PDtRLVjx

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 01:09 PM
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, 3, 10, 0, 1),
2722(2, 3, 4, 14, 1),
2723(3, 3, 16, 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-- Dumping data for table `notification`
3355--
3356
3357INSERT INTO `notification` (`id`, `notificationTypeId`, `questionId`, `answerId`, `reactionId`, `replyId`, `userId`, `askedBy`, `status`, `dateCreated`) VALUES
3358(2, 6, 0, 0, 6, 0, 3, 0, 0, '2016-12-14 10:16:35'),
3359(3, 3, 0, 0, 6, 4, 3, 0, 0, '2016-12-14 12:22:39'),
3360(4, 4, 10, 0, 0, 0, 3, 7, 0, '2016-12-13 17:36:24');
3361
3362-- --------------------------------------------------------
3363
3364--
3365-- Table structure for table `notificationType`
3366--
3367
3368DROP TABLE IF EXISTS `notificationType`;
3369CREATE TABLE `notificationType` (
3370  `id` int(10) UNSIGNED NOT NULL,
3371  `key` varchar(25) NOT NULL,
3372  `value` varchar(255) NOT NULL
3373) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3374
3375--
3376-- Dumping data for table `notificationType`
3377--
3378
3379INSERT INTO `notificationType` (`id`, `key`, `value`) VALUES
3380(1, 'newAnswer', 'heeft uw vraag beantwoord.'),
3381(2, 'newCommentAnswer', 'heeft gereageerd op uw antwoord.'),
3382(3, 'newReplyComment', 'heeft gereageerd op uw reactie.'),
3383(4, 'newRequest', 'heeft u gevraagd om een vraag te beantwoorden.'),
3384(5, 'deletedAnswer', 'Uw antwoord is door de community verwijderd.'),
3385(6, 'deletedComment', 'Uw reactie is door de community verwijderd.'),
3386(7, 'deletedQuestion', 'Uw vraag is door de community verwijderd.'),
3387(8, 'deletedReply', 'Uw reactie is door de community verwijderd.');
3388
3389-- --------------------------------------------------------
3390
3391--
3392-- Table structure for table `page`
3393--
3394
3395DROP TABLE IF EXISTS `page`;
3396CREATE TABLE `page` (
3397  `id` int(10) UNSIGNED NOT NULL,
3398  `content` mediumtext,
3399  `data` varchar(255) NOT NULL,
3400  `img` varchar(255) NOT NULL,
3401  `partyId` int(11) UNSIGNED NOT NULL,
3402  `dateUpdated` datetime NOT NULL
3403) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3404
3405--
3406-- Dumping data for table `page`
3407--
3408
3409INSERT INTO `page` (`id`, `content`, `data`, `img`, `partyId`, `dateUpdated`) VALUES
3410(1, 'hallo dit is een pagina', 'http://wikipedia.nl', '', 4, '2016-11-09 00:00:00');
3411
3412-- --------------------------------------------------------
3413
3414--
3415-- Table structure for table `party`
3416--
3417
3418DROP TABLE IF EXISTS `party`;
3419CREATE TABLE `party` (
3420  `id` int(11) NOT NULL,
3421  `leader` varchar(255) DEFAULT NULL,
3422  `leaderUrl` varchar(255) DEFAULT NULL,
3423  `established` int(11) DEFAULT NULL,
3424  `members` int(11) DEFAULT NULL,
3425  `seatsFirst` int(11) DEFAULT NULL,
3426  `seatsSecond` int(11) DEFAULT NULL,
3427  `seatsEU` int(11) DEFAULT NULL
3428) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3429
3430--
3431-- Dumping data for table `party`
3432--
3433
3434INSERT INTO `party` (`id`, `leader`, `leaderUrl`, `established`, `members`, `seatsFirst`, `seatsSecond`, `seatsEU`) VALUES
3435(1, 'Mark Rutte', NULL, 1948, 28436, 13, 40, 3),
3436(2, 'Sybrand Buma', NULL, 1980, 50181, 12, 13, 5),
3437(3, 'Gert-Jan Segers', NULL, 2001, 23398, 3, 5, 1),
3438(4, 'Alexander Pechtold', NULL, 1966, 25349, 10, 12, 4),
3439(5, 'Jesse Klaver', NULL, 1990, 21180, 4, 4, 2),
3440(6, 'Diederik Samsom', NULL, 1946, 46045, 8, 36, 3),
3441(7, 'Marianne Thieme', NULL, 2002, 12131, 2, 2, 1),
3442(8, 'Kees van der Staaij', NULL, 1918, 29928, 2, 3, 1),
3443(9, 'Emile Roemer', NULL, 1971, 41710, 9, 15, 2),
3444(10, 'Jan Roos', NULL, 2014, 1150, 0, 2, 0),
3445(11, 'Norbert Klein', NULL, 2014, 287, 0, 1, 0),
3446(12, 'Henk Krol', NULL, 2009, 6056, 2, 1, 0),
3447(13, 'Ancilla van de Leest', NULL, 2010, 6056, 0, 0, 0),
3448(14, 'Tunahan Kuzu', NULL, 2015, 0, 0, 0, 0);
3449
3450-- --------------------------------------------------------
3451
3452--
3453-- Table structure for table `poll`
3454--
3455
3456DROP TABLE IF EXISTS `poll`;
3457CREATE TABLE `poll` (
3458  `id` int(10) UNSIGNED NOT NULL,
3459  `questionId` int(11) NOT NULL,
3460  `title` varchar(255) NOT NULL,
3461  `dateCreated` datetime NOT NULL
3462) ENGINE=InnoDB DEFAULT CHARSET=utf8;
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
3479--
3480-- Table structure for table `pollVote`
3481--
3482
3483DROP TABLE IF EXISTS `pollVote`;
3484CREATE TABLE `pollVote` (
3485  `id` int(10) UNSIGNED NOT NULL,
3486  `userId` int(10) UNSIGNED NOT NULL,
3487  `pollOptionId` int(10) UNSIGNED NOT NULL,
3488  `dateCreated` datetime DEFAULT NULL
3489) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3490
3491-- --------------------------------------------------------
3492
3493--
3494-- Table structure for table `province`
3495--
3496
3497DROP TABLE IF EXISTS `province`;
3498CREATE TABLE `province` (
3499  `id` int(10) UNSIGNED NOT NULL,
3500  `name` varchar(255) NOT NULL,
3501  `img` varchar(255) DEFAULT NULL,
3502  `pageId` int(11) DEFAULT NULL
3503) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3504
3505--
3506-- Dumping data for table `province`
3507--
3508
3509INSERT INTO `province` (`id`, `name`, `img`, `pageId`) VALUES
3510(1, 'Drenthe', NULL, NULL),
3511(2, 'Noord Brabant', NULL, NULL),
3512(3, 'Gelderland', NULL, NULL),
3513(4, 'Utrecht', NULL, NULL),
3514(5, 'Friesland', NULL, NULL),
3515(6, 'Zuid Holland', NULL, NULL),
3516(7, 'Limburg', NULL, NULL),
3517(8, 'Noord Holland', NULL, NULL),
3518(9, 'Groningen', NULL, NULL),
3519(10, 'Zeeland', NULL, NULL),
3520(11, 'Overijssel', NULL, NULL),
3521(12, 'Flevoland', NULL, NULL);
3522
3523-- --------------------------------------------------------
3524
3525--
3526-- Table structure for table `question`
3527--
3528
3529DROP TABLE IF EXISTS `question`;
3530CREATE TABLE `question` (
3531  `id` int(11) UNSIGNED NOT NULL,
3532  `userId` int(10) UNSIGNED NOT NULL,
3533  `slug` varchar(255) NOT NULL,
3534  `title` varchar(255) NOT NULL,
3535  `description` mediumtext NOT NULL,
3536  `views` int(11) DEFAULT '0',
3537  `upvoted` int(11) DEFAULT '0',
3538  `shared` int(10) UNSIGNED DEFAULT '0',
3539  `downvoted` int(11) DEFAULT '0',
3540  `reported` int(11) DEFAULT '0',
3541  `dateCreated` datetime NOT NULL,
3542  `lastAnswered` datetime DEFAULT NULL,
3543  `closingDate` datetime DEFAULT NULL
3544) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3545
3546--
3547-- Dumping data for table `question`
3548--
3549
3550INSERT INTO `question` (`id`, `userId`, `slug`, `title`, `description`, `views`, `upvoted`, `shared`, `downvoted`, `reported`, `dateCreated`, `lastAnswered`, `closingDate`) VALUES
3551(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'),
3552(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),
3553(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),
3554(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),
3555(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),
3556(15, 3, 'delete-me-please', 'DELETE ME PLEASE', 'PLEASE PLEASE', 0, 0, 0, 0, 0, '2016-12-14 11:53:18', NULL, NULL);
3557
3558-- --------------------------------------------------------
3559
3560--
3561-- Table structure for table `questionInvite`
3562--
3563
3564DROP TABLE IF EXISTS `questionInvite`;
3565CREATE TABLE `questionInvite` (
3566  `id` int(11) NOT NULL,
3567  `from` int(10) UNSIGNED NOT NULL,
3568  `to` int(10) UNSIGNED NOT NULL,
3569  `status` int(11) DEFAULT '0',
3570  `questionId` int(11) NOT NULL
3571) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3572
3573--
3574-- Dumping data for table `questionInvite`
3575--
3576
3577INSERT INTO `questionInvite` (`id`, `from`, `to`, `status`, `questionId`) VALUES
3578(1, 2, 1, 2, 1);
3579
3580-- --------------------------------------------------------
3581
3582--
3583-- Table structure for table `questionMedium`
3584--
3585
3586DROP TABLE IF EXISTS `questionMedium`;
3587CREATE TABLE `questionMedium` (
3588  `id` int(10) UNSIGNED NOT NULL,
3589  `questionId` int(10) UNSIGNED NOT NULL,
3590  `mediumTypeId` int(10) UNSIGNED NOT NULL,
3591  `title` varchar(255) NOT NULL,
3592  `url` varchar(255) NOT NULL
3593) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3594
3595--
3596-- Dumping data for table `questionMedium`
3597--
3598
3599INSERT INTO `questionMedium` (`id`, `questionId`, `mediumTypeId`, `title`, `url`) VALUES
3600(1, 1, 2, 'dit is een video of zo', 'http://facebook.com'),
3601(2, 1, 1, 'Awesome :)', 'http://giphy.com/gifs/alison-brie-6qd1cvYxrSaqI'),
3602(3, 1, 3, 'pdf I think', 'http://imgur.com/gallery/LY3tYQC'),
3603(4, 1, 4, 'Just a link bro', 'http://cheezburger.com/8144753664');
3604
3605-- --------------------------------------------------------
3606
3607--
3608-- Table structure for table `reaction`
3609--
3610
3611DROP TABLE IF EXISTS `reaction`;
3612CREATE TABLE `reaction` (
3613  `id` int(10) UNSIGNED NOT NULL,
3614  `answerId` int(11) NOT NULL,
3615  `userId` int(10) UNSIGNED NOT NULL,
3616  `reaction` tinytext,
3617  `reported` int(11) DEFAULT '0',
3618  `upvoted` int(11) DEFAULT '0',
3619  `downvoted` int(11) DEFAULT '0',
3620  `dateCreated` datetime DEFAULT NULL
3621) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3622
3623--
3624-- Dumping data for table `reaction`
3625--
3626
3627INSERT INTO `reaction` (`id`, `answerId`, `userId`, `reaction`, `reported`, `upvoted`, `downvoted`, `dateCreated`) VALUES
3628(1, 4, 8, 'Dankjewel voor het uitgebreide antwoord Geert, hier kan ik iets mee!', 0, 3, 0, '2016-12-13 11:14:42'),
3629(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'),
3630(3, 6, 5, 'Zeer uitgebreid antwoord, dankuwel!', 0, 4, 0, '2016-12-13 18:32:42'),
3631(4, 6, 7, 'Zo te lezen snap je er helemaal niks van, ga toch weg!', 0, 1, 0, '2016-12-15 18:45:20'),
3632(5, 7, 7, 'Tja, dat is het probleem, een andere oplossing is moeilijk!', 0, 2, 0, '2016-12-14 10:36:04'),
3633(6, 7, 3, 'Platgooien die bende, hebben wij toch niks aan.', 5000, 2, 0, '2016-12-14 14:13:20');
3634
3635-- --------------------------------------------------------
3636
3637--
3638-- Table structure for table `reply`
3639--
3640
3641DROP TABLE IF EXISTS `reply`;
3642CREATE TABLE `reply` (
3643  `id` int(11) NOT NULL,
3644  `reactionId` int(10) UNSIGNED NOT NULL,
3645  `userId` int(10) UNSIGNED NOT NULL,
3646  `reply` tinytext NOT NULL,
3647  `reported` int(11) DEFAULT '0',
3648  `upvoted` int(11) DEFAULT '0',
3649  `downvoted` int(11) DEFAULT '0',
3650  `dateCreated` datetime DEFAULT NULL
3651) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3652
3653--
3654-- Dumping data for table `reply`
3655--
3656
3657INSERT INTO `reply` (`id`, `reactionId`, `userId`, `reply`, `reported`, `upvoted`, `downvoted`, `dateCreated`) VALUES
3658(1, 2, 5, 'Niet cool man, niet cool!', 0, 2, 0, '2016-12-13 15:48:00'),
3659(2, 2, 7, 'HAHA!', 500, 12, 0, '2016-12-13 15:50:00'),
3660(3, 4, 5, 'Nou, nou. Dat mag ook wel wat minder.', 0, 4, 0, '2016-12-13 19:20:37'),
3661(4, 6, 7, 'Een beetje respect graag!', 0, 13, 0, '2016-12-14 16:09:25');
3662
3663-- --------------------------------------------------------
3664
3665--
3666-- Table structure for table `resetList`
3667--
3668
3669DROP TABLE IF EXISTS `resetList`;
3670CREATE TABLE `resetList` (
3671  `id` int(11) NOT NULL,
3672  `emailAddress` varchar(255) NOT NULL,
3673  `hash` varchar(255) NOT NULL,
3674  `dateCreated` datetime DEFAULT NULL
3675) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3676
3677--
3678-- Dumping data for table `resetList`
3679--
3680
3681INSERT INTO `resetList` (`id`, `emailAddress`, `hash`, `dateCreated`) VALUES
3682(1, 'wietse.l.devries@gmail.com', 'kjhrqwkjh32lkj5hl32kj4h', '2016-11-03 00:00:00');
3683
3684-- --------------------------------------------------------
3685
3686--
3687-- Table structure for table `setting`
3688--
3689
3690DROP TABLE IF EXISTS `setting`;
3691CREATE TABLE `setting` (
3692  `id` int(11) NOT NULL,
3693  `userId` int(10) UNSIGNED NOT NULL,
3694  `settingTypeId` int(10) UNSIGNED NOT NULL,
3695  `value` int(11) NOT NULL DEFAULT '0',
3696  `dateChanged` datetime DEFAULT NULL
3697) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3698
3699--
3700-- Dumping data for table `setting`
3701--
3702
3703INSERT INTO `setting` (`id`, `userId`, `settingTypeId`, `value`, `dateChanged`) VALUES
3704(1, 1, 2, 1, '2016-11-09 00:00:00'),
3705(2, 1, 3, 1, '2016-11-08 00:00:00');
3706
3707-- --------------------------------------------------------
3708
3709--
3710-- Table structure for table `settingType`
3711--
3712
3713DROP TABLE IF EXISTS `settingType`;
3714CREATE TABLE `settingType` (
3715  `id` int(10) UNSIGNED NOT NULL,
3716  `key` varchar(25) DEFAULT NULL,
3717  `value` varchar(255) DEFAULT NULL,
3718  `hidden` tinyint(1) NOT NULL DEFAULT '0'
3719) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3720
3721--
3722-- Dumping data for table `settingType`
3723--
3724
3725INSERT INTO `settingType` (`id`, `key`, `value`, `hidden`) VALUES
3726(1, 'email', 'Email notificaties ontvangen', 0),
3727(2, 'desktop', 'Desktop notificaties ontvangen', 0),
3728(3, 'work', 'Geen notificaties ontvangen tussen 09:00 en 17:00 uur', 0),
3729(4, 'digest', 'Periodiek een samenvattingen ontvangen per email', 0),
3730(5, 'layout', 'Open of gesloten weergave van vragen', 1),
3731(6, 'shareFacebook', 'Gebruiker heeft bij laatste actie gedeeld op fb', 1),
3732(7, 'shareTwitter', 'Gebruiker heeft bij laatste actie gedeeld op twitter', 1),
3733(8, 'followPage', 'Wilt u notificaties ontvangen voor nieuwe vragen op deze pagina?', 1);
3734
3735-- --------------------------------------------------------
3736
3737--
3738-- Table structure for table `tag`
3739--
3740
3741DROP TABLE IF EXISTS `tag`;
3742CREATE TABLE `tag` (
3743  `id` int(10) UNSIGNED NOT NULL,
3744  `questionId` int(11) NOT NULL,
3745  `tagValueId` int(11) NOT NULL,
3746  `dateCreated` datetime NOT NULL
3747) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3748
3749--
3750-- Dumping data for table `tag`
3751--
3752
3753INSERT INTO `tag` (`id`, `questionId`, `tagValueId`, `dateCreated`) VALUES
3754(1, 9, 4, '2016-12-13 21:14:41'),
3755(2, 10, 4, '2016-12-13 21:14:41'),
3756(3, 9, 10, '2016-12-13 21:16:28'),
3757(4, 9, 11, '2016-12-13 21:16:28'),
3758(5, 11, 21, '2016-12-13 21:19:17'),
3759(6, 10, 21, '2016-12-13 21:19:17'),
3760(7, 9, 21, '2016-12-13 21:19:17'),
3761(8, 8, 21, '2016-12-13 21:19:17'),
3762(9, 2, 21, '2016-12-13 21:19:17'),
3763(10, 2, 16, '2016-12-13 21:19:17'),
3764(11, 8, 16, '2016-12-13 21:19:17'),
3765(12, 9, 16, '2016-12-13 21:19:17'),
3766(13, 10, 16, '2016-12-13 21:19:17');
3767
3768-- --------------------------------------------------------
3769
3770--
3771-- Table structure for table `tagValue`
3772--
3773
3774DROP TABLE IF EXISTS `tagValue`;
3775CREATE TABLE `tagValue` (
3776  `id` int(10) UNSIGNED NOT NULL,
3777  `key` varchar(255) NOT NULL,
3778  `value` varchar(255) NOT NULL,
3779  `used` int(11) DEFAULT '0',
3780  `userId` int(10) UNSIGNED NOT NULL,
3781  `pageId` int(11) NOT NULL DEFAULT '0',
3782  `dateCreated` datetime DEFAULT NULL
3783) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3784
3785--
3786-- Dumping data for table `tagValue`
3787--
3788
3789INSERT INTO `tagValue` (`id`, `key`, `value`, `used`, `userId`, `pageId`, `dateCreated`) VALUES
3790(1, '', 'Onderwijs', 0, 0, 0, NULL),
3791(2, 'begroting', 'Begroting', 0, 1, 1, NULL),
3792(3, '', 'Defensie', 0, 0, 0, NULL),
3793(4, 'oorlog', 'Oorlog', 0, 0, 0, NULL),
3794(5, '', 'Vluchtelingen', 0, 0, 0, NULL),
3795(6, '', 'Rijkswaterstaat', 0, 0, 0, NULL),
3796(7, '', 'windmolens', 0, 0, 0, NULL),
3797(8, '', 'Groene energie', 0, 0, 0, NULL),
3798(9, '', 'Onderwijs', 0, 0, 0, NULL),
3799(10, 'syrie', 'Syrie', 0, 0, 0, NULL),
3800(11, 'isis', 'ISIS', 0, 0, 0, NULL),
3801(12, '', 'Olie', 0, 0, 0, NULL),
3802(13, '', 'VN (Verenigde naties)', 0, 0, 0, NULL),
3803(14, '', 'Burgermeester', 0, 0, 0, NULL),
3804(15, '', 'Eerste kamer', 0, 0, 0, NULL),
3805(16, 'tweede-kamer', 'Tweede kamer', 0, 0, 0, NULL),
3806(17, '', 'EU (Europese Unie)', 0, 0, 0, NULL),
3807(18, '', 'Discriminatie', 0, 0, 0, NULL),
3808(19, '', 'Sexisme', 0, 0, 0, NULL),
3809(20, '', 'Verkeer', 0, 0, 0, NULL),
3810(21, 'cultuur', 'Cultuur', 0, 0, 0, NULL),
3811(22, '', 'Wetenschap', 0, 0, 0, NULL),
3812(23, '', 'Koning', 0, 0, 0, NULL),
3813(24, '', 'Monarchie', 0, 0, 0, NULL),
3814(25, '', 'Willem-Alexander', 0, 0, 0, NULL),
3815(26, '', 'Justitie', 0, 0, 0, NULL),
3816(27, '', 'Politie', 0, 0, 0, NULL),
3817(28, '', 'Zorgverzekering', 0, 0, 0, NULL),
3818(29, '', 'Werkgelegenheid', 0, 0, 0, NULL),
3819(30, '', 'Sociale zaken', 0, 0, 0, NULL),
3820(31, '', 'Infrastructuur', 0, 0, 0, NULL),
3821(32, '', 'Drenthe', 0, 0, 0, NULL),
3822(33, '', 'Noord Brabant', 0, 0, 0, NULL),
3823(34, '', 'Noord Holland', 0, 0, 0, NULL),
3824(35, '', 'Gelderland', 0, 0, 0, NULL),
3825(36, '', 'Utrecht (Provincie)', 0, 0, 0, NULL),
3826(37, '', 'Friesland', 0, 0, 0, NULL),
3827(38, '', 'Zuid Holland', 0, 0, 0, NULL),
3828(39, '', 'Overijssel', 0, 0, 0, NULL),
3829(40, '', 'Flevoland', 0, 0, 0, NULL),
3830(41, '', 'Limburg', 0, 0, 0, NULL),
3831(42, '', 'Groningen (Provincie)', 0, 0, 0, NULL),
3832(43, '', 'Zeeland', 0, 0, 0, NULL),
3833(44, '', 'Ministerie van Algemene Zaken (A)', 0, 0, 0, NULL),
3834(45, '', 'Ministerie van Binnenlandse Zaken en Koninkrijksrelaties (BZK)', 0, 0, 0, NULL),
3835(46, '', 'Ministerie van Buitenlandse Zaken (BuZa)', 0, 0, 0, NULL),
3836(47, '', 'Ministerie van Defensie', 0, 0, 0, NULL),
3837(48, '', 'Ministerie van Economische Zaken (EZ)', 0, 0, 0, NULL),
3838(49, '', 'Ministerie van Financiën', 0, 0, 0, NULL),
3839(50, '', 'Ministerie van Infrastructuur en Milieu (I&M)', 0, 0, 0, NULL),
3840(51, '', 'Ministerie van Onderwijs, Cultuur en Wetenschap (OCW)', 0, 0, 0, NULL),
3841(52, '', 'Ministerie van Sociale Zaken en Werkgelegenheid (SZW)', 0, 0, 0, NULL),
3842(53, '', 'Ministerie van Veiligheid en Justitie (V&J)', 0, 0, 0, NULL),
3843(54, '', 'Ministerie van Volksgezondheid, Welzijn en Sport (VWS)', 0, 0, 0, NULL);
3844
3845-- --------------------------------------------------------
3846
3847--
3848-- Table structure for table `user`
3849--
3850
3851DROP TABLE IF EXISTS `user`;
3852CREATE TABLE `user` (
3853  `id` int(10) UNSIGNED NOT NULL,
3854  `token` varchar(255) NOT NULL,
3855  `email` varchar(255) NOT NULL,
3856  `password` varchar(255) DEFAULT NULL,
3857  `userName` varchar(255) NOT NULL,
3858  `avatar` varchar(255) DEFAULT NULL,
3859  `firstName` varchar(255) DEFAULT NULL,
3860  `lastName` varchar(255) DEFAULT NULL,
3861  `function` varchar(255) DEFAULT NULL,
3862  `bio` tinytext,
3863  `linkedinId` varchar(255) DEFAULT NULL,
3864  `googleId` varchar(255) DEFAULT NULL,
3865  `facebookId` varchar(255) DEFAULT NULL,
3866  `cityId` int(10) UNSIGNED NOT NULL,
3867  `ageId` int(10) UNSIGNED NOT NULL,
3868  `age` int(10) NOT NULL,
3869  `gender` enum('m','f') DEFAULT NULL,
3870  `educationId` int(10) UNSIGNED NOT NULL,
3871  `incomeId` int(10) UNSIGNED NOT NULL,
3872  `maritalStatusId` int(11) NOT NULL,
3873  `children` enum('y','n') DEFAULT NULL,
3874  `statusId` int(10) UNSIGNED DEFAULT '0',
3875  `verified` int(11) DEFAULT '0',
3876  `dateRegistered` datetime DEFAULT NULL,
3877  `lastLogin` datetime DEFAULT NULL,
3878  `loginCount` int(10) UNSIGNED DEFAULT '0',
3879  `reputation` int(10) UNSIGNED DEFAULT '0'
3880) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3881
3882--
3883-- Dumping data for table `user`
3884--
3885
3886INSERT 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
3887(1, '', 'wietse.l.devries@gmail.com', 'password123', 'wietse', 'wietsedevries.png', 'Wietse', 'de Vries', 'Schapenherder', 'De laatste keer dat ik telde, had ik 435 schapen. Daarna viel ik in slaap.', 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),
3888(2, 'mas7h0em24l6h5bzz1tt9', 'tijmenhelder@gmail.com', '$2a$06$r6eV5umPCRCeLYz8xj1MhOnKXgUosAo4CQDGCIoFcaZZG7nV4e7DS', 'TijmenH', 'tijmenhelder.gif', 'Tijmen', 'Helder', 'Eigenaar Burgerzetel.nl', 'Met burgerzetel zet ik me in voor betere politiek!', '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),
3889(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 10:38:34', 4, 45),
3890(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),
3891(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),
3892(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),
3893(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);
3894
3895-- --------------------------------------------------------
3896
3897--
3898-- Table structure for table `visit`
3899--
3900
3901DROP TABLE IF EXISTS `visit`;
3902CREATE TABLE `visit` (
3903  `id` int(10) UNSIGNED NOT NULL,
3904  `questionId` int(10) UNSIGNED NOT NULL,
3905  `userId` int(10) UNSIGNED NOT NULL,
3906  `count` int(11) NOT NULL DEFAULT '0' COMMENT 'track which question a user has visited. If more than once, increment ‘count’',
3907  `dateCreated` datetime DEFAULT NULL,
3908  `tagValueId` int(11) NOT NULL
3909) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3910
3911--
3912-- Dumping data for table `visit`
3913--
3914
3915INSERT INTO `visit` (`id`, `questionId`, `userId`, `count`, `dateCreated`, `tagValueId`) VALUES
3916(1, 1, 1, 23, '2016-11-09 00:00:00', 0),
3917(3, 1, 1, 12, '2016-11-02 00:00:00', 0);
3918
3919--
3920-- Indexes for dumped tables
3921--
3922
3923--
3924-- Indexes for table `age`
3925--
3926ALTER TABLE `age`
3927  ADD PRIMARY KEY (`id`);
3928
3929--
3930-- Indexes for table `answer`
3931--
3932ALTER TABLE `answer`
3933  ADD PRIMARY KEY (`id`),
3934  ADD KEY `fk_answer1_idx` (`questionId`),
3935  ADD KEY `fk_answer2_idx` (`userId`);
3936
3937--
3938-- Indexes for table `answerMedium`
3939--
3940ALTER TABLE `answerMedium`
3941  ADD PRIMARY KEY (`id`),
3942  ADD KEY `fk_answer_medium1_idx` (`answerId`),
3943  ADD KEY `fk_answer_medium2_idx` (`mediumTypeId`);
3944
3945--
3946-- Indexes for table `city`
3947--
3948ALTER TABLE `city`
3949  ADD PRIMARY KEY (`id`),
3950  ADD KEY `fk_city1_idx` (`municipalityId`);
3951
3952--
3953-- Indexes for table `content`
3954--
3955ALTER TABLE `content`
3956  ADD PRIMARY KEY (`id`);
3957
3958--
3959-- Indexes for table `education`
3960--
3961ALTER TABLE `education`
3962  ADD PRIMARY KEY (`id`);
3963
3964--
3965-- Indexes for table `faq`
3966--
3967ALTER TABLE `faq`
3968  ADD PRIMARY KEY (`id`);
3969
3970--
3971-- Indexes for table `favorite`
3972--
3973ALTER TABLE `favorite`
3974  ADD PRIMARY KEY (`id`),
3975  ADD KEY `fk_favorite2_idx` (`userId`);
3976
3977--
3978-- Indexes for table `income`
3979--
3980ALTER TABLE `income`
3981  ADD PRIMARY KEY (`id`);
3982
3983--
3984-- Indexes for table `interest`
3985--
3986ALTER TABLE `interest`
3987  ADD PRIMARY KEY (`id`);
3988
3989--
3990-- Indexes for table `maritalStatus`
3991--
3992ALTER TABLE `maritalStatus`
3993  ADD PRIMARY KEY (`id`);
3994
3995--
3996-- Indexes for table `mediumType`
3997--
3998ALTER TABLE `mediumType`
3999  ADD PRIMARY KEY (`id`);
4000
4001--
4002-- Indexes for table `milestone`
4003--
4004ALTER TABLE `milestone`
4005  ADD PRIMARY KEY (`id`);
4006
4007--
4008-- Indexes for table `milestoneType`
4009--
4010ALTER TABLE `milestoneType`
4011  ADD PRIMARY KEY (`id`),
4012  ADD UNIQUE KEY `id` (`id`);
4013
4014--
4015-- Indexes for table `municipality`
4016--
4017ALTER TABLE `municipality`
4018  ADD PRIMARY KEY (`id`),
4019  ADD KEY `fk_municipality1_idx` (`provinceId`);
4020
4021--
4022-- Indexes for table `notification`
4023--
4024ALTER TABLE `notification`
4025  ADD PRIMARY KEY (`id`),
4026  ADD KEY `fk_notification1_idx` (`notificationTypeId`),
4027  ADD KEY `fk_notification2_idx` (`userId`),
4028  ADD KEY `fk_notification3_idx` (`questionId`),
4029  ADD KEY `fk_notification4_idx` (`answerId`);
4030
4031--
4032-- Indexes for table `notificationType`
4033--
4034ALTER TABLE `notificationType`
4035  ADD PRIMARY KEY (`id`);
4036
4037--
4038-- Indexes for table `page`
4039--
4040ALTER TABLE `page`
4041  ADD PRIMARY KEY (`id`);
4042
4043--
4044-- Indexes for table `party`
4045--
4046ALTER TABLE `party`
4047  ADD PRIMARY KEY (`id`);
4048
4049--
4050-- Indexes for table `poll`
4051--
4052ALTER TABLE `poll`
4053  ADD PRIMARY KEY (`id`),
4054  ADD KEY `fk_poll1_idx` (`questionId`);
4055
4056--
4057-- Indexes for table `pollOption`
4058--
4059ALTER TABLE `pollOption`
4060  ADD PRIMARY KEY (`id`),
4061  ADD KEY `fk_poll_option1_idx` (`pollId`);
4062
4063--
4064-- Indexes for table `pollVote`
4065--
4066ALTER TABLE `pollVote`
4067  ADD PRIMARY KEY (`id`),
4068  ADD KEY `fk_poll_vote1_idx` (`userId`),
4069  ADD KEY `fk_poll_vote3_idx` (`pollOptionId`);
4070
4071--
4072-- Indexes for table `province`
4073--
4074ALTER TABLE `province`
4075  ADD PRIMARY KEY (`id`);
4076
4077--
4078-- Indexes for table `question`
4079--
4080ALTER TABLE `question`
4081  ADD PRIMARY KEY (`id`),
4082  ADD UNIQUE KEY `slug_UNIQUE` (`slug`),
4083  ADD KEY `fk_question1_idx` (`userId`);
4084
4085--
4086-- Indexes for table `questionInvite`
4087--
4088ALTER TABLE `questionInvite`
4089  ADD PRIMARY KEY (`id`),
4090  ADD KEY `fk_question_invite1_idx` (`to`),
4091  ADD KEY `fk_question_invite2_idx` (`from`);
4092
4093--
4094-- Indexes for table `questionMedium`
4095--
4096ALTER TABLE `questionMedium`
4097  ADD PRIMARY KEY (`id`),
4098  ADD KEY `fk_question_medium1_idx` (`questionId`),
4099  ADD KEY `fk_question_medium2_idx` (`mediumTypeId`);
4100
4101--
4102-- Indexes for table `reaction`
4103--
4104ALTER TABLE `reaction`
4105  ADD PRIMARY KEY (`id`),
4106  ADD KEY `fk_reaction1_idx` (`answerId`),
4107  ADD KEY `fk_reaction2_idx` (`userId`);
4108
4109--
4110-- Indexes for table `reply`
4111--
4112ALTER TABLE `reply`
4113  ADD PRIMARY KEY (`id`),
4114  ADD KEY `fk_reply1_idx` (`userId`),
4115  ADD KEY `fk_reply2_idx` (`reactionId`);
4116
4117--
4118-- Indexes for table `resetList`
4119--
4120ALTER TABLE `resetList`
4121  ADD PRIMARY KEY (`id`);
4122
4123--
4124-- Indexes for table `setting`
4125--
4126ALTER TABLE `setting`
4127  ADD PRIMARY KEY (`id`),
4128  ADD KEY `fk_setting1_idx` (`userId`),
4129  ADD KEY `fk_setting2_idx` (`settingTypeId`);
4130
4131--
4132-- Indexes for table `settingType`
4133--
4134ALTER TABLE `settingType`
4135  ADD PRIMARY KEY (`id`);
4136
4137--
4138-- Indexes for table `tag`
4139--
4140ALTER TABLE `tag`
4141  ADD PRIMARY KEY (`id`);
4142
4143--
4144-- Indexes for table `tagValue`
4145--
4146ALTER TABLE `tagValue`
4147  ADD PRIMARY KEY (`id`),
4148  ADD UNIQUE KEY `id` (`id`);
4149
4150--
4151-- Indexes for table `user`
4152--
4153ALTER TABLE `user`
4154  ADD PRIMARY KEY (`id`),
4155  ADD KEY `fk_user1_idx` (`ageId`),
4156  ADD KEY `fk_user2_idx` (`educationId`),
4157  ADD KEY `fk_user3_idx` (`maritalStatusId`),
4158  ADD KEY `fk_user4_idx` (`incomeId`),
4159  ADD KEY `fk_user5_idx` (`cityId`);
4160
4161--
4162-- Indexes for table `visit`
4163--
4164ALTER TABLE `visit`
4165  ADD PRIMARY KEY (`id`);
4166
4167--
4168-- AUTO_INCREMENT for dumped tables
4169--
4170
4171--
4172-- AUTO_INCREMENT for table `age`
4173--
4174ALTER TABLE `age`
4175  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
4176--
4177-- AUTO_INCREMENT for table `answer`
4178--
4179ALTER TABLE `answer`
4180  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4181--
4182-- AUTO_INCREMENT for table `answerMedium`
4183--
4184ALTER TABLE `answerMedium`
4185  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
4186--
4187-- AUTO_INCREMENT for table `content`
4188--
4189ALTER TABLE `content`
4190  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4191--
4192-- AUTO_INCREMENT for table `education`
4193--
4194ALTER TABLE `education`
4195  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
4196--
4197-- AUTO_INCREMENT for table `faq`
4198--
4199ALTER TABLE `faq`
4200  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4201--
4202-- AUTO_INCREMENT for table `favorite`
4203--
4204ALTER TABLE `favorite`
4205  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
4206--
4207-- AUTO_INCREMENT for table `income`
4208--
4209ALTER TABLE `income`
4210  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4211--
4212-- AUTO_INCREMENT for table `interest`
4213--
4214ALTER TABLE `interest`
4215  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4216--
4217-- AUTO_INCREMENT for table `maritalStatus`
4218--
4219ALTER TABLE `maritalStatus`
4220  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
4221--
4222-- AUTO_INCREMENT for table `mediumType`
4223--
4224ALTER TABLE `mediumType`
4225  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4226--
4227-- AUTO_INCREMENT for table `milestone`
4228--
4229ALTER TABLE `milestone`
4230  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
4231--
4232-- AUTO_INCREMENT for table `milestoneType`
4233--
4234ALTER TABLE `milestoneType`
4235  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
4236--
4237-- AUTO_INCREMENT for table `notification`
4238--
4239ALTER TABLE `notification`
4240  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4241--
4242-- AUTO_INCREMENT for table `notificationType`
4243--
4244ALTER TABLE `notificationType`
4245  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4246--
4247-- AUTO_INCREMENT for table `page`
4248--
4249ALTER TABLE `page`
4250  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4251--
4252-- AUTO_INCREMENT for table `party`
4253--
4254ALTER TABLE `party`
4255  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
4256--
4257-- AUTO_INCREMENT for table `poll`
4258--
4259ALTER TABLE `poll`
4260  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
4261--
4262-- AUTO_INCREMENT for table `pollOption`
4263--
4264ALTER TABLE `pollOption`
4265  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
4266--
4267-- AUTO_INCREMENT for table `pollVote`
4268--
4269ALTER TABLE `pollVote`
4270  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
4271--
4272-- AUTO_INCREMENT for table `province`
4273--
4274ALTER TABLE `province`
4275  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
4276--
4277-- AUTO_INCREMENT for table `question`
4278--
4279ALTER TABLE `question`
4280  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
4281--
4282-- AUTO_INCREMENT for table `questionInvite`
4283--
4284ALTER TABLE `questionInvite`
4285  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4286--
4287-- AUTO_INCREMENT for table `questionMedium`
4288--
4289ALTER TABLE `questionMedium`
4290  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4291--
4292-- AUTO_INCREMENT for table `reaction`
4293--
4294ALTER TABLE `reaction`
4295  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
4296--
4297-- AUTO_INCREMENT for table `reply`
4298--
4299ALTER TABLE `reply`
4300  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
4301--
4302-- AUTO_INCREMENT for table `resetList`
4303--
4304ALTER TABLE `resetList`
4305  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
4306--
4307-- AUTO_INCREMENT for table `setting`
4308--
4309ALTER TABLE `setting`
4310  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
4311--
4312-- AUTO_INCREMENT for table `settingType`
4313--
4314ALTER TABLE `settingType`
4315  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4316--
4317-- AUTO_INCREMENT for table `tag`
4318--
4319ALTER TABLE `tag`
4320  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
4321--
4322-- AUTO_INCREMENT for table `tagValue`
4323--
4324ALTER TABLE `tagValue`
4325  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;
4326--
4327-- AUTO_INCREMENT for table `user`
4328--
4329ALTER TABLE `user`
4330  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
4331--
4332-- AUTO_INCREMENT for table `visit`
4333--
4334ALTER TABLE `visit`
4335  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;