[BUGFIX] File identifiers are case-insensitive
[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 '0' NOT NULL,
179 backend_layout_next_level varchar(64) DEFAULT '0' 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 tinytext,
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 );
278
279 #
280 # Table structure for table 'sys_file'
281 #
282 CREATE TABLE sys_file (
283 uid int(11) NOT NULL auto_increment,
284 pid int(11) DEFAULT '0' NOT NULL,
285 # update timestamp of the database record, not the file!
286 tstamp int(11) DEFAULT '0' NOT NULL,
287
288 # management information
289 missing tinyint(4) DEFAULT '0' NOT NULL,
290 storage int(11) DEFAULT '0' NOT NULL,
291 type varchar(10) DEFAULT '' NOT NULL,
292 metadata int(11) DEFAULT '0' NOT NULL,
293
294 # file info data
295 identifier text,
296 identifier_hash varchar(40) DEFAULT '' NOT NULL,
297 folder_hash varchar(40) DEFAULT '' NOT NULL,
298 extension varchar(255) DEFAULT '' NOT NULL,
299 mime_type varchar(255) DEFAULT '' NOT NULL,
300 name tinytext,
301 sha1 tinytext,
302 size int(11) DEFAULT '0' NOT NULL,
303 creation_date int(11) DEFAULT '0' NOT NULL,
304 modification_date int(11) DEFAULT '0' NOT NULL,
305
306 PRIMARY KEY (uid),
307 KEY sel01 (storage,identifier_hash),
308 KEY sha1 (sha1(40))
309 );
310
311 #
312 # Table structure for table 'sys_file_metadata'
313 #
314 CREATE TABLE sys_file_metadata (
315 uid int(11) NOT NULL auto_increment,
316 pid int(11) DEFAULT '0' NOT NULL,
317 tstamp int(11) DEFAULT '0' NOT NULL,
318 crdate int(11) DEFAULT '0' NOT NULL,
319 cruser_id int(11) DEFAULT '0' NOT NULL,
320
321 # Language fields
322 sys_language_uid int(11) DEFAULT '0' NOT NULL,
323 l10n_parent int(11) DEFAULT '0' NOT NULL,
324 l10n_diffsource mediumblob NOT NULL,
325
326 # Versioning fields
327 t3ver_oid int(11) DEFAULT '0' NOT NULL,
328 t3ver_id int(11) DEFAULT '0' NOT NULL,
329 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
330 t3ver_label varchar(30) DEFAULT '' NOT NULL,
331 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
332 t3ver_stage int(11) DEFAULT '0' NOT NULL,
333 t3ver_count int(11) DEFAULT '0' NOT NULL,
334 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
335 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
336 t3_origuid int(11) DEFAULT '0' NOT NULL,
337
338 file int(11) DEFAULT '0' NOT NULL,
339 title tinytext,
340 width int(11) DEFAULT '0' NOT NULL,
341 height int(11) DEFAULT '0' NOT NULL,
342 description text,
343 alternative text,
344
345 PRIMARY KEY (uid),
346 KEY file (file),
347 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
348 );
349
350
351 #
352 # Table structure for table 'sys_file_processedfile'.
353 # which is a "temporary" file, like an image preview
354 # This table does not have a TCA representation, as it is only written
355 # to using direct SQL queries in the code
356 #
357 CREATE TABLE sys_file_processedfile (
358 uid int(11) NOT NULL auto_increment,
359 tstamp int(11) DEFAULT '0' NOT NULL,
360 crdate int(11) DEFAULT '0' NOT NULL,
361
362 storage int(11) DEFAULT '0' NOT NULL,
363 original int(11) DEFAULT '0' NOT NULL,
364 identifier varchar(512) DEFAULT '' NOT NULL,
365 name tinytext,
366 configuration text,
367 configurationsha1 varchar(40) DEFAULT '' NOT NULL,
368 originalfilesha1 varchar(40) DEFAULT '' NOT NULL,
369 task_type varchar(200) DEFAULT '' NOT NULL,
370 checksum varchar(255) DEFAULT '' NOT NULL,
371 width int(11) DEFAULT '0',
372 height int(11) DEFAULT '0',
373
374 PRIMARY KEY (uid)
375 );
376
377 #
378 # Table structure for table 'sys_file_reference'
379 # which is one usage of a file with overloaded metadata
380 #
381 CREATE TABLE sys_file_reference (
382 uid int(11) NOT NULL auto_increment,
383 pid int(11) DEFAULT '0' NOT NULL,
384 tstamp int(11) DEFAULT '0' NOT NULL,
385 crdate int(11) DEFAULT '0' NOT NULL,
386 cruser_id int(11) DEFAULT '0' NOT NULL,
387 sorting int(10) DEFAULT '0' NOT NULL,
388 deleted tinyint(4) DEFAULT '0' NOT NULL,
389 hidden tinyint(4) DEFAULT '0' NOT NULL,
390
391 # Versioning fields
392 t3ver_oid int(11) DEFAULT '0' NOT NULL,
393 t3ver_id int(11) DEFAULT '0' NOT NULL,
394 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
395 t3ver_label varchar(30) DEFAULT '' NOT NULL,
396 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
397 t3ver_stage int(11) DEFAULT '0' NOT NULL,
398 t3ver_count int(11) DEFAULT '0' NOT NULL,
399 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
400 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
401 t3_origuid int(11) DEFAULT '0' NOT NULL,
402
403 # Language fields
404 sys_language_uid int(11) DEFAULT '0' NOT NULL,
405 l10n_parent int(11) DEFAULT '0' NOT NULL,
406 l10n_diffsource mediumblob NOT NULL,
407
408 # Reference fields (basically same as MM table)
409 uid_local int(11) DEFAULT '0' NOT NULL,
410 uid_foreign int(11) DEFAULT '0' NOT NULL,
411 tablenames varchar(255) DEFAULT '' NOT NULL,
412 fieldname tinytext,
413 sorting_foreign int(11) DEFAULT '0' NOT NULL,
414 table_local varchar(255) DEFAULT '' NOT NULL,
415
416 # Local usage overlay fields
417 title tinytext,
418 description text,
419 alternative tinytext,
420 link tinytext,
421 downloadname tinytext,
422
423 PRIMARY KEY (uid),
424 KEY parent (pid,deleted)
425 );
426
427
428 #
429 # Table structure for table 'sys_file_collection'
430 #
431 CREATE TABLE sys_file_collection (
432 uid int(11) NOT NULL auto_increment,
433 pid int(11) DEFAULT '0' NOT NULL,
434 tstamp int(11) DEFAULT '0' NOT NULL,
435 crdate int(11) DEFAULT '0' NOT NULL,
436 cruser_id int(11) DEFAULT '0' NOT NULL,
437 t3ver_oid int(11) DEFAULT '0' NOT NULL,
438 t3ver_id int(11) DEFAULT '0' NOT NULL,
439 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
440 t3ver_label varchar(30) DEFAULT '' NOT NULL,
441 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
442 t3ver_stage int(11) DEFAULT '0' NOT NULL,
443 t3ver_count int(11) DEFAULT '0' NOT NULL,
444 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
445 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
446 t3_origuid int(11) DEFAULT '0' NOT NULL,
447 sys_language_uid int(11) DEFAULT '0' NOT NULL,
448 l10n_parent int(11) DEFAULT '0' NOT NULL,
449 l10n_diffsource mediumtext,
450 deleted tinyint(4) DEFAULT '0' NOT NULL,
451 hidden tinyint(4) DEFAULT '0' NOT NULL,
452 starttime int(11) DEFAULT '0' NOT NULL,
453 endtime int(11) DEFAULT '0' NOT NULL,
454
455 # Actual fields
456 title tinytext,
457 description text,
458 type varchar(30) DEFAULT 'static' NOT NULL,
459
460 # for type=static
461 files int(11) DEFAULT '0' NOT NULL,
462
463 # for type=folder:
464 storage int(11) DEFAULT '0' NOT NULL,
465 folder text NOT NULL,
466
467 # for type=category:
468 category int(11) DEFAULT '0' NOT NULL,
469
470 PRIMARY KEY (uid),
471 KEY parent (pid,deleted),
472 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
473 );
474
475 #
476 # Table structure for table 'sys_collection'
477 #
478 CREATE TABLE sys_collection (
479 uid int(11) NOT NULL auto_increment,
480 pid int(11) DEFAULT '0' NOT NULL,
481 tstamp int(11) DEFAULT '0' NOT NULL,
482 crdate int(11) DEFAULT '0' NOT NULL,
483 cruser_id int(11) DEFAULT '0' NOT NULL,
484 t3ver_oid int(11) DEFAULT '0' NOT NULL,
485 t3ver_id int(11) DEFAULT '0' NOT NULL,
486 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
487 t3ver_label varchar(30) DEFAULT '' NOT NULL,
488 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
489 t3ver_stage int(11) DEFAULT '0' NOT NULL,
490 t3ver_count int(11) DEFAULT '0' NOT NULL,
491 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
492 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
493 t3_origuid int(11) DEFAULT '0' NOT NULL,
494 sys_language_uid int(11) DEFAULT '0' NOT NULL,
495 l10n_parent int(11) DEFAULT '0' NOT NULL,
496 l10n_diffsource mediumtext,
497 deleted tinyint(4) DEFAULT '0' NOT NULL,
498 hidden tinyint(4) DEFAULT '0' NOT NULL,
499 starttime int(11) DEFAULT '0' NOT NULL,
500 endtime int(11) DEFAULT '0' NOT NULL,
501 fe_group int(11) DEFAULT '0' NOT NULL,
502
503 title tinytext,
504 description text,
505 type varchar(32) DEFAULT 'static' NOT NULL,
506 table_name tinytext,
507 items int(11) DEFAULT '0' NOT NULL,
508
509 PRIMARY KEY (uid),
510 KEY parent (pid,deleted),
511 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
512 );
513
514 #
515 # Table structure for table 'sys_collection_entries'
516 #
517 CREATE TABLE sys_collection_entries (
518 uid int(11) NOT NULL auto_increment,
519 uid_local int(11) DEFAULT '0' NOT NULL,
520 uid_foreign int(11) DEFAULT '0' NOT NULL,
521 tablenames varchar(30) DEFAULT '' NOT NULL,
522 sorting int(11) DEFAULT '0' NOT NULL,
523
524 KEY uid_local (uid_local),
525 KEY uid_foreign (uid_foreign),
526 PRIMARY KEY (uid)
527 );
528
529 #
530 # Table structure for table 'sys_history'
531 #
532 CREATE TABLE sys_history (
533 uid int(11) unsigned NOT NULL auto_increment,
534 pid int(11) unsigned DEFAULT '0' NOT NULL,
535 sys_log_uid int(11) DEFAULT '0' NOT NULL,
536 history_data mediumtext,
537 fieldlist text,
538 recuid int(11) DEFAULT '0' NOT NULL,
539 tablename varchar(255) DEFAULT '' NOT NULL,
540 tstamp int(11) DEFAULT '0' NOT NULL,
541 history_files mediumtext,
542 snapshot int(11) DEFAULT '0' NOT NULL,
543 PRIMARY KEY (uid),
544 KEY parent (pid),
545 KEY recordident_1 (tablename,recuid),
546 KEY recordident_2 (tablename,tstamp),
547 KEY sys_log_uid (sys_log_uid)
548 ) ENGINE=InnoDB;
549
550 #
551 # Table structure for table 'sys_lockedrecords'
552 #
553 CREATE TABLE sys_lockedrecords (
554 uid int(11) unsigned NOT NULL auto_increment,
555 userid int(11) unsigned DEFAULT '0' NOT NULL,
556 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
557 record_table varchar(255) DEFAULT '' NOT NULL,
558 record_uid int(11) DEFAULT '0' NOT NULL,
559 record_pid int(11) DEFAULT '0' NOT NULL,
560 username varchar(50) DEFAULT '' NOT NULL,
561 feuserid int(11) unsigned DEFAULT '0' NOT NULL,
562 PRIMARY KEY (uid),
563 KEY event (userid,tstamp)
564 );
565
566 #
567 # Table structure for table 'sys_refindex'
568 #
569 CREATE TABLE sys_refindex (
570 hash varchar(32) DEFAULT '' NOT NULL,
571 tablename varchar(255) DEFAULT '' NOT NULL,
572 recuid int(11) DEFAULT '0' NOT NULL,
573 field varchar(40) DEFAULT '' NOT NULL,
574 flexpointer varchar(255) DEFAULT '' NOT NULL,
575 softref_key varchar(30) DEFAULT '' NOT NULL,
576 softref_id varchar(40) DEFAULT '' NOT NULL,
577 sorting int(11) DEFAULT '0' NOT NULL,
578 deleted tinyint(1) DEFAULT '0' NOT NULL,
579 ref_table varchar(255) DEFAULT '' NOT NULL,
580 ref_uid int(11) DEFAULT '0' NOT NULL,
581 ref_string varchar(200) DEFAULT '' NOT NULL,
582
583 PRIMARY KEY (hash),
584 KEY lookup_rec (tablename,recuid),
585 KEY lookup_uid (ref_table,ref_uid),
586 KEY lookup_string (ref_string)
587 );
588
589 #
590 # Table structure for table 'sys_log'
591 #
592 CREATE TABLE sys_log (
593 uid int(11) unsigned NOT NULL auto_increment,
594 pid int(11) unsigned DEFAULT '0' NOT NULL,
595 userid int(11) unsigned DEFAULT '0' NOT NULL,
596 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
597 recuid int(11) unsigned DEFAULT '0' NOT NULL,
598 tablename varchar(255) DEFAULT '' NOT NULL,
599 recpid int(11) DEFAULT '0' NOT NULL,
600 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
601 details text NOT NULL,
602 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
603 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
604 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
605 IP varchar(39) DEFAULT '' NOT NULL,
606 log_data text,
607 event_pid int(11) DEFAULT '-1' NOT NULL,
608 workspace int(11) DEFAULT '0' NOT NULL,
609 NEWid varchar(20) DEFAULT '' NOT NULL,
610 request_id varchar(13) DEFAULT '' NOT NULL,
611 time_micro float DEFAULT '0' NOT NULL,
612 component varchar(255) DEFAULT '' NOT NULL,
613 level tinyint(1) unsigned DEFAULT '0' NOT NULL,
614 message text,
615 data text,
616 PRIMARY KEY (uid),
617 KEY parent (pid),
618 KEY event (userid,event_pid),
619 KEY recuidIdx (recuid,uid),
620 KEY user_auth (type,action,tstamp),
621 KEY request (request_id)
622 ) ENGINE=InnoDB;
623
624 #
625 # Table structure for table 'sys_language'
626 #
627 CREATE TABLE sys_language (
628 uid int(11) unsigned NOT NULL auto_increment,
629 pid int(11) unsigned DEFAULT '0' NOT NULL,
630 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
631 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
632 title varchar(80) DEFAULT '' NOT NULL,
633 flag varchar(20) DEFAULT '' NOT NULL,
634 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
635 PRIMARY KEY (uid),
636 KEY parent (pid)
637 );
638
639 #
640 # Table structure for table 'sys_category'
641 #
642 CREATE TABLE sys_category (
643 uid int(11) NOT NULL auto_increment,
644 pid int(11) DEFAULT '0' NOT NULL,
645 tstamp int(11) DEFAULT '0' NOT NULL,
646 crdate int(11) DEFAULT '0' NOT NULL,
647 cruser_id int(11) DEFAULT '0' NOT NULL,
648 deleted tinyint(4) DEFAULT '0' NOT NULL,
649 hidden tinyint(4) DEFAULT '0' NOT NULL,
650 starttime int(11) unsigned DEFAULT '0' NOT NULL,
651 endtime int(11) unsigned DEFAULT '0' NOT NULL,
652
653 t3ver_oid int(11) DEFAULT '0' NOT NULL,
654 t3ver_id int(11) DEFAULT '0' NOT NULL,
655 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
656 t3ver_label varchar(30) DEFAULT '' NOT NULL,
657 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
658 t3ver_stage int(11) DEFAULT '0' NOT NULL,
659 t3ver_count int(11) DEFAULT '0' NOT NULL,
660 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
661 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
662 t3_origuid int(11) DEFAULT '0' NOT NULL,
663 sorting int(11) unsigned DEFAULT '0' NOT NULL,
664
665 sys_language_uid int(11) DEFAULT '0' NOT NULL,
666 l10n_parent int(11) DEFAULT '0' NOT NULL,
667 l10n_diffsource mediumblob NOT NULL,
668
669 title tinytext NOT NULL,
670 description text NOT NULL,
671 parent int(11) DEFAULT '0' NOT NULL,
672 items int(11) DEFAULT '0' NOT NULL,
673
674 PRIMARY KEY (uid),
675 KEY parent (pid),
676 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
677 );
678
679 #
680 # Table structure for table 'sys_category_record_mm'
681 #
682 CREATE TABLE sys_category_record_mm (
683 uid_local int(11) DEFAULT '0' NOT NULL,
684 uid_foreign int(11) DEFAULT '0' NOT NULL,
685 tablenames varchar(255) DEFAULT '' NOT NULL,
686 fieldname varchar(255) DEFAULT '' NOT NULL,
687 sorting int(11) DEFAULT '0' NOT NULL,
688 sorting_foreign int(11) DEFAULT '0' NOT NULL,
689
690 KEY uid_local_foreign (uid_local,uid_foreign),
691 KEY uid_foreign_tablenames (uid_foreign,tablenames)
692 );