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