-- MySQL dump 10.16  Distrib 10.1.22-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: tmp
-- ------------------------------------------------------
-- Server version	10.2.4-MariaDB-log

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `mitarbeiter`
--

DROP TABLE IF EXISTS `mitarbeiter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mitarbeiter` (
  `pk` int(11) NOT NULL DEFAULT 0,
  `in_aw_liste` int(1) DEFAULT 1,
  `deaktiviert` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mitarbeiter`
--

LOCK TABLES `mitarbeiter` WRITE;
/*!40000 ALTER TABLE `mitarbeiter` DISABLE KEYS */;
INSERT INTO `mitarbeiter` VALUES (1,1,0),(2,1,0),(3,1,0),(4,1,1),(5,1,0),(6,1,1),(7,1,0),(10,0,0),(11,0,0),(12,1,0),(13,0,1),(14,0,1),(16,1,0),(17,0,1),(19,1,1),(20,0,1),(21,1,1),(22,1,0),(23,0,0),(26,1,0),(27,1,1),(28,1,0),(29,1,0),(30,1,1),(31,1,0),(32,0,1),(33,1,0),(34,1,0),(36,1,1),(37,1,0),(38,1,1),(39,1,1),(41,1,0),(43,1,0),(44,1,0),(45,1,0),(46,1,0),(47,1,0),(49,1,0),(50,1,0),(51,1,0),(52,1,0),(53,1,0),(54,0,1),(55,0,1),(56,1,1),(57,1,0),(58,1,1),(59,1,1),(60,1,1),(61,1,0),(63,0,0),(65,1,1),(66,1,1),(68,1,0),(72,1,1),(73,1,0),(74,1,0),(76,1,1),(77,1,1),(78,1,1),(79,1,1),(80,1,0),(81,1,1),(82,1,1),(83,1,0),(84,1,0),(85,0,1),(87,1,0),(88,1,1),(89,1,1),(90,1,1),(91,1,0),(92,1,0),(93,1,1),(94,1,0),(95,1,0),(96,1,0),(98,1,1),(99,1,0),(101,1,0),(102,1,1),(103,1,0),(104,1,1),(105,0,1),(106,1,1),(107,0,1),(108,1,0),(109,1,0),(110,1,0),(111,1,0),(112,1,1),(113,1,0),(114,1,1),(115,1,0),(116,1,0),(117,1,1),(118,1,0),(119,1,0),(120,1,0),(122,1,0),(123,1,1),(200,1,1),(5003,1,1),(5005,1,1),(5008,1,1),(5010,1,1),(5011,1,1),(5012,0,1),(5014,1,1),(5015,1,1),(5017,1,1),(5018,1,1),(5019,1,1),(5020,1,1),(5021,1,1),(5022,1,1),(5023,1,1),(5024,1,1),(5026,1,1),(5027,1,1),(5028,1,1),(5029,1,1),(5030,1,1),(5031,1,1),(5032,1,1),(5033,1,1),(5034,1,1),(5036,1,1),(100001,0,1),(100002,0,0),(100003,1,1),(100004,1,1),(100005,1,0),(100006,1,1),(100007,0,1),(100008,1,1),(100009,1,1),(100010,1,1),(100011,1,1),(100012,1,1),(100013,1,0),(100014,1,1),(100015,0,0),(100016,1,1),(100017,1,1),(100018,1,1),(100019,1,1),(100020,1,1),(100021,1,1),(100022,1,0),(100023,1,1),(100024,1,1),(100025,1,1),(100026,1,0),(100027,1,1),(100028,1,0),(100029,0,1),(100030,1,1),(100031,1,1),(100032,1,1),(100033,1,1),(100035,1,1),(100036,1,1),(100037,1,1),(100038,1,1),(100039,1,1),(100040,0,1),(100041,1,1),(100042,1,1),(100049,1,1),(100050,1,1),(100051,1,1),(100052,1,0),(100053,1,1),(100054,1,0),(100055,1,1),(100056,1,0),(100057,1,1),(100058,1,1),(100059,1,1),(100060,1,1),(100061,1,1),(100062,1,1),(100063,1,0),(100064,1,1),(100065,1,0),(100066,1,1),(100067,1,1),(100068,1,0),(100069,1,1),(100070,1,1),(100071,1,1),(100072,1,1),(100073,1,1),(100074,1,1),(100075,1,1),(100076,1,1),(100077,1,0),(100078,1,1),(100079,1,1),(100080,1,1),(100081,1,1),(100082,1,1),(100083,1,0),(100084,1,0),(100085,0,1),(100086,1,1),(100087,1,1),(100088,1,1),(100089,1,0),(100090,1,1),(100091,1,1),(100092,1,1),(100093,1,1),(100094,1,0),(100095,0,1),(100096,0,1),(100097,0,1),(100098,0,1),(100099,0,1),(100100,0,1),(100101,1,1),(100102,1,0),(100103,1,1),(100104,1,1),(100105,0,1),(100106,0,1),(100107,0,1),(100108,0,1),(100109,0,1),(100110,0,1),(100111,0,1),(100112,0,1),(100113,0,1),(100114,0,1),(100115,0,1),(100116,0,1),(100117,0,1),(100118,0,1),(100119,0,1),(100120,0,1),(100121,1,1),(100122,1,1),(100123,1,1),(100124,1,0),(100125,1,0),(100126,1,1),(100127,0,1),(100128,0,1),(100129,0,1),(100131,1,1),(100132,1,0),(100133,1,0),(100134,1,1),(100135,1,1),(100136,0,0),(100137,0,1),(100138,0,1),(100139,0,1),(100140,0,1),(100141,0,1),(100142,0,1),(100143,0,1),(100144,0,1),(100145,1,1),(100146,1,0),(100147,1,0),(100148,0,1),(100149,0,1),(100150,1,1),(100151,0,1),(100152,0,1),(100153,1,1),(100154,0,1),(100155,0,1),(100156,0,1),(100157,0,1),(100158,0,1),(100159,1,0),(100160,1,0),(100161,1,0),(100162,1,1),(100163,1,1),(100164,1,0),(100165,0,0),(100166,1,1),(100167,0,1),(100168,1,1),(100169,1,1),(100170,1,1),(100171,1,1),(100172,1,1),(100173,0,0),(100174,1,1),(100175,0,1),(100176,1,1),(100177,0,1),(100178,0,1),(100179,1,1),(100180,0,0),(100181,1,1),(100182,1,1),(100183,1,0),(100184,0,1),(100185,0,1),(100186,1,1),(100187,1,1),(100188,1,1),(100189,1,1),(100190,1,0),(100191,1,1),(100192,1,1),(100193,1,1),(100194,1,0),(100195,1,0),(100196,1,1),(100197,1,1),(100198,1,0),(100199,1,0),(100200,1,1),(100201,1,1),(100202,1,1),(100203,1,1),(100204,1,1),(100205,1,0),(100206,1,1),(100207,1,1),(100208,1,0),(100209,1,1),(100210,0,1),(100211,1,1),(100212,1,1),(100213,0,1),(100214,1,1),(100215,1,1),(100216,1,0),(100217,1,1),(100218,1,0),(100219,0,1),(100220,1,0),(100221,1,1),(100222,1,1),(100223,1,1),(100224,1,1),(100225,1,1),(100226,1,0),(100227,1,1),(100228,1,1),(100229,1,1),(100230,1,1),(100231,1,1),(100232,1,1),(100233,1,1),(100234,1,1),(100235,1,1),(100236,1,1),(100237,1,1),(100238,1,1),(100239,1,1),(100240,1,1),(100241,1,1),(100242,1,1),(100243,1,1),(100244,1,0),(100245,1,1),(100246,1,0),(100247,1,0),(100248,1,0),(100249,1,0),(100250,1,0),(100251,1,1),(100252,1,1),(100253,1,1),(100254,1,1),(100255,1,0),(100256,1,1),(100257,1,1),(100258,1,0),(100259,1,1),(100260,1,0),(100261,1,1),(100262,1,1),(100263,1,1),(100264,1,1),(100265,1,0),(100266,1,1),(100267,1,1),(100268,1,0),(100269,1,0),(100270,1,0),(100271,1,0),(100272,1,0),(100273,1,0),(100274,1,0),(100275,1,0),(100276,1,0),(100277,1,1),(100278,1,1),(100279,1,0),(100280,1,0),(100281,0,1),(100282,1,0),(100283,1,1),(100284,1,1),(100285,1,1),(100286,1,0),(100287,1,1),(100288,1,0),(100289,1,0),(100290,1,1),(100291,1,0),(100292,1,1),(100293,1,1),(100294,1,0),(100295,1,0),(100296,1,0),(100297,1,1),(100298,1,1),(100299,1,1),(100300,1,1),(100301,1,0),(100302,1,1),(100303,1,1),(100304,1,0),(100305,1,0),(100306,1,0),(100307,1,1),(100308,1,0),(100309,1,0),(100310,1,0),(100311,1,0),(100312,1,0),(100313,1,0),(100314,1,1),(100315,1,0),(100316,1,1),(100317,1,0),(100318,1,0),(100319,1,0),(100320,1,1),(100321,1,0),(100322,1,0),(100323,1,1),(100324,1,0),(100325,1,0),(100326,1,1),(100327,1,0),(100328,1,1),(100329,1,1),(100330,1,1),(100331,1,0),(100332,1,0),(100333,1,0),(100334,1,0),(100335,1,0),(100336,1,0),(100337,1,0),(100338,1,0),(100339,1,0),(100340,1,0),(100341,1,1),(100342,1,1),(100344,1,1),(100347,1,1),(100350,1,0),(100355,1,0),(100358,1,0),(100361,1,0),(100364,1,1),(100367,1,1),(100370,1,1),(100373,1,1),(100376,1,1),(100379,1,1),(100382,1,0),(100385,1,1),(100388,1,1),(100391,1,1),(100394,1,0),(100397,1,0),(100400,1,1),(100401,1,1),(100404,1,0),(100407,1,0),(100410,1,0),(100413,1,0),(100416,1,0),(100419,1,0),(100422,1,0),(100425,1,0),(100428,1,1),(100431,1,1),(100434,1,1),(100437,1,0),(100440,1,0),(100443,1,0),(100446,1,0),(100449,1,0),(100452,1,0),(100455,1,1),(100458,1,0),(100461,1,0),(100464,1,1),(100465,1,0),(100466,1,0),(100469,1,1),(100472,1,1),(100475,1,0),(100478,1,0),(100481,1,0),(100484,1,1),(100487,1,0),(100490,1,1),(100493,1,0),(100496,1,0),(100499,1,0),(100502,1,0),(100505,1,1),(100508,1,1),(100512,1,0),(100513,1,1),(100517,0,1),(100520,0,1),(100521,1,0),(100524,1,0),(100527,1,0),(100530,1,0),(100534,1,0),(100540,1,1),(100547,1,1),(100552,1,1),(100560,1,0),(100568,1,0),(100576,0,1),(100584,0,1),(100591,0,0),(100599,0,1),(100603,0,1),(100607,0,1),(100615,1,0),(100623,1,0),(100627,1,0),(100635,1,1),(100643,1,1),(100651,1,0),(100659,1,0),(100667,1,0),(100671,1,0),(100679,1,0),(100687,1,1),(100695,1,0),(100699,1,1),(100707,1,0),(100715,0,0),(100719,0,1),(100727,0,1),(100735,0,1),(100739,0,0),(100743,1,0),(100751,1,0),(100759,1,0),(100764,0,0),(100770,1,0),(100775,1,0),(100783,0,0),(100791,1,0),(100799,1,0),(100803,1,0),(100811,1,0),(100815,1,0),(100823,1,0),(100831,1,0),(100839,1,0),(100841,1,0);
/*!40000 ALTER TABLE `mitarbeiter` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017-05-02 17:00:08
