[TASK] Move RemoveXSS to EXT:core
[Packages/TYPO3.CMS.git] / typo3 / sysext / core / ext_tables.sql
1 #
2 # Table structure for table 'be_groups'
3 #
4 CREATE TABLE be_groups (
5 uid int(11) unsigned NOT NULL auto_increment,
6 pid int(11) unsigned DEFAULT '0' NOT NULL,
7 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
8 title varchar(50) DEFAULT '' NOT NULL,
9 non_exclude_fields text,
10 explicit_allowdeny text,
11 allowed_languages varchar(255) DEFAULT '' NOT NULL,
12 custom_options text,
13 db_mountpoints text,
14 pagetypes_select varchar(255) DEFAULT '' NOT NULL,
15 tables_select text,
16 tables_modify text,
17 crdate int(11) unsigned DEFAULT '0' NOT NULL,
18 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
19 groupMods text,
20 file_mountpoints text,
21 file_permissions text,
22 hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
23 description text,
24 lockToDomain varchar(50) DEFAULT '' NOT NULL,
25 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
26 TSconfig text,
27 subgroup text,
28 hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
29 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
30 category_perms varchar(255) DEFAULT '' NOT NULL,
31 PRIMARY KEY (uid),
32 KEY parent (pid)
33 );
34
35 #
36 # Table structure for table 'be_sessions'
37 #
38 CREATE TABLE be_sessions (
39 ses_id varchar(32) DEFAULT '' NOT NULL,
40 ses_name varchar(32) DEFAULT '' NOT NULL,
41 ses_iplock varchar(39) DEFAULT '' NOT NULL,
42 ses_hashlock int(11) DEFAULT '0' NOT NULL,
43 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
44 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
45 ses_data longtext,
46 ses_backuserid int(11) NOT NULL default '0',
47 PRIMARY KEY (ses_id,ses_name),
48 KEY ses_tstamp (ses_tstamp)
49 );
50
51 #
52 # Table structure for table 'be_users'
53 #
54 CREATE TABLE be_users (
55 uid int(11) unsigned NOT NULL auto_increment,
56 pid int(11) unsigned DEFAULT '0' NOT NULL,
57 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
58 username varchar(50) DEFAULT '' NOT NULL,
59 password varchar(100) DEFAULT '' NOT NULL,
60 admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
61 usergroup varchar(255) DEFAULT '' NOT NULL,
62 disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
63 starttime int(11) unsigned DEFAULT '0' NOT NULL,
64 endtime int(11) unsigned DEFAULT '0' NOT NULL,
65 lang char(2) DEFAULT '' NOT NULL,
66 email varchar(80) DEFAULT '' NOT NULL,
67 db_mountpoints text,
68 options tinyint(4) unsigned DEFAULT '0' NOT NULL,
69 crdate int(11) unsigned DEFAULT '0' NOT NULL,
70 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
71 realName varchar(80) DEFAULT '' NOT NULL,
72 userMods text,
73 allowed_languages varchar(255) DEFAULT '' NOT NULL,
74 uc mediumtext,
75 file_mountpoints text,
76 file_permissions text,
77 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
78 lockToDomain varchar(50) DEFAULT '' NOT NULL,
79 disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
80 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
81 TSconfig text,
82 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
83 createdByAction int(11) DEFAULT '0' NOT NULL,
84 usergroup_cached_list text,
85 workspace_id int(11) DEFAULT '0' NOT NULL,
86 workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
87 category_perms varchar(255) DEFAULT '' NOT NULL,
88 PRIMARY KEY (uid),
89 KEY parent (pid),
90 KEY username (username)
91 );
92
93 #
94 # Table structure for table 'cache_imagesizes'
95 #
96 CREATE TABLE cache_imagesizes (
97 md5hash varchar(32) DEFAULT '' NOT NULL,
98 md5filename varchar(32) DEFAULT '' NOT NULL,
99 tstamp int(11) DEFAULT '0' NOT NULL,
100 filename varchar(255) DEFAULT '' NOT NULL,
101 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
102 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
103 PRIMARY KEY (md5filename)
104 ) ENGINE=InnoDB;
105
106 #
107 # Table structure for table 'pages'
108 #
109 CREATE TABLE pages (
110 uid int(11) NOT NULL auto_increment,
111 pid int(11) DEFAULT '0' NOT NULL,
112 t3ver_oid int(11) DEFAULT '0' NOT NULL,
113 t3ver_id int(11) DEFAULT '0' NOT NULL,
114 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
115 t3ver_label varchar(255) DEFAULT '' NOT NULL,
116 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
117 t3ver_stage int(11) DEFAULT '0' NOT NULL,
118 t3ver_count int(11) DEFAULT '0' NOT NULL,
119 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
120 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
121 t3_origuid int(11) DEFAULT '0' NOT NULL,
122 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
123 sorting int(11) unsigned DEFAULT '0' NOT NULL,
124 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
125 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
126 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
127 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
128 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
129 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
130 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
131 crdate int(11) unsigned DEFAULT '0' NOT NULL,
132 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
133 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
134 title varchar(255) DEFAULT '' NOT NULL,
135 doktype int(11) unsigned DEFAULT '0' NOT NULL,
136 TSconfig text,
137 storage_pid int(11) DEFAULT '0' NOT NULL,
138 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
139 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
140 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
141 url varchar(255) DEFAULT '' NOT NULL,
142 starttime int(11) unsigned DEFAULT '0' NOT NULL,
143 endtime int(11) unsigned DEFAULT '0' NOT NULL,
144 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
145 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
146 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
147 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
148 fe_group varchar(100) DEFAULT '0' NOT NULL,
149 subtitle varchar(255) DEFAULT '' NOT NULL,
150 layout int(11) unsigned DEFAULT '0' NOT NULL,
151 url_scheme tinyint(3) unsigned DEFAULT '0' NOT NULL,
152 target varchar(80) DEFAULT '' NOT NULL,
153 media text,
154 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
155 keywords text,
156 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
157 cache_tags varchar(255) DEFAULT '' NOT NULL,
158 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
159 description text,
160 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
161 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
162 abstract text,
163 module varchar(10) DEFAULT '' NOT NULL,
164 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
165 author varchar(255) DEFAULT '' NOT NULL,
166 author_email varchar(80) DEFAULT '' NOT NULL,
167 nav_title varchar(255) DEFAULT '' NOT NULL,
168 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
169 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
170 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
171 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
172 alias varchar(32) DEFAULT '' NOT NULL,
173 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
174 fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
175 backend_layout varchar(64) DEFAULT '' NOT NULL,
176 backend_layout_next_level varchar(64) DEFAULT '' NOT NULL,
177 PRIMARY KEY (uid),
178 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
179 KEY parent (pid,deleted,sorting),
180 KEY alias (alias),
181 KEY determineSiteRoot (is_siteroot)
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 int(11) 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 read_only tinyint(1) unsigned DEFAULT '0' NOT NULL,
247 PRIMARY KEY (uid),
248 KEY parent (pid)
249 );
250
251
252 #
253 # Table structure for table 'sys_file_storage'
254 #
255 CREATE TABLE sys_file_storage (
256 uid int(11) NOT NULL auto_increment,
257 pid int(11) DEFAULT '0' NOT NULL,
258 tstamp int(11) DEFAULT '0' NOT NULL,
259 crdate int(11) DEFAULT '0' NOT NULL,
260 cruser_id int(11) DEFAULT '0' NOT NULL,
261 deleted tinyint(4) DEFAULT '0' NOT NULL,
262
263 name varchar(30) DEFAULT '' NOT NULL,
264 description text,
265 driver tinytext,
266 configuration text,
267 is_default tinyint(4) DEFAULT '0' NOT NULL,
268 is_browsable tinyint(4) DEFAULT '0' NOT NULL,
269 is_public tinyint(4) DEFAULT '0' NOT NULL,
270 is_writable tinyint(4) DEFAULT '0' NOT NULL,
271 is_online tinyint(4) DEFAULT '1' NOT NULL,
272 processingfolder tinytext,
273
274 PRIMARY KEY (uid),
275 KEY parent (pid,deleted)
276 );
277
278 #
279 # Table structure for table 'sys_file'
280 #
281 CREATE TABLE sys_file (
282 uid int(11) NOT NULL auto_increment,
283 pid int(11) DEFAULT '0' NOT NULL,
284 # update timestamp of the database record, not the file!
285 tstamp int(11) DEFAULT '0' NOT NULL,
286 last_indexed 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 char(40) DEFAULT '' NOT NULL,
297 folder_hash char(40) DEFAULT '' NOT NULL,
298 extension varchar(255) DEFAULT '' NOT NULL,
299 mime_type varchar(255) DEFAULT '' NOT NULL,
300 name tinytext,
301 sha1 char(40) DEFAULT '' NOT NULL,
302 size bigint(20) unsigned 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 folder (storage,folder_hash),
309 KEY tstamp (tstamp),
310 KEY lastindex (last_indexed),
311 KEY sha1 (sha1)
312 );
313
314 #
315 # Table structure for table 'sys_file_metadata'
316 #
317 CREATE TABLE sys_file_metadata (
318 uid int(11) NOT NULL auto_increment,
319 pid int(11) DEFAULT '0' NOT NULL,
320 tstamp int(11) DEFAULT '0' NOT NULL,
321 crdate int(11) DEFAULT '0' NOT NULL,
322 cruser_id int(11) DEFAULT '0' NOT NULL,
323
324 # Language fields
325 sys_language_uid int(11) DEFAULT '0' NOT NULL,
326 l10n_parent int(11) DEFAULT '0' NOT NULL,
327 l10n_diffsource mediumblob NOT NULL,
328
329 # Versioning fields
330 t3ver_oid int(11) DEFAULT '0' NOT NULL,
331 t3ver_id int(11) DEFAULT '0' NOT NULL,
332 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
333 t3ver_label varchar(30) DEFAULT '' NOT NULL,
334 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
335 t3ver_stage int(11) DEFAULT '0' NOT NULL,
336 t3ver_count int(11) DEFAULT '0' NOT NULL,
337 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
338 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
339 t3_origuid int(11) DEFAULT '0' NOT NULL,
340
341 file int(11) DEFAULT '0' NOT NULL,
342 title tinytext,
343 width int(11) DEFAULT '0' NOT NULL,
344 height int(11) DEFAULT '0' NOT NULL,
345 description text,
346 alternative text,
347
348 PRIMARY KEY (uid),
349 KEY file (file),
350 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
351 KEY fal_filelist (l10n_parent,sys_language_uid)
352 );
353
354
355 #
356 # Table structure for table 'sys_file_processedfile'.
357 # which is a "temporary" file, like an image preview
358 # This table does not have a TCA representation, as it is only written
359 # to using direct SQL queries in the code
360 #
361 CREATE TABLE sys_file_processedfile (
362 uid int(11) NOT NULL auto_increment,
363 tstamp int(11) DEFAULT '0' NOT NULL,
364 crdate int(11) DEFAULT '0' NOT NULL,
365
366 storage int(11) DEFAULT '0' NOT NULL,
367 original int(11) DEFAULT '0' NOT NULL,
368 identifier varchar(512) DEFAULT '' NOT NULL,
369 name tinytext,
370 configuration text,
371 configurationsha1 char(40) DEFAULT '' NOT NULL,
372 originalfilesha1 char(40) DEFAULT '' NOT NULL,
373 task_type varchar(200) DEFAULT '' NOT NULL,
374 checksum char(10) DEFAULT '' NOT NULL,
375 width int(11) DEFAULT '0',
376 height int(11) DEFAULT '0',
377
378 PRIMARY KEY (uid),
379 KEY combined_1 (original,task_type,configurationsha1),
380 KEY identifier (storage,identifier(199))
381 );
382
383 #
384 # Table structure for table 'sys_file_reference'
385 # which is one usage of a file with overloaded metadata
386 #
387 CREATE TABLE sys_file_reference (
388 uid int(11) NOT NULL auto_increment,
389 pid int(11) DEFAULT '0' NOT NULL,
390 tstamp int(11) DEFAULT '0' NOT NULL,
391 crdate int(11) DEFAULT '0' NOT NULL,
392 cruser_id int(11) DEFAULT '0' NOT NULL,
393 sorting int(10) DEFAULT '0' NOT NULL,
394 deleted tinyint(4) DEFAULT '0' NOT NULL,
395 hidden tinyint(4) DEFAULT '0' NOT NULL,
396
397 # Versioning fields
398 t3ver_oid int(11) DEFAULT '0' NOT NULL,
399 t3ver_id int(11) DEFAULT '0' NOT NULL,
400 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
401 t3ver_label varchar(30) DEFAULT '' NOT NULL,
402 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
403 t3ver_stage int(11) DEFAULT '0' NOT NULL,
404 t3ver_count int(11) DEFAULT '0' NOT NULL,
405 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
406 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
407 t3_origuid int(11) DEFAULT '0' NOT NULL,
408
409 # Language fields
410 sys_language_uid int(11) DEFAULT '0' NOT NULL,
411 l10n_parent int(11) DEFAULT '0' NOT NULL,
412 l10n_diffsource mediumblob NOT NULL,
413
414 # Reference fields (basically same as MM table)
415 uid_local int(11) DEFAULT '0' NOT NULL,
416 uid_foreign int(11) DEFAULT '0' NOT NULL,
417 tablenames varchar(64) DEFAULT '' NOT NULL,
418 fieldname varchar(64) DEFAULT '' NOT NULL,
419 sorting_foreign int(11) DEFAULT '0' NOT NULL,
420 table_local varchar(64) DEFAULT '' NOT NULL,
421
422 # Local usage overlay fields
423 title tinytext,
424 description text,
425 alternative tinytext,
426 link varchar(1024) DEFAULT '' NOT NULL,
427 downloadname tinytext,
428
429 PRIMARY KEY (uid),
430 KEY parent (pid,deleted),
431 KEY tablenames_fieldname (tablenames(32),fieldname(12)),
432 KEY deleted (deleted),
433 KEY uid_foreign (uid_foreign)
434 );
435
436
437 #
438 # Table structure for table 'sys_file_collection'
439 #
440 CREATE TABLE sys_file_collection (
441 uid int(11) NOT NULL auto_increment,
442 pid int(11) DEFAULT '0' NOT NULL,
443 tstamp int(11) DEFAULT '0' NOT NULL,
444 crdate int(11) DEFAULT '0' NOT NULL,
445 cruser_id 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(30) 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 sys_language_uid int(11) DEFAULT '0' NOT NULL,
457 l10n_parent int(11) DEFAULT '0' NOT NULL,
458 l10n_diffsource mediumtext,
459 deleted tinyint(4) DEFAULT '0' NOT NULL,
460 hidden tinyint(4) DEFAULT '0' NOT NULL,
461 starttime int(11) DEFAULT '0' NOT NULL,
462 endtime int(11) DEFAULT '0' NOT NULL,
463
464 # Actual fields
465 title tinytext,
466 description text,
467 type varchar(30) DEFAULT 'static' NOT NULL,
468
469 # for type=static
470 files int(11) DEFAULT '0' NOT NULL,
471
472 # for type=folder:
473 storage int(11) DEFAULT '0' NOT NULL,
474 folder text NOT NULL,
475
476 # for type=category:
477 category int(11) DEFAULT '0' NOT NULL,
478
479 PRIMARY KEY (uid),
480 KEY parent (pid,deleted),
481 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
482 );
483
484 #
485 # Table structure for table 'sys_collection'
486 #
487 CREATE TABLE sys_collection (
488 uid int(11) NOT NULL auto_increment,
489 pid int(11) DEFAULT '0' NOT NULL,
490 tstamp int(11) DEFAULT '0' NOT NULL,
491 crdate int(11) DEFAULT '0' NOT NULL,
492 cruser_id int(11) DEFAULT '0' NOT NULL,
493 t3ver_oid int(11) DEFAULT '0' NOT NULL,
494 t3ver_id int(11) DEFAULT '0' NOT NULL,
495 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
496 t3ver_label varchar(30) DEFAULT '' NOT NULL,
497 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
498 t3ver_stage int(11) DEFAULT '0' NOT NULL,
499 t3ver_count int(11) DEFAULT '0' NOT NULL,
500 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
501 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
502 t3_origuid int(11) DEFAULT '0' NOT NULL,
503 sys_language_uid int(11) DEFAULT '0' NOT NULL,
504 l10n_parent int(11) DEFAULT '0' NOT NULL,
505 l10n_diffsource mediumtext,
506 deleted tinyint(4) DEFAULT '0' NOT NULL,
507 hidden tinyint(4) DEFAULT '0' NOT NULL,
508 starttime int(11) DEFAULT '0' NOT NULL,
509 endtime int(11) DEFAULT '0' NOT NULL,
510 fe_group int(11) DEFAULT '0' NOT NULL,
511
512 title tinytext,
513 description text,
514 type varchar(32) DEFAULT 'static' NOT NULL,
515 table_name tinytext,
516 items int(11) DEFAULT '0' NOT NULL,
517
518 PRIMARY KEY (uid),
519 KEY parent (pid,deleted),
520 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
521 );
522
523 #
524 # Table structure for table 'sys_collection_entries'
525 #
526 CREATE TABLE sys_collection_entries (
527 uid int(11) NOT NULL auto_increment,
528 uid_local int(11) DEFAULT '0' NOT NULL,
529 uid_foreign int(11) DEFAULT '0' NOT NULL,
530 tablenames varchar(64) DEFAULT '' NOT NULL,
531 sorting int(11) DEFAULT '0' NOT NULL,
532
533 KEY uid_local (uid_local),
534 KEY uid_foreign (uid_foreign),
535 PRIMARY KEY (uid)
536 );
537
538 #
539 # Table structure for table 'sys_history'
540 #
541 CREATE TABLE sys_history (
542 uid int(11) unsigned NOT NULL auto_increment,
543 pid int(11) unsigned DEFAULT '0' NOT NULL,
544 sys_log_uid int(11) DEFAULT '0' NOT NULL,
545 history_data mediumtext,
546 fieldlist text,
547 recuid int(11) DEFAULT '0' NOT NULL,
548 tablename varchar(255) DEFAULT '' NOT NULL,
549 tstamp int(11) DEFAULT '0' NOT NULL,
550 history_files mediumtext,
551 snapshot int(11) DEFAULT '0' NOT NULL,
552 PRIMARY KEY (uid),
553 KEY parent (pid),
554 KEY recordident_1 (tablename,recuid),
555 KEY recordident_2 (tablename,tstamp),
556 KEY sys_log_uid (sys_log_uid)
557 ) ENGINE=InnoDB;
558
559 #
560 # Table structure for table 'sys_lockedrecords'
561 #
562 CREATE TABLE sys_lockedrecords (
563 uid int(11) unsigned NOT NULL auto_increment,
564 userid int(11) unsigned DEFAULT '0' NOT NULL,
565 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
566 record_table varchar(255) DEFAULT '' NOT NULL,
567 record_uid int(11) DEFAULT '0' NOT NULL,
568 record_pid int(11) DEFAULT '0' NOT NULL,
569 username varchar(50) DEFAULT '' NOT NULL,
570 feuserid int(11) unsigned DEFAULT '0' NOT NULL,
571 PRIMARY KEY (uid),
572 KEY event (userid,tstamp)
573 );
574
575 #
576 # Table structure for table 'sys_refindex'
577 #
578 CREATE TABLE sys_refindex (
579 hash varchar(32) DEFAULT '' NOT NULL,
580 tablename varchar(255) DEFAULT '' NOT NULL,
581 recuid int(11) DEFAULT '0' NOT NULL,
582 field varchar(40) DEFAULT '' NOT NULL,
583 flexpointer varchar(255) DEFAULT '' NOT NULL,
584 softref_key varchar(30) DEFAULT '' NOT NULL,
585 softref_id varchar(40) DEFAULT '' NOT NULL,
586 sorting int(11) DEFAULT '0' NOT NULL,
587 deleted tinyint(1) DEFAULT '0' NOT NULL,
588 workspace int(11) 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 language_isocode varchar(2) DEFAULT '' NOT NULL,
645 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
646 PRIMARY KEY (uid),
647 KEY parent (pid)
648 );
649
650 #
651 # Table structure for table 'sys_category'
652 #
653 CREATE TABLE sys_category (
654 uid int(11) NOT NULL auto_increment,
655 pid int(11) DEFAULT '0' NOT NULL,
656 tstamp int(11) DEFAULT '0' NOT NULL,
657 crdate int(11) DEFAULT '0' NOT NULL,
658 cruser_id int(11) DEFAULT '0' NOT NULL,
659 deleted tinyint(4) DEFAULT '0' NOT NULL,
660 hidden tinyint(4) DEFAULT '0' NOT NULL,
661 starttime int(11) unsigned DEFAULT '0' NOT NULL,
662 endtime int(11) unsigned DEFAULT '0' NOT NULL,
663
664 t3ver_oid int(11) DEFAULT '0' NOT NULL,
665 t3ver_id int(11) DEFAULT '0' NOT NULL,
666 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
667 t3ver_label varchar(30) DEFAULT '' NOT NULL,
668 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
669 t3ver_stage int(11) DEFAULT '0' NOT NULL,
670 t3ver_count int(11) DEFAULT '0' NOT NULL,
671 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
672 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
673 t3_origuid int(11) DEFAULT '0' NOT NULL,
674 sorting int(11) unsigned DEFAULT '0' NOT NULL,
675
676 sys_language_uid int(11) DEFAULT '0' NOT NULL,
677 l10n_parent int(11) DEFAULT '0' NOT NULL,
678 l10n_diffsource mediumblob NOT NULL,
679
680 title tinytext NOT NULL,
681 description text NOT NULL,
682 parent int(11) DEFAULT '0' NOT NULL,
683 items int(11) DEFAULT '0' NOT NULL,
684
685 PRIMARY KEY (uid),
686 KEY parent (pid),
687 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
688 KEY category_parent (parent),
689 KEY category_list (pid,deleted,sys_language_uid)
690 );
691
692 #
693 # Table structure for table 'sys_category_record_mm'
694 #
695 CREATE TABLE sys_category_record_mm (
696 uid_local int(11) DEFAULT '0' NOT NULL,
697 uid_foreign int(11) DEFAULT '0' NOT NULL,
698 tablenames varchar(255) DEFAULT '' NOT NULL,
699 fieldname varchar(255) DEFAULT '' NOT NULL,
700 sorting int(11) DEFAULT '0' NOT NULL,
701 sorting_foreign int(11) DEFAULT '0' NOT NULL,
702
703 KEY uid_local_foreign (uid_local,uid_foreign),
704 KEY uid_foreign_tablenames (uid_foreign,tablenames)
705 );