Bekomme folgendes Ergebnis:
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) COLLATE utf8_bin NOT NULL DEFAULT '',
`alias` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
`author` int(10) unsigned NOT NULL DEFAULT '0',
`inColumn` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
`keywords` text COLLATE utf8_bin,
`showTeaser` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`teaser` text COLLATE utf8_bin,
`printable` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`cssID` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`space` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`published` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`start` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`stop` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`teaser_image` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`teaser_image_alt` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`teaser_image_size` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`teaserCssID` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`tags` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`tags_showtags` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`tags_max_tags` smallint(5) unsigned NOT NULL DEFAULT '0',
`tags_relevance` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`tags_jumpto` smallint(5) unsigned NOT NULL DEFAULT '0',
`protected` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`groups` blob,
`guests` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`languageMain` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `pid` (`pid`),
KEY `alias` (`alias`)
) ENGINE=MyISAM AUTO_INCREMENT=2324 DEFAULT CHARSET=utf8 COLLATE=utf8_bin
Lesezeichen