Fatal Error

**vfl63langerwehe** · 18.03.2018, 18:35

Liebe Community,

ich wollte heute Abend das CMS updaten. Hierbei habe ich folgenden Hinweis bekommen
Ihre Installation konnte nicht vollständig aktualisiert werden. Benötigt Contao auf Ihrem Server den Safe-Mode-Hack und haben Sie diesen korrekt konfiguriert?

Außerdem bekomme ich diese Meldung wenn ich auf das Backend zugreifen möchte:

Code:

Fatal error: Uncaught exception Exception with message Query error: Unknown column 'userid' in 'field list' (SELECT pid, tstamp, version, fromTable, username, userid, description, editUrl, active FROM tl_version ORDER BY tstamp DESC, pid, version DESC LIMIT 0,30) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295
#0 system/modules/core/library/Contao/Database/Statement.php(264): Contao\Database\Statement->query()
#1 system/modules/core/classes/Versions.php(618): Contao\Database\Statement->execute('14')
#2 system/modules/core/controllers/BackendMain.php(175): Contao\Versions::addToTemplate(Object(Contao\BackendTemplate))
#3 system/modules/core/controllers/BackendMain.php(125): Contao\BackendMain->welcomeScreen()
#4 contao/main.php(20): Contao\BackendMain->run()
#5 {main}

Was kann ich da machen ?

VG
VfL 63 Langerwehe

//Moderation: Beitrag in ein neues Thema verschoben.

**vfl63langerwehe** · 18.03.2018, 21:10

Jetzt habe ich ein weiteres Problem:

ich kann nicht mehr vfl63langerwehe/contao/main.php oder vfl63langerwehe/contao/install.php au frufen.

Ich brauche dringend Hilfe !

**tab** · 18.03.2018, 21:29

Um welche Contao-Version geht es denn überhaupt? Und von welcher auf welche Version wolltest du updaten? Dass nach dem Safe-Mode-Hack gefragt wird, deutet für mich darauf hin, dass Dateien nicht geschrieben werden konnten. Also möglicherweise ein Rechteproblem. Hast du schon mal probiert, den Contao-Check laufen zu lassen? (https://docs.contao.org/books/manual...igurieren.html)

**vfl63langerwehe** · 18.03.2018, 21:38

Ich glaube es sollte auf Contao 3.5 aktualisiert werden.

Die letzte Version ist glaube ich von 2013. Ich habe keine Kenntnis vom HTML oder Php.

Aktuell ist es so, dass wenn ich das backend aufrufen möchte (www.vfl63langerwehe.de/contao/main.php) erscheint eine weiße Seite.

Das ist der aktuelle Code aus der localconfig.php.

<?php

### INSTALL SCRIPT START ###
$GLOBALS['TL_CONFIG']['licenseAccepted'] = true;
$GLOBALS['TL_CONFIG']['displayErrors'] = true;

KfM.MzaYRY3EDpw2RYgpedkFjGSNEq';
$GLOBALS['TL_CONFIG']['encryptionKey'] = 'd160a3f2e3ae38c7d9415431f1af66a4';
$GLOBALS['TL_CONFIG']['dbDriver'] = 'MySQL';
$GLOBALS['TL_CONFIG']['dbHost'] = 'localhost';
$GLOBALS['TL_CONFIG']['dbUser'] = 'xxx';
$GLOBALS['TL_CONFIG']['dbPass'] = 'xxx';
$GLOBALS['TL_CONFIG']['dbDatabase'] = 'xxx';
$GLOBALS['TL_CONFIG']['dbPconnect'] = false;
$GLOBALS['TL_CONFIG']['dbCharset'] = 'UTF8';
$GLOBALS['TL_CONFIG']['dbPort'] = 3306;
$GLOBALS['TL_CONFIG']['dbSocket'] = '';
$GLOBALS['TL_CONFIG']['installCount'] = 0;
### INSTALL SCRIPT STOP ###

**07alex07** · 18.03.2018, 22:01

Sicher das die Datei so aussieht?
Das mit kfm.... sieht für mich komisch aus.

**folkfreund** · 18.03.2018, 22:05

Du hast hoffentlich ein Backup von vor dem Update-Versuch?

Bei einem Update über mehrere Versionen hinweg ist es nicht besonders unwahrscheinlich, dass irgendwelche Erweiterungen nicht funktionieren. Es wäre also gut, mehr Informationen zu haben, v.a. von welcher Version genau du ausgegangen bist und welche Erweiterungen (in welchen Versionen) installiert sind/waren.

Edit:
@Alex: stimmt, da scheint es einfach einen Fehler in der Datei zu geben. Hab ich übersehen...
Eventuell einfach mal diese Zeile löschen?

**vfl63langerwehe** · 18.03.2018, 22:21

Das mit kfm kommt glaube ich daher das in der Zeile davor das mit $Globals Password steht.

Ich kann leider nichts zu den Versionnummern sagen. Es wurde durch das unvollständige Update ein Backup gemacht.

Wenn ich die Zeile lösche, bekomme ich:

Code:

Warning: mysql_connect(): Access denied for user 'xxx'@'localhost' (using password: YES) in system/modules/core/library/Contao/Database/Mysql.php on line 47
#0 [internal function]: __error(2, 'mysql_connect()...', '/var/www/xxx...', 47, Array)
#1 system/modules/core/library/Contao/Database/Mysql.php(47): mysql_connect('localhost:3306', 'xxx', 'xxx...')
#2 system/modules/core/library/Contao/Database.php(81): Contao\Database\Mysql->connect()
#3 system/modules/core/library/Contao/Database.php(165): Contao\Database->__construct(Array)
#4 [internal function]: Contao\Database::getInstance()
#5 system/modules/core/library/Contao/System.php(140): call_user_func(Array)
#6 system/modules/core/library/Contao/User.php(158): Contao\System->import('Database')
#7 system/modules/core/classes/FrontendUser.php(62): Contao\User->__construct()
#8 system/modules/core/library/Contao/User.php(220): Contao\FrontendUser->__construct()
#9 [internal function]: Contao\User::getInstance()
#10 system/modules/core/library/Contao/System.php(140): call_user_func(Array)
#11 system/modules/core/controllers/FrontendIndex.php(31): Contao\System->import('FrontendUser', 'User')
#12 index.php(19): Contao\FrontendIndex->__construct()
#13 {main}

Fatal error: Uncaught exception Exception with message Access denied for user 'xxx'@'localhost' (using password: YES) thrown in system/modules/core/library/Contao/Database/Mysql.php on line 52
#0 system/modules/core/library/Contao/Database.php(81): Contao\Database\Mysql->connect()
#1 system/modules/core/library/Contao/Database.php(165): Contao\Database->__construct(Array)
#2 [internal function]: Contao\Database::getInstance()
#3 system/modules/core/library/Contao/System.php(140): call_user_func(Array)
#4 system/modules/core/library/Contao/User.php(158): Contao\System->import('Database')
#5 system/modules/core/classes/FrontendUser.php(62): Contao\User->__construct()
#6 system/modules/core/library/Contao/User.php(220): Contao\FrontendUser->__construct()
#7 [internal function]: Contao\User::getInstance()
#8 system/modules/core/library/Contao/System.php(140): call_user_func(Array)
#9 system/modules/core/controllers/FrontendIndex.php(31): Contao\System->import('FrontendUser', 'User')
#10 index.php(19): Contao\FrontendIndex->__construct()
#11 {main}

Ich habe ok-webhosting als Server Host und dort sind zwei Datenbanken genannt:
kweb31_1 mit der Bemerkung custom
kweb31_2 mit der Bemerkung typolight

**tab** · 18.03.2018, 22:26

Also da fehlt mir doch einiges, z.B. die Zeile mit dem installPassword. Platz hast du noch genug auf deinem Webspace?

**jk1** · 18.03.2018, 23:58

Hi,

dein Install-Tool ist inzwischen wieder erreichbar, siehe:
http://www.vfl63langerwehe.de/contao/install.php

Da das Install-Tool Passwort nicht mehr in deiner Config-Datei stand, konnte nun jede Person selber eines vergeben & den Installations-Vorgang fortsetzen.
Damit das niemand mit böser Absicht macht, habe ich dir mal eins eingetragen & es dir per PN geschickt.

Du siehst dann die Eingabe für die Datenbankdaten. Prüfe die Felder "Benutzername", "Passwort" und "Datenbank".
Diese Daten solltest du bei deinem Hoster sehen.

Danach sehen wir weiter.

Ändere dein Install-Tool-Passwort dann am besten auch wieder, direkt oben im ersten Bereich zum aufklappen :-)

Viel Erfolg!

**vfl63langerwehe** · 19.03.2018, 06:05

Hallo,

schon mal vielen Dank für die ersten Hilfestellungen.

Auf vfl63langerwehe.de/contao/install.php habe ich im ersten Schritt ein neues Passwort eingetragen.

Dann konnte ich erfolgreich eine Verbindung zur Datenbank herstellen.

Nun wird mir gesagt, dass die Datenbank nicht aktuell ist.

Genügend Webspace habe ich.

Code:

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) COLLATE utf8_bin NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `inColumn` varchar(32) NOT NULL default '',
  `keywords` text NULL,
  `showTeaser` char(1) NOT NULL default '',
  `teaserCssID` varchar(255) NOT NULL default '',
  `teaser` text NULL,
  `printable` varchar(255) NOT NULL default '',
  `customTpl` varchar(64) NOT NULL default '',
  `protected` char(1) NOT NULL default '',
  `groups` blob NULL,
  `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 '',
  `dw_description` text NULL,
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`),
  KEY `pid_start_stop_published_sorting` (`pid`, `start`, `stop`, `published`, `sorting`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
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 '',
  `text` mediumtext NULL,
  `addImage` char(1) NOT NULL default '',
  `singleSRC` binary(16) 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 '',
  `html` mediumtext NULL,
  `listtype` varchar(32) NOT NULL default '',
  `listitems` blob NULL,
  `tableitems` mediumblob NULL,
  `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 '',
  `code` text NULL,
  `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 '',
  `multiSRC` blob NULL,
  `orderSRC` blob NULL,
  `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 '',
  `playerSRC` blob NULL,
  `youtube` varchar(16) NOT NULL default '',
  `posterSRC` binary(16) 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 '',
  `groups` blob NULL,
  `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 '',
  `dfTitle` varchar(64) NOT NULL default '',
  `dfSize` varchar(64) NOT NULL default '',
  `dfTemplate` varchar(32) NOT NULL default '',
  `dlh_googlemap` int(10) unsigned NOT NULL default '0',
  `dlh_googlemap_zoom` int(10) unsigned NOT NULL default '0',
  `dlh_googlemap_size` varchar(255) NOT NULL default '',
  `dlh_googlemap_static` char(1) NOT NULL default '',
  `dlh_googlemap_url` varchar(255) NOT NULL default '',
  `movie_controls` char(1) NOT NULL default '',
  `movie_preload` char(1) NOT NULL default '',
  `movie_autoplay` char(1) NOT NULL default '',
  `movie_loop` char(1) NOT NULL default '',
  `movie_width` varchar(5) NOT NULL default '',
  `movie_height` varchar(5) NOT NULL default '',
  `movie_preview` varchar(255) NOT NULL default '',
  `movie_mp4` varchar(255) NOT NULL default '',
  `movie_ogg` varchar(255) NOT NULL default '',
  `audio_controls` char(1) NOT NULL default '',
  `audio_preload` char(1) NOT NULL default '',
  `audio_autoplay` char(1) NOT NULL default '',
  `audio_loop` char(1) NOT NULL default '',
  `audio_mp3` varchar(255) NOT NULL default '',
  `audio_ogg` varchar(255) NOT NULL default '',
  `nSMode` varchar(64) NOT NULL default 'horicontal',
  `nSElemClass` varchar(255) NOT NULL default '',
  `nSElemWidth` varchar(255) NOT NULL default '',
  `nSElemHeight` varchar(255) NOT NULL default '',
  `nSEffectsExtended` char(1) NOT NULL default '',
  `nSEffectTransition` varchar(64) NOT NULL default '',
  `nSEffectEase` varchar(64) NOT NULL default '',
  `nSPlayAuto` char(1) NOT NULL default '',
  `nSEffectInterval` int(10) NOT NULL default '3000',
  `nSEffectDuration` int(10) NOT NULL default '1000',
  `nSStartPoint` int(10) NOT NULL default '0',
  `nSControls` char(1) NOT NULL default '',
  `nSControlButtons` char(1) NOT NULL default '',
  `nSSideButtons` char(1) NOT NULL default '',
  `nSNews` int(10) unsigned NOT NULL default '0',
  `nSBackground` varchar(255) NOT NULL default '',
  `nSUrl` varchar(255) NOT NULL default '',
  `nSTarget` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid_ptable_invisible_sorting` (`pid`, `ptable`, `invisible`, `sorting`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_cron` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(32) NULL,
  `value` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_files` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` binary(16) NULL,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `uuid` binary(16) 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',
  `meta` blob NULL,
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`),
  UNIQUE KEY `uuid` (`uuid`),
  KEY `path` (`path`(333)),
  KEY `extension` (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE 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) 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 '',
  `storeFormdata` char(1) NOT NULL default '',
  `efgStoreValues` char(1) NOT NULL default '',
  `useFormValues` char(1) NOT NULL default '',
  `useFieldNames` char(1) NOT NULL default '',
  `efgAliasField` varchar(64) NOT NULL default '',
  `sendConfirmationMail` char(1) NOT NULL default '',
  `confirmationMailRecipientField` varchar(64) NOT NULL default '',
  `confirmationMailRecipient` varchar(255) NOT NULL default '',
  `confirmationMailSender` varchar(255) NOT NULL default '',
  `confirmationMailReplyto` varchar(255) NOT NULL default '',
  `confirmationMailSubject` varchar(255) NOT NULL default '',
  `confirmationMailText` text NULL,
  `confirmationMailTemplate` varchar(255) NOT NULL default '',
  `confirmationMailSkipEmpty` char(1) NOT NULL default '',
  `sendFormattedMail` char(1) NOT NULL default '',
  `formattedMailRecipient` text NULL,
  `formattedMailSubject` varchar(255) NOT NULL default '',
  `formattedMailText` text NULL,
  `formattedMailTemplate` varchar(255) NOT NULL default '',
  `formattedMailSkipEmpty` char(1) NOT NULL default '',
  `addConfirmationMailAttachments` char(1) NOT NULL default '',
  `confirmationMailAttachments` blob NULL,
  `addFormattedMailAttachments` char(1) NOT NULL default '',
  `formattedMailAttachments` blob NULL,
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
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 '',
  `text` text NULL,
  `html` text NULL,
  `options` blob NULL,
  `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) 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 '',
  `addSubmit` char(1) NOT NULL default '',
  `slabel` varchar(255) NOT NULL default '',
  `imageSubmit` char(1) NOT NULL default '',
  `singleSRC` binary(16) NULL,
  `efgLookupOptions` text NULL,
  `efgMultiSRC` text NULL,
  `efgImageMultiple` char(1) NOT NULL default '',
  `efgImageUseHomeDir` char(1) NOT NULL default '',
  `efgImageSortBy` varchar(32) NOT NULL default '',
  `efgImageSize` varchar(255) NOT NULL default '',
  `efgImagePerRow` smallint(5) unsigned NOT NULL default '0',
  `efgImageMargin` varchar(255) NOT NULL default '',
  `efgImageFullsize` char(1) NOT NULL default '',
  `efgAddBackButton` char(1) NOT NULL default '',
  `efgBackSlabel` varchar(255) NOT NULL default '',
  `efgBackImageSubmit` char(1) NOT NULL default '',
  `efgBackSingleSRC` varchar(255) NOT NULL default '',
  `efgBackStoreSessionValues` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_image_size` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NULL,
  `sizes` varchar(255) NOT NULL default '',
  `densities` varchar(255) NOT NULL default '',
  `width` int(10) NULL,
  `height` int(10) NULL,
  `resizeMode` varchar(255) NOT NULL default '',
  `zoom` int(10) NULL,
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_image_size_item` (
  `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',
  `media` varchar(255) NOT NULL default '',
  `sizes` varchar(255) NOT NULL default '',
  `densities` varchar(255) NOT NULL default '',
  `width` int(10) NULL,
  `height` int(10) NULL,
  `resizeMode` varchar(255) NOT NULL default '',
  `zoom` int(10) NULL,
  `invisible` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_layout` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `rows` varchar(8) NOT NULL default '',
  `headerHeight` varchar(255) NOT NULL default '',
  `footerHeight` varchar(255) NOT NULL default '',
  `cols` varchar(8) NOT NULL default '',
  `widthLeft` varchar(255) NOT NULL default '',
  `widthRight` varchar(255) NOT NULL default '',
  `sections` varchar(1022) NOT NULL default '',
  `sPosition` varchar(32) NOT NULL default '',
  `framework` varchar(255) NOT NULL default '',
  `stylesheet` blob NULL,
  `external` blob NULL,
  `orderExt` blob NULL,
  `loadingOrder` varchar(16) NOT NULL default '',
  `newsfeeds` blob NULL,
  `calendarfeeds` blob NULL,
  `modules` blob NULL,
  `template` varchar(64) NOT NULL default '',
  `doctype` varchar(32) NOT NULL default '',
  `webfonts` varchar(255) NOT NULL default '',
  `picturefill` char(1) NOT NULL default '',
  `viewport` varchar(255) NOT NULL default '',
  `titleTag` varchar(255) NOT NULL default '',
  `cssClass` varchar(255) NOT NULL default '',
  `onload` varchar(255) NOT NULL default '',
  `head` text NULL,
  `addJQuery` char(1) NOT NULL default '',
  `jSource` varchar(16) NOT NULL default '',
  `jquery` text NULL,
  `addMooTools` char(1) NOT NULL default '',
  `mooSource` varchar(16) NOT NULL default '',
  `mootools` text NULL,
  `analytics` text NULL,
  `script` text NULL,
  `static` char(1) NOT NULL default '',
  `width` varchar(255) NOT NULL default '',
  `align` varchar(32) NOT NULL default '',
  `summarizeFeeds` blob NULL,
  `usejquery` char(1) NOT NULL default '',
  `jquerySource` varchar(32) NOT NULL default '',
  `jqueryVersion` varchar(32) NOT NULL default '',
  `jqueryNoConflict` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_log` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `source` varchar(32) NOT NULL default '',
  `action` varchar(32) NOT NULL default '',
  `username` varchar(64) NOT NULL default '',
  `text` text NULL,
  `func` varchar(255) NOT NULL default '',
  `ip` varchar(64) NOT NULL default '',
  `browser` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_member` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `firstname` varchar(255) NOT NULL default '',
  `lastname` varchar(255) NOT NULL default '',
  `dateOfBirth` varchar(11) NOT NULL default '',
  `gender` varchar(32) NOT NULL default '',
  `company` varchar(255) NOT NULL default '',
  `street` varchar(255) NOT NULL default '',
  `postal` varchar(32) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state` varchar(64) NOT NULL default '',
  `country` varchar(2) NOT NULL default '',
  `phone` varchar(64) NOT NULL default '',
  `mobile` varchar(64) NOT NULL default '',
  `fax` varchar(64) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `website` varchar(255) NOT NULL default '',
  `language` varchar(5) NOT NULL default '',
  `groups` blob NULL,
  `login` char(1) NOT NULL default '',
  `username` varchar(64) COLLATE utf8_bin NULL,
  `password` varchar(128) NOT NULL default '',
  `assignDir` char(1) NOT NULL default '',
  `homeDir` binary(16) NULL,
  `disable` char(1) NOT NULL default '',
  `start` varchar(10) NOT NULL default '',
  `stop` varchar(10) NOT NULL default '',
  `dateAdded` int(10) unsigned NOT NULL default '0',
  `lastLogin` int(10) unsigned NOT NULL default '0',
  `currentLogin` int(10) unsigned NOT NULL default '0',
  `loginCount` smallint(5) unsigned NOT NULL default '3',
  `locked` int(10) unsigned NOT NULL default '0',
  `session` blob NULL,
  `autologin` varchar(32) NULL,
  `createdOn` int(10) unsigned NOT NULL default '0',
  `activation` varchar(32) NOT NULL default '',
  `allowEmail` varchar(32) NOT NULL default '',
  `publicFields` blob NULL,
  `newsletter` blob NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `email` (`email`),
  UNIQUE KEY `autologin` (`autologin`),
  KEY `activation` (`activation`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_member_group` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `redirect` char(1) NOT NULL default '',
  `jumpTo` int(10) unsigned NOT NULL default '0',
  `disable` char(1) NOT NULL default '',
  `start` varchar(10) NOT NULL default '',
  `stop` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_module` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `headline` varchar(255) NOT NULL default '',
  `type` varchar(64) NOT NULL default '',
  `levelOffset` smallint(5) unsigned NOT NULL default '0',
  `showLevel` smallint(5) unsigned NOT NULL default '0',
  `hardLimit` char(1) NOT NULL default '',
  `showProtected` char(1) NOT NULL default '',
  `defineRoot` char(1) NOT NULL default '',
  `rootPage` int(10) unsigned NOT NULL default '0',
  `navigationTpl` varchar(64) NOT NULL default '',
  `customTpl` varchar(64) NOT NULL default '',
  `pages` blob NULL,
  `orderPages` blob NULL,
  `showHidden` char(1) NOT NULL default '',
  `customLabel` varchar(64) NOT NULL default '',
  `autologin` char(1) NOT NULL default '',
  `jumpTo` int(10) unsigned NOT NULL default '0',
  `redirectBack` char(1) NOT NULL default '',
  `cols` varchar(32) NOT NULL default '',
  `editable` blob NULL,
  `memberTpl` varchar(64) NOT NULL default '',
  `tableless` char(1) NOT NULL default '',
  `form` int(10) unsigned NOT NULL default '0',
  `queryType` varchar(32) NOT NULL default '',
  `fuzzy` char(1) NOT NULL default '',
  `contextLength` smallint(5) unsigned NOT NULL default '0',
  `totalLength` smallint(5) unsigned NOT NULL default '0',
  `perPage` smallint(5) unsigned NOT NULL default '0',
  `searchType` varchar(32) NOT NULL default '',
  `searchTpl` varchar(64) NOT NULL default '',
  `inColumn` varchar(32) NOT NULL default '',
  `skipFirst` smallint(5) unsigned NOT NULL default '0',
  `loadFirst` char(1) NOT NULL default '',
  `size` varchar(64) NOT NULL default '',
  `transparent` char(1) NOT NULL default '',
  `flashvars` varchar(255) NOT NULL default '',
  `altContent` text NULL,
  `source` varchar(32) NOT NULL default '',
  `singleSRC` binary(16) NULL,
  `url` varchar(255) NOT NULL default '',
  `interactive` char(1) NOT NULL default '',
  `flashID` varchar(64) NOT NULL default '',
  `flashJS` text NULL,
  `imgSize` varchar(64) NOT NULL default '',
  `useCaption` char(1) NOT NULL default '',
  `fullsize` char(1) NOT NULL default '',
  `multiSRC` blob NULL,
  `orderSRC` blob NULL,
  `html` text NULL,
  `rss_cache` int(10) unsigned NOT NULL default '0',
  `rss_feed` text NULL,
  `rss_template` varchar(64) NOT NULL default '',
  `numberOfItems` smallint(5) unsigned NOT NULL default '0',
  `disableCaptcha` char(1) NOT NULL default '',
  `reg_groups` blob NULL,
  `reg_allowLogin` char(1) NOT NULL default '',
  `reg_skipName` char(1) NOT NULL default '',
  `reg_close` varchar(32) NOT NULL default '',
  `reg_assignDir` char(1) NOT NULL default '',
  `reg_homeDir` binary(16) NULL,
  `reg_activate` char(1) NOT NULL default '',
  `reg_jumpTo` int(10) unsigned NOT NULL default '0',
  `reg_text` text NULL,
  `reg_password` text NULL,
  `protected` char(1) NOT NULL default '',
  `groups` blob NULL,
  `guests` char(1) NOT NULL default '',
  `cssID` varchar(255) NOT NULL default '',
  `space` varchar(64) NOT NULL default '',
  `banner_hideempty` char(1) NOT NULL default '0',
  `banner_firstview` char(1) NOT NULL default '0',
  `banner_categories` varchar(255) NOT NULL default '',
  `banner_template` varchar(32) NOT NULL default '',
  `banner_redirect` varchar(32) NOT NULL default '',
  `banner_useragent` varchar(64) NOT NULL default '',
  `cal_calendar` blob NULL,
  `cal_noSpan` char(1) NOT NULL default '',
  `cal_startDay` smallint(5) unsigned NOT NULL default '1',
  `cal_format` varchar(32) NOT NULL default '',
  `cal_ignoreDynamic` char(1) NOT NULL default '',
  `cal_order` varchar(32) NOT NULL default '',
  `cal_readerModule` int(10) unsigned NOT NULL default '0',
  `cal_limit` smallint(5) unsigned NOT NULL default '0',
  `cal_template` varchar(64) NOT NULL default '',
  `cal_ctemplate` varchar(64) NOT NULL default '',
  `cal_showQuantity` char(1) NOT NULL default '',
  `cal_startDate` varchar(10) NOT NULL default '',
  `cal_endDate` varchar(10) NOT NULL default '',
  `cal_onlyPast` char(1) NOT NULL default '',
  `dlh_googlemap` int(10) unsigned NOT NULL default '0',
  `dlh_googlemap_zoom` int(10) unsigned NOT NULL default '0',
  `dlh_googlemap_size` varchar(255) NOT NULL default '',
  `list_formdata` varchar(64) NOT NULL default '',
  `list_where` varchar(255) NOT NULL default '',
  `list_sort` varchar(255) NOT NULL default '',
  `list_fields` text NULL,
  `efg_list_searchtype` varchar(32) NOT NULL default '',
  `list_search` varchar(255) NOT NULL default '',
  `list_info` text NULL,
  `efg_list_access` varchar(32) NOT NULL default '',
  `efg_fe_edit_access` varchar(32) NOT NULL default '',
  `efg_fe_delete_access` varchar(32) NOT NULL default '',
  `efg_fe_export_access` varchar(32) NOT NULL default '',
  `efg_DetailsKey` varchar(64) NOT NULL default '',
  `efg_iconfolder` varchar(255) NOT NULL default '',
  `efg_fe_keep_id` char(1) NOT NULL default '',
  `efg_fe_no_formatted_mail` char(1) NOT NULL default '',
  `efg_fe_no_confirmation_mail` char(1) NOT NULL default '',
  `efg_com_allow_comments` char(1) NOT NULL default '',
  `efg_com_per_page` smallint(5) unsigned NOT NULL default '0',
  `efg_com_notify` varchar(32) NOT NULL default '',
  `faq_categories` blob NULL,
  `faq_readerModule` int(10) unsigned NOT NULL default '0',
  `glossaries` varchar(255) NOT NULL default '',
  `list_table` varchar(64) NOT NULL default '',
  `list_info_where` varchar(255) NOT NULL default '',
  `list_layout` varchar(64) NOT NULL default '',
  `list_info_layout` varchar(64) NOT NULL default '',
  `ml_groups` blob NULL,
  `ml_fields` blob NULL,
  `news_archives` blob NULL,
  `news_featured` varchar(16) NOT NULL default '',
  `news_jumpToCurrent` varchar(16) NOT NULL default '',
  `news_readerModule` int(10) unsigned NOT NULL default '0',
  `news_metaFields` varchar(255) NOT NULL default '',
  `news_template` varchar(64) NOT NULL default '',
  `news_format` varchar(32) NOT NULL default '',
  `news_startDay` smallint(5) unsigned NOT NULL default '0',
  `news_order` varchar(255) NOT NULL default '',
  `news_showQuantity` char(1) NOT NULL default '',
  `newsletters` blob NULL,
  `nl_channels` blob NULL,
  `nl_hideChannels` char(1) NOT NULL default '',
  `nl_subscribe` text NULL,
  `nl_unsubscribe` text NULL,
  `nl_template` varchar(64) NOT NULL default '',
  `visitors_categories` varchar(255) NOT NULL default '',
  `visitors_template` varchar(32) NOT NULL default '',
  `visitors_useragent` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_page` (
  `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) COLLATE utf8_bin NOT NULL default '',
  `type` varchar(32) NOT NULL default '',
  `pageTitle` varchar(255) NOT NULL default '',
  `language` varchar(5) NOT NULL default '',
  `robots` varchar(32) NOT NULL default '',
  `description` text NULL,
  `redirect` varchar(32) NOT NULL default '',
  `jumpTo` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `target` char(1) NOT NULL default '',
  `dns` varchar(255) NOT NULL default '',
  `staticFiles` varchar(255) NOT NULL default '',
  `staticPlugins` varchar(255) NOT NULL default '',
  `fallback` char(1) NOT NULL default '',
  `adminEmail` varchar(255) NOT NULL default '',
  `dateFormat` varchar(32) NOT NULL default '',
  `timeFormat` varchar(32) NOT NULL default '',
  `datimFormat` varchar(32) NOT NULL default '',
  `createSitemap` char(1) NOT NULL default '',
  `sitemapName` varchar(32) NOT NULL default '',
  `useSSL` char(1) NOT NULL default '',
  `autoforward` char(1) NOT NULL default '',
  `protected` char(1) NOT NULL default '',
  `groups` blob NULL,
  `includeLayout` char(1) NOT NULL default '',
  `layout` int(10) unsigned NOT NULL default '0',
  `mobileLayout` int(10) unsigned NOT NULL default '0',
  `includeCache` char(1) NOT NULL default '',
  `cache` int(10) unsigned NOT NULL default '0',
  `includeChmod` char(1) NOT NULL default '',
  `cuser` int(10) unsigned NOT NULL default '0',
  `cgroup` int(10) unsigned NOT NULL default '0',
  `chmod` varchar(255) NOT NULL default '',
  `noSearch` char(1) NOT NULL default '',
  `cssClass` varchar(64) NOT NULL default '',
  `sitemap` varchar(32) NOT NULL default '',
  `hide` char(1) NOT NULL default '',
  `guests` char(1) NOT NULL default '',
  `tabindex` smallint(5) unsigned NOT NULL default '0',
  `accesskey` char(1) NOT NULL default '',
  `published` char(1) NOT NULL default '',
  `start` varchar(10) NOT NULL default '',
  `stop` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`),
  KEY `pid_type_start_stop_published` (`pid`, `type`, `start`, `stop`, `published`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_search` (
  `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 '',
  `url` varchar(255) NOT NULL default '',
  `text` mediumtext NULL,
  `filesize` double unsigned NOT NULL default '0',
  `checksum` varchar(32) NOT NULL default '',
  `protected` char(1) NOT NULL default '',
  `groups` blob NULL,
  `language` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`),
  UNIQUE KEY `checksum_pid` (`checksum`, `pid`),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_search_index` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `word` varchar(64) COLLATE utf8_bin NOT NULL default '',
  `relevance` smallint(5) unsigned NOT NULL default '0',
  `language` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`),
  KEY `word` (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_session` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `sessionID` varchar(128) NOT NULL default '',
  `hash` varchar(40) NULL,
  `ip` varchar(64) NOT NULL default '',
  `su` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`),
  UNIQUE KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_style` (
  `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',
  `selector` varchar(1022) NOT NULL default '',
  `category` varchar(32) NOT NULL default '',
  `comment` varchar(255) NOT NULL default '',
  `size` char(1) NOT NULL default '',
  `width` varchar(64) NOT NULL default '',
  `height` varchar(64) NOT NULL default '',
  `minwidth` varchar(64) NOT NULL default '',
  `minheight` varchar(64) NOT NULL default '',
  `maxwidth` varchar(64) NOT NULL default '',
  `maxheight` varchar(64) NOT NULL default '',
  `positioning` char(1) NOT NULL default '',
  `trbl` varchar(128) NOT NULL default '',
  `position` varchar(32) NOT NULL default '',
  `floating` varchar(32) NOT NULL default '',
  `clear` varchar(32) NOT NULL default '',
  `overflow` varchar(32) NOT NULL default '',
  `display` varchar(32) NOT NULL default '',
  `alignment` char(1) NOT NULL default '',
  `margin` varchar(128) NOT NULL default '',
  `padding` varchar(128) NOT NULL default '',
  `align` varchar(32) NOT NULL default '',
  `verticalalign` varchar(32) NOT NULL default '',
  `textalign` varchar(32) NOT NULL default '',
  `whitespace` varchar(8) NOT NULL default '',
  `background` char(1) NOT NULL default '',
  `bgcolor` varchar(64) NOT NULL default '',
  `bgimage` varchar(255) NOT NULL default '',
  `bgposition` varchar(32) NOT NULL default '',
  `bgrepeat` varchar(32) NOT NULL default '',
  `shadowsize` varchar(128) NOT NULL default '',
  `shadowcolor` varchar(64) NOT NULL default '',
  `gradientAngle` varchar(32) NOT NULL default '',
  `gradientColors` varchar(128) NOT NULL default '',
  `border` char(1) NOT NULL default '',
  `borderwidth` varchar(128) NOT NULL default '',
  `borderstyle` varchar(32) NOT NULL default '',
  `bordercolor` varchar(64) NOT NULL default '',
  `borderradius` varchar(128) NOT NULL default '',
  `bordercollapse` varchar(32) NOT NULL default '',
  `borderspacing` varchar(64) NOT NULL default '',
  `font` char(1) NOT NULL default '',
  `fontfamily` varchar(255) NOT NULL default '',
  `fontsize` varchar(64) NOT NULL default '',
  `fontcolor` varchar(64) NOT NULL default '',
  `lineheight` varchar(64) NOT NULL default '',
  `fontstyle` varchar(255) NOT NULL default '',
  `texttransform` varchar(32) NOT NULL default '',
  `textindent` varchar(64) NOT NULL default '',
  `letterspacing` varchar(64) NOT NULL default '',
  `wordspacing` varchar(64) NOT NULL default '',
  `list` char(1) NOT NULL default '',
  `liststyletype` varchar(32) NOT NULL default '',
  `liststyleimage` varchar(255) NOT NULL default '',
  `own` text NULL,
  `invisible` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_style_sheet` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(64) NULL,
  `disablePie` char(1) NOT NULL default '',
  `embedImages` int(10) unsigned NOT NULL default '0',
  `cc` varchar(32) NOT NULL default '',
  `media` varchar(255) NOT NULL default '',
  `mediaQuery` text NULL,
  `vars` text NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_theme` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(128) NOT NULL default '',
  `author` varchar(128) NOT NULL default '',
  `folders` blob NULL,
  `screenshot` binary(16) NULL,
  `templates` varchar(255) NOT NULL default '',
  `vars` text NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_undo` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `fromTable` varchar(255) NOT NULL default '',
  `query` text NULL,
  `affectedRows` smallint(5) unsigned NOT NULL default '0',
  `data` mediumblob NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_user` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `username` varchar(64) COLLATE utf8_bin NULL,
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `language` varchar(5) NOT NULL default '',
  `backendTheme` varchar(32) NOT NULL default '',
  `uploader` varchar(32) NOT NULL default '',
  `showHelp` char(1) NOT NULL default '',
  `thumbnails` char(1) NOT NULL default '',
  `useRTE` char(1) NOT NULL default '',
  `useCE` char(1) NOT NULL default '',
  `password` varchar(128) NOT NULL default '',
  `pwChange` char(1) NOT NULL default '',
  `admin` char(1) NOT NULL default '',
  `groups` blob NULL,
  `inherit` varchar(12) NOT NULL default '',
  `modules` blob NULL,
  `themes` blob NULL,
  `pagemounts` blob NULL,
  `alpty` blob NULL,
  `filemounts` blob NULL,
  `fop` blob NULL,
  `forms` blob NULL,
  `formp` blob NULL,
  `disable` char(1) NOT NULL default '',
  `start` varchar(10) NOT NULL default '',
  `stop` varchar(10) NOT NULL default '',
  `session` blob NULL,
  `dateAdded` int(10) unsigned NOT NULL default '0',
  `lastLogin` int(10) unsigned NOT NULL default '0',
  `currentLogin` int(10) unsigned NOT NULL default '0',
  `loginCount` smallint(5) unsigned NOT NULL default '3',
  `locked` int(10) unsigned NOT NULL default '0',
  `calendars` blob NULL,
  `calendarp` blob NULL,
  `calendarfeeds` blob NULL,
  `calendarfeedp` blob NULL,
  `faqs` blob NULL,
  `faqp` blob NULL,
  `news` blob NULL,
  `newp` blob NULL,
  `newsfeeds` blob NULL,
  `newsfeedp` blob NULL,
  `newsletters` blob NULL,
  `newsletterp` blob NULL,
  `quickjump4ward_enabled` char(1) NOT NULL default '1',
  `quickjump4ward` blob NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_user_group` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `modules` blob NULL,
  `themes` blob NULL,
  `pagemounts` blob NULL,
  `alpty` blob NULL,
  `filemounts` blob NULL,
  `fop` blob NULL,
  `forms` blob NULL,
  `formp` blob NULL,
  `alexf` blob NULL,
  `disable` char(1) NOT NULL default '',
  `start` varchar(10) NOT NULL default '',
  `stop` varchar(10) NOT NULL default '',
  `calendars` blob NULL,
  `calendarp` blob NULL,
  `calendarfeeds` blob NULL,
  `calendarfeedp` blob NULL,
  `faqs` blob NULL,
  `faqp` blob NULL,
  `news` blob NULL,
  `newp` blob NULL,
  `newsfeeds` blob NULL,
  `newsfeedp` blob NULL,
  `newsletters` blob NULL,
  `newsletterp` blob NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_version` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `version` smallint(5) unsigned NOT NULL default '1',
  `fromTable` varchar(255) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `username` varchar(64) NULL,
  `description` varchar(255) NOT NULL default '',
  `editUrl` varchar(255) NOT NULL default '',
  `active` char(1) NOT NULL default '',
  `data` mediumblob NULL,
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`),
  KEY `fromTable` (`fromTable`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_banner` (
  `banner_type` varchar(32) NOT NULL default 'banner_image',
  `banner_name` varchar(64) NOT NULL default '',
  `banner_weighting` tinyint(3) unsigned NOT NULL default '2',
  `banner_url` varchar(255) NOT NULL default '',
  `banner_jumpTo` int(10) unsigned NOT NULL default '0',
  `banner_target` char(1) NOT NULL default '',
  `banner_image` varchar(255) NOT NULL default '',
  `banner_image_extern` varchar(255) NOT NULL default '',
  `banner_imgSize` varchar(255) NOT NULL default '',
  `banner_comment` text NOT NULL,
  `banner_published` char(1) NOT NULL default '',
  `banner_start` varchar(10) NOT NULL default '',
  `banner_stop` varchar(10) NOT NULL default '',
  `banner_until` char(1) NOT NULL default '',
  `banner_views_until` varchar(10) NOT NULL default '',
  `banner_clicks_until` varchar(10) NOT NULL default '',
  `banner_domain` varchar(255) NOT NULL default '',
  `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',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_banner_category` (
  `title` varchar(60) NOT NULL default '',
  `banner_template` varchar(32) NOT NULL default '',
  `banner_default` char(1) NOT NULL default '',
  `banner_default_name` varchar(64) NOT NULL default '',
  `banner_default_url` varchar(128) NOT NULL default '',
  `banner_default_image` varchar(255) NOT NULL default '',
  `banner_default_target` char(1) NOT NULL default '',
  `banner_numbers` char(1) NOT NULL default '',
  `banner_random` char(1) NOT NULL default '',
  `banner_limit` int(10) unsigned NOT NULL default '0',
  `banner_protected` char(1) NOT NULL default '',
  `banner_groups` varchar(255) NOT NULL default '',
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
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 '',
  `groups` blob NULL,
  `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 '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
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) COLLATE utf8_bin NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `addTime` char(1) NOT NULL default '',
  `startTime` int(10) unsigned NULL,
  `endTime` int(10) unsigned NULL,
  `startDate` int(10) unsigned NULL,
  `endDate` int(10) unsigned NULL,
  `location` varchar(255) NOT NULL default '',
  `teaser` text NULL,
  `addImage` char(1) NOT NULL default '',
  `singleSRC` binary(16) 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 '',
  `enclosure` blob NULL,
  `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 '',
  `dw_keywords` text NULL,
  `dw_description` text NULL,
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`),
  KEY `pid_start_stop_published` (`pid`, `start`, `stop`, `published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
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) COLLATE utf8_bin NOT NULL default '',
  `language` varchar(32) NOT NULL default '',
  `calendars` blob NULL,
  `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 '',
  `description` text NULL,
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
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 '',
  `comment` text NULL,
  `addReply` char(1) NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `reply` text NULL,
  `published` char(1) NOT NULL default '',
  `ip` varchar(64) NOT NULL default '',
  `notified` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `published` (`published`),
  KEY `source_parent_published` (`source`, `parent`, `published`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
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 '',
  PRIMARY KEY  (`id`),
  KEY `tokenRemove` (`tokenRemove`),
  KEY `source_parent_tokenConfirm` (`source`, `parent`, `tokenConfirm`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
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 '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_dlh_googlemaps` (
  `title` varchar(255) NOT NULL default '',
  `center` varchar(64) NOT NULL default '',
  `geocoderAddress` varchar(255) NOT NULL default '',
  `geocoderCountry` varchar(2) NOT NULL default '1',
  `mapSize` varchar(255) NOT NULL default '',
  `zoom` int(10) unsigned NOT NULL default '0',
  `mapTypeId` varchar(16) NOT NULL default '',
  `mapTypesAvailable` varchar(255) NOT NULL default '',
  `staticMapNoscript` char(1) NOT NULL default '1',
  `sensor` char(1) NOT NULL default '1',
  `useMapTypeControl` char(1) NOT NULL default '1',
  `mapTypeControlStyle` varchar(16) NOT NULL default '',
  `mapTypeControlPos` varchar(16) NOT NULL default '',
  `useNavigationControl` char(1) NOT NULL default '1',
  `navigationControlStyle` varchar(16) NOT NULL default '',
  `navigationControlPos` varchar(16) NOT NULL default '',
  `streetViewControl` char(1) NOT NULL default '1',
  `disableDoubleClickZoom` char(1) NOT NULL default '1',
  `scrollwheel` char(1) NOT NULL default '1',
  `draggable` char(1) NOT NULL default '1',
  `useScaleControl` char(1) NOT NULL default '1',
  `scaleControlPos` varchar(16) NOT NULL default '',
  `parameter` text NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_dlh_googlemaps_elements` (
  `title` varchar(255) NOT NULL default '',
  `type` varchar(32) NOT NULL default '',
  `singleCoords` varchar(64) NOT NULL default '',
  `markerType` varchar(32) NOT NULL default '',
  `markerAction` varchar(255) NOT NULL default '',
  `multiCoords` blob NULL,
  `markerShowTitle` char(1) NOT NULL default '',
  `overlaySRC` varchar(255) NOT NULL default '',
  `iconSRC` varchar(255) NOT NULL default '',
  `iconSize` varchar(255) NOT NULL default '',
  `iconAnchor` varchar(255) NOT NULL default '',
  `hasShadow` char(1) NOT NULL default '',
  `shadowSRC` varchar(255) NOT NULL default '',
  `shadowSize` varchar(255) NOT NULL default '',
  `strokeColor` varchar(6) NOT NULL default '',
  `strokeOpacity` varchar(255) NOT NULL default '',
  `strokeWeight` varchar(64) NOT NULL default '',
  `fillColor` varchar(6) NOT NULL default '',
  `fillOpacity` varchar(255) NOT NULL default '',
  `radius` varchar(64) NOT NULL default '',
  `bounds` varchar(255) NOT NULL default '',
  `zIndex` int(10) unsigned NOT NULL default '0',
  `popupInfoWindow` char(1) NOT NULL default '',
  `useRouting` char(1) NOT NULL default '',
  `routingAddress` varchar(255) NOT NULL default '',
  `infoWindow` text NULL,
  `infoWindowAnchor` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `target` char(1) NOT NULL default '',
  `linkTitle` varchar(255) NOT NULL default '',
  `parameter` text NULL,
  `published` char(1) NOT NULL default '',
  `sorting` int(10) unsigned NOT NULL default '0',
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_formdata` (
  `form` varchar(64) NOT NULL default '',
  `date` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `fd_member` int(10) unsigned NOT NULL default '0',
  `fd_user` int(10) unsigned NOT NULL default '0',
  `fd_member_group` int(10) unsigned NOT NULL default '0',
  `fd_user_group` int(10) unsigned NOT NULL default '0',
  `published` char(1) NOT NULL default '',
  `alias` varchar(64) NOT NULL default '',
  `confirmationSent` char(1) NOT NULL default '',
  `confirmationDate` varchar(10) NOT NULL default '',
  `be_notes` text NULL,
  `id` int(10) unsigned NOT NULL auto_increment,
  `sorting` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `form` (`form`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_formdata_details` (
  `value` text NULL,
  `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',
  `ff_id` int(10) unsigned NOT NULL default '0',
  `ff_type` varchar(32) NOT NULL default '',
  `ff_name` varchar(64) NOT NULL default '',
  `ff_label` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`),
  KEY `ff_name` (`ff_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE 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) COLLATE utf8_bin NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `answer` text NULL,
  `addImage` char(1) NOT NULL default '',
  `singleSRC` binary(16) 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 '',
  `enclosure` blob NULL,
  `noComments` char(1) NOT NULL default '',
  `published` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid_published_sorting` (`pid`, `published`, `sorting`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
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 '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_glossary` (
  `title` varchar(255) NOT NULL default '',
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_glossary_term` (
  `term` varchar(64) NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `definition` text NULL,
  `addImage` char(1) NOT NULL default '',
  `singleSRC` varchar(255) NOT NULL default '',
  `alt` varchar(255) NOT NULL default '',
  `size` varchar(64) NOT NULL default '',
  `imagemargin` varchar(255) NOT NULL default '',
  `caption` varchar(255) NOT NULL default '',
  `floating` varchar(32) NOT NULL default '',
  `fullsize` char(1) NOT NULL default '',
  `addEnclosure` char(1) NOT NULL default '',
  `enclosure` varchar(255) NOT NULL default '',
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_news` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `headline` varchar(255) NOT NULL default '',
  `alias` varchar(128) COLLATE utf8_bin NOT NULL default '',
  `author` int(10) unsigned NOT NULL default '0',
  `date` int(10) unsigned NOT NULL default '0',
  `time` int(10) unsigned NOT NULL default '0',
  `subheadline` varchar(255) NOT NULL default '',
  `teaser` text NULL,
  `addImage` char(1) NOT NULL default '',
  `singleSRC` binary(16) 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 '',
  `enclosure` blob NULL,
  `source` varchar(12) 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 '',
  `featured` char(1) NOT NULL default '',
  `published` char(1) NOT NULL default '',
  `start` varchar(10) NOT NULL default '',
  `stop` varchar(10) NOT NULL default '',
  `addGallery` char(1) NOT NULL default '',
  `gal_headline` varchar(255) NOT NULL default '',
  `multiSRC` blob NULL,
  `perRow` smallint(5) unsigned NOT NULL default '0',
  `sortBy` varchar(32) NOT NULL default '',
  `gal_imagemargin` varchar(255) NOT NULL default '',
  `gal_size` varchar(255) NOT NULL default '',
  `gal_fullsize` char(1) NOT NULL default '',
  `dw_keywords` text NULL,
  `dw_description` text NULL,
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`),
  KEY `pid_start_stop_published` (`pid`, `start`, `stop`, `published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_news_archive` (
  `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 '',
  `groups` blob NULL,
  `allowComments` char(1) NOT NULL default '',
  `notify` varchar(16) 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 '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_news_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) COLLATE utf8_bin NOT NULL default '',
  `language` varchar(32) NOT NULL default '',
  `archives` blob NULL,
  `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 '',
  `description` text NULL,
  PRIMARY KEY  (`id`),
  KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_newsletter` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `subject` varchar(255) NOT NULL default '',
  `alias` varchar(128) COLLATE utf8_bin NOT NULL default '',
  `content` mediumtext NULL,
  `text` mediumtext NULL,
  `addFile` char(1) NOT NULL default '',
  `files` blob NULL,
  `template` varchar(64) NOT NULL default '',
  `sendText` char(1) NOT NULL default '',
  `externalImages` char(1) NOT NULL default '',
  `sender` varchar(128) NOT NULL default '',
  `senderName` varchar(128) NOT NULL default '',
  `sent` char(1) NOT NULL default '',
  `date` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_newsletter_channel` (
  `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',
  `useSMTP` char(1) NOT NULL default '',
  `smtpHost` varchar(64) NOT NULL default '',
  `smtpUser` varchar(128) NOT NULL default '',
  `smtpPass` varchar(32) NOT NULL default '',
  `smtpEnc` varchar(3) NOT NULL default '',
  `smtpPort` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_newsletter_recipients` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `active` char(1) NOT NULL default '',
  `addedOn` varchar(10) NOT NULL default '',
  `confirmed` varchar(10) NOT NULL default '',
  `ip` varchar(64) NOT NULL default '',
  `token` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`),
  KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_repository_installs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  `extension` varchar(32) NOT NULL default '',
  `version` int(9) NOT NULL default '0',
  `build` int(9) NOT NULL default '0',
  `alpha` char(1) NOT NULL default '',
  `beta` char(1) NOT NULL default '',
  `rc` char(1) NOT NULL default '',
  `stable` char(1) NOT NULL default '1',
  `lickey` varchar(255) NOT NULL default '',
  `delprot` char(1) NOT NULL default '',
  `updprot` char(1) NOT NULL default '',
  `error` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_repository_instfiles` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `pid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `filename` varchar(255) NOT NULL default '',
  `filetype` char(1) NOT NULL default 'F',
  `flag` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
	
CREATE TABLE `tl_social_bookmarks` (
  `name` varchar(64) NOT NULL default '',
  `icon` varchar(64) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `style` varchar(255) NOT NULL default '',
  `cssID` varchar(255) NOT NULL default '',
  `published` char(1) NOT NULL default '',
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_summarizeFeeds` (
  `resource` varchar(8) NOT NULL default '',
  `newsArchives` blob NULL,
  `calendar` blob NULL,
  `title` varchar(255) NOT NULL default '',
  `alias` varbinary(128) NOT NULL default '',
  `description` text NULL,
  `source` varchar(6) NOT NULL default '',
  `letters` int(10) unsigned NOT NULL default '0',
  `maxItems` smallint(5) unsigned NOT NULL default '0',
  `language` varchar(32) NOT NULL default '',
  `format` varchar(4) NOT NULL default '',
  `feedBase` varchar(255) NOT NULL default '',
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_visitors` (
  `visitors_name` varchar(64) NOT NULL default '',
  `visitors_startdate` varchar(10) NOT NULL default '',
  `visitors_visit_start` int(10) unsigned NOT NULL default '0',
  `visitors_hit_start` int(10) unsigned NOT NULL default '0',
  `visitors_average` char(1) NOT NULL default '',
  `visitors_block_time` int(10) unsigned NOT NULL default '1800',
  `visitors_thousands_separator` char(1) NOT NULL default '',
  `published` char(1) NOT NULL default '',
  `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',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_visitors_category` (
  `title` varchar(60) NOT NULL default '',
  `visitors_template` varchar(32) NOT NULL default '',
  `visitors_cache_mode` tinyint(3) unsigned NOT NULL default '1',
  `id` int(10) unsigned NOT NULL auto_increment,
  `tstamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_banner_stat` (
  `id` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `banner_views` int(10) unsigned NOT NULL default '0',
  `banner_clicks` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_banner_blocker` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `bid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `ip` varchar(40) NOT NULL default '0.0.0.0',
  `type` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_banner_random_blocker` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `bid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `ip` varchar(40) NOT NULL default '0.0.0.0',
  PRIMARY KEY  (`id`),
  KEY `bid` (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_visitors_counter` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `visitors_date` date NOT NULL default '1999-01-01',
  `visitors_visit` int(10) unsigned NOT NULL default '0',
  `visitors_hit` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_visitors_blocker` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `visitors_tstamp` timestamp NULL default NULL,
  `visitors_ip` varchar(40) NOT NULL default '0.0.0.0',
  `visitors_type` char(1) NOT NULL default 'v',
  PRIMARY KEY  (`id`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_visitors_browser` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `visitors_browser` varchar(60) NOT NULL default 'Unknown',
  `visitors_os` varchar(60) NOT NULL default 'Unknown',
  `visitors_lang` varchar(10) NOT NULL default 'Unknown',
  `visitors_counter` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_visitors_searchengines` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `visitors_searchengine` varchar(60) NOT NULL default 'Unknown',
  `visitors_keywords` varchar(255) NOT NULL default 'Unknown',
  PRIMARY KEY  (`id`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	
CREATE TABLE `tl_visitors_referrer` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `vid` int(10) unsigned NOT NULL default '0',
  `tstamp` int(10) unsigned NOT NULL default '0',
  `visitors_referrer_dns` varchar(255) NOT NULL default '-',
  `visitors_referrer_full` text NULL,
  PRIMARY KEY  (`id`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

**vfl63langerwehe** · 19.03.2018, 06:27

und wenn ich dann auf den Button Datenbank aktualisieren klicke, erscheint:

ALTER TABLE `tl_visitors_blocker` CHANGE `visitors_tstamp` `visitors_tstamp` timestamp NULL default NULL;

Daraufhin komme ich auch nicht mehr bei dem Backend rein

Anmeldung fehlgeschlagen (Benutzernamen und Passwörter unterscheiden zwischen Groß- und Kleinschreibung)!

Hierfür hatte ich eigentlich nichts geändert.

**Samson1964** · 19.03.2018, 06:36

Ich musste mit Tapatalk erstmal 100 mal wischen. Pack doch deinen Code das nächste Mal in Code-Tags.
War das nicht ein Update? Warum war die Datenbank dann leer?

Gesendet von meinem L52 mit Tapatalk

**vfl63langerwehe** · 19.03.2018, 06:51

Hallo Frank,

ich kann dir das nicht sagen, ich habe die Website mit allem Drum und Dran von dem Vorgänger übernommen. Dieser will mir nun nicht helfen und ich kenne ich mit Datenbanken, HTML, PHP etc nicht aus.

VG

**Spooky** · 19.03.2018, 07:45

Überprüfe deine Serverumgebung und die Contao Installation mit dem Contao Check.

**mlweb** · 19.03.2018, 07:45

Und hast Du ein Backup vor allem von der Datenbank?

**mlweb** · 19.03.2018, 07:49

Ich habe mir gerade mal alles durchgeklickt. Keine weisse Seite, sondern die Wartungsseite. Sieht erst einmal alles nicht kritisch aus.
Falls Du kein Update der DB hast. Hol Dir sicherheitshalber eine von Deinem Provider. Die Provider die ich kenne haben so etwas, speichern aber immer nur mehr oder weniger lange.

**vfl63langerwehe** · 19.03.2018, 07:58

Während der Installation wurde ein Backup gemacht. Ich finde jeden Falls auf dem FTP Server im Ordner Backup eine Datei mit Datum von gestern.

**jk1** · 19.03.2018, 08:48

Das er dir die ganzen Tabellen zum erstellen angeboten hat, sagt aus, dass die vorher angegebene Datenbank leer war. D.h. irgendwas oder irgendjemand hat die Datenbankinhalte gelöscht.
Contao macht das aber nicht. Vielleicht wurde vorher doch eine andere Datenbank genutzt? Dein Hoster gibt dir sicherlich die Möglichkeit über phpMyAdmin in die Datenbanken zu schauen. Du könntest damit in die zweite Datenbank schauen. Wenn du dort auf der linken Seite mehrere Tabellen hast, die mit dem Namen "tl_" beginnen, wird das zu Contao gehören. In dem Fall könntest du nochmal die Install ausführen & die alternativen Datenbankdaten eingeben.

Wenn nicht, musst du nun erstmal in dein neues Contao reinkommen, wo aber alles leer sein wird. Also keine Seitenstruktur, kein Layout, kein Modul, etc.
Den Benutzer musst du dann auch im Install-Tool anlegen (letzter Schritt).
Irgendeine Ahnung, womit das Backup gemacht wurde? Wie heißt die Datei?

**vfl63langerwehe** · 19.03.2018, 16:27

Also, wenn ich mich bei phpmyadmin Einloge sehe ich für eine Datenbank folgendes
Bildschirmfoto 2018-03-19 um 17.23.52.png

auf dem FTP Server finde ich unter Backup die Datei mysql-2.11.3.sql mit Datum Gestern 18:11Uhr.

Wie soll ich fortfahren ?

**jk1** · 19.03.2018, 17:23

Also, relevant sind nur alle Tabellen die mit tl_ beginnen. Die anderen kommen von woanders.
Da die Tabellen ja mit dem Install-Tool angelegt wurden, sollten diese hauptsächlich leer sein.

In deinem Baum, den du gescreenshotet hast, hast du ganz oben (nicht im Screenshot sichtbar) den Datenbanknamen stehen. Das müsste "kweb31_2" sein, bzw. dass, was du im Install-Tool eingetragen hattest. Schau nochmal nach, ob das übereinstimmt. Wenn ja, dann klickst du in phpMyAdmin auf diesen Datenbank-Namen. Du solltest im Hauptfenster nun nochmal alle Tabellen sehen. Vor diesen Namen ist eine Checkbox. Markiere alle, die mit "tl_" beginnen. Die anderen die mit "cms_" beginnen, wählst du nicht aus.

Ganz unten siehst du ein Drop-Down "markierte:", wo du die Aktion der ausgewählten Tabellen bestimmen kannst.
phpmyadmin-tabellen-loeschen.PNG

Wähle dort löschen aus & bestätige den Vorgang.
Anschließend sollten nur noch deine Tabellen zu sehen sein, die mit cms_ beginnen.
Lade dein mysql Backup auf deinen Rechner runter.

Gehe in phpMyadmin im Hauptfenster ganz oben auf "Importieren".
phpmyadmin-importieren.PNG

Wähle dort dann bei dem Feld "Datei auswählen" deine Backup-Datei aus. Im Dropdown "Format" sollte "SQL" bereits vorausgewählt sein.
Klicke dann auf "OK", warte ab & hoffe auf keinen Fehler.
Anschließend solltest du dich mit deinen alten Contao-Daten wieder ins CMS einloggen können.

Wenn Fehlermeldungen kommen, solltest du alle Erweiterungen über FTP deaktivieren & es danach nochmal probieren.
Erstelle dazu in den jeweiligen Erweiterungs-Verzeichnissen unter system/modules/ eine Datei mit dem Namen ".skip" (ohne Anführungszeichen).
Also zum Beispiel in den Ordner system/modules/banner

Danach schauen wir weiter!