-- phpMyAdmin SQL Dump
-- version 4.9.2deb1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Erstellungszeit: 31. Mrz 2020 um 17:17
-- Server-Version: 10.4.12-MariaDB-1:10.4.12+maria~buster-log
-- PHP-Version: 7.3.15-4+0~20200224.55+debian10~1.gbpbea824

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

--
-- Datenbank: `iobroker`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `kreise`
--

CREATE TABLE `kreise` (
  `id` varchar(5) NOT NULL,
  `art` varchar(16) NOT NULL,
  `kreis` varchar(44) NOT NULL,
  `skreis` varchar(44) NOT NULL,
  `region` varchar(5) NOT NULL,
  `flaeche` decimal(6,2) NOT NULL COMMENT 'in km2',
  `bevoelkerung` int(12) NOT NULL,
  `maenner` int(7) NOT NULL,
  `frauen` int(7) NOT NULL,
  `dichte` int(7) NOT NULL COMMENT 'pro km2'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Daten für Tabelle `kreise`
--

INSERT INTO `kreise` (`id`, `art`, `kreis`, `skreis`, `region`, `flaeche`, `bevoelkerung`, `maenner`, `frauen`, `dichte`) VALUES
('01001', 'Kreisfreie Stadt', 'Flensburg, Stadt', 'Flensburg', 'DEF01', '56.73', 89504, 44599, 44905, 1578),
('01002', 'Kreisfreie Stadt', 'Kiel, Landeshauptstadt', 'Kiel', 'DEF02', '118.65', 247548, 120566, 126982, 2086),
('01003', 'Kreisfreie Stadt', 'Lübeck, Hansestadt', 'Lübeck', 'DEF03', '214.19', 217198, 104371, 112827, 1014),
('01004', 'Kreisfreie Stadt', 'Neumünster, Stadt', 'Neumünster', 'DEF04', '71.66', 79487, 39241, 40246, 1109),
('01051', 'Kreis', 'Dithmarschen', 'Dithmarschen', 'DEF05', '1428.17', 133210, 65720, 67490, 93),
('01053', 'Kreis', 'Herzogtum Lauenburg', 'Herzogtum_Lauenburg', 'DEF06', '1263.07', 197264, 96881, 100383, 156),
('01054', 'Kreis', 'Nordfriesland', 'Nordfriesland', 'DEF07', '2083.55', 165507, 81099, 84408, 79),
('01055', 'Kreis', 'Ostholstein', 'Ostholstein', 'DEF08', '1393.02', 200581, 96765, 103816, 144),
('01056', 'Kreis', 'Pinneberg', 'Pinneberg', 'DEF09', '664.25', 314391, 154211, 160180, 473),
('01057', 'Kreis', 'Plön', 'Plön', 'DEF0A', '1083.56', 128647, 62532, 66115, 119),
('01058', 'Kreis', 'Rendsburg-Eckernförde', 'Rendsburg-Eckernförde', 'DEF0B', '2189.79', 272775, 134109, 138666, 125),
('01059', 'Kreis', 'Schleswig-Flensburg', 'Schleswig-Flensburg', 'DEF0C', '2071.28', 200025, 99092, 100933, 97),
('01060', 'Kreis', 'Segeberg', 'Segeberg', 'DEF0D', '1344.47', 276032, 136517, 139515, 205),
('01061', 'Kreis', 'Steinburg', 'Steinburg', 'DEF0E', '1055.70', 131347, 64923, 66424, 124),
('01062', 'Kreis', 'Stormarn', 'Stormarn', 'DEF0F', '766.21', 243196, 118831, 124365, 317),
('02000', 'Kreisfreie Stadt', 'Hamburg, Freie und Hansestadt', 'Hamburg', 'DE600', '755.09', 1841179, 902048, 939131, 2438),
('03101', 'Kreisfreie Stadt', 'Braunschweig, Stadt', 'Braunschweig', 'DE911', '192.70', 248292, 122985, 125307, 1288),
('03102', 'Kreisfreie Stadt', 'Salzgitter, Stadt', 'Salzgitter', 'DE912', '224.49', 104948, 52202, 52746, 467),
('03103', 'Kreisfreie Stadt', 'Wolfsburg, Stadt', 'Wolfsburg', 'DE913', '204.61', 124151, 61820, 62331, 607),
('03151', 'Landkreis', 'Gifhorn', 'Gifhorn', 'DE914', '1567.45', 175920, 88035, 87885, 112),
('03153', 'Landkreis', 'Goslar', 'Goslar', 'DE916', '966.72', 137014, 67834, 69180, 142),
('03154', 'Landkreis', 'Helmstedt', 'Helmstedt', 'DE917', '676.15', 91307, 45241, 46066, 135),
('03155', 'Landkreis', 'Northeim', 'Northeim', 'DE918', '1268.76', 132765, 65445, 67320, 105),
('03157', 'Landkreis', 'Peine', 'Peine', 'DE91A', '536.50', 133965, 66286, 67679, 250),
('03158', 'Landkreis', 'Wolfenbüttel', 'Wolfenbüttel', 'DE91B', '724.30', 119960, 59370, 60590, 166);

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `kreise`
--
ALTER TABLE `kreise`
  ADD UNIQUE KEY `id` (`id`),
  ADD UNIQUE KEY `skreis_id` (`skreis`,`id`),
  ADD UNIQUE KEY `kreis_skreis` (`kreis`,`id`);
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 */;
