Zitat von
do_while
Hier ein Auszug aus der Datenbank-Definition bei Contao 2.9.0:
Code:
CREATE TABLE `tl_member` (
`id` int(10) unsigned NOT NULL auto_increment,
`tstamp` int(10) unsigned NOT NULL default '0',
:
`currentLogin` int(10) unsigned NOT NULL default '0',
`lastLogin` int(10) unsigned NOT NULL default '0',
`autologin` varchar(32) NULL default NULL,
`createdOn` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `username` (`username`),
UNIQUE KEY `autologin` (`autologin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
In dieser Core-Datei wird autologin genutzt und als UNIQUE KEY angelegt.
Wie sieht diese Tabelle in Deinem phpMyAdmin aus?
Ich habe jetzt die database.sql nach erneutem Update auf 2.9.0 durchsucht.
In 2 Tabellen taucht `autologin` auf.
Code:
--
-- Table `tl_member`
--
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(2) NOT NULL default '',
`groups` blob NULL,
`login` char(1) NOT NULL default '',
`username` varchar(64) NOT NULL default '',
`password` varchar(64) NOT NULL default '',
`assignDir` char(1) NOT NULL default '',
`homeDir` varchar(255) NOT NULL default '',
`disable` char(1) NOT NULL default '',
`start` varchar(10) NOT NULL default '',
`stop` varchar(10) NOT NULL default '',
`loginCount` smallint(5) unsigned NOT NULL default '3',
`locked` int(10) unsigned NOT NULL default '0',
`session` blob NULL,
`dateAdded` int(10) unsigned NOT NULL default '0',
`currentLogin` int(10) unsigned NOT NULL default '0',
`lastLogin` int(10) unsigned NOT NULL default '0',
`autologin` varchar(32) NULL default NULL,
`createdOn` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `username` (`username`),
UNIQUE KEY `autologin` (`autologin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Code:
--
-- Table `tl_module`
--
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 '',
`pages` blob NULL,
`includeRoot` char(1) NOT NULL default '',
`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',
`searchType` 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',
`queryType` 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` varchar(255) NOT NULL default '',
`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,
`html` 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 '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;