das wäre die hier:
PHP-Code:
CREATE TABLE `tl_article` (
`id` int(10) UNSIGNED NOT NULL,
`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 '',
`keywords` text,
`showTeaser` char(1) NOT NULL DEFAULT '',
`teaserCssID` varchar(255) NOT NULL DEFAULT '',
`teaser` text,
`printable` varchar(255) NOT NULL DEFAULT '',
`customTpl` varchar(64) NOT NULL DEFAULT '',
`protected` char(1) NOT NULL DEFAULT '',
`groups` blob,
`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 '',
`tags` char(1) NOT NULL DEFAULT '',
`tags_showtags` char(1) NOT NULL DEFAULT '',
`tags_max_tags` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`tags_relevance` char(1) NOT NULL DEFAULT '',
`tags_jumpto` smallint(5) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Lesezeichen