· 9 years ago · Dec 22, 2016, 03:34 PM
1-- phpMyAdmin SQL Dump
2-- version 4.6.4
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:3306
6-- Generation Time: Dec 22, 2016 at 04:32 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 `party`
21--
22
23DROP TABLE IF EXISTS `party`;
24CREATE TABLE `party` (
25 `id` int(11) NOT NULL,
26 `leader` varchar(255) DEFAULT NULL,
27 `leaderUrl` varchar(255) DEFAULT NULL,
28 `established` int(11) DEFAULT NULL,
29 `members` int(11) DEFAULT NULL,
30 `seatsFirst` int(11) DEFAULT NULL,
31 `seatsSecond` int(11) DEFAULT NULL,
32 `seatsEU` int(11) DEFAULT NULL
33) ENGINE=InnoDB DEFAULT CHARSET=utf8;
34
35--
36-- Dumping data for table `party`
37--
38
39INSERT INTO `party` (`id`, `leader`, `leaderUrl`, `established`, `members`, `seatsFirst`, `seatsSecond`, `seatsEU`) VALUES
40(1, 'Mark Rutte', NULL, 1948, 28436, 13, 40, 3),
41(2, 'Sybrand Buma', NULL, 1980, 50181, 12, 13, 5),
42(3, 'Gert-Jan Segers', NULL, 2001, 23398, 3, 5, 1),
43(4, 'Alexander Pechtold', NULL, 1966, 25349, 10, 12, 4),
44(5, 'Jesse Klaver', NULL, 1990, 21180, 4, 4, 2),
45(6, 'Lodewijk Asscher', NULL, 1946, 46045, 8, 36, 3),
46(7, 'Marianne Thieme', NULL, 2002, 12131, 2, 2, 1),
47(8, 'Kees van der Staaij', NULL, 1918, 29928, 2, 3, 1),
48(9, 'Emile Roemer', NULL, 1971, 41710, 9, 15, 2),
49(10, 'Jan Roos', NULL, 2014, 1150, 0, 2, 0),
50(11, 'Norbert Klein', NULL, 2014, 287, 0, 1, 0),
51(12, 'Henk Krol', NULL, 2009, 6056, 2, 1, 0),
52(13, 'Ancilla van de Leest', NULL, 2010, 6056, 0, 0, 0),
53(14, 'Tunahan Kuzu', NULL, 2015, 0, 0, 0, 0),
54(15, 'Geert Wilders', NULL, 2006, 1, 9, 12, 4),
55(16, 'Henk ten Hoeve', NULL, 1999, 0, 1, 0, 0),
56(17, 'Jacques Monasch', NULL, 2016, 0, 0, 0, 0);
57
58--
59-- Indexes for dumped tables
60--
61
62--
63-- Indexes for table `party`
64--
65ALTER TABLE `party`
66 ADD PRIMARY KEY (`id`);
67
68--
69-- AUTO_INCREMENT for dumped tables
70--
71
72--
73-- AUTO_INCREMENT for table `party`
74--
75ALTER TABLE `party`
76 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;