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