uMKmZ62b

1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Dec 14, 2016 at 09:57 AM
7-- Server version: 5.6.33
8-- PHP Version: 7.0.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `main`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `age`
21--
22
23DROP TABLE IF EXISTS `age`;
24CREATE TABLE `age` (
25  `id` int(10) UNSIGNED NOT NULL,
26  `key` varchar(25) NOT NULL,
27  `value` varchar(255) NOT NULL,
28  `order` int(11) DEFAULT '0'
29) ENGINE=InnoDB DEFAULT CHARSET=utf8;
30
31--
32-- Dumping data for table `age`
33--
34
35INSERT INTO `age` (`id`, `key`, `value`, `order`) VALUES
36(1, '18-', 'tot 18 jaar', 0),
37(2, '18-24', '18 tot 24 jaar', 0),
38(3, '25-34', '25 tot 34 jaar', 0),
39(4, '35-44', '35 tot 44 jaar', 0),
40(5, '45-54', '45 tot 54 jaar', 0),
41(6, '55-64', '55 tot 64 jaar', 0),
42(7, '65+', '65 of ouder', 0);
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `answer`
48--
49
50DROP TABLE IF EXISTS `answer`;
51CREATE TABLE `answer` (
52  `id` int(11) NOT NULL,
53  `questionId` int(11) NOT NULL,
54  `userId` int(10) UNSIGNED NOT NULL,
55  `answer` mediumtext NOT NULL,
56  `upvoted` int(11) DEFAULT '0',
57  `downvoted` int(11) DEFAULT '0',
58  `shared` int(11) DEFAULT '0',
59  `reported` int(11) DEFAULT '0',
60  `correct` tinyint(1) DEFAULT '0',
61  `dateCreated` datetime NOT NULL
62) ENGINE=InnoDB DEFAULT CHARSET=utf8;
63
64--
65-- Dumping data for table `answer`
66--
67
68INSERT INTO `answer` (`id`, `questionId`, `userId`, `answer`, `upvoted`, `downvoted`, `shared`, `reported`, `correct`, `dateCreated`) VALUES
69(1, 8, 1, 'Ik vind het erg vervelend voor de journalisten, maar in andere landen worden andere regels gehanteerd dus eigen schuld dikke bult', 18, 0, 0, 0, 0, '2016-12-13 10:15:18'),
70(2, 8, 5, 'De bedrijven waarvoor de journalisten werken zullen aansprakelijk moeten zijn, dan zullen ze er wel wat aan doen om ervoor te zorgen dat minder journalisten vast komen te zitten.', 4, 0, 0, 100, 0, '2016-12-13 10:37:00'),
71(3, 8, 6, 'Journalisten moeten gewoon wat beter op hun tellen passen!', 2, 0, 0, 670, 0, '2016-12-13 11:28:38'),
72(4, 11, 5, '‘Verdovende middelen en middelen met psychische uitwerking’ mogen nooit per post worden verstuurd. Deze kan men alleen persoonlijk meenemen naar het buitenland met een doktersverklaring voor eigen gebruik. "De Opiumwet bevat een lijst van soft- en harddrugs die je niet in je bezit mag hebben. Ook in veel medicijnen zitten stoffen die onder de Opiumwet vallen, zoals in sterke pijnstillers, rustgevende middelen, ADHD-medicatie en medicinale cannabis. Medisch gebruik is toegestaan, maar als je zulke medicijnen mee wilt nemen naar het buitenland, heb je een officiële verklaring van je arts nodig dat je ze op doktersvoorschrift gebruikt. Met zo’n verklaring toon je aan dat je de medicatie voor eigen gebruik meeneemt.\nDe meest voorkomende opiumwetmiddelen zijn:\nStofnaam - Merknaam Methylfenidaat - Ritalin, Concerta, Medikinet \nMorfine - Kapanol, Oramorph\nOxycodon - Oxycontin, Oxynorm\nMethadon - Symoron, Pindadone\nTemazepam - Normisom\nOxazepam - Seresta" Medicijnen die in Frankrijk niet onder de opiumwet vallen, zijn ter plekke in een apotheek verkrijgbaar.', 21, 0, 0, 0, 1, '2016-12-13 13:00:00'),
73(5, 11, 2, 'Je zult een medische verklaring bij moeten voegen, of douanepapieren. Misschien allebei. Vraag het na bij douane of post', 4, 0, 0, 0, 0, '2016-12-13 09:17:00'),
74(6, 9, 2, 'ISIS moet bestreden worden. ISIS heeft zich laten kennen als een opponent die niet terugdeinst, geduchte tegenstand biedt, haar strategie en tactieken gedurende de strijd permanent aanpast, over een internationaal netwerk beschikt en gebruik maakt van moderne middelen waaronder het internet. Door openbaarmaking van informatie kan de veiligheid geschaad worden. De bestrijding van ISIS doen we met een grote coalitie van landen. Centcom (VS) heeft de leiding over deze operatie en maakt namens de coalitie informatie beschikbaar. Individuele landen maken een eigen afweging over hun inzet. Informatie over specifieke aanvallen of doelen, in dit geval Nederland, vergroot risico’s en gevaar voor de Nederlandse militairen en de Nederlandse samenleving (nationale veiligheid). Dat moet worden voorkomen.', 11, 0, 0, 120, 0, '2016-12-13 17:28:18'),
75(7, 9, 6, 'Ze moeten ophouden alles te bombarderen, het maakt het alleen maar erger. Ze kunnen beter geld gebruiken voor het zoeken van een andere oplossing als je het mij vraagt. Een andere oplossing is echter ook erg moeilijk.', 0, 0, 0, 0, 0, '2016-12-13 23:16:45'),
76(8, 9, 7, 'Wat een stomme vraag.. ', 1, 0, 0, 1800, 0, '2016-12-13 21:19:10');
77
78-- --------------------------------------------------------
79
80--
81-- Table structure for table `answerMedium`
82--
83
84DROP TABLE IF EXISTS `answerMedium`;
85CREATE TABLE `answerMedium` (
86  `id` int(10) UNSIGNED NOT NULL,
87  `answerId` int(10) UNSIGNED NOT NULL,
88  `mediumTypeId` int(10) UNSIGNED NOT NULL,
89  `title` varchar(255) NOT NULL,
90  `url` varchar(255) NOT NULL
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92
93-- --------------------------------------------------------
94
95--
96-- Table structure for table `city`
97--
98
99DROP TABLE IF EXISTS `city`;
100CREATE TABLE `city` (
101  `id` int(10) UNSIGNED NOT NULL,
102  `municipalityId` int(10) UNSIGNED NOT NULL,
103  `name` varchar(255) NOT NULL,
104  `img` varchar(255) DEFAULT NULL
105) ENGINE=InnoDB DEFAULT CHARSET=utf8;
106
107--
108-- Dumping data for table `city`
109--
110
111INSERT INTO `city` (`id`, `municipalityId`, `name`, `img`) VALUES
112(1, 1, 'Schoonloo', NULL),
113(2, 1, 'Grolloo', NULL),
114(3, 1, 'Vredenheim', NULL),
115(4, 1, 'Amen', NULL),
116(5, 1, 'Papenvoort', NULL),
117(6, 1, 'Marwijksoord', NULL),
118(7, 1, 'Nooitgedacht', NULL),
119(8, 1, 'Rolde', NULL),
120(9, 1, 'Nijlande', NULL),
121(10, 1, 'Eldersloo', NULL),
122(11, 1, 'Ekehaar', NULL),
123(12, 1, 'Geelbroek', NULL),
124(13, 1, 'Eleveld', NULL),
125(14, 1, 'Deurze', NULL),
126(15, 1, 'Balloo', NULL),
127(16, 1, 'Balloerveld', NULL),
128(17, 1, 'Gieten', NULL),
129(18, 1, 'Gasselte', NULL),
130(19, 1, 'Eext', NULL),
131(20, 1, 'Eexterzandvoort', NULL),
132(21, 1, 'Anderen', NULL),
133(22, 1, 'Gasteren', NULL),
134(23, 1, 'Anloo', NULL),
135(24, 1, 'Annen', NULL),
136(25, 1, 'Schipborg', NULL),
137(26, 1, 'Gieterveen', NULL),
138(27, 1, 'Nieuwediep', NULL),
139(28, 1, 'Gasselternijveen', NULL),
140(29, 1, 'Gasselternijveenschemond', NULL),
141(30, 1, 'Annerveensche Kan', NULL),
142(31, 1, 'Oud Annerveen', NULL),
143(32, 1, 'Spijkerboor (DR)', NULL),
144(33, 1, 'Nieuw Annerveen', NULL),
145(34, 1, 'Eexterveen', NULL),
146(35, 1, 'Eexterveensche Kan', NULL),
147(36, 2, 'Wijk en Aalburg', NULL),
148(37, 2, 'Veen', NULL),
149(38, 2, 'Genderen', NULL),
150(39, 2, 'Eethen', NULL),
151(40, 2, 'Drongelen', NULL),
152(41, 2, 'Meeuwen', NULL),
153(42, 2, 'Babylonienbroek', NULL),
154(43, 3, 'Aalsmeer', NULL),
155(44, 3, 'Kudelstaart', NULL),
156(45, 4, 'Dinxperlo', NULL),
157(46, 4, 'De Heurne', NULL),
158(47, 4, 'Aalten', NULL),
159(48, 4, 'Heurne', NULL),
160(49, 4, 'Bredevoort', NULL),
161(50, 5, 'Abcoude', NULL),
162(51, 5, 'Baambrugge', NULL),
163(52, 6, 'Surhuisterveen', NULL),
164(53, 6, 'Boelenslaan', NULL),
165(54, 6, 'Harkema', NULL),
166(55, 6, 'Surhuizum', NULL),
167(56, 6, 'Augustinusga', NULL),
168(57, 6, 'Buitenpost', NULL),
169(58, 6, 'Twijzel', NULL),
170(59, 6, 'Twijzelerheide', NULL),
171(60, 6, 'Kootstertille', NULL),
172(61, 6, 'Drogeham', NULL),
173(62, 6, 'Stroobos', NULL),
174(63, 6, 'Gerkesklooster', NULL),
175(64, 7, 'Alblasserdam', NULL),
176(65, 8, 'Rhoon', NULL),
177(66, 8, 'Rotterdam Albrandswaard', NULL),
178(67, 8, 'Poortugaal', NULL),
179(68, 9, 'Kaag', NULL),
180(69, 9, 'Roelofarendsveen', NULL),
181(70, 9, 'Oud Ade', NULL),
182(71, 9, 'Rijpwetering', NULL),
183(72, 9, 'Nieuwe Wetering', NULL),
184(73, 9, 'Oude Wetering', NULL),
185(74, 10, 'Alkmaar', NULL),
186(75, 10, 'Oudorp (NH)', NULL),
187(76, 10, 'Koedijk', NULL),
188(77, 11, 'Almelo', NULL),
189(78, 11, 'Aadorp', NULL),
190(79, 11, 'Bornerbroek', NULL),
191(80, 12, 'Almere', NULL),
192(81, 13, 'Alphen aan den Rijn', NULL),
193(82, 13, 'Aarlanderveen', NULL),
194(83, 13, 'Zwammerdam', NULL),
195(84, 14, 'Galder', NULL),
196(85, 14, 'Strijbeek', NULL),
197(86, 14, 'Ulvenhout Ac', NULL),
198(87, 14, 'Bavel Ac', NULL),
199(88, 14, 'Chaam', NULL),
200(89, 14, 'Alphen (NB)', NULL),
201(90, 15, 'Posterholt', NULL),
202(91, 15, 'Montfort', NULL),
203(92, 15, 'Sint Odilienberg', NULL),
204(93, 16, 'Hollum', NULL),
205(94, 16, 'Ballum', NULL),
206(95, 16, 'Nes Ameland', NULL),
207(96, 16, 'Buren (FRL)', NULL),
208(97, 17, 'Amersfoort', NULL),
209(98, 17, 'Hoogland', NULL),
210(99, 17, 'Hooglanderveen', NULL),
211(100, 17, 'Stoutenburg Noord', NULL),
212(101, 18, 'Amstelveen', NULL),
213(102, 19, 'Amsterdam', NULL),
214(103, 19, 'Amsterdam Zuidoost', NULL),
215(104, 20, 'Andijk', NULL),
216(105, 21, 'Anna Paulowna', NULL),
217(106, 21, 'Breezand', NULL),
218(107, 21, 'Wieringerwaard', NULL),
219(108, 22, 'Uddel', NULL),
220(109, 22, 'Apeldoorn', NULL),
221(110, 22, 'Ugchelen', NULL),
222(111, 22, 'Beemte Broekland', NULL),
223(112, 22, 'Wenum Wiesel', NULL),
224(113, 22, 'Hoog Soeren', NULL),
225(114, 22, 'Radio Kootwijk', NULL),
226(115, 22, 'Hoenderloo', NULL),
227(116, 22, 'Beekbergen', NULL),
228(117, 22, 'Lieren', NULL),
229(118, 22, 'Loenen (GLD)', NULL),
230(119, 22, 'Klarenbeek', NULL),
231(120, 23, 'Appingedam', NULL),
232(121, 24, 'Velden', NULL),
233(122, 24, 'Lomm', NULL),
234(123, 24, 'Arcen', NULL),
235(124, 25, 'Arnhem', NULL),
236(125, 26, 'Assen', NULL),
237(126, 26, 'Loon', NULL),
238(127, 26, 'Rhee', NULL),
239(128, 26, 'Ter Aard', NULL),
240(129, 26, 'Zeijerveld', NULL),
241(130, 26, 'Zeijerveen', NULL),
242(131, 26, 'Ubbena', NULL),
243(132, 27, 'Asten', NULL),
244(133, 27, 'Ommel', NULL),
245(134, 27, 'Heusden Gemeente Asten', NULL),
246(135, 28, 'Baarle Nassau', NULL),
247(136, 28, 'Ulicoten', NULL),
248(137, 28, 'Castelre', NULL),
249(138, 29, 'Baarn', NULL),
250(139, 29, 'Lage Vuursche', NULL),
251(140, 30, 'Barendrecht', NULL),
252(141, 31, 'Barneveld', NULL),
253(142, 31, 'Kootwijkerbroek', NULL),
254(143, 31, 'Kootwijk', NULL),
255(144, 31, 'Stroe', NULL),
256(145, 31, 'Voorthuizen', NULL),
257(146, 31, 'Terschuur', NULL),
258(147, 31, 'Zwartebroek', NULL),
259(148, 31, 'Achterveld', NULL),
260(149, 31, 'De Glind', NULL),
261(150, 31, 'Garderen', NULL),
262(151, 32, 'Bedum', NULL),
263(152, 32, 'Noordwolde (GN)', NULL),
264(153, 32, 'Zuidwolde (GN)', NULL),
265(154, 32, 'Onderdendam', NULL),
266(155, 33, 'Spaubeek', NULL),
267(156, 33, 'Beek (LB)', NULL),
268(157, 33, 'Maastricht Airport', NULL),
269(158, 34, 'Zuidoostbeemster', NULL),
270(159, 34, 'Middenbeemster', NULL),
271(160, 34, 'Noordbeemster', NULL),
272(161, 34, 'Westbeemster', NULL),
273(162, 35, 'Reuver', NULL),
274(163, 35, 'Beesel', NULL),
275(164, 36, 'Veelerveen', NULL),
276(165, 36, 'Bellingwolde', NULL),
277(166, 36, 'Oudeschans', NULL),
278(167, 36, 'Blijham', NULL),
279(168, 36, 'Wedde', NULL),
280(169, 36, 'Vriescheloo', NULL),
281(170, 37, 'Bennebroek', NULL),
282(171, 38, 'Berkenwoude', NULL),
283(172, 38, 'Bergambacht', NULL),
284(173, 38, 'Ammerstol', NULL),
285(174, 39, 'Riethoven', NULL),
286(175, 39, 'Westerhoven', NULL),
287(176, 39, 'Bergeijk', NULL),
288(177, 39, 'Luijksgestel', NULL),
289(178, 40, 'Afferden (LB)', NULL),
290(179, 40, 'Siebengewald', NULL),
291(180, 40, 'Bergen (LB)', NULL),
292(181, 40, 'Well (LB)', NULL),
293(182, 40, 'Wellerlooi', NULL),
294(183, 41, 'Bergen (NH)', NULL),
295(184, 41, 'Bergen aan Zee', NULL),
296(185, 41, 'Schoorl', NULL),
297(186, 41, 'Groet', NULL),
298(187, 41, 'Egmond aan Zee', NULL),
299(188, 41, 'Egmond aan de Hoef', NULL),
300(189, 41, 'Egmond Binnen', NULL),
301(190, 42, 'Bergen op Zoom', NULL),
302(191, 42, 'Halsteren', NULL),
303(192, 42, 'Lepelstraat', NULL),
304(193, 43, 'Bergschenhoek', NULL),
305(194, 44, 'Berkel en Rodenrijs', NULL),
306(195, 45, 'Eibergen', NULL),
307(196, 45, 'Beltrum', NULL),
308(197, 45, 'Rekken', NULL),
309(198, 45, 'Neede', NULL),
310(199, 45, 'Rietmolen', NULL),
311(200, 45, 'Ruurlo', NULL),
312(201, 45, 'Borculo', NULL),
313(202, 45, 'Haarlo', NULL),
314(203, 45, 'Geesteren (GLD)', NULL),
315(204, 45, 'Gelselaar', NULL),
316(205, 46, 'Heesch', NULL),
317(206, 46, 'Nistelrode', NULL),
318(207, 46, 'Loosbroek', NULL),
319(208, 46, 'Heeswijk Dinther', NULL),
320(209, 46, 'Vorstenbosch', NULL),
321(210, 47, 'Geervliet', NULL),
322(211, 47, 'Simonshaven', NULL),
323(212, 47, 'Zuidland', NULL),
324(213, 47, 'Abbenbroek', NULL),
325(214, 47, 'Heenvliet', NULL),
326(215, 47, 'Oudenhoorn', NULL),
327(216, 48, 'Best', NULL),
328(217, 49, 'Weurt', NULL),
329(218, 49, 'Beuningen (GLD)', NULL),
330(219, 49, 'Ewijk', NULL),
331(220, 49, 'Winssen', NULL),
332(221, 50, 'Beverwijk', NULL),
333(222, 50, 'Wijk aan Zee', NULL),
334(223, 51, 'Mijnsheerenland', NULL),
335(224, 51, 'Westmaas', NULL),
336(225, 51, 'Heinenoord', NULL),
337(226, 51, 'Puttershoek', NULL),
338(227, 51, 'Maasdam', NULL),
339(228, 52, 'Hapert', NULL),
340(229, 52, 'Hoogeloon', NULL),
341(230, 52, 'Casteren', NULL),
342(231, 52, 'Bladel', NULL),
343(232, 52, 'Netersel', NULL),
344(233, 53, 'Blaricum', NULL),
345(234, 54, 'Bleiswijk', NULL),
346(235, 55, 'Overveen', NULL),
347(236, 55, 'Bloemendaal', NULL),
348(237, 55, 'Aerdenhout', NULL),
349(238, 55, 'Vogelenzang', NULL),
350(239, 56, 'Akkrum', NULL),
351(240, 56, 'Terherne', NULL),
352(241, 56, 'Nes Gemeente Boarnsterhim', NULL),
353(242, 56, 'Aldeboarn', NULL),
354(243, 56, 'Dearsum', NULL),
355(244, 56, 'Sibrandabuorren', NULL),
356(245, 56, 'Grou', NULL),
357(246, 56, 'Warten', NULL),
358(247, 56, 'Warstiens', NULL),
359(248, 56, 'Wergea', NULL),
360(249, 56, 'Eagum', NULL),
361(250, 56, 'Idaerd', NULL),
362(251, 56, 'Reduzum', NULL),
363(252, 56, 'Friens', NULL),
364(253, 56, 'Jirnsum', NULL),
365(254, 56, 'Raerd', NULL),
366(255, 56, 'Poppenwier', NULL),
367(256, 56, 'Tersoal', NULL),
368(257, 57, 'Bodegraven', NULL),
369(258, 57, 'Nieuwerbrug', NULL),
370(259, 58, 'Boekel', NULL),
371(260, 58, 'Venhorst', NULL),
372(261, 59, 'Bolsward', NULL),
373(262, 60, 'Eeserveen', NULL),
374(263, 60, 'Klijndijk', NULL),
375(264, 60, 'Valthe', NULL),
376(265, 60, 'Odoorn', NULL),
377(266, 60, 'Odoornerveen', NULL),
378(267, 60, 'Exloo', NULL),
379(268, 60, 'Valthermond', NULL),
380(269, 60, 'Tweede Valthermond', NULL),
381(270, 60, 'Nieuw Buinen', NULL),
382(271, 60, 'Drouwenermond', NULL),
383(272, 60, 'Buinerveen', NULL),
384(273, 60, 'Drouwenerveen', NULL),
385(274, 60, 'Bronnegerveen', NULL),
386(275, 60, 'Bronneger', NULL),
387(276, 60, 'Buinen', NULL),
388(277, 60, 'Borger', NULL),
389(278, 60, 'Drouwen', NULL),
390(279, 60, 'Westdorp', NULL),
391(280, 60, 'Ellertshaar', NULL),
392(281, 60, 'Ees', NULL),
393(282, 60, 'Eesergroen', NULL),
394(283, 60, 'Zandberg (DR)', NULL),
395(284, 60, 'Tweede Exloermond', NULL),
396(285, 60, 'Eerste Exloermond', NULL),
397(286, 60, 'Exloerveen', NULL),
398(287, 61, 'Borne', NULL),
399(288, 61, 'Zenderen', NULL),
400(289, 61, 'Hertme', NULL),
401(290, 62, 's Gravenpolder', NULL),
402(291, 62, 'Hoedekenskerke', NULL),
403(292, 62, 'Kwadendamme', NULL),
404(293, 62, 'Baarland', NULL),
405(294, 62, 'Oudelande', NULL),
406(295, 62, 'Ellewoutsdijk', NULL),
407(296, 62, 'Driewegen', NULL),
408(297, 62, 'Ovezande', NULL),
409(298, 62, 'Nisse', NULL),
410(299, 62, 's Heer Abtskerke', NULL),
411(300, 62, 'Heinkenszand', NULL),
412(301, 62, 's Heerenhoek', NULL),
413(302, 62, 'Borssele', NULL),
414(303, 62, 'Nieuwdorp Zld', NULL),
415(304, 62, 'Lewedorp', NULL),
416(305, 63, 'Boskoop', NULL),
417(306, 64, 'Oeffelt', NULL),
418(307, 64, 'Rijkevoort', NULL),
419(308, 64, 'Vierlingsbeek', NULL),
420(309, 64, 'Maashees', NULL),
421(310, 64, 'Holthees', NULL),
422(311, 64, 'Overloon', NULL),
423(312, 64, 'Groeningen', NULL),
424(313, 64, 'Vortum Mullem', NULL),
425(314, 64, 'Boxmeer', NULL),
426(315, 64, 'Beugen', NULL),
427(316, 64, 'Sambeek', NULL),
428(317, 65, 'Boxtel', NULL),
429(318, 65, 'Liempde', NULL),
430(319, 66, 'Breda', NULL),
431(320, 66, 'Prinsenbeek', NULL),
432(321, 66, 'Teteringen', NULL),
433(322, 66, 'Ulvenhout', NULL),
434(323, 66, 'Bavel', NULL),
435(324, 67, 'Breukelen (UT)', NULL),
436(325, 67, 'Nieuwer Ter Aa', NULL),
437(326, 67, 'Kockengen', NULL),
438(327, 68, 'Brielle', NULL),
439(328, 68, 'Vierpolders', NULL),
440(329, 68, 'Zwartewaal', NULL),
441(330, 69, 'Drempt', NULL),
442(331, 69, 'Hoog Keppel', NULL),
443(332, 69, 'Laag Keppel', NULL),
444(333, 69, 'Hummelo', NULL),
445(334, 69, 'Zelhem', NULL),
446(335, 69, 'Halle', NULL),
447(336, 69, 'Steenderen', NULL),
448(337, 69, 'Baak', NULL),
449(338, 69, 'Rha', NULL),
450(339, 69, 'Olburgen', NULL),
451(340, 69, 'Bronkhorst', NULL),
452(341, 69, 'Toldijk', NULL),
453(342, 69, 'Vierakker', NULL),
454(343, 69, 'Wichmond', NULL),
455(344, 69, 'Vorden', NULL),
456(345, 69, 'Hengelo (GLD)', NULL),
457(346, 69, 'Keijenborg', NULL),
458(347, 70, 'Eerbeek', NULL),
459(348, 70, 'Hall', NULL),
460(349, 70, 'Brummen', NULL),
461(350, 70, 'Leuvenheim', NULL),
462(351, 70, 'Tonden', NULL),
463(352, 70, 'Empe', NULL),
464(353, 71, 'Brunssum', NULL),
465(354, 72, 'Bunnik', NULL),
466(355, 72, 'Odijk', NULL),
467(356, 72, 'Werkhoven', NULL),
468(357, 73, 'Bunschoten Spakenburg', NULL),
469(358, 73, 'Eemdijk', NULL),
470(359, 74, 'Zoelen', NULL),
471(360, 74, 'Kerk Avezaath Gemeente Buren', NULL),
472(361, 74, 'Kapel Avezaath Gemeente Buren', NULL),
473(362, 74, 'Maurik', NULL),
474(363, 74, 'Rijswijk (GLD)', NULL),
475(364, 74, 'Eck en Wiel', NULL),
476(365, 74, 'Ingen', NULL),
477(366, 74, 'Ommeren', NULL),
478(367, 74, 'Lienden', NULL),
479(368, 74, 'Zoelmond', NULL),
480(369, 74, 'Beusichem', NULL),
481(370, 74, 'Asch', NULL),
482(371, 74, 'Buren (GLD)', NULL),
483(372, 74, 'Erichem', NULL),
484(373, 74, 'Ravenswaaij', NULL),
485(374, 75, 'Bussum', NULL),
486(375, 76, 'Capelle aan den IJssel', NULL),
487(376, 77, 'De Woude', NULL),
488(377, 77, 'Castricum', NULL),
489(378, 77, 'Limmen', NULL),
490(379, 77, 'Akersloot', NULL),
491(380, 78, 'Coevorden', NULL),
492(381, 78, 'Dalen', NULL),
493(382, 78, 'Dalerpeel', NULL),
494(383, 78, 'Wachtum', NULL),
495(384, 78, 'Dalerveen', NULL),
496(385, 78, 'Stieltjeskanaal', NULL),
497(386, 78, 'Sleen', NULL),
498(387, 78, 'Diphoorn', NULL),
499(388, 78, 'Erm', NULL),
500(389, 78, 'Holsloot', NULL),
501(390, 78, 'Noord Sleen', NULL),
502(391, 78, 'T Haantje', NULL),
503(392, 78, 'Schoonoord', NULL),
504(393, 78, 'De Kiel', NULL),
505(394, 78, 'Zweeloo', NULL),
506(395, 78, 'Wezup', NULL),
507(396, 78, 'Wezuperbrug', NULL),
508(397, 78, 'Aalden', NULL),
509(398, 78, 'Meppen', NULL),
510(399, 78, 'Benneveld', NULL),
511(400, 78, 'Oosterhesselen', NULL),
512(401, 78, 'Gees', NULL),
513(402, 78, 'Zwinderen', NULL),
514(403, 78, 'Geesbrug', NULL),
515(404, 78, 'Nieuwlande Coevorden', NULL),
516(405, 79, 'Budel', NULL),
517(406, 79, 'Budel Schoot', NULL),
518(407, 79, 'Budel Dorplein', NULL),
519(408, 79, 'Maarheeze', NULL),
520(409, 79, 'Soerendonk', NULL),
521(410, 79, 'Gastel', NULL),
522(411, 80, 'Numansdorp', NULL),
523(412, 80, 'Klaaswaal', NULL),
524(413, 81, 'Cuijk', NULL),
525(414, 81, 'Katwijk (NB)', NULL),
526(415, 81, 'Vianen (NB)', NULL),
527(416, 81, 'Sint Agatha', NULL),
528(417, 81, 'Beers (NB)', NULL),
529(418, 81, 'Linden', NULL),
530(419, 81, 'Haps', NULL),
531(420, 82, 'Culemborg', NULL),
532(421, 83, 'Nieuwleusen', NULL),
533(422, 83, 'Dalfsen', NULL),
534(423, 83, 'Lemelerveld', NULL),
535(424, 84, 'Roodkerk', NULL),
536(425, 84, 'Damwoude', NULL),
537(426, 84, 'Rinsumageest', NULL),
538(427, 84, 'Sijbrandahuis', NULL),
539(428, 84, 'Broeksterwoude', NULL),
540(429, 84, 'De Valom', NULL),
541(430, 84, 'Wouterswoude', NULL),
542(431, 84, 'Driesum', NULL),
543(432, 84, 'Veenwouden', NULL),
544(433, 84, 'Zwaagwesteinde', NULL),
545(434, 85, 'Westbroek', NULL),
546(435, 85, 'Bilthoven', NULL),
547(436, 85, 'De Bilt', NULL),
548(437, 85, 'Groenekan', NULL),
549(438, 85, 'Maartensdijk', NULL),
550(439, 85, 'Hollandsche Rading', NULL),
551(440, 86, 'Mensingeweer', NULL),
552(441, 86, 'Schouwerzijl', NULL),
553(442, 86, 'Warfhuizen', NULL),
554(443, 86, 'Wehe Den Hoorn', NULL),
555(444, 86, 'Leens', NULL),
556(445, 86, 'Zuurdijk', NULL),
557(446, 86, 'Eenrum', NULL),
558(447, 86, 'Pieterburen', NULL),
559(448, 86, 'Westernieland', NULL),
560(449, 86, 'Ulrum', NULL),
561(450, 86, 'Niekerk De Marne', NULL),
562(451, 86, 'Houwerzijl', NULL),
563(452, 86, 'Zoutkamp', NULL),
564(453, 86, 'Vierhuizen', NULL),
565(454, 86, 'Lauwersoog', NULL),
566(455, 86, 'Kloosterburen', NULL),
567(456, 86, 'Hornhuizen', NULL),
568(457, 87, 'De Hoef', NULL),
569(458, 87, 'Amstelhoek', NULL),
570(459, 87, 'Mijdrecht', NULL),
571(460, 87, 'Vinkeveen', NULL),
572(461, 87, 'Waverveen', NULL),
573(462, 87, 'Wilnis', NULL),
574(463, 88, 'Drogteropslagen', NULL),
575(464, 88, 'Zuidwolde (DR)', NULL),
576(465, 88, 'Veeningen', NULL),
577(466, 88, 'Linde (DR)', NULL),
578(467, 88, 'Kerkenveld', NULL),
579(468, 88, 'Alteveer De Wolden', NULL),
580(469, 88, 'Echten (DR)', NULL),
581(470, 88, 'Eursinge De Wolden', NULL),
582(471, 88, 'De Wijk', NULL),
583(472, 88, 'Koekange', NULL),
584(473, 88, 'Ruinerwold', NULL),
585(474, 88, 'Ruinen', NULL),
586(475, 88, 'Ansen', NULL),
587(476, 89, 'Delft', NULL),
588(477, 90, 'Krewerd', NULL),
589(478, 90, 'Holwierde', NULL),
590(479, 90, 'Bierum', NULL),
591(480, 90, 'Losdorp', NULL),
592(481, 90, 'Godlinze', NULL),
593(482, 90, 'Spijk (GN)', NULL),
594(483, 90, 'Delfzijl', NULL),
595(484, 90, 'Farmsum', NULL),
596(485, 90, 'Meedhuizen', NULL),
597(486, 90, 'Wagenborgen', NULL),
598(487, 90, 'Woldendorp', NULL),
599(488, 90, 'Termunten', NULL),
600(489, 90, 'Termunterzijl', NULL),
601(490, 90, 'Borgsweer', NULL),
602(491, 91, 'Den Helder', NULL),
603(492, 92, 'Deurne', NULL),
604(493, 92, 'Vlierden', NULL),
605(494, 92, 'Liessel', NULL),
606(495, 92, 'Neerkant', NULL),
607(496, 92, 'Helenaveen', NULL),
608(497, 93, 'Deventer', NULL),
609(498, 93, 'Colmschate', NULL),
610(499, 93, 'Diepenveen', NULL),
611(500, 93, 'Schalkhaar', NULL),
612(501, 93, 'Lettele', NULL),
613(502, 93, 'Okkenbroek', NULL),
614(503, 93, 'Bathmen', NULL),
615(504, 94, 'Diemen', NULL),
616(505, 95, 'Deurningen', NULL),
617(506, 95, 'Denekamp', NULL),
618(507, 95, 'Weerselo', NULL),
619(508, 95, 'Rossum (OV)', NULL),
620(509, 95, 'Saasveld', NULL),
621(510, 95, 'Ootmarsum', NULL),
622(511, 95, 'Tilligte', NULL),
623(512, 95, 'Lattrop Breklenkamp', NULL),
624(513, 95, 'Agelo', NULL),
625(514, 95, 'Oud Ootmarsum', NULL),
626(515, 95, 'Nutter', NULL),
627(516, 96, 'Dirksland', NULL),
628(517, 96, 'Melissant', NULL),
629(518, 96, 'Herkingen', NULL),
630(519, 97, 'Doesburg', NULL),
631(520, 98, 'Doetinchem', NULL),
632(521, 98, 'Gaanderen', NULL),
633(522, 98, 'Wehl', NULL),
634(523, 99, 'Dongen', NULL),
635(524, 99, 's Gravenmoer', NULL),
636(525, 100, 'Dokkum', NULL),
637(526, 100, 'Aalzum', NULL),
638(527, 100, 'Wetzens', NULL),
639(528, 100, 'Metslawier', NULL),
640(529, 100, 'Jouswier', NULL),
641(530, 100, 'Oostrum (FRL)', NULL),
642(531, 100, 'Ee', NULL),
643(532, 100, 'Engwierum', NULL),
644(533, 100, 'Anjum', NULL),
645(534, 100, 'Lioessens', NULL),
646(535, 100, 'Morra', NULL),
647(536, 100, 'Paesens', NULL),
648(537, 100, 'Oosternijkerk', NULL),
649(538, 100, 'Niawier', NULL),
650(539, 100, 'Wierum', NULL),
651(540, 100, 'Moddergat', NULL),
652(541, 100, 'Nes Gemeente Dongeradeel', NULL),
653(542, 100, 'Hantumhuizen', NULL),
654(543, 100, 'Ternaard', NULL),
655(544, 100, 'Hantumeruitburen', NULL),
656(545, 100, 'Hantum', NULL),
657(546, 100, 'Hiaure', NULL),
658(547, 100, 'Holwerd', NULL),
659(548, 100, 'Waaxens Gemeente Dongeradeel', NULL),
660(549, 100, 'Brantgum', NULL),
661(550, 100, 'Foudgum', NULL),
662(551, 100, 'Raard', NULL),
663(552, 100, 'Bornwird', NULL),
664(553, 101, 'Dordrecht', NULL),
665(554, 102, 'Venhuizen', NULL),
666(555, 102, 'Hem', NULL),
667(556, 102, 'Wijdenes', NULL),
668(557, 102, 'Oosterleek', NULL),
669(558, 102, 'Hoogkarspel', NULL),
670(559, 102, 'Westwoud', NULL),
671(560, 102, 'Oosterblokker', NULL),
672(561, 102, 'Schellinkhout', NULL),
673(562, 103, 'Zevenberg Hoek Gemeente Drimmelen', NULL),
674(563, 103, 'Terheijden', NULL),
675(564, 103, 'Wagenberg', NULL),
676(565, 103, 'Made', NULL),
677(566, 103, 'Drimmelen', NULL),
678(567, 103, 'Lage Zwaluwe', NULL),
679(568, 103, 'Hooge Zwaluwe', NULL),
680(569, 104, 'Dronten', NULL),
681(570, 104, 'Swifterbant', NULL),
682(571, 104, 'Biddinghuizen', NULL),
683(572, 105, 'Horssen', NULL),
684(573, 105, 'Druten', NULL),
685(574, 105, 'Deest', NULL),
686(575, 105, 'Afferden (GLD)', NULL),
687(576, 105, 'Puiflijk', NULL),
688(577, 106, 'Duiven', NULL),
689(578, 106, 'Groessen', NULL),
690(579, 106, 'Loo (GLD)', NULL),
691(580, 107, 'Echt', NULL),
692(581, 107, 'Koningsbosch', NULL),
693(582, 107, 'Maria Hoop', NULL),
694(583, 107, 'Sint Joost', NULL),
695(584, 107, 'Susteren', NULL),
696(585, 107, 'Roosteren', NULL),
697(586, 107, 'Nieuwstadt', NULL),
698(587, 108, 'Volendam', NULL),
699(588, 108, 'Edam', NULL),
700(589, 108, 'Purmer', NULL),
701(590, 109, 'Ede (GLD)', NULL),
702(591, 109, 'Bennekom', NULL),
703(592, 109, 'Otterlo', NULL),
704(593, 109, 'Harskamp', NULL),
705(594, 109, 'Wekerom', NULL),
706(595, 109, 'Lunteren', NULL),
707(596, 109, 'Ederveen', NULL),
708(597, 109, 'De Klomp', NULL),
709(598, 109, 'Deelen', NULL),
710(599, 109, 'Hoenderloo', NULL),
711(600, 110, 'Eemnes', NULL),
712(601, 111, 'Startenhuizen', NULL),
713(602, 111, 'Eemshaven', NULL),
714(603, 111, 'Uithuizen', NULL),
715(604, 111, 'Uithuizermeeden', NULL),
716(605, 111, 'Roodeschool', NULL),
717(606, 111, 'Oudeschip', NULL),
718(607, 111, 'Oosternieland', NULL),
719(608, 111, 'Oldenzijl', NULL),
720(609, 111, 'Usquert', NULL),
721(610, 111, 'Warffum', NULL),
722(611, 111, 'Kantens', NULL),
723(612, 111, 'Eppenhuizen', NULL),
724(613, 111, 'Zandeweer', NULL),
725(614, 111, 'Rottum (GN)', NULL),
726(615, 111, 'Stitswerd', NULL),
727(616, 112, 'Knegsel', NULL),
728(617, 112, 'Vessem', NULL),
729(618, 112, 'Wintelre', NULL),
730(619, 112, 'Eersel', NULL),
731(620, 112, 'Steensel', NULL),
732(621, 112, 'Duizel', NULL),
733(622, 113, 'Eijsden', NULL),
734(623, 113, 'Gronsveld', NULL),
735(624, 114, 'Eindhoven', NULL),
736(625, 115, 'Elburg', NULL),
737(626, 115, 'T Harde', NULL),
738(627, 115, 'Doornspijk', NULL),
739(628, 116, 'Schoonebeek', NULL),
740(629, 116, 'Zandpol', NULL),
741(630, 116, 'Weiteveen', NULL),
742(631, 116, 'Nieuw Schoonebeek', NULL),
743(632, 116, 'Emmen', NULL),
744(633, 116, 'Nieuw Weerdinge', NULL),
745(634, 116, 'Nieuw Amsterdam', NULL),
746(635, 116, 'Veenoord', NULL),
747(636, 116, 'Emmer Compascuum', NULL),
748(637, 116, 'Barger Compascuum', NULL),
749(638, 116, 'Nieuw Dordrecht', NULL),
750(639, 116, 'Erica', NULL),
751(640, 116, 'Klazienaveen', NULL),
752(641, 116, 'Zwartemeer', NULL),
753(642, 116, 'Roswinkel', NULL),
754(643, 117, 'Enkhuizen', NULL),
755(644, 118, 'Enschede', NULL),
756(645, 119, 'Epe', NULL),
757(646, 119, 'Emst', NULL),
758(647, 119, 'Oene', NULL),
759(648, 119, 'Vaassen', NULL),
760(649, 120, 'Ermelo', NULL),
761(650, 121, 'Etten Leur', NULL),
762(651, 122, 'Marrum', NULL),
763(652, 122, 'Hallum', NULL),
764(653, 122, 'Jannum', NULL),
765(654, 122, 'Burdaard', NULL),
766(655, 122, 'Blije', NULL),
767(656, 122, 'Ferwert', NULL),
768(657, 122, 'Hegebeintum', NULL),
769(658, 122, 'Ginnum', NULL),
770(659, 122, 'Reitsum', NULL),
771(660, 122, 'Lichtaard', NULL),
772(661, 122, 'Jislum', NULL),
773(662, 122, 'Wanswert', NULL),
774(663, 123, 'Franeker', NULL),
775(664, 123, 'Tzum', NULL),
776(665, 123, 'Hitzum', NULL),
777(666, 123, 'Achlum', NULL),
778(667, 123, 'Herbaijum', NULL),
779(668, 123, 'Dongjum', NULL),
780(669, 123, 'Boer', NULL),
781(670, 123, 'Ried', NULL),
782(671, 123, 'Peins', NULL),
783(672, 123, 'Schalsum', NULL),
784(673, 123, 'Zweins', NULL),
785(674, 123, 'Tzummarum', NULL),
786(675, 123, 'Firdgum', NULL),
787(676, 123, 'Klooster Lidlum', NULL),
788(677, 123, 'Oosterbierum', NULL),
789(678, 123, 'Sexbierum', NULL),
790(679, 123, 'Pietersbierum', NULL),
791(680, 124, 'Sloten (FRL)', NULL),
792(681, 124, 'Balk', NULL),
793(682, 124, 'Wijckel', NULL),
794(683, 124, 'Ruigahuizen', NULL),
795(684, 124, 'Sondel', NULL),
796(685, 124, 'Nijemirdum', NULL),
797(686, 124, 'Oudemirdum', NULL),
798(687, 124, 'Harich', NULL),
799(688, 124, 'Rijs', NULL),
800(689, 124, 'Mirns', NULL),
801(690, 124, 'Bakhuizen', NULL),
802(691, 124, 'Elahuizen', NULL),
803(692, 124, 'Oudega Gemeente Gaasterland Sleat', NULL),
804(693, 124, 'Kolderwolde', NULL),
805(694, 125, 'Geertruidenberg', NULL),
806(695, 125, 'Raamsdonksveer', NULL),
807(696, 125, 'Raamsdonk', NULL),
808(697, 126, 'Acquoij', NULL),
809(698, 126, 'Rhenoij', NULL),
810(699, 126, 'Beesd', NULL),
811(700, 126, 'Gellicum', NULL),
812(701, 126, 'Rumpt', NULL),
813(702, 126, 'Enspijk', NULL),
814(703, 126, 'Deil', NULL),
815(704, 126, 'Geldermalsen', NULL),
816(705, 126, 'Meteren', NULL),
817(706, 126, 'Tricht', NULL),
818(707, 126, 'Buurmalsen', NULL),
819(708, 127, 'Geldrop', NULL),
820(709, 127, 'Mierlo', NULL),
821(710, 128, 'Gemert', NULL),
822(711, 128, 'Handel', NULL),
823(712, 128, 'Elsendorp', NULL),
824(713, 128, 'De Mortel', NULL),
825(714, 128, 'Bakel', NULL),
826(715, 128, 'Milheeze', NULL),
827(716, 128, 'De Rips', NULL),
828(717, 129, 'Gennep', NULL),
829(718, 129, 'Ottersum', NULL),
830(719, 129, 'Milsbeek', NULL),
831(720, 129, 'Heijen', NULL),
832(721, 130, 'Giessenburg', NULL),
833(722, 130, 'Schelluinen', NULL),
834(723, 130, 'Hoogblokland', NULL),
835(724, 130, 'Hoornaar', NULL),
836(725, 130, 'Noordeloos', NULL),
837(726, 130, 'Arkel', NULL),
838(727, 131, 'Rijen', NULL),
839(728, 131, 'Molenschot', NULL),
840(729, 131, 'Hulten', NULL),
841(730, 131, 'Gilze', NULL),
842(731, 132, 'Stellendam', NULL),
843(732, 132, 'Goedereede', NULL),
844(733, 132, 'Ouddorp (ZH)', NULL),
845(734, 133, 's Heer Arendskerke', NULL),
846(735, 133, 'Goes', NULL),
847(736, 133, 'Wolphaartsdijk', NULL),
848(737, 133, 's Heer Hendriks Kinderderen', NULL),
849(738, 133, 'Kattendijke', NULL),
850(739, 133, 'Wilhelminadorp', NULL),
851(740, 133, 'Kloetinge', NULL),
852(741, 134, 'Goirle', NULL),
853(742, 134, 'Riel', NULL),
854(743, 135, 'Gorinchem', NULL),
855(744, 135, 'Dalem', NULL),
856(745, 136, 'Gouda', NULL),
857(746, 137, 'Oud Alblas', NULL),
858(747, 137, 'Bleskensgraaf Ca', NULL),
859(748, 137, 'Molenaarsgraaf', NULL),
860(749, 137, 'Brandwijk', NULL),
861(750, 137, 'Ottoland', NULL),
862(751, 137, 'Goudriaan', NULL),
863(752, 137, 'Wijngaarden (ZH)', NULL),
864(753, 138, 'De Rijp', NULL),
865(754, 138, 'Graft', NULL),
866(755, 138, 'Noordeinde (NH)', NULL),
867(756, 138, 'West Graftdijk', NULL),
868(757, 138, 'Oost Graftdijk', NULL),
869(758, 138, 'Starnmeer', NULL),
870(759, 138, 'Markenbinnen', NULL),
871(760, 139, 'Grave', NULL),
872(761, 139, 'Velp (NB)', NULL),
873(762, 139, 'Escharen', NULL),
874(763, 139, 'Gassel', NULL),
875(764, 140, 'Lichtenvoorde', NULL),
876(765, 140, 'Vragender', NULL),
877(766, 140, 'Harreveld', NULL),
878(767, 140, 'Zieuwent', NULL),
879(768, 140, 'Lievelde', NULL),
880(769, 140, 'Groenlo', NULL),
881(770, 140, 'Marienvelde', NULL),
882(771, 141, 'Groesbeek', NULL),
883(772, 141, 'Heilig Landstichting', NULL),
884(773, 141, 'Berg En Dal', NULL),
885(774, 142, 'Groningen', NULL),
886(775, 143, 'Oldekerk', NULL),
887(776, 143, 'Niekerk Grootegast', NULL),
888(777, 143, 'Grootegast', NULL),
889(778, 143, 'Sebaldeburen', NULL),
890(779, 143, 'Doezum', NULL),
891(780, 143, 'Kornhorn', NULL),
892(781, 143, 'Opende', NULL),
893(782, 143, 'Lutjegast', NULL),
894(783, 144, 'Gulpen', NULL),
895(784, 144, 'Ingber', NULL),
896(785, 144, 'Reijmerstok', NULL),
897(786, 144, 'Heijenrath', NULL),
898(787, 144, 'Slenaken', NULL),
899(788, 144, 'Beutenaken', NULL),
900(789, 144, 'Mechelen', NULL),
901(790, 144, 'Epen', NULL),
902(791, 144, 'Wittem', NULL),
903(792, 144, 'Eijs', NULL),
904(793, 144, 'Elkenrade', NULL),
905(794, 144, 'Wijlre', NULL),
906(795, 145, 'Haaksbergen', NULL),
907(796, 146, 'Biezenmortel', NULL),
908(797, 146, 'Haaren', NULL),
909(798, 146, 'Helvoirt', NULL),
910(799, 146, 'Esch', NULL),
911(800, 147, 'Haarlem', NULL),
912(801, 147, 'Spaarndam West', NULL),
913(802, 148, 'Halfweg (NH)', NULL),
914(803, 148, 'Spaarndam', NULL),
915(804, 148, 'Haarlemmerliede', NULL),
916(805, 149, 'Schiphol', NULL),
917(806, 149, 'Luchthaven Schiphol', NULL),
918(807, 149, 'Schiphol Rijk', NULL),
919(808, 149, 'Zwanenburg', NULL),
920(809, 149, 'Badhoevedorp', NULL),
921(810, 149, 'Lijnden', NULL),
922(811, 149, 'Rijsenhout', NULL),
923(812, 149, 'Aalsmeerderbrug', NULL),
924(813, 149, 'Rozenburg (NH)', NULL),
925(814, 149, 'Oude Meer', NULL),
926(815, 149, 'Hoofddorp', NULL),
927(816, 149, 'Zwaanshoek', NULL),
928(817, 149, 'Vijfhuizen', NULL),
929(818, 149, 'Cruquius', NULL),
930(819, 149, 'Boesingheliede', NULL),
931(820, 149, 'Beinsdorp', NULL),
932(821, 149, 'Nieuw Vennep', NULL),
933(822, 149, 'Burgerveen', NULL),
934(823, 149, 'Leimuiderbrug', NULL),
935(824, 149, 'Weteringbrug', NULL),
936(825, 149, 'Abbenes', NULL),
937(826, 149, 'Buitenkaag', NULL),
938(827, 149, 'Lisserbroek', NULL),
939(828, 150, 'Haelen', NULL),
940(829, 150, 'Buggenum', NULL),
941(830, 150, 'Nunhem', NULL),
942(831, 150, 'Horn', NULL),
943(832, 151, 'Oudenbosch', NULL),
944(833, 151, 'Hoeven', NULL),
945(834, 151, 'Bosschenhoofd', NULL),
946(835, 151, 'Oud Gastel', NULL),
947(836, 151, 'Stampersgat', NULL),
948(837, 152, 'Bergentheim', NULL),
949(838, 152, 'Marienberg', NULL),
950(839, 152, 'Sibculo', NULL),
951(840, 152, 'Kloosterhaar', NULL),
952(841, 152, 'Bruchterveld', NULL),
953(842, 152, 'Brucht', NULL),
954(843, 152, 'Dedemsvaart', NULL),
955(844, 152, 'Balkbrug', NULL),
956(845, 152, 'Hardenberg', NULL),
957(846, 152, 'Lutten', NULL),
958(847, 152, 'Slagharen', NULL),
959(848, 152, 'Schuinesloot', NULL),
960(849, 152, 'Loozen', NULL),
961(850, 152, 'Holthone', NULL),
962(851, 152, 'De Krim', NULL),
963(852, 152, 'Gramsbergen', NULL),
964(853, 152, 'Ane', NULL),
965(854, 152, 'Anevelde', NULL),
966(855, 152, 'Den Velde', NULL),
967(856, 152, 'Holtheme', NULL),
968(857, 152, 'Anerveen', NULL),
969(858, 152, 'Radewijk', NULL),
970(859, 152, 'Venebrugge', NULL),
971(860, 152, 'Hoogenweg', NULL),
972(861, 152, 'Rheeze', NULL),
973(862, 152, 'Diffelen', NULL),
974(863, 152, 'Heemserveen', NULL),
975(864, 152, 'Rheezerveen', NULL),
976(865, 152, 'Collendoorn', NULL),
977(866, 153, 'Harderwijk', NULL),
978(867, 153, 'Hierden', NULL),
979(868, 154, 'Hardinxveld Giessendam', NULL),
980(869, 155, 'Noordlaren', NULL),
981(870, 155, 'Haren (GN)', NULL),
982(871, 155, 'Onnen', NULL),
983(872, 155, 'Glimmen', NULL),
984(873, 156, 'Waarland', NULL),
985(874, 156, 'Sint Maarten', NULL),
986(875, 156, 'Dirkshorn', NULL),
987(876, 156, 'Tuitjenhorn', NULL),
988(877, 156, 'Warmenhuizen', NULL),
989(878, 157, 'Wijnaldum', NULL),
990(879, 157, 'Harlingen', NULL),
991(880, 157, 'Midlum', NULL),
992(881, 158, 'Hattem', NULL),
993(882, 159, 'Wessem', NULL),
994(883, 159, 'Heel', NULL),
995(884, 159, 'Beegden', NULL),
996(885, 160, 'Heemskerk', NULL),
997(886, 161, 'Heemstede', NULL),
998(887, 162, 'Heerde', NULL),
999(888, 162, 'Wapenveld', NULL),
1000(889, 162, 'Vorchten', NULL),
1001(890, 162, 'Veessen', NULL),
1002(891, 163, 'Jubbega', NULL),
1003(892, 163, 'Hoornsterzwaag', NULL),
1004(893, 163, 'Oudehorne', NULL),
1005(894, 163, 'Nieuwehorne', NULL),
1006(895, 163, 'Bontebok', NULL),
1007(896, 163, 'Heerenveen', NULL),
1008(897, 163, 'Terband', NULL),
1009(898, 163, 'Oudeschoot', NULL),
1010(899, 163, 'Nieuweschoot', NULL),
1011(900, 163, 'Oranjewoud', NULL),
1012(901, 163, 'Mildam', NULL),
1013(902, 163, 'Katlijk', NULL),
1014(903, 163, 'De Knipe', NULL),
1015(904, 163, 'Gersloot', NULL),
1016(905, 163, 'Tjalleberd', NULL),
1017(906, 163, 'Luinjeberd', NULL),
1018(907, 164, 'Heerhugowaard', NULL),
1019(908, 165, 'Heerlen', NULL),
1020(909, 165, 'Hoensbroek', NULL),
1021(910, 166, 'Heeze', NULL),
1022(911, 166, 'Leende', NULL),
1023(912, 166, 'Sterksel', NULL),
1024(913, 167, 'Heiloo', NULL),
1025(914, 168, 'Panningen', NULL),
1026(915, 168, 'Koningslust', NULL),
1027(916, 168, 'Grashoek', NULL),
1028(917, 168, 'Beringe', NULL),
1029(918, 168, 'Egchel', NULL),
1030(919, 168, 'Helden', NULL),
1031(920, 169, 'Nijverdal', NULL),
1032(921, 169, 'Hellendoorn', NULL),
1033(922, 169, 'Haarle Gemeente Hellendoorn', NULL),
1034(923, 169, 'Daarlerveen', NULL),
1035(924, 169, 'Daarle', NULL),
1036(925, 170, 'Hellevoetsluis', NULL),
1037(926, 171, 'Helmond', NULL),
1038(927, 172, 'Hendrik Ido Ambacht', NULL),
1039(928, 173, 'Hengelo (OV)', NULL),
1040(929, 174, 'Minnertsga', NULL),
1041(930, 174, 'Westhoek', NULL),
1042(931, 174, 'Sint Annaparochie', NULL),
1043(932, 174, 'Vrouwenparochie', NULL),
1044(933, 174, 'Oude Bildtzijl', NULL),
1045(934, 174, 'Sint Jacobiparochie', NULL),
1046(935, 175, 'Malden', NULL),
1047(936, 175, 'Heumen', NULL),
1048(937, 175, 'Overasselt', NULL),
1049(938, 175, 'Nederasselt', NULL),
1050(939, 176, 'Drunen', NULL),
1051(940, 176, 'Elshout', NULL),
1052(941, 176, 'Vlijmen', NULL),
1053(942, 176, 'Nieuwkuijk', NULL),
1054(943, 176, 'Haarsteeg', NULL),
1055(944, 176, 'Heusden Gemeente Heusden', NULL),
1056(945, 177, 'Kelpen Oler', NULL),
1057(946, 177, 'Heijthuijsen', NULL),
1058(947, 177, 'Baexem', NULL),
1059(948, 177, 'Grathem', NULL),
1060(949, 178, 'Hillegom', NULL),
1061(950, 179, 'Hilvarenbeek', NULL),
1062(951, 179, 'Biest Houtakker', NULL),
1063(952, 179, 'Esbeek', NULL),
1064(953, 179, 'Diessen', NULL),
1065(954, 179, 'Haghorst', NULL),
1066(955, 180, 'Hilversum', NULL),
1067(956, 181, 'Goor', NULL),
1068(957, 181, 'Markelo', NULL),
1069(958, 181, 'Diepenheim', NULL),
1070(959, 181, 'Delden', NULL),
1071(960, 181, 'Ambt Delden', NULL),
1072(961, 181, 'Hengevelde', NULL),
1073(962, 181, 'Bentelo', NULL),
1074(963, 182, 'Hoogeveen', NULL),
1075(964, 182, 'Nieuweroord', NULL),
1076(965, 182, 'Hollandscheveld', NULL),
1077(966, 182, 'Noordscheschut', NULL),
1078(967, 182, 'Alteveer Hoogeveen', NULL),
1079(968, 182, 'Elim', NULL),
1080(969, 182, 'Nieuwlande', NULL),
1081(970, 182, 'Fluitenberg', NULL),
1082(971, 182, 'Pesse', NULL),
1083(972, 182, 'Stuifzand', NULL),
1084(973, 182, 'Tiendeveen', NULL),
1085(974, 183, 'Hoogezand', NULL),
1086(975, 183, 'Kiel Windeweer', NULL),
1087(976, 183, 'Kropswolde', NULL),
1088(977, 183, 'Foxhol', NULL),
1089(978, 183, 'Westerbroek', NULL),
1090(979, 183, 'Waterhuizen', NULL),
1091(980, 183, 'Sappemeer', NULL),
1092(981, 184, 'Hoorn (NH)', NULL),
1093(982, 184, 'Zwaag', NULL),
1094(983, 184, 'Blokker', NULL),
1095(984, 185, 'Griendtsveen', NULL),
1096(985, 185, 'Broekhuizenvorst', NULL),
1097(986, 185, 'Broekhuizen (LB)', NULL),
1098(987, 185, 'Horst', NULL),
1099(988, 185, 'Melderslo', NULL),
1100(989, 185, 'Hegelsom', NULL),
1101(990, 185, 'Meterik', NULL),
1102(991, 185, 'America', NULL),
1103(992, 185, 'Grubbenvorst', NULL),
1104(993, 185, 'Lottum', NULL),
1105(994, 186, 'Houten', NULL),
1106(995, 186, 't Goij', NULL),
1107(996, 186, 'Schalkwijk', NULL),
1108(997, 186, 'Tull en t Waal', NULL),
1109(998, 187, 'Huizen', NULL),
1110(999, 188, 'Hulst', NULL),
1111(1000, 188, 'Sint Jansteen', NULL),
1112(1001, 188, 'Kapellebrug', NULL),
1113(1002, 188, 'Heikant', NULL),
1114(1003, 188, 'Clinge', NULL),
1115(1004, 188, 'Nieuw Namen', NULL),
1116(1005, 188, 'Graauw', NULL),
1117(1006, 188, 'Vogelwaarde', NULL),
1118(1007, 188, 'Terhole', NULL),
1119(1008, 188, 'Kuitaart', NULL),
1120(1009, 188, 'Hengstdijk', NULL),
1121(1010, 188, 'Lamswaarde', NULL),
1122(1011, 188, 'Kloosterzande', NULL),
1123(1012, 188, 'Walsoorden', NULL),
1124(1013, 188, 'Ossenisse', NULL),
1125(1014, 189, 'Ell', NULL),
1126(1015, 189, 'Haler', NULL),
1127(1016, 189, 'Hunsel', NULL),
1128(1017, 189, 'Ittervoort', NULL),
1129(1018, 189, 'Neeritter', NULL),
1130(1019, 190, 'IJsselstein (UT)', NULL),
1131(1020, 191, 'Hoogmade', NULL),
1132(1021, 191, 'Leimuiden', NULL),
1133(1022, 191, 'Rijnsaterwoude', NULL),
1134(1023, 191, 'Woubrugge', NULL),
1135(1024, 192, 'Kampen', NULL),
1136(1025, 192, 'IJsselmuiden', NULL),
1137(1026, 192, 'Wilsum', NULL),
1138(1027, 192, 's Heerenbroek', NULL),
1139(1028, 192, 'Zalk', NULL),
1140(1029, 192, 'Grafhorst', NULL),
1141(1030, 192, 'Kamperveen', NULL),
1142(1031, 192, 'Mastenbroek', NULL),
1143(1032, 193, 'Kapelle', NULL),
1144(1033, 193, 'Schore', NULL),
1145(1034, 193, 'Wemeldinge', NULL),
1146(1035, 193, 'Kloetinge', NULL),
1147(1036, 194, 'Katwijk (ZH)', NULL),
1148(1037, 194, 'Rijnsburg', NULL),
1149(1038, 194, 'Valkenburg (ZH)', NULL),
1150(1039, 195, 'Kerkrade', NULL),
1151(1040, 195, 'Eijgelshoven', NULL),
1152(1041, 196, 'Kessel (LB)', NULL),
1153(1042, 197, 'Kollum', NULL),
1154(1043, 197, 'Augsbuurt', NULL),
1155(1044, 197, 'Kollumerpomp', NULL),
1156(1045, 197, 'Oudwoude', NULL),
1157(1046, 197, 'Westergeest', NULL),
1158(1047, 197, 'Triemen', NULL),
1159(1048, 197, 'Veenklooster', NULL),
1160(1049, 197, 'Kollumerzwaag', NULL),
1161(1050, 197, 'Zwagerbosch', NULL),
1162(1051, 197, 'Burum', NULL),
1163(1052, 197, 'Warfstermolen', NULL),
1164(1053, 197, 'Munnekezijl', NULL),
1165(1054, 198, 'Nieuw Beijerland', NULL),
1166(1055, 198, 'Piershil', NULL),
1167(1056, 198, 'Goudswaard', NULL),
1168(1057, 198, 'Zuid Beijerland', NULL),
1169(1058, 199, 'Krimpen aan den IJssel', NULL),
1170(1059, 200, 'Aarle Rixtel', NULL),
1171(1060, 200, 'Lieshout', NULL),
1172(1061, 200, 'Mariahout', NULL),
1173(1062, 200, 'Beek en Donk', NULL),
1174(1063, 201, 'Schaijk', NULL),
1175(1064, 201, 'Reek', NULL),
1176(1065, 201, 'Zeeland', NULL),
1177(1066, 202, 'Landgraaf', NULL),
1178(1067, 203, 'Landsmeer', NULL),
1179(1068, 203, 'Den Ilp', NULL),
1180(1069, 203, 'Purmerland', NULL),
1181(1070, 204, 'Broek op Langedijk', NULL),
1182(1071, 204, 'Zuid Scharwoude', NULL),
1183(1072, 204, 'Noord Scharwoude', NULL),
1184(1073, 204, 'Oudkarspel', NULL),
1185(1074, 204, 'Koedijk', NULL),
1186(1075, 204, 'Sint Pancras', NULL),
1187(1076, 205, 'Laren (NH)', NULL),
1188(1077, 206, 'Leek', NULL),
1189(1078, 206, 'Zevenhuizen (GN)', NULL),
1190(1079, 206, 'Midwolde', NULL),
1191(1080, 206, 'Tolbert', NULL),
1192(1081, 206, 'Boerakker Gemeente Leek', NULL),
1193(1082, 206, 'Enumatil', NULL),
1194(1083, 206, 'Lettelbert', NULL),
1195(1084, 206, 'Oostwold Gemeente Leek', NULL),
1196(1085, 207, 'Leerdam', NULL),
1197(1086, 207, 'Schoonrewoerd', NULL),
1198(1087, 207, 'Oosterwijk', NULL),
1199(1088, 207, 'Kedichem', NULL),
1200(1089, 208, 'Leeuwarden', NULL),
1201(1090, 208, 'Lekkum', NULL),
1202(1091, 208, 'Miedum', NULL),
1203(1092, 208, 'Snakkerburen', NULL),
1204(1093, 208, 'Goutum', NULL),
1205(1094, 208, 'Teerns', NULL),
1206(1095, 208, 'Hempens', NULL),
1207(1096, 208, 'Swichum', NULL),
1208(1097, 208, 'Wirdum (FRL)', NULL),
1209(1098, 208, 'Wijtgaard', NULL),
1210(1099, 209, 'Stiens', NULL),
1211(1100, 209, 'Finkum', NULL),
1212(1101, 209, 'Hijum', NULL),
1213(1102, 209, 'Britsum', NULL),
1214(1103, 209, 'Cornjum', NULL),
1215(1104, 209, 'Jelsum', NULL),
1216(1105, 209, 'Oude Leije', NULL),
1217(1106, 210, 'Leiden', NULL),
1218(1107, 211, 'Leiderdorp', NULL),
1219(1108, 212, 'Leidschendam', NULL),
1220(1109, 212, 'Voorburg', NULL),
1221(1110, 213, 'Lelystad', NULL),
1222(1111, 214, 'Delfstrahuizen', NULL),
1223(1112, 214, 'Lemmer', NULL),
1224(1113, 214, 'Eesterga', NULL),
1225(1114, 214, 'Follega', NULL),
1226(1115, 214, 'Oosterzee', NULL),
1227(1116, 214, 'Echten (FRL)', NULL),
1228(1117, 214, 'Bantega', NULL),
1229(1118, 214, 'Echtenerbrug', NULL),
1230(1119, 215, 'Achterveld', NULL),
1231(1120, 215, 'Leusden', NULL),
1232(1121, 215, 'Stoutenburg', NULL),
1233(1122, 216, 'Vrouwenakker', NULL),
1234(1123, 216, 'Noorden', NULL),
1235(1124, 216, 'Zevenhoven', NULL),
1236(1125, 216, 'Nieuwveen', NULL),
1237(1126, 217, 'Streefkerk', NULL),
1238(1127, 217, 'Groot Ammers', NULL),
1239(1128, 217, 'Nieuwpoort', NULL),
1240(1129, 217, 'Langerak (ZH)', NULL),
1241(1130, 217, 'Waal', NULL),
1242(1131, 218, 'Asperen', NULL),
1243(1132, 218, 'Heukelum', NULL),
1244(1133, 218, 'Herwijnen', NULL),
1245(1134, 218, 'Spijk Gemeente Lingewaal', NULL),
1246(1135, 218, 'Vuren', NULL),
1247(1136, 219, 'Bemmel', NULL),
1248(1137, 219, 'Ressen', NULL),
1249(1138, 219, 'Haalderen', NULL),
1250(1139, 219, 'Doornenburg', NULL),
1251(1140, 219, 'Angeren', NULL),
1252(1141, 219, 'Gendt', NULL),
1253(1142, 219, 'Huissen', NULL),
1254(1143, 220, 'Lisse', NULL),
1255(1144, 221, 'Oijen', NULL),
1256(1145, 221, 'Teeffelen', NULL),
1257(1146, 221, 'Lithoijen', NULL),
1258(1147, 221, 'Lith', NULL),
1259(1148, 221, 'Maren Kessel', NULL),
1260(1149, 222, 'Boazum', NULL),
1261(1150, 222, 'Britswert', NULL),
1262(1151, 222, 'Wiuwert', NULL),
1263(1152, 222, 'Rien', NULL),
1264(1153, 222, 'Lijtsewierrum', NULL),
1265(1154, 222, 'Wommels', NULL),
1266(1155, 222, 'Kubaard', NULL),
1267(1156, 222, 'Iens', NULL),
1268(1157, 222, 'Easterein', NULL),
1269(1158, 222, 'Itens', NULL),
1270(1159, 222, 'Reahus', NULL),
1271(1160, 222, 'Hidaard', NULL),
1272(1161, 222, 'Winsum (FRL)', NULL),
1273(1162, 222, 'Huns', NULL),
1274(1163, 222, 'Leons', NULL),
1275(1164, 222, 'Baard', NULL),
1276(1165, 222, 'Easterlittens', NULL),
1277(1166, 222, 'Baaium', NULL),
1278(1167, 222, 'Wjelsrijp', NULL),
1279(1168, 222, 'Spannum', NULL),
1280(1169, 222, 'Hinnaard', NULL),
1281(1170, 222, 'Waaksens Gemeente Littenseradiel', NULL),
1282(1171, 222, 'Easterwierrum', NULL),
1283(1172, 222, 'Mantgum', NULL),
1284(1173, 222, 'Jorwert', NULL),
1285(1174, 222, 'Weidum', NULL),
1286(1175, 222, 'Bears (FRL)', NULL),
1287(1176, 222, 'Jellum', NULL),
1288(1177, 222, 'Hilaard', NULL),
1289(1178, 223, 'Eefde', NULL),
1290(1179, 223, 'Gorssel', NULL),
1291(1180, 223, 'Epse', NULL),
1292(1181, 223, 'Joppe', NULL),
1293(1182, 223, 'Kring Van Dorth', NULL),
1294(1183, 223, 'Harfsen', NULL),
1295(1184, 223, 'Almen', NULL),
1296(1185, 223, 'Lochem', NULL),
1297(1186, 223, 'Barchem', NULL),
1298(1187, 223, 'Laren (GLD)', NULL),
1299(1188, 224, 'Nigtevecht', NULL),
1300(1189, 224, 'Nieuwersluis', NULL),
1301(1190, 224, 'Loenen aan de Vecht', NULL),
1302(1191, 224, 'Vreeland', NULL),
1303(1192, 224, 'Loenersloot', NULL),
1304(1193, 225, 'Kaatsheuvel', NULL),
1305(1194, 225, 'Loon Op Zand', NULL),
1306(1195, 225, 'De Moer', NULL),
1307(1196, 226, 'Benschop', NULL),
1308(1197, 226, 'Lopik', NULL),
1309(1198, 226, 'Lopikerkapel', NULL),
1310(1199, 226, 'Jaarsveld', NULL),
1311(1200, 226, 'Polsbroek', NULL),
1312(1201, 227, 'Oosterwijtwerd', NULL),
1313(1202, 227, 'Leermens', NULL),
1314(1203, 227, 'Eenum', NULL),
1315(1204, 227, 'Zeerijp', NULL),
1316(1205, 227, 'T Zandt (GN)', NULL),
1317(1206, 227, 'Wirdum (GN)', NULL),
1318(1207, 227, 'Garrelsweer', NULL),
1319(1208, 227, 'Loppersum', NULL),
1320(1209, 227, 'Stedum', NULL),
1321(1210, 227, 'Westeremden', NULL),
1322(1211, 227, 'Garsthuizen', NULL),
1323(1212, 227, 'Startenhuizen Gemeente Loppersum', NULL),
1324(1213, 227, 'Zijldijk', NULL),
1325(1214, 227, 'Middelstum', NULL),
1326(1215, 227, 'Huizinge', NULL),
1327(1216, 227, 'Westerwijtwerd', NULL),
1328(1217, 227, 'Toornwerd', NULL),
1329(1218, 228, 'Losser', NULL),
1330(1219, 228, 'Glane', NULL),
1331(1220, 228, 'Overdinkel', NULL),
1332(1221, 228, 'De Lutte', NULL),
1333(1222, 228, 'Beuningen (OV)', NULL),
1334(1223, 229, 'Maarssen', NULL),
1335(1224, 229, 'Oud Zuilen', NULL),
1336(1225, 229, 'Tienhoven (UT)', NULL),
1337(1226, 230, 'Maasbracht', NULL),
1338(1227, 230, 'Linne', NULL),
1339(1228, 230, 'Stevensweert', NULL),
1340(1229, 230, 'Ohe En Laak', NULL),
1341(1230, 231, 'Baarlo (LB)', NULL),
1342(1231, 231, 'Maasbree', NULL),
1343(1232, 232, 'Vinkel', NULL),
1344(1233, 232, 'Geffen', NULL),
1345(1234, 232, 'Nuland', NULL),
1346(1235, 233, 'Hedel', NULL),
1347(1236, 233, 'Ammerzoden', NULL),
1348(1237, 233, 'Well (GLD)', NULL),
1349(1238, 233, 'Hurwenen', NULL),
1350(1239, 233, 'Rossum (GLD)', NULL),
1351(1240, 233, 'Kerkdriel', NULL),
1352(1241, 233, 'Hoenzadriel', NULL),
1353(1242, 233, 'Velddriel', NULL),
1354(1243, 233, 'Alem', NULL),
1355(1244, 233, 'Heerewaarden', NULL),
1356(1245, 234, 'Maassluis', NULL),
1357(1246, 235, 'Maastricht', NULL),
1358(1247, 236, 'Eckelrade', NULL),
1359(1248, 236, 'Noorbeek', NULL),
1360(1249, 236, 'Mheer', NULL),
1361(1250, 236, 'Banholt', NULL),
1362(1251, 236, 'Sint Geertruid', NULL),
1363(1252, 236, 'Cadier En Keer', NULL),
1364(1253, 236, 'Bemelen', NULL),
1365(1254, 236, 'Margraten', NULL),
1366(1255, 236, 'Scheulder', NULL),
1367(1256, 237, 'Boerakker', NULL),
1368(1257, 237, 'Marum', NULL),
1369(1258, 237, 'Nuis', NULL),
1370(1259, 237, 'Niebert', NULL),
1371(1260, 237, 'Jonkersvaart', NULL),
1372(1261, 237, 'De Wilp (GN)', NULL),
1373(1262, 237, 'Noordwijk (GN)', NULL),
1374(1263, 237, 'Lucaswolde', NULL),
1375(1264, 238, 'Medemblik', NULL),
1376(1265, 239, 'Wanssum', NULL),
1377(1266, 239, 'Geijsteren', NULL),
1378(1267, 239, 'Blitterswijck', NULL),
1379(1268, 239, 'Meerlo', NULL),
1380(1269, 239, 'Tienraij', NULL),
1381(1270, 239, 'Swolgen', NULL),
1382(1271, 240, 'Meerssen', NULL),
1383(1272, 240, 'Ulestraten', NULL),
1384(1273, 240, 'Moorveld', NULL),
1385(1274, 240, 'Bunde', NULL),
1386(1275, 240, 'Geulle', NULL),
1387(1276, 241, 'Meijel', NULL),
1388(1277, 242, 'Schingen', NULL),
1389(1278, 242, 'Boksum', NULL),
1390(1279, 242, 'Blessum', NULL),
1391(1280, 242, 'Deinum', NULL),
1392(1281, 242, 'Marssum', NULL),
1393(1282, 242, 'Dronrijp', NULL),
1394(1283, 242, 'Menaldum', NULL),
1395(1284, 242, 'Slappeterp', NULL),
1396(1285, 242, 'Engelum', NULL),
1397(1286, 242, 'Berlikum (FRL)', NULL),
1398(1287, 242, 'Wier', NULL),
1399(1288, 242, 'Beetgum', NULL),
1400(1289, 242, 'Beetgumermolen', NULL),
1401(1290, 243, 'Borgercompagnie', NULL),
1402(1291, 243, 'Tripscompagnie', NULL),
1403(1292, 243, 'Noordbroek', NULL),
1404(1293, 243, 'Zuidbroek', NULL),
1405(1294, 243, 'Muntendam', NULL),
1406(1295, 243, 'Meeden', NULL),
1407(1296, 244, 'Meppel', NULL),
1408(1297, 244, 'Nijeveen', NULL),
1409(1298, 244, 'Rogat', NULL),
1410(1299, 244, 'Broekhuizen (DR)', NULL),
1411(1300, 244, 'De Schiphorst', NULL),
1412(1301, 245, 'Middelburg', NULL),
1413(1302, 245, 'Nieuw en Sint Joosland', NULL),
1414(1303, 245, 'Arnemuiden', NULL),
1415(1304, 246, 'Middelharnis', NULL),
1416(1305, 246, 'Stad Aan Het Haringvliet', NULL),
1417(1306, 246, 'Nieuwe Tonge', NULL),
1418(1307, 246, 'Sommelsdijk', NULL),
1419(1308, 247, 'Den Hoorn (ZH)', NULL),
1420(1309, 247, 'Schipluiden', NULL),
1421(1310, 247, 'Maasland', NULL),
1422(1311, 248, 'Nieuw Balinge', NULL),
1423(1312, 248, 'Beilen', NULL),
1424(1313, 248, 'Hooghalen', NULL),
1425(1314, 248, 'Hijken', NULL),
1426(1315, 248, 'Oranje', NULL),
1427(1316, 248, 'Spier', NULL),
1428(1317, 248, 'Wijster', NULL),
1429(1318, 248, 'Drijber', NULL),
1430(1319, 248, 'Bovensmilde', NULL),
1431(1320, 248, 'Smilde', NULL),
1432(1321, 248, 'Hoogersmilde', NULL),
1433(1322, 248, 'Westerbork', NULL),
1434(1323, 248, 'Zuidveld', NULL),
1435(1324, 248, 'Zwiggelte', NULL),
1436(1325, 248, 'Eursinge', NULL),
1437(1326, 248, 'Bruntinge', NULL),
1438(1327, 248, 'Mantinge', NULL),
1439(1328, 248, 'Balinge', NULL),
1440(1329, 248, 'Garminge', NULL),
1441(1330, 248, 'Witteveen', NULL),
1442(1331, 248, 'Orvelte', NULL),
1443(1332, 248, 'Elp', NULL),
1444(1333, 249, 'Mill', NULL),
1445(1334, 249, 'Langenboom', NULL),
1446(1335, 249, 'Sint Hubert', NULL),
1447(1336, 249, 'Wilbertoord', NULL),
1448(1337, 250, 'Millingen aan den Rijn', NULL),
1449(1338, 251, 'Standdaarbuiten', NULL),
1450(1339, 251, 'Zevenbergen', NULL),
1451(1340, 251, 'Zevenbergschen Hoek', NULL),
1452(1341, 251, 'Langeweg', NULL),
1453(1342, 251, 'Moerdijk', NULL),
1454(1343, 251, 'Klundert', NULL),
1455(1344, 251, 'Fijnaart', NULL),
1456(1345, 251, 'Heijningen', NULL),
1457(1346, 251, 'Oudemolen (NB)', NULL),
1458(1347, 251, 'Willemstad (NB)', NULL),
1459(1348, 252, 'Didam', NULL),
1460(1349, 252, 'Kilder', NULL),
1461(1350, 252, 'Loerbeek', NULL),
1462(1351, 252, 'Beek Montferland', NULL),
1463(1352, 252, 'Zeddam', NULL),
1464(1353, 252, 'Stokkum', NULL),
1465(1354, 252, 'S Heerenberg', NULL),
1466(1355, 252, 'Lengel', NULL),
1467(1356, 252, 'Azewijn', NULL),
1468(1357, 252, 'Vethuizen', NULL),
1469(1358, 252, 'Braamt', NULL),
1470(1359, 252, 'Wijnbergen', NULL),
1471(1360, 253, 'Montfoort', NULL),
1472(1361, 253, 'Linschoten', NULL),
1473(1362, 254, 'Molenhoek (LB)', NULL),
1474(1363, 254, 'Mook', NULL),
1475(1364, 254, 'Plasmolen', NULL),
1476(1365, 254, 'Middelaar', NULL),
1477(1366, 255, 'Moordrecht', NULL),
1478(1367, 256, 'Muiden', NULL),
1479(1368, 256, 'Muiderberg', NULL),
1480(1369, 257, 'Naarden', NULL),
1481(1370, 258, 'Kesteren', NULL),
1482(1371, 258, 'Opheusden', NULL),
1483(1372, 258, 'Ochten', NULL),
1484(1373, 258, 'IJzendoorn', NULL),
1485(1374, 258, 'Echteld', NULL),
1486(1375, 258, 'Dodewaard', NULL),
1487(1376, 259, 'Krimpen aan de Lek', NULL),
1488(1377, 259, 'Lekkerkerk', NULL),
1489(1378, 260, 'Nederweert', NULL),
1490(1379, 260, 'Nederweert Eind', NULL),
1491(1380, 260, 'Ospel', NULL),
1492(1381, 260, 'Leveroij', NULL),
1493(1382, 261, 'Ophemert', NULL),
1494(1383, 261, 'Heesselt', NULL),
1495(1384, 261, 'Varik', NULL),
1496(1385, 261, 'Hellouw', NULL),
1497(1386, 261, 'Haaften', NULL),
1498(1387, 261, 'Tuil', NULL),
1499(1388, 261, 'Waardenburg', NULL),
1500(1389, 261, 'Neerijnen', NULL),
1501(1390, 261, 'Opijnen', NULL),
1502(1391, 261, 'Est', NULL),
1503(1392, 262, 'Winkel', NULL),
1504(1393, 262, 'Lutjewinkel', NULL),
1505(1394, 262, 'Nieuwe Niedorp', NULL),
1506(1395, 262, 'Oude Niedorp', NULL),
1507(1396, 262, 't Veld', NULL),
1508(1397, 262, 'Zijdewind', NULL),
1509(1398, 262, 'Kolhorn', NULL),
1510(1399, 262, 'Barsingerhorn', NULL),
1511(1400, 263, 'Nieuw Lekkerland', NULL),
1512(1401, 263, 'Kinderdijk', NULL),
1513(1402, 264, 'Nieuwegein', NULL),
1514(1403, 265, 'Nieuwerkerk aan den IJssel', NULL),
1515(1404, 266, 'Nieuwkoop', NULL),
1516(1405, 266, 'Noorden', NULL),
1517(1406, 266, 'Woerdense Verlaat', NULL),
1518(1407, 267, 'Hemelum', NULL),
1519(1408, 267, 'Workum', NULL),
1520(1409, 267, 'Hindeloopen', NULL),
1521(1410, 267, 'Stavoren', NULL),
1522(1411, 267, 'Warns', NULL),
1523(1412, 267, 'Molkwerum', NULL),
1524(1413, 267, 'Koudum', NULL),
1525(1414, 267, 'It Heidenskip', NULL),
1526(1415, 267, 'Nijhuizum', NULL),
1527(1416, 268, 'Nijkerk', NULL),
1528(1417, 268, 'Nijkerkerveen', NULL),
1529(1418, 268, 'Hoevelaken', NULL),
1530(1419, 269, 'Nijmegen', NULL),
1531(1420, 269, 'Lent', NULL),
1532(1421, 269, 'Oosterhout Gemeente Nijmegen', NULL),
1533(1422, 269, 'Ressen Gemeente Nijmegen', NULL),
1534(1423, 270, 'Kortgene', NULL),
1535(1424, 270, 'Kats', NULL),
1536(1425, 270, 'Colijnsplaat', NULL),
1537(1426, 270, 'Wissenkerke', NULL),
1538(1427, 270, 'Kamperland', NULL),
1539(1428, 270, 'Geersdijk', NULL),
1540(1429, 271, 'Roden', NULL),
1541(1430, 271, 'Lieveren', NULL),
1542(1431, 271, 'Roderesch', NULL),
1543(1432, 271, 'Alteveer Gemeente Noordenveld', NULL),
1544(1433, 271, 'Steenbergen (DR)', NULL),
1545(1434, 271, 'Nieuw Roden', NULL),
1546(1435, 271, 'Nietap', NULL),
1547(1436, 271, 'Leutingewolde', NULL),
1548(1437, 271, 'Foxwolde', NULL),
1549(1438, 271, 'Roderwolde', NULL),
1550(1439, 271, 'Peize', NULL),
1551(1440, 271, 'Norg', NULL),
1552(1441, 271, 'Langelo (DR)', NULL),
1553(1442, 271, 'Peest', NULL),
1554(1443, 271, 'Zuidvelde', NULL),
1555(1444, 271, 'Huis Ter Heide (DR)', NULL),
1556(1445, 271, 'Westervelde', NULL),
1557(1446, 271, 'Veenhuizen', NULL),
1558(1447, 271, 'Een', NULL),
1559(1448, 271, 'Een West', NULL),
1560(1449, 271, 'Matsloot', NULL),
1561(1450, 272, 'Benningbroek', NULL),
1562(1451, 272, 'Sijbekarspel', NULL),
1563(1452, 272, 'Abbekerk', NULL),
1564(1453, 272, 'Lambertschaag', NULL),
1565(1454, 272, 'Opperdoes', NULL),
1566(1455, 272, 'Twisk', NULL),
1567(1456, 272, 'Oostwoud', NULL),
1568(1457, 272, 'Midwoud', NULL),
1569(1458, 272, 'Hauwert', NULL),
1570(1459, 273, 'Emmeloord', NULL),
1571(1460, 273, 'Ens', NULL),
1572(1461, 273, 'Nagele', NULL),
1573(1462, 273, 'Tollebeek', NULL),
1574(1463, 273, 'Espel', NULL),
1575(1464, 273, 'Creil', NULL),
1576(1465, 273, 'Rutten', NULL),
1577(1466, 273, 'Bant', NULL),
1578(1467, 273, 'Luttelgeest', NULL),
1579(1468, 273, 'Marknesse', NULL),
1580(1469, 273, 'Kraggenburg', NULL),
1581(1470, 274, 'Noordwijk (ZH)', NULL),
1582(1471, 275, 'De Zilk', NULL),
1583(1472, 275, 'Noordwijkerhout', NULL),
1584(1473, 276, 'Nuenen', NULL),
1585(1474, 277, 'Nunspeet', NULL),
1586(1475, 277, 'Elspeet', NULL),
1587(1476, 277, 'Vierhouten', NULL),
1588(1477, 277, 'Hulshorst', NULL),
1589(1478, 278, 'Schimmert', NULL),
1590(1479, 278, 'Hulsberg', NULL),
1591(1480, 278, 'Nuth', NULL),
1592(1481, 278, 'Wijnandsrade', NULL),
1593(1482, 279, 'Hensbroek', NULL),
1594(1483, 279, 'Obdam', NULL),
1595(1484, 280, 'Oegstgeest', NULL),
1596(1485, 281, 'Oost West Middelbeers', NULL),
1597(1486, 281, 'Oirschot', NULL),
1598(1487, 282, 'Heukelom (NB)', NULL),
1599(1488, 282, 'Oisterwijk', NULL),
1600(1489, 282, 'Moergestel', NULL),
1601(1490, 283, 'Noordeinde (GLD)', NULL),
1602(1491, 283, 'Wezep', NULL),
1603(1492, 283, 'Hattemerbroek', NULL),
1604(1493, 283, 'T Loo Gemeente Oldebroek', NULL),
1605(1494, 283, 'Oldebroek', NULL),
1606(1495, 283, 'Oosterwolde (GLD)', NULL),
1607(1496, 284, 'Deurningen', NULL),
1608(1497, 284, 'Oldenzaal', NULL),
1609(1498, 285, 'Olst', NULL),
1610(1499, 285, 'Wesepe', NULL),
1611(1500, 285, 'Wijhe', NULL),
1612(1501, 285, 'Welsum', NULL),
1613(1502, 285, 'Marle', NULL),
1614(1503, 286, 'Beerzerveld', NULL),
1615(1504, 286, 'Ommen', NULL),
1616(1505, 286, 'Vilsteren', NULL),
1617(1506, 286, 'Arrien', NULL),
1618(1507, 286, 'Beerze', NULL),
1619(1508, 286, 'Stegeren', NULL),
1620(1509, 286, 'Witharen', NULL),
1621(1510, 286, 'Vinkenbuurt', NULL),
1622(1511, 286, 'Dalmsholte', NULL),
1623(1512, 286, 'Giethmen', NULL),
1624(1513, 286, 'Lemele', NULL),
1625(1514, 287, 'Merkelbeek', NULL),
1626(1515, 287, 'Schinveld', NULL),
1627(1516, 287, 'Jabeek', NULL),
1628(1517, 287, 'Bingelrade', NULL),
1629(1518, 288, 'Dorst', NULL),
1630(1519, 288, 'Oosterhout (NB)', NULL),
1631(1520, 288, 'Oosteind', NULL),
1632(1521, 288, 'Den Hout (NB)', NULL),
1633(1522, 289, 'Oude Tonge', NULL),
1634(1523, 289, 'Achthuizen', NULL),
1635(1524, 289, 'Ooltgensplaat', NULL),
1636(1525, 289, 'Den Bommel', NULL),
1637(1526, 290, 'Oldeberkoop', NULL),
1638(1527, 290, 'Nijeberkoop', NULL),
1639(1528, 290, 'Makkinga', NULL),
1640(1529, 290, 'Elsloo Fr', NULL),
1641(1530, 290, 'Langedijke', NULL),
1642(1531, 290, 'Appelscha', NULL),
1643(1532, 290, 'Ravenswoud', NULL),
1644(1533, 290, 'Fochteloo', NULL),
1645(1534, 290, 'Oosterwolde (FRL)', NULL),
1646(1535, 290, 'Haule', NULL),
1647(1536, 290, 'Haulerwijk', NULL),
1648(1537, 290, 'Waskemeer', NULL),
1649(1538, 290, 'Donkerbroek', NULL),
1650(1539, 291, 'Oostzaan', NULL),
1651(1540, 292, 'De Weere', NULL),
1652(1541, 292, 'Spanbroek', NULL),
1653(1542, 292, 'Opmeer', NULL),
1654(1543, 292, 'Hoogwoud', NULL),
1655(1544, 292, 'Aartswoud', NULL),
1656(1545, 293, 'Gorredijk', NULL),
1657(1546, 293, 'Jonkerslan', NULL),
1658(1547, 293, 'Langezwaag', NULL),
1659(1548, 293, 'Luxwoude', NULL),
1660(1549, 293, 'Tijnje', NULL),
1661(1550, 293, 'Terwispel', NULL),
1662(1551, 293, 'Lippenhuizen', NULL),
1663(1552, 293, 'Hemrik', NULL),
1664(1553, 293, 'Wijnjewoude', NULL),
1665(1554, 293, 'Bakkeveen', NULL),
1666(1555, 293, 'Beetsterzwaag', NULL),
1667(1556, 293, 'Nij Beets', NULL),
1668(1557, 293, 'Olterterp', NULL),
1669(1558, 293, 'Ureterp', NULL),
1670(1559, 293, 'Siegerswoude', NULL),
1671(1560, 293, 'Frieschepalen', NULL),
1672(1561, 294, 'Oss', NULL),
1673(1562, 294, 'Berghem', NULL),
1674(1563, 294, 'Megen', NULL),
1675(1564, 294, 'Macharen', NULL),
1676(1565, 294, 'Haren (NB)', NULL),
1677(1566, 294, 'Ravenstein', NULL),
1678(1567, 294, 'Herpen', NULL),
1679(1568, 295, 'Oud Beijerland', NULL),
1680(1569, 296, 'Varsseveld', NULL),
1681(1570, 296, 'Westendorp', NULL),
1682(1571, 296, 'Heelweg', NULL),
1683(1572, 296, 'Terborg', NULL),
1684(1573, 296, 'Silvolde', NULL),
1685(1574, 296, 'Sinderen', NULL),
1686(1575, 296, 'Ulft', NULL),
1687(1576, 296, 'Etten (GLD)', NULL),
1688(1577, 296, 'Varsselder En Veldhunten', NULL),
1689(1578, 296, 'Netterden', NULL),
1690(1579, 296, 'Megchelen', NULL),
1691(1580, 296, 'Gendringen', NULL),
1692(1581, 296, 'Voorst Gemeente Gendringen', NULL),
1693(1582, 296, 'Breedenbroek', NULL),
1694(1583, 296, 'Sinderen Gemeente Gendringen', NULL),
1695(1584, 297, 'Duivendrecht', NULL),
1696(1585, 297, 'Ouderkerk Amstel', NULL),
1697(1586, 298, 'Gouderak', NULL),
1698(1587, 298, 'Ouderkerk aan den IJssel', NULL),
1699(1588, 299, 'Oudewater', NULL),
1700(1589, 299, 'Snelrewaard', NULL),
1701(1590, 299, 'Papekop', NULL),
1702(1591, 299, 'Hekendorp', NULL),
1703(1592, 300, 'Elst (GLD)', NULL),
1704(1593, 300, 'Driel', NULL),
1705(1594, 300, 'Heteren', NULL),
1706(1595, 300, 'Randwijk', NULL),
1707(1596, 300, 'Zetten', NULL),
1708(1597, 300, 'Hemmen', NULL),
1709(1598, 300, 'Andelst', NULL),
1710(1599, 300, 'Herveld', NULL),
1711(1600, 300, 'Valburg', NULL),
1712(1601, 300, 'Homoet', NULL),
1713(1602, 300, 'Slijk Ewijk', NULL),
1714(1603, 300, 'Oosterhout (GLD)', NULL),
1715(1604, 301, 'Papendrecht', NULL),
1716(1605, 302, 'Alteveer (GN)', NULL),
1717(1606, 302, 'Nieuwe Pekela', NULL),
1718(1607, 302, 'Oude Pekela', NULL),
1719(1608, 303, 'Nootdorp', NULL),
1720(1609, 303, 'Pijnacker', NULL),
1721(1610, 303, 'Delfgauw', NULL),
1722(1611, 304, 'Purmerend', NULL),
1723(1612, 305, 'Putten', NULL),
1724(1613, 306, 'Laag Zuthem', NULL),
1725(1614, 306, 'Raalte', NULL),
1726(1615, 306, 'Luttenberg', NULL),
1727(1616, 306, 'Marienheem', NULL),
1728(1617, 306, 'Broekland (OV)', NULL),
1729(1618, 306, 'Heeten', NULL),
1730(1619, 306, 'Nieuw Heeten', NULL),
1731(1620, 306, 'Heino', NULL),
1732(1621, 306, 'Lierderholthuis', NULL),
1733(1622, 307, 'Reeuwijk', NULL),
1734(1623, 307, 'Driebruggen', NULL),
1735(1624, 307, 'Waarder', NULL),
1736(1625, 308, 'Finsterwolde', NULL),
1737(1626, 308, 'Beerta', NULL),
1738(1627, 308, 'Nieuw Beerta', NULL),
1739(1628, 308, 'Drieborg', NULL),
1740(1629, 308, 'Oudezijl', NULL),
1741(1630, 308, 'Nieuweschans', NULL),
1742(1631, 309, 'Yerseke', NULL),
1743(1632, 309, 'Rilland', NULL),
1744(1633, 309, 'Krabbendijke', NULL),
1745(1634, 309, 'Waarde', NULL),
1746(1635, 309, 'Oostdijk', NULL),
1747(1636, 309, 'Kruiningen', NULL),
1748(1637, 309, 'Hansweert', NULL),
1749(1638, 310, 'Oosterbeek', NULL),
1750(1639, 310, 'Doorwerth', NULL),
1751(1640, 310, 'Heelsum', NULL),
1752(1641, 310, 'Renkum', NULL),
1753(1642, 310, 'Wolfheze', NULL),
1754(1643, 311, 'Renswoude', NULL),
1755(1644, 312, 'Lage Mierde', NULL),
1756(1645, 312, 'Hooge Mierde', NULL),
1757(1646, 312, 'Hulsel', NULL),
1758(1647, 312, 'Reusel', NULL),
1759(1648, 313, 'Velp (GLD)', NULL),
1760(1649, 313, 'Dieren', NULL),
1761(1650, 313, 'Ellecom', NULL),
1762(1651, 313, 'Spankeren', NULL),
1763(1652, 313, 'Laag Soeren', NULL),
1764(1653, 313, 'Rheden', NULL),
1765(1654, 313, 'De Steeg', NULL),
1766(1655, 314, 'Rhenen', NULL),
1767(1656, 314, 'Elst (UT)', NULL),
1768(1657, 315, 'Ridderkerk', NULL),
1769(1658, 316, 'Pannerden', NULL),
1770(1659, 316, 'Aerdt', NULL),
1771(1660, 316, 'Herwen', NULL),
1772(1661, 316, 'Lobith', NULL),
1773(1662, 316, 'Tolkamer', NULL),
1774(1663, 316, 'Spijk (GLD)', NULL),
1775(1664, 317, 'Hazerswoude Dorp', NULL),
1776(1665, 317, 'Hazerswoude Rijndijk', NULL),
1777(1666, 317, 'Koudekerk aan den Rijn', NULL),
1778(1667, 317, 'Benthuizen', NULL),
1779(1668, 318, 'Holten', NULL),
1780(1669, 318, 'Rijssen', NULL),
1781(1670, 319, 'Rijswijk (ZH)', NULL),
1782(1671, 320, 'Vlodrop', NULL),
1783(1672, 320, 'Melick', NULL),
1784(1673, 320, 'Herkenbosch', NULL),
1785(1674, 321, 'Roermond', NULL),
1786(1675, 321, 'Herten', NULL),
1787(1676, 322, 'Neer', NULL),
1788(1677, 322, 'Roggel', NULL),
1789(1678, 322, 'Heibloem', NULL),
1790(1679, 323, 'Roosendaal', NULL),
1791(1680, 323, 'Nispen', NULL),
1792(1681, 323, 'Wouw', NULL),
1793(1682, 323, 'Wouwse Plantage', NULL),
1794(1683, 323, 'Heerle', NULL),
1795(1684, 323, 'Moerstraten', NULL),
1796(1685, 324, 'Rotterdam', NULL),
1797(1686, 324, 'Hoek Van Holland', NULL),
1798(1687, 324, 'Hoogvliet Rotterdam', NULL),
1799(1688, 324, 'Pernis Rotterdam', NULL),
1800(1689, 324, 'Vondelingenplaat Rotterdam', NULL),
1801(1690, 324, 'Botlek Rotterdam', NULL),
1802(1691, 324, 'Europoort Rotterdam', NULL),
1803(1692, 324, 'Maasvlakte Rotterdam', NULL),
1804(1693, 325, 'Rozenburg (ZH)', NULL),
1805(1694, 326, 'Rozendaal', NULL),
1806(1695, 327, 'Sint Willebrord', NULL),
1807(1696, 327, 'Sprundel', NULL),
1808(1697, 327, 'Rucphen', NULL),
1809(1698, 327, 'Schijf', NULL);
1810INSERT INTO `city` (`id`, `municipalityId`, `name`, `img`) VALUES
1811(1699, 327, 'Zegge', NULL),
1812(1700, 328, 's Gravendeel', NULL),
1813(1701, 329, 'Den Haag', NULL),
1814(1702, 330, 'Den Bosch', NULL),
1815(1703, 330, 'Rosmalen', NULL),
1816(1704, 331, 'Schagen', NULL),
1817(1705, 332, 'Heiligerlee', NULL),
1818(1706, 332, 'Westerlee (GN)', NULL),
1819(1707, 332, 'Scheemda', NULL),
1820(1708, 332, 'Midwolda', NULL),
1821(1709, 332, 'Oostwold Scheemda', NULL),
1822(1710, 332, 'Blauwestad', NULL),
1823(1711, 332, 'T Waar', NULL),
1824(1712, 332, 'Nieuw Scheemda', NULL),
1825(1713, 332, 'Nieuwolda', NULL),
1826(1714, 333, 'Schermerhorn', NULL),
1827(1715, 333, 'Ursem Gemeente Schermer', NULL),
1828(1716, 333, 'Stompetoren', NULL),
1829(1717, 333, 'Oterleek', NULL),
1830(1718, 333, 'Grootschermer', NULL),
1831(1719, 333, 'Driehuizen', NULL),
1832(1720, 333, 'Zuidschermer', NULL),
1833(1721, 334, 'Scherpenzeel (GLD)', NULL),
1834(1722, 335, 'Schiedam', NULL),
1835(1723, 336, 'Schiermonnikoog', NULL),
1836(1724, 337, 'Schijndel', NULL),
1837(1725, 338, 'Puth', NULL),
1838(1726, 338, 'Sweikhuizen', NULL),
1839(1727, 338, 'Schinnen', NULL),
1840(1728, 338, 'Amstenrade', NULL),
1841(1729, 338, 'Oirsbeek', NULL),
1842(1730, 338, 'Doenrade', NULL),
1843(1731, 339, 'Schoonhoven', NULL),
1844(1732, 340, 'Zierikzee', NULL),
1845(1733, 340, 'Ouwerkerk', NULL),
1846(1734, 340, 'Nieuwerkerk', NULL),
1847(1735, 340, 'Oosterland', NULL),
1848(1736, 340, 'Sirjansland', NULL),
1849(1737, 340, 'Bruinisse', NULL),
1850(1738, 340, 'Dreischor', NULL),
1851(1739, 340, 'Zonnemaire', NULL),
1852(1740, 340, 'Noordgouwe', NULL),
1853(1741, 340, 'Brouwershaven', NULL),
1854(1742, 340, 'Kerkwerve', NULL),
1855(1743, 340, 'Scharendijke', NULL),
1856(1744, 340, 'Ellemeet', NULL),
1857(1745, 340, 'Renesse', NULL),
1858(1746, 340, 'Noordwelle', NULL),
1859(1747, 340, 'Serooskerke Schouw', NULL),
1860(1748, 340, 'Burgh Haamstede', NULL),
1861(1749, 341, 'Sevenum', NULL),
1862(1750, 341, 'Kronenberg', NULL),
1863(1751, 341, 'Evertsoord', NULL),
1864(1752, 342, 'Bocholtz', NULL),
1865(1753, 342, 'Baneheide', NULL),
1866(1754, 342, 'Simpelveld', NULL),
1867(1755, 343, 'Landhorst', NULL),
1868(1756, 343, 'Wanroij', NULL),
1869(1757, 343, 'Rijkevoort Walsert', NULL),
1870(1758, 343, 'Oploo', NULL),
1871(1759, 343, 'Westerbeek', NULL),
1872(1760, 343, 'Stevensbeek', NULL),
1873(1761, 343, 'Sint Anthonis', NULL),
1874(1762, 343, 'Ledeacker', NULL),
1875(1763, 344, 'Berlicum (NB)', NULL),
1876(1764, 344, 'Sint Michielsgestel', NULL),
1877(1765, 344, 'Den Dungen', NULL),
1878(1766, 344, 'Gemonde', NULL),
1879(1767, 345, 'Sint Oedenrode', NULL),
1880(1768, 346, 'Born', NULL),
1881(1769, 346, 'Buchten', NULL),
1882(1770, 346, 'Holtum', NULL),
1883(1771, 346, 'Papenhoven', NULL),
1884(1772, 346, 'Obbicht', NULL),
1885(1773, 346, 'Grevenbicht', NULL),
1886(1774, 346, 'Sittard', NULL),
1887(1775, 346, 'Limbricht', NULL),
1888(1776, 346, 'Einighausen', NULL),
1889(1777, 346, 'Guttecoven', NULL),
1890(1778, 346, 'Munstergeleen', NULL),
1891(1779, 346, 'Windraak', NULL),
1892(1780, 346, 'Geleen', NULL),
1893(1781, 347, 'Rottum (FRL)', NULL),
1894(1782, 347, 'Rotstergaast', NULL),
1895(1783, 347, 'Rotsterhaule', NULL),
1896(1784, 347, 'Sintjohannesga', NULL),
1897(1785, 347, 'Oudehaske', NULL),
1898(1786, 347, 'Nijehaske', NULL),
1899(1787, 347, 'Vegelinsoord', NULL),
1900(1788, 347, 'Haskerdijken', NULL),
1901(1789, 347, 'Nieuwebrug', NULL),
1902(1790, 347, 'Joure', NULL),
1903(1791, 347, 'Snikzwaag', NULL),
1904(1792, 347, 'Haskerhorne', NULL),
1905(1793, 347, 'Rohel', NULL),
1906(1794, 347, 'Goingarijp', NULL),
1907(1795, 347, 'Broek (FRL)', NULL),
1908(1796, 347, 'Ouwsterhaule', NULL),
1909(1797, 347, 'Ouwster Nijega', NULL),
1910(1798, 347, 'Oldeouwer', NULL),
1911(1799, 347, 'Doniaga', NULL),
1912(1800, 347, 'Scharsterbrug', NULL),
1913(1801, 347, 'Sint Nicolaasga', NULL),
1914(1802, 347, 'Tjerkgaast', NULL),
1915(1803, 347, 'Idskenhuizen', NULL),
1916(1804, 347, 'Teroele', NULL),
1917(1805, 347, 'Langweer', NULL),
1918(1806, 347, 'Boornzwaag', NULL),
1919(1807, 347, 'Legemeer', NULL),
1920(1808, 347, 'Dijken', NULL),
1921(1809, 347, 'Akmarijp', NULL),
1922(1810, 347, 'Terkaple', NULL),
1923(1811, 348, 'Sliedrecht', NULL),
1924(1812, 349, 'Kolham', NULL),
1925(1813, 349, 'Scharmer', NULL),
1926(1814, 349, 'Harkstede', NULL),
1927(1815, 349, 'Woudbloem', NULL),
1928(1816, 349, 'Froombosch', NULL),
1929(1817, 349, 'Slochteren', NULL),
1930(1818, 349, 'Lageland', NULL),
1931(1819, 349, 'Luddeweer', NULL),
1932(1820, 349, 'Overschild', NULL),
1933(1821, 349, 'Schildwolde', NULL),
1934(1822, 349, 'Hellum', NULL),
1935(1823, 349, 'Siddeburen', NULL),
1936(1824, 349, 'Steendam', NULL),
1937(1825, 349, 'Tjuchem', NULL),
1938(1826, 350, 'Oostburg', NULL),
1939(1827, 350, 'Groede', NULL),
1940(1828, 350, 'Nieuwvliet', NULL),
1941(1829, 350, 'Zuidzande', NULL),
1942(1830, 350, 'Cadzand', NULL),
1943(1831, 350, 'Schoondijke', NULL),
1944(1832, 350, 'Waterlandkerkje', NULL),
1945(1833, 350, 'Breskens', NULL),
1946(1834, 350, 'Hoofdplaat', NULL),
1947(1835, 350, 'IJzendijke', NULL),
1948(1836, 350, 'Biervliet', NULL),
1949(1837, 350, 'Sluis', NULL),
1950(1838, 350, 'Retranchement', NULL),
1951(1839, 350, 'Aardenburg', NULL),
1952(1840, 350, 'Sint Kruis', NULL),
1953(1841, 350, 'Eede Zld', NULL),
1954(1842, 351, 'Goengahuizen', NULL),
1955(1843, 351, 'Drachten', NULL),
1956(1844, 351, 'Kortehemmen', NULL),
1957(1845, 351, 'Boornbergum', NULL),
1958(1846, 351, 'De Wilgen', NULL),
1959(1847, 351, 'Smalle Ee', NULL),
1960(1848, 351, 'De Veenhoop', NULL),
1961(1849, 351, 'Oudega Gemeente Smallingerland', NULL),
1962(1850, 351, 'Nijega', NULL),
1963(1851, 351, 'Opeinde', NULL),
1964(1852, 351, 'De Tike', NULL),
1965(1853, 351, 'Rottevalle', NULL),
1966(1854, 351, 'Drachtstercompagn', NULL),
1967(1855, 351, 'Houtigehage', NULL),
1968(1856, 352, 'Sneek', NULL),
1969(1857, 352, 'Offingawier', NULL),
1970(1858, 352, 'Loenga', NULL),
1971(1859, 352, 'ijsbrechtum', NULL),
1972(1860, 353, 'Soest', NULL),
1973(1861, 353, 'Soesterberg', NULL),
1974(1862, 354, 'Someren', NULL),
1975(1863, 354, 'Lierop', NULL),
1976(1864, 355, 'Son', NULL),
1977(1865, 355, 'Breugel', NULL),
1978(1866, 356, 'Spijkenisse', NULL),
1979(1867, 356, 'Hekelingen', NULL),
1980(1868, 357, 'Stadskanaal', NULL),
1981(1869, 357, 'Musselkanaal', NULL),
1982(1870, 357, 'Mussel', NULL),
1983(1871, 357, 'Vledderveen (GN)', NULL),
1984(1872, 357, 'Onstwedde', NULL),
1985(1873, 357, 'Alteveer (GN)', NULL),
1986(1874, 358, 'Punthorst', NULL),
1987(1875, 358, 'Staphorst', NULL),
1988(1876, 358, 'Rouveen', NULL),
1989(1877, 358, 'IJhorst', NULL),
1990(1878, 359, 'Bovenkarspel', NULL),
1991(1879, 359, 'Grootebroek', NULL),
1992(1880, 359, 'Lutjebroek', NULL),
1993(1881, 360, 'Steenbergen (NB)', NULL),
1994(1882, 360, 'De Heen', NULL),
1995(1883, 360, 'Dinteloord', NULL),
1996(1884, 360, 'Nieuw Vossemeer', NULL),
1997(1885, 360, 'Kruisland', NULL),
1998(1886, 361, 'Wanneperveen', NULL),
1999(1887, 361, 'Belt Schutsloot', NULL),
2000(1888, 361, 'Vollenhove', NULL),
2001(1889, 361, 'Sint Jansklooster', NULL),
2002(1890, 361, 'Steenwijk', NULL),
2003(1891, 361, 'Tuk', NULL),
2004(1892, 361, 'Witte Paarden', NULL),
2005(1893, 361, 'Baars', NULL),
2006(1894, 361, 'De Pol', NULL),
2007(1895, 361, 'Willemsoord', NULL),
2008(1896, 361, 'Marijenkampen', NULL),
2009(1897, 361, 'Steenwijkerwold', NULL),
2010(1898, 361, 'Basse', NULL),
2011(1899, 361, 'Zuidveen', NULL),
2012(1900, 361, 'Onna', NULL),
2013(1901, 361, 'Kallenkote', NULL),
2014(1902, 361, 'De Bult', NULL),
2015(1903, 361, 'Eesveen', NULL),
2016(1904, 361, 'Giethoorn', NULL),
2017(1905, 361, 'Blokzijl', NULL),
2018(1906, 361, 'IJsselham', NULL),
2019(1907, 361, 'Nederland', NULL),
2020(1908, 361, 'Wetering', NULL),
2021(1909, 361, 'Scheerwolde', NULL),
2022(1910, 361, 'Baarlo Ov', NULL),
2023(1911, 361, 'Blankenham', NULL),
2024(1912, 361, 'Kuinre', NULL),
2025(1913, 361, 'Oldemarkt', NULL),
2026(1914, 361, 'Ossenzijl', NULL),
2027(1915, 361, 'Kalenberg', NULL),
2028(1916, 361, 'Paasloo', NULL),
2029(1917, 362, 'Urmond', NULL),
2030(1918, 362, 'Stein (LB)', NULL),
2031(1919, 362, 'Elsloo (LB)', NULL),
2032(1920, 363, 'Strijen', NULL),
2033(1921, 363, 'Strijensas', NULL),
2034(1922, 363, 'Mookhoek', NULL),
2035(1923, 364, 'Swalmen', NULL),
2036(1924, 365, 'Ten Boer', NULL),
2037(1925, 365, 'Ten Post', NULL),
2038(1926, 365, 'Winneweer', NULL),
2039(1927, 365, 'Lellens', NULL),
2040(1928, 365, 'Woltersum', NULL),
2041(1929, 365, 'Sint Annen', NULL),
2042(1930, 365, 'Thesinge', NULL),
2043(1931, 365, 'Garmerwolde', NULL),
2044(1932, 366, 'Ter Aar', NULL),
2045(1933, 367, 'Biervliet', NULL),
2046(1934, 367, 'Terneuzen', NULL),
2047(1935, 367, 'Spui', NULL),
2048(1936, 367, 'Sluiskil', NULL),
2049(1937, 367, 'Hoek', NULL),
2050(1938, 367, 'Zaamslag', NULL),
2051(1939, 367, 'Sas Van Gent', NULL),
2052(1940, 367, 'Philippine', NULL),
2053(1941, 367, 'Westdorpe', NULL),
2054(1942, 367, 'Axel', NULL),
2055(1943, 367, 'Zuiddorpe', NULL),
2056(1944, 367, 'Overslag', NULL),
2057(1945, 367, 'Koewacht', NULL),
2058(1946, 368, 'Terschelling West', NULL),
2059(1947, 368, 'Terschelling Hee', NULL),
2060(1948, 368, 'Terschelling Kaart', NULL),
2061(1949, 368, 'Terschelling Baaid', NULL),
2062(1950, 368, 'Terschelling Kinum', NULL),
2063(1951, 368, 'Terschelling Midld', NULL),
2064(1952, 368, 'Terschelling Serijp', NULL),
2065(1953, 368, 'Terschelling Landr', NULL),
2066(1954, 368, 'Terschelling Formr', NULL),
2067(1955, 368, 'Terschelling Lies', NULL),
2068(1956, 368, 'Terschelling Hoorn', NULL),
2069(1957, 368, 'Terschelling Oosterend', NULL),
2070(1958, 369, 'Den Burg', NULL),
2071(1959, 369, 'Oudeschild', NULL),
2072(1960, 369, 'De Waal', NULL),
2073(1961, 369, 'Oosterend (NH)', NULL),
2074(1962, 369, 'De Cocksdorp', NULL),
2075(1963, 369, 'De Koog', NULL),
2076(1964, 369, 'Den Hoorn Texel', NULL),
2077(1965, 370, 'Sassenheim', NULL),
2078(1966, 370, 'Voorhout', NULL),
2079(1967, 370, 'Warmond', NULL),
2080(1968, 371, 'Sint Philipsland', NULL),
2081(1969, 371, 'Tholen', NULL),
2082(1970, 371, 'Poortvliet', NULL),
2083(1971, 371, 'Scherpenisse', NULL),
2084(1972, 371, 'Sint Maartensdijk', NULL),
2085(1973, 371, 'Stavenisse', NULL),
2086(1974, 371, 'Sint Annaland', NULL),
2087(1975, 371, 'Oud Vossemeer', NULL),
2088(1976, 372, 'Thorn', NULL),
2089(1977, 373, 'Tiel', NULL),
2090(1978, 373, 'Kapel Avezaath Gemeente Tiel', NULL),
2091(1979, 373, 'Wadenoijen', NULL),
2092(1980, 373, 'Kerk Avezaath Gemeente Tiel', NULL),
2093(1981, 373, 'Zennewijnen', NULL),
2094(1982, 374, 'Tilburg', NULL),
2095(1983, 374, 'Berkel Enschot', NULL),
2096(1984, 374, 'Udenhout', NULL),
2097(1985, 375, 'Mariaparochie', NULL),
2098(1986, 375, 'Harbrinkhoek', NULL),
2099(1987, 375, 'Tubbergen', NULL),
2100(1988, 375, 'Vasse', NULL),
2101(1989, 375, 'Hezingen', NULL),
2102(1990, 375, 'Mander', NULL),
2103(1991, 375, 'Manderveen', NULL),
2104(1992, 375, 'Albergen', NULL),
2105(1993, 375, 'Fleringen', NULL),
2106(1994, 375, 'Reutum', NULL),
2107(1995, 375, 'Haarle Gemeente Tubbergen', NULL),
2108(1996, 375, 'Geesteren (OV)', NULL),
2109(1997, 375, 'Langeveen', NULL),
2110(1998, 376, 'Vriezenveen', NULL),
2111(1999, 376, 'Bruinehaar', NULL),
2112(2000, 376, 'Westerhaar Vriezenveensche Wijk', NULL),
2113(2001, 376, 'Vroomshoop', NULL),
2114(2002, 376, 'Den Ham (OV)', NULL),
2115(2003, 377, 'Zuidlaren', NULL),
2116(2004, 377, 'De Groeve', NULL),
2117(2005, 377, 'Zuidlaarderveen', NULL),
2118(2006, 377, 'Midlaren', NULL),
2119(2007, 377, 'Vries', NULL),
2120(2008, 377, 'Tijnaarlo', NULL),
2121(2009, 377, 'Zeegse', NULL),
2122(2010, 377, 'Oudemolen (DR)', NULL),
2123(2011, 377, 'Taarlo', NULL),
2124(2012, 377, 'Zeijen', NULL),
2125(2013, 377, 'De Punt', NULL),
2126(2014, 377, 'IJde', NULL),
2127(2015, 377, 'Winde', NULL),
2128(2016, 377, 'Bunne', NULL),
2129(2017, 377, 'Donderen', NULL),
2130(2018, 377, 'Eelde', NULL),
2131(2019, 377, 'Paterswolde', NULL),
2132(2020, 377, 'Eelderwolde', NULL),
2133(2021, 378, 'Gijtsjerk', NULL),
2134(2022, 378, 'Oentsjerk', NULL),
2135(2023, 378, 'Munein', NULL),
2136(2024, 378, 'Aldtsjerk', NULL),
2137(2025, 378, 'Wijns', NULL),
2138(2026, 378, 'Burgum', NULL),
2139(2027, 378, 'Hurdegarijp', NULL),
2140(2028, 378, 'Tytsjerk', NULL),
2141(2029, 378, 'Ryptsjerk', NULL),
2142(2030, 378, 'Noardburgum', NULL),
2143(2031, 378, 'Jistrum', NULL),
2144(2032, 378, 'Eastermar', NULL),
2145(2033, 378, 'Sumar', NULL),
2146(2034, 378, 'Garijp', NULL),
2147(2035, 378, 'Earnewald', NULL),
2148(2036, 378, 'Suwald', NULL),
2149(2037, 379, 'Berg En Dal', NULL),
2150(2038, 379, 'Beek Ubbergen', NULL),
2151(2039, 379, 'Ubbergen', NULL),
2152(2040, 379, 'Persingen', NULL),
2153(2041, 379, 'Ooij', NULL),
2154(2042, 379, 'Erlecom', NULL),
2155(2043, 379, 'Leuth', NULL),
2156(2044, 379, 'Kekerdom', NULL),
2157(2045, 380, 'Uden', NULL),
2158(2046, 380, 'Volkel', NULL),
2159(2047, 380, 'Odiliapeel', NULL),
2160(2048, 381, 'Uitgeest', NULL),
2161(2049, 382, 'Uithoorn', NULL),
2162(2050, 382, 'De Kwakel', NULL),
2163(2051, 383, 'Urk', NULL),
2164(2052, 384, 'Vleuten', NULL),
2165(2053, 384, 'De Meern', NULL),
2166(2054, 384, 'Haarzuilens', NULL),
2167(2055, 384, 'Utrecht', NULL),
2168(2056, 385, 'Doorn', NULL),
2169(2057, 385, 'Maarn', NULL),
2170(2058, 385, 'Maarsbergen', NULL),
2171(2059, 385, 'Leersum', NULL),
2172(2060, 385, 'Amerongen', NULL),
2173(2061, 385, 'Overberg', NULL),
2174(2062, 385, 'Driebergen Rijsenburg', NULL),
2175(2063, 386, 'Vaals', NULL),
2176(2064, 386, 'Vijlen', NULL),
2177(2065, 386, 'Lemiers', NULL),
2178(2066, 387, 'Valkenburg (LB)', NULL),
2179(2067, 387, 'Schin Op Geul', NULL),
2180(2068, 387, 'Berg En Terblijt', NULL),
2181(2069, 387, 'Walem', NULL),
2182(2070, 388, 'Valkenswaard', NULL),
2183(2071, 389, 'Borgercompagnie', NULL),
2184(2072, 389, 'Veendam', NULL),
2185(2073, 389, 'Wildervank', NULL),
2186(2074, 390, 'Veenendaal', NULL),
2187(2075, 391, 'Veere', NULL),
2188(2076, 391, 'Gapinge', NULL),
2189(2077, 391, 'Serooskerke Walcheren', NULL),
2190(2078, 391, 'Vrouwenpolder', NULL),
2191(2079, 391, 'Oostkapelle', NULL),
2192(2080, 391, 'Domburg', NULL),
2193(2081, 391, 'Westkapelle', NULL),
2194(2082, 391, 'Aagtekerke', NULL),
2195(2083, 391, 'Grijpskerke', NULL),
2196(2084, 391, 'Meliskerke', NULL),
2197(2085, 391, 'Koudekerke', NULL),
2198(2086, 391, 'Biggekerke', NULL),
2199(2087, 391, 'Zoutelande', NULL),
2200(2088, 392, 'Veghel', NULL),
2201(2089, 392, 'Erp', NULL),
2202(2090, 393, 'Veldhoven', NULL),
2203(2091, 394, 'Velsen Noord', NULL),
2204(2092, 394, 'IJmuiden', NULL),
2205(2093, 394, 'Velsen Zuid', NULL),
2206(2094, 394, 'Driehuis (NH)', NULL),
2207(2095, 394, 'Velserbroek', NULL),
2208(2096, 394, 'Santpoort Noord', NULL),
2209(2097, 394, 'Santpoort Zuid', NULL),
2210(2098, 395, 'Venlo', NULL),
2211(2099, 395, 'Tegelen', NULL),
2212(2100, 395, 'Steijl', NULL),
2213(2101, 395, 'Belfeld', NULL),
2214(2102, 396, 'Venray', NULL),
2215(2103, 396, 'Oostrum (LB)', NULL),
2216(2104, 396, 'Oirlo', NULL),
2217(2105, 396, 'Leunen', NULL),
2218(2106, 396, 'Castenraij', NULL),
2219(2107, 396, 'Heide', NULL),
2220(2108, 396, 'IJsselsteijn (LB)', NULL),
2221(2109, 396, 'Veulen', NULL),
2222(2110, 396, 'Merselo', NULL),
2223(2111, 396, 'Vredepeel', NULL),
2224(2112, 396, 'Smakt', NULL),
2225(2113, 397, 'Ossenwaard (UT)', NULL),
2226(2114, 397, 'Everdingen', NULL),
2227(2115, 397, 'Zijderveld', NULL),
2228(2116, 397, 'Hagestein', NULL),
2229(2117, 397, 'Vianen (UT)', NULL),
2230(2118, 398, 'Vlaardingen', NULL),
2231(2119, 399, 'Vlagtwedde', NULL),
2232(2120, 399, 'Bourtange', NULL),
2233(2121, 399, 'Sellingen', NULL),
2234(2122, 399, 'Ter Apel', NULL),
2235(2123, 399, 'Ter Apelkanaal', NULL),
2236(2124, 400, 'Vlieland', NULL),
2237(2125, 401, 'Vlissingen', NULL),
2238(2126, 401, 'Oost Souburg', NULL),
2239(2127, 401, 'Ritthem', NULL),
2240(2128, 402, 'Stolwijk', NULL),
2241(2129, 402, 'Haastrecht', NULL),
2242(2130, 402, 'Vlist', NULL),
2243(2131, 403, 'Ransdaal', NULL),
2244(2132, 403, 'Klimmen', NULL),
2245(2133, 403, 'Voerendaal', NULL),
2246(2134, 404, 'Voorschoten', NULL),
2247(2135, 405, 'Klarenbeek', NULL),
2248(2136, 405, 'Voorst Gemeente Voorst', NULL),
2249(2137, 405, 'Wilp (GLD)', NULL),
2250(2138, 405, 'Twello', NULL),
2251(2139, 405, 'Teuge', NULL),
2252(2140, 405, 'Terwolde', NULL),
2253(2141, 405, 'Nijbroek', NULL),
2254(2142, 405, 'Steenenkamer', NULL),
2255(2143, 406, 'Vught', NULL),
2256(2144, 406, 'Cromvoirt', NULL),
2257(2145, 407, 'Waalre', NULL),
2258(2146, 408, 'Waalwijk', NULL),
2259(2147, 408, 'Sprang Capelle', NULL),
2260(2148, 408, 'Waspik', NULL),
2261(2149, 409, 'Waddinxveen', NULL),
2262(2150, 410, 'Wageningen', NULL),
2263(2151, 411, 'Wassenaar', NULL),
2264(2152, 412, 'Monnickendam', NULL),
2265(2153, 412, 'Katwoude', NULL),
2266(2154, 412, 'Broek in Waterland', NULL),
2267(2155, 412, 'Zuiderwoude', NULL),
2268(2156, 412, 'Uitdam', NULL),
2269(2157, 412, 'Marken', NULL),
2270(2158, 412, 'Ilpendam', NULL),
2271(2159, 412, 'Watergang', NULL),
2272(2160, 412, 'Purmer', NULL),
2273(2161, 413, 'Weert', NULL),
2274(2162, 413, 'Stramproy', NULL),
2275(2163, 414, 'Weesp', NULL),
2276(2164, 415, 'Werkendam', NULL),
2277(2165, 415, 'Sleeuwijk', NULL),
2278(2166, 415, 'Nieuwendijk (NB)', NULL),
2279(2167, 415, 'Dussen', NULL),
2280(2168, 415, 'Hank', NULL),
2281(2169, 416, 'Zwaagdijk', NULL),
2282(2170, 416, 'Wervershoof', NULL),
2283(2171, 417, 'Dreumel', NULL),
2284(2172, 417, 'Alphen (GLD)', NULL),
2285(2173, 417, 'Maasbommel', NULL),
2286(2174, 417, 'Altforst', NULL),
2287(2175, 417, 'Appeltern', NULL),
2288(2176, 417, 'Boven Leeuwen', NULL),
2289(2177, 417, 'Beneden Leeuwen', NULL),
2290(2178, 417, 'Wamel', NULL),
2291(2179, 418, 'Oudendijk (NH)', NULL),
2292(2180, 418, 'Avenhorn', NULL),
2293(2181, 418, 'Scharwoude', NULL),
2294(2182, 418, 'Spierdijk', NULL),
2295(2183, 418, 'Ursem', NULL),
2296(2184, 418, 'Berkhout', NULL),
2297(2185, 418, 'De Goorn', NULL),
2298(2186, 418, 'Zuidermeer', NULL),
2299(2187, 419, 'Havelte', NULL),
2300(2188, 419, 'Darp', NULL),
2301(2189, 419, 'Havelterberg', NULL),
2302(2190, 419, 'Uffelte', NULL),
2303(2191, 419, 'Diever', NULL),
2304(2192, 419, 'Wapse', NULL),
2305(2193, 419, 'Dieverbrug', NULL),
2306(2194, 419, 'Geeuwenbrug', NULL),
2307(2195, 419, 'Wittelte', NULL),
2308(2196, 419, 'Dwingeloo', NULL),
2309(2197, 419, 'Wapserveen', NULL),
2310(2198, 419, 'Vledder', NULL),
2311(2199, 419, 'Frederiksoord', NULL),
2312(2200, 419, 'Nijensleek', NULL),
2313(2201, 419, 'Wilhelminaoord', NULL),
2314(2202, 419, 'Vledderveen (DR)', NULL),
2315(2203, 419, 'Doldersum', NULL),
2316(2204, 419, 'Boschoord', NULL),
2317(2205, 419, 'Zorgvlied', NULL),
2318(2206, 419, 'Wateren', NULL),
2319(2207, 419, 'Oude Willem', NULL),
2320(2208, 420, 'Westervoort', NULL),
2321(2209, 421, 'Wateringen', NULL),
2322(2210, 421, 'Kwintsheul', NULL),
2323(2211, 421, 'Naaldwijk', NULL),
2324(2212, 421, 'Honselersdijk', NULL),
2325(2213, 421, 'Maasdijk', NULL),
2326(2214, 421, 'De Lier', NULL),
2327(2215, 421, 'Monster', NULL),
2328(2216, 421, 'Ter Heijde', NULL),
2329(2217, 421, 'Poeldijk', NULL),
2330(2218, 421, 's Gravenzande', NULL),
2331(2219, 422, 'Oosterstreek', NULL),
2332(2220, 422, 'Zandhuizen', NULL),
2333(2221, 422, 'Noordwolde (FRL)', NULL),
2334(2222, 422, 'Boijl', NULL),
2335(2223, 422, 'Vinkega', NULL),
2336(2224, 422, 'De Hoeve', NULL),
2337(2225, 422, 'Steggerda', NULL),
2338(2226, 422, 'Peperga', NULL),
2339(2227, 422, 'De Blesse', NULL),
2340(2228, 422, 'Blesdijke', NULL),
2341(2229, 422, 'Wolvega', NULL),
2342(2230, 422, 'Oldeholtpade', NULL),
2343(2231, 422, 'Nijeholtpade', NULL),
2344(2232, 422, 'Ter Idzard', NULL),
2345(2233, 422, 'Oldeholtwolde', NULL),
2346(2234, 422, 'Sonnega', NULL),
2347(2235, 422, 'Oldetrijne', NULL),
2348(2236, 422, 'Nijetrijne', NULL),
2349(2237, 422, 'Spanga', NULL),
2350(2238, 422, 'Scherpenzeel (FRL)', NULL),
2351(2239, 422, 'Langelille', NULL),
2352(2240, 422, 'Munnekeburen', NULL),
2353(2241, 422, 'Oldelamer', NULL),
2354(2242, 422, 'Nijelamer', NULL),
2355(2243, 422, 'Nijeholtwolde', NULL),
2356(2244, 422, 'Slijkenburg', NULL),
2357(2245, 423, 'Oostvoorne', NULL),
2358(2246, 423, 'Tinte', NULL),
2359(2247, 423, 'Rockanje', NULL),
2360(2248, 424, 'Zuna', NULL),
2361(2249, 424, 'Notter', NULL),
2362(2250, 424, 'Enter', NULL),
2363(2251, 424, 'Wierden', NULL),
2364(2252, 424, 'Hoge Hexel', NULL),
2365(2253, 425, 'Hippolytushoef', NULL),
2366(2254, 425, 'Westerland', NULL),
2367(2255, 425, 'Den Oever', NULL),
2368(2256, 426, 'Wieringerwerf', NULL),
2369(2257, 426, 'Kreileroord', NULL),
2370(2258, 426, 'Slootdorp', NULL),
2371(2259, 426, 'Middenmeer', NULL),
2372(2260, 427, 'Wijchen', NULL),
2373(2261, 427, 'Niftrik', NULL),
2374(2262, 427, 'Balgoij', NULL),
2375(2263, 427, 'Leur', NULL),
2376(2264, 427, 'Hernen', NULL),
2377(2265, 427, 'Bergharen', NULL),
2378(2266, 427, 'Batenburg', NULL),
2379(2267, 428, 'Loosdrecht', NULL),
2380(2268, 428, 'Kortenhoef', NULL),
2381(2269, 428, 's Graveland', NULL),
2382(2270, 428, 'Ankeveen', NULL),
2383(2271, 428, 'Nederhorst den Berg', NULL),
2384(2272, 428, 'Breukeleveen', NULL),
2385(2273, 429, 'Cothen', NULL),
2386(2274, 429, 'Langbroek', NULL),
2387(2275, 429, 'Wijk bij Duurstede', NULL),
2388(2276, 430, 'Winschoten', NULL),
2389(2277, 431, 'Sauwerd', NULL),
2390(2278, 431, 'Wetsinge', NULL),
2391(2279, 431, 'Adorp', NULL),
2392(2280, 431, 'Ezinge', NULL),
2393(2281, 431, 'Feerwerd', NULL),
2394(2282, 431, 'Garnwerd', NULL),
2395(2283, 431, 'Winsum (GN)', NULL),
2396(2284, 431, 'Baflo', NULL),
2397(2285, 431, 'Tinallinge', NULL),
2398(2286, 431, 'Rasquert', NULL),
2399(2287, 431, 'Den Andel', NULL),
2400(2288, 431, 'Saaxumhuizen', NULL),
2401(2289, 432, 'Winterswijk', NULL),
2402(2290, 432, 'Winterswijk Meddo', NULL),
2403(2291, 432, 'Winterswijk Huppel', NULL),
2404(2292, 432, 'Winterswijk Ratum', NULL),
2405(2293, 432, 'Winterswijk Kotten', NULL),
2406(2294, 432, 'Winterswijk Woold', NULL),
2407(2295, 432, 'Winterswijk Miste', NULL),
2408(2296, 432, 'Winterswijk Henxel', NULL),
2409(2297, 432, 'Winterswijk Brinkh', NULL),
2410(2298, 432, 'Winterswijk Corle', NULL),
2411(2299, 433, 'Hoogerheide', NULL),
2412(2300, 433, 'Woensdrecht', NULL),
2413(2301, 433, 'Huijbergen', NULL),
2414(2302, 433, 'Ossendrecht', NULL),
2415(2303, 433, 'Putte', NULL),
2416(2304, 434, 'Woerden', NULL),
2417(2305, 434, 'Kamerik', NULL),
2418(2306, 434, 'Zegveld', NULL),
2419(2307, 434, 'Harmelen', NULL),
2420(2308, 435, 'Zwaagdijk', NULL),
2421(2309, 435, 'Wognum', NULL),
2422(2310, 435, 'Nibbixwoud', NULL),
2423(2311, 436, 'Wijdewormer', NULL),
2424(2312, 436, 'Spijkerboor (NH)', NULL),
2425(2313, 436, 'Wormer', NULL),
2426(2314, 436, 'Oostknollendam', NULL),
2427(2315, 436, 'Jisp', NULL),
2428(2316, 437, 'Woudenberg', NULL),
2429(2317, 438, 'Andel', NULL),
2430(2318, 438, 'Giessen', NULL),
2431(2319, 438, 'Rijswijk (NB)', NULL),
2432(2320, 438, 'Woudrichem', NULL),
2433(2321, 438, 'Almkerk', NULL),
2434(2322, 438, 'Waardhuizen', NULL),
2435(2323, 438, 'Uitwijk', NULL),
2436(2324, 439, 'Hartwerd', NULL),
2437(2325, 439, 'Burgwerd', NULL),
2438(2326, 439, 'Hichtum', NULL),
2439(2327, 439, 'Schettens', NULL),
2440(2328, 439, 'Longerhouw', NULL),
2441(2329, 439, 'Schraard', NULL),
2442(2330, 439, 'Wons', NULL),
2443(2331, 439, 'Witmarsum', NULL),
2444(2332, 439, 'Pingjum', NULL),
2445(2333, 439, 'Zurich', NULL),
2446(2334, 439, 'Kornwerderzand', NULL),
2447(2335, 439, 'Cornwerd', NULL),
2448(2336, 439, 'Makkum (FR)', NULL),
2449(2337, 439, 'Idsegahuizum', NULL),
2450(2338, 439, 'Piaam', NULL),
2451(2339, 439, 'Gaast', NULL),
2452(2340, 439, 'Allingawier', NULL),
2453(2341, 439, 'Exmorra', NULL),
2454(2342, 439, 'Ferwoude', NULL),
2455(2343, 439, 'Hieslum', NULL),
2456(2344, 439, 'Parrega', NULL),
2457(2345, 439, 'Dedgum', NULL),
2458(2346, 439, 'Tjerkwerd', NULL),
2459(2347, 439, 'Breezanddijk', NULL),
2460(2348, 439, 'Kimswerd', NULL),
2461(2349, 439, 'Arum', NULL),
2462(2350, 439, 'Lollum', NULL),
2463(2351, 440, 'Koufurderrige', NULL),
2464(2352, 440, 'Woudsend', NULL),
2465(2353, 440, 'Smallebrugge', NULL),
2466(2354, 440, 'Indijk', NULL),
2467(2355, 440, 'Ypecolsga', NULL),
2468(2356, 440, 'Gaastmeer', NULL),
2469(2357, 440, 'Idzega', NULL),
2470(2358, 440, 'Sandfirden', NULL),
2471(2359, 440, 'Oudega Gemeente Wymbritseradiel', NULL),
2472(2360, 440, 'Blauwhuis', NULL),
2473(2361, 440, 'Westhem', NULL),
2474(2362, 440, 'Abbega', NULL),
2475(2363, 440, 'Oosthem', NULL),
2476(2364, 440, 'Heeg', NULL),
2477(2365, 440, 'Hommerts', NULL),
2478(2366, 440, 'Jutrijp', NULL),
2479(2367, 440, 'Uitwellingerga', NULL),
2480(2368, 440, 'Oppenhuizen', NULL),
2481(2369, 440, 'Gauw', NULL),
2482(2370, 440, 'Goenga', NULL),
2483(2371, 440, 'Scharnegoutum', NULL),
2484(2372, 440, 'Tirns', NULL),
2485(2373, 440, 'IJlst', NULL),
2486(2374, 440, 'Greonterp', NULL),
2487(2375, 440, 'Nijland', NULL),
2488(2376, 440, 'Tjalhuizum', NULL),
2489(2377, 440, 'Folsgare', NULL),
2490(2378, 440, 'Wolsum', NULL),
2491(2379, 441, 'Zaandam', NULL),
2492(2380, 441, 'Wormerveer', NULL),
2493(2381, 441, 'Westknollendam', NULL),
2494(2382, 441, 'Koog aan de Zaan', NULL),
2495(2383, 441, 'Zaandijk', NULL),
2496(2384, 441, 'Westzaan', NULL),
2497(2385, 441, 'Krommenie', NULL),
2498(2386, 441, 'Assendelft', NULL),
2499(2387, 442, 'Zaltbommel', NULL),
2500(2388, 442, 'Zuilichem', NULL),
2501(2389, 442, 'Brakel', NULL),
2502(2390, 442, 'Poederoijen', NULL),
2503(2391, 442, 'Aalst (GLD)', NULL),
2504(2392, 442, 'Gameren', NULL),
2505(2393, 442, 'Nieuwaal', NULL),
2506(2394, 442, 'Bruchem', NULL),
2507(2395, 442, 'Kerkwijk', NULL),
2508(2396, 442, 'Delwijnen', NULL),
2509(2397, 442, 'Nederhemert', NULL),
2510(2398, 442, 'Bern', NULL),
2511(2399, 443, 'Zandvoort', NULL),
2512(2400, 443, 'Bentveld', NULL),
2513(2401, 444, 'Hei en Boeicop', NULL),
2514(2402, 444, 'Lexmond', NULL),
2515(2403, 444, 'Meerkerk', NULL),
2516(2404, 444, 'Ameide', NULL),
2517(2405, 444, 'Tienhoven (ZH)', NULL),
2518(2406, 444, 'Nieuwland', NULL),
2519(2407, 444, 'Leerbroek', NULL),
2520(2408, 445, 'Kwadijk', NULL),
2521(2409, 445, 'Middelie', NULL),
2522(2410, 445, 'Warder', NULL),
2523(2411, 445, 'Oosthuizen', NULL),
2524(2412, 445, 'Beets (NH)', NULL),
2525(2413, 445, 'Schardam', NULL),
2526(2414, 445, 'Hobrede', NULL),
2527(2415, 446, 'Zeewolde', NULL),
2528(2416, 447, 'Zeist', NULL),
2529(2417, 447, 'Austerlitz', NULL),
2530(2418, 447, 'Huis Ter Heide (UT)', NULL),
2531(2419, 447, 'Den Dolder', NULL),
2532(2420, 447, 'Bosch en Duin', NULL),
2533(2421, 448, 'Zevenaar', NULL),
2534(2422, 448, 'Babberich', NULL),
2535(2423, 448, 'Angerlo', NULL),
2536(2424, 448, 'Giesbeek', NULL),
2537(2425, 448, 'Lathum', NULL),
2538(2426, 449, 'Moerkapelle', NULL),
2539(2427, 449, 'Zevenhuizen (ZH)', NULL),
2540(2428, 450, 'Schagerbrug', NULL),
2541(2429, 450, 'Sint Maartensbrug', NULL),
2542(2430, 450, 'Sint Maartensvlotbrug', NULL),
2543(2431, 450, 'Burgerbrug', NULL),
2544(2432, 450, 'Petten', NULL),
2545(2433, 450, 't Zand (NH)', NULL),
2546(2434, 450, 'Oudesluis', NULL),
2547(2435, 450, 'Callantsoog', NULL),
2548(2436, 451, 'Zoetermeer', NULL),
2549(2437, 452, 'Zoeterwoude', NULL),
2550(2438, 452, 'Gelderswoude', NULL),
2551(2439, 453, 'Zuidhorn', NULL),
2552(2440, 453, 'Noordhorn', NULL),
2553(2441, 453, 'Briltil', NULL),
2554(2442, 453, 'Aduard', NULL),
2555(2443, 453, 'Den Horn', NULL),
2556(2444, 453, 'Den Ham (GN)', NULL),
2557(2445, 453, 'Niezijl', NULL),
2558(2446, 453, 'Grijpskerk', NULL),
2559(2447, 453, 'Pieterzijl', NULL),
2560(2448, 453, 'Visvliet', NULL),
2561(2449, 453, 'Kommerzijl', NULL),
2562(2450, 453, 'Oldehove', NULL),
2563(2451, 453, 'Niehove', NULL),
2564(2452, 453, 'Lauwerzijl', NULL),
2565(2453, 453, 'Saaksum', NULL),
2566(2454, 454, 'Zundert', NULL),
2567(2455, 454, 'Wernhout', NULL),
2568(2456, 454, 'Achtmaal', NULL),
2569(2457, 454, 'Rijsbergen', NULL),
2570(2458, 455, 'Zutphen', NULL),
2571(2459, 455, 'Warnsveld', NULL),
2572(2460, 456, 'Hasselt', NULL),
2573(2461, 456, 'Zwartsluis', NULL),
2574(2462, 456, 'Genemuiden', NULL),
2575(2463, 456, 'Mastenbroek', NULL),
2576(2464, 457, 'Heerjansdam', NULL),
2577(2465, 457, 'Zwijndrecht', NULL),
2578(2466, 458, 'Zwolle', NULL);
2579
2580-- --------------------------------------------------------
2581
2582--
2583-- Table structure for table `content`
2584--
2585
2586DROP TABLE IF EXISTS `content`;
2587CREATE TABLE `content` (
2588  `id` int(11) UNSIGNED NOT NULL,
2589  `slug` varchar(255) NOT NULL,
2590  `title` varchar(255) NOT NULL,
2591  `content` mediumtext NOT NULL,
2592  `dateUpdated` datetime NOT NULL
2593) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2594
2595--
2596-- Dumping data for table `content`
2597--
2598
2599INSERT INTO `content` (`id`, `slug`, `title`, `content`, `dateUpdated`) VALUES
2600(1, 'cookies', 'Cookies informatie', '<strong>Cookies op burgerzetel.nl</strong>\r\n<br/>\r\nburgerzetel.nl plaatst cookies bij bezoekers. Dat doen we om informatie te\r\nverzamelen over de pagina’s die gebruikers op onze website bezoeken, om bij te\r\nhouden hoe vaak bezoekers terug komen en om te zien welke pagina’s het goed doen\r\nop de website. Ook houden we bij welke informatie de browser deelt.\r\n<br/><br/>\r\n<strong>Cookies uitschakelen</strong>\r\n<br/>\r\nU kunt er voor kiezen om cookies uit te schakelen. Dat doet u door gebruik te\r\nmaken de mogelijkheden van uw browser. U vindt meer informatie over deze\r\nmogelijkheden op de website van de aanbieder van uw browser.\r\n<br/><br/>\r\n<strong>Cookies van derde partijen</strong>\r\n<br/>\r\nHet is mogelijk dat derde partijen, zoals Google, op onze website adverteren of\r\ndat wij gebruik maken van een andere dienst. Daarvoor plaatsen deze derde\r\npartijen in sommige gevallen cookies. Deze cookies zijn niet door burgerzetel.nl\r\nte beïnvloeden.', '2016-11-02 00:00:00'),
2601(2, 'privacy-beleid', 'Privacybeleid', '<strong>1) Waarborgen Privacy</strong>\n<br/>\nHet waarborgen van de privacy van bezoekers van burgerzetel.nl is een belangrijke\ntaak voor ons. Daarom beschrijven we in onze privacy policy welke informatie we\nverzamelen en hoe we deze informatie gebruiken.\n<br/><br/>\n<strong>2) Toestemming</strong>\n<br/>\nDoor de informatie en de diensten op burgerzetel.nl te gebruiken, gaat u akkoord\nmet onze privacy policy en de voorwaarden die wij hierin hebben opgenomen.\n<br/><br/>\n<strong>3) Vragen</strong>\n<br/>\nAls u meer informatie wilt ontvangen, of vragen hebt over de privacy policy van\nBurgerzetel en specifiek burgerzetel.nl, kun u ons benaderen via e-mail. Ons\ne-mailadres is info@burgerzetel.nl.\n<br/><br/>\n<strong>4) Monitoren gedrag bezoeker</strong>\n<br/>\nburgerzetel.nl maakt gebruik van verschillende technieken om bij te houden wie\nde website bezoekt, hoe deze bezoeker zich op de website gedraagt en welke\npagina’s worden bezocht. Dat is een gebruikelijke manier van werken voor websites\nomdat het informatie oplevert op die bijdraagt aan de kwaliteit van de\ngebruikerservaring. De informatie die we, via cookies, registreren, bestaat uit\nonder meer IP-adressen, het type browser en de bezochte pagina’s.\n<br/><br/>\nTevens monitoren we waar bezoekers de website voor het eerst bezoeken en vanaf\nwelke pagina ze vertrekken. Deze informatie houden we anoniem bij en is niet\ngekoppeld aan andere persoonlijke informatie.\n<br/><br/>\n<strong>5) Gebruik van cookies</strong>\n<br/>\nburgerzetel.nl plaatst cookies bij bezoekers. Dat doen we om informatie te\nverzamelen over de pagina’s die gebruikers op onze website bezoeken, om bij te\nhouden hoe vaak bezoekers terug komen en om te zien welke pagina’s het goed doen\nop de website. Ook houden we bij welke informatie de browser deelt.\n<br/><br/>\n<strong>6) Cookies uitschakelen</strong>\n<br/>\nU kunt er voor kiezen om cookies uit te schakelen. Dat doet u door gebruik te\nmaken de mogelijkheden van uw browser. U vindt meer informatie over deze\nmogelijkheden op de website van de aanbieder van uw browser.\n<br/><br/>\n<strong>7) Cookies van derde partijen</strong>\n<br/>\nHet is mogelijk dat derde partijen, zoals Google, op onze website adverteren of\ndat wij gebruik maken van een andere dienst. Daarvoor plaatsen deze derde\npartijen in sommige gevallen cookies. Deze cookies zijn niet door burgerzetel.nl\nte beïnvloeden.', '2016-11-02 00:00:00'),
2602(3, 'media-kit', 'Media Kit', 'Info over de media kit', '2016-11-02 00:00:00'),
2603(4, 'huisregels', 'Huisregels', 'Info over de huisregels', '2016-11-02 00:00:00');
2604
2605-- --------------------------------------------------------
2606
2607--
2608-- Table structure for table `education`
2609--
2610
2611DROP TABLE IF EXISTS `education`;
2612CREATE TABLE `education` (
2613  `id` int(10) UNSIGNED NOT NULL,
2614  `key` varchar(25) NOT NULL,
2615  `value` varchar(255) NOT NULL,
2616  `order` int(11) DEFAULT '0'
2617) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2618
2619--
2620-- Dumping data for table `education`
2621--
2622
2623INSERT INTO `education` (`id`, `key`, `value`, `order`) VALUES
2624(1, 'mavo', 'MAVO/VMBO', 0),
2625(2, 'havo', 'HAVO', 0),
2626(3, 'vwo', 'VWO', 0),
2627(4, 'mbo', 'MBO', 0),
2628(5, 'hbo', 'HBO', 0),
2629(6, 'wo', 'WO', 0);
2630
2631-- --------------------------------------------------------
2632
2633--
2634-- Table structure for table `faq`
2635--
2636
2637DROP TABLE IF EXISTS `faq`;
2638CREATE TABLE `faq` (
2639  `id` int(11) NOT NULL,
2640  `questionId` int(11) NOT NULL,
2641  `category` int(11) NOT NULL DEFAULT '0'
2642) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2643
2644--
2645-- Dumping data for table `faq`
2646--
2647
2648INSERT INTO `faq` (`id`, `questionId`, `category`) VALUES
2649(1, 1, 3);
2650
2651-- --------------------------------------------------------
2652
2653--
2654-- Table structure for table `favorite`
2655--
2656
2657DROP TABLE IF EXISTS `favorite`;
2658CREATE TABLE `favorite` (
2659  `id` int(11) NOT NULL,
2660  `userId` int(10) UNSIGNED NOT NULL,
2661  `questionId` int(11) NOT NULL,
2662  `dateCreated` datetime DEFAULT NULL
2663) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2664
2665--
2666-- Dumping data for table `favorite`
2667--
2668
2669INSERT INTO `favorite` (`id`, `userId`, `questionId`, `dateCreated`) VALUES
2670(1, 1, 1, '2016-11-02 00:00:00'),
2671(2, 1, 1, '2016-11-16 00:00:00');
2672
2673-- --------------------------------------------------------
2674
2675--
2676-- Table structure for table `income`
2677--
2678
2679DROP TABLE IF EXISTS `income`;
2680CREATE TABLE `income` (
2681  `id` int(10) UNSIGNED NOT NULL,
2682  `key` varchar(25) NOT NULL,
2683  `value` varchar(255) NOT NULL,
2684  `order` int(11) DEFAULT '0'
2685) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2686
2687--
2688-- Dumping data for table `income`
2689--
2690
2691INSERT INTO `income` (`id`, `key`, `value`, `order`) VALUES
2692(1, '1500-', 'Minder dan €1500', 0),
2693(2, '1500-2000', '€1500 - €2000', 0),
2694(3, '2000-2500', '€2000 - €2500', 0),
2695(4, '2500-3000', '€2500 - €3000', 0),
2696(5, '3000-3500', '€3000 - €3500', 0),
2697(6, '3500-4000', '€3500 - €4000', 0),
2698(7, '4000-4500', '€4000 - €4500', 0),
2699(8, '4500+', 'Meer dan €4500', 0);
2700
2701-- --------------------------------------------------------
2702
2703--
2704-- Table structure for table `interest`
2705--
2706
2707DROP TABLE IF EXISTS `interest`;
2708CREATE TABLE `interest` (
2709  `id` int(10) UNSIGNED NOT NULL,
2710  `userId` int(11) NOT NULL,
2711  `tagValueId` int(11) NOT NULL,
2712  `points` int(11) NOT NULL,
2713  `hidden` tinyint(1) NOT NULL DEFAULT '1'
2714) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2715
2716--
2717-- Dumping data for table `interest`
2718--
2719
2720INSERT INTO `interest` (`id`, `userId`, `tagValueId`, `points`, `hidden`) VALUES
2721(1, 1, 12, 0, 1),
2722(2, 1, 4, 14, 1),
2723(3, 1, 17, 0, 1),
2724(4, 1, 21, 0, 1);
2725
2726-- --------------------------------------------------------
2727
2728--
2729-- Table structure for table `maritalStatus`
2730--
2731
2732DROP TABLE IF EXISTS `maritalStatus`;
2733CREATE TABLE `maritalStatus` (
2734  `id` int(10) UNSIGNED NOT NULL,
2735  `key` varchar(25) NOT NULL,
2736  `value` varchar(255) NOT NULL,
2737  `order` int(11) DEFAULT '0'
2738) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2739
2740--
2741-- Dumping data for table `maritalStatus`
2742--
2743
2744INSERT INTO `maritalStatus` (`id`, `key`, `value`, `order`) VALUES
2745(1, 'ongehuwd', 'Ongehuwd', 0),
2746(2, 'gehuwd', 'Wettig gehuwd', 0),
2747(3, 'partnerschap', 'Partnerschap', 0),
2748(4, 'verweduwdhuwelijk', 'Verweduwd na wettig huwelijk', 0),
2749(5, 'verweduwdpartnerschap', 'Verweduwd na partnerschap', 0),
2750(6, 'gescheidenhuwelijk', 'Gescheiden na wettig huwelijk', 0),
2751(7, 'gescheidenpartnerschap', 'Gescheiden na partnerschap', 0);
2752
2753-- --------------------------------------------------------
2754
2755--
2756-- Table structure for table `mediumType`
2757--
2758
2759DROP TABLE IF EXISTS `mediumType`;
2760CREATE TABLE `mediumType` (
2761  `id` int(10) UNSIGNED NOT NULL,
2762  `key` varchar(25) NOT NULL,
2763  `value` varchar(255) NOT NULL
2764) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2765
2766--
2767-- Dumping data for table `mediumType`
2768--
2769
2770INSERT INTO `mediumType` (`id`, `key`, `value`) VALUES
2771(1, 'link', 'link'),
2772(2, 'video', 'video'),
2773(3, 'pdf', 'pdf'),
2774(4, '`img`', 'afbeelding');
2775
2776-- --------------------------------------------------------
2777
2778--
2779-- Table structure for table `milestone`
2780--
2781
2782DROP TABLE IF EXISTS `milestone`;
2783CREATE TABLE `milestone` (
2784  `id` int(10) UNSIGNED NOT NULL,
2785  `milestoneTypeId` int(11) DEFAULT NULL,
2786  `userId` int(10) UNSIGNED NOT NULL,
2787  `total` int(11) DEFAULT NULL,
2788  `hidden` tinyint(1) DEFAULT '0',
2789  `dateFirst` datetime DEFAULT NULL,
2790  `dateLast` datetime DEFAULT NULL
2791) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2792
2793--
2794-- Dumping data for table `milestone`
2795--
2796
2797INSERT INTO `milestone` (`id`, `milestoneTypeId`, `userId`, `total`, `hidden`, `dateFirst`, `dateLast`) VALUES
2798(1, 3, 1, 12, 0, '2016-11-09 00:00:00', '2016-11-03 00:00:00'),
2799(2, 12, 1, 2, 0, '2016-11-08 00:00:00', '2016-11-03 00:00:00'),
2800(3, 2, 2, 35, 0, '2016-11-15 00:00:00', '2016-11-16 00:00:00'),
2801(4, 3, 2, 35, 0, '2016-11-15 00:00:00', '2016-11-16 00:00:00'),
2802(5, 4, 2, 35, 0, '2016-11-15 00:00:00', '2016-11-16 00:00:00');
2803
2804-- --------------------------------------------------------
2805
2806--
2807-- Table structure for table `milestoneType`
2808--
2809
2810DROP TABLE IF EXISTS `milestoneType`;
2811CREATE TABLE `milestoneType` (
2812  `id` int(10) UNSIGNED NOT NULL,
2813  `key` varchar(25) NOT NULL,
2814  `value` varchar(255) NOT NULL,
2815  `number` int(11) NOT NULL DEFAULT '0',
2816  `reward` int(11) DEFAULT '0',
2817  `hidden` tinyint(1) DEFAULT '0'
2818) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2819
2820--
2821-- Dumping data for table `milestoneType`
2822--
2823
2824INSERT INTO `milestoneType` (`id`, `key`, `value`, `number`, `reward`, `hidden`) VALUES
2825(1, 'profile', 'Profiel volledig ingevuld', 1, 10, 0),
2826(2, '5shares', '5x Een pagina gedeeld', 5, 25, 0),
2827(3, '10shares', '10x Een pagina gedeeld', 10, 50, 0),
2828(4, '25shares', '25x Een pagina gedeeld', 25, 100, 0),
2829(5, '3invites', '5 Vrienden uitgenodigd', 5, 25, 0),
2830(6, '10invites', '10 Vrienden uitgenodigd', 10, 50, 0),
2831(7, '25invites', '25 Vrienden uitgenodigd', 25, 100, 0),
2832(8, '5answers', '5 Antwoorden gegeven', 5, 10, 0),
2833(9, '10answers', '10 Antwoorden gegeven', 10, 25, 0),
2834(10, '25answers', '25 Antwoorden gegeven', 25, 50, 0),
2835(11, '50answers', '50 Antwoorden gegeven', 50, 75, 0),
2836(12, '100answers', '100 Antwoorden gegeven', 100, 100, 0),
2837(13, '250answers', '250 Antwoorden gegeven', 250, 250, 0),
2838(14, '5questions', '5 Vragen gesteld', 5, 10, 0),
2839(15, '10questions', '10 Vragen gesteld', 10, 25, 0),
2840(16, '25questions', '25 Vragen gesteld', 25, 50, 0),
2841(17, '50questions', '50 Vragen gesteld', 50, 75, 0),
2842(18, '100questions', '100 Vragen gesteld', 100, 100, 0),
2843(19, '250questions', '250 Vragen gesteld', 250, 250, 0),
2844(20, '10reactions', '10 Reacties geplaatst', 10, 10, 0),
2845(21, '50reactions', '50 Reacties geplaatst', 50, 25, 0),
2846(22, '100reactions', '100 Reacties geplaatst', 100, 50, 0),
2847(23, '5received', 'Gefeliciteerd! U bent 5x gevraagd een vraag te beantwoorden', 5, 10, 1),
2848(24, '25received', 'Gefeliciteerd! U bent 25x gevraagd om een vraag te beantwoorden.', 25, 25, 1),
2849(25, '50received', 'Gefeliciteerd! U bent 50x gevraagd om een vraag te beantwoorden.', 50, 50, 1),
2850(26, '500gift', 'Gefeliciteerd! U heeft een bronzen bagde verdient.', 0, 0, 1),
2851(27, '1000gift', 'Gefeliciteerd! U heeft een zilveren bagde verdient.', 0, 0, 1),
2852(28, '5000gift', 'Gefeliciteerd! U heeft een gouden bagde verdient.', 0, 0, 1);
2853
2854-- --------------------------------------------------------
2855
2856--
2857-- Table structure for table `municipality`
2858--
2859
2860DROP TABLE IF EXISTS `municipality`;
2861CREATE TABLE `municipality` (
2862  `id` int(10) UNSIGNED NOT NULL,
2863  `provinceId` int(10) UNSIGNED NOT NULL,
2864  `name` varchar(255) NOT NULL,
2865  `img` varchar(255) DEFAULT NULL,
2866  `pageId` int(11) DEFAULT NULL
2867) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2868
2869--
2870-- Dumping data for table `municipality`
2871--
2872
2873INSERT INTO `municipality` (`id`, `provinceId`, `name`, `img`, `pageId`) VALUES
2874(1, 1, 'Aa en Hunze', NULL, NULL),
2875(2, 2, 'Aalburg', NULL, NULL),
2876(3, 8, 'Aalsmeer', NULL, NULL),
2877(4, 3, 'Aalten', NULL, NULL),
2878(5, 4, 'Abcoude', NULL, NULL),
2879(6, 5, 'Achtkarspelen', NULL, NULL),
2880(7, 6, 'Alblasserdam', NULL, NULL),
2881(8, 6, 'Albrandswaard', NULL, NULL),
2882(9, 6, 'Alkemade', NULL, NULL),
2883(10, 8, 'Alkmaar', NULL, NULL),
2884(11, 11, 'Almelo', NULL, NULL),
2885(12, 12, 'Almere', NULL, NULL),
2886(13, 6, 'Alphen Aan Den Rijn', NULL, NULL),
2887(14, 2, 'Alphen Chaam', NULL, NULL),
2888(15, 7, 'Ambt Montfort', NULL, NULL),
2889(16, 5, 'Ameland', NULL, NULL),
2890(17, 4, 'Amersfoort', NULL, NULL),
2891(18, 8, 'Amstelveen', NULL, NULL),
2892(19, 8, 'Amsterdam', NULL, NULL),
2893(20, 8, 'Andijk', NULL, NULL),
2894(21, 8, 'Anna Paulowna', NULL, NULL),
2895(22, 3, 'Apeldoorn', NULL, NULL),
2896(23, 9, 'Appingedam', NULL, NULL),
2897(24, 7, 'Arcen en Velden', NULL, NULL),
2898(25, 3, 'Arnhem', NULL, NULL),
2899(26, 1, 'Assen', NULL, NULL),
2900(27, 2, 'Asten', NULL, NULL),
2901(28, 2, 'Baarle Nassau', NULL, NULL),
2902(29, 4, 'Baarn', NULL, NULL),
2903(30, 6, 'Barendrecht', NULL, NULL),
2904(31, 3, 'Barneveld', NULL, NULL),
2905(32, 9, 'Bedum', NULL, NULL),
2906(33, 7, 'Beek', NULL, NULL),
2907(34, 8, 'Beemster', NULL, NULL),
2908(35, 7, 'Beesel', NULL, NULL),
2909(36, 9, 'Bellingwedde', NULL, NULL),
2910(37, 8, 'Bennebroek', NULL, NULL),
2911(38, 6, 'Bergambacht', NULL, NULL),
2912(39, 2, 'Bergeijk', NULL, NULL),
2913(40, 7, 'Bergen (LB)', NULL, NULL),
2914(41, 8, 'Bergen (NH)', NULL, NULL),
2915(42, 2, 'Bergen op Zoom', NULL, NULL),
2916(43, 6, 'Bergschenhoek', NULL, NULL),
2917(44, 6, 'Berkel en Rodenrijs', NULL, NULL),
2918(45, 3, 'Berkelland', NULL, NULL),
2919(46, 2, 'Bernheze', NULL, NULL),
2920(47, 6, 'Bernisse', NULL, NULL),
2921(48, 2, 'Best', NULL, NULL),
2922(49, 3, 'Beuningen', NULL, NULL),
2923(50, 8, 'Beverwijk', NULL, NULL),
2924(51, 6, 'Binnenmaas', NULL, NULL),
2925(52, 2, 'Bladel', NULL, NULL),
2926(53, 8, 'Blaricum', NULL, NULL),
2927(54, 6, 'Bleiswijk', NULL, NULL),
2928(55, 8, 'Bloemendaal', NULL, NULL),
2929(56, 5, 'Boarnsterhim', NULL, NULL),
2930(57, 6, 'Bodegraven', NULL, NULL),
2931(58, 2, 'Boekel', NULL, NULL),
2932(59, 5, 'Bolsward', NULL, NULL),
2933(60, 1, 'Borger Odoorn', NULL, NULL),
2934(61, 11, 'Borne', NULL, NULL),
2935(62, 10, 'Borsele', NULL, NULL),
2936(63, 6, 'Boskoop', NULL, NULL),
2937(64, 2, 'Boxmeer', NULL, NULL),
2938(65, 2, 'Boxtel', NULL, NULL),
2939(66, 2, 'Breda', NULL, NULL),
2940(67, 4, 'Breukelen', NULL, NULL),
2941(68, 6, 'Brielle', NULL, NULL),
2942(69, 3, 'Bronckhorst', NULL, NULL),
2943(70, 3, 'Brummen', NULL, NULL),
2944(71, 7, 'Brunssum', NULL, NULL),
2945(72, 4, 'Bunnik', NULL, NULL),
2946(73, 4, 'Bunschoten', NULL, NULL),
2947(74, 3, 'Buren', NULL, NULL),
2948(75, 8, 'Bussum', NULL, NULL),
2949(76, 6, 'Capelle aan den IJssel', NULL, NULL),
2950(77, 8, 'Castricum', NULL, NULL),
2951(78, 1, 'Coevorden', NULL, NULL),
2952(79, 2, 'Cranendonck', NULL, NULL),
2953(80, 6, 'Cromstrijen', NULL, NULL),
2954(81, 2, 'Cuijk', NULL, NULL),
2955(82, 3, 'Culemborg', NULL, NULL),
2956(83, 11, 'Dalfsen', NULL, NULL),
2957(84, 5, 'Dantumadeel', NULL, NULL),
2958(85, 4, 'De Bilt', NULL, NULL),
2959(86, 9, 'De Marne', NULL, NULL),
2960(87, 4, 'De Ronde Venen', NULL, NULL),
2961(88, 1, 'De Wolden', NULL, NULL),
2962(89, 6, 'Delft', NULL, NULL),
2963(90, 9, 'Delfzijl', NULL, NULL),
2964(91, 8, 'Den Helder', NULL, NULL),
2965(92, 2, 'Deurne', NULL, NULL),
2966(93, 11, 'Deventer', NULL, NULL),
2967(94, 8, 'Diemen', NULL, NULL),
2968(95, 11, 'Dinkelland', NULL, NULL),
2969(96, 6, 'Dirksland', NULL, NULL),
2970(97, 3, 'Doesburg', NULL, NULL),
2971(98, 3, 'Doetinchem', NULL, NULL),
2972(99, 2, 'Dongen', NULL, NULL),
2973(100, 5, 'Dongeradeel', NULL, NULL),
2974(101, 6, 'Dordrecht', NULL, NULL),
2975(102, 8, 'Drechterland', NULL, NULL),
2976(103, 2, 'Drimmelen', NULL, NULL),
2977(104, 12, 'Dronten', NULL, NULL),
2978(105, 3, 'Druten', NULL, NULL),
2979(106, 3, 'Duiven', NULL, NULL),
2980(107, 7, 'Echt Susteren', NULL, NULL),
2981(108, 8, 'Edam Volendam', NULL, NULL),
2982(109, 3, 'Ede', NULL, NULL),
2983(110, 4, 'Eemnes', NULL, NULL),
2984(111, 9, 'Eemsmond', NULL, NULL),
2985(112, 2, 'Eersel', NULL, NULL),
2986(113, 7, 'Eijsden', NULL, NULL),
2987(114, 2, 'Eindhoven', NULL, NULL),
2988(115, 3, 'Elburg', NULL, NULL),
2989(116, 1, 'Emmen', NULL, NULL),
2990(117, 8, 'Enkhuizen', NULL, NULL),
2991(118, 11, 'Enschede', NULL, NULL),
2992(119, 3, 'Epe', NULL, NULL),
2993(120, 3, 'Ermelo', NULL, NULL),
2994(121, 2, 'Etten Leur', NULL, NULL),
2995(122, 5, 'Ferwerderadiel', NULL, NULL),
2996(123, 5, 'Franekeradeel', NULL, NULL),
2997(124, 5, 'Gaasterlan Sleat', NULL, NULL),
2998(125, 2, 'Geertruidenberg', NULL, NULL),
2999(126, 3, 'Geldermalsen', NULL, NULL),
3000(127, 2, 'Geldrop Mierlo', NULL, NULL),
3001(128, 2, 'Gemert Bakel', NULL, NULL),
3002(129, 7, 'Gennep', NULL, NULL),
3003(130, 6, 'Giessenlanden', NULL, NULL),
3004(131, 2, 'Gilze en Rijen', NULL, NULL),
3005(132, 6, 'Goedereede', NULL, NULL),
3006(133, 10, 'Goes', NULL, NULL),
3007(134, 2, 'Goirle', NULL, NULL),
3008(135, 6, 'Gorinchem', NULL, NULL),
3009(136, 6, 'Gouda', NULL, NULL),
3010(137, 6, 'Graafstroom', NULL, NULL),
3011(138, 8, 'Graft De Rijp', NULL, NULL),
3012(139, 2, 'Grave', NULL, NULL),
3013(140, 3, 'Groenlo', NULL, NULL),
3014(141, 3, 'Groesbeek', NULL, NULL),
3015(142, 9, 'Groningen', NULL, NULL),
3016(143, 9, 'Grootegast', NULL, NULL),
3017(144, 7, 'Gulpen Wittem', NULL, NULL),
3018(145, 11, 'Haaksbergen', NULL, NULL),
3019(146, 2, 'Haaren', NULL, NULL),
3020(147, 8, 'Haarlem', NULL, NULL),
3021(148, 8, 'Haarlemmerliede en Spaarnwoude', NULL, NULL),
3022(149, 8, 'Haarlemmermeer', NULL, NULL),
3023(150, 7, 'Haelen', NULL, NULL),
3024(151, 2, 'Halderberge', NULL, NULL),
3025(152, 11, 'Hardenberg', NULL, NULL),
3026(153, 3, 'Harderwijk', NULL, NULL),
3027(154, 6, 'Hardinxveld Giessendam', NULL, NULL),
3028(155, 9, 'Haren', NULL, NULL),
3029(156, 8, 'Harenkarpsel', NULL, NULL),
3030(157, 5, 'Harlingen', NULL, NULL),
3031(158, 3, 'Hattem', NULL, NULL),
3032(159, 7, 'Heel', NULL, NULL),
3033(160, 8, 'Heemskerk', NULL, NULL),
3034(161, 8, 'Heemstede', NULL, NULL),
3035(162, 3, 'Heerde', NULL, NULL),
3036(163, 5, 'Heerenveen', NULL, NULL),
3037(164, 8, 'Heerhugowaard', NULL, NULL),
3038(165, 7, 'Heerlen', NULL, NULL),
3039(166, 2, 'Heeze Leende', NULL, NULL),
3040(167, 8, 'Heiloo', NULL, NULL),
3041(168, 7, 'Helden', NULL, NULL),
3042(169, 11, 'Hellendoorn', NULL, NULL),
3043(170, 6, 'Hellevoetsluis', NULL, NULL),
3044(171, 2, 'Helmond', NULL, NULL),
3045(172, 6, 'Hendrik Ido Ambacht', NULL, NULL),
3046(173, 11, 'Hengelo (OV)', NULL, NULL),
3047(174, 5, 'Het Bildt', NULL, NULL),
3048(175, 3, 'Heumen', NULL, NULL),
3049(176, 2, 'Heusden', NULL, NULL),
3050(177, 7, 'Heythuysen', NULL, NULL),
3051(178, 6, 'Hillegom', NULL, NULL),
3052(179, 2, 'Hilvarenbeek', NULL, NULL),
3053(180, 8, 'Hilversum', NULL, NULL),
3054(181, 11, 'Hof Van Twente', NULL, NULL),
3055(182, 1, 'Hoogeveen', NULL, NULL),
3056(183, 9, 'Hoogezand Sappemeer', NULL, NULL),
3057(184, 8, 'Hoorn', NULL, NULL),
3058(185, 7, 'Horst aan de Maas', NULL, NULL),
3059(186, 4, 'Houten', NULL, NULL),
3060(187, 8, 'Huizen', NULL, NULL),
3061(188, 10, 'Hulst', NULL, NULL),
3062(189, 7, 'Hunsel', NULL, NULL),
3063(190, 4, 'IJsselstein', NULL, NULL),
3064(191, 6, 'Jacobswoude', NULL, NULL),
3065(192, 11, 'Kampen', NULL, NULL),
3066(193, 10, 'Kapelle', NULL, NULL),
3067(194, 6, 'Katwijk', NULL, NULL),
3068(195, 7, 'Kerkrade', NULL, NULL),
3069(196, 7, 'Kessel', NULL, NULL),
3070(197, 5, 'Kollumerland en Nieuwkruisland', NULL, NULL),
3071(198, 6, 'Korendijk', NULL, NULL),
3072(199, 6, 'Krimpen aan den IJssel', NULL, NULL),
3073(200, 2, 'Laarbeek', NULL, NULL),
3074(201, 2, 'Landerd', NULL, NULL),
3075(202, 7, 'Landgraaf', NULL, NULL),
3076(203, 8, 'Landsmeer', NULL, NULL),
3077(204, 8, 'Langedijk', NULL, NULL),
3078(205, 8, 'Laren', NULL, NULL),
3079(206, 9, 'Leek', NULL, NULL),
3080(207, 6, 'Leerdam', NULL, NULL),
3081(208, 5, 'Leeuwarden', NULL, NULL),
3082(209, 5, 'Leeuwarderadeel', NULL, NULL),
3083(210, 6, 'Leiden', NULL, NULL),
3084(211, 6, 'Leiderdorp', NULL, NULL),
3085(212, 6, 'Leidschendam Voorburg', NULL, NULL),
3086(213, 12, 'Lelystad', NULL, NULL),
3087(214, 5, 'Lemsterland', NULL, NULL),
3088(215, 4, 'Leusden', NULL, NULL),
3089(216, 6, 'Liemeer', NULL, NULL),
3090(217, 6, 'Liesveld', NULL, NULL),
3091(218, 3, 'Lingewaal', NULL, NULL),
3092(219, 3, 'Lingewaard', NULL, NULL),
3093(220, 6, 'Lisse', NULL, NULL),
3094(221, 2, 'Lith', NULL, NULL),
3095(222, 5, 'Littenseradiel', NULL, NULL),
3096(223, 3, 'Lochem', NULL, NULL),
3097(224, 4, 'Loenen', NULL, NULL),
3098(225, 2, 'Loon Op Zand', NULL, NULL),
3099(226, 4, 'Lopik', NULL, NULL),
3100(227, 9, 'Loppersum', NULL, NULL),
3101(228, 11, 'Losser', NULL, NULL),
3102(229, 4, 'Maarssen', NULL, NULL),
3103(230, 7, 'Maasbracht', NULL, NULL),
3104(231, 7, 'Maasbree', NULL, NULL),
3105(232, 2, 'Maasdonk', NULL, NULL),
3106(233, 3, 'Maasdriel', NULL, NULL),
3107(234, 6, 'Maassluis', NULL, NULL),
3108(235, 7, 'Maastricht', NULL, NULL),
3109(236, 7, 'Margraten', NULL, NULL),
3110(237, 9, 'Marum', NULL, NULL),
3111(238, 8, 'Medemblik', NULL, NULL),
3112(239, 7, 'Meerlo Wanssum', NULL, NULL),
3113(240, 7, 'Meerssen', NULL, NULL),
3114(241, 7, 'Meijel', NULL, NULL),
3115(242, 5, 'Menaldumadeel', NULL, NULL),
3116(243, 9, 'Menterwolde', NULL, NULL),
3117(244, 1, 'Meppel', NULL, NULL),
3118(245, 10, 'Middelburg', NULL, NULL),
3119(246, 6, 'Middelharnis', NULL, NULL),
3120(247, 6, 'Midden Delfland', NULL, NULL),
3121(248, 1, 'Midden Drenthe', NULL, NULL),
3122(249, 2, 'Mill en Sint Hubert', NULL, NULL),
3123(250, 3, 'Millingen aan de Rijn', NULL, NULL),
3124(251, 2, 'Moerdijk', NULL, NULL),
3125(252, 3, 'Montferland', NULL, NULL),
3126(253, 4, 'Montfoort', NULL, NULL),
3127(254, 7, 'Mook en Middelaar', NULL, NULL),
3128(255, 6, 'Moordrecht', NULL, NULL),
3129(256, 8, 'Muiden', NULL, NULL),
3130(257, 8, 'Naarden', NULL, NULL),
3131(258, 3, 'Neder Betuwe', NULL, NULL),
3132(259, 6, 'Nederlek', NULL, NULL),
3133(260, 7, 'Nederweert', NULL, NULL),
3134(261, 3, 'Neerijnen', NULL, NULL),
3135(262, 8, 'Niedorp', NULL, NULL),
3136(263, 6, 'Nieuw Lekkerland', NULL, NULL),
3137(264, 4, 'Nieuwegein', NULL, NULL),
3138(265, 6, 'Nieuwerkerk aan den IJssel', NULL, NULL),
3139(266, 6, 'Nieuwkoop', NULL, NULL),
3140(267, 5, 'Nijefurd', NULL, NULL),
3141(268, 3, 'Nijkerk', NULL, NULL),
3142(269, 3, 'Nijmegen', NULL, NULL),
3143(270, 10, 'Noord Beveland', NULL, NULL),
3144(271, 1, 'Noordenveld', NULL, NULL),
3145(272, 8, 'Noorder Koggenland', NULL, NULL),
3146(273, 12, 'Noordoostpolder', NULL, NULL),
3147(274, 6, 'Noordwijk', NULL, NULL),
3148(275, 6, 'Noordwijkerhout', NULL, NULL),
3149(276, 2, 'Nuenen', NULL, NULL),
3150(277, 3, 'Nunspeet', NULL, NULL),
3151(278, 7, 'Nuth', NULL, NULL),
3152(279, 8, 'Obdam', NULL, NULL),
3153(280, 6, 'Oegstgeest', NULL, NULL),
3154(281, 2, 'Oirschot', NULL, NULL),
3155(282, 2, 'Oisterwijk', NULL, NULL),
3156(283, 3, 'Oldebroek', NULL, NULL),
3157(284, 11, 'Oldenzaal', NULL, NULL),
3158(285, 11, 'Olst Wijhe', NULL, NULL),
3159(286, 11, 'Ommen', NULL, NULL),
3160(287, 7, 'Onderbanken', NULL, NULL),
3161(288, 2, 'Oosterhout', NULL, NULL),
3162(289, 6, 'Oostflakkee', NULL, NULL),
3163(290, 5, 'Ooststellingwerf', NULL, NULL),
3164(291, 8, 'Oostzaan', NULL, NULL),
3165(292, 8, 'Opmeer', NULL, NULL),
3166(293, 5, 'Opsterland', NULL, NULL),
3167(294, 2, 'Oss', NULL, NULL),
3168(295, 6, 'Oud Beijerland', NULL, NULL),
3169(296, 3, 'Oude IJsselstreek', NULL, NULL),
3170(297, 8, 'Ouder Amstel', NULL, NULL),
3171(298, 6, 'Ouderkerk', NULL, NULL),
3172(299, 4, 'Oudewater', NULL, NULL),
3173(300, 3, 'Overbetuwe', NULL, NULL),
3174(301, 6, 'Papendrecht', NULL, NULL),
3175(302, 9, 'Pekela', NULL, NULL),
3176(303, 6, 'Pijnacker Nootdorp', NULL, NULL),
3177(304, 8, 'Purmerend', NULL, NULL),
3178(305, 3, 'Putten', NULL, NULL),
3179(306, 11, 'Raalte', NULL, NULL),
3180(307, 6, 'Reeuwijk', NULL, NULL),
3181(308, 9, 'Reiderland', NULL, NULL),
3182(309, 10, 'Reimerswaal', NULL, NULL),
3183(310, 3, 'Renkum', NULL, NULL),
3184(311, 4, 'Renswoude', NULL, NULL),
3185(312, 2, 'Reusel de Mierden', NULL, NULL),
3186(313, 3, 'Rheden', NULL, NULL),
3187(314, 4, 'Rhenen', NULL, NULL),
3188(315, 6, 'Ridderkerk', NULL, NULL),
3189(316, 3, 'Rijnwaarden', NULL, NULL),
3190(317, 6, 'Rijnwoude', NULL, NULL),
3191(318, 11, 'Rijssen Holten', NULL, NULL),
3192(319, 6, 'Rijswijk', NULL, NULL),
3193(320, 7, 'Roerdalen', NULL, NULL),
3194(321, 7, 'Roermond', NULL, NULL),
3195(322, 7, 'Roggel en Neer', NULL, NULL),
3196(323, 2, 'Roosendaal', NULL, NULL),
3197(324, 6, 'Rotterdam', NULL, NULL),
3198(325, 6, 'Rozenburg', NULL, NULL),
3199(326, 3, 'Rozendaal', NULL, NULL),
3200(327, 2, 'Rucphen', NULL, NULL),
3201(328, 6, 's Gravendeel', NULL, NULL),
3202(329, 6, 's Gravenhage', NULL, NULL),
3203(330, 2, 's Hertogenbosch', NULL, NULL),
3204(331, 8, 'Schagen', NULL, NULL),
3205(332, 9, 'Scheemda', NULL, NULL),
3206(333, 8, 'Schermer', NULL, NULL),
3207(334, 3, 'Scherpenzeel', NULL, NULL),
3208(335, 6, 'Schiedam', NULL, NULL),
3209(336, 5, 'Schiermonnikoog', NULL, NULL),
3210(337, 2, 'Schijndel', NULL, NULL),
3211(338, 7, 'Schinnen', NULL, NULL),
3212(339, 6, 'Schoonhoven', NULL, NULL),
3213(340, 10, 'Schouwen Duiveland', NULL, NULL),
3214(341, 7, 'Sevenum', NULL, NULL),
3215(342, 7, 'Simpelveld', NULL, NULL),
3216(343, 2, 'Sint Anthonis', NULL, NULL),
3217(344, 2, 'Sint Michielsgestel', NULL, NULL),
3218(345, 2, 'Sint Oedenrode', NULL, NULL),
3219(346, 7, 'Sittard Geleen', NULL, NULL),
3220(347, 5, 'Skarsterlan', NULL, NULL),
3221(348, 6, 'Sliedrecht', NULL, NULL),
3222(349, 9, 'Slochteren', NULL, NULL),
3223(350, 10, 'Sluis', NULL, NULL),
3224(351, 5, 'Smallingerland', NULL, NULL),
3225(352, 5, 'Sneek', NULL, NULL),
3226(353, 4, 'Soest', NULL, NULL),
3227(354, 2, 'Someren', NULL, NULL),
3228(355, 2, 'Son en Breugel', NULL, NULL),
3229(356, 6, 'Spijkenisse', NULL, NULL),
3230(357, 9, 'Stadskanaal', NULL, NULL),
3231(358, 11, 'Staphorst', NULL, NULL),
3232(359, 8, 'Stede Broec', NULL, NULL),
3233(360, 2, 'Steenbergen', NULL, NULL),
3234(361, 11, 'Steenwijkerland', NULL, NULL),
3235(362, 7, 'Stein', NULL, NULL),
3236(363, 6, 'Strijen', NULL, NULL),
3237(364, 7, 'Swalmen', NULL, NULL),
3238(365, 9, 'Ten Boer', NULL, NULL),
3239(366, 6, 'Ter Aar', NULL, NULL),
3240(367, 10, 'Terneuzen', NULL, NULL),
3241(368, 5, 'Terschelling', NULL, NULL),
3242(369, 8, 'Texel', NULL, NULL),
3243(370, 6, 'Teylingen', NULL, NULL),
3244(371, 10, 'Tholen', NULL, NULL),
3245(372, 7, 'Thorn', NULL, NULL),
3246(373, 3, 'Tiel', NULL, NULL),
3247(374, 2, 'Tilburg', NULL, NULL),
3248(375, 11, 'Tubbergen', NULL, NULL),
3249(376, 11, 'Twenterand', NULL, NULL),
3250(377, 1, 'Tynaarlo', NULL, NULL),
3251(378, 5, 'Tytsjerksteradiel', NULL, NULL),
3252(379, 3, 'Ubbergen', NULL, NULL),
3253(380, 2, 'Uden', NULL, NULL),
3254(381, 8, 'Uitgeest', NULL, NULL),
3255(382, 8, 'Uithoorn', NULL, NULL),
3256(383, 12, 'Urk', NULL, NULL),
3257(384, 4, 'Utrecht', NULL, NULL),
3258(385, 4, 'Utrechtse Heuvelrug', NULL, NULL),
3259(386, 7, 'Vaals', NULL, NULL),
3260(387, 7, 'Valkenburg aan de Geul', NULL, NULL),
3261(388, 2, 'Valkenswaard', NULL, NULL),
3262(389, 9, 'Veendam', NULL, NULL),
3263(390, 4, 'Veenendaal', NULL, NULL),
3264(391, 10, 'Veere', NULL, NULL),
3265(392, 2, 'Veghel', NULL, NULL),
3266(393, 2, 'Veldhoven', NULL, NULL),
3267(394, 8, 'Velsen', NULL, NULL),
3268(395, 7, 'Venlo', NULL, NULL),
3269(396, 7, 'Venray', NULL, NULL),
3270(397, 4, 'Vianen', NULL, NULL),
3271(398, 6, 'Vlaardingen', NULL, NULL),
3272(399, 9, 'Vlagtwedde', NULL, NULL),
3273(400, 5, 'Vlieland', NULL, NULL),
3274(401, 10, 'Vlissingen', NULL, NULL),
3275(402, 6, 'Vlist', NULL, NULL),
3276(403, 7, 'Voerendaal', NULL, NULL),
3277(404, 6, 'Voorschoten', NULL, NULL),
3278(405, 3, 'Voorst', NULL, NULL),
3279(406, 2, 'Vught', NULL, NULL),
3280(407, 2, 'Waalre', NULL, NULL),
3281(408, 2, 'Waalwijk', NULL, NULL),
3282(409, 6, 'Waddinxveen', NULL, NULL),
3283(410, 3, 'Wageningen', NULL, NULL),
3284(411, 6, 'Wassenaar', NULL, NULL),
3285(412, 8, 'Waterland', NULL, NULL),
3286(413, 7, 'Weert', NULL, NULL),
3287(414, 8, 'Weesp', NULL, NULL),
3288(415, 2, 'Werkendam', NULL, NULL),
3289(416, 8, 'Wervershoof', NULL, NULL),
3290(417, 3, 'West Maas en Waal', NULL, NULL),
3291(418, 8, 'Wester Koggenland', NULL, NULL),
3292(419, 1, 'Westerveld', NULL, NULL),
3293(420, 3, 'Westervoort', NULL, NULL),
3294(421, 6, 'Westland', NULL, NULL),
3295(422, 5, 'Weststellingwerf', NULL, NULL),
3296(423, 6, 'Westvoorne', NULL, NULL),
3297(424, 11, 'Wierden', NULL, NULL),
3298(425, 8, 'Wieringen', NULL, NULL),
3299(426, 8, 'Wieringermeer', NULL, NULL),
3300(427, 3, 'Wijchen', NULL, NULL),
3301(428, 8, 'Wijdemeren', NULL, NULL),
3302(429, 4, 'Wijk bij Duurstede', NULL, NULL),
3303(430, 9, 'Winschoten', NULL, NULL),
3304(431, 9, 'Winsum', NULL, NULL),
3305(432, 3, 'Winterswijk', NULL, NULL),
3306(433, 2, 'Woensdrecht', NULL, NULL),
3307(434, 4, 'Woerden', NULL, NULL),
3308(435, 8, 'Wognum', NULL, NULL),
3309(436, 8, 'Wormerland', NULL, NULL),
3310(437, 4, 'Woudenberg', NULL, NULL),
3311(438, 2, 'Woudrichem', NULL, NULL),
3312(439, 5, 'Wunseradiel', NULL, NULL),
3313(440, 5, 'Wymbritseradiel', NULL, NULL),
3314(441, 8, 'Zaanstad', NULL, NULL),
3315(442, 3, 'Zaltbommel', NULL, NULL),
3316(443, 8, 'Zandvoort', NULL, NULL),
3317(444, 6, 'Zederik', NULL, NULL),
3318(445, 8, 'Zeevang', NULL, NULL),
3319(446, 12, 'Zeewolde', NULL, NULL),
3320(447, 4, 'Zeist', NULL, NULL),
3321(448, 3, 'Zevenaar', NULL, NULL),
3322(449, 6, 'Zevenhuizen Moerkapelle', NULL, NULL),
3323(450, 8, 'Zijpe', NULL, NULL),
3324(451, 6, 'Zoetermeer', NULL, NULL),
3325(452, 6, 'Zoeterwoude', NULL, NULL),
3326(453, 9, 'Zuidhorn', NULL, NULL),
3327(454, 2, 'Zundert', NULL, NULL),
3328(455, 3, 'Zutphen', NULL, NULL),
3329(456, 11, 'Zwartewaterland', NULL, NULL),
3330(457, 6, 'Zwijndrecht', NULL, NULL),
3331(458, 11, 'Zwolle', NULL, NULL);
3332
3333-- --------------------------------------------------------
3334
3335--
3336-- Table structure for table `notification`
3337--
3338
3339DROP TABLE IF EXISTS `notification`;
3340CREATE TABLE `notification` (
3341  `id` int(11) NOT NULL,
3342  `notificationTypeId` int(10) UNSIGNED NOT NULL,
3343  `questionId` int(11) NOT NULL DEFAULT '0',
3344  `answerId` int(11) NOT NULL DEFAULT '0',
3345  `reactionId` int(11) UNSIGNED NOT NULL,
3346  `replyId` int(11) UNSIGNED NOT NULL,
3347  `userId` int(10) UNSIGNED NOT NULL,
3348  `askedBy` int(11) NOT NULL,
3349  `status` int(11) DEFAULT '0',
3350  `dateCreated` datetime DEFAULT NULL
3351) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3352
3353-- --------------------------------------------------------
3354
3355--
3356-- Table structure for table `notificationType`
3357--
3358
3359DROP TABLE IF EXISTS `notificationType`;
3360CREATE TABLE `notificationType` (
3361  `id` int(10) UNSIGNED NOT NULL,
3362  `key` varchar(25) NOT NULL,
3363  `value` varchar(255) NOT NULL
3364) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3365
3366--
3367-- Dumping data for table `notificationType`
3368--
3369
3370INSERT INTO `notificationType` (`id`, `key`, `value`) VALUES
3371(1, 'newAnswer', 'heeft uw vraag beantwoord.'),
3372(2, 'newCommentAnswer', 'heeft gereageerd op uw antwoord.'),
3373(3, 'newReplyComment', 'heeft gereageerd op uw reactie.'),
3374(4, 'newRequest', 'heeft u gevraagd om een vraag te beantwoorden.'),
3375(5, 'deletedAnswer', 'Uw antwoord is door de community verwijderd.'),
3376(6, 'deletedComment', 'Uw reactie is door de community verwijderd.'),
3377(7, 'deletedQuestion', 'Uw vraag is door de community verwijderd.'),
3378(8, 'deletedReply', 'Uw reactie is door de community verwijderd.');
3379
3380-- --------------------------------------------------------
3381
3382--
3383-- Table structure for table `page`
3384--
3385
3386DROP TABLE IF EXISTS `page`;
3387CREATE TABLE `page` (
3388  `id` int(10) UNSIGNED NOT NULL,
3389  `content` mediumtext,
3390  `data` varchar(255) NOT NULL,
3391  `img` varchar(255) NOT NULL,
3392  `partyId` int(11) UNSIGNED NOT NULL,
3393  `dateUpdated` datetime NOT NULL
3394) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3395
3396--
3397-- Dumping data for table `page`
3398--
3399
3400INSERT INTO `page` (`id`, `content`, `data`, `img`, `partyId`, `dateUpdated`) VALUES
3401(1, 'hallo dit is een pagina', 'http://wikipedia.nl', '', 4, '2016-11-09 00:00:00');
3402
3403-- --------------------------------------------------------
3404
3405--
3406-- Table structure for table `party`
3407--
3408
3409DROP TABLE IF EXISTS `party`;
3410CREATE TABLE `party` (
3411  `id` int(11) NOT NULL,
3412  `leader` varchar(255) DEFAULT NULL,
3413  `leaderUrl` varchar(255) DEFAULT NULL,
3414  `established` int(11) DEFAULT NULL,
3415  `members` int(11) DEFAULT NULL,
3416  `seatsFirst` int(11) DEFAULT NULL,
3417  `seatsSecond` int(11) DEFAULT NULL,
3418  `seatsEU` int(11) DEFAULT NULL
3419) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3420
3421--
3422-- Dumping data for table `party`
3423--
3424
3425INSERT INTO `party` (`id`, `leader`, `leaderUrl`, `established`, `members`, `seatsFirst`, `seatsSecond`, `seatsEU`) VALUES
3426(1, 'Mark Rutte', NULL, 1948, 28436, 13, 40, 3),
3427(2, 'Sybrand Buma', NULL, 1980, 50181, 12, 13, 5),
3428(3, 'Gert-Jan Segers', NULL, 2001, 23398, 3, 5, 1),
3429(4, 'Alexander Pechtold', NULL, 1966, 25349, 10, 12, 4),
3430(5, 'Jesse Klaver', NULL, 1990, 21180, 4, 4, 2),
3431(6, 'Diederik Samsom', NULL, 1946, 46045, 8, 36, 3),
3432(7, 'Marianne Thieme', NULL, 2002, 12131, 2, 2, 1),
3433(8, 'Kees van der Staaij', NULL, 1918, 29928, 2, 3, 1),
3434(9, 'Emile Roemer', NULL, 1971, 41710, 9, 15, 2),
3435(10, 'Jan Roos', NULL, 2014, 1150, 0, 2, 0),
3436(11, 'Norbert Klein', NULL, 2014, 287, 0, 1, 0),
3437(12, 'Henk Krol', NULL, 2009, 6056, 2, 1, 0),
3438(13, 'Ancilla van de Leest', NULL, 2010, 6056, 0, 0, 0),
3439(14, 'Tunahan Kuzu', NULL, 2015, 0, 0, 0, 0);
3440
3441-- --------------------------------------------------------
3442
3443--
3444-- Table structure for table `poll`
3445--
3446
3447DROP TABLE IF EXISTS `poll`;
3448CREATE TABLE `poll` (
3449  `id` int(10) UNSIGNED NOT NULL,
3450  `questionId` int(11) NOT NULL,
3451  `title` varchar(255) NOT NULL,
3452  `dateCreated` datetime NOT NULL
3453) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3454
3455--
3456-- Dumping data for table `poll`
3457--
3458
3459INSERT INTO `poll` (`id`, `questionId`, `title`, `dateCreated`) VALUES
3460(1, 1, 'Wie heeft al heel veel gedaan vandaag?', '2016-11-06 00:00:00'),
3461(2, 12, '', '2016-12-13 17:05:00'),
3462(3, 13, '', '2016-12-13 17:06:04');
3463
3464-- --------------------------------------------------------
3465
3466--
3467-- Table structure for table `pollOption`
3468--
3469
3470DROP TABLE IF EXISTS `pollOption`;
3471CREATE TABLE `pollOption` (
3472  `id` int(10) UNSIGNED NOT NULL,
3473  `pollId` int(10) UNSIGNED NOT NULL,
3474  `value` varchar(255) NOT NULL
3475) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3476
3477--
3478-- Dumping data for table `pollOption`
3479--
3480
3481INSERT INTO `pollOption` (`id`, `pollId`, `value`) VALUES
3482(1, 1, 'Wietse'),
3483(2, 1, 'Hilda');
3484
3485-- --------------------------------------------------------
3486
3487--
3488-- Table structure for table `pollVote`
3489--
3490
3491DROP TABLE IF EXISTS `pollVote`;
3492CREATE TABLE `pollVote` (
3493  `id` int(10) UNSIGNED NOT NULL,
3494  `userId` int(10) UNSIGNED NOT NULL,
3495  `pollOptionId` int(10) UNSIGNED NOT NULL,
3496  `dateCreated` datetime DEFAULT NULL
3497) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3498
3499--
3500-- Dumping data for table `pollVote`
3501--
3502
3503INSERT INTO `pollVote` (`id`, `userId`, `pollOptionId`, `dateCreated`) VALUES
3504(1, 1, 1, '2016-11-02 00:00:00'),
3505(2, 1, 1, '2016-11-10 00:00:00'),
3506(3, 1, 2, '2016-11-09 00:00:00');
3507
3508-- --------------------------------------------------------
3509
3510--
3511-- Table structure for table `province`
3512--
3513
3514DROP TABLE IF EXISTS `province`;
3515CREATE TABLE `province` (
3516  `id` int(10) UNSIGNED NOT NULL,
3517  `name` varchar(255) NOT NULL,
3518  `img` varchar(255) DEFAULT NULL,
3519  `pageId` int(11) DEFAULT NULL
3520) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3521
3522--
3523-- Dumping data for table `province`
3524--
3525
3526INSERT INTO `province` (`id`, `name`, `img`, `pageId`) VALUES
3527(1, 'Drenthe', NULL, NULL),
3528(2, 'Noord Brabant', NULL, NULL),
3529(3, 'Gelderland', NULL, NULL),
3530(4, 'Utrecht', NULL, NULL),
3531(5, 'Friesland', NULL, NULL),
3532(6, 'Zuid Holland', NULL, NULL),
3533(7, 'Limburg', NULL, NULL),
3534(8, 'Noord Holland', NULL, NULL),
3535(9, 'Groningen', NULL, NULL),
3536(10, 'Zeeland', NULL, NULL),
3537(11, 'Overijssel', NULL, NULL),
3538(12, 'Flevoland', NULL, NULL);
3539
3540-- --------------------------------------------------------
3541
3542--
3543-- Table structure for table `question`
3544--
3545
3546DROP TABLE IF EXISTS `question`;
3547CREATE TABLE `question` (
3548  `id` int(11) UNSIGNED NOT NULL,
3549  `userId` int(10) UNSIGNED NOT NULL,
3550  `slug` varchar(255) NOT NULL,
3551  `title` varchar(255) NOT NULL,
3552  `description` mediumtext NOT NULL,
3553  `views` int(11) DEFAULT '0',
3554  `upvoted` int(11) DEFAULT '0',
3555  `shared` int(10) UNSIGNED DEFAULT '0',
3556  `downvoted` int(11) DEFAULT '0',
3557  `reported` int(11) DEFAULT '0',
3558  `dateCreated` datetime NOT NULL,
3559  `lastAnswered` datetime DEFAULT NULL,
3560  `closingDate` datetime DEFAULT NULL
3561) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3562
3563--
3564-- Dumping data for table `question`
3565--
3566
3567INSERT INTO `question` (`id`, `userId`, `slug`, `title`, `description`, `views`, `upvoted`, `shared`, `downvoted`, `reported`, `dateCreated`, `lastAnswered`, `closingDate`) VALUES
3568(2, 2, 'Wie-houdt-er-van-koekjes', 'Wie houdt er van koekjes?', 'Uit recent onderzoek blijkt dat cookiemonster van koekjes houdt. Uit geruchten bleek dat cookiemonster vaak te vinden is bij de plaatselijke buurtsuper van Zaandam. Verslaggevers uit het hele land zijn met haastige spoed naar de buurtsuper afgereisd. Na bijna vijf uur wachten kwam het monster in blauwe vacht inderdaad aangewandeld. Verslaggevers probeerden hem verschillende vragen te stellen, maar het enige wat het monster kon zeggen was "geen commentaar". De directie van de buurtsuper zit met een groot probleem, zij kunnen de vaste klant niet weigeren maar de rest van het dorp vind vaak lege schappen op de koekjesafdeling. Wat kan de buurtsuper van zaandam doen om dit probleem te verhelpen?  ', 53, 19, 133, 2, 35, '2016-11-10 08:09:32', '2016-11-11 06:25:02', '2016-11-10 00:00:00'),
3569(8, 8, 'meer-journalisten-vast-dan-vorig-jaar', 'Meer journalisten vast dan vorig jaar.', 'Momenteel zitten wereldwijd minstens 348 journalisten vast. Dat is een toename van 6 procent vergeleken met eind 2015. Vooral journalisten in Turkije moeten sinds de neergeslagen couppoging in juli op hun tellen passen. (bron: nu.nl)\r\n\r\nWat vinden jullie hiervan en welke stappen kunnen er genomen worden om dit probleem op te lossen?', 13, 6, 2, 0, 500, '2016-12-13 09:46:22', '2016-12-13 10:37:14', NULL),
3570(9, 5, 'russen-bombarderen-stad-syrie', 'Russen bombarderen stad syrië', 'Islamitische Staat (IS) heeft zich teruggetrokken uit Palmyra, nadat strijders van de terreurgroep de Syrische stad zaterdag opnieuw waren binnengedrongen.\r\n\r\nDit is allemaal gebeurd nadat Rusland heeft gebombardeerd. Wat vinden jullie, moeten we ons minder bemoeien met Syrië? Of moeten we juist alles platbombarderen? ', 56, 34, 1, 0, 20, '2016-12-13 12:12:12', '2016-12-13 15:30:06', NULL),
3571(10, 7, 'wat-kruis-je-aan-bij-visum-aanvraag-al-ben-je-bekeurd-voor-heling', 'Wat kruis je aan bij visum aanvraag al ben je bekeurd voor heling?', 'Twee jaar geleden heb ik een fiets gekocht en gepakt op heling. Super dom en stom maar is helaas gebeurd. Ik wil graag een visum aanvragen voor Bali aangezien ik daar voor een paar maanden heen ga voor school. Bij de visum aanvraag moet ik aanvinken of ik een strafblad heb. Ik heb naar mijn weten een aantekening en een boete van 160 euro moeten betalen. Weet iemand of ik hier ja of nee moet aankruisen, en stel dat ik ja aankruis wat voor gevolgen dit dan heeft?', 0, 4, 0, 0, 0, '2016-12-13 06:36:00', '2016-12-13 08:20:00', NULL),
3572(11, 8, 'Waar-moet-ik rekening-mee houden-als-ik-medicijnen-naar-het-buitenland-frankrijk-wil-sturen-per-post', 'Waar moet ik rekening mee houden als ik medicijnen naar het buitenland (Frankrijk) wil sturen per post?', 'Ik moet medicijnen per post opsturen naar Frankrijk, maar kan dit via de gewone post of zijn er speciale voorwaarden?', 0, 7, 1, 0, 70, '2016-12-12 08:37:18', '2016-12-13 13:37:00', NULL);
3573
3574-- --------------------------------------------------------
3575
3576--
3577-- Table structure for table `questionInvite`
3578--
3579
3580DROP TABLE IF EXISTS `questionInvite`;
3581CREATE TABLE `questionInvite` (
3582  `id` int(11) NOT NULL,
3583  `from` int(10) UNSIGNED NOT NULL,
3584  `to` int(10) UNSIGNED NOT NULL,
3585  `status` int(11) DEFAULT '0',
3586  `questionId` int(11) NOT NULL
3587) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3588
3589--
3590-- Dumping data for table `questionInvite`
3591--
3592
3593INSERT INTO `questionInvite` (`id`, `from`, `to`, `status`, `questionId`) VALUES
3594(1, 2, 1, 2, 1);
3595
3596-- --------------------------------------------------------
3597
3598--
3599-- Table structure for table `questionMedium`
3600--
3601
3602DROP TABLE IF EXISTS `questionMedium`;
3603CREATE TABLE `questionMedium` (
3604  `id` int(10) UNSIGNED NOT NULL,
3605  `questionId` int(10) UNSIGNED NOT NULL,
3606  `mediumTypeId` int(10) UNSIGNED NOT NULL,
3607  `title` varchar(255) NOT NULL,
3608  `url` varchar(255) NOT NULL
3609) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3610
3611--
3612-- Dumping data for table `questionMedium`
3613--
3614
3615INSERT INTO `questionMedium` (`id`, `questionId`, `mediumTypeId`, `title`, `url`) VALUES
3616(1, 1, 2, 'dit is een video of zo', 'http://facebook.com'),
3617(2, 1, 1, 'Awesome :)', 'http://giphy.com/gifs/alison-brie-6qd1cvYxrSaqI'),
3618(3, 1, 3, 'pdf I think', 'http://imgur.com/gallery/LY3tYQC'),
3619(4, 1, 4, 'Just a link bro', 'http://cheezburger.com/8144753664');
3620
3621-- --------------------------------------------------------
3622
3623--
3624-- Table structure for table `reaction`
3625--
3626
3627DROP TABLE IF EXISTS `reaction`;
3628CREATE TABLE `reaction` (
3629  `id` int(10) UNSIGNED NOT NULL,
3630  `answerId` int(11) NOT NULL,
3631  `userId` int(10) UNSIGNED NOT NULL,
3632  `reaction` tinytext,
3633  `reported` int(11) DEFAULT '0',
3634  `upvoted` int(11) DEFAULT '0',
3635  `downvoted` int(11) DEFAULT '0',
3636  `dateCreated` datetime DEFAULT NULL
3637) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3638
3639--
3640-- Dumping data for table `reaction`
3641--
3642
3643INSERT INTO `reaction` (`id`, `answerId`, `userId`, `reaction`, `reported`, `upvoted`, `downvoted`, `dateCreated`) VALUES
3644(1, 4, 8, 'Dankjewel voor het uitgebreide antwoord Geert, hier kan ik iets mee!', 0, 3, 0, '2016-12-13 11:14:42'),
3645(2, 4, 1, 'Zo hee, die Geert kan wel uitgebreide antwoorden geven. Zeker niks te doen in de tweede kamer?', 0, 27, 0, '2016-12-13 11:18:00'),
3646(3, 6, 5, 'Zeer uitgebreid antwoord, dankuwel!', 0, 4, 0, '2016-12-13 18:32:42'),
3647(4, 6, 7, 'Zo te lezen snap je er helemaal niks van, ga toch weg!', 0, 1, 0, '2016-12-15 18:45:20'),
3648(5, 7, 7, 'Tja, dat is het probleem, een andere oplossing is moeilijk!', 0, 2, 0, '2016-12-14 10:36:04');
3649
3650-- --------------------------------------------------------
3651
3652--
3653-- Table structure for table `reply`
3654--
3655
3656DROP TABLE IF EXISTS `reply`;
3657CREATE TABLE `reply` (
3658  `id` int(11) NOT NULL,
3659  `reactionId` int(10) UNSIGNED NOT NULL,
3660  `userId` int(10) UNSIGNED NOT NULL,
3661  `reply` tinytext NOT NULL,
3662  `reported` int(11) DEFAULT '0',
3663  `upvoted` int(11) DEFAULT '0',
3664  `downvoted` int(11) DEFAULT '0',
3665  `dateCreated` datetime DEFAULT NULL
3666) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3667
3668--
3669-- Dumping data for table `reply`
3670--
3671
3672INSERT INTO `reply` (`id`, `reactionId`, `userId`, `reply`, `reported`, `upvoted`, `downvoted`, `dateCreated`) VALUES
3673(1, 2, 5, 'Niet cool man, niet cool!', 0, 2, 0, '2016-12-13 15:48:00'),
3674(2, 2, 7, 'HAHA!', 500, 12, 0, '2016-12-13 15:50:00'),
3675(3, 4, 5, 'Nou, nou. Dat mag ook wel wat minder.', 0, 4, 0, '2016-12-13 19:20:37');
3676
3677-- --------------------------------------------------------
3678
3679--
3680-- Table structure for table `resetList`
3681--
3682
3683DROP TABLE IF EXISTS `resetList`;
3684CREATE TABLE `resetList` (
3685  `id` int(11) NOT NULL,
3686  `emailAddress` varchar(255) NOT NULL,
3687  `hash` varchar(255) NOT NULL,
3688  `dateCreated` datetime DEFAULT NULL
3689) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3690
3691--
3692-- Dumping data for table `resetList`
3693--
3694
3695INSERT INTO `resetList` (`id`, `emailAddress`, `hash`, `dateCreated`) VALUES
3696(1, 'wietse.l.devries@gmail.com', 'kjhrqwkjh32lkj5hl32kj4h', '2016-11-03 00:00:00');
3697
3698-- --------------------------------------------------------
3699
3700--
3701-- Table structure for table `setting`
3702--
3703
3704DROP TABLE IF EXISTS `setting`;
3705CREATE TABLE `setting` (
3706  `id` int(11) NOT NULL,
3707  `userId` int(10) UNSIGNED NOT NULL,
3708  `settingTypeId` int(10) UNSIGNED NOT NULL,
3709  `value` int(11) NOT NULL DEFAULT '0',
3710  `dateChanged` datetime DEFAULT NULL
3711) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3712
3713--
3714-- Dumping data for table `setting`
3715--
3716
3717INSERT INTO `setting` (`id`, `userId`, `settingTypeId`, `value`, `dateChanged`) VALUES
3718(1, 1, 2, 1, '2016-11-09 00:00:00'),
3719(2, 1, 3, 1, '2016-11-08 00:00:00');
3720
3721-- --------------------------------------------------------
3722
3723--
3724-- Table structure for table `settingType`
3725--
3726
3727DROP TABLE IF EXISTS `settingType`;
3728CREATE TABLE `settingType` (
3729  `id` int(10) UNSIGNED NOT NULL,
3730  `key` varchar(25) DEFAULT NULL,
3731  `value` varchar(255) DEFAULT NULL,
3732  `hidden` tinyint(1) NOT NULL DEFAULT '0'
3733) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3734
3735--
3736-- Dumping data for table `settingType`
3737--
3738
3739INSERT INTO `settingType` (`id`, `key`, `value`, `hidden`) VALUES
3740(1, 'email', 'Email notificaties ontvangen', 0),
3741(2, 'desktop', 'Desktop notificaties ontvangen', 0),
3742(3, 'work', 'Geen notificaties ontvangen tussen 09:00 en 17:00 uur', 0),
3743(4, 'digest', 'Periodiek een samenvattingen ontvangen per email', 0),
3744(5, 'layout', 'Open of gesloten weergave van vragen', 1),
3745(6, 'shareFacebook', 'Gebruiker heeft bij laatste actie gedeeld op fb', 1),
3746(7, 'shareTwitter', 'Gebruiker heeft bij laatste actie gedeeld op twitter', 1),
3747(8, 'followPage', 'Wilt u notificaties ontvangen voor nieuwe vragen op deze pagina?', 1);
3748
3749-- --------------------------------------------------------
3750
3751--
3752-- Table structure for table `tag`
3753--
3754
3755DROP TABLE IF EXISTS `tag`;
3756CREATE TABLE `tag` (
3757  `id` int(10) UNSIGNED NOT NULL,
3758  `questionId` int(11) NOT NULL,
3759  `tagValueId` int(11) NOT NULL,
3760  `dateCreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
3761) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3762
3763--
3764-- Dumping data for table `tag`
3765--
3766
3767INSERT INTO `tag` (`id`, `questionId`, `tagValueId`, `dateCreated`) VALUES
3768(1, 9, 4, '2016-12-13 21:14:41'),
3769(2, 10, 4, '2016-12-13 21:14:41'),
3770(3, 9, 10, '2016-12-13 21:16:28'),
3771(4, 9, 11, '2016-12-13 21:16:28'),
3772(5, 11, 21, '2016-12-13 21:19:17'),
3773(6, 10, 21, '2016-12-13 21:19:17'),
3774(7, 9, 21, '2016-12-13 21:19:17'),
3775(8, 8, 21, '2016-12-13 21:19:17'),
3776(9, 2, 21, '2016-12-13 21:19:17'),
3777(10, 2, 16, '2016-12-13 21:19:17'),
3778(11, 8, 16, '2016-12-13 21:19:17'),
3779(12, 9, 16, '2016-12-13 21:19:17'),
3780(13, 10, 16, '2016-12-13 21:19:17');
3781
3782-- --------------------------------------------------------
3783
3784--
3785-- Table structure for table `tagValue`
3786--
3787
3788DROP TABLE IF EXISTS `tagValue`;
3789CREATE TABLE `tagValue` (
3790  `id` int(10) UNSIGNED NOT NULL,
3791  `key` varchar(255) NOT NULL,
3792  `value` varchar(255) NOT NULL,
3793  `used` int(11) DEFAULT '0',
3794  `userId` int(10) UNSIGNED NOT NULL,
3795  `pageId` int(11) NOT NULL DEFAULT '0',
3796  `dateCreated` datetime DEFAULT NULL
3797) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3798
3799--
3800-- Dumping data for table `tagValue`
3801--
3802
3803INSERT INTO `tagValue` (`id`, `key`, `value`, `used`, `userId`, `pageId`, `dateCreated`) VALUES
3804(1, '', 'Onderwijs', 0, 0, 0, NULL),
3805(2, 'begroting', 'Begroting', 0, 1, 1, NULL),
3806(3, '', 'Defensie', 0, 0, 0, NULL),
3807(4, 'oorlog', 'Oorlog', 0, 0, 0, NULL),
3808(5, '', 'Vluchtelingen', 0, 0, 0, NULL),
3809(6, '', 'Rijkswaterstaat', 0, 0, 0, NULL),
3810(7, '', 'windmolens', 0, 0, 0, NULL),
3811(8, '', 'Groene energie', 0, 0, 0, NULL),
3812(9, '', 'Onderwijs', 0, 0, 0, NULL),
3813(10, 'syrie', 'Syrie', 0, 0, 0, NULL),
3814(11, 'isis', 'ISIS', 0, 0, 0, NULL),
3815(12, '', 'Olie', 0, 0, 0, NULL),
3816(13, '', 'VN (Verenigde naties)', 0, 0, 0, NULL),
3817(14, '', 'Burgermeester', 0, 0, 0, NULL),
3818(15, '', 'Eerste kamer', 0, 0, 0, NULL),
3819(16, 'tweede-kamer', 'Tweede kamer', 0, 0, 0, NULL),
3820(17, '', 'EU (Europese Unie)', 0, 0, 0, NULL),
3821(18, '', 'Discriminatie', 0, 0, 0, NULL),
3822(19, '', 'Sexisme', 0, 0, 0, NULL),
3823(20, '', 'Verkeer', 0, 0, 0, NULL),
3824(21, 'cultuur', 'Cultuur', 0, 0, 0, NULL),
3825(22, '', 'Wetenschap', 0, 0, 0, NULL),
3826(23, '', 'Koning', 0, 0, 0, NULL),
3827(24, '', 'Monarchie', 0, 0, 0, NULL),
3828(25, '', 'Willem-Alexander', 0, 0, 0, NULL),
3829(26, '', 'Justitie', 0, 0, 0, NULL),
3830(27, '', 'Politie', 0, 0, 0, NULL),
3831(28, '', 'Zorgverzekering', 0, 0, 0, NULL),
3832(29, '', 'Werkgelegenheid', 0, 0, 0, NULL),
3833(30, '', 'Sociale zaken', 0, 0, 0, NULL),
3834(31, '', 'Infrastructuur', 0, 0, 0, NULL),
3835(32, '', 'Drenthe', 0, 0, 0, NULL),
3836(33, '', 'Noord Brabant', 0, 0, 0, NULL),
3837(34, '', 'Noord Holland', 0, 0, 0, NULL),
3838(35, '', 'Gelderland', 0, 0, 0, NULL),
3839(36, '', 'Utrecht (Provincie)', 0, 0, 0, NULL),
3840(37, '', 'Friesland', 0, 0, 0, NULL),
3841(38, '', 'Zuid Holland', 0, 0, 0, NULL),
3842(39, '', 'Overijssel', 0, 0, 0, NULL),
3843(40, '', 'Flevoland', 0, 0, 0, NULL),
3844(41, '', 'Limburg', 0, 0, 0, NULL),
3845(42, '', 'Groningen (Provincie)', 0, 0, 0, NULL),
3846(43, '', 'Zeeland', 0, 0, 0, NULL),
3847(44, '', 'Ministerie van Algemene Zaken (A)', 0, 0, 0, NULL),
3848(45, '', 'Ministerie van Binnenlandse Zaken en Koninkrijksrelaties (BZK)', 0, 0, 0, NULL),
3849(46, '', 'Ministerie van Buitenlandse Zaken (BuZa)', 0, 0, 0, NULL),
3850(47, '', 'Ministerie van Defensie', 0, 0, 0, NULL),
3851(48, '', 'Ministerie van Economische Zaken (EZ)', 0, 0, 0, NULL),
3852(49, '', 'Ministerie van Financiën', 0, 0, 0, NULL),
3853(50, '', 'Ministerie van Infrastructuur en Milieu (I&M)', 0, 0, 0, NULL),
3854(51, '', 'Ministerie van Onderwijs, Cultuur en Wetenschap (OCW)', 0, 0, 0, NULL),
3855(52, '', 'Ministerie van Sociale Zaken en Werkgelegenheid (SZW)', 0, 0, 0, NULL),
3856(53, '', 'Ministerie van Veiligheid en Justitie (V&J)', 0, 0, 0, NULL),
3857(54, '', 'Ministerie van Volksgezondheid, Welzijn en Sport (VWS)', 0, 0, 0, NULL);
3858
3859-- --------------------------------------------------------
3860
3861--
3862-- Table structure for table `user`
3863--
3864
3865DROP TABLE IF EXISTS `user`;
3866CREATE TABLE `user` (
3867  `id` int(10) UNSIGNED NOT NULL,
3868  `token` varchar(255) NOT NULL,
3869  `email` varchar(255) NOT NULL,
3870  `password` varchar(255) DEFAULT NULL,
3871  `userName` varchar(255) NOT NULL,
3872  `avatar` varchar(255) DEFAULT NULL,
3873  `firstName` varchar(255) DEFAULT NULL,
3874  `lastName` varchar(255) DEFAULT NULL,
3875  `function` varchar(255) DEFAULT NULL,
3876  `bio` tinytext,
3877  `linkedinId` varchar(255) DEFAULT NULL,
3878  `googleId` varchar(255) DEFAULT NULL,
3879  `facebookId` varchar(255) DEFAULT NULL,
3880  `cityId` int(10) UNSIGNED NOT NULL,
3881  `ageId` int(10) UNSIGNED NOT NULL,
3882  `age` int(10) NOT NULL,
3883  `gender` enum('m','f') DEFAULT NULL,
3884  `educationId` int(10) UNSIGNED NOT NULL,
3885  `incomeId` int(10) UNSIGNED NOT NULL,
3886  `maritalStatusId` int(11) NOT NULL,
3887  `children` enum('y','n') DEFAULT NULL,
3888  `statusId` int(10) UNSIGNED DEFAULT '0',
3889  `verified` int(11) DEFAULT '0',
3890  `dateRegistered` datetime DEFAULT NULL,
3891  `lastLogin` datetime DEFAULT NULL,
3892  `loginCount` int(10) UNSIGNED DEFAULT '0',
3893  `reputation` int(10) UNSIGNED DEFAULT '0'
3894) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3895
3896--
3897-- Dumping data for table `user`
3898--
3899
3900INSERT INTO `user` (`id`, `token`, `email`, `password`, `userName`, `avatar`, `firstName`, `lastName`, `function`, `bio`, `linkedinId`, `googleId`, `facebookId`, `cityId`, `ageId`, `age`, `gender`, `educationId`, `incomeId`, `maritalStatusId`, `children`, `statusId`, `verified`, `dateRegistered`, `lastLogin`, `loginCount`, `reputation`) VALUES
3901(1, '', 'wietse.l.devries@gmail.com', 'password123', 'wietse', '', 'Wietse', 'de Vries', 'Programmeur Burgerzetel.nl', 'ik heet wietse!:P', NULL, NULL, NULL, 1, 3, 0, 'm', 5, 3, 1, 'n', 2, 0, '2016-11-03 18:35:40', '2016-11-03 18:35:44', 2, 1501),
3902(2, 'mas7h0em24l6h5bzz1tt9', 'tijmenhelder@gmail.com', '$2a$06$r6eV5umPCRCeLYz8xj1MhOnKXgUosAo4CQDGCIoFcaZZG7nV4e7DS', 'TijmenH', 'tijmenhelder.gif', 'Tijmen', 'Helder', 'Big Boss Burgerzetel.nl', 'hoi, ik ben tijmen helder en ik rook heel langzaam.', 'idgAgtYcQC', '117717143542666307909', '1516409185040846', 56, 3, 0, 'm', 5, 3, 2, 'y', 3, 1, '2016-11-17 00:00:00', '2016-12-13 14:59:52', 135, 5490),
3903(3, '', 'test@persoon.nl', '$2a$06$T8bYG1QXuEtOt1fVRZNU8OugEZun7H2.VD0yVbrVAPePoUQYiKW/2', 'jeanie', 'testpersoon.png', 'Bobbie', 'Jeanpierre', 'Officiële tester van Burgerzetel.nl', 'Ik ben de enige echte tester van Burgerzetel.nl. Het feit dat deze site zo fijn werkt komt dus allemaal door mij!', NULL, NULL, NULL, 918, 2, 0, 'm', 5, 4, 3, 'y', 1, 1, '2016-12-12 12:15:45', '2016-12-14 09:57:04', 3, 45),
3904(5, '', 'g.wilders@tweedekamer.nl', '$2a$06$3.pxpr3s7qQrFJtJ.q2TdeWqcdQmpIKYviCXAJ/nQ9C4.QnliIJSy', 'GeertW', '', 'Geert', 'Wilders', 'Voorzitter PVV', 'Ik sta voor een vrij land!', NULL, NULL, NULL, 2500, 4, 1967, 'm', 1, 4, 1, 'n', 1, 1, '2016-12-13 00:00:00', '2016-12-13 00:00:00', 0, 0),
3905(6, '', 'geertschilder@gmail.com', '$2a$06$s.6GkdPTGa/2tkrASuRFpO3WskaOS3c.vx3X6984WMBDZ6thZzGeO', 'kunstenaar', '', 'Geert', 'Schilder', 'Kunstenaar in hart en nieren', 'Ik maak kunst met een politiek thema', NULL, NULL, NULL, 487, 3, 1976, 'm', 3, 1, 1, 'y', 1, 0, '2016-12-12 00:00:00', '2016-12-12 00:00:00', 0, 20),
3906(7, '', 'geertruda@dewildehoeve.nl', '$2a$06$/hiB07NBEe3rSICLKfa7o..ThkxA6rVojC2KfNoAFp2UF1NCEthbC', 'geertje', '', 'Geertruda', 'Bouwmans', 'Vuurtorenwachter', 'Mijn naam is Geertruda, maar je mag ook Geertje zeggen!', NULL, NULL, NULL, 71, 4, 1921, 'f', 2, 3, 1, 'y', 1, 0, '2016-12-13 00:00:00', '2016-12-13 00:00:00', 0, 450),
3907(8, '', 'elisawilders@geenfamilie.van', '$2a$06$5wtxgt1dMUDk3Zs3/aCqCeilGmDAtq4KLniNghedIlPfKxjfu0Xg.', 'elisa', '', 'Elisa', 'Wilders', 'Communicatieafdeling Gemeente Mill en Sint Hubert', 'Ik ben geen familie van Geert Wilders!', NULL, NULL, NULL, 1902, 1, 1975, 'f', 1, 2, 6, 'n', 1, 1, '2016-12-13 00:00:00', '2016-12-13 00:00:00', 0, 780);
3908
3909-- --------------------------------------------------------
3910
3911--
3912-- Table structure for table `visit`
3913--
3914
3915DROP TABLE IF EXISTS `visit`;
3916CREATE TABLE `visit` (
3917  `id` int(10) UNSIGNED NOT NULL,
3918  `questionId` int(10) UNSIGNED NOT NULL,
3919  `userId` int(10) UNSIGNED NOT NULL,
3920  `count` int(11) NOT NULL DEFAULT '0' COMMENT 'track which question a user has visited. If more than once, increment ‘count’',
3921  `dateCreated` datetime DEFAULT NULL,
3922  `tagValueId` int(11) NOT NULL
3923) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3924
3925--
3926-- Dumping data for table `visit`
3927--
3928
3929INSERT INTO `visit` (`id`, `questionId`, `userId`, `count`, `dateCreated`, `tagValueId`) VALUES
3930(1, 1, 1, 23, '2016-11-09 00:00:00', 0),
3931(3, 1, 1, 12, '2016-11-02 00:00:00', 0);
3932
3933--
3934-- Indexes for dumped tables
3935--
3936
3937--
3938-- Indexes for table `age`
3939--
3940ALTER TABLE `age`
3941  ADD PRIMARY KEY (`id`);
3942
3943--
3944-- Indexes for table `answer`
3945--
3946ALTER TABLE `answer`
3947  ADD PRIMARY KEY (`id`),
3948  ADD KEY `fk_answer1_idx` (`questionId`),
3949  ADD KEY `fk_answer2_idx` (`userId`);
3950
3951--
3952-- Indexes for table `answerMedium`
3953--
3954ALTER TABLE `answerMedium`
3955  ADD PRIMARY KEY (`id`),
3956  ADD KEY `fk_answer_medium1_idx` (`answerId`),
3957  ADD KEY `fk_answer_medium2_idx` (`mediumTypeId`);
3958
3959--
3960-- Indexes for table `city`
3961--
3962ALTER TABLE `city`
3963  ADD PRIMARY KEY (`id`),
3964  ADD KEY `fk_city1_idx` (`municipalityId`);
3965
3966--
3967-- Indexes for table `content`
3968--
3969ALTER TABLE `content`
3970  ADD PRIMARY KEY (`id`);
3971
3972--
3973-- Indexes for table `education`
3974--
3975ALTER TABLE `education`
3976  ADD PRIMARY KEY (`id`);
3977
3978--
3979-- Indexes for table `faq`
3980--
3981ALTER TABLE `faq`
3982  ADD PRIMARY KEY (`id`);
3983
3984--
3985-- Indexes for table `favorite`
3986--
3987ALTER TABLE `favorite`
3988  ADD PRIMARY KEY (`id`),
3989  ADD KEY `fk_favorite2_idx` (`userId`);
3990
3991--
3992-- Indexes for table `income`
3993--
3994ALTER TABLE `income`
3995  ADD PRIMARY KEY (`id`);
3996
3997--
3998-- Indexes for table `interest`
3999--
4000ALTER TABLE `interest`
4001  ADD PRIMARY KEY (`id`);
4002
4003--
4004-- Indexes for table `maritalStatus`
4005--
4006ALTER TABLE `maritalStatus`
4007  ADD PRIMARY KEY (`id`);
4008
4009--
4010-- Indexes for table `mediumType`
4011--
4012ALTER TABLE `mediumType`
4013  ADD PRIMARY KEY (`id`);
4014
4015--
4016-- Indexes for table `milestone`
4017--
4018ALTER TABLE `milestone`
4019  ADD PRIMARY KEY (`id`);
4020
4021--
4022-- Indexes for table `milestoneType`
4023--
4024ALTER TABLE `milestoneType`
4025  ADD PRIMARY KEY (`id`),
4026  ADD UNIQUE KEY `id` (`id`);
4027
4028--
4029-- Indexes for table `municipality`
4030--
4031ALTER TABLE `municipality`
4032  ADD PRIMARY KEY (`id`),
4033  ADD KEY `fk_municipality1_idx` (`provinceId`);
4034
4035--
4036-- Indexes for table `notification`
4037--
4038ALTER TABLE `notification`
4039  ADD PRIMARY KEY (`id`),
4040  ADD KEY `fk_notification1_idx` (`notificationTypeId`),
4041  ADD KEY `fk_notification2_idx` (`userId`),
4042  ADD KEY `fk_notification3_idx` (`questionId`),
4043  ADD KEY `fk_notification4_idx` (`answerId`);
4044
4045--
4046-- Indexes for table `notificationType`
4047--
4048ALTER TABLE `notificationType`
4049  ADD PRIMARY KEY (`id`);
4050
4051--
4052-- Indexes for table `page`
4053--
4054ALTER TABLE `page`
4055  ADD PRIMARY KEY (`id`);
4056
4057--
4058-- Indexes for table `party`
4059--
4060ALTER TABLE `party`
4061  ADD PRIMARY KEY (`id`);
4062
4063--
4064-- Indexes for table `poll`
4065--
4066ALTER TABLE `poll`
4067  ADD PRIMARY KEY (`id`),
4068  ADD KEY `fk_poll1_idx` (`questionId`);
4069
4070--
4071-- Indexes for table `pollOption`
4072--
4073ALTER TABLE `pollOption`
4074  ADD PRIMARY KEY (`id`),
4075  ADD KEY `fk_poll_option1_idx` (`pollId`);
4076
4077--
4078-- Indexes for table `pollVote`
4079--
4080ALTER TABLE `pollVote`
4081  ADD PRIMARY KEY (`id`),
4082  ADD KEY `fk_poll_vote1_idx` (`userId`),
4083  ADD KEY `fk_poll_vote3_idx` (`pollOptionId`);
4084
4085--
4086-- Indexes for table `province`
4087--
4088ALTER TABLE `province`
4089  ADD PRIMARY KEY (`id`);
4090
4091--
4092-- Indexes for table `question`
4093--
4094ALTER TABLE `question`
4095  ADD PRIMARY KEY (`id`),
4096  ADD UNIQUE KEY `slug_UNIQUE` (`slug`),
4097  ADD KEY `fk_question1_idx` (`userId`);
4098
4099--
4100-- Indexes for table `questionInvite`
4101--
4102ALTER TABLE `questionInvite`
4103  ADD PRIMARY KEY (`id`),
4104  ADD KEY `fk_question_invite1_idx` (`to`),
4105  ADD KEY `fk_question_invite2_idx` (`from`);
4106
4107--
4108-- Indexes for table `questionMedium`
4109--
4110ALTER TABLE `questionMedium`
4111  ADD PRIMARY KEY (`id`),
4112  ADD KEY `fk_question_medium1_idx` (`questionId`),
4113  ADD KEY `fk_question_medium2_idx` (`mediumTypeId`);
4114
4115--
4116-- Indexes for table `reaction`
4117--
4118ALTER TABLE `reaction`
4119  ADD PRIMARY KEY (`id`),
4120  ADD KEY `fk_reaction1_idx` (`answerId`),
4121  ADD KEY `fk_reaction2_idx` (`userId`);
4122
4123--
4124-- Indexes for table `reply`
4125--
4126ALTER TABLE `reply`
4127  ADD PRIMARY KEY (`id`),
4128  ADD KEY `fk_reply1_idx` (`userId`),
4129  ADD KEY `fk_reply2_idx` (`reactionId`);
4130
4131--
4132-- Indexes for table `resetList`
4133--
4134ALTER TABLE `resetList`
4135  ADD PRIMARY KEY (`id`);
4136
4137--
4138-- Indexes for table `setting`
4139--
4140ALTER TABLE `setting`
4141  ADD PRIMARY KEY (`id`),
4142  ADD KEY `fk_setting1_idx` (`userId`),
4143  ADD KEY `fk_setting2_idx` (`settingTypeId`);
4144
4145--
4146-- Indexes for table `settingType`
4147--
4148ALTER TABLE `settingType`
4149  ADD PRIMARY KEY (`id`);
4150
4151--
4152-- Indexes for table `tag`
4153--
4154ALTER TABLE `tag`
4155  ADD PRIMARY KEY (`id`);
4156
4157--
4158-- Indexes for table `tagValue`
4159--
4160ALTER TABLE `tagValue`
4161  ADD PRIMARY KEY (`id`),
4162  ADD UNIQUE KEY `id` (`id`);
4163
4164--
4165-- Indexes for table `user`
4166--
4167ALTER TABLE `user`
4168  ADD PRIMARY KEY (`id`),
4169  ADD KEY `fk_user1_idx` (`ageId`),
4170  ADD KEY `fk_user2_idx` (`educationId`),
4171  ADD KEY `fk_user3_idx` (`maritalStatusId`),
4172  ADD KEY `fk_user4_idx` (`incomeId`),
4173  ADD KEY `fk_user5_idx` (`cityId`);
4174
4175--
4176-- Indexes for table `visit`
4177--
4178ALTER TABLE `visit`
4179  ADD PRIMARY KEY (`id`);
4180
4181--
4182-- AUTO_INCREMENT for dumped tables
4183--
4184
4185--
4186-- AUTO_INCREMENT for table `age`
4187--
4188ALTER TABLE `age`
4189  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
4190--
4191-- AUTO_INCREMENT for table `answer`
4192--
4193ALTER TABLE `answer`
4194  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4195--
4196-- AUTO_INCREMENT for table `answerMedium`
4197--
4198ALTER TABLE `answerMedium`
4199  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
4200--
4201-- AUTO_INCREMENT for table `content`
4202--
4203ALTER TABLE `content`
4204  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4205--
4206-- AUTO_INCREMENT for table `education`
4207--
4208ALTER TABLE `education`
4209  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
4210--
4211-- AUTO_INCREMENT for table `faq`
4212--
4213ALTER TABLE `faq`
4214  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4215--
4216-- AUTO_INCREMENT for table `favorite`
4217--
4218ALTER TABLE `favorite`
4219  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
4220--
4221-- AUTO_INCREMENT for table `income`
4222--
4223ALTER TABLE `income`
4224  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4225--
4226-- AUTO_INCREMENT for table `interest`
4227--
4228ALTER TABLE `interest`
4229  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4230--
4231-- AUTO_INCREMENT for table `maritalStatus`
4232--
4233ALTER TABLE `maritalStatus`
4234  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
4235--
4236-- AUTO_INCREMENT for table `mediumType`
4237--
4238ALTER TABLE `mediumType`
4239  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4240--
4241-- AUTO_INCREMENT for table `milestone`
4242--
4243ALTER TABLE `milestone`
4244  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
4245--
4246-- AUTO_INCREMENT for table `milestoneType`
4247--
4248ALTER TABLE `milestoneType`
4249  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
4250--
4251-- AUTO_INCREMENT for table `notification`
4252--
4253ALTER TABLE `notification`
4254  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
4255--
4256-- AUTO_INCREMENT for table `notificationType`
4257--
4258ALTER TABLE `notificationType`
4259  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4260--
4261-- AUTO_INCREMENT for table `page`
4262--
4263ALTER TABLE `page`
4264  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4265--
4266-- AUTO_INCREMENT for table `party`
4267--
4268ALTER TABLE `party`
4269  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
4270--
4271-- AUTO_INCREMENT for table `poll`
4272--
4273ALTER TABLE `poll`
4274  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
4275--
4276-- AUTO_INCREMENT for table `pollOption`
4277--
4278ALTER TABLE `pollOption`
4279  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
4280--
4281-- AUTO_INCREMENT for table `pollVote`
4282--
4283ALTER TABLE `pollVote`
4284  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
4285--
4286-- AUTO_INCREMENT for table `province`
4287--
4288ALTER TABLE `province`
4289  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
4290--
4291-- AUTO_INCREMENT for table `question`
4292--
4293ALTER TABLE `question`
4294  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
4295--
4296-- AUTO_INCREMENT for table `questionInvite`
4297--
4298ALTER TABLE `questionInvite`
4299  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4300--
4301-- AUTO_INCREMENT for table `questionMedium`
4302--
4303ALTER TABLE `questionMedium`
4304  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4305--
4306-- AUTO_INCREMENT for table `reaction`
4307--
4308ALTER TABLE `reaction`
4309  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
4310--
4311-- AUTO_INCREMENT for table `reply`
4312--
4313ALTER TABLE `reply`
4314  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
4315--
4316-- AUTO_INCREMENT for table `resetList`
4317--
4318ALTER TABLE `resetList`
4319  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4320--
4321-- AUTO_INCREMENT for table `setting`
4322--
4323ALTER TABLE `setting`
4324  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
4325--
4326-- AUTO_INCREMENT for table `settingType`
4327--
4328ALTER TABLE `settingType`
4329  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4330--
4331-- AUTO_INCREMENT for table `tag`
4332--
4333ALTER TABLE `tag`
4334  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
4335--
4336-- AUTO_INCREMENT for table `tagValue`
4337--
4338ALTER TABLE `tagValue`
4339  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
4340--
4341-- AUTO_INCREMENT for table `user`
4342--
4343ALTER TABLE `user`
4344  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4345--
4346-- AUTO_INCREMENT for table `visit`
4347--
4348ALTER TABLE `visit`
4349  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;