4 #
Table structure for table 'be_groups'
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,
15 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
16 pagetypes_select
varchar(255) DEFAULT '' NOT NULL,
19 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
20 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
22 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
23 fileoper_perms
tinyint(4) DEFAULT '0' NOT NULL,
24 hidden
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
25 inc_access_lists
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
27 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
28 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
30 subgroup
varchar(255) DEFAULT '' NOT NULL,
31 hide_in_lists
tinyint(4) DEFAULT '0' NOT NULL,
32 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
38 #
Table structure for table 'be_sessions'
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,
48 ses_backuserid
int(11) NOT NULL default '0',
49 PRIMARY KEY (ses_id
,ses_name
),
50 KEY ses_tstamp (ses_tstamp
)
54 #
Table structure for table 'be_users'
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
varchar(255) DEFAULT '' NOT NULL,
75 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
77 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
78 fileoper_perms
tinyint(4) DEFAULT '0' NOT NULL,
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,
84 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
85 createdByAction
int(11) DEFAULT '0' NOT NULL,
86 usergroup_cached_list
varchar(255) DEFAULT '' NOT NULL,
87 workspace_id
int(11) DEFAULT '0' NOT NULL,
88 workspace_preview
tinyint(3) DEFAULT '1' NOT NULL,
91 KEY username (username
)
95 #
Table structure for table 'cache_imagesizes'
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
)
108 #
Table structure for 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,
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,
155 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
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,
161 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
162 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
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,
179 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
180 KEY parent (pid
,deleted
,sorting
),
185 #
Table structure for table 'sys_registry'
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,
193 UNIQUE KEY entry_identifier (entry_namespace
,entry_key
)
197 #
Table structure for table 'sys_be_shortcuts'
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,
204 description
varchar(255) DEFAULT '' NOT NULL,
205 sorting
int(11) DEFAULT '0' NOT NULL,
206 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
213 #
Table structure for table 'sys_news'
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,
234 #
Table structure for table 'sys_filemounts'
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,
252 #
Table structure for table 'sys_file_storage'
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,
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
,
278 #
Table structure for table 'sys_file'
280 CREATE TABLE sys_file (
281 uid
int(11) NOT NULL auto_increment
,
282 pid
int(11) DEFAULT '0' NOT NULL,
283 tstamp
int(11) DEFAULT '0' NOT NULL,
284 crdate
int(11) DEFAULT '0' NOT NULL,
285 cruser_id
int(11) DEFAULT '0' NOT NULL,
286 deleted
tinyint(4) DEFAULT '0' NOT NULL,
289 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
290 t3ver_id
int(11) DEFAULT '0' NOT NULL,
291 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
292 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
293 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
294 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
295 t3ver_count
int(11) DEFAULT '0' NOT NULL,
296 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
297 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
298 t3_origuid
int(11) DEFAULT '0' NOT NULL,
300 type varchar(10) DEFAULT '' NOT NULL,
301 storage int(11) DEFAULT '0' NOT NULL,
302 identifier
varchar(200) DEFAULT '' NOT NULL,
303 extension
varchar(255) DEFAULT '' NOT NULL,
304 mime_type
varchar(255) DEFAULT '' NOT NULL,
308 size int(11) DEFAULT '0' NOT NULL,
309 creation_date
int(11) DEFAULT '0' NOT NULL,
310 modification_date
int(11) DEFAULT '0' NOT NULL,
311 width
int(11) DEFAULT '0' NOT NULL,
312 height
int(11) DEFAULT '0' NOT NULL,
318 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)
322 #
Table structure for table 'sys_file_processedfile'.
323 # which
is a
"temporary" file, like an image preview
324 # This
table does
not have a TCA representation
, as it
's only written do using direct SQL queries in the code
326 CREATE TABLE sys_file_processedfile (
327 uid int(11) NOT NULL auto_increment,
328 pid int(11) DEFAULT '0' NOT NULL,
329 tstamp int(11) DEFAULT '0' NOT NULL,
330 crdate int(11) DEFAULT '0' NOT NULL,
331 cruser_id int(11) DEFAULT '0' NOT NULL,
332 deleted tinyint(4) DEFAULT '0' NOT NULL,
334 storage int(11) DEFAULT '0' NOT NULL,
335 original int(11) DEFAULT '0' NOT NULL,
336 identifier varchar(200) DEFAULT '' NOT NULL,
339 context varchar(200) DEFAULT '' NOT NULL,
340 checksum varchar(255) DEFAULT '' NOT NULL,
341 is_processed varchar(200) DEFAULT '' NOT NULL,
342 extension varchar(255) DEFAULT '' NOT NULL,
343 mime_type varchar(255) DEFAULT '' NOT NULL,
345 size int(11) DEFAULT '0' NOT NULL,
346 width int(11) DEFAULT '0' NOT NULL,
347 height int(11) DEFAULT '0' NOT NULL,
354 # Table structure for table 'sys_file_reference
'
355 # which is one usage of a file with overloaded metadata
357 CREATE TABLE sys_file_reference (
358 uid int(11) NOT NULL auto_increment,
359 pid int(11) DEFAULT '0' NOT NULL,
360 tstamp int(11) DEFAULT '0' NOT NULL,
361 crdate int(11) DEFAULT '0' NOT NULL,
362 cruser_id int(11) DEFAULT '0' NOT NULL,
363 sorting int(10) DEFAULT '0' NOT NULL,
364 deleted tinyint(4) DEFAULT '0' NOT NULL,
365 hidden tinyint(4) DEFAULT '0' NOT NULL,
368 t3ver_oid int(11) DEFAULT '0' NOT NULL,
369 t3ver_id int(11) DEFAULT '0' NOT NULL,
370 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
371 t3ver_label varchar(30) DEFAULT '' NOT NULL,
372 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
373 t3ver_stage int(11) DEFAULT '0' NOT NULL,
374 t3ver_count int(11) DEFAULT '0' NOT NULL,
375 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
376 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
377 t3_origuid int(11) DEFAULT '0' NOT NULL,
380 sys_language_uid int(11) DEFAULT '0' NOT NULL,
381 l10n_parent int(11) DEFAULT '0' NOT NULL,
382 l10n_diffsource mediumblob NOT NULL,
384 # Reference fields (basically same as MM table)
385 uid_local int(11) DEFAULT '0' NOT NULL,
386 uid_foreign int(11) DEFAULT '0' NOT NULL,
387 tablenames varchar(255) DEFAULT '' NOT NULL,
389 sorting_foreign int(11) DEFAULT '0' NOT NULL,
390 table_local varchar(255) DEFAULT '' NOT NULL,
392 # Local usage overlay fields
395 alternative tinytext,
397 downloadname tinytext,
400 KEY uid_local (uid_local),
401 KEY uid_foreign (uid_foreign),
407 # Table structure for table 'sys_file_collection
'
409 CREATE TABLE sys_file_collection (
410 uid int(11) NOT NULL auto_increment,
411 pid int(11) DEFAULT '0' NOT NULL,
412 tstamp int(11) DEFAULT '0' NOT NULL,
413 crdate int(11) DEFAULT '0' NOT NULL,
414 cruser_id int(11) DEFAULT '0' NOT NULL,
415 t3ver_oid int(11) DEFAULT '0' NOT NULL,
416 t3ver_id int(11) DEFAULT '0' NOT NULL,
417 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
418 t3ver_label varchar(30) DEFAULT '' NOT NULL,
419 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
420 t3ver_stage int(11) DEFAULT '0' NOT NULL,
421 t3ver_count int(11) DEFAULT '0' NOT NULL,
422 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
423 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
424 t3_origuid int(11) DEFAULT '0' NOT NULL,
425 sys_language_uid int(11) DEFAULT '0' NOT NULL,
426 l10n_parent int(11) DEFAULT '0' NOT NULL,
427 l10n_diffsource mediumtext,
428 deleted tinyint(4) DEFAULT '0' NOT NULL,
429 hidden tinyint(4) DEFAULT '0' NOT NULL,
430 starttime int(11) DEFAULT '0' NOT NULL,
431 endtime int(11) DEFAULT '0' NOT NULL,
436 type varchar(6) DEFAULT 'static' NOT NULL,
439 files int(11) DEFAULT '0' NOT NULL,
442 storage int(11) DEFAULT '0' NOT NULL,
443 folder text NOT NULL,
447 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
451 # Table structure for table 'sys_collection
'
453 CREATE TABLE sys_collection (
454 uid int(11) NOT NULL auto_increment,
455 pid int(11) DEFAULT '0' NOT NULL,
456 tstamp int(11) DEFAULT '0' NOT NULL,
457 crdate int(11) DEFAULT '0' NOT NULL,
458 cruser_id int(11) DEFAULT '0' NOT NULL,
459 t3ver_oid int(11) DEFAULT '0' NOT NULL,
460 t3ver_id int(11) DEFAULT '0' NOT NULL,
461 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
462 t3ver_label varchar(30) DEFAULT '' NOT NULL,
463 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
464 t3ver_stage int(11) DEFAULT '0' NOT NULL,
465 t3ver_count int(11) DEFAULT '0' NOT NULL,
466 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
467 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
468 t3_origuid int(11) DEFAULT '0' NOT NULL,
469 sys_language_uid int(11) DEFAULT '0' NOT NULL,
470 l10n_parent int(11) DEFAULT '0' NOT NULL,
471 l10n_diffsource mediumtext,
472 deleted tinyint(4) DEFAULT '0' NOT NULL,
473 hidden tinyint(4) DEFAULT '0' NOT NULL,
474 starttime int(11) DEFAULT '0' NOT NULL,
475 endtime int(11) DEFAULT '0' NOT NULL,
476 fe_group int(11) DEFAULT '0' NOT NULL,
480 type varchar(32) DEFAULT 'static' NOT NULL,
482 items int(11) DEFAULT '0' NOT NULL,
486 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
490 # Table structure for table 'sys_collection_entries
'
492 CREATE TABLE sys_collection_entries (
493 uid int(11) NOT NULL auto_increment,
494 uid_local int(11) DEFAULT '0' NOT NULL,
495 uid_foreign int(11) DEFAULT '0' NOT NULL,
496 tablenames varchar(30) DEFAULT '' NOT NULL,
497 sorting int(11) DEFAULT '0' NOT NULL,
499 KEY uid_local (uid_local),
500 KEY uid_foreign (uid_foreign),
505 # Table structure for table 'sys_history
'
507 CREATE TABLE sys_history (
508 uid int(11) unsigned NOT NULL auto_increment,
509 pid int(11) unsigned DEFAULT '0' NOT NULL,
510 sys_log_uid int(11) DEFAULT '0' NOT NULL,
511 history_data mediumtext,
513 recuid int(11) DEFAULT '0' NOT NULL,
514 tablename varchar(255) DEFAULT '' NOT NULL,
515 tstamp int(11) DEFAULT '0' NOT NULL,
516 history_files mediumtext,
517 snapshot int(11) DEFAULT '0' NOT NULL,
520 KEY recordident_1 (tablename,recuid),
521 KEY recordident_2 (tablename,tstamp),
522 KEY sys_log_uid (sys_log_uid)
526 # Table structure for table 'sys_lockedrecords
'
528 CREATE TABLE sys_lockedrecords (
529 uid int(11) unsigned NOT NULL auto_increment,
530 userid int(11) unsigned DEFAULT '0' NOT NULL,
531 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
532 record_table varchar(255) DEFAULT '' NOT NULL,
533 record_uid int(11) DEFAULT '0' NOT NULL,
534 record_pid int(11) DEFAULT '0' NOT NULL,
535 username varchar(50) DEFAULT '' NOT NULL,
536 feuserid int(11) unsigned DEFAULT '0' NOT NULL,
538 KEY event (userid,tstamp)
542 # Table structure for table 'sys_refindex
'
544 CREATE TABLE sys_refindex (
545 hash varchar(32) DEFAULT '' NOT NULL,
546 tablename varchar(255) DEFAULT '' NOT NULL,
547 recuid int(11) DEFAULT '0' NOT NULL,
548 field varchar(40) DEFAULT '' NOT NULL,
549 flexpointer varchar(255) DEFAULT '' NOT NULL,
550 softref_key varchar(30) DEFAULT '' NOT NULL,
551 softref_id varchar(40) DEFAULT '' NOT NULL,
552 sorting int(11) DEFAULT '0' NOT NULL,
553 deleted tinyint(1) DEFAULT '0' NOT NULL,
554 ref_table varchar(255) DEFAULT '' NOT NULL,
555 ref_uid int(11) DEFAULT '0' NOT NULL,
556 ref_string varchar(200) DEFAULT '' NOT NULL,
559 KEY lookup_rec (tablename,recuid),
560 KEY lookup_uid (ref_table,ref_uid),
561 KEY lookup_string (ref_string)
565 # Table structure for table 'sys_log
'
567 CREATE TABLE sys_log (
568 uid int(11) unsigned NOT NULL auto_increment,
569 pid int(11) unsigned DEFAULT '0' NOT NULL,
570 userid int(11) unsigned DEFAULT '0' NOT NULL,
571 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
572 recuid int(11) unsigned DEFAULT '0' NOT NULL,
573 tablename varchar(255) DEFAULT '' NOT NULL,
574 recpid int(11) DEFAULT '0' NOT NULL,
575 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
576 details text NOT NULL,
577 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
578 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
579 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
580 IP varchar(39) DEFAULT '' NOT NULL,
582 event_pid int(11) DEFAULT '-1' NOT NULL,
583 workspace int(11) DEFAULT '0' NOT NULL,
584 NEWid varchar(20) DEFAULT '' NOT NULL,
585 request_id varchar(13) DEFAULT '' NOT NULL,
586 time_micro float DEFAULT '0' NOT NULL,
587 component varchar(255) DEFAULT '' NOT NULL,
588 level tinyint(1) unsigned DEFAULT '0' NOT NULL,
593 KEY event (userid,event_pid),
594 KEY recuidIdx (recuid,uid),
595 KEY user_auth (type,action,tstamp),
596 KEY request (request_id)
600 # Table structure for table 'sys_language
'
602 CREATE TABLE sys_language (
603 uid int(11) unsigned NOT NULL auto_increment,
604 pid int(11) unsigned DEFAULT '0' NOT NULL,
605 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
606 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
607 title varchar(80) DEFAULT '' NOT NULL,
608 flag varchar(20) DEFAULT '' NOT NULL,
609 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
615 # Table structure for table 'sys_category
'
617 CREATE TABLE sys_category (
618 uid int(11) NOT NULL auto_increment,
619 pid int(11) DEFAULT '0' NOT NULL,
620 tstamp int(11) DEFAULT '0' NOT NULL,
621 crdate int(11) DEFAULT '0' NOT NULL,
622 cruser_id int(11) DEFAULT '0' NOT NULL,
623 deleted tinyint(4) DEFAULT '0' NOT NULL,
624 hidden tinyint(4) DEFAULT '0' NOT NULL,
625 starttime int(11) unsigned DEFAULT '0' NOT NULL,
626 endtime int(11) unsigned DEFAULT '0' NOT NULL,
628 t3ver_oid int(11) DEFAULT '0' NOT NULL,
629 t3ver_id int(11) DEFAULT '0' NOT NULL,
630 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
631 t3ver_label varchar(30) DEFAULT '' NOT NULL,
632 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
633 t3ver_stage int(11) DEFAULT '0' NOT NULL,
634 t3ver_count int(11) DEFAULT '0' NOT NULL,
635 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
636 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
637 t3_origuid int(11) DEFAULT '0' NOT NULL,
639 sys_language_uid int(11) DEFAULT '0' NOT NULL,
640 l10n_parent int(11) DEFAULT '0' NOT NULL,
641 l10n_diffsource mediumblob NOT NULL,
643 title tinytext NOT NULL,
644 description text NOT NULL,
645 parent int(11) DEFAULT '0' NOT NULL,
646 items int(11) DEFAULT '0' NOT NULL,
650 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
654 # Table structure for table 'sys_category_record_mm
'
656 CREATE TABLE sys_category_record_mm (
657 uid_local int(11) DEFAULT '0' NOT NULL,
658 uid_foreign int(11) DEFAULT '0' NOT NULL,
659 tablenames varchar(255) DEFAULT '' NOT NULL,
660 sorting int(11) DEFAULT '0' NOT NULL,
661 sorting_foreign int(11) DEFAULT '0' NOT NULL,
663 KEY uid_local_foreign (uid_local,uid_foreign)
664 KEY uid_foreign_tablenames (uid_foreign,tablenames)