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