SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
-- Database: `contao3540`
-- --------------------------------------------------------
-- Table structure for table `tl_article`
CREATE TABLE `tl_article` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`author` int(10) unsigned NOT NULL DEFAULT '0',
`inColumn` varchar(32) NOT NULL DEFAULT '',
`showTeaser` char(1) NOT NULL DEFAULT '',
`teaserCssID` varchar(255) NOT NULL DEFAULT '',
`printable` varchar(255) NOT NULL DEFAULT '',
`customTpl` varchar(64) NOT NULL DEFAULT '',
`protected` char(1) NOT NULL DEFAULT '',
`guests` char(1) NOT NULL DEFAULT '',
`cssID` varchar(255) NOT NULL DEFAULT '',
`space` varchar(64) NOT NULL DEFAULT '',
`published` char(1) NOT NULL DEFAULT '',
`start` varchar(10) NOT NULL DEFAULT '',
`stop` varchar(10) NOT NULL DEFAULT '',
KEY `pid_start_stop_published_sorting` (`pid`,`start`,`stop`,`published`,`sorting`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_calendar`
CREATE TABLE `tl_calendar` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
`protected` char(1) NOT NULL DEFAULT '',
`allowComments` char(1) NOT NULL DEFAULT '',
`notify` varchar(32) NOT NULL DEFAULT '',
`sortOrder` varchar(32) NOT NULL DEFAULT '',
`perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
`moderate` char(1) NOT NULL DEFAULT '',
`bbcode` char(1) NOT NULL DEFAULT '',
`requireLogin` char(1) NOT NULL DEFAULT '',
`disableCaptcha` char(1) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_calendar_events`
CREATE TABLE `tl_calendar_events` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`author` int(10) unsigned NOT NULL DEFAULT '0',
`addTime` char(1) NOT NULL DEFAULT '',
`startTime` int(10) unsigned DEFAULT NULL,
`endTime` int(10) unsigned DEFAULT NULL,
`startDate` int(10) unsigned DEFAULT NULL,
`endDate` int(10) unsigned DEFAULT NULL,
`location` varchar(255) NOT NULL DEFAULT '',
`addImage` char(1) NOT NULL DEFAULT '',
`singleSRC` binary(16) DEFAULT NULL,
`alt` varchar(255) NOT NULL DEFAULT '',
`size` varchar(64) NOT NULL DEFAULT '',
`imagemargin` varchar(128) NOT NULL DEFAULT '',
`imageUrl` varchar(255) NOT NULL DEFAULT '',
`fullsize` char(1) NOT NULL DEFAULT '',
`caption` varchar(255) NOT NULL DEFAULT '',
`floating` varchar(32) NOT NULL DEFAULT '',
`recurring` char(1) NOT NULL DEFAULT '',
`repeatEach` varchar(64) NOT NULL DEFAULT '',
`repeatEnd` int(10) unsigned NOT NULL DEFAULT '0',
`recurrences` smallint(5) unsigned NOT NULL DEFAULT '0',
`addEnclosure` char(1) NOT NULL DEFAULT '',
`source` varchar(32) NOT NULL DEFAULT '',
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
`articleId` int(10) unsigned NOT NULL DEFAULT '0',
`url` varchar(255) NOT NULL DEFAULT '',
`target` char(1) NOT NULL DEFAULT '',
`cssClass` varchar(255) NOT NULL DEFAULT '',
`noComments` char(1) NOT NULL DEFAULT '',
`published` char(1) NOT NULL DEFAULT '',
`start` varchar(10) NOT NULL DEFAULT '',
`stop` varchar(10) NOT NULL DEFAULT '',
KEY `pid_start_stop_published` (`pid`,`start`,`stop`,`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_calendar_feed`
CREATE TABLE `tl_calendar_feed` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`language` varchar(32) NOT NULL DEFAULT '',
`format` varchar(32) NOT NULL DEFAULT '',
`source` varchar(32) NOT NULL DEFAULT '',
`maxItems` smallint(5) unsigned NOT NULL DEFAULT '0',
`feedBase` varchar(255) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_comments`
CREATE TABLE `tl_comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`source` varchar(32) NOT NULL DEFAULT '',
`parent` int(10) unsigned NOT NULL DEFAULT '0',
`date` varchar(64) NOT NULL DEFAULT '',
`name` varchar(64) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`website` varchar(128) NOT NULL DEFAULT '',
`addReply` char(1) NOT NULL DEFAULT '',
`author` int(10) unsigned NOT NULL DEFAULT '0',
`published` char(1) NOT NULL DEFAULT '',
`ip` varchar(64) NOT NULL DEFAULT '',
`notified` char(1) NOT NULL DEFAULT '',
KEY `published` (`published`),
KEY `source_parent_published` (`source`,`parent`,`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_comments_notify`
CREATE TABLE `tl_comments_notify` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`source` varchar(32) NOT NULL DEFAULT '',
`parent` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(128) NOT NULL DEFAULT '',
`email` varchar(128) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
`addedOn` varchar(10) NOT NULL DEFAULT '',
`ip` varchar(64) NOT NULL DEFAULT '',
`tokenConfirm` varchar(32) NOT NULL DEFAULT '',
`tokenRemove` varchar(32) NOT NULL DEFAULT '',
KEY `tokenRemove` (`tokenRemove`),
KEY `source_parent_tokenConfirm` (`source`,`parent`,`tokenConfirm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_content`
CREATE TABLE `tl_content` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`ptable` varchar(64) NOT NULL DEFAULT '',
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`type` varchar(64) NOT NULL DEFAULT '',
`headline` varchar(255) NOT NULL DEFAULT '',
`addImage` char(1) NOT NULL DEFAULT '',
`singleSRC` binary(16) DEFAULT NULL,
`alt` varchar(255) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
`size` varchar(64) NOT NULL DEFAULT '',
`imagemargin` varchar(128) NOT NULL DEFAULT '',
`imageUrl` varchar(255) NOT NULL DEFAULT '',
`fullsize` char(1) NOT NULL DEFAULT '',
`caption` varchar(255) NOT NULL DEFAULT '',
`floating` varchar(32) NOT NULL DEFAULT '',
`listtype` varchar(32) NOT NULL DEFAULT '',
`summary` varchar(255) NOT NULL DEFAULT '',
`thead` char(1) NOT NULL DEFAULT '',
`tfoot` char(1) NOT NULL DEFAULT '',
`tleft` char(1) NOT NULL DEFAULT '',
`sortable` char(1) NOT NULL DEFAULT '',
`sortIndex` smallint(5) unsigned NOT NULL DEFAULT '0',
`sortOrder` varchar(32) NOT NULL DEFAULT '',
`mooHeadline` varchar(255) NOT NULL DEFAULT '',
`mooStyle` varchar(255) NOT NULL DEFAULT '',
`mooClasses` varchar(255) NOT NULL DEFAULT '',
`highlight` varchar(32) NOT NULL DEFAULT '',
`shClass` varchar(255) NOT NULL DEFAULT '',
`url` varchar(255) NOT NULL DEFAULT '',
`target` char(1) NOT NULL DEFAULT '',
`titleText` varchar(255) NOT NULL DEFAULT '',
`linkTitle` varchar(255) NOT NULL DEFAULT '',
`embed` varchar(255) NOT NULL DEFAULT '',
`rel` varchar(64) NOT NULL DEFAULT '',
`useImage` char(1) NOT NULL DEFAULT '',
`useHomeDir` char(1) NOT NULL DEFAULT '',
`perRow` smallint(5) unsigned NOT NULL DEFAULT '0',
`perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
`numberOfItems` smallint(5) unsigned NOT NULL DEFAULT '0',
`sortBy` varchar(32) NOT NULL DEFAULT '',
`metaIgnore` char(1) NOT NULL DEFAULT '',
`galleryTpl` varchar(64) NOT NULL DEFAULT '',
`customTpl` varchar(64) NOT NULL DEFAULT '',
`youtube` varchar(16) NOT NULL DEFAULT '',
`posterSRC` binary(16) DEFAULT NULL,
`playerSize` varchar(64) NOT NULL DEFAULT '',
`autoplay` char(1) NOT NULL DEFAULT '',
`sliderDelay` int(10) unsigned NOT NULL DEFAULT '0',
`sliderSpeed` int(10) unsigned NOT NULL DEFAULT '300',
`sliderStartSlide` smallint(5) unsigned NOT NULL DEFAULT '0',
`sliderContinuous` char(1) NOT NULL DEFAULT '',
`cteAlias` int(10) unsigned NOT NULL DEFAULT '0',
`articleAlias` int(10) unsigned NOT NULL DEFAULT '0',
`article` int(10) unsigned NOT NULL DEFAULT '0',
`form` int(10) unsigned NOT NULL DEFAULT '0',
`module` int(10) unsigned NOT NULL DEFAULT '0',
`protected` char(1) NOT NULL DEFAULT '',
`guests` char(1) NOT NULL DEFAULT '',
`cssID` varchar(255) NOT NULL DEFAULT '',
`space` varchar(64) NOT NULL DEFAULT '',
`invisible` char(1) NOT NULL DEFAULT '',
`start` varchar(10) NOT NULL DEFAULT '',
`stop` varchar(10) NOT NULL DEFAULT '',
`com_order` varchar(32) NOT NULL DEFAULT '',
`com_perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
`com_moderate` char(1) NOT NULL DEFAULT '',
`com_bbcode` char(1) NOT NULL DEFAULT '',
`com_disableCaptcha` char(1) NOT NULL DEFAULT '',
`com_requireLogin` char(1) NOT NULL DEFAULT '',
`com_template` varchar(64) NOT NULL DEFAULT '',
KEY `pid_ptable_invisible_sorting` (`pid`,`ptable`,`invisible`,`sorting`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_cron`
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(32) DEFAULT NULL,
`value` varchar(32) NOT NULL DEFAULT '',
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
-- Dumping data for table `tl_cron`
INSERT INTO `tl_cron` VALUES
(1, 'lastrun', '[[timestamp]]'),
(2, 'monthly', '[[cron_monthly]]'),
(3, 'weekly', '[[cron_weekly]]'),
(4, 'daily', '[[cron_daily]]'),
-- --------------------------------------------------------
-- Table structure for table `tl_extension`
CREATE TABLE `tl_extension` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(64) NOT NULL DEFAULT '',
`folder` varchar(48) NOT NULL DEFAULT '',
`author` varchar(128) NOT NULL DEFAULT '',
`copyright` varchar(128) NOT NULL DEFAULT '',
`package` varchar(64) NOT NULL DEFAULT '',
`license` varchar(64) NOT NULL DEFAULT '',
`addBeMod` char(1) NOT NULL DEFAULT '',
`beClasses` varchar(255) NOT NULL DEFAULT '',
`beTables` varchar(255) NOT NULL DEFAULT '',
`beTemplates` varchar(255) NOT NULL DEFAULT '',
`addFeMod` char(1) NOT NULL DEFAULT '',
`feClasses` varchar(255) NOT NULL DEFAULT '',
`feTables` varchar(255) NOT NULL DEFAULT '',
`feTemplates` varchar(255) NOT NULL DEFAULT '',
`addLanguage` char(1) NOT NULL DEFAULT '',
`languages` varchar(255) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_faq`
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`question` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`author` int(10) unsigned NOT NULL DEFAULT '0',
`addImage` char(1) NOT NULL DEFAULT '',
`singleSRC` binary(16) DEFAULT NULL,
`alt` varchar(255) NOT NULL DEFAULT '',
`size` varchar(64) NOT NULL DEFAULT '',
`imagemargin` varchar(128) NOT NULL DEFAULT '',
`imageUrl` varchar(255) NOT NULL DEFAULT '',
`fullsize` char(1) NOT NULL DEFAULT '',
`caption` varchar(255) NOT NULL DEFAULT '',
`floating` varchar(12) NOT NULL DEFAULT '',
`addEnclosure` char(1) NOT NULL DEFAULT '',
`noComments` char(1) NOT NULL DEFAULT '',
`published` char(1) NOT NULL DEFAULT '',
KEY `pid_published_sorting` (`pid`,`published`,`sorting`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_faq_category`
CREATE TABLE `tl_faq_category` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`headline` varchar(255) NOT NULL DEFAULT '',
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
`allowComments` char(1) NOT NULL DEFAULT '',
`notify` varchar(16) NOT NULL DEFAULT '',
`sortOrder` varchar(12) NOT NULL DEFAULT '',
`perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
`moderate` char(1) NOT NULL DEFAULT '',
`bbcode` char(1) NOT NULL DEFAULT '',
`requireLogin` char(1) NOT NULL DEFAULT '',
`disableCaptcha` char(1) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_files`
CREATE TABLE `tl_files` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` binary(16) DEFAULT NULL,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`uuid` binary(16) DEFAULT NULL,
`type` varchar(16) NOT NULL DEFAULT '',
`path` varchar(1022) NOT NULL DEFAULT '',
`extension` varchar(16) NOT NULL DEFAULT '',
`hash` varchar(32) NOT NULL DEFAULT '',
`found` char(1) NOT NULL DEFAULT '1',
`name` varchar(255) NOT NULL DEFAULT '',
`importantPartX` int(10) NOT NULL DEFAULT '0',
`importantPartY` int(10) NOT NULL DEFAULT '0',
`importantPartWidth` int(10) NOT NULL DEFAULT '0',
`importantPartHeight` int(10) NOT NULL DEFAULT '0',
UNIQUE KEY `uuid` (`uuid`),
KEY `path` (`path`(333)),
KEY `extension` (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
-- Dumping data for table `tl_files`
INSERT INTO `tl_files` VALUES
-- --------------------------------------------------------
-- Table structure for table `tl_form`
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
`sendViaEmail` char(1) NOT NULL DEFAULT '',
`recipient` varchar(1022) NOT NULL DEFAULT '',
`subject` varchar(255) NOT NULL DEFAULT '',
`format` varchar(12) NOT NULL DEFAULT '',
`skipEmpty` char(1) NOT NULL DEFAULT '',
`storeValues` char(1) NOT NULL DEFAULT '',
`targetTable` varchar(64) NOT NULL DEFAULT '',
`method` varchar(12) NOT NULL DEFAULT '',
`novalidate` char(1) NOT NULL DEFAULT '',
`attributes` varchar(255) NOT NULL DEFAULT '',
`formID` varchar(64) NOT NULL DEFAULT '',
`tableless` char(1) NOT NULL DEFAULT '',
`allowTags` char(1) NOT NULL DEFAULT '',
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `tl_form_field`
CREATE TABLE `tl_form_field` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
`invisible` char(1) NOT NULL DEFAULT '',
`type` varchar(64) NOT NULL DEFAULT '',
`name` varchar(64) NOT NULL DEFAULT '',
`label` varchar(255) NOT NULL DEFAULT '',
`mandatory` char(1) NOT NULL DEFAULT '',
`rgxp` varchar(32) NOT NULL DEFAULT '',
`placeholder` varchar(255) NOT NULL DEFAULT '',
`minlength` int(10) unsigned NOT NULL DEFAULT '0',
`maxlength` int(10) unsigned NOT NULL DEFAULT '0',
`size` varchar(255) NOT NULL DEFAULT '',
`multiple` char(1) NOT NULL DEFAULT '',
`mSize` smallint(5) unsigned NOT NULL DEFAULT '0',
`extensions` varchar(255) NOT NULL DEFAULT '',
`storeFile` char(1) NOT NULL DEFAULT '',
`uploadFolder` binary(16) DEFAULT NULL,
`useHomeDir` char(1) NOT NULL DEFAULT '',
`doNotOverwrite` char(1) NOT NULL DEFAULT '',
`fsType` varchar(32) NOT NULL DEFAULT '',
`class` varchar(255) NOT NULL DEFAULT '',
`value` varchar(255) NOT NULL DEFAULT '',
`accesskey` char(1) NOT NULL DEFAULT '',
`tabindex` smallint(5) unsigned NOT NULL DEFAULT '0',
`fSize` smallint(5) unsigned NOT NULL DEFAULT '0',
`customTpl` varchar(64) NOT NULL DEFAULT '',