· 8 years ago · Dec 07, 2017, 12:20 AM
1--
2-- Table structure for table `mayorresults`
3--
4
5CREATE TABLE IF NOT EXISTS `mayorresults` (
6 `id` int(11) NOT NULL AUTO_INCREMENT,
7 `county_id` int(11) DEFAULT NULL,
8 `district_id` int(11) DEFAULT NULL,
9 `zaz_id` int(11) DEFAULT NULL,
10 `local_unit_id` varchar(11) DEFAULT NULL,
11 `QV` varchar(11) DEFAULT NULL,
12 `all_voters` int(11) DEFAULT NULL,
13 `unused_ballots` int(11) DEFAULT NULL,
14 `damaged_ballots` int(11) DEFAULT NULL,
15 `ballots_found_in_box` int(11) DEFAULT NULL,
16 `valid_votes` int(11) DEFAULT NULL,
17 `invalid_votes` int(11) DEFAULT NULL,
18 `mayor_id` int(11) DEFAULT NULL,
19 `votes` int(11) DEFAULT NULL,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12317 ;
22
23--
24-- Dumping data for table `mayorresults`
25--
26
27INSERT INTO `mayorresults` (`id`, `county_id`, `district_id`, `zaz_id`, `local_unit_id`, `QV`, `all_voters`, `unused_ballots`, `damaged_ballots`, `ballots_found_in_box`, `valid_votes`, `invalid_votes`, `mayor_id`, `votes`) VALUES
28(1, 12, 1, 1, '1', '32681', 233, 340, 0, 233, 227, 6, 1, 114),
29(2, 12, 1, 1, '1', '32681', 233, 340, 0, 233, 227, 6, 374, 113),
30(3, 12, 1, 1, '1', '32691', 226, 261, 4, 226, 214, 12, 1, 99),
31(4, 12, 1, 1, '1', '32691', 226, 261, 4, 226, 214, 12, 374, 115),
32(5, 12, 1, 1, '1', '3269', 241, 315, 3, 241, 235, 6, 1, 104),
33(6, 12, 1, 1, '1', '3269', 241, 315, 3, 241, 235, 6, 374, 131),
34(7, 12, 1, 1, '1', '3270', 294, 512, 0, 294, 283, 11, 1, 156),
35(8, 12, 1, 1, '1', '3270', 294, 512, 0, 294, 283, 11, 374, 127),
36(9, 12, 1, 1, '1', '32701', 244, 403, 0, 244, 234, 10, 1, 134),
37(10, 12, 1, 1, '1', '32701', 244, 403, 0, 244, 234, 10, 374, 100),
38(11, 12, 1, 1, '1', '3271', 192, 253, 0, 192, 185, 7, 1, 89),
39(12, 12, 1, 1, '1', '3271', 192, 253, 0, 192, 185, 7, 374, 96),
40(478, 9, 22, 35, '256', '0541', 468, 227, 21, 468, 454, 14, 136, 153),
41(479, 9, 22, 35, '256', '0541', 468, 227, 21, 468, 454, 14, 626, 301),
42(480, 9, 22, 35, '256', '0542', 39, 33, 0, 39, 39, 0, 136, 6),
43(481, 9, 22, 35, '256', '0542', 39, 33, 0, 39, 39, 0, 626, 33),
44(482, 9, 22, 35, '256', '0543', 293, 296, 4, 293, 286, 7, 136, 131),
45(483, 9, 22, 35, '256', '0543', 293, 296, 4, 293, 286, 7, 626, 155),
46(484, 9, 22, 35, '256', '0544', 135, 61, 4, 135, 132, 3, 136, 48),
47(485, 9, 22, 35, '256', '0544', 135, 61, 4, 135, 132, 3, 626, 84),
48(486, 9, 22, 35, '256', '0545', 137, 77, 4, 137, 134, 3, 136, 68),
49(487, 9, 22, 35, '256', '0545', 137, 77, 4, 137, 134, 3, 626, 66),
50(488, 8, 19, 33, '235', '3999', 152, 96, 1, 152, 150, 2, 227, 86),
51(489, 8, 19, 33, '235', '3999', 152, 96, 1, 152, 150, 2, 605, 64),
52(490, 12, 36, 3, '13', '3518', 404, 619, 1, 404, 399, 5, 30, 208),
53(491, 12, 36, 3, '13', '3518', 404, 619, 1, 404, 399, 5, 386, 191),
54(492, 12, 1, 2, '6', '3433', 76, 85, 1, 76, 76, 0, 241, 63),
55(493, 12, 1, 2, '6', '3433', 76, 85, 1, 76, 76, 0, 379, 13),
56(494, 9, 22, 35, '256', '0546', 388, 192, 5, 388, 381, 7, 136, 191),
57(495, 9, 22, 35, '256', '0546', 388, 192, 5, 388, 381, 7, 626, 190);