1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
CREATE TABLE `tl_content` (
`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',
`type` varchar(32) NOT NULL default '',
`invisible` char(1) NOT NULL default '',
`headline` varchar(255) NOT NULL default '',
`text` text NULL,
`html` text NULL,
`code` text NULL,
`highlight` varchar(32) NOT NULL default '',
`addImage` char(1) NOT NULL default '',
`useImage` char(1) NOT NULL default '',
`singleSRC` varchar(255) NOT NULL default '',
`multiSRC` blob NULL,
`useHomeDir` char(1) NOT NULL default '',
`sortBy` varchar(32) NOT NULL default '',
`size` varchar(255) NOT NULL default '',
`alt` varchar(255) NOT NULL default '',
`caption` varchar(255) NOT NULL default '',
`floating` varchar(32) NOT NULL default '',
`imagemargin` varchar(255) NOT NULL default '',
`fullsize` char(1) NOT NULL default '',
`perRow` smallint(5) unsigned NOT NULL default '0',
`listtype` varchar(32) NOT NULL default '',
`listitems` blob NULL,
`tableitems` blob NULL,
`summary` varchar(255) NOT NULL default '',
`thead` char(1) NOT NULL default '',
`tfoot` 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 '',
`url` varchar(255) NOT NULL default '',
`imageUrl` varchar(255) NOT NULL default '',
`linkTitle` varchar(255) NOT NULL default '',
`embed` varchar(255) NOT NULL default '',
`target` char(1) NOT NULL default '',
`mooType` varchar(32) NOT NULL default '',
`mooHeadline` varchar(255) NOT NULL default '',
`mooStyle` varchar(255) NOT NULL default '',
`mooClasses` varchar(255) NOT NULL default '',
`perPage` smallint(5) unsigned NOT NULL default '0',
`cteAlias` smallint(5) unsigned NOT NULL default '0',
`articleAlias` smallint(5) unsigned NOT NULL default '0',
`article` int(10) unsigned NOT NULL default '0',
`form` smallint(5) unsigned NOT NULL default '0',
`module` smallint(5) unsigned NOT NULL default '0',
`protected` char(1) NOT NULL default '',
`guests` char(1) NOT NULL default '',
`groups` blob NULL,
`space` varchar(255) NOT NULL default '',
`align` varchar(32) NOT NULL default '',
`cssID` varchar(255) NOT NULL default '',
`com_template` varchar(32) NOT NULL default '',
`com_perPage` smallint(5) unsigned NOT NULL default '0',
`com_order` varchar(32) NOT NULL default '',
`com_moderate` char(1) NOT NULL default '',
`com_bbcode` char(1) NOT NULL default '',
`com_disableCaptcha` char(1) NOT NULL default '',
`dfTitle` varchar(64) NOT NULL default '',
`dfSize` varchar(255) NOT NULL default '',
`dfInterval` smallint(5) unsigned NOT NULL default '7',
`dfTemplate` varchar(32) NOT NULL default '',
`dfPause` char(1) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `pid` (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|