-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathsample_data.sql
More file actions
53 lines (53 loc) · 9.64 KB
/
sample_data.sql
File metadata and controls
53 lines (53 loc) · 9.64 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
insert into ADMIN(id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (890000,"Rodney", "Mwanje", "Luguyesi", "Likuyani", "Okelo", "rodney002mwanje@gmail.com");
insert into ADMIN(id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (890001,"Beldine", "Moturi", "Bella", "Longonot", "Royco", "beldine001moturi@gmail.com");
insert into ADMIN (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (890002,"Shaun", "Mak", "King", "Lagos", "OneSoftware", "pyBaker003@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (823001,"Jessica", "Gatura", "Nzembi", "Kileleshwa", "catnoir", "jessnzembi@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (823002,"Richard", "Shigali", "Luguyesi", "Narok", "family", "shigalison@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (823003,"Alvin", "Obuya", "", "Kisumu", "chemistry", "alvinobuya@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (824004,"Carlyn", "Kenyan", "", "Kitale", "munene", "carlynkenyan@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (827005,"Cuthbert", "Rehema", "Beautiful", "paris", "lovebrain", "cuthrehema@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (824006,"Gift", "Oroko", "Alenga", "Kitale", "riara", "giftAlenga@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (878607,"Dreyfuss", "Diego", "Shigali", "Soy", "games", "DreyDiego@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893008,"Zelipha", "Wambui", "Wamboi", "Wamboi", "thehero", "wambuiZelipha@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893009,"Stallone", "Mecha", "Papa", "Nyeri", "lovetolose", "papaMecha@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893010,"Nile", "Okomo", "Otieno", "Kilo", "luckstrike", "okomoNile@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893011,"Milly", "makori", "Mildred", "Kitengela", "motivator", "MillyMakori@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893012,"Benjamin", "WaMombasa", "Nze", "WhiteHouse", "minutes", "BenjaMombasa@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893013,"Mwake", "Kitolo", "Nze", "Turkana", "amrocking", "mwakeKitololo@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893014,"Bonface", "Orina", "Kingwa", "Naivasha", "dropme", "bonfaceOrina@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893015,"Gabriel", "Gabu", "Chebet", "Nakuru", "keepmeup", "gabrielGabu@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893026,"Levvy", "Kiptoo", "Kipchoge", "Nakuru", "quenchit", "levvyKiptoo@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893027,"Joshua", "Aaron", "Temoi", "Kileleshwa", "liveit", "joshuaAaron@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (823054, "Antony", "Ezekiel", "Kilombwa", "Narok", "dontback", "antoEze@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893031, "Jane", "Ndinda", "Kilwa", "Kileleshwa", "catnoir", "janendinda@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893032, "Fred", "Ongere", "Wanzio", "Soy", "catnoir", "fredongere@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893033, "Barry", "Allan", "hamaka", "Matunda", "catnoir", "barryallan@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893034, "Betty", "Odera", "Hilder", "Seregeya", "catnoir", "killerfrost@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893035, "Killer", "Frost", "Otieno", "Nakuru", "catnoir", "bettyodera@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893036, "Katrina", "Kioko", "Wamburu", "Kileleshwa", "catnoir", "katkioko@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893037, "Johnson", "Sakaja", "Kitongwe", "Kileleshwa", "catnoir", "sakajajohnson@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893038, "Mary", "Wawira", "Ajab", "Kileleshwa", "catnoir", "marywawira@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893039, "Emu", "Ndegwa", "Mzito", "Kitale", "catnoir", "emundengwa@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893040, "Melvin", "Mwatibo", "Kitololo", "Kitale", "catnoir", "malvinmwatibo@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893041, "John", "Orina", "Malonza", "Masinde", "catnoir", "johnmalonza@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893042, "Kijana", " Wamalwa", "Henry", "Ukombozi", "catnoir", "kijanawamalwa@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893043, "John", "Gichuki", "Agabus", "Kapenguria", "catnoir", "gichukijohn@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (893044, "Derrick", "Kiptum", "Kipsang", "Kijasho", "catnoir", "kiptumderrick@gmail.com");
insert into REGISTERED_VOTERS (id, First_Name, Middle_Name, Last_Name, Location, Password, Email) VALUES (8930045, "Joash", "Kipchumba", "Kipkorir", "Kileleshwa", "catnoir", "kiptumjoash@gmail.com");
insert into POST (Post_Name) VALUES ("President"), ("Senator"), ("Governor"), ("MP");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (823002,"President", "Richard", "Shigali", "Luguyesi", "Narok", "shigalison@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893031,"Governor", "Jane", "Ndinda", "Kilwa", "Kileleshwa", "janendinda@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893032,"President", "Fred", "Ongere", "Wanzio", "Soy", "fredongere@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893033,"President", "Barry", "Allan", "hamaka", "Matunda","barryallan@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893034,"President", "Betty", "Odera", "Hilder", "Seregeya", "killerfrost@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893035,"Governor", "Killer", "Frost", "Otieno", "Nakuru","bettyodera@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893036,"Governor", "Katrina", "Kioko", "Wamburu", "Kileleshwa", "katkioko@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893037,"Governor", "Johnson", "Sakaja", "Kitongwe", "Kileleshwa", "sakajajohnson@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893038,"Senator", "Mary", "Wawira", "Ajab", "Kileleshwa", "marywawira@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893039,"Senator", "Emu", "Ndegwa", "Mzito", "Kitale", "emundengwa@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893040,"Senator", "Melvin", "Mwatibo", "Kitololo", "Kitale", "malvinmwatibo@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893041,"Senator", "John", "Orina", "Malonza", "Masinde", "johnmalonza@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893042,"MP", "Kijana", " Wamalwa", "Henry", "Ukombozi", "kijanawamalwa@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893043,"MP", "John", "Gichuki", "Agabus", "Kapenguria", "gichukijohn@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (893044,"MP", "Derrick", "Kiptum", "Kipsang", "Kijasho", "kiptumderrick@gmail.com");
insert into ASPIRANTS (id, post_name, First_Name, Middle_Name, Last_Name, Location, Email) VALUES (8930045,"MP", "Joash", "Kipchumba", "Kipkorir", "Kileleshwa", "kiptumjoash@gmail.com");