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,
26 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
27 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
30 hide_in_lists
tinyint(4) DEFAULT '0' NOT NULL,
31 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
32 category_perms
varchar(255) DEFAULT '' 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,
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,
75 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
77 file_mountpoints
text,
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,
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 category_perms
varchar(255) DEFAULT '' NOT NULL,
92 KEY username (username
)
96 #
Table structure for table 'cache_imagesizes'
98 CREATE TABLE cache_imagesizes (
99 md5hash
varchar(32) DEFAULT '' NOT NULL,
100 md5filename
varchar(32) DEFAULT '' NOT NULL,
101 tstamp
int(11) DEFAULT '0' NOT NULL,
102 filename
varchar(255) DEFAULT '' NOT NULL,
103 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
104 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
105 PRIMARY KEY (md5filename
)
109 #
Table structure for table 'pages'
112 uid
int(11) NOT NULL auto_increment
,
113 pid
int(11) DEFAULT '0' NOT NULL,
114 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
115 t3ver_id
int(11) DEFAULT '0' NOT NULL,
116 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
117 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
118 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
119 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
120 t3ver_count
int(11) DEFAULT '0' NOT NULL,
121 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
122 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
123 t3_origuid
int(11) DEFAULT '0' NOT NULL,
124 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
125 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
126 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
127 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
128 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
129 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
130 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
131 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
132 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
133 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
134 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
135 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
136 title
varchar(255) DEFAULT '' NOT NULL,
137 doktype
int(11) unsigned
DEFAULT '0' NOT NULL,
139 storage_pid
int(11) DEFAULT '0' NOT NULL,
140 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
141 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
142 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
143 url
varchar(255) DEFAULT '' NOT NULL,
144 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
145 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
146 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
147 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
148 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
149 no_cache
int(10) unsigned
DEFAULT '0' NOT NULL,
150 fe_group
varchar(100) DEFAULT '0' NOT NULL,
151 subtitle
varchar(255) DEFAULT '' NOT NULL,
152 layout
int(11) unsigned
DEFAULT '0' NOT NULL,
153 url_scheme
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
154 target
varchar(80) DEFAULT '' NOT NULL,
156 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
158 cache_timeout
int(10) unsigned
DEFAULT '0' NOT NULL,
159 cache_tags
varchar(255) DEFAULT '' NOT NULL,
160 newUntil
int(10) unsigned
DEFAULT '0' NOT NULL,
162 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
163 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
165 module varchar(10) DEFAULT '' NOT NULL,
166 extendToSubpages
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
167 author
varchar(255) DEFAULT '' NOT NULL,
168 author_email
varchar(80) DEFAULT '' NOT NULL,
169 nav_title
varchar(255) DEFAULT '' NOT NULL,
170 nav_hide
tinyint(4) DEFAULT '0' NOT NULL,
171 content_from_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
172 mount_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
173 mount_pid_ol
tinyint(4) DEFAULT '0' NOT NULL,
174 alias varchar(32) DEFAULT '' NOT NULL,
175 l18n_cfg
tinyint(4) DEFAULT '0' NOT NULL,
176 fe_login_mode
tinyint(4) DEFAULT '0' NOT NULL,
177 backend_layout
varchar(64) DEFAULT '' NOT NULL,
178 backend_layout_next_level
varchar(64) DEFAULT '' NOT NULL,
180 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
181 KEY parent (pid
,deleted
,sorting
),
183 KEY determineSiteRoot (deleted
,hidden
,is_siteroot
)
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,
248 read_only
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
255 #
Table structure for table 'sys_file_storage'
257 CREATE TABLE sys_file_storage (
258 uid
int(11) NOT NULL auto_increment
,
259 pid
int(11) DEFAULT '0' NOT NULL,
260 tstamp
int(11) DEFAULT '0' NOT NULL,
261 crdate
int(11) DEFAULT '0' NOT NULL,
262 cruser_id
int(11) DEFAULT '0' NOT NULL,
263 deleted
tinyint(4) DEFAULT '0' NOT NULL,
264 hidden
tinyint(4) DEFAULT '0' NOT NULL,
266 name varchar(30) DEFAULT '' NOT NULL,
270 is_default
tinyint(4) DEFAULT '0' NOT NULL,
271 is_browsable
tinyint(4) DEFAULT '0' NOT NULL,
272 is_public
tinyint(4) DEFAULT '0' NOT NULL,
273 is_writable
tinyint(4) DEFAULT '0' NOT NULL,
274 is_online
tinyint(4) DEFAULT '1' NOT NULL,
275 processingfolder tinytext
,
278 KEY parent (pid
,deleted
),
279 KEY deleted_hidden (deleted
,hidden
)
283 #
Table structure for table 'sys_file'
285 CREATE TABLE sys_file (
286 uid
int(11) NOT NULL auto_increment
,
287 pid
int(11) DEFAULT '0' NOT NULL,
288 #
update timestamp of the
database record
, not the
file!
289 tstamp
int(11) DEFAULT '0' NOT NULL,
290 last_indexed
int(11) DEFAULT '0' NOT NULL,
292 # management information
293 missing
tinyint(4) DEFAULT '0' NOT NULL,
294 storage int(11) DEFAULT '0' NOT NULL,
295 type varchar(10) DEFAULT '' NOT NULL,
296 metadata
int(11) DEFAULT '0' NOT NULL,
300 identifier_hash
char(40) DEFAULT '' NOT NULL,
301 folder_hash
char(40) DEFAULT '' NOT NULL,
302 extension
varchar(255) DEFAULT '' NOT NULL,
303 mime_type
varchar(255) DEFAULT '' NOT NULL,
305 sha1
char(40) DEFAULT '' NOT NULL,
306 size bigint(20) unsigned
DEFAULT '0' NOT NULL,
307 creation_date
int(11) DEFAULT '0' NOT NULL,
308 modification_date
int(11) DEFAULT '0' NOT NULL,
311 KEY sel01 (storage,identifier_hash
),
312 KEY folder (storage,folder_hash
),
314 KEY lastindex (last_indexed
),
319 #
Table structure for table 'sys_file_metadata'
321 CREATE TABLE sys_file_metadata (
322 uid
int(11) NOT NULL auto_increment
,
323 pid
int(11) DEFAULT '0' NOT NULL,
324 tstamp
int(11) DEFAULT '0' NOT NULL,
325 crdate
int(11) DEFAULT '0' NOT NULL,
326 cruser_id
int(11) DEFAULT '0' NOT NULL,
329 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
330 l10n_parent
int(11) DEFAULT '0' NOT NULL,
331 l10n_diffsource mediumblob
NOT NULL,
334 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
335 t3ver_id
int(11) DEFAULT '0' NOT NULL,
336 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
337 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
338 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
339 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
340 t3ver_count
int(11) DEFAULT '0' NOT NULL,
341 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
342 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
343 t3_origuid
int(11) DEFAULT '0' NOT NULL,
345 file int(11) DEFAULT '0' NOT NULL,
347 width
int(11) DEFAULT '0' NOT NULL,
348 height
int(11) DEFAULT '0' NOT NULL,
354 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
355 KEY fal_filelist (l10n_parent
,sys_language_uid
)
360 #
Table structure for table 'sys_file_processedfile'.
361 # which
is a
"temporary" file, like an image preview
362 # This
table does
not have a TCA representation
, as it
is only written
363 #
to using direct
SQL queries
in the code
365 CREATE TABLE sys_file_processedfile (
366 uid
int(11) NOT NULL auto_increment
,
367 tstamp
int(11) DEFAULT '0' NOT NULL,
368 crdate
int(11) DEFAULT '0' NOT NULL,
370 storage int(11) DEFAULT '0' NOT NULL,
371 original
int(11) DEFAULT '0' NOT NULL,
372 identifier
varchar(512) DEFAULT '' NOT NULL,
375 configurationsha1
char(40) DEFAULT '' NOT NULL,
376 originalfilesha1
char(40) DEFAULT '' NOT NULL,
377 task_type
varchar(200) DEFAULT '' NOT NULL,
378 checksum
varchar(255) DEFAULT '' NOT NULL,
379 width
int(11) DEFAULT '0',
380 height
int(11) DEFAULT '0',
383 KEY combined_1 (original
,task_type
,configurationsha1
),
384 KEY identifier (storage,identifier(199))
388 #
Table structure for table 'sys_file_reference'
389 # which
is one
usage of a
file with overloaded metadata
391 CREATE TABLE sys_file_reference (
392 uid
int(11) NOT NULL auto_increment
,
393 pid
int(11) DEFAULT '0' NOT NULL,
394 tstamp
int(11) DEFAULT '0' NOT NULL,
395 crdate
int(11) DEFAULT '0' NOT NULL,
396 cruser_id
int(11) DEFAULT '0' NOT NULL,
397 sorting
int(10) DEFAULT '0' NOT NULL,
398 deleted
tinyint(4) DEFAULT '0' NOT NULL,
399 hidden
tinyint(4) DEFAULT '0' NOT NULL,
402 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
403 t3ver_id
int(11) DEFAULT '0' NOT NULL,
404 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
405 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
406 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
407 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
408 t3ver_count
int(11) DEFAULT '0' NOT NULL,
409 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
410 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
411 t3_origuid
int(11) DEFAULT '0' NOT NULL,
414 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
415 l10n_parent
int(11) DEFAULT '0' NOT NULL,
416 l10n_diffsource mediumblob
NOT NULL,
418 # Reference
fields (basically same
as MM
table)
419 uid_local
int(11) DEFAULT '0' NOT NULL,
420 uid_foreign
int(11) DEFAULT '0' NOT NULL,
421 tablenames
varchar(64) DEFAULT '' NOT NULL,
422 fieldname
varchar(64) DEFAULT '' NOT NULL,
423 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
424 table_local
varchar(64) DEFAULT '' NOT NULL,
426 #
Local usage overlay fields
429 alternative tinytext
,
430 link varchar(1024) DEFAULT '' NOT NULL,
431 downloadname tinytext
,
434 KEY parent (pid
,deleted
),
435 KEY tablenames_fieldname (tablenames(32),fieldname(12)),
436 KEY deleted (deleted
),
437 KEY uid_foreign (uid_foreign
)
442 #
Table structure for table 'sys_file_collection'
444 CREATE TABLE sys_file_collection (
445 uid
int(11) NOT NULL auto_increment
,
446 pid
int(11) DEFAULT '0' NOT NULL,
447 tstamp
int(11) DEFAULT '0' NOT NULL,
448 crdate
int(11) DEFAULT '0' NOT NULL,
449 cruser_id
int(11) DEFAULT '0' NOT NULL,
450 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
451 t3ver_id
int(11) DEFAULT '0' NOT NULL,
452 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
453 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
454 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
455 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
456 t3ver_count
int(11) DEFAULT '0' NOT NULL,
457 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
458 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
459 t3_origuid
int(11) DEFAULT '0' NOT NULL,
460 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
461 l10n_parent
int(11) DEFAULT '0' NOT NULL,
462 l10n_diffsource mediumtext
,
463 deleted
tinyint(4) DEFAULT '0' NOT NULL,
464 hidden
tinyint(4) DEFAULT '0' NOT NULL,
465 starttime
int(11) DEFAULT '0' NOT NULL,
466 endtime
int(11) DEFAULT '0' NOT NULL,
471 type varchar(30) DEFAULT 'static' NOT NULL,
474 files
int(11) DEFAULT '0' NOT NULL,
477 storage int(11) DEFAULT '0' NOT NULL,
478 folder
text NOT NULL,
481 category
int(11) DEFAULT '0' NOT NULL,
484 KEY parent (pid
,deleted
),
485 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)
489 #
Table structure for table 'sys_collection'
491 CREATE TABLE sys_collection (
492 uid
int(11) NOT NULL auto_increment
,
493 pid
int(11) DEFAULT '0' NOT NULL,
494 tstamp
int(11) DEFAULT '0' NOT NULL,
495 crdate
int(11) DEFAULT '0' NOT NULL,
496 cruser_id
int(11) DEFAULT '0' NOT NULL,
497 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
498 t3ver_id
int(11) DEFAULT '0' NOT NULL,
499 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
500 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
501 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
502 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
503 t3ver_count
int(11) DEFAULT '0' NOT NULL,
504 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
505 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
506 t3_origuid
int(11) DEFAULT '0' NOT NULL,
507 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
508 l10n_parent
int(11) DEFAULT '0' NOT NULL,
509 l10n_diffsource mediumtext
,
510 deleted
tinyint(4) DEFAULT '0' NOT NULL,
511 hidden
tinyint(4) DEFAULT '0' NOT NULL,
512 starttime
int(11) DEFAULT '0' NOT NULL,
513 endtime
int(11) DEFAULT '0' NOT NULL,
514 fe_group
int(11) DEFAULT '0' NOT NULL,
518 type varchar(32) DEFAULT 'static' NOT NULL,
520 items
int(11) DEFAULT '0' NOT NULL,
523 KEY parent (pid
,deleted
),
524 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)
528 #
Table structure for table 'sys_collection_entries'
530 CREATE TABLE sys_collection_entries (
531 uid
int(11) NOT NULL auto_increment
,
532 uid_local
int(11) DEFAULT '0' NOT NULL,
533 uid_foreign
int(11) DEFAULT '0' NOT NULL,
534 tablenames
varchar(64) DEFAULT '' NOT NULL,
535 sorting
int(11) DEFAULT '0' NOT NULL,
537 KEY uid_local (uid_local
),
538 KEY uid_foreign (uid_foreign
),
543 #
Table structure for table 'sys_history'
545 CREATE TABLE sys_history (
546 uid
int(11) unsigned
NOT NULL auto_increment
,
547 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
548 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
549 history_data mediumtext
,
551 recuid
int(11) DEFAULT '0' NOT NULL,
552 tablename
varchar(255) DEFAULT '' NOT NULL,
553 tstamp
int(11) DEFAULT '0' NOT NULL,
554 history_files mediumtext
,
555 snapshot
int(11) DEFAULT '0' NOT NULL,
558 KEY recordident_1 (tablename
,recuid
),
559 KEY recordident_2 (tablename
,tstamp
),
560 KEY sys_log_uid (sys_log_uid
)
564 #
Table structure for table 'sys_lockedrecords'
566 CREATE TABLE sys_lockedrecords (
567 uid
int(11) unsigned
NOT NULL auto_increment
,
568 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
569 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
570 record_table
varchar(255) DEFAULT '' NOT NULL,
571 record_uid
int(11) DEFAULT '0' NOT NULL,
572 record_pid
int(11) DEFAULT '0' NOT NULL,
573 username
varchar(50) DEFAULT '' NOT NULL,
574 feuserid
int(11) unsigned
DEFAULT '0' NOT NULL,
576 KEY event (userid
,tstamp
)
580 #
Table structure for table 'sys_refindex'
582 CREATE TABLE sys_refindex (
583 hash
varchar(32) DEFAULT '' NOT NULL,
584 tablename
varchar(255) DEFAULT '' NOT NULL,
585 recuid
int(11) DEFAULT '0' NOT NULL,
586 field
varchar(40) DEFAULT '' NOT NULL,
587 flexpointer
varchar(255) DEFAULT '' NOT NULL,
588 softref_key
varchar(30) DEFAULT '' NOT NULL,
589 softref_id
varchar(40) DEFAULT '' NOT NULL,
590 sorting
int(11) DEFAULT '0' NOT NULL,
591 deleted
tinyint(1) DEFAULT '0' NOT NULL,
592 workspace
int(11) DEFAULT '0' NOT NULL,
593 ref_table
varchar(255) DEFAULT '' NOT NULL,
594 ref_uid
int(11) DEFAULT '0' NOT NULL,
595 ref_string
varchar(200) DEFAULT '' NOT NULL,
598 KEY lookup_rec (tablename
,recuid
),
599 KEY lookup_uid (ref_table
,ref_uid
),
600 KEY lookup_string (ref_string
)
604 #
Table structure for table 'sys_log'
606 CREATE TABLE sys_log (
607 uid
int(11) unsigned
NOT NULL auto_increment
,
608 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
609 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
610 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
611 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
612 tablename
varchar(255) DEFAULT '' NOT NULL,
613 recpid
int(11) DEFAULT '0' NOT NULL,
614 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
615 details
text NOT NULL,
616 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
617 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
618 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
619 IP
varchar(39) DEFAULT '' NOT NULL,
621 event_pid
int(11) DEFAULT '-1' NOT NULL,
622 workspace
int(11) DEFAULT '0' NOT NULL,
623 NEWid
varchar(20) DEFAULT '' NOT NULL,
624 request_id
varchar(13) DEFAULT '' NOT NULL,
625 time_micro
float DEFAULT '0' NOT NULL,
626 component
varchar(255) DEFAULT '' NOT NULL,
627 level tinyint(1) unsigned
DEFAULT '0' NOT NULL,
632 KEY event (userid
,event_pid
),
633 KEY recuidIdx (recuid
,uid
),
634 KEY user_auth (type,action,tstamp
),
635 KEY request (request_id
)
639 #
Table structure for table 'sys_language'
641 CREATE TABLE sys_language (
642 uid
int(11) unsigned
NOT NULL auto_increment
,
643 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
644 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
645 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
646 title
varchar(80) DEFAULT '' NOT NULL,
647 flag varchar(20) DEFAULT '' NOT NULL,
648 language_isocode
varchar(2) DEFAULT '' NOT NULL,
649 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,
655 #
Table structure for table 'sys_category'
657 CREATE TABLE sys_category (
658 uid
int(11) NOT NULL auto_increment
,
659 pid
int(11) DEFAULT '0' NOT NULL,
660 tstamp
int(11) DEFAULT '0' NOT NULL,
661 crdate
int(11) DEFAULT '0' NOT NULL,
662 cruser_id
int(11) DEFAULT '0' NOT NULL,
663 deleted
tinyint(4) DEFAULT '0' NOT NULL,
664 hidden
tinyint(4) DEFAULT '0' NOT NULL,
665 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
666 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
668 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
669 t3ver_id
int(11) DEFAULT '0' NOT NULL,
670 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
671 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
672 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
673 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
674 t3ver_count
int(11) DEFAULT '0' NOT NULL,
675 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
676 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
677 t3_origuid
int(11) DEFAULT '0' NOT NULL,
678 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
680 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
681 l10n_parent
int(11) DEFAULT '0' NOT NULL,
682 l10n_diffsource mediumblob
NOT NULL,
684 title tinytext
NOT NULL,
685 description
text NOT NULL,
686 parent
int(11) DEFAULT '0' NOT NULL,
687 items
int(11) DEFAULT '0' NOT NULL,
691 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
692 KEY category_parent (parent
),
693 KEY category_list (pid
,deleted
,sys_language_uid
)
697 #
Table structure for table 'sys_category_record_mm'
699 CREATE TABLE sys_category_record_mm (
700 uid_local
int(11) DEFAULT '0' NOT NULL,
701 uid_foreign
int(11) DEFAULT '0' NOT NULL,
702 tablenames
varchar(255) DEFAULT '' NOT NULL,
703 fieldname
varchar(255) DEFAULT '' NOT NULL,
704 sorting
int(11) DEFAULT '0' NOT NULL,
705 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
707 KEY uid_local_foreign (uid_local
,uid_foreign
),
708 KEY uid_foreign_tablenames (uid_foreign
,tablenames
)