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