SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;


CREATE TABLE IF NOT EXISTS `bundeskanzler` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `familienname` varchar(30) NOT NULL,
  `vorname` varchar(30) NOT NULL,
  `geschlecht` enum('m','w') NOT NULL,
  `bundesland` varchar(2) NOT NULL,
  `partei` varchar(20) DEFAULT NULL,
  `beginnAmtszeit` int(4) NOT NULL,
  `endeAmtszeit` int(4) DEFAULT NULL,
  `jahresgehalt` int(6) NOT NULL,
  `notiz` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bundesland` (`bundesland`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

INSERT INTO `bundeskanzler` (`id`, `familienname`, `vorname`, `geschlecht`, `bundesland`, `partei`, `beginnAmtszeit`, `endeAmtszeit`, `jahresgehalt`, `notiz`) VALUES
(1, 'Merkel', 'Angela', 'w', 'MV', 'CDU', 2005, 2021, 330000, ''),
(2, 'Schröder', 'Gerhard', 'm', 'NI', 'SPD', 1998, 2005, 350000, ''),
(3, 'Kiesinger', 'Kurt Georg', 'm', 'BW', 'CDU', 1965, 1969, 120000, ''),
(4, 'Schmitt', 'Helmut', 'm', 'HH', 'SPD', 1974, 1982, 220000, ''),
(5, 'Kohl', 'Helmut', 'm', 'RP', 'CDU', 1982, 1998, 350000, ''),
(6, 'Adenauer', 'Konrad', 'm', 'NW', 'CDU', 1949, 1963, 75000, ''),
(7, 'Erhard', 'Ludwig', 'm', 'BY', 'CDU', 1963, 1965, 85000, ''),
(8, 'Scholz', 'Olaf', 'm', 'HH', 'SPD', 2021, NULL, 330000, ''),
(9, 'Brandt', 'Willy', 'm', 'BE', 'SPD', 1969, 1974, 150000, '');

CREATE TABLE IF NOT EXISTS `bundesland` (
  `kuerzel` varchar(2) NOT NULL,
  `name` varchar(30) NOT NULL,
  `bundesratsstimmen` int(2) NOT NULL,
  `flaeche` double(15,1) NOT NULL,
  `einwohnerzahl` bigint(15) NOT NULL,
  `bruttoinlandsprodukt` double(15,1) NOT NULL,
  PRIMARY KEY (`kuerzel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

INSERT INTO `bundesland` (`kuerzel`, `name`, `bundesratsstimmen`, `flaeche`, `einwohnerzahl`, `bruttoinlandsprodukt`) VALUES
('BB', 'Brandenburg', 4, 29479.0, 2518304, 76.2),
('BE', 'Berlin', 4, 891.8, 3769495, 143.3),
('BW', 'Baden-Württemberg', 6, 35751.0, 11100394, 500.8),
('BY', 'Bayern', 6, 70550.0, 13124737, 624.6),
('HB', 'Bremen', 3, 419.4, 682986, 29.9),
('HE', 'Hessen', 5, 21114.0, 6288080, 285.9),
('HH', 'Hamburg', 3, 755.2, 1845685, 118.9),
('MV', 'Mecklenburg-Vorpommern', 3, 23174.0, 1609675, 46.4),
('NI', 'Niedersachsen', 6, 47624.0, 7982448, 334.1),
('NW', 'Nordrhein-Westfalen', 6, 34083.0, 17947221, 741.9),
('RP', 'Rheinland-Pfalz', 4, 19847.0, 4082000, 155.3),
('SH', 'Schleswig-Holstein', 4, 15799.0, 2859685, 106.4),
('SL', 'Saarland', 3, 2569.0, 986887, 35.2),
('SN', 'Sachsen', 4, 18416.0, 4085949, 123.8),
('ST', 'Sachsen-Anhalt', 4, 20445.0, 2209208, 68.6),
('TH', 'Thüringen', 4, 16172.0, 2134545, 64.4);

CREATE TABLE IF NOT EXISTS `ex_ministerpraesident` (
  `bundeskanzler` int(3) NOT NULL,
  `ministerpräsident` int(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `ex_ministerpraesident` (`bundeskanzler`, `ministerpräsident`) VALUES
(2, 57),
(3, 112),
(5, 80),
(8, 125),
(9, 168);

CREATE TABLE IF NOT EXISTS `ministerpraesident` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `familienname` varchar(30) NOT NULL,
  `vorname` varchar(30) NOT NULL,
  `geschlecht` enum('m','w') NOT NULL,
  `bundesland` varchar(2) NOT NULL,
  `partei` varchar(20) DEFAULT NULL,
  `beginnAmtszeit` int(4) NOT NULL,
  `endeAmtszeit` int(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bundesland` (`bundesland`)
) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

INSERT INTO `ministerpraesident` (`id`, `familienname`, `vorname`, `geschlecht`, `bundesland`, `partei`, `beginnAmtszeit`, `endeAmtszeit`) VALUES
(1, 'Osswald', 'Albert', 'm', 'HE', 'SPD', 1969, 1976),
(2, 'Goppel', 'Alfons', 'm', 'BY', 'CSU', 1954, 1978),
(3, 'Gomolka', 'Alfred', 'm', 'MV', 'CDU', 1990, 1992),
(4, 'Kubel', 'Alfred', 'm', 'NI', 'SPD', 1970, 1976),
(5, 'Bovenschulte', 'Andreas', 'm', 'HB', 'SPD', 2019, NULL),
(6, 'Rehlinger', 'Anke', 'w', 'SL', 'SPD', 2018, 2018),
(7, 'Rehlinger', 'Anke', 'w', 'SL', 'SPD', 2022, NULL),
(8, 'Kramp-Karrenbauer', 'Annegret', 'w', 'SL', 'CDU', 2011, 2018),
(9, 'Laschet', 'Armin', 'm', 'NW', 'CDU', 2017, 2021),
(10, 'Seite', 'Berndt', 'm', 'MV', 'CDU', 1992, 1998),
(11, 'Vogel', 'Bernhard', 'm', 'RP', 'CDU', 1976, 1988),
(12, 'Vogel', 'Bernhard', 'm', 'TH', 'CDU', 1992, 2003),
(13, 'Engholm', 'Björn', 'm', 'SH', 'SPD', 1988, 1993),
(14, 'Ramelow', 'Bodo', 'm', 'TH', 'DIE LINKE', 2014, 2020),
(15, 'Ramelow', 'Bodo', 'm', 'TH', 'DIE LINKE', 2020, NULL),
(16, 'Rhein', 'Boris', 'm', 'HE', 'CDU', 2022, NULL),
(17, 'Diekmann', 'Bruno', 'm', 'SH', 'SPD', 1949, 1950),
(18, 'Wagner', 'Carl-Ludwig', 'm', 'RP', 'CDU', 1988, 1991),
(19, 'Sieling', 'Carsten', 'm', 'HB', 'SPD', 2015, 2019),
(20, 'Stock', 'Christian', 'm', 'HE', 'SPD', 1946, 1950),
(21, 'Wulff', 'Christian', 'm', 'NI', 'CDU', 2003, 2010),
(22, 'Krajewski', 'Christiane', 'w', 'SL', 'SPD', 1998, 1998),
(23, 'Lieberknecht', 'Christine', 'w', 'TH', 'CDU', 2009, 2014),
(24, 'Ahlhaus', 'Christoph', 'm', 'HH', 'CDU', 2010, 2011),
(25, 'Bergner', 'Christoph', 'm', 'ST', 'CDU', 1993, 1994),
(26, 'Hartmann', 'Christoph', 'm', 'SL', 'FDP', 2011, 2011),
(27, 'Günther', 'Daniel', 'm', 'SH', 'CDU', 2017, NULL),
(28, 'McAllister', 'David', 'm', 'NI', 'CDU', 2010, 2013),
(29, 'Althaus', 'Dieter', 'm', 'TH', 'CDU', 2003, 2009),
(30, 'Biallas', 'Dieter', 'm', 'HH', 'FDP', 1974, 1974),
(31, 'Woidke', 'Dietmar', 'm', 'BB', 'SPD', 2013, NULL),
(32, 'Stobbe', 'Dietrich', 'm', 'BE', 'SPD', 1977, 1981),
(33, 'Diepgen', 'Eberhard', 'm', 'BE', 'CDU', 1984, 1989),
(34, 'Diepgen', 'Eberhard', 'm', 'BE', 'CDU', 1991, 2001),
(35, 'Engelhard', 'Edgar', 'm', 'HH', 'FDP', 1960, 1961),
(36, 'Stoiber', 'Edmund', 'm', 'BY', 'CSU', 1993, 2007),
(37, 'Reinert', 'Egon', 'm', 'SL', 'CDU', 1957, 1959),
(38, 'Rittershaus', 'Erhard', 'm', 'HH', NULL, 1997, 1997),
(39, 'Albrecht', 'Ernst', 'm', 'NI', 'CDU', 1976, 1990),
(40, 'Reuter', 'Ernst', 'm', 'BE', 'SPD', 1948, 1953),
(41, 'Müller', 'Erwin', 'm', 'SL', NULL, 1946, 1947),
(42, 'Sellering', 'Erwin', 'm', 'MV', 'SPD', 2008, 2017),
(43, 'Teufel', 'Erwin', 'm', 'BW', 'CDU', 1991, 2005),
(44, 'Amrehn', 'Franz', 'm', 'BE', 'CDU', 1957, 1957),
(45, 'Meyers', 'Franz', 'm', 'NW', 'CDU', 1958, 1966),
(46, 'Giffey', 'Franziska', 'w', 'BE', 'SPD', 2021, 2023),
(47, 'Röder', 'Franz-Josef', 'm', 'SL', 'CDU', 1959, 1979),
(48, 'Strauß', 'Franz-Josef', 'm', 'BY', 'CSU', 1978, 1988),
(49, 'Lübke', 'Friedrich Wilhelm', 'm', 'SH', 'CDU', 1951, 1954),
(50, 'Schaeffler', 'Fritz', 'm', 'BY', 'CSU', 1945, 1945),
(51, 'Steinhoff', 'Fritz', 'm', 'NW', 'SPD', 1956, 1958),
(52, 'Müller', 'Gebhard', 'm', 'BW', 'CDU', 1953, 1958),
(53, 'Milbradt', 'Georg', 'm', 'SN', 'CDU', 2002, 2008),
(54, 'Diederichs', 'Georg-August', 'm', 'NI', 'SPD', 1961, 1970),
(55, 'Zinn', 'Georg-August', 'm', 'HE', 'SPD', 1950, 1969),
(56, 'Glogowski', 'Gerhard', 'm', 'NI', 'SPD', 1998, 1999),
(57, 'Schröder', 'Gerhard', 'm', 'NI', 'Grüne', 1990, 1998),
(58, 'Stoltenberg', 'Gerhard', 'm', 'SH', 'CDU', 1971, 1982),
(59, 'Beckstein', 'Günther', 'm', 'BY', 'CSU', 2007, 2008),
(60, 'Oettinger', 'Günther', 'm', 'BW', 'CDU', 2005, 2010),
(61, 'Kraft', 'Hannelore', 'w', 'NW', 'SPD', 2010, 2017),
(62, 'Seidel', 'Hanns', 'm', 'BY', 'CSU', 1957, 1960),
(63, 'Ehard', 'Hans', 'm', 'BY', 'CSU', 1946, 1954),
(64, 'Ehard', 'Hans', 'm', 'BY', 'CSU', 1960, 1962),
(65, 'Eichel', 'Hans', 'm', 'HE', 'SPD', 1991, 1999),
(66, 'Filbinger', 'Hans', 'm', 'BW', 'CDU', 1966, 1978),
(67, 'Geisler', 'Hans', 'm', 'SN', 'CDU', 2002, 2002),
(68, 'Koschnick', 'Hans', 'm', 'HB', 'SPD', 1967, 1985),
(69, 'Neureuter', 'Hans', 'm', 'SL', NULL, 1945, 1946),
(70, 'Vogel', 'Hans-Jochen', 'm', 'BE', 'SPD', 1981, 1981),
(71, 'Klose', 'Hans-Ulrich', 'm', 'HH', 'SPD', 1974, 1981),
(72, 'Ringstorff', 'Harald', 'm', 'MV', 'SPD', 1998, 2008),
(73, 'Simonis', 'Heide', 'w', 'SH', 'SPD', 1993, 2005),
(74, 'Albertz', 'Heinrich', 'm', 'BE', 'SPD', 1966, 1967),
(75, 'Hellwege', 'Heinrich', 'm', 'NI', NULL, 1955, 1959),
(76, 'Welsch', 'Heinrich', 'm', 'SL', NULL, 1955, 1956),
(77, 'Kühn', 'Heinz', 'm', 'NW', 'SPD', 1966, 1978),
(78, 'Karry', 'Heinz-Herbert', 'm', 'HE', 'FDP', 1976, 1976),
(79, 'Elstner', 'Helga', 'w', 'HH', 'SPD', 1981, 1981),
(80, 'Kohl', 'Helmut', 'm', 'RP', 'CDU', 1969, 1976),
(81, 'Lemke', 'Helmut', 'm', 'SH', 'CDU', 1963, 1971),
(82, 'Wüst', 'Hendrik', 'm', 'NW', 'CDU', 2021, NULL),
(83, 'Scherf', 'Henning', 'm', 'HB', 'SPD', 1995, 2005),
(84, 'Schwarz', 'Henning', 'm', 'SH', 'CDU', 1987, 1988),
(85, 'Voscherau', 'Henning', 'm', 'HH', 'SPD', 1988, 1997),
(86, 'Weichmann', 'Herbert', 'm', 'HH', 'SPD', 1965, 1971),
(87, 'Lüdemann', 'Herrmann', 'm', 'SH', 'SPD', 1947, 1949),
(88, 'Kopf', 'Hinrich Wilhelm', 'm', 'NI', 'SPD', 1946, 1955),
(89, 'Kopf', 'Hinrich Wilhelm', 'm', 'NI', 'SPD', 1959, 1961),
(90, 'Börner', 'Holger', 'm', 'HE', 'SPD', 1976, 1987),
(91, 'Seehofer', 'Horst', 'm', 'BY', 'CSU', 2008, 2018),
(92, 'Ney', 'Hubert', 'm', 'SL', 'CDU', 1956, 1957),
(93, 'Böhrnsen', 'Jens', 'm', 'HB', 'SPD', 2005, 2015),
(94, 'Stamp', 'Joachim', 'm', 'NW', 'FDP', 2021, 2021),
(95, 'Wolf', 'Jochen', 'm', 'BB', 'SPD', 1990, 1990),
(96, 'Hoffmann', 'Johannes', 'm', 'SL', NULL, 1947, 1955),
(97, 'Rau', 'Johannes', 'm', 'NW', 'SPD', 1978, 1998),
(98, 'Duchac', 'Josef', 'm', 'TH', 'CDU', 1990, 1992),
(99, 'Rüttgers', 'Jürgen', 'm', 'NW', 'CDU', 2005, 2010),
(100, 'Wegner', 'Kai', 'm', 'BE', 'CDU', 2023, NULL),
(101, 'von Hassel', 'Kai-Uwe', 'm', 'SH', 'CDU', 1954, 1963),
(102, 'Arnold', 'Karl', 'm', 'NW', 'CDU', 1947, 1956),
(103, 'Fegebank', 'Katharina', 'w', 'HH', 'Grüne', 2018, 2018),
(104, 'Schütz', 'Klaus', 'm', 'BE', 'SPD', 1967, 1977),
(105, 'von Dohnany', 'Klaus', 'm', 'HH', 'SPD', 1981, 1988),
(106, 'Wedemeier', 'Klaus', 'm', 'HB', 'SPD', 1985, 1995),
(107, 'Wowereit', 'Klaus', 'm', 'BE', 'SPD', 2001, 2014),
(108, 'Sager', 'Krista', 'w', 'HH', 'Grüne', 2001, 2001),
(109, 'Beck', 'Kurt', 'm', 'RP', 'SPD', 1994, 2013),
(110, 'Biedenkopf', 'Kurt', 'm', 'SN', 'CDU', 1990, 2002),
(111, 'Conrad', 'Kurt', 'm', 'SL', 'SPD', 1959, 1959),
(112, 'Kiesinger', 'Kurt Georg', 'm', 'BW', 'CDU', 1958, 1966),
(113, 'Späth', 'Lothar', 'm', 'BW', 'CDU', 1978, 1991),
(114, 'Dreyer', 'Malu', 'w', 'RP', 'SPD', 2013, NULL),
(115, 'Stolpe', 'Manfred', 'm', 'BB', 'SPD', 1990, 2002),
(116, 'Schwesig', 'Manuela', 'w', 'MV', 'SPD', 2017, NULL),
(117, 'Söder', 'Markus', 'm', 'BY', 'CSU', 2018, NULL),
(118, 'Dulig', 'Martin', 'm', 'SN', 'SPD', 2017, 2017),
(119, 'Platzeck', 'Matthias', 'm', 'BB', 'SPD', 2002, 2013),
(120, 'Brauer', 'Max', 'm', 'HH', 'SPD', 1946, 1953),
(121, 'Streibl', 'Max', 'm', 'BY', 'CSU', 1988, 1993),
(122, 'Kretschmer', 'Michael', 'm', 'SN', 'CDU', 2017, NULL),
(123, 'Müller', 'Michael', 'm', 'BE', 'SPD', 2014, 2021),
(124, 'Vesper', 'Michael', 'm', 'NW', 'Grüne', 2002, 2002),
(125, 'Scholz', 'Olaf', 'm', 'HH', 'SPD', 2011, 2018),
(126, 'von Beust', 'Ole', 'm', 'HH', 'CDU', 2001, 2010),
(127, 'Runde', 'Ortwin', 'm', 'HH', 'SPD', 1997, 2001),
(128, 'Lafontaine', 'Oskar', 'm', 'SL', 'SPD', 1985, 1998),
(129, 'Suhr', 'Otto', 'm', 'BE', 'SPD', 1955, 1957),
(130, 'Nevermann', 'Paul', 'm', 'HH', 'SPD', 1961, 1965),
(131, 'Steinbrück', 'Peer', 'm', 'NW', 'SPD', 2002, 2005),
(132, 'Altmeier', 'Peter', 'm', 'RP', 'CDU', 1947, 1969),
(133, 'Müller', 'Peter', 'm', 'SL', 'CDU', 1999, 2011),
(134, 'Schulz', 'Peter', 'm', 'HH', 'SPD', 1971, 1974),
(135, 'Tschentscher', 'Peter', 'm', 'HH', 'SPD', 2018, NULL),
(136, 'Carstensen', 'Peter Harry', 'm', 'SH', 'CDU', 2005, 2012),
(137, 'Haseloff', 'Reiner', 'm', 'ST', 'CDU', 2011, NULL),
(138, 'Höppner', 'Reinhard', 'm', 'ST', 'SPD', 1994, 2002),
(139, 'Klimmt', 'Reinhard', 'm', 'SL', 'SPD', 1998, 1999),
(140, 'Maier', 'Reinhold', 'm', 'BW', 'FDP', 1952, 1953),
(141, 'von Weizsäcker', 'Richard', 'm', 'BE', 'CDU', 1981, 1984),
(142, 'Koch', 'Roland', 'm', 'HE', 'CDU', 1999, 2010),
(143, 'Petersen', 'Rudolf', 'm', 'HH', 'CDU', 1945, 1946),
(144, 'Scharping', 'Rudolf', 'm', 'RP', 'SPD', 1991, 1994),
(145, 'Gabriel', 'Sigmar', 'm', 'NI', 'SPD', 1999, 2003),
(146, 'Tillich', 'Stanislaw', 'm', 'SN', 'CDU', 2008, 2017),
(147, 'Mappus', 'Stefan', 'm', 'BW', 'CDU', 2010, 2011),
(148, 'Weil', 'Stephan', 'm', 'NI', 'SPD', 2013, NULL),
(149, 'Steltzer', 'Theodor', 'm', 'SH', 'CDU', 1946, 1947),
(150, 'Jurk', 'Thomas', 'm', 'SN', 'SPD', 2008, 2008),
(151, 'Kemmerich', 'Thomas', 'm', 'TH', 'FDP', 2020, 2020),
(152, 'Hans', 'Tobias', 'm', 'SL', 'CDU', 2018, 2022),
(153, 'Albig', 'Torsten', 'm', 'SH', 'SPD', 2012, 2017),
(154, 'Barschel', 'Uwe', 'm', 'SH', 'CDU', 1982, 1987),
(155, 'Bouffier', 'Volker', 'm', 'HE', 'CDU', 2010, 2022),
(156, 'Bartram', 'Walter', 'm', 'SH', 'CDU', 1950, 1951),
(157, 'Momper', 'Walter', 'm', 'BE', 'SPD', 1989, 1991),
(158, 'Wallmann', 'Walter', 'm', 'HE', 'CDU', 1987, 1991),
(159, 'Schreiber', 'Walther', 'm', 'BE', 'CDU', 1953, 1955),
(160, 'Gies', 'Werner', 'm', 'ST', 'CDU', 1990, 1991),
(161, 'Klumpp', 'Werner', 'm', 'SL', 'FDP', 1979, 1979),
(162, 'Münch', 'Werner', 'm', 'ST', 'CDU', 1991, 1993),
(163, 'Zeyer', 'Werner', 'm', 'SL', 'CDU', 1979, 1985),
(164, 'Boden', 'Wilhelm', 'm', 'RP', 'CDU', 1946, 1947),
(165, 'Hoegner', 'Wilhelm', 'm', 'BY', 'SPD', 1945, 1946),
(166, 'Hoegner', 'Wilhelm', 'm', 'BY', 'SPD', 1954, 1957),
(167, 'Kaisen', 'Wilhelm', 'm', 'HB', 'SPD', 1945, 1965),
(168, 'Brandt', 'Willy', 'm', 'BE', 'SPD', 1957, 1966),
(169, 'Dehnkamp', 'Willy', 'm', 'HB', 'SPD', 1965, 1967),
(170, 'Kretschmann', 'Winfried', 'm', 'BW', 'Grüne', 2011, NULL),
(171, 'Böhmer', 'Wolfgang', 'm', 'ST', 'CDU', 2002, 2011),
(172, 'Clement', 'Wolfgang', 'm', 'NW', 'SPD', 1998, 2002),
(173, 'Rauls', 'Wolfgang', 'm', 'ST', 'FDP', 1993, 1993);

CREATE TABLE IF NOT EXISTS `partei` (
  `kuerzel` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `datumGruendung` date NOT NULL,
  `ortGruendung` varchar(30) NOT NULL,
  PRIMARY KEY (`kuerzel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

INSERT INTO `partei` (`kuerzel`, `name`, `datumGruendung`, `ortGruendung`) VALUES
('AfD', 'Alternative für Deutschland', '2013-02-06', 'Berlin'),
('CDU', 'Christlich Demokratische Union', '1945-06-26', 'Berlin'),
('CSU', 'Christlich-Soziale Union in Bayern', '1945-10-08', 'München'),
('DIE LINKE', 'Die Linke', '2007-06-16', 'Berlin'),
('Die PARTEI', 'Partei für Arbeit, Rechtsstaat, Tierschutz, Elitenförderung und basisdemokratische Initiative', '2004-10-04', 'Berlin'),
('Die Tierschutzpartei', 'Partei Mensch Umwelt Tierschutz', '1993-09-03', 'Frankfurt am Main'),
('FDP', 'Freie Demokratische Partei', '1948-12-11', 'Heppenheim (Bergstraße)'),
('FW', 'Freie Wähler', '2009-01-19', 'Wiesentheid'),
('Grüne', 'Bündnis 90/Die Grünen', '1980-01-13', 'Karlsruhe'),
('MLPD', 'Marxistisch-Leninistische Partei Deutschlands', '1982-07-20', 'Gelsenkirchen'),
('NPD', 'Nationaldemokratische Partei', '1964-11-28', 'Hannover'),
('OEDP', 'Ökologisch-Demokratische Partei', '1982-12-12', 'München'),
('SPD', 'Sozialdemokratische Partei', '1863-05-23', 'Leipzig'),
('Volt', 'Volt Deutschland', '2017-03-11', 'Berlin');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
