enables to have specific HTTP status codes on a sys_domain record when doing a redire...
[Packages/TYPO3.CMS.git] / typo3 / sysext / cms / ext_tables.sql
1 #
2 # TYPO3 SVN ID: $Id$
3 #
4
5
6 #
7 # Table structure for table 'cache_pages'
8 #
9 CREATE TABLE cache_pages (
10 id int(11) unsigned NOT NULL auto_increment,
11 hash varchar(32) DEFAULT '' NOT NULL,
12 page_id int(11) unsigned DEFAULT '0' NOT NULL,
13 reg1 int(11) unsigned DEFAULT '0' NOT NULL,
14 HTML mediumtext,
15 temp_content int(1) DEFAULT '0' NOT NULL,
16 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
17 expires int(10) unsigned DEFAULT '0' NOT NULL,
18 cache_data mediumblob,
19 KEY page_id (page_id),
20 KEY sel (hash,page_id),
21 PRIMARY KEY (id)
22 ) ENGINE=InnoDB;
23
24
25 #
26 # Table structure for table 'cache_pagesection'
27 #
28 CREATE TABLE cache_pagesection (
29 page_id int(11) unsigned DEFAULT '0' NOT NULL,
30 mpvar_hash int(11) unsigned DEFAULT '0' NOT NULL,
31 content blob,
32 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
33 PRIMARY KEY (page_id,mpvar_hash)
34 ) ENGINE=InnoDB;
35
36
37 #
38 # Table structure for table 'cache_typo3temp_log'
39 #
40 CREATE TABLE cache_typo3temp_log (
41 md5hash varchar(32) DEFAULT '' NOT NULL,
42 tstamp int(11) DEFAULT '0' NOT NULL,
43 filename varchar(255) DEFAULT '' NOT NULL,
44 orig_filename varchar(255) DEFAULT '' NOT NULL,
45 PRIMARY KEY (md5hash)
46 ) ENGINE=InnoDB;
47
48
49 #
50 # Table structure for table 'cache_md5params'
51 #
52 CREATE TABLE cache_md5params (
53 md5hash varchar(20) DEFAULT '' NOT NULL,
54 tstamp int(11) DEFAULT '0' NOT NULL,
55 type tinyint(3) DEFAULT '0' NOT NULL,
56 params text,
57 PRIMARY KEY (md5hash)
58 ) ENGINE=InnoDB;
59
60
61 #
62 # Table structure for table 'cache_imagesizes'
63 #
64 CREATE TABLE cache_imagesizes (
65 md5hash varchar(32) DEFAULT '' NOT NULL,
66 md5filename varchar(32) DEFAULT '' NOT NULL,
67 tstamp int(11) DEFAULT '0' NOT NULL,
68 filename varchar(255) DEFAULT '' NOT NULL,
69 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
70 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
71 PRIMARY KEY (md5filename)
72 ) ENGINE=InnoDB;
73
74
75 #
76 # Table structure for table 'cache_treelist'
77 #
78 CREATE TABLE cache_treelist (
79 md5hash char(32) DEFAULT '' NOT NULL,
80 pid int(11) DEFAULT '0' NOT NULL,
81 treelist text NOT NULL,
82 tstamp int(11) DEFAULT '0' NOT NULL,
83 expires int(11) unsigned DEFAULT '0' NOT NULL,
84 PRIMARY KEY (md5hash)
85 ) ENGINE=InnoDB;
86
87
88 #
89 # Table structure for table 'fe_groups'
90 #
91 CREATE TABLE fe_groups (
92 uid int(11) unsigned NOT NULL auto_increment,
93 pid int(11) unsigned DEFAULT '0' NOT NULL,
94 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
95 crdate int(11) unsigned DEFAULT '0' NOT NULL,
96 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
97 title varchar(50) DEFAULT '' NOT NULL,
98 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
99 lockToDomain varchar(50) DEFAULT '' NOT NULL,
100 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
101 description text,
102 subgroup tinytext,
103 TSconfig text,
104 PRIMARY KEY (uid),
105 KEY parent (pid)
106 );
107
108
109 #
110 # Table structure for table 'fe_session_data'
111 #
112 CREATE TABLE fe_session_data (
113 hash varchar(32) DEFAULT '' NOT NULL,
114 content mediumblob,
115 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
116 PRIMARY KEY (hash)
117 ) ENGINE=InnoDB;
118
119
120 #
121 # Table structure for table 'fe_sessions'
122 #
123 CREATE TABLE fe_sessions (
124 ses_id varchar(32) DEFAULT '' NOT NULL,
125 ses_name varchar(32) DEFAULT '' NOT NULL,
126 ses_iplock varchar(39) DEFAULT '' NOT NULL,
127 ses_hashlock int(11) DEFAULT '0' NOT NULL,
128 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
129 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
130 ses_data blob,
131 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
132 PRIMARY KEY (ses_id,ses_name)
133 ) ENGINE=InnoDB;
134
135
136 #
137 # Table structure for table 'fe_users'
138 #
139 CREATE TABLE fe_users (
140 uid int(11) unsigned NOT NULL auto_increment,
141 pid int(11) unsigned DEFAULT '0' NOT NULL,
142 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
143 username varchar(50) DEFAULT '' NOT NULL,
144 password varchar(40) DEFAULT '' NOT NULL,
145 usergroup tinytext,
146 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
147 starttime int(11) unsigned DEFAULT '0' NOT NULL,
148 endtime int(11) unsigned DEFAULT '0' NOT NULL,
149 name varchar(80) DEFAULT '' NOT NULL,
150 address varchar(255) DEFAULT '' NOT NULL,
151 telephone varchar(20) DEFAULT '' NOT NULL,
152 fax varchar(20) DEFAULT '' NOT NULL,
153 email varchar(80) DEFAULT '' NOT NULL,
154 crdate int(11) unsigned DEFAULT '0' NOT NULL,
155 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
156 lockToDomain varchar(50) DEFAULT '' NOT NULL,
157 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
158 uc blob,
159 title varchar(40) DEFAULT '' NOT NULL,
160 zip varchar(10) DEFAULT '' NOT NULL,
161 city varchar(50) DEFAULT '' NOT NULL,
162 country varchar(40) DEFAULT '' NOT NULL,
163 www varchar(80) DEFAULT '' NOT NULL,
164 company varchar(80) DEFAULT '' NOT NULL,
165 image tinytext,
166 TSconfig text,
167 fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
168 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
169 is_online int(10) unsigned DEFAULT '0' NOT NULL,
170 PRIMARY KEY (uid),
171 KEY parent (pid,username),
172 KEY username (username),
173 KEY is_online (is_online)
174 );
175
176
177 #
178 # Table structure for table 'pages_language_overlay'
179 #
180 CREATE TABLE pages_language_overlay (
181 uid int(11) NOT NULL auto_increment,
182 pid int(11) DEFAULT '0' NOT NULL,
183 t3ver_oid int(11) DEFAULT '0' NOT NULL,
184 t3ver_id int(11) DEFAULT '0' NOT NULL,
185 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
186 t3ver_label varchar(30) DEFAULT '' NOT NULL,
187 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
188 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
189 t3ver_count int(11) DEFAULT '0' NOT NULL,
190 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
191 t3_origuid int(11) DEFAULT '0' NOT NULL,
192 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
193 crdate int(11) unsigned DEFAULT '0' NOT NULL,
194 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
195 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
196 title varchar(255) DEFAULT '' NOT NULL,
197 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
198 starttime int(11) unsigned DEFAULT '0' NOT NULL,
199 endtime int(11) unsigned DEFAULT '0' NOT NULL,
200 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
201 subtitle varchar(255) DEFAULT '' NOT NULL,
202 nav_title varchar(255) DEFAULT '' NOT NULL,
203 media tinytext,
204 keywords text,
205 description text,
206 abstract text,
207 author varchar(255) DEFAULT '' NOT NULL,
208 author_email varchar(80) DEFAULT '' NOT NULL,
209 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
210 l18n_diffsource mediumblob,
211
212 PRIMARY KEY (uid),
213 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
214 KEY parent (pid,sys_language_uid)
215 );
216
217
218 #
219 # Table structure for table 'static_template'
220 #
221 CREATE TABLE static_template (
222 uid int(11) unsigned NOT NULL auto_increment,
223 pid int(11) unsigned DEFAULT '0' NOT NULL,
224 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
225 crdate int(11) unsigned DEFAULT '0' NOT NULL,
226 title varchar(255) DEFAULT '' NOT NULL,
227 include_static tinytext,
228 constants text,
229 config text,
230 editorcfg text,
231 description text,
232 PRIMARY KEY (uid),
233 KEY parent (pid)
234 );
235
236
237 #
238 # Table structure for table 'sys_domain'
239 #
240 CREATE TABLE sys_domain (
241 uid int(11) unsigned NOT NULL auto_increment,
242 pid int(11) unsigned DEFAULT '0' NOT NULL,
243 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
244 crdate int(11) unsigned DEFAULT '0' NOT NULL,
245 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
246 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
247 domainName varchar(80) DEFAULT '' NOT NULL,
248 redirectTo varchar(120) DEFAULT '' NOT NULL,
249 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
250 sorting int(10) unsigned DEFAULT '0' NOT NULL,
251 prepend_params int(10) DEFAULT '0' NOT NULL,
252
253 PRIMARY KEY (uid),
254 KEY parent (pid)
255 );
256
257
258
259 #
260 # Table structure for table 'sys_template'
261 #
262 CREATE TABLE sys_template (
263 uid int(11) NOT NULL auto_increment,
264 pid int(11) DEFAULT '0' NOT NULL,
265 t3ver_oid int(11) DEFAULT '0' NOT NULL,
266 t3ver_id int(11) DEFAULT '0' NOT NULL,
267 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
268 t3ver_label varchar(30) DEFAULT '' NOT NULL,
269 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
270 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
271 t3ver_count int(11) DEFAULT '0' NOT NULL,
272 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
273 t3_origuid int(11) DEFAULT '0' NOT NULL,
274 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
275 sorting int(11) unsigned DEFAULT '0' NOT NULL,
276 crdate int(11) unsigned DEFAULT '0' NOT NULL,
277 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
278 title varchar(255) DEFAULT '' NOT NULL,
279 sitetitle varchar(255) DEFAULT '' NOT NULL,
280 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
281 starttime int(11) unsigned DEFAULT '0' NOT NULL,
282 endtime int(11) unsigned DEFAULT '0' NOT NULL,
283 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
284 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
285 include_static tinytext,
286 include_static_file text,
287 constants text,
288 config text,
289 editorcfg text,
290 resources text,
291 nextLevel varchar(5) DEFAULT '' NOT NULL,
292 description text,
293 basedOn tinytext,
294 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
295 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
296 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
297 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
298 PRIMARY KEY (uid),
299 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
300 KEY parent (pid,sorting,deleted,hidden)
301 );
302
303
304 #
305 # Table structure for table 'tt_content'
306 #
307 CREATE TABLE tt_content (
308 uid int(11) NOT NULL auto_increment,
309 pid int(11) DEFAULT '0' NOT NULL,
310 t3ver_oid int(11) DEFAULT '0' NOT NULL,
311 t3ver_id int(11) DEFAULT '0' NOT NULL,
312 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
313 t3ver_label varchar(30) DEFAULT '' NOT NULL,
314 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
315 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
316 t3ver_count int(11) DEFAULT '0' NOT NULL,
317 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
318 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
319 t3_origuid int(11) DEFAULT '0' NOT NULL,
320 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
321 crdate int(11) unsigned DEFAULT '0' NOT NULL,
322 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
323 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
324 sorting int(11) unsigned DEFAULT '0' NOT NULL,
325 CType varchar(30) DEFAULT '' NOT NULL,
326 header varchar(255) DEFAULT '' NOT NULL,
327 header_position varchar(6) DEFAULT '' NOT NULL,
328 bodytext mediumtext,
329 image text,
330 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
331 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
332 imagecaption text,
333 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
334 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
335 media text,
336 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
337 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
338 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
339 records text,
340 pages tinytext,
341 starttime int(11) unsigned DEFAULT '0' NOT NULL,
342 endtime int(11) unsigned DEFAULT '0' NOT NULL,
343 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
344 subheader varchar(255) DEFAULT '' NOT NULL,
345 spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
346 spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
347 fe_group varchar(100) DEFAULT '0' NOT NULL,
348 header_link varchar(255) DEFAULT '' NOT NULL,
349 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
350 image_link varchar(255) DEFAULT '' NOT NULL,
351 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
352 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
353 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
354 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
355 altText text,
356 titleText text,
357 longdescURL text,
358 header_layout varchar(30) DEFAULT '0' NOT NULL,
359 text_align varchar(6) DEFAULT '' NOT NULL,
360 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
361 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
362 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
363 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
364 menu_type varchar(30) DEFAULT '0' NOT NULL,
365 list_type varchar(36) DEFAULT '0' NOT NULL,
366 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
367 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
368 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
369 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
370 select_key varchar(80) DEFAULT '' NOT NULL,
371 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
372 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
373 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
374 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
375 date int(10) unsigned DEFAULT '0' NOT NULL,
376 splash_layout varchar(30) DEFAULT '0' NOT NULL,
377 multimedia tinytext,
378 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
379 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
380 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
381 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
382 sys_language_uid int(11) DEFAULT '0' NOT NULL,
383 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
384 pi_flexform mediumtext,
385 l18n_parent int(11) DEFAULT '0' NOT NULL,
386 l18n_diffsource mediumblob,
387
388 PRIMARY KEY (uid),
389 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
390 KEY parent (pid,sorting)
391 );
392
393
394 #
395 # Table structure for table 'pages'
396 #
397 CREATE TABLE pages (
398 url varchar(255) DEFAULT '' NOT NULL,
399 starttime int(11) unsigned DEFAULT '0' NOT NULL,
400 endtime int(11) unsigned DEFAULT '0' NOT NULL,
401 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
402 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
403 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
404 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
405 fe_group varchar(100) DEFAULT '0' NOT NULL,
406 subtitle varchar(255) DEFAULT '' NOT NULL,
407 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
408 target varchar(20) DEFAULT '' NOT NULL,
409 media text,
410 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
411 keywords text,
412 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
413 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
414 description text,
415 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
416 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
417 abstract text,
418 module varchar(10) DEFAULT '' NOT NULL,
419 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
420 author varchar(255) DEFAULT '' NOT NULL,
421 author_email varchar(80) DEFAULT '' NOT NULL,
422 nav_title varchar(255) DEFAULT '' NOT NULL,
423 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
424 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
425 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
426 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
427 alias varchar(32) DEFAULT '' NOT NULL,
428 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
429 fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
430 KEY alias (alias)
431 );