-- Database Election
DROP DATABASE IF EXISTS Election;
CREATE DATABASE Election;
USE Election;

-- Table Member
CREATE TABLE Member
(   
    mid INT PRIMARY KEY,
    firstName VARCHAR(30) NOT NULL,
    lastName VARCHAR(60) NOT NULL,
    pass CHAR(12) NOT NULL,
    email VARCHAR(100)
);

INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(1,'Ann','Anson','aa01119','aanson@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(2,'Ben','Jamin','bj11122','bjamin@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(3,'Cir','Cus','cc22211','ccus@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(4,'Don','Donski','dd00413','ddonski@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(5,'Eve','Lady','el98765','elady@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(6,'Fin','End','fe00011','fend@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(7,'Gin','Rum','gr12345','grum@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(8,'Hal','Bar','hb01011','hbar@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(9,'Ian','Yan','iy99900','iyan@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(10,'Jan','Osik','jo33322','josik@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(11,'Kim','Novak','kn23230','knovak@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(12,'Lue','Vre','lv88877','lvre@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(13,'Mac','Intosh','mi77788','mintosh@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(14,'Ned','Ross','nr66677','nross@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(15,'Ore','Gon','og33344','ogon@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(16,'Pat','Terson','pt22233','pterson@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(17,'Que','Book','qb11122','qbook@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(18,'Ron','Reg','rg88822','rreg@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(19,'Sue','Bee','sb77722','sbee@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(20,'Tom','Kruse','tk33388','tkruse@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(21,'Ula','Micka','um66633','umicka@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(22,'Vin','Cent','cv00001','vcent@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(23,'Wow','Great','wg11110','wgreat@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(24,'Xer','Xes','xx12345','xxes@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(25,'Yul','Ek','ye55555','yek@wnec.edu');
INSERT INTO Member(mid,firstName,lastName,pass,email) VALUES(26,'Zim','Aaa','za77777','zaaa@wnec.edu');

-- Table Office
CREATE TABLE Office
(   
    oid INT PRIMARY KEY,
    title varchar(50) NOT NULL
);

INSERT INTO Office(oid,title) VALUES(1,'President');
INSERT INTO Office(oid,title) VALUES(2,'Vice-President');
INSERT INTO Office(oid,title) VALUES(3,'Treasurer');
INSERT INTO Office(oid,title) VALUES(4,'Editor');

-- Table Candidate
CREATE TABLE Candidate
(   
    mid int PRIMARY KEY,
    oid int NOT NULL,
    FOREIGN KEY (mid) REFERENCES Member(mid),
    FOREIGN KEY (oid) REFERENCES Office(oid)
);
INSERT INTO Candidate(mid,oid) VALUES(3,1);
INSERT INTO Candidate(mid,oid) VALUES(13,1);
INSERT INTO Candidate(mid,oid) VALUES(22,1);
INSERT INTO Candidate(mid,oid) VALUES(4,2);
INSERT INTO Candidate(mid,oid) VALUES(10,2);
INSERT INTO Candidate(mid,oid) VALUES(15,2);
INSERT INTO Candidate(mid,oid) VALUES(24,2);
INSERT INTO Candidate(mid,oid) VALUES(8,3);
INSERT INTO Candidate(mid,oid) VALUES(9,3);
INSERT INTO Candidate(mid,oid) VALUES(12,3);
INSERT INTO Candidate(mid,oid) VALUES(1,4);
INSERT INTO Candidate(mid,oid) VALUES(7,4);
INSERT INTO Candidate(mid,oid) VALUES(20,4);
INSERT INTO Candidate(mid,oid) VALUES(21,4);
INSERT INTO Candidate(mid,oid) VALUES(23,4);
INSERT INTO Candidate(mid,oid) VALUES(25,4);

-- Table Ballot
CREATE TABLE Ballot
(   
    mid int NOT NULL,
    oid int NOT NULL,
    ballotPickupTime DATETIME, 
    PRIMARY KEY(mid,oid),
    FOREIGN KEY (mid) REFERENCES Member(mid),
    FOREIGN KEY (oid) REFERENCES Office(oid)    
);

INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(2,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(4,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(5,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(6,1,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(7,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(8,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(9,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(11,1,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(12,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(13,1,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(14,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(15,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(16,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(17,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(18,1,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(19,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(20,1,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(21,1,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(22,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(23,1,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(24,1,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(25,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(26,1,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(1,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(2,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(3,2,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(4,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(5,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(6,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(7,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(8,2,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(9,2,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(10,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(11,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(12,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(13,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(14,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(15,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(16,2,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(17,2,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(18,2,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(19,2,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(20,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(21,2,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(22,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(23,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(24,2,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(25,2,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(26,2,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(1,3,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(2,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(3,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(4,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(5,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(6,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(7,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(8,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(9,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(10,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(11,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(12,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(13,3,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(14,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(15,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(16,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(17,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(18,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(19,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(20,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(21,3,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(22,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(23,3,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(24,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(25,3,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(26,3,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(1,4,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(2,4,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(3,4,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(4,4,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(5,4,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(6,4,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(7,4,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(8,4,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(9,4,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(10,4,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(11,4,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(12,4,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(13,4,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(14,4,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(15,4,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(16,4,'2009-09-29 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(17,4,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(18,4,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(19,4,'2009-09-28 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(20,4,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(21,4,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(22,4,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(23,4,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(24,4,'2009-10-01 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(25,4,'2009-09-30 22:51');
INSERT INTO Ballot(mid,oid,ballotPickupTime) VALUES(26,4,'2009-10-01 22:51');

-- Table Vote
CREATE TABLE Vote
(   
    id INT PRIMARY KEY AUTO_INCREMENT,
    mid INT NOT NULL,
    voteTime DATETIME NOT NULL,
    FOREIGN KEY (mid) REFERENCES Candidate(mid)
);

INSERT INTO Vote(id,mid,voteTime) VALUES(1,7,'2009-09-30 01:31');
INSERT INTO Vote(id,mid,voteTime) VALUES(2,21,'2009-09-29 23:45');
INSERT INTO Vote(id,mid,voteTime) VALUES(3,4,'2009-10-02 03:42');
INSERT INTO Vote(id,mid,voteTime) VALUES(4,15,'2009-10-02 01:25');
INSERT INTO Vote(id,mid,voteTime) VALUES(5,9,'2009-09-29 23:54');
INSERT INTO Vote(id,mid,voteTime) VALUES(6,7,'2009-09-29 00:23');
INSERT INTO Vote(id,mid,voteTime) VALUES(7,12,'2009-09-30 00:15');
INSERT INTO Vote(id,mid,voteTime) VALUES(8,12,'2009-09-30 01:35');
INSERT INTO Vote(id,mid,voteTime) VALUES(9,15,'2009-09-29 00:13');
INSERT INTO Vote(id,mid,voteTime) VALUES(10,3,'2009-09-28 23:02');
INSERT INTO Vote(id,mid,voteTime) VALUES(11,25,'2009-10-01 02:32');
INSERT INTO Vote(id,mid,voteTime) VALUES(12,23,'2009-09-29 02:06');
INSERT INTO Vote(id,mid,voteTime) VALUES(13,12,'2009-10-01 00:13');
INSERT INTO Vote(id,mid,voteTime) VALUES(14,9,'2009-09-29 23:27');
INSERT INTO Vote(id,mid,voteTime) VALUES(15,22,'2009-09-29 02:50');
INSERT INTO Vote(id,mid,voteTime) VALUES(16,3,'2009-09-29 01:16');
INSERT INTO Vote(id,mid,voteTime) VALUES(17,15,'2009-10-01 03:11');
INSERT INTO Vote(id,mid,voteTime) VALUES(18,3,'2009-09-29 02:30');
INSERT INTO Vote(id,mid,voteTime) VALUES(19,10,'2009-10-01 23:24');
INSERT INTO Vote(id,mid,voteTime) VALUES(20,10,'2009-10-01 02:02');
INSERT INTO Vote(id,mid,voteTime) VALUES(21,25,'2009-09-29 03:21');
INSERT INTO Vote(id,mid,voteTime) VALUES(22,3,'2009-09-30 03:28');
INSERT INTO Vote(id,mid,voteTime) VALUES(23,9,'2009-10-01 23:08');
INSERT INTO Vote(id,mid,voteTime) VALUES(24,15,'2009-10-01 01:16');
INSERT INTO Vote(id,mid,voteTime) VALUES(25,15,'2009-09-28 23:48');
INSERT INTO Vote(id,mid,voteTime) VALUES(26,3,'2009-10-01 02:29');
INSERT INTO Vote(id,mid,voteTime) VALUES(27,3,'2009-09-30 02:04');
INSERT INTO Vote(id,mid,voteTime) VALUES(28,22,'2009-10-02 02:42');
INSERT INTO Vote(id,mid,voteTime) VALUES(29,25,'2009-10-02 02:03');
INSERT INTO Vote(id,mid,voteTime) VALUES(30,10,'2009-09-29 01:57');
INSERT INTO Vote(id,mid,voteTime) VALUES(31,10,'2009-10-01 01:22');
INSERT INTO Vote(id,mid,voteTime) VALUES(32,15,'2009-10-02 01:43');
INSERT INTO Vote(id,mid,voteTime) VALUES(33,20,'2009-09-29 02:23');
INSERT INTO Vote(id,mid,voteTime) VALUES(34,4,'2009-10-02 02:40');
INSERT INTO Vote(id,mid,voteTime) VALUES(35,12,'2009-09-30 23:36');
INSERT INTO Vote(id,mid,voteTime) VALUES(36,9,'2009-10-01 23:28');
INSERT INTO Vote(id,mid,voteTime) VALUES(37,9,'2009-10-01 02:40');
INSERT INTO Vote(id,mid,voteTime) VALUES(38,8,'2009-09-30 02:59');
INSERT INTO Vote(id,mid,voteTime) VALUES(39,25,'2009-10-01 02:23');
INSERT INTO Vote(id,mid,voteTime) VALUES(40,12,'2009-10-01 23:38');
INSERT INTO Vote(id,mid,voteTime) VALUES(41,22,'2009-09-30 03:25');
INSERT INTO Vote(id,mid,voteTime) VALUES(42,10,'2009-09-30 00:36');
INSERT INTO Vote(id,mid,voteTime) VALUES(43,1,'2009-10-02 03:05');
INSERT INTO Vote(id,mid,voteTime) VALUES(44,8,'2009-10-02 00:31');
INSERT INTO Vote(id,mid,voteTime) VALUES(45,25,'2009-09-30 00:41');
INSERT INTO Vote(id,mid,voteTime) VALUES(46,25,'2009-09-29 02:47');
INSERT INTO Vote(id,mid,voteTime) VALUES(47,12,'2009-10-01 01:40');
INSERT INTO Vote(id,mid,voteTime) VALUES(48,12,'2009-09-29 23:16');
INSERT INTO Vote(id,mid,voteTime) VALUES(49,21,'2009-10-01 00:29');
INSERT INTO Vote(id,mid,voteTime) VALUES(50,20,'2009-10-02 01:09');
INSERT INTO Vote(id,mid,voteTime) VALUES(51,13,'2009-09-30 00:37');
INSERT INTO Vote(id,mid,voteTime) VALUES(52,13,'2009-09-30 23:27');
INSERT INTO Vote(id,mid,voteTime) VALUES(53,15,'2009-10-01 01:34');
INSERT INTO Vote(id,mid,voteTime) VALUES(54,4,'2009-10-01 23:28');
INSERT INTO Vote(id,mid,voteTime) VALUES(55,3,'2009-10-01 03:10');
INSERT INTO Vote(id,mid,voteTime) VALUES(56,23,'2009-09-30 01:15');
INSERT INTO Vote(id,mid,voteTime) VALUES(57,10,'2009-09-28 22:56');
INSERT INTO Vote(id,mid,voteTime) VALUES(58,13,'2009-09-30 23:22');
INSERT INTO Vote(id,mid,voteTime) VALUES(59,9,'2009-10-01 03:12');
INSERT INTO Vote(id,mid,voteTime) VALUES(60,1,'2009-09-29 00:56');
INSERT INTO Vote(id,mid,voteTime) VALUES(61,8,'2009-09-29 03:11');
INSERT INTO Vote(id,mid,voteTime) VALUES(62,10,'2009-09-30 23:03');
INSERT INTO Vote(id,mid,voteTime) VALUES(63,21,'2009-10-02 02:34');
INSERT INTO Vote(id,mid,voteTime) VALUES(64,3,'2009-09-29 00:52');
INSERT INTO Vote(id,mid,voteTime) VALUES(65,12,'2009-09-30 02:43');
INSERT INTO Vote(id,mid,voteTime) VALUES(66,15,'2009-09-29 03:20');
INSERT INTO Vote(id,mid,voteTime) VALUES(67,20,'2009-09-29 02:24');
INSERT INTO Vote(id,mid,voteTime) VALUES(68,9,'2009-09-30 03:20');
INSERT INTO Vote(id,mid,voteTime) VALUES(69,8,'2009-10-02 00:57');
INSERT INTO Vote(id,mid,voteTime) VALUES(70,8,'2009-09-30 03:20');
INSERT INTO Vote(id,mid,voteTime) VALUES(71,3,'2009-10-02 02:29');
INSERT INTO Vote(id,mid,voteTime) VALUES(72,12,'2009-09-30 03:09');
INSERT INTO Vote(id,mid,voteTime) VALUES(73,3,'2009-09-30 00:10');
INSERT INTO Vote(id,mid,voteTime) VALUES(74,10,'2009-09-29 00:44');
INSERT INTO Vote(id,mid,voteTime) VALUES(75,10,'2009-09-29 23:52');
INSERT INTO Vote(id,mid,voteTime) VALUES(76,23,'2009-10-02 03:23');
INSERT INTO Vote(id,mid,voteTime) VALUES(77,9,'2009-09-30 01:00');
INSERT INTO Vote(id,mid,voteTime) VALUES(78,10,'2009-10-02 03:41');
INSERT INTO Vote(id,mid,voteTime) VALUES(79,1,'2009-10-02 01:38');
INSERT INTO Vote(id,mid,voteTime) VALUES(80,7,'2009-09-30 02:10');
INSERT INTO Vote(id,mid,voteTime) VALUES(81,20,'2009-10-01 01:26');
INSERT INTO Vote(id,mid,voteTime) VALUES(82,22,'2009-10-01 00:27');
INSERT INTO Vote(id,mid,voteTime) VALUES(83,8,'2009-10-02 01:09');
INSERT INTO Vote(id,mid,voteTime) VALUES(84,3,'2009-09-29 02:05');
INSERT INTO Vote(id,mid,voteTime) VALUES(85,4,'2009-10-02 02:17');
INSERT INTO Vote(id,mid,voteTime) VALUES(86,4,'2009-09-30 01:43');
INSERT INTO Vote(id,mid,voteTime) VALUES(87,22,'2009-09-30 03:36');
INSERT INTO Vote(id,mid,voteTime) VALUES(88,12,'2009-10-02 03:20');
INSERT INTO Vote(id,mid,voteTime) VALUES(89,8,'2009-09-28 23:10');
INSERT INTO Vote(id,mid,voteTime) VALUES(90,10,'2009-09-29 00:32');
INSERT INTO Vote(id,mid,voteTime) VALUES(91,13,'2009-09-30 23:43');
INSERT INTO Vote(id,mid,voteTime) VALUES(92,1,'2009-09-30 03:11');
INSERT INTO Vote(id,mid,voteTime) VALUES(93,22,'2009-09-29 02:13');
INSERT INTO Vote(id,mid,voteTime) VALUES(94,15,'2009-09-30 02:54');
INSERT INTO Vote(id,mid,voteTime) VALUES(95,22,'2009-10-01 01:06');
INSERT INTO Vote(id,mid,voteTime) VALUES(96,21,'2009-10-02 01:06');
INSERT INTO Vote(id,mid,voteTime) VALUES(97,25,'2009-09-29 01:23');
INSERT INTO Vote(id,mid,voteTime) VALUES(98,3,'2009-10-01 01:22');
INSERT INTO Vote(id,mid,voteTime) VALUES(99,25,'2009-09-30 01:48');
INSERT INTO Vote(id,mid,voteTime) VALUES(100,9,'2009-09-30 01:19');
INSERT INTO Vote(id,mid,voteTime) VALUES(101,10,'2009-10-02 02:14');