COMMIT;

-- Dumped table `modx_transport_packages` with 31 row(s)
--

--
-- Table structure for table `modx_transport_providers`
--

CREATE TABLE `modx_transport_providers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `description` mediumtext DEFAULT NULL,
  `service_url` tinytext DEFAULT NULL,
  `username` varchar(191) NOT NULL DEFAULT '',
  `api_key` varchar(191) NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `updated` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `priority` tinyint(4) NOT NULL DEFAULT 10,
  `properties` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `api_key` (`api_key`),
  KEY `username` (`username`),
  KEY `active` (`active`),
  KEY `priority` (`priority`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_transport_providers`
--

SET autocommit=0;
INSERT INTO `modx_transport_providers` VALUES (1,'modx.com','The official MODX transport provider for 3rd party components.','https://rest.modx.com/extras/','','','2021-05-28 09:04:51','2021-08-02 14:05:07',1,10,'');
COMMIT;

-- Dumped table `modx_transport_providers` with 1 row(s)
--

--
-- Table structure for table `modx_user_attributes`
--

CREATE TABLE `modx_user_attributes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `internalKey` int(10) NOT NULL,
  `fullname` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `phone` varchar(100) NOT NULL DEFAULT '',
  `mobilephone` varchar(100) NOT NULL DEFAULT '',
  `blocked` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `blockeduntil` int(11) NOT NULL DEFAULT 0,
  `blockedafter` int(11) NOT NULL DEFAULT 0,
  `logincount` int(11) NOT NULL DEFAULT 0,
  `lastlogin` int(11) NOT NULL DEFAULT 0,
  `thislogin` int(11) NOT NULL DEFAULT 0,
  `failedlogincount` int(10) NOT NULL DEFAULT 0,
  `sessionid` varchar(100) NOT NULL DEFAULT '',
  `dob` int(10) NOT NULL DEFAULT 0,
  `gender` int(1) NOT NULL DEFAULT 0,
  `address` text NOT NULL,
  `country` varchar(191) NOT NULL DEFAULT '',
  `city` varchar(191) NOT NULL DEFAULT '',
  `state` varchar(25) NOT NULL DEFAULT '',
  `zip` varchar(25) NOT NULL DEFAULT '',
  `fax` varchar(100) NOT NULL DEFAULT '',
  `photo` varchar(191) NOT NULL DEFAULT '',
  `comment` text NOT NULL,
  `website` varchar(191) NOT NULL DEFAULT '',
  `extended` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `internalKey` (`internalKey`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_user_attributes`
--

SET autocommit=0;
INSERT INTO `modx_user_attributes` VALUES (1,1,'Hauptadministrator','christian@bruehlbaerbel.de','','',0,0,0,128,1651603108,1651687846,0,'0c0nda5b4bl54c9u9u6q2oukto',0,0,'','','','','','','','','','[]'),(2,2,'','agandreasgreiner@aol.com','','',0,0,0,3,1578605364,1582140654,0,'b04876b9028eca0c4fec6938b34faca0',0,0,'','','','','','','','','','[]'),(3,3,'','alex@bruehlbaerbel.de','','',0,0,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(4,4,'','alex.friesch@web.de','','',0,1608551631,0,10,1578702663,1578703002,4,'cf8e9f8e64e490758c90a6f3b10915be',0,0,'','','','','','','','','','[]'),(5,5,'','andreas.kertschek@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(6,6,'','andrea.lauxmann@gmx.de','','',0,1611603065,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(7,7,'','armbla@web.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(8,8,'','aylin.werz@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(10,10,'','dani.vaas@t-online.de','','',0,1634818691,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(11,11,'','dannykehrer@gmx.de','','',0,1573850936,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(13,13,'','sam1512@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(15,15,'','julia@bruehlbaerbel.de','','',0,0,0,60,1648453472,1649858096,0,'n7ss29gta1ikqo62kkknlo08ul',0,0,'','','','','','','','','','[]'),(16,16,'','k-lutz@hotmail.de','','',0,1576774005,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(17,17,'','kathrin.knecht@t-online.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(18,18,'','katrin.trommeter@web.de','','',0,0,0,1,0,1558211186,0,'20c9391c26d7625d720c790748fa02a6',0,0,'','','','','','','','','','[]'),(19,19,'','holler-kerstin@web.de','','',0,0,0,1,0,1578258135,2,'a037fe690f6974c16d8d95810edd9827',0,0,'','','','','','','','','','[]'),(20,20,'','florian.kugel@gmx.de','','',0,0,0,10,1581242334,1581982807,0,'e61d906f0d0af07429caff37554221e8',0,0,'','','','','','','','','','[]'),(21,21,'','linda.lauxmann@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(22,22,'','unger_lisa@web.de','','',0,0,0,0,0,0,2,'',0,0,'','','','','','','','','','[]'),(23,23,'','manu.lauxmann@gmx.de','','',0,0,0,2,1553883485,1553883717,0,'2e2905e237552d99be4e250a11e8c085',0,0,'','','','','','','','','','[]'),(24,24,'','marcschell@t-online.de','','',0,0,0,10,1579630346,1617634519,0,'02ab3ff56351beca14bcd8e4c339b5d1',0,0,'','','','','','','','','','[]'),(25,25,'','marcus.kremm@gmail.com','','',0,0,0,11,1630242317,1645963428,0,'vo3oktkreoq29f1fg4gs1737a0',0,0,'','','','','','','','','','[]'),(26,26,'','marina.hoerz@gmx.de','','',0,0,0,3,1580906980,1582477539,4,'bf8f43216251dbc2ea472976e4ffc7da',0,0,'','','','','','','','','','[]'),(27,27,'','martina.d.gut@gmail.com','','',0,0,0,1,0,1567504425,2,'d4b52e16201adf601710d5e07f76ece8',0,0,'','','','','','','','','','[]'),(28,28,'','martina.kovacs@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(29,29,'','m.bader83@web.de','','',0,0,0,2,1554702330,1578257335,0,'c8fe99f23c2bc0267896ac8fe6f23f23',0,0,'','','','','','','','','','[]'),(30,30,'','michael.hoerz@student.uni-tuebingen.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(31,31,'','michaela.bayer83@yahoo.de','','',0,1582214842,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(32,32,'','michael.neuscheler@rncdh.de','','',0,0,0,4,1623421532,1638228779,0,'6634c225bf39247e035d38164b17ffe2',0,0,'','','','','','','','','','[]'),(33,33,'','steffen@bruehlbaerbel.de','','',0,0,0,8,1638990628,1650827249,0,'cgi1acdg383drst4d4gk6r09f1',0,0,'','','','','','','','','','[]'),(34,34,'','nicole.rein@web.de','','',0,1642620418,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(35,35,'','lauxmann19@gmail.com','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(36,36,'','alexlebuck@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(37,37,'','olli@bruehlbaerbel.de','','',0,0,0,69,1582629323,1582749551,2,'5b73a1bb0484a1265bad4c465e96d405',0,0,'','','','','','','','','','[]'),(38,38,'','pamelamayer@kabelbw.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(39,39,'','pw-87@gmx.de','','',0,0,0,3,1582484668,1641986501,0,'vp2cg25rmu95mm45pilnia3jd6',0,0,'','','','','','','','','','[]'),(40,40,'','patrick.schell@web.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(41,41,'','ralflauxmann@t-online.de','','',0,0,0,0,0,0,2,'',0,0,'','','','','','','','','','[]'),(42,42,'','s.mayer41083@online.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(43,43,'','salvatorino@gmx.de','','',0,0,0,18,1613158008,1613158716,0,'34f755ab75aae0b1fc977febb055f8b5',0,0,'','','','','','','','','','[]'),(44,44,'','sarahkertschek@gmx.de','','',0,0,0,14,1582409979,1598007791,4,'23dda343df78e9d123cdcfb55dddaf8c',0,0,'','','','','','','','','','[]'),(45,45,'','severine@bruehlbaerbel.de','','',0,0,0,5,1644413452,1644511090,0,'d6ve95vtnf13q01tfdlnre03ui',0,0,'','','','','','','','','','[]'),(46,46,'','silvia.kovacs@gmx.de','','',0,0,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(47,47,'','simi_sch@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(48,48,'','stefan@bruehlbaerbel.de','','',0,0,0,12,1604334916,1636475000,0,'f895791fd45a3eacc6768960d9aaccfe',0,0,'','','','','','','','','','[]'),(49,49,'','tim.lauxmann@gmx.de','','',0,0,0,1,0,1581323164,0,'f1a49a49a82e00135c8571ea5af3bd60',0,0,'','','','','','','','','','[]'),(50,50,'','thomas.85@gmx.de','','',0,0,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(52,52,'','verena.auer@web.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(53,53,'','rabuswolfgang@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(54,54,'','pundm.ziegler@t-online.de','','',0,0,0,16,1582534551,1582625970,0,'5c9fdd2a0f352432ede4c4bf5c217567',0,0,'','','','','','','','','','[]'),(56,56,'','mona.schweiker@web.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(57,57,'','zeller81@gmx.net','','',0,1612894982,0,2,1578585098,1578585236,4,'45b86e698859361730a96fc05c5d3255',0,0,'','','','','','','','','','[]'),(58,58,'','tamara.kunst@web.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(59,59,'','vaaschristian@web.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(60,60,'','janak17@gmx.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(61,61,'','hofbauer.pliezhausen@freenet.de','','',0,1593595263,0,0,0,0,4,'',0,0,'','','','','','','','','','[]'),(62,62,'','stefanie.galster@mailbox.org','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(63,63,'','adam.jahraus@gmx.de','','',0,0,0,8,1581840414,1582296298,0,'f76374d9a694797227b96047fe6cdb7c',0,0,'','','','','','','','','','[]'),(64,64,'','hexe0964@gmx.de','','',0,0,0,9,1581839966,1581840083,0,'26d71262393c640b03baecfec9ac726d',0,0,'','','','','','','','','','[]'),(65,65,'','mario.streimelweger@icloud.com','','',0,0,0,5,1582211281,1603356609,0,'76ac4a09c03ea8c61ea022229f36a426',0,0,'','','','','','','','','','[]'),(66,66,'','patrickkleinbach@web.de','','',0,0,0,0,0,0,0,'',0,0,'','','','','','','','','','[]'),(69,69,'','tanja-glock@web.de','','',0,0,0,47,1582660318,1582808630,0,'d8fa34e7d2b032ec6d9f4aef0abba316',0,0,'','','','','','','','','','[]'),(72,72,'','ctrash@mailbox.org','','',0,0,0,1,0,1557740969,0,'0891de782a2677365d3f01f19d2084f7',0,0,'','','','','','','','','','[]'),(73,73,'','dieterundclaudia@gmx.de','','',0,0,0,2,1577474169,1577474506,0,'bff60fd2de72f371c01a6cc967776276',0,0,'','','','','','','','','','[]'),(74,74,'','csocial@mailbox.org','','',0,0,0,1,0,1578573263,0,'c4e92f48cae9910663213c611b53d50e',0,0,'','','','','','','','','','[]');
COMMIT;

-- Dumped table `modx_user_attributes` with 65 row(s)
--

--
-- Table structure for table `modx_user_group_roles`
--

CREATE TABLE `modx_user_group_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `description` mediumtext DEFAULT NULL,
  `authority` int(10) unsigned NOT NULL DEFAULT 9999,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `authority` (`authority`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_user_group_roles`
--

SET autocommit=0;
INSERT INTO `modx_user_group_roles` VALUES (1,'Member',NULL,9999),(2,'Super User',NULL,0);
COMMIT;

-- Dumped table `modx_user_group_roles` with 2 row(s)
--

--
-- Table structure for table `modx_user_group_settings`
--

CREATE TABLE `modx_user_group_settings` (
  `group` int(10) unsigned NOT NULL DEFAULT 0,
  `key` varchar(50) NOT NULL,
  `value` text DEFAULT NULL,
  `xtype` varchar(75) NOT NULL DEFAULT 'textfield',
  `namespace` varchar(40) NOT NULL DEFAULT 'core',
  `area` varchar(191) NOT NULL DEFAULT '',
  `editedon` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`group`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_user_group_settings`
--

SET autocommit=0;
COMMIT;

-- Dumped table `modx_user_group_settings` with 0 row(s)
--

--
-- Table structure for table `modx_user_messages`
--

CREATE TABLE `modx_user_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(15) NOT NULL DEFAULT '',
  `subject` varchar(191) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `sender` int(10) NOT NULL DEFAULT 0,
  `recipient` int(10) NOT NULL DEFAULT 0,
  `private` tinyint(4) NOT NULL DEFAULT 0,
  `date_sent` datetime DEFAULT NULL,
  `read` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_user_messages`
--

SET autocommit=0;
COMMIT;

-- Dumped table `modx_user_messages` with 0 row(s)
--

--
-- Table structure for table `modx_user_settings`
--

CREATE TABLE `modx_user_settings` (
  `user` int(11) NOT NULL DEFAULT 0,
  `key` varchar(50) NOT NULL DEFAULT '',
  `value` text DEFAULT NULL,
  `xtype` varchar(75) NOT NULL DEFAULT 'textfield',
  `namespace` varchar(40) NOT NULL DEFAULT 'core',
  `area` varchar(191) NOT NULL DEFAULT '',
  `editedon` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`user`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_user_settings`
--

SET autocommit=0;
COMMIT;

-- Dumped table `modx_user_settings` with 0 row(s)
--

--
-- Table structure for table `modx_users`
--

CREATE TABLE `modx_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL DEFAULT '',
  `cachepwd` varchar(255) NOT NULL DEFAULT '',
  `class_key` varchar(100) NOT NULL DEFAULT 'modUser',
  `active` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `remote_key` varchar(191) DEFAULT NULL,
  `remote_data` text DEFAULT NULL,
  `hash_class` varchar(100) NOT NULL DEFAULT 'hashing.modNative',
  `salt` varchar(100) NOT NULL DEFAULT '',
  `primary_group` int(10) unsigned NOT NULL DEFAULT 0,
  `session_stale` text DEFAULT NULL,
  `sudo` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `createdon` int(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `class_key` (`class_key`),
  KEY `remote_key` (`remote_key`),
  KEY `primary_group` (`primary_group`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_users`
--

SET autocommit=0;
INSERT INTO `modx_users` VALUES (1,'Christian','$2y$10$mSUBVf3bwEL67PXMGPzQNu9tPprA22LNZsjqjySBAAB1PrzanfSi.','','modUser',1,NULL,NULL,'hashing.modNative','6ff592a29150d79c14191279de19fa8b',4,'a:2:{i:0;s:3:\"mgr\";i:1;s:3:\"web\";}',1,1546348731),(2,'Andy','$2y$10$W7RtMbTVpi/J9iNV.gUU6uv9w1xWpxoiHtYt1ExNGSJi5Ac775ya.','','modUser',1,NULL,NULL,'hashing.modNative','0e9721d8022ada58766fd5e161f875da',3,NULL,0,1553530870),(3,'Alex','$2y$10$epKO1qyh2xR6/A68glA0gOSGaWwpg06OdSCs/xVXm9mj1dW26tAcu','','modUser',1,NULL,NULL,'hashing.modNative','b814b658ff19219f1cbc9bfdff165951',3,NULL,0,1553531024),(4,'Alexandra','$2y$10$.1ekSm3mImLnJmNdOw4mYeQj.m1FXmCUn.44fUNVhHhaBGl9PZJTK','','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(5,'Andi','$2y$10$HbuPkodgYBx6HjORQaImQuArsN15A95Q6HL/qa3PRrW1IMKP9x4pW','','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(6,'Andrea','$2y$10$78qegvC6PBXcAGfMruRUHe/0dc8TbxwiWknpY1kSuWTFDW1WlaH86','$2y$10$8w/GTMCOcl7GdWGkcgo6YexnS62vtTpJk7WD/XbnWGcZsKozO7Rzy','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(7,'Armin','$2y$10$ltI3UYgCzh7QVhJQWSDFReiRqRZ8IqrtTorlWdB5IsfZoZm8ca0aq','$2y$10$a/AmtOmpftF7T.J2sZ7LVuBNjd7jnOmBRNUcd6kNGcr1U18pBLDjC','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(8,'Aylin','$2y$10$a8ghuXlVEgPhSZSfwYwETOlkXdaSKnIh.qwn3PnRI6aPdzbQRpcOS','$2y$10$83JJ0IWhUJYAm2WzFc4UpOCWbEBydkLfHL/meagDONY7kdO8IL4ja','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(10,'Dani','$2y$10$V6EH6.rBeKfT5h2ydHkH/eO/Av5DUo5ITXZUkW86miMKGUAPe902O','$2y$10$/UuQcRD/XzJxvn35fjW/Lu8y1DtsS.Utx/GVoEA279ci.JumRwejK','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(11,'Danny','$2y$10$WN4Ydm242lU2hKAAZKulv.x6vwdZxqRr/7lPI9xVQgMlEdwgxXpNy','$2y$10$tBvszZGfaf.p5SL6TN3B4OMhQBa6VkZORZ/zM0Yq7JBMYO4a9FUki','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(13,'Helga','$2y$10$PPxzLfhx563SpOwwK5Jwr.zH2KXWydKR/RYnqa/yDxgu3n2nLMJ9O','$2y$10$zWi9xwRjosXkZcgec3I.QuF9Qt9xe/z95fMOLvS5x0Ca2uJ9djNl.','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(15,'Jule88','$2y$10$sqs3hH2TeuOEEGZ46dh8pOdDxeqHuTq6km0NvhLFe9ftJiuNVjHya','$2y$10$DOqfqFpoHIoq.DT6FgUuq.rIQHHpiZwlcfls/LXKoIjAIfNoHa81C','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',4,NULL,0,1553531160),(16,'Kathrin','$2y$10$US/F5n5BNBxF9qB8u20Pj.2dem/Ozkd17i1PbL6iW1inps21AHTSy','$2y$10$Kf5tbIHaUyY/29QRXRSqV.wTiDAljsb/FmtTU2QV7CPYkCPdtqAQi','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(17,'Kathrin79','$2y$10$WgcIXMRmK3hpSf4hkGYQGeKWmojJu9WFwONclQr2Dmv6jJxDDDqFq','$2y$10$0AbZJRxWRHPzl34hol8jw.MpKmynIIymxXe9KVGSgLd.iq9VrL0vG','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(18,'Katrin','$2y$10$wGpA/n7z.BUMDMrVSdV.deln.yTcRM2CHxPP/mqCKAu./.afE6S96','$2y$10$WQJiLVRf8kZpeLfVtfXNieoc0NkKJky1mC4k.hF9yTXTqq12XnlPi','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(19,'Kerstin','$2y$10$JxPeEQ05SScWknC0zRsD2e3HLY1SecdNSkVLjsSjdqlg4U6771nBm','$2y$10$N/IrYQeXa2Drwq7KkPs9iuZHQlktYrCLPHLdXXIsDJSCgKkHBnC3i','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(20,'Kugel','$2y$10$y2VZkicsddiBsYA7zDsUmuGBWNpgZh8QvVm0ytftZDCpGRdIE9yoi','$2y$10$ylYCwr4UJ4TKTeQE2nwF3.5ySV0uZXw7.Zq0fgolBBm13CTeL4dOO','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(21,'Linda','$2y$10$6bey3S1PgTZfVsBlvmlItObsQcotlcppB3SSvVsc7jMaQX4KQ.fAi','$2y$10$9KboAygdbcHzWkS.gLk9aeHcx5FXePwmyhJkEhgQLYO0RlUIzedBi','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(22,'Lisa','$2y$10$HR1NdvKNMvn2pAkjz1IG9eimVt9OhO7bdaz..JNsJIpeK1crh5kUy','$2y$10$9hThgWE3M5nQ1RuFRUWgRuOBlhER0xnqBB7.NNhNFadreKxr.Wk.W','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(23,'Manu','$2y$10$Qisl6pwUY0/CGzAbwdAP4.XBZsilyl2KPYu9yqunE3OXl/OE1fd6a','$2y$10$QSeoot8nFTPJg5H2f1Wb8.1DEBlG6FGL57tzDnURmKF6h78ZOnr5G','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(24,'Marc','$2y$10$L67wIB2YM3osFJI8m8pU7.Fd1jzU7V5D/SBHSqgPXeQS6fT8bAe3q','$2y$10$uAjx33JP2KlY6VCl1RLu1eZN3KYPIrCVoYZUQBIECAVClojRY8pr6','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(25,'Marcus','$2y$10$siYedqt43tsao51I61mRWOxYQAYcgvADn0DD7FWT91BDRgmDS18yS','$2y$10$iXVwAnhs2dUbDrMv1rTFheRP0I5vh40vfL7XaPgAGG5eqMecY9i0K','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(26,'Marina','$2y$10$OrKUfeD.EUfhVZhRS6sT9elzbt3caCmwvKe8tRXBQ/sHkWW1CCg8q','$2y$10$VCD6mTr9oq1YZ6/OzmXqUuRa6Gm9B1nNVuLzb8DhCcSikYsNxS4lu','modUser',1,NULL,NULL,'hashing.modNative','0e9721d8022ada58766fd5e161f875da',3,NULL,0,1553530870),(27,'Martina','$2y$10$Pd0fhwfptPaiET.wVz7FCOa.RcNMZGtMNZWXthuWII1dd0rSN76B.','$2y$10$1SwlAIO16RZm25RQ8bdrnuYmOm3brfec3SjzzMw2odm/7mr/u5c7G','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(28,'Martina89','$2y$10$itzlkvmhS3Lue0cWt.cBcOHD5VNxV3P1RNKqkQR27E5mxkPcW99Vm','$2y$10$kyMsjpzEW7kwcVoVNapYo.fgTWVEamhGuyVnNu7CWiX3NWzpI64uO','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(29,'Meiada','$2y$10$nGIp2ff6NDm6JJyG6gKJcesNSoQzvTwHW9SU1p5RXBMtuxu4NvZ4W','$2y$10$txIOV./.q/SogpEnIJCEyux3wrvS8l5mm3uVMGGkDAkhII6P5IcZa','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(30,'Michael','$2y$10$gk0yNaMVYh/kOzK6a9uhpuE2gzNZQ6N7pyMHjHKYkmPsVMBnqr7Me','$2y$10$i1oxsPPyMJc/b/PFx9bGROd6giVRwmM7G7JCjz2WlwwLYI4JJ0Jxm','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(31,'Michaela69','$2y$10$uZav4hQ8IYs2bk9Iz29A6.Myvp2hlb9NtNGIL8AZgZRZKShdr4Ip2','$2y$10$H0strLciblXLKhAxHEPUuu3kAnCgC4j4/5yhEcEKX4KdT4i/9NQ4m','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(32,'Michi','$2y$10$8lztMhX6mNubuSan31p8s.LT9HbWMKoQ4fYFp5tIeUsPvIie/wllS','$2y$10$e6Vjqqkz9qLeJNAtAjd40euNuX81vT4SU8Ave/sNGDy8XSYYh.fjm','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(33,'Neuschis','$2y$10$hrsuxC5XuvHkUTiNgvKPl.Huu1q9zCHz37kIydbhPa1hTVVqLPvFm','$2y$10$ApfooR2nNxntgH2IJpbOruMRhyhjBZwk3uS7ZLGiwaJzEjm8qTdva','modUser',1,NULL,NULL,'hashing.modNative','b814b658ff19219f1cbc9bfdff165951',4,NULL,0,1553531024),(34,'Nicole','$2y$10$/m/13UAY6R.NNhiW9mg9fOFzLfxhQ66ienX1q6Ym7N6X3g.g1OP.2','$2y$10$yQ8xjaLgMtSU0MdIooFNX.tbC96w/e5ehKlNNxLpz1hE6D.6RVPlC','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(35,'Nina','$2y$10$v64P8i.0qVeNKR4lKZwSBudAjdWJwLWgEUdAbsMYwQsg6gY2DUrCu','$2y$10$NjvdB7lW42r/f/eKj98SCOP9bTweqBVWerIFMD17DyPIipMytvny.','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(36,'Olex','$2y$10$bdhtpy1Puk2FbeMwI0dXW.t/ToGtjYwKfuI/nBaliO7pcz9n8Vl6m','$2y$10$6zVroAHPMKUlgy5UQPJbt.erF1diskIznEqHwaixKODsOUyY49Frm','modUser',1,NULL,NULL,'hashing.modNative','0e9721d8022ada58766fd5e161f875da',3,NULL,0,1553530870),(37,'Olli','$2y$10$zWstlH1JCXI.ZoExZnHoI.JD4QGNWuUuhux1zdZoiEJTAj2EI8zqK','$2y$10$BCrtlmOHPz956OkyPElkfOBezH8MTPTk5ugGQpn/ZQhiV.GQdGkQy','modUser',1,NULL,NULL,'hashing.modNative','b814b658ff19219f1cbc9bfdff165951',4,NULL,0,1553531024),(38,'Pamela','$2y$10$iKm/Pwe2GqoJVBpIhucct.JqCpBRUP.ee5W6ViuC.eGl75SIQn38O','$2y$10$Di2XFGLf99FZ/bpXrRIZtuXdOQ8p4zwGe8rVBjQ6uzF5cnFKLJgxe','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(39,'Patrick','$2y$10$MeoCoJigmoDQAfK3cKL/iO3RsEjbMy3gMGk1n327Oa6NWCurH7K3K','$2y$10$m5GiX5oSOe9tMQJSKLKBwu1fyXp9ABYJsfIcRNr1J3n8GEa.k8vTW','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(40,'Pit','$2y$10$4JDWKWL8qOEsbBT0aEf/MO5iURfFP/K1BOV14QJTVS6KAMIhleFRG','$2y$10$GPSxt/lIyGoLMJPfv7oEneuJMC3p3MZc7/69Sdbk9fmWeYMBPp7Fm','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(41,'Ralf','$2y$10$Q4VzJOgqGzZrg8UlAGym7eeOytOK9Vg3FBLOweI0V.6jWVyW9k/tm','$2y$10$erPDdKkMawuDLG7JBRjz7ebfCEuK20PGDZ/2z5LQ6pFKzpDVPsDzq','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(42,'Sabrina','$2y$10$9qVaASR8ylSOfRi.Q7dkK.wm25AF99e9JzDvBhawgRml.5IbPVglq','$2y$10$eyqFjhZma01NrdPoPbdj3eiQpdHgpLXbCYUQBALyGVn11vJ4vTd3a','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(43,'Salva','$2y$10$xQd726tzlYcvqm19yBN0fOtXLeeJRnluZv.2vBsqrEZsXqERB7MDa','$2y$10$qGEw6TODcZp.ckvPwSDw7ORh/JXu2KDOfaVQ.aFE3QJwaqZtNTu8W','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(44,'Sarah','$2y$10$tzatrKELIfWcqCSQw91Fce.6LktkJwccuurFXR8eFIkctXT4GQCnK','$2y$10$o0mF8K.DYB0oX0JiotjKZ.x8ceFKKbCuymR35nltB2oIMxTdSt606','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(45,'Severine','$2y$10$PgT7G0R0BGIDiAKLTpQvQO5S.O5op8MRrJtKU0y6ZqBk59hrZi4bu','$2y$10$uwL2GDNYgY2aD7v/T8WIO.dB.5vH5ngoOOPnLU.D0NiaUdCN6F.v.','modUser',1,NULL,NULL,'hashing.modNative','b814b658ff19219f1cbc9bfdff165951',4,NULL,0,1553531024),(46,'Silvia','$2y$10$lDrmGzZJlXrC5gsybA.Lee.yPIpi53/UHG2ZdilZnphccMU0rvlIe','$2y$10$Ehp.KmQ2D27j/ktiQNasYu4gyOqOavvul5RlySOEcK109zOvMjbxW','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(47,'Simone','$2y$10$sEfsZdFkFV4RrsFnjOdVM.BhdSrTWVJ1RQMkuxnsKj5zfVr0.yo1O','$2y$10$OV/yO7vuoyNX0J7PRJmJiOq8cux3of9FfSLb4xCrtUHDZ0Nuai1We','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(48,'Stefan','$2y$10$A.R2o4/tYMbHwmtzMXE/H.NZEosRFHa64W.JaSc9ZEEI8WgeXdnFy','$2y$10$yr6.7of4KewgipaxIMa2peu/C90HXYVyjacpOOwADN8N8LaqUj/u2','modUser',1,NULL,NULL,'hashing.modNative','b814b658ff19219f1cbc9bfdff165951',4,NULL,0,1553531024),(49,'Tim','$2y$10$RfbTCgbsczIBhMW7rFyL0.ZFTl4AxXSXqqlgXsUqz/hg3PDKA0nl2','$2y$10$ZohVrHi6LOtFsmfbTtZrY.Hblbn13I.cmD9WzB8N6WbaXrZzAKnAO','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(50,'Thomas','$2y$10$srB4/rzmC7VLWFPGRFZVyOar5Z9HvGejLfyn8qJ2Gprxs3JtuNXGO','$2y$10$idfLHtiAqWaHdNHRc.Hf2.qClTtePfLBtzvIxgW58vqpD.GqtY3/C','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(52,'Verena','$2y$10$xY8vSxWYFrhMqys3uQS.VuEX7SQvMFul5.W6ss4sPCaww8AHTVQGG','$2y$10$4TSOAcYjdN4.cNHAA0NWceyb/DqDLIRgVV7/SkfjfpQev0N7hwT6m','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(53,'Wolfgang','$2y$10$I9IJFbKfCjekTjnhSsf7t.vPynIqKEYCXAW.kb5jyJE9BbfSbND52','$2y$10$ROZc8V.n9IIP4RSvjeGI..ZvMwC9Zzdc8IS2twXjziA6.SOfGayMq','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(54,'Ziegler','$2y$10$xGF22eLvXsjLUeAAe3mKZOnHeOFfI1/ty0zjpoYNFcyoQVRxK9IyG','$2y$10$FlOWj92eoA2G1NjBt9ma2e3bjjG5wu/84IHX0CAxfUKqYRW9X0VwC','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(56,'Mona','$2y$10$g.BRpztntOTIIkMv2tLaCuYkBLzeODZ4RdkgmwDjrLSpZbp82s0AK','$2y$10$X/JCQoYqhxzGxajs8uQC.eZEP4mR0SCdwJW1zc9pU4.zViYKmDnMq','modUser',1,NULL,NULL,'hashing.modNative','0e9721d8022ada58766fd5e161f875da',3,NULL,0,1553530870),(57,'Marcusz','$2y$10$TH6TMX80rOt5TEca9IGz8.HGrDdyM2ewV0tty2X/CX2w5up9lN07O','$2y$10$BafUugsyYRSuZjlJ8hyPgObd4M1xk/cfBk5lx4sRZc1h6gMi10bdW','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(58,'Tamara','$2y$10$f0n1lx5uAh75VHVc/Y8ZUOZieFeWgJHx/HMmbGfUbWqtjDMv/8Krq','$2y$10$AsqN5F7hsKytujNkYmWW4uWKzfwdQlCpjHG0Rqa989cXkUbtGGp2u','modUser',1,NULL,NULL,'hashing.modNative','0e9721d8022ada58766fd5e161f875da',3,NULL,0,1553530870),(59,'Christian99','$2y$10$8fwhS/wqPWPdeA9/OkbWhO2K0FD8FzXE8D/JwMgwkwat.5q/Dzct2','$2y$10$eYOX5kLgz.Sq.Wbqm/l4CO3bQgKh7Dsn2v0cYS5bFyxUE2Hf30WfO','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(60,'Jana','$2y$10$Y0R3h8Kxhfw/VMngrB3LcOWEWPkgE4VmZjZYL7Zk0EHIpXV1.l8aS','$2y$10$sgEICYm6My86I/UN2sWb..YG0ix6ADqZksGdX5iOO3VbBh8tTajC2','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(61,'Simonh','$2y$10$Fusf9RqVv8s57GyW6T/SVOkfGbeXJDR6TUq0Ch8RCKn0ses0fTOrm','$2y$10$hSLnsU7uBEMoQ2ImQDHDa..mhYwfzC0LVlIgTwkkbJgm2qTpDb0LW','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(62,'Stefanie','$2y$10$jheizgpQXFeNWw1MUBvsjuHftpXFf53.td3UI4j6oIvMn7UWhYdca','$2y$10$MfNuGvr0jL8YsNC2An0zEOM2ekYwYNoptJJCi116vwN/2mFhfntcG','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(63,'Adam','$2y$10$qiB1vE/3.nSv.21GWd5FvO9ZORyyVF8yqyu.3qqJt3uSir6khq2VG','$2y$10$YKBGCyIi56pjS6M/G/1ozuqkMBM7WRHScNXHj215UZOy8IvOOUhfK','modUser',1,NULL,NULL,'hashing.modNative','d9319ef78857a1071a9e48771722169e',3,NULL,0,1553531160),(64,'Carmen','$2y$10$fMgZzJ9jiFuCo6lAnyc7Y.kqmkOyuLTFUBbrnt3uaPMOJ2/kBJtcO','$2y$10$0LZ8FlPH6ihapxuTvvyDNuAldRiKdjhv2WIdFe59MQRhXbAXu7Lbu','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(65,'Mario','$2y$10$4VyYEo9UxHc/2oEkWxUHnuC60BUzIUFbWDC/W0Zrl5vYc6ob4v7jS','$2y$10$WGclxScEb7tZWxbaALyWsuAsE0qfO7FUAR7iZAWCn/5BHctLQR32W','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(66,'Homba','$2y$10$2JruuV1wuVgLulYfDJE2He5af6Y11SIHKDCNzWGEYJkYhB7BrvoQ.','$2y$10$i7MTBqwJCzUColZ9wh8bNejMDrtcjDP8Ar7KkHmJYtckGIL/Zjb3W','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(69,'Tanja','$2y$10$U0AE.YMPCbTm5GEN4ivvnOmgq3/dR6/Qgj6k07FeWfE5eqIMni3sW','$2y$10$JXIN0vjyYHel1NcuMy1WA.c.x6fWw6THZcPqCaSe8l5krBKtolmum','modUser',1,NULL,NULL,'hashing.modNative','c797251e61d30932ebad637237f13429',3,NULL,0,1553531086),(72,'Testausschuss','$2y$10$6B0Kd1g4E1Kz906qj1Po7uwez8q1TZ./OfowcSGl3ggkqWiMImKem','','modUser',0,NULL,NULL,'hashing.modNative','66c0c400523e7f94ee1e8fd9bdc96d4c',4,NULL,0,1557740934),(73,'Dieter','$2y$10$gwaLQDqX8t6BJ8RxI4tlWeuKXRq9D/WRaWR1poa2dxmu5bQnR1GiS','','modUser',1,NULL,NULL,'hashing.modNative','28e62b3854d7b573e66f6cfa7e76c638',3,NULL,0,1577470014),(74,'Testmitglied','$2y$10$qowumTQvnr8z77yfRl8j0e6Hs3mg8hbfmF35lQ3.FrzPDYMlxIgB.','$2y$10$8DJmEnrS8YQE.ZeaD4uX9uPbg.anR0y6mWDe0VQ5bai3bZuCxeYvy','modUser',0,NULL,NULL,'hashing.modNative','66c0c400523e7f94ee1e8fd9bdc96d4c',3,NULL,0,1557740934);
COMMIT;

-- Dumped table `modx_users` with 65 row(s)
--

--
-- Table structure for table `modx_workspaces`
--

CREATE TABLE `modx_workspaces` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL DEFAULT '',
  `path` varchar(191) NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `attributes` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `path` (`path`),
  KEY `name` (`name`),
  KEY `active` (`active`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modx_workspaces`
--

SET autocommit=0;
INSERT INTO `modx_workspaces` VALUES (1,'Default MODX workspace','{core_path}','2019-01-01 14:18:51',1,NULL);
COMMIT;

-- Dumped table `modx_workspaces` with 1 row(s)
--

--
-- Stand-In structure for view `c103_v_arbeitsdienst`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_arbeitsdienst`*/;
CREATE TABLE IF NOT EXISTS `c103_v_arbeitsdienst` (
`MdxUserID` int(10) unsigned
,`UserID` int(5)
,`Vorname` varchar(25)
,`Nachname` varchar(25)
,`KalenderID` int(11)
,`Date` datetime
,`Event` varchar(75)
,`Ort` varchar(50)
,`Dienste` int(2)
);
--
-- Stand-In structure for view `c103_v_busuebersicht`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_busuebersicht`*/;
CREATE TABLE IF NOT EXISTS `c103_v_busuebersicht` (
`BusID` int(11)
,`tVon` datetime
,`ort` varchar(50)
,`busInfo` varchar(100)
,`busStatus` tinyint(1)
,`busPlaetze` tinyint(2)
,`sumVerkauft` bigint(21)
);
--
-- Stand-In structure for view `c103_v_fahrkarten`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_fahrkarten`*/;
CREATE TABLE IF NOT EXISTS `c103_v_fahrkarten` (
`tVon` datetime
,`Ort` varchar(50)
,`busInfo` varchar(100)
,`BusID` int(11)
,`BusStatus` tinyint(1)
,`BusPlaetze` tinyint(2)
,`MdxUserID` int(10) unsigned
,`UserID` int(5)
,`Vorname` varchar(25)
,`Nachname` varchar(25)
,`Betrag` int(1)
);
--
-- Stand-In structure for view `c103_v_kalender`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_kalender`*/;
CREATE TABLE IF NOT EXISTS `c103_v_kalender` (
`name` varchar(75)
,`tVon` datetime
,`tBis` datetime
,`Zunft` varchar(50)
,`ort` varchar(50)
,`ortDetail` varchar(50)
,`kat` varchar(25)
,`bus` tinyint(1)
,`busTime` datetime
,`busInfo` varchar(100)
,`laufnr` varchar(10)
,`bemerkInt` varchar(1000)
,`bemerkExt` varchar(1000)
,`intFlag` tinyint(1)
,`timestamp` timestamp
);
--
-- Stand-In structure for view `c103_v_mitglieder`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_mitglieder`*/;
CREATE TABLE IF NOT EXISTS `c103_v_mitglieder` (
`MdxUserID` int(10) unsigned
,`UserID` int(5)
,`Anrede` varchar(25)
,`Vorname` varchar(25)
,`Nachname` varchar(25)
,`Strasse` varchar(50)
,`PLZ` int(5)
,`Ort` varchar(25)
,`Tel_p` varchar(25)
,`Mobil` varchar(25)
,`E_Mail` varchar(50)
,`Geburtsdatum` date
,`Bild` varchar(50)
,`Status` varchar(10)
,`Beitragsart` varchar(50)
,`Laufnr` smallint(3)
,`Position` varchar(50)
,`Eintritt` date
,`Austritt` date
);
--
-- View structure for view `c103_v_arbeitsdienst`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_arbeitsdienst`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nzmittel`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `c103_v_arbeitsdienst` AS select `modx_user_attributes`.`id` AS `MdxUserID`,`c103_mitgl_personen`.`id` AS `UserID`,`c103_mitgl_personen`.`Vorname` AS `Vorname`,`c103_mitgl_personen`.`Nachname` AS `Nachname`,`c103_kalender`.`ID` AS `KalenderID`,`c103_kalender`.`tVon` AS `Date`,`c103_kalender`.`name` AS `Event`,`c103_kalender`.`ort` AS `Ort`,`c103_arbeitsdienst`.`dienste` AS `Dienste` from (((`c103_arbeitsdienst` join `c103_mitgl_personen` on(`c103_mitgl_personen`.`id` = `c103_arbeitsdienst`.`userid`)) left join `c103_kalender` on(`c103_arbeitsdienst`.`eventid` = `c103_kalender`.`ID`)) left join `modx_user_attributes` on(`c103_mitgl_personen`.`E_Mail` = `modx_user_attributes`.`email`)) where `c103_mitgl_personen`.`Laufnr` >= 0 and `c103_mitgl_personen`.`id` < 90000 and (`c103_mitgl_personen`.`Austritt` = _utf8'0000-00-00' or `c103_mitgl_personen`.`Austritt` > curdate()) and `c103_mitgl_personen`.`Nachname`  not like _utf8'Leihhäs%' order by `c103_mitgl_personen`.`Nachname`,`c103_mitgl_personen`.`Vorname`,`c103_mitgl_personen`.`Strasse` */;

--
-- View structure for view `c103_v_busuebersicht`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_busuebersicht`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nzmittel`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `c103_v_busuebersicht` AS select `c103_kalender`.`ID` AS `BusID`,`c103_kalender`.`tVon` AS `tVon`,`c103_kalender`.`ort` AS `ort`,`c103_kalender`.`busInfo` AS `busInfo`,`c103_kalender`.`busStatus` AS `busStatus`,`c103_kalender`.`busPlaetze` AS `busPlaetze`,count(`c103_fahrkarten2020`.`BusID`) AS `sumVerkauft` from (`c103_kalender` join `c103_fahrkarten2020` on(`c103_kalender`.`ID` = `c103_fahrkarten2020`.`BusID`)) where `c103_kalender`.`gesperrt` = 0 and `c103_kalender`.`tBis` > curdate() and `c103_kalender`.`pubDate` <= curdate() and `c103_kalender`.`bus` = 1 and `c103_fahrkarten2020`.`Betrag` > 0 group by `c103_fahrkarten2020`.`BusID` order by `c103_kalender`.`tVon` */;

--
-- View structure for view `c103_v_fahrkarten`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_fahrkarten`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nzmittel`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `c103_v_fahrkarten` AS select `c103_kalender`.`tVon` AS `tVon`,`c103_kalender`.`ort` AS `Ort`,`c103_kalender`.`busInfo` AS `busInfo`,`c103_kalender`.`ID` AS `BusID`,`c103_kalender`.`busStatus` AS `BusStatus`,`c103_kalender`.`busPlaetze` AS `BusPlaetze`,`modx_user_attributes`.`id` AS `MdxUserID`,`c103_mitgl_personen`.`id` AS `UserID`,`c103_mitgl_personen`.`Vorname` AS `Vorname`,`c103_mitgl_personen`.`Nachname` AS `Nachname`,`c103_fahrkarten2020`.`Betrag` AS `Betrag` from (((`c103_fahrkarten2020` join `c103_kalender` on(`c103_fahrkarten2020`.`BusID` = `c103_kalender`.`ID`)) join `c103_mitgl_personen` on(`c103_mitgl_personen`.`id` = `c103_fahrkarten2020`.`UserID`)) left join `modx_user_attributes` on(`c103_mitgl_personen`.`E_Mail` = `modx_user_attributes`.`email`)) order by `c103_fahrkarten2020`.`UserID`,`c103_kalender`.`tVon` */;

--
-- View structure for view `c103_v_kalender`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_kalender`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`nzmittel`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `c103_v_kalender` AS select `c103_kalender`.`name` AS `name`,`c103_kalender`.`tVon` AS `tVon`,`c103_kalender`.`tBis` AS `tBis`,`c103_kalender`.`zunft` AS `Zunft`,`c103_kalender`.`ort` AS `ort`,`c103_kalender`.`ortDetail` AS `ortDetail`,`c103_kalender`.`kat` AS `kat`,`c103_kalender`.`bus` AS `bus`,`c103_kalender`.`busTime` AS `busTime`,`c103_kalender`.`busInfo` AS `busInfo`,`c103_kalender`.`laufnr` AS `laufnr`,`c103_kalender`.`bemerkInt` AS `bemerkInt`,`c103_kalender`.`bemerkExt` AS `bemerkExt`,`c103_kalender`.`intFlag` AS `intFlag`,`c103_kalender`.`timestamp` AS `timestamp` from `c103_kalender` where `c103_kalender`.`gesperrt` = 0 and `c103_kalender`.`tBis` > curdate() and `c103_kalender`.`pubDate` <= curdate() order by `c103_kalender`.`tVon`,`c103_kalender`.`tBis`,`c103_kalender`.`name` */;

--
-- View structure for view `c103_v_mitglieder`
--

/*!50001 DROP VIEW IF EXISTS `c103_v_mitglieder`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `c103_v_mitglieder` AS select `modx_user_attributes`.`id` AS `MdxUserID`,`c103_mitgl_personen`.`id` AS `UserID`,`c103_mitgl_personen`.`Anrede` AS `Anrede`,`c103_mitgl_personen`.`Vorname` AS `Vorname`,`c103_mitgl_personen`.`Nachname` AS `Nachname`,`c103_mitgl_personen`.`Strasse` AS `Strasse`,`c103_mitgl_personen`.`PLZ` AS `PLZ`,`c103_plz`.`Ort` AS `Ort`,`c103_mitgl_personen`.`Tel_p` AS `Tel_p`,`c103_mitgl_personen`.`Mobil` AS `Mobil`,`c103_mitgl_personen`.`E_Mail` AS `E_Mail`,`c103_mitgl_personen`.`Geburtsdatum` AS `Geburtsdatum`,`c103_mitgl_personen`.`Bild` AS `Bild`,`c103_mitgl_personen`.`Status` AS `Status`,`c103_mitgl_status`.`Beitragsart` AS `Beitragsart`,`c103_mitgl_personen`.`Laufnr` AS `Laufnr`,`c103_mitgl_personen`.`Position` AS `Position`,`c103_mitgl_personen`.`Eintritt` AS `Eintritt`,`c103_mitgl_personen`.`Austritt` AS `Austritt` from (((`c103_mitgl_personen` join `c103_plz` on(`c103_mitgl_personen`.`PLZ` = `c103_plz`.`PLZ`)) left join `c103_mitgl_status` on(`c103_mitgl_personen`.`Beitrag` = `c103_mitgl_status`.`ID`)) left join `modx_user_attributes` on(`c103_mitgl_personen`.`E_Mail` = `modx_user_attributes`.`email`)) where `c103_mitgl_personen`.`Laufnr` >= 0 and `c103_mitgl_personen`.`id` < 90000 and (`c103_mitgl_personen`.`Austritt` = _utf8'0000-00-00' or `c103_mitgl_personen`.`Austritt` > curdate()) and `c103_mitgl_personen`.`Nachname`  not like _utf8'Leihhäs%' order by `c103_mitgl_personen`.`Nachname`,`c103_mitgl_personen`.`Vorname`,`c103_mitgl_personen`.`Strasse` */;


