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,
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
text,
23 file_permissions
text,
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,
31 hide_in_lists
tinyint(4) DEFAULT '0' NOT NULL,
32 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
33 category_perms
varchar(255) DEFAULT '' NOT NULL,
39 #
Table structure for table 'be_sessions'
41 CREATE TABLE be_sessions (
42 ses_id
varchar(32) DEFAULT '' NOT NULL,
43 ses_name
varchar(32) DEFAULT '' NOT NULL,
44 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
45 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
46 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
47 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
49 ses_backuserid
int(11) NOT NULL default '0',
50 PRIMARY KEY (ses_id
,ses_name
),
51 KEY ses_tstamp (ses_tstamp
)
55 #
Table structure for table 'be_users'
57 CREATE TABLE be_users (
58 uid
int(11) unsigned
NOT NULL auto_increment
,
59 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
60 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
61 username
varchar(50) DEFAULT '' NOT NULL,
62 password varchar(100) DEFAULT '' NOT NULL,
63 admin tinyint(4) unsigned
DEFAULT '0' NOT NULL,
64 usergroup
varchar(255) DEFAULT '' NOT NULL,
65 disable tinyint(1) unsigned
DEFAULT '0' NOT NULL,
66 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
67 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
68 lang
char(2) DEFAULT '' NOT NULL,
69 email
varchar(80) DEFAULT '' NOT NULL,
71 options tinyint(4) unsigned
DEFAULT '0' NOT NULL,
72 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
73 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
74 realName
varchar(80) DEFAULT '' NOT NULL,
76 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
78 file_mountpoints
text,
79 file_permissions
text,
80 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
81 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
82 disableIPlock
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
83 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
85 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
86 createdByAction
int(11) DEFAULT '0' NOT NULL,
87 usergroup_cached_list
text,
88 workspace_id
int(11) DEFAULT '0' NOT NULL,
89 workspace_preview
tinyint(3) DEFAULT '1' NOT NULL,
90 category_perms
varchar(255) DEFAULT '' NOT NULL,
93 KEY username (username
)
97 #
Table structure for table 'cache_imagesizes'
99 CREATE TABLE cache_imagesizes (
100 md5hash
varchar(32) DEFAULT '' NOT NULL,
101 md5filename
varchar(32) DEFAULT '' NOT NULL,
102 tstamp
int(11) DEFAULT '0' NOT NULL,
103 filename
varchar(255) DEFAULT '' NOT NULL,
104 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
105 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
106 PRIMARY KEY (md5filename
)
110 #
Table structure for table 'pages'
113 uid
int(11) NOT NULL auto_increment
,
114 pid
int(11) DEFAULT '0' NOT NULL,
115 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
116 t3ver_id
int(11) DEFAULT '0' NOT NULL,
117 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
118 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
119 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
120 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
121 t3ver_count
int(11) DEFAULT '0' NOT NULL,
122 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
123 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
124 t3_origuid
int(11) DEFAULT '0' NOT NULL,
125 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
126 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
127 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
128 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
129 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
130 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
131 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
132 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
133 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
134 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
135 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
136 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
137 title
varchar(255) DEFAULT '' NOT NULL,
138 doktype
int(11) unsigned
DEFAULT '0' NOT NULL,
140 storage_pid
int(11) DEFAULT '0' NOT NULL,
141 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
142 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
143 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
144 url
varchar(255) DEFAULT '' NOT NULL,
145 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
146 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
147 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
148 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
149 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
150 no_cache
int(10) unsigned
DEFAULT '0' NOT NULL,
151 fe_group
varchar(100) DEFAULT '0' NOT NULL,
152 subtitle
varchar(255) DEFAULT '' NOT NULL,
153 layout
int(11) unsigned
DEFAULT '0' NOT NULL,
154 url_scheme
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
155 target
varchar(80) DEFAULT '' NOT NULL,
157 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
159 cache_timeout
int(10) unsigned
DEFAULT '0' NOT NULL,
160 cache_tags
varchar(255) DEFAULT '' NOT NULL,
161 newUntil
int(10) unsigned
DEFAULT '0' NOT NULL,
163 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
164 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
166 module varchar(10) DEFAULT '' NOT NULL,
167 extendToSubpages
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
168 author
varchar(255) DEFAULT '' NOT NULL,
169 author_email
varchar(80) DEFAULT '' NOT NULL,
170 nav_title
varchar(255) DEFAULT '' NOT NULL,
171 nav_hide
tinyint(4) DEFAULT '0' NOT NULL,
172 content_from_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
173 mount_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
174 mount_pid_ol
tinyint(4) DEFAULT '0' NOT NULL,
175 alias varchar(32) DEFAULT '' NOT NULL,
176 l18n_cfg
tinyint(4) DEFAULT '0' NOT NULL,
177 fe_login_mode
tinyint(4) DEFAULT '0' NOT NULL,
178 backend_layout
varchar(64) DEFAULT '' NOT NULL,
179 backend_layout_next_level
varchar(64) DEFAULT '' NOT NULL,
181 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
182 KEY parent (pid
,deleted
,sorting
),
187 #
Table structure for table 'sys_registry'
189 CREATE TABLE sys_registry (
190 uid
int(11) unsigned
NOT NULL auto_increment
,
191 entry_namespace
varchar(128) DEFAULT '' NOT NULL,
192 entry_key
varchar(128) DEFAULT '' NOT NULL,
195 UNIQUE KEY entry_identifier (entry_namespace
,entry_key
)
199 #
Table structure for table 'sys_be_shortcuts'
201 CREATE TABLE sys_be_shortcuts (
202 uid
int(11) unsigned
NOT NULL auto_increment
,
203 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
204 module_name
varchar(255) DEFAULT '' NOT NULL,
206 description
varchar(255) DEFAULT '' NOT NULL,
207 sorting
int(11) DEFAULT '0' NOT NULL,
208 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
215 #
Table structure for table 'sys_news'
217 CREATE TABLE sys_news (
218 uid
int(11) unsigned
NOT NULL auto_increment
,
219 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
220 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
221 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
222 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
223 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
224 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
225 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
226 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
227 title
varchar(255) DEFAULT '' NOT NULL,
236 #
Table structure for table 'sys_filemounts'
238 CREATE TABLE sys_filemounts (
239 uid
int(11) unsigned
NOT NULL auto_increment
,
240 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
241 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
242 title
varchar(30) DEFAULT '' NOT NULL,
243 path varchar(120) DEFAULT '' NOT NULL,
244 base
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
245 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
246 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
247 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
254 #
Table structure for table 'sys_file_storage'
256 CREATE TABLE sys_file_storage (
257 uid
int(11) NOT NULL auto_increment
,
258 pid
int(11) DEFAULT '0' NOT NULL,
259 tstamp
int(11) DEFAULT '0' NOT NULL,
260 crdate
int(11) DEFAULT '0' NOT NULL,
261 cruser_id
int(11) DEFAULT '0' NOT NULL,
262 deleted
tinyint(4) DEFAULT '0' NOT NULL,
263 hidden
tinyint(4) DEFAULT '0' NOT NULL,
265 name varchar(30) DEFAULT '' NOT NULL,
269 is_browsable
tinyint(4) DEFAULT '0' NOT NULL,
270 is_public
tinyint(4) DEFAULT '0' NOT NULL,
271 is_writable
tinyint(4) DEFAULT '0' NOT NULL,
272 is_online
tinyint(4) DEFAULT '1' NOT NULL,
273 processingfolder tinytext
,
276 KEY parent (pid
,deleted
),
277 KEY deleted_hidden (deleted
,hidden
)
281 #
Table structure for table 'sys_file'
283 CREATE TABLE sys_file (
284 uid
int(11) NOT NULL auto_increment
,
285 pid
int(11) DEFAULT '0' NOT NULL,
286 #
update timestamp of the
database record
, not the
file!
287 tstamp
int(11) DEFAULT '0' NOT NULL,
288 last_indexed
int(11) DEFAULT '0' NOT NULL,
290 # management information
291 missing
tinyint(4) DEFAULT '0' NOT NULL,
292 storage int(11) DEFAULT '0' NOT NULL,
293 type varchar(10) DEFAULT '' NOT NULL,
294 metadata
int(11) DEFAULT '0' NOT NULL,
298 identifier_hash
varchar(40) DEFAULT '' NOT NULL,
299 folder_hash
varchar(40) DEFAULT '' NOT NULL,
300 extension
varchar(255) DEFAULT '' NOT NULL,
301 mime_type
varchar(255) DEFAULT '' NOT NULL,
304 size int(11) DEFAULT '0' NOT NULL,
305 creation_date
int(11) DEFAULT '0' NOT NULL,
306 modification_date
int(11) DEFAULT '0' NOT NULL,
309 KEY sel01 (storage,identifier_hash
),
310 KEY folder (storage,folder_hash
),
312 KEY lastindex (last_indexed
),
317 #
Table structure for table 'sys_file_metadata'
319 CREATE TABLE sys_file_metadata (
320 uid
int(11) NOT NULL auto_increment
,
321 pid
int(11) DEFAULT '0' NOT NULL,
322 tstamp
int(11) DEFAULT '0' NOT NULL,
323 crdate
int(11) DEFAULT '0' NOT NULL,
324 cruser_id
int(11) DEFAULT '0' NOT NULL,
327 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
328 l10n_parent
int(11) DEFAULT '0' NOT NULL,
329 l10n_diffsource mediumblob
NOT NULL,
332 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
333 t3ver_id
int(11) DEFAULT '0' NOT NULL,
334 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
335 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
336 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
337 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
338 t3ver_count
int(11) DEFAULT '0' NOT NULL,
339 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
340 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
341 t3_origuid
int(11) DEFAULT '0' NOT NULL,
343 file int(11) DEFAULT '0' NOT NULL,
345 width
int(11) DEFAULT '0' NOT NULL,
346 height
int(11) DEFAULT '0' NOT NULL,
352 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
353 KEY fal_filelist (l10n_parent
,sys_language_uid
),
358 #
Table structure for table 'sys_file_processedfile'.
359 # which
is a
"temporary" file, like an image preview
360 # This
table does
not have a TCA representation
, as it
is only written
361 #
to using direct
SQL queries
in the code
363 CREATE TABLE sys_file_processedfile (
364 uid
int(11) NOT NULL auto_increment
,
365 tstamp
int(11) DEFAULT '0' NOT NULL,
366 crdate
int(11) DEFAULT '0' NOT NULL,
368 storage int(11) DEFAULT '0' NOT NULL,
369 original
int(11) DEFAULT '0' NOT NULL,
370 identifier
varchar(512) DEFAULT '' NOT NULL,
373 configurationsha1
varchar(40) DEFAULT '' NOT NULL,
374 originalfilesha1
varchar(40) DEFAULT '' NOT NULL,
375 task_type
varchar(200) DEFAULT '' NOT NULL,
376 checksum
varchar(255) DEFAULT '' NOT NULL,
377 width
int(11) DEFAULT '0',
378 height
int(11) DEFAULT '0',
381 KEY combined_1 (original
,task_type
,configurationsha1
)
385 #
Table structure for table 'sys_file_reference'
386 # which
is one
usage of a
file with overloaded metadata
388 CREATE TABLE sys_file_reference (
389 uid
int(11) NOT NULL auto_increment
,
390 pid
int(11) DEFAULT '0' NOT NULL,
391 tstamp
int(11) DEFAULT '0' NOT NULL,
392 crdate
int(11) DEFAULT '0' NOT NULL,
393 cruser_id
int(11) DEFAULT '0' NOT NULL,
394 sorting
int(10) DEFAULT '0' NOT NULL,
395 deleted
tinyint(4) DEFAULT '0' NOT NULL,
396 hidden
tinyint(4) DEFAULT '0' NOT NULL,
399 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
400 t3ver_id
int(11) DEFAULT '0' NOT NULL,
401 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
402 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
403 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
404 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
405 t3ver_count
int(11) DEFAULT '0' NOT NULL,
406 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
407 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
408 t3_origuid
int(11) DEFAULT '0' NOT NULL,
411 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
412 l10n_parent
int(11) DEFAULT '0' NOT NULL,
413 l10n_diffsource mediumblob
NOT NULL,
415 # Reference
fields (basically same
as MM
table)
416 uid_local
int(11) DEFAULT '0' NOT NULL,
417 uid_foreign
int(11) DEFAULT '0' NOT NULL,
418 tablenames
varchar(64) DEFAULT '' NOT NULL,
419 fieldname
varchar(64) DEFAULT '' NOT NULL,
420 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
421 table_local
varchar(64) DEFAULT '' NOT NULL,
423 #
Local usage overlay fields
426 alternative tinytext
,
428 downloadname tinytext
,
431 KEY parent (pid
,deleted
),
432 KEY tablenames_fieldname (tablenames(32),fieldname(12)),
433 KEY deleted (deleted
),
434 KEY uid_foreign (uid_foreign
)
439 #
Table structure for table 'sys_file_collection'
441 CREATE TABLE sys_file_collection (
442 uid
int(11) NOT NULL auto_increment
,
443 pid
int(11) DEFAULT '0' NOT NULL,
444 tstamp
int(11) DEFAULT '0' NOT NULL,
445 crdate
int(11) DEFAULT '0' NOT NULL,
446 cruser_id
int(11) DEFAULT '0' NOT NULL,
447 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
448 t3ver_id
int(11) DEFAULT '0' NOT NULL,
449 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
450 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
451 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
452 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
453 t3ver_count
int(11) DEFAULT '0' NOT NULL,
454 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
455 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
456 t3_origuid
int(11) DEFAULT '0' NOT NULL,
457 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
458 l10n_parent
int(11) DEFAULT '0' NOT NULL,
459 l10n_diffsource mediumtext
,
460 deleted
tinyint(4) DEFAULT '0' NOT NULL,
461 hidden
tinyint(4) DEFAULT '0' NOT NULL,
462 starttime
int(11) DEFAULT '0' NOT NULL,
463 endtime
int(11) DEFAULT '0' NOT NULL,
468 type varchar(30) DEFAULT 'static' NOT NULL,
471 files
int(11) DEFAULT '0' NOT NULL,
474 storage int(11) DEFAULT '0' NOT NULL,
475 folder
text NOT NULL,
478 category
int(11) DEFAULT '0' NOT NULL,
481 KEY parent (pid
,deleted
),
482 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)
486 #
Table structure for table 'sys_collection'
488 CREATE TABLE sys_collection (
489 uid
int(11) NOT NULL auto_increment
,
490 pid
int(11) DEFAULT '0' NOT NULL,
491 tstamp
int(11) DEFAULT '0' NOT NULL,
492 crdate
int(11) DEFAULT '0' NOT NULL,
493 cruser_id
int(11) DEFAULT '0' NOT NULL,
494 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
495 t3ver_id
int(11) DEFAULT '0' NOT NULL,
496 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
497 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
498 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
499 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
500 t3ver_count
int(11) DEFAULT '0' NOT NULL,
501 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
502 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
503 t3_origuid
int(11) DEFAULT '0' NOT NULL,
504 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
505 l10n_parent
int(11) DEFAULT '0' NOT NULL,
506 l10n_diffsource mediumtext
,
507 deleted
tinyint(4) DEFAULT '0' NOT NULL,
508 hidden
tinyint(4) DEFAULT '0' NOT NULL,
509 starttime
int(11) DEFAULT '0' NOT NULL,
510 endtime
int(11) DEFAULT '0' NOT NULL,
511 fe_group
int(11) DEFAULT '0' NOT NULL,
515 type varchar(32) DEFAULT 'static' NOT NULL,
517 items
int(11) DEFAULT '0' NOT NULL,
520 KEY parent (pid
,deleted
),
521 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)
525 #
Table structure for table 'sys_collection_entries'
527 CREATE TABLE sys_collection_entries (
528 uid
int(11) NOT NULL auto_increment
,
529 uid_local
int(11) DEFAULT '0' NOT NULL,
530 uid_foreign
int(11) DEFAULT '0' NOT NULL,
531 tablenames
varchar(30) DEFAULT '' NOT NULL,
532 sorting
int(11) DEFAULT '0' NOT NULL,
534 KEY uid_local (uid_local
),
535 KEY uid_foreign (uid_foreign
),
540 #
Table structure for table 'sys_history'
542 CREATE TABLE sys_history (
543 uid
int(11) unsigned
NOT NULL auto_increment
,
544 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
545 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
546 history_data mediumtext
,
548 recuid
int(11) DEFAULT '0' NOT NULL,
549 tablename
varchar(255) DEFAULT '' NOT NULL,
550 tstamp
int(11) DEFAULT '0' NOT NULL,
551 history_files mediumtext
,
552 snapshot
int(11) DEFAULT '0' NOT NULL,
555 KEY recordident_1 (tablename
,recuid
),
556 KEY recordident_2 (tablename
,tstamp
),
557 KEY sys_log_uid (sys_log_uid
)
561 #
Table structure for table 'sys_lockedrecords'
563 CREATE TABLE sys_lockedrecords (
564 uid
int(11) unsigned
NOT NULL auto_increment
,
565 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
566 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
567 record_table
varchar(255) DEFAULT '' NOT NULL,
568 record_uid
int(11) DEFAULT '0' NOT NULL,
569 record_pid
int(11) DEFAULT '0' NOT NULL,
570 username
varchar(50) DEFAULT '' NOT NULL,
571 feuserid
int(11) unsigned
DEFAULT '0' NOT NULL,
573 KEY event (userid
,tstamp
)
577 #
Table structure for table 'sys_refindex'
579 CREATE TABLE sys_refindex (
580 hash
varchar(32) DEFAULT '' NOT NULL,
581 tablename
varchar(255) DEFAULT '' NOT NULL,
582 recuid
int(11) DEFAULT '0' NOT NULL,
583 field
varchar(40) DEFAULT '' NOT NULL,
584 flexpointer
varchar(255) DEFAULT '' NOT NULL,
585 softref_key
varchar(30) DEFAULT '' NOT NULL,
586 softref_id
varchar(40) DEFAULT '' NOT NULL,
587 sorting
int(11) DEFAULT '0' NOT NULL,
588 deleted
tinyint(1) DEFAULT '0' NOT NULL,
589 ref_table
varchar(255) DEFAULT '' NOT NULL,
590 ref_uid
int(11) DEFAULT '0' NOT NULL,
591 ref_string
varchar(200) DEFAULT '' NOT NULL,
594 KEY lookup_rec (tablename
,recuid
),
595 KEY lookup_uid (ref_table
,ref_uid
),
596 KEY lookup_string (ref_string
)
600 #
Table structure for table 'sys_log'
602 CREATE TABLE sys_log (
603 uid
int(11) unsigned
NOT NULL auto_increment
,
604 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
605 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
606 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
607 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
608 tablename
varchar(255) DEFAULT '' NOT NULL,
609 recpid
int(11) DEFAULT '0' NOT NULL,
610 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
611 details
text NOT NULL,
612 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
613 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
614 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
615 IP
varchar(39) DEFAULT '' NOT NULL,
617 event_pid
int(11) DEFAULT '-1' NOT NULL,
618 workspace
int(11) DEFAULT '0' NOT NULL,
619 NEWid
varchar(20) DEFAULT '' NOT NULL,
620 request_id
varchar(13) DEFAULT '' NOT NULL,
621 time_micro
float DEFAULT '0' NOT NULL,
622 component
varchar(255) DEFAULT '' NOT NULL,
623 level tinyint(1) unsigned
DEFAULT '0' NOT NULL,
628 KEY event (userid
,event_pid
),
629 KEY recuidIdx (recuid
,uid
),
630 KEY user_auth (type,action,tstamp
),
631 KEY request (request_id
)
635 #
Table structure for table 'sys_language'
637 CREATE TABLE sys_language (
638 uid
int(11) unsigned
NOT NULL auto_increment
,
639 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
640 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
641 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
642 title
varchar(80) DEFAULT '' NOT NULL,
643 flag varchar(20) DEFAULT '' NOT NULL,
644 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,
650 #
Table structure for table 'sys_category'
652 CREATE TABLE sys_category (
653 uid
int(11) NOT NULL auto_increment
,
654 pid
int(11) DEFAULT '0' NOT NULL,
655 tstamp
int(11) DEFAULT '0' NOT NULL,
656 crdate
int(11) DEFAULT '0' NOT NULL,
657 cruser_id
int(11) DEFAULT '0' NOT NULL,
658 deleted
tinyint(4) DEFAULT '0' NOT NULL,
659 hidden
tinyint(4) DEFAULT '0' NOT NULL,
660 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
661 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
663 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
664 t3ver_id
int(11) DEFAULT '0' NOT NULL,
665 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
666 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
667 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
668 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
669 t3ver_count
int(11) DEFAULT '0' NOT NULL,
670 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
671 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
672 t3_origuid
int(11) DEFAULT '0' NOT NULL,
673 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
675 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
676 l10n_parent
int(11) DEFAULT '0' NOT NULL,
677 l10n_diffsource mediumblob
NOT NULL,
679 title tinytext
NOT NULL,
680 description
text NOT NULL,
681 parent
int(11) DEFAULT '0' NOT NULL,
682 items
int(11) DEFAULT '0' NOT NULL,
686 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
687 KEY category_parent (parent
),
688 KEY category_list (pid
,deleted
,sys_language_uid
),
692 #
Table structure for table 'sys_category_record_mm'
694 CREATE TABLE sys_category_record_mm (
695 uid_local
int(11) DEFAULT '0' NOT NULL,
696 uid_foreign
int(11) DEFAULT '0' NOT NULL,
697 tablenames
varchar(255) DEFAULT '' NOT NULL,
698 fieldname
varchar(255) DEFAULT '' NOT NULL,
699 sorting
int(11) DEFAULT '0' NOT NULL,
700 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
702 KEY uid_local_foreign (uid_local
,uid_foreign
),
703 KEY uid_foreign_tablenames (uid_foreign
,tablenames
)