[BUGFIX] Correct handling of empty Backend Layouts
[Packages/TYPO3.CMS.git] / typo3 / sysext / core / ext_tables.sql
1 #
2
3 #
4 # Table structure for table 'be_groups'
5 #
6 CREATE TABLE be_groups (
7 uid int(11) unsigned NOT NULL auto_increment,
8 pid int(11) unsigned DEFAULT '0' NOT NULL,
9 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
10 title varchar(50) DEFAULT '' NOT NULL,
11 non_exclude_fields text,
12 explicit_allowdeny text,
13 allowed_languages varchar(255) DEFAULT '' NOT NULL,
14 custom_options text,
15 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
16 pagetypes_select varchar(255) DEFAULT '' NOT NULL,
17 tables_select text,
18 tables_modify text,
19 crdate int(11) unsigned DEFAULT '0' NOT NULL,
20 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
21 groupMods text,
22 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
23 file_permissions text,
24 hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
25 inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
26 description text,
27 lockToDomain varchar(50) DEFAULT '' NOT NULL,
28 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
29 TSconfig text,
30 subgroup text,
31 hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
32 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
33 category_perms varchar(255) DEFAULT '' NOT NULL,
34 PRIMARY KEY (uid),
35 KEY parent (pid)
36 );
37
38 #
39 # Table structure for table 'be_sessions'
40 #
41 CREATE TABLE be_sessions (
42 ses_id varchar(32) DEFAULT '' NOT NULL,
43 ses_name varchar(32) DEFAULT '' NOT NULL,
44 ses_iplock varchar(39) DEFAULT '' NOT NULL,
45 ses_hashlock int(11) DEFAULT '0' NOT NULL,
46 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
47 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
48 ses_data longtext,
49 ses_backuserid int(11) NOT NULL default '0',
50 PRIMARY KEY (ses_id,ses_name),
51 KEY ses_tstamp (ses_tstamp)
52 );
53
54 #
55 # Table structure for table 'be_users'
56 #
57 CREATE TABLE be_users (
58 uid int(11) unsigned NOT NULL auto_increment,
59 pid int(11) unsigned DEFAULT '0' NOT NULL,
60 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
61 username varchar(50) DEFAULT '' NOT NULL,
62 password varchar(100) DEFAULT '' NOT NULL,
63 admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
64 usergroup varchar(255) DEFAULT '' NOT NULL,
65 disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
66 starttime int(11) unsigned DEFAULT '0' NOT NULL,
67 endtime int(11) unsigned DEFAULT '0' NOT NULL,
68 lang char(2) DEFAULT '' NOT NULL,
69 email varchar(80) DEFAULT '' NOT NULL,
70 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
71 options tinyint(4) unsigned DEFAULT '0' NOT NULL,
72 crdate int(11) unsigned DEFAULT '0' NOT NULL,
73 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
74 realName varchar(80) DEFAULT '' NOT NULL,
75 userMods text,
76 allowed_languages varchar(255) DEFAULT '' NOT NULL,
77 uc mediumtext,
78 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
79 file_permissions text,
80 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
81 lockToDomain varchar(50) DEFAULT '' NOT NULL,
82 disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
83 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
84 TSconfig text,
85 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
86 createdByAction int(11) DEFAULT '0' NOT NULL,
87 usergroup_cached_list text,
88 workspace_id int(11) DEFAULT '0' NOT NULL,
89 workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
90 category_perms varchar(255) DEFAULT '' NOT NULL,
91 PRIMARY KEY (uid),
92 KEY parent (pid),
93 KEY username (username)
94 );
95
96 #
97 # Table structure for table 'cache_imagesizes'
98 #
99 CREATE TABLE cache_imagesizes (
100 md5hash varchar(32) DEFAULT '' NOT NULL,
101 md5filename varchar(32) DEFAULT '' NOT NULL,
102 tstamp int(11) DEFAULT '0' NOT NULL,
103 filename varchar(255) DEFAULT '' NOT NULL,
104 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
105 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
106 PRIMARY KEY (md5filename)
107 ) ENGINE=InnoDB;
108
109 #
110 # Table structure for table 'pages'
111 #
112 CREATE TABLE pages (
113 uid int(11) NOT NULL auto_increment,
114 pid int(11) DEFAULT '0' NOT NULL,
115 t3ver_oid int(11) DEFAULT '0' NOT NULL,
116 t3ver_id int(11) DEFAULT '0' NOT NULL,
117 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
118 t3ver_label varchar(255) DEFAULT '' NOT NULL,
119 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
120 t3ver_stage int(11) DEFAULT '0' NOT NULL,
121 t3ver_count int(11) DEFAULT '0' NOT NULL,
122 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
123 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
124 t3_origuid int(11) DEFAULT '0' NOT NULL,
125 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
126 sorting int(11) unsigned DEFAULT '0' NOT NULL,
127 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
128 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
129 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
130 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
131 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
132 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
133 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
134 crdate int(11) unsigned DEFAULT '0' NOT NULL,
135 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
136 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
137 title varchar(255) DEFAULT '' NOT NULL,
138 doktype int(11) unsigned DEFAULT '0' NOT NULL,
139 TSconfig text,
140 storage_pid int(11) DEFAULT '0' NOT NULL,
141 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
142 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
143 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
144 url varchar(255) DEFAULT '' NOT NULL,
145 starttime int(11) unsigned DEFAULT '0' NOT NULL,
146 endtime int(11) unsigned DEFAULT '0' NOT NULL,
147 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
148 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
149 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
150 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
151 fe_group varchar(100) DEFAULT '0' NOT NULL,
152 subtitle varchar(255) DEFAULT '' NOT NULL,
153 layout int(11) unsigned DEFAULT '0' NOT NULL,
154 url_scheme tinyint(3) unsigned DEFAULT '0' NOT NULL,
155 target varchar(80) DEFAULT '' NOT NULL,
156 media text,
157 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
158 keywords text,
159 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
160 cache_tags varchar(255) DEFAULT '' NOT NULL,
161 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
162 description text,
163 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
164 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
165 abstract text,
166 module varchar(10) DEFAULT '' NOT NULL,
167 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
168 author varchar(255) DEFAULT '' NOT NULL,
169 author_email varchar(80) DEFAULT '' NOT NULL,
170 nav_title varchar(255) DEFAULT '' NOT NULL,
171 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
172 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
173 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
174 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
175 alias varchar(32) DEFAULT '' NOT NULL,
176 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
177 fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
178 backend_layout varchar(64) DEFAULT '' NOT NULL,
179 backend_layout_next_level varchar(64) DEFAULT '' NOT NULL,
180 PRIMARY KEY (uid),
181 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
182 KEY parent (pid,deleted,sorting),
183 KEY alias (alias)
184 );
185
186 #
187 # Table structure for table 'sys_registry'
188 #
189 CREATE TABLE sys_registry (
190 uid int(11) unsigned NOT NULL auto_increment,
191 entry_namespace varchar(128) DEFAULT '' NOT NULL,
192 entry_key varchar(128) DEFAULT '' NOT NULL,
193 entry_value blob,
194 PRIMARY KEY (uid),
195 UNIQUE KEY entry_identifier (entry_namespace,entry_key)
196 );
197
198 #
199 # Table structure for table 'sys_be_shortcuts'
200 #
201 CREATE TABLE sys_be_shortcuts (
202 uid int(11) unsigned NOT NULL auto_increment,
203 userid int(11) unsigned DEFAULT '0' NOT NULL,
204 module_name varchar(255) DEFAULT '' NOT NULL,
205 url text,
206 description varchar(255) DEFAULT '' NOT NULL,
207 sorting int(11) DEFAULT '0' NOT NULL,
208 sc_group tinyint(4) DEFAULT '0' NOT NULL,
209 PRIMARY KEY (uid),
210 KEY event (userid)
211 );
212
213
214 #
215 # Table structure for table 'sys_news'
216 #
217 CREATE TABLE sys_news (
218 uid int(11) unsigned NOT NULL auto_increment,
219 pid int(11) unsigned DEFAULT '0' NOT NULL,
220 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
221 crdate int(11) unsigned DEFAULT '0' NOT NULL,
222 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
223 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
224 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
225 starttime int(11) unsigned DEFAULT '0' NOT NULL,
226 endtime int(11) unsigned DEFAULT '0' NOT NULL,
227 title varchar(255) DEFAULT '' NOT NULL,
228 content mediumtext,
229
230 PRIMARY KEY (uid),
231 KEY parent (pid)
232 );
233
234
235 #
236 # Table structure for table 'sys_filemounts'
237 #
238 CREATE TABLE sys_filemounts (
239 uid int(11) unsigned NOT NULL auto_increment,
240 pid int(11) unsigned DEFAULT '0' NOT NULL,
241 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
242 title varchar(30) DEFAULT '' NOT NULL,
243 path varchar(120) DEFAULT '' NOT NULL,
244 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
245 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
246 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
247 sorting int(11) unsigned DEFAULT '0' NOT NULL,
248 PRIMARY KEY (uid),
249 KEY parent (pid)
250 );
251
252
253 #
254 # Table structure for table 'sys_file_storage'
255 #
256 CREATE TABLE sys_file_storage (
257 uid int(11) NOT NULL auto_increment,
258 pid int(11) DEFAULT '0' NOT NULL,
259 tstamp int(11) DEFAULT '0' NOT NULL,
260 crdate int(11) DEFAULT '0' NOT NULL,
261 cruser_id int(11) DEFAULT '0' NOT NULL,
262 deleted tinyint(4) DEFAULT '0' NOT NULL,
263 hidden tinyint(4) DEFAULT '0' NOT NULL,
264
265 name varchar(30) DEFAULT '' NOT NULL,
266 description text,
267 driver tinytext,
268 configuration text,
269 is_browsable tinyint(4) DEFAULT '0' NOT NULL,
270 is_public tinyint(4) DEFAULT '0' NOT NULL,
271 is_writable tinyint(4) DEFAULT '0' NOT NULL,
272 is_online tinyint(4) DEFAULT '1' NOT NULL,
273 processingfolder tinytext,
274
275 PRIMARY KEY (uid),
276 KEY parent (pid,deleted),
277 KEY deleted_hidden (deleted,hidden)
278 );
279
280 #
281 # Table structure for table 'sys_file'
282 #
283 CREATE TABLE sys_file (
284 uid int(11) NOT NULL auto_increment,
285 pid int(11) DEFAULT '0' NOT NULL,
286 # update timestamp of the database record, not the file!
287 tstamp int(11) DEFAULT '0' NOT NULL,
288 last_indexed int(11) DEFAULT '0' NOT NULL,
289
290 # management information
291 missing tinyint(4) DEFAULT '0' NOT NULL,
292 storage int(11) DEFAULT '0' NOT NULL,
293 type varchar(10) DEFAULT '' NOT NULL,
294 metadata int(11) DEFAULT '0' NOT NULL,
295
296 # file info data
297 identifier text,
298 identifier_hash varchar(40) DEFAULT '' NOT NULL,
299 folder_hash varchar(40) DEFAULT '' NOT NULL,
300 extension varchar(255) DEFAULT '' NOT NULL,
301 mime_type varchar(255) DEFAULT '' NOT NULL,
302 name tinytext,
303 sha1 tinytext,
304 size int(11) DEFAULT '0' NOT NULL,
305 creation_date int(11) DEFAULT '0' NOT NULL,
306 modification_date int(11) DEFAULT '0' NOT NULL,
307
308 PRIMARY KEY (uid),
309 KEY sel01 (storage,identifier_hash),
310 KEY folder (storage,folder_hash),
311 KEY tstamp (tstamp),
312 KEY lastindex (last_indexed),
313 KEY sha1 (sha1(40))
314 );
315
316 #
317 # Table structure for table 'sys_file_metadata'
318 #
319 CREATE TABLE sys_file_metadata (
320 uid int(11) NOT NULL auto_increment,
321 pid int(11) DEFAULT '0' NOT NULL,
322 tstamp int(11) DEFAULT '0' NOT NULL,
323 crdate int(11) DEFAULT '0' NOT NULL,
324 cruser_id int(11) DEFAULT '0' NOT NULL,
325
326 # Language fields
327 sys_language_uid int(11) DEFAULT '0' NOT NULL,
328 l10n_parent int(11) DEFAULT '0' NOT NULL,
329 l10n_diffsource mediumblob NOT NULL,
330
331 # Versioning fields
332 t3ver_oid int(11) DEFAULT '0' NOT NULL,
333 t3ver_id int(11) DEFAULT '0' NOT NULL,
334 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
335 t3ver_label varchar(30) DEFAULT '' NOT NULL,
336 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
337 t3ver_stage int(11) DEFAULT '0' NOT NULL,
338 t3ver_count int(11) DEFAULT '0' NOT NULL,
339 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
340 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
341 t3_origuid int(11) DEFAULT '0' NOT NULL,
342
343 file int(11) DEFAULT '0' NOT NULL,
344 title tinytext,
345 width int(11) DEFAULT '0' NOT NULL,
346 height int(11) DEFAULT '0' NOT NULL,
347 description text,
348 alternative text,
349
350 PRIMARY KEY (uid),
351 KEY file (file),
352 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
353 KEY fal_filelist (l10n_parent,sys_language_uid),
354 );
355
356
357 #
358 # Table structure for table 'sys_file_processedfile'.
359 # which is a "temporary" file, like an image preview
360 # This table does not have a TCA representation, as it is only written
361 # to using direct SQL queries in the code
362 #
363 CREATE TABLE sys_file_processedfile (
364 uid int(11) NOT NULL auto_increment,
365 tstamp int(11) DEFAULT '0' NOT NULL,
366 crdate int(11) DEFAULT '0' NOT NULL,
367
368 storage int(11) DEFAULT '0' NOT NULL,
369 original int(11) DEFAULT '0' NOT NULL,
370 identifier varchar(512) DEFAULT '' NOT NULL,
371 name tinytext,
372 configuration text,
373 configurationsha1 varchar(40) DEFAULT '' NOT NULL,
374 originalfilesha1 varchar(40) DEFAULT '' NOT NULL,
375 task_type varchar(200) DEFAULT '' NOT NULL,
376 checksum varchar(255) DEFAULT '' NOT NULL,
377 width int(11) DEFAULT '0',
378 height int(11) DEFAULT '0',
379
380 PRIMARY KEY (uid),
381 KEY combined_1 (original,task_type,configurationsha1)
382 );
383
384 #
385 # Table structure for table 'sys_file_reference'
386 # which is one usage of a file with overloaded metadata
387 #
388 CREATE TABLE sys_file_reference (
389 uid int(11) NOT NULL auto_increment,
390 pid int(11) DEFAULT '0' NOT NULL,
391 tstamp int(11) DEFAULT '0' NOT NULL,
392 crdate int(11) DEFAULT '0' NOT NULL,
393 cruser_id int(11) DEFAULT '0' NOT NULL,
394 sorting int(10) DEFAULT '0' NOT NULL,
395 deleted tinyint(4) DEFAULT '0' NOT NULL,
396 hidden tinyint(4) DEFAULT '0' NOT NULL,
397
398 # Versioning fields
399 t3ver_oid int(11) DEFAULT '0' NOT NULL,
400 t3ver_id int(11) DEFAULT '0' NOT NULL,
401 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
402 t3ver_label varchar(30) DEFAULT '' NOT NULL,
403 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
404 t3ver_stage int(11) DEFAULT '0' NOT NULL,
405 t3ver_count int(11) DEFAULT '0' NOT NULL,
406 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
407 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
408 t3_origuid int(11) DEFAULT '0' NOT NULL,
409
410 # Language fields
411 sys_language_uid int(11) DEFAULT '0' NOT NULL,
412 l10n_parent int(11) DEFAULT '0' NOT NULL,
413 l10n_diffsource mediumblob NOT NULL,
414
415 # Reference fields (basically same as MM table)
416 uid_local int(11) DEFAULT '0' NOT NULL,
417 uid_foreign int(11) DEFAULT '0' NOT NULL,
418 tablenames varchar(64) DEFAULT '' NOT NULL,
419 fieldname varchar(64) DEFAULT '' NOT NULL,
420 sorting_foreign int(11) DEFAULT '0' NOT NULL,
421 table_local varchar(64) DEFAULT '' NOT NULL,
422
423 # Local usage overlay fields
424 title tinytext,
425 description text,
426 alternative tinytext,
427 link tinytext,
428 downloadname tinytext,
429
430 PRIMARY KEY (uid),
431 KEY parent (pid,deleted),
432 KEY tablenames_fieldname (tablenames(32),fieldname(12)),
433 KEY deleted (deleted),
434 KEY uid_foreign (uid_foreign)
435 );
436
437
438 #
439 # Table structure for table 'sys_file_collection'
440 #
441 CREATE TABLE sys_file_collection (
442 uid int(11) NOT NULL auto_increment,
443 pid int(11) DEFAULT '0' NOT NULL,
444 tstamp int(11) DEFAULT '0' NOT NULL,
445 crdate int(11) DEFAULT '0' NOT NULL,
446 cruser_id int(11) DEFAULT '0' NOT NULL,
447 t3ver_oid int(11) DEFAULT '0' NOT NULL,
448 t3ver_id int(11) DEFAULT '0' NOT NULL,
449 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
450 t3ver_label varchar(30) DEFAULT '' NOT NULL,
451 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
452 t3ver_stage int(11) DEFAULT '0' NOT NULL,
453 t3ver_count int(11) DEFAULT '0' NOT NULL,
454 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
455 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
456 t3_origuid int(11) DEFAULT '0' NOT NULL,
457 sys_language_uid int(11) DEFAULT '0' NOT NULL,
458 l10n_parent int(11) DEFAULT '0' NOT NULL,
459 l10n_diffsource mediumtext,
460 deleted tinyint(4) DEFAULT '0' NOT NULL,
461 hidden tinyint(4) DEFAULT '0' NOT NULL,
462 starttime int(11) DEFAULT '0' NOT NULL,
463 endtime int(11) DEFAULT '0' NOT NULL,
464
465 # Actual fields
466 title tinytext,
467 description text,
468 type varchar(30) DEFAULT 'static' NOT NULL,
469
470 # for type=static
471 files int(11) DEFAULT '0' NOT NULL,
472
473 # for type=folder:
474 storage int(11) DEFAULT '0' NOT NULL,
475 folder text NOT NULL,
476
477 # for type=category:
478 category int(11) DEFAULT '0' NOT NULL,
479
480 PRIMARY KEY (uid),
481 KEY parent (pid,deleted),
482 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
483 );
484
485 #
486 # Table structure for table 'sys_collection'
487 #
488 CREATE TABLE sys_collection (
489 uid int(11) NOT NULL auto_increment,
490 pid int(11) DEFAULT '0' NOT NULL,
491 tstamp int(11) DEFAULT '0' NOT NULL,
492 crdate int(11) DEFAULT '0' NOT NULL,
493 cruser_id int(11) DEFAULT '0' NOT NULL,
494 t3ver_oid int(11) DEFAULT '0' NOT NULL,
495 t3ver_id int(11) DEFAULT '0' NOT NULL,
496 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
497 t3ver_label varchar(30) DEFAULT '' NOT NULL,
498 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
499 t3ver_stage int(11) DEFAULT '0' NOT NULL,
500 t3ver_count int(11) DEFAULT '0' NOT NULL,
501 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
502 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
503 t3_origuid int(11) DEFAULT '0' NOT NULL,
504 sys_language_uid int(11) DEFAULT '0' NOT NULL,
505 l10n_parent int(11) DEFAULT '0' NOT NULL,
506 l10n_diffsource mediumtext,
507 deleted tinyint(4) DEFAULT '0' NOT NULL,
508 hidden tinyint(4) DEFAULT '0' NOT NULL,
509 starttime int(11) DEFAULT '0' NOT NULL,
510 endtime int(11) DEFAULT '0' NOT NULL,
511 fe_group int(11) DEFAULT '0' NOT NULL,
512
513 title tinytext,
514 description text,
515 type varchar(32) DEFAULT 'static' NOT NULL,
516 table_name tinytext,
517 items int(11) DEFAULT '0' NOT NULL,
518
519 PRIMARY KEY (uid),
520 KEY parent (pid,deleted),
521 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
522 );
523
524 #
525 # Table structure for table 'sys_collection_entries'
526 #
527 CREATE TABLE sys_collection_entries (
528 uid int(11) NOT NULL auto_increment,
529 uid_local int(11) DEFAULT '0' NOT NULL,
530 uid_foreign int(11) DEFAULT '0' NOT NULL,
531 tablenames varchar(30) DEFAULT '' NOT NULL,
532 sorting int(11) DEFAULT '0' NOT NULL,
533
534 KEY uid_local (uid_local),
535 KEY uid_foreign (uid_foreign),
536 PRIMARY KEY (uid)
537 );
538
539 #
540 # Table structure for table 'sys_history'
541 #
542 CREATE TABLE sys_history (
543 uid int(11) unsigned NOT NULL auto_increment,
544 pid int(11) unsigned DEFAULT '0' NOT NULL,
545 sys_log_uid int(11) DEFAULT '0' NOT NULL,
546 history_data mediumtext,
547 fieldlist text,
548 recuid int(11) DEFAULT '0' NOT NULL,
549 tablename varchar(255) DEFAULT '' NOT NULL,
550 tstamp int(11) DEFAULT '0' NOT NULL,
551 history_files mediumtext,
552 snapshot int(11) DEFAULT '0' NOT NULL,
553 PRIMARY KEY (uid),
554 KEY parent (pid),
555 KEY recordident_1 (tablename,recuid),
556 KEY recordident_2 (tablename,tstamp),
557 KEY sys_log_uid (sys_log_uid)
558 ) ENGINE=InnoDB;
559
560 #
561 # Table structure for table 'sys_lockedrecords'
562 #
563 CREATE TABLE sys_lockedrecords (
564 uid int(11) unsigned NOT NULL auto_increment,
565 userid int(11) unsigned DEFAULT '0' NOT NULL,
566 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
567 record_table varchar(255) DEFAULT '' NOT NULL,
568 record_uid int(11) DEFAULT '0' NOT NULL,
569 record_pid int(11) DEFAULT '0' NOT NULL,
570 username varchar(50) DEFAULT '' NOT NULL,
571 feuserid int(11) unsigned DEFAULT '0' NOT NULL,
572 PRIMARY KEY (uid),
573 KEY event (userid,tstamp)
574 );
575
576 #
577 # Table structure for table 'sys_refindex'
578 #
579 CREATE TABLE sys_refindex (
580 hash varchar(32) DEFAULT '' NOT NULL,
581 tablename varchar(255) DEFAULT '' NOT NULL,
582 recuid int(11) DEFAULT '0' NOT NULL,
583 field varchar(40) DEFAULT '' NOT NULL,
584 flexpointer varchar(255) DEFAULT '' NOT NULL,
585 softref_key varchar(30) DEFAULT '' NOT NULL,
586 softref_id varchar(40) DEFAULT '' NOT NULL,
587 sorting int(11) DEFAULT '0' NOT NULL,
588 deleted tinyint(1) DEFAULT '0' NOT NULL,
589 ref_table varchar(255) DEFAULT '' NOT NULL,
590 ref_uid int(11) DEFAULT '0' NOT NULL,
591 ref_string varchar(200) DEFAULT '' NOT NULL,
592
593 PRIMARY KEY (hash),
594 KEY lookup_rec (tablename,recuid),
595 KEY lookup_uid (ref_table,ref_uid),
596 KEY lookup_string (ref_string)
597 );
598
599 #
600 # Table structure for table 'sys_log'
601 #
602 CREATE TABLE sys_log (
603 uid int(11) unsigned NOT NULL auto_increment,
604 pid int(11) unsigned DEFAULT '0' NOT NULL,
605 userid int(11) unsigned DEFAULT '0' NOT NULL,
606 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
607 recuid int(11) unsigned DEFAULT '0' NOT NULL,
608 tablename varchar(255) DEFAULT '' NOT NULL,
609 recpid int(11) DEFAULT '0' NOT NULL,
610 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
611 details text NOT NULL,
612 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
613 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
614 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
615 IP varchar(39) DEFAULT '' NOT NULL,
616 log_data text,
617 event_pid int(11) DEFAULT '-1' NOT NULL,
618 workspace int(11) DEFAULT '0' NOT NULL,
619 NEWid varchar(20) DEFAULT '' NOT NULL,
620 request_id varchar(13) DEFAULT '' NOT NULL,
621 time_micro float DEFAULT '0' NOT NULL,
622 component varchar(255) DEFAULT '' NOT NULL,
623 level tinyint(1) unsigned DEFAULT '0' NOT NULL,
624 message text,
625 data text,
626 PRIMARY KEY (uid),
627 KEY parent (pid),
628 KEY event (userid,event_pid),
629 KEY recuidIdx (recuid,uid),
630 KEY user_auth (type,action,tstamp),
631 KEY request (request_id)
632 ) ENGINE=InnoDB;
633
634 #
635 # Table structure for table 'sys_language'
636 #
637 CREATE TABLE sys_language (
638 uid int(11) unsigned NOT NULL auto_increment,
639 pid int(11) unsigned DEFAULT '0' NOT NULL,
640 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
641 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
642 title varchar(80) DEFAULT '' NOT NULL,
643 flag varchar(20) DEFAULT '' NOT NULL,
644 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
645 PRIMARY KEY (uid),
646 KEY parent (pid)
647 );
648
649 #
650 # Table structure for table 'sys_category'
651 #
652 CREATE TABLE sys_category (
653 uid int(11) NOT NULL auto_increment,
654 pid int(11) DEFAULT '0' NOT NULL,
655 tstamp int(11) DEFAULT '0' NOT NULL,
656 crdate int(11) DEFAULT '0' NOT NULL,
657 cruser_id int(11) DEFAULT '0' NOT NULL,
658 deleted tinyint(4) DEFAULT '0' NOT NULL,
659 hidden tinyint(4) DEFAULT '0' NOT NULL,
660 starttime int(11) unsigned DEFAULT '0' NOT NULL,
661 endtime int(11) unsigned DEFAULT '0' NOT NULL,
662
663 t3ver_oid int(11) DEFAULT '0' NOT NULL,
664 t3ver_id int(11) DEFAULT '0' NOT NULL,
665 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
666 t3ver_label varchar(30) DEFAULT '' NOT NULL,
667 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
668 t3ver_stage int(11) DEFAULT '0' NOT NULL,
669 t3ver_count int(11) DEFAULT '0' NOT NULL,
670 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
671 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
672 t3_origuid int(11) DEFAULT '0' NOT NULL,
673 sorting int(11) unsigned DEFAULT '0' NOT NULL,
674
675 sys_language_uid int(11) DEFAULT '0' NOT NULL,
676 l10n_parent int(11) DEFAULT '0' NOT NULL,
677 l10n_diffsource mediumblob NOT NULL,
678
679 title tinytext NOT NULL,
680 description text NOT NULL,
681 parent int(11) DEFAULT '0' NOT NULL,
682 items int(11) DEFAULT '0' NOT NULL,
683
684 PRIMARY KEY (uid),
685 KEY parent (pid),
686 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
687 KEY category_parent (parent),
688 KEY category_list (pid,deleted,sys_language_uid),
689 );
690
691 #
692 # Table structure for table 'sys_category_record_mm'
693 #
694 CREATE TABLE sys_category_record_mm (
695 uid_local int(11) DEFAULT '0' NOT NULL,
696 uid_foreign int(11) DEFAULT '0' NOT NULL,
697 tablenames varchar(255) DEFAULT '' NOT NULL,
698 fieldname varchar(255) DEFAULT '' NOT NULL,
699 sorting int(11) DEFAULT '0' NOT NULL,
700 sorting_foreign int(11) DEFAULT '0' NOT NULL,
701
702 KEY uid_local_foreign (uid_local,uid_foreign),
703 KEY uid_foreign_tablenames (uid_foreign,tablenames)
704 );