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