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