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