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