   `vote_id` int(11) NOT NULL,
   `vote` text NOT NULL,
   `votation_id` int(11) NOT NULL,
-  `latitud` double NOT NULL,
-  `longitud` double NOT NULL,
+  `cod_pos` int(6) NOT NULL,
   PRIMARY KEY (vote_id),
   FOREIGN KEY (votation_id) 
         REFERENCES Votacion(votacion_id)

CREATE PROCEDURE InsertarVoto
(
	IN votacionName VARCHAR(100), 
	IN voto VARCHAR(100), 
	IN latitud double, 
	IN longitud double
)
BEGIN
	DECLARE votacionId INT;

	SELECT votacion_id INTO votacionId FROM `Votacion` WHERE name like votacionName;
		
	SELECT COUNT(*)+1 INTO votId1 FROM Votes;
	INSERT INTO Votes values(votId1, voto, votacionId, codPos);
    
END
//
