


# Export von Tabelle bolt_info
# ------------------------------------------------------------


CREATE TABLE `bolt_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `datecreated` datetime NOT NULL,
  `datechanged` datetime NOT NULL,
  `datepublish` datetime DEFAULT NULL,
  `datedepublish` datetime DEFAULT NULL,
  `templatefields` longtext COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(32) COLLATE utf8_unicode_ci DEFAULT '',
  `ownerid` int(11) DEFAULT NULL,
  `status` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_317983AD989D9B62` (`slug`),
  KEY `IDX_317983ADAFBA6FD8` (`datecreated`),
  KEY `IDX_317983ADBE74E59A` (`datechanged`),
  KEY `IDX_317983ADA5131421` (`datepublish`),
  KEY `IDX_317983ADB7805520` (`datedepublish`),
  KEY `IDX_317983AD7B00651C` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `bolt_info` (`id`, `slug`, `datecreated`, `datechanged`, `datepublish`, `datedepublish`, `templatefields`, `username`, `ownerid`, `status`, `title`, `text`)
VALUES
	(1,'not-found','2016-02-24 13:58:25','2016-02-24 14:02:25','2016-02-24 13:58:18',NULL,'[]','',4,'published','Error 404','<p>Error 404</p>');



# Export von Tabelle bolt_users
# ------------------------------------------------------------


CREATE TABLE `bolt_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(254) COLLATE utf8_unicode_ci NOT NULL,
  `lastseen` datetime DEFAULT NULL,
  `lastip` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `displayname` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `stack` varchar(1024) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `enabled` tinyint(1) NOT NULL,
  `shadowpassword` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `shadowtoken` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `shadowvalidity` datetime DEFAULT NULL,
  `failedlogins` int(11) NOT NULL DEFAULT '0',
  `throttleduntil` datetime DEFAULT NULL,
  `roles` varchar(1024) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5585B54F85E0677` (`username`),
  UNIQUE KEY `UNIQ_5585B54E7927C74` (`email`),
  KEY `IDX_5585B5450F9BB84` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `bolt_users` (`username`, `password`, `email`, `lastseen`, `lastip`, `displayname`, `stack`, `enabled`, `shadowpassword`, `shadowtoken`, `shadowvalidity`, `failedlogins`, `throttleduntil`, `roles`)
VALUES
	('tbulla','$P$DJYjZDsm8ij.PPKsVC8k/dsWjA93cu0','tobias.bulla@condenast.de',NULL,'','Tobias Bulla','[]',1,'','',NULL,0,NULL,'[\"root\"]'),
	('cwoldt','$P$DVq0tKVjltTDtbNncDCBMo6TY66cH1.','christian.woldt@condenast.de',NULL,'','Christian Woldt','[]',1,'','',NULL,0,NULL,'[\"root\"]'),
	('dforster','$P$DrpnwlUnDOdSsLPRhtbTFQoHjoFiXp/','danny.forster@condenast.de',NULL,'','Danny Forster','[]',1,'','',NULL,0,NULL,'[\"root\"]'),
	('rralev','$P$D7mPglTmEdcW8O2Xrm9gwFgVsnerf4/','rosen.ralev@condenast.de',NULL,'','Rosen Ralev','[]',1,'','',NULL,0,NULL,'[\"root\"]'),
  	('gkauntz', '$P$DnpVuYrcOzVFBvwen0nOz7V//xTh5E.', 'gert.kauntz@condenast.de', NULL, '', 'Gert Kauntz', '[]', 1, '', '', NULL, 0, NULL, '[\"root\"]'),
	('nengin', '$2y$08$PbCPmWjlVFpSLfYC68AGNuQlcnaAdsoRDsbMgqE5mPOjrarLRpE6K', 'nergis.engin@condenast.de', NULL, '', 'Nergis Engin', '[]', 1, '', '', NULL, 0, NULL, '[\"root\"]'),
	('atheobold', '$P$DbQp1G/KPNuZYOo5sBsLyVcL6a7EYb.', 'alexander.theobold@condenast.de', NULL, '', 'Alexander Theobold', '[]', 1, '', '', NULL, 0, NULL, '[\"root\"]');


