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