i6mWeeHj

1-- phpMyAdmin SQL Dump
2-- version 4.4.10
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Dec 14, 2016 at 02:08 PM
7-- Server version: 5.5.42
8-- PHP Version: 5.6.10
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 `tagValue`
21--
22
23DROP TABLE IF EXISTS `tagValue`;
24CREATE TABLE `tagValue` (
25  `id` int(10) unsigned NOT NULL,
26  `key` varchar(255) NOT NULL,
27  `value` varchar(255) NOT NULL,
28  `used` int(11) DEFAULT '0',
29  `userId` int(10) unsigned NOT NULL,
30  `pageId` int(11) NOT NULL DEFAULT '0',
31  `dateCreated` datetime DEFAULT NULL
32) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
33
34--
35-- Dumping data for table `tagValue`
36--
37
38INSERT INTO `tagValue` (`id`, `key`, `value`, `used`, `userId`, `pageId`, `dateCreated`) VALUES
39(1, 'onderwijs', 'Onderwijs', 0, 0, 0, NULL),
40(2, 'begroting', 'Begroting', 0, 1, 1, NULL),
41(3, 'defensie', 'Defensie', 0, 0, 0, NULL),
42(4, 'oorlog', 'Oorlog', 0, 0, 0, NULL),
43(5, 'vluchtelingen', 'Vluchtelingen', 0, 0, 0, NULL),
44(6, 'rijkswaterstaat', 'Rijkswaterstaat', 0, 0, 0, NULL),
45(7, 'windmolens', 'windmolens', 0, 0, 0, NULL),
46(8, 'groene-energie', 'Groene energie', 0, 0, 0, NULL),
47(9, 'onderwijs', 'Onderwijs', 0, 0, 0, NULL),
48(10, 'syrie', 'Syrie', 0, 0, 0, NULL),
49(11, 'isis', 'ISIS', 0, 0, 0, NULL),
50(12, 'olie', 'Olie', 0, 0, 0, NULL),
51(13, 'vn', 'VN (Verenigde naties)', 0, 0, 0, NULL),
52(14, 'burgermeester', 'Burgermeester', 0, 0, 0, NULL),
53(15, 'eerste-kamer', 'Eerste kamer', 0, 0, 0, NULL),
54(16, 'tweede-kamer', 'Tweede kamer', 0, 0, 0, NULL),
55(17, 'eu', 'EU (Europese Unie)', 0, 0, 0, NULL),
56(18, 'discriminatie', 'Discriminatie', 0, 0, 0, NULL),
57(19, 'sexisme', 'Sexisme', 0, 0, 0, NULL),
58(20, 'verkeer', 'Verkeer', 0, 0, 0, NULL),
59(21, 'cultuur', 'Cultuur', 0, 0, 0, NULL),
60(22, 'wetenschap', 'Wetenschap', 0, 0, 0, NULL),
61(23, 'koning', 'Koning', 0, 0, 0, NULL),
62(24, 'monarchie', 'Monarchie', 0, 0, 0, NULL),
63(25, 'willem-alexander', 'Willem-Alexander', 0, 0, 0, NULL),
64(26, 'justitie', 'Justitie', 0, 0, 0, NULL),
65(27, 'politie', 'Politie', 0, 0, 0, NULL),
66(28, 'zorgverzekering', 'Zorgverzekering', 0, 0, 0, NULL),
67(29, 'werkgelegenheid', 'Werkgelegenheid', 0, 0, 0, NULL),
68(30, 'sociale-zaken', 'Sociale zaken', 0, 0, 0, NULL),
69(31, 'Infrastructuur', 'Infrastructuur', 0, 0, 0, NULL),
70(32, 'Drenthe', 'Drenthe', 0, 0, 0, NULL),
71(33, 'Noord-Brabant', 'Noord Brabant', 0, 0, 0, NULL),
72(34, '', 'Noord Holland', 0, 0, 0, NULL),
73(35, '', 'Gelderland', 0, 0, 0, NULL),
74(36, '', 'Utrecht (Provincie)', 0, 0, 0, NULL),
75(37, '', 'Friesland', 0, 0, 0, NULL),
76(38, '', 'Zuid Holland', 0, 0, 0, NULL),
77(39, '', 'Overijssel', 0, 0, 0, NULL),
78(40, '', 'Flevoland', 0, 0, 0, NULL),
79(41, '', 'Limburg', 0, 0, 0, NULL),
80(42, '', 'Groningen (Provincie)', 0, 0, 0, NULL),
81(43, '', 'Zeeland', 0, 0, 0, NULL),
82(44, '', 'Ministerie van Algemene Zaken (A)', 0, 0, 0, NULL),
83(45, '', 'Ministerie van Binnenlandse Zaken en Koninkrijksrelaties (BZK)', 0, 0, 0, NULL),
84(46, '', 'Ministerie van Buitenlandse Zaken (BuZa)', 0, 0, 0, NULL),
85(47, '', 'Ministerie van Defensie', 0, 0, 0, NULL),
86(48, '', 'Ministerie van Economische Zaken (EZ)', 0, 0, 0, NULL),
87(49, '', 'Ministerie van Financiën', 0, 0, 0, NULL),
88(50, '', 'Ministerie van Infrastructuur en Milieu (I&M)', 0, 0, 0, NULL),
89(51, '', 'Ministerie van Onderwijs, Cultuur en Wetenschap (OCW)', 0, 0, 0, NULL),
90(52, '', 'Ministerie van Sociale Zaken en Werkgelegenheid (SZW)', 0, 0, 0, NULL),
91(53, '', 'Ministerie van Veiligheid en Justitie (V&J)', 0, 0, 0, NULL),
92(54, '', 'Ministerie van Volksgezondheid, Welzijn en Sport (VWS)', 0, 0, 0, NULL),
93(55, 'pvv', 'Partij voor de Vrijheid (PVV)', 12, 1, 0, '2016-12-15 00:00:00'),
94(56, 'homosexualiteit', 'homosexualiteit', 74, 2, 0, '2016-12-16 00:00:00');
95
96--
97-- Indexes for dumped tables
98--
99
100--
101-- Indexes for table `tagValue`
102--
103ALTER TABLE `tagValue`
104  ADD PRIMARY KEY (`id`),
105  ADD UNIQUE KEY `id` (`id`);
106
107--
108-- AUTO_INCREMENT for dumped tables
109--
110
111--
112-- AUTO_INCREMENT for table `tagValue`
113--
114ALTER TABLE `tagValue`
115  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=57;