[TASK] Add more tests to site resolving
[Packages/TYPO3.CMS.git] / typo3 / sysext / frontend / ext_tables.sql
1 #
2 # Table structure for table 'cache_treelist'
3 #
4 CREATE TABLE cache_treelist (
5 md5hash char(32) DEFAULT '' NOT NULL,
6 pid int(11) DEFAULT '0' NOT NULL,
7 treelist mediumtext,
8 tstamp int(11) DEFAULT '0' NOT NULL,
9 expires int(11) unsigned DEFAULT '0' NOT NULL,
10
11 PRIMARY KEY (md5hash)
12 ) ENGINE=InnoDB;
13
14 #
15 # Table structure for table 'fe_groups'
16 #
17 CREATE TABLE fe_groups (
18 title varchar(50) DEFAULT '' NOT NULL,
19 lockToDomain varchar(50) DEFAULT '' NOT NULL,
20 subgroup tinytext,
21 TSconfig text
22 );
23
24
25 #
26 # Table structure for table 'fe_sessions'
27 #
28 CREATE TABLE fe_sessions (
29 ses_id varchar(32) DEFAULT '' NOT NULL,
30 ses_iplock varchar(39) DEFAULT '' NOT NULL,
31 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
32 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
33 ses_data mediumblob,
34 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
35 ses_anonymous tinyint(1) unsigned DEFAULT '0' NOT NULL,
36
37 PRIMARY KEY (ses_id),
38 KEY ses_tstamp (ses_tstamp)
39 ) ENGINE=InnoDB;
40
41 #
42 # Table structure for table 'fe_users'
43 #
44 CREATE TABLE fe_users (
45 username varchar(255) DEFAULT '' NOT NULL,
46 password varchar(100) DEFAULT '' NOT NULL,
47 usergroup tinytext,
48 name varchar(160) DEFAULT '' NOT NULL,
49 first_name varchar(50) DEFAULT '' NOT NULL,
50 middle_name varchar(50) DEFAULT '' NOT NULL,
51 last_name varchar(50) DEFAULT '' NOT NULL,
52 address varchar(255) DEFAULT '' NOT NULL,
53 telephone varchar(30) DEFAULT '' NOT NULL,
54 fax varchar(30) DEFAULT '' NOT NULL,
55 email varchar(255) DEFAULT '' NOT NULL,
56 lockToDomain varchar(50) DEFAULT '' NOT NULL,
57 uc blob,
58 title varchar(40) DEFAULT '' NOT NULL,
59 zip varchar(10) DEFAULT '' NOT NULL,
60 city varchar(50) DEFAULT '' NOT NULL,
61 country varchar(40) DEFAULT '' NOT NULL,
62 www varchar(80) DEFAULT '' NOT NULL,
63 company varchar(80) DEFAULT '' NOT NULL,
64 image tinytext,
65 TSconfig text,
66 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
67 is_online int(10) unsigned DEFAULT '0' NOT NULL,
68
69 KEY parent (pid,username),
70 KEY username (username),
71 KEY is_online (is_online)
72 );
73
74 #
75 # Table structure for table 'pages_language_overlay'
76 # Kept with all management fields like uid and pid for b/w compat reasons.
77 # Table will be removed in v10 with removal of unifiedPageTranslationHandling feature toggle
78 #
79 CREATE TABLE pages_language_overlay (
80 uid int(11) NOT NULL auto_increment,
81 pid int(11) DEFAULT '0' NOT NULL,
82 doktype int(11) unsigned DEFAULT '0' NOT NULL,
83 t3ver_oid int(11) DEFAULT '0' NOT NULL,
84 t3ver_id int(11) DEFAULT '0' NOT NULL,
85 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
86 t3ver_label varchar(255) DEFAULT '' NOT NULL,
87 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
88 t3ver_stage int(11) DEFAULT '0' NOT NULL,
89 t3ver_count int(11) DEFAULT '0' NOT NULL,
90 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
91 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
92 t3_origuid int(11) DEFAULT '0' NOT NULL,
93 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
94 crdate int(11) unsigned DEFAULT '0' NOT NULL,
95 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
96 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
97 title varchar(255) DEFAULT '' NOT NULL,
98 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
99 starttime int(11) unsigned DEFAULT '0' NOT NULL,
100 endtime int(11) unsigned DEFAULT '0' NOT NULL,
101 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
102 subtitle varchar(255) DEFAULT '' NOT NULL,
103 nav_title varchar(255) DEFAULT '' NOT NULL,
104 media int(11) unsigned DEFAULT '0' NOT NULL,
105 keywords text,
106 description text,
107 abstract text,
108 author varchar(255) DEFAULT '' NOT NULL,
109 author_email varchar(255) DEFAULT '' NOT NULL,
110 l18n_diffsource mediumblob,
111 url varchar(255) DEFAULT '' NOT NULL,
112 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
113 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
114
115 PRIMARY KEY (uid),
116 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
117 KEY parent (pid,sys_language_uid)
118 );
119
120 #
121 # Table structure for table 'sys_domain'
122 #
123 CREATE TABLE sys_domain (
124 domainName varchar(255) DEFAULT '' NOT NULL,
125
126 KEY getSysDomain (hidden),
127 KEY getDomainStartPage (pid,hidden,domainName)
128 );
129
130 #
131 # Table structure for table 'sys_template'
132 #
133 CREATE TABLE sys_template (
134 title varchar(255) DEFAULT '' NOT NULL,
135 sitetitle varchar(255) DEFAULT '' NOT NULL,
136 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
137 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
138 include_static_file text,
139 constants text,
140 config text,
141 nextLevel varchar(5) DEFAULT '' NOT NULL,
142 basedOn tinytext,
143 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
144 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
145
146 KEY roottemplate (deleted,hidden,root)
147 );
148
149 #
150 # Table structure for table 'tt_content'
151 #
152 CREATE TABLE tt_content (
153 CType varchar(255) DEFAULT '' NOT NULL,
154 header varchar(255) DEFAULT '' NOT NULL,
155 header_position varchar(6) DEFAULT '' NOT NULL,
156 rowDescription text,
157 bodytext mediumtext,
158 bullets_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
159 uploads_description tinyint(1) unsigned DEFAULT '0' NOT NULL,
160 uploads_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
161 assets int(11) unsigned DEFAULT '0' NOT NULL,
162 image int(11) unsigned DEFAULT '0' NOT NULL,
163 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
164 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
165 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
166 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
167 media int(11) unsigned DEFAULT '0' NOT NULL,
168 layout int(11) unsigned DEFAULT '0' NOT NULL,
169 frame_class varchar(60) DEFAULT 'default' NOT NULL,
170 cols int(11) unsigned DEFAULT '0' NOT NULL,
171 spaceBefore smallint(5) unsigned DEFAULT '0' NOT NULL,
172 spaceAfter smallint(5) unsigned DEFAULT '0' NOT NULL,
173 space_before_class varchar(60) DEFAULT '' NOT NULL,
174 space_after_class varchar(60) DEFAULT '' NOT NULL,
175 records text,
176 pages text,
177 colPos int(11) unsigned DEFAULT '0' NOT NULL,
178 subheader varchar(255) DEFAULT '' NOT NULL,
179 header_link varchar(1024) DEFAULT '' NOT NULL,
180 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
181 header_layout varchar(30) DEFAULT '0' NOT NULL,
182 list_type varchar(255) DEFAULT '' NOT NULL,
183 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
184 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
185 file_collections text,
186 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
187 filelink_sorting varchar(17) DEFAULT '' NOT NULL,
188 filelink_sorting_direction varchar(4) DEFAULT '' NOT NULL,
189 target varchar(30) DEFAULT '' NOT NULL,
190 date int(10) unsigned DEFAULT '0' NOT NULL,
191 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
192 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
193 pi_flexform mediumtext,
194 accessibility_title varchar(30) DEFAULT '' NOT NULL,
195 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
196 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
197 selected_categories text,
198 category_field varchar(64) DEFAULT '' NOT NULL,
199 table_class varchar(60) DEFAULT '' NOT NULL,
200 table_caption varchar(255) DEFAULT NULL,
201 table_delimiter smallint(6) unsigned DEFAULT '0' NOT NULL,
202 table_enclosure smallint(6) unsigned DEFAULT '0' NOT NULL,
203 table_header_position tinyint(3) unsigned DEFAULT '0' NOT NULL,
204 table_tfoot tinyint(1) unsigned DEFAULT '0' NOT NULL,
205
206 KEY parent (pid,sorting),
207 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
208 KEY language (l18n_parent,sys_language_uid)
209 );
210
211 #
212 # Table structure for table 'backend_layout'
213 #
214 CREATE TABLE backend_layout (
215 title varchar(255) DEFAULT '' NOT NULL,
216 config text NOT NULL,
217 icon text
218 );