2 #
Table structure for table 'be_groups'
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,
14 pagetypes_select
varchar(255) DEFAULT '' NOT NULL,
17 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
18 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
20 file_mountpoints
text,
21 file_permissions
text,
22 hidden
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
23 description
varchar(2000) DEFAULT '' NOT NULL,
24 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
25 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
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,
36 #
Table structure for table 'be_sessions'
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,
46 ses_backuserid
int(11) NOT NULL default '0',
47 PRIMARY KEY (ses_id
,ses_name
),
48 KEY ses_tstamp (ses_tstamp
)
52 #
Table structure for table 'be_users'
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 description
varchar(2000) DEFAULT '' NOT NULL,
60 avatar
int(11) unsigned
NOT NULL default '0',
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 'pages'
99 uid
int(11) NOT NULL auto_increment
,
100 pid
int(11) DEFAULT '0' NOT NULL,
101 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
102 t3ver_id
int(11) DEFAULT '0' NOT NULL,
103 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
104 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
105 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
106 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
107 t3ver_count
int(11) DEFAULT '0' NOT NULL,
108 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
109 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
110 t3_origuid
int(11) DEFAULT '0' NOT NULL,
111 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
112 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
113 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
114 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
115 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
116 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
117 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
118 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
119 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
120 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
121 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
122 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
123 title
varchar(255) DEFAULT '' NOT NULL,
124 doktype
int(11) unsigned
DEFAULT '0' NOT NULL,
126 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
127 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
128 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
129 url
varchar(255) DEFAULT '' NOT NULL,
130 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
131 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
132 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
133 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
134 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
135 no_cache
int(10) unsigned
DEFAULT '0' NOT NULL,
136 fe_group
varchar(100) DEFAULT '0' NOT NULL,
137 subtitle
varchar(255) DEFAULT '' NOT NULL,
138 layout
int(11) unsigned
DEFAULT '0' NOT NULL,
139 url_scheme
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
140 target
varchar(80) DEFAULT '' NOT NULL,
142 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
144 cache_timeout
int(10) unsigned
DEFAULT '0' NOT NULL,
145 cache_tags
varchar(255) DEFAULT '' NOT NULL,
146 newUntil
int(10) unsigned
DEFAULT '0' NOT NULL,
148 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
149 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
151 module varchar(10) DEFAULT '' NOT NULL,
152 extendToSubpages
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
153 author
varchar(255) DEFAULT '' NOT NULL,
154 author_email
varchar(80) DEFAULT '' NOT NULL,
155 nav_title
varchar(255) DEFAULT '' NOT NULL,
156 nav_hide
tinyint(4) DEFAULT '0' NOT NULL,
157 content_from_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
158 mount_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
159 mount_pid_ol
tinyint(4) DEFAULT '0' NOT NULL,
160 alias varchar(32) DEFAULT '' NOT NULL,
161 l18n_cfg
tinyint(4) DEFAULT '0' NOT NULL,
162 fe_login_mode
tinyint(4) DEFAULT '0' NOT NULL,
163 backend_layout
varchar(64) DEFAULT '' NOT NULL,
164 backend_layout_next_level
varchar(64) DEFAULT '' NOT NULL,
165 tsconfig_includes
text,
167 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
168 KEY parent (pid
,deleted
,sorting
),
170 KEY determineSiteRoot (is_siteroot
)
174 #
Table structure for table 'sys_registry'
176 CREATE TABLE sys_registry (
177 uid
int(11) unsigned
NOT NULL auto_increment
,
178 entry_namespace
varchar(128) DEFAULT '' NOT NULL,
179 entry_key
varchar(128) DEFAULT '' NOT NULL,
182 UNIQUE KEY entry_identifier (entry_namespace
,entry_key
)
186 #
Table structure for table 'sys_be_shortcuts'
188 CREATE TABLE sys_be_shortcuts (
189 uid
int(11) unsigned
NOT NULL auto_increment
,
190 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
191 module_name
varchar(255) DEFAULT '' NOT NULL,
193 description
varchar(255) DEFAULT '' NOT NULL,
194 sorting
int(11) DEFAULT '0' NOT NULL,
195 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
202 #
Table structure for table 'sys_news'
204 CREATE TABLE sys_news (
205 uid
int(11) unsigned
NOT NULL auto_increment
,
206 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
207 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
208 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
209 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
210 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
211 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
212 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
213 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
214 title
varchar(255) DEFAULT '' NOT NULL,
223 #
Table structure for table 'sys_filemounts'
225 CREATE TABLE sys_filemounts (
226 uid
int(11) unsigned
NOT NULL auto_increment
,
227 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
228 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
229 title
varchar(30) DEFAULT '' NOT NULL,
230 description
varchar(2000) DEFAULT '' NOT NULL,
231 path varchar(120) DEFAULT '' NOT NULL,
232 base
int(11) unsigned
DEFAULT '0' NOT NULL,
233 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
234 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
235 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
236 read_only
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
243 #
Table structure for table 'sys_file_storage'
245 CREATE TABLE sys_file_storage (
246 uid
int(11) NOT NULL auto_increment
,
247 pid
int(11) DEFAULT '0' NOT NULL,
248 tstamp
int(11) DEFAULT '0' NOT NULL,
249 crdate
int(11) DEFAULT '0' NOT NULL,
250 cruser_id
int(11) DEFAULT '0' NOT NULL,
251 deleted
tinyint(4) DEFAULT '0' NOT NULL,
253 name varchar(30) DEFAULT '' NOT NULL,
257 is_default
tinyint(4) DEFAULT '0' NOT NULL,
258 is_browsable
tinyint(4) DEFAULT '0' NOT NULL,
259 is_public
tinyint(4) DEFAULT '0' NOT NULL,
260 is_writable
tinyint(4) DEFAULT '0' NOT NULL,
261 is_online
tinyint(4) DEFAULT '1' NOT NULL,
262 processingfolder tinytext
,
265 KEY parent (pid
,deleted
)
269 #
Table structure for table 'sys_file'
271 CREATE TABLE sys_file (
272 uid
int(11) NOT NULL auto_increment
,
273 pid
int(11) DEFAULT '0' NOT NULL,
274 #
update timestamp of the
database record
, not the
file!
275 tstamp
int(11) DEFAULT '0' NOT NULL,
276 last_indexed
int(11) DEFAULT '0' NOT NULL,
278 # management information
279 missing
tinyint(4) DEFAULT '0' NOT NULL,
280 storage int(11) DEFAULT '0' NOT NULL,
281 type varchar(10) DEFAULT '' NOT NULL,
282 metadata
int(11) DEFAULT '0' NOT NULL,
286 identifier_hash
char(40) DEFAULT '' NOT NULL,
287 folder_hash
char(40) DEFAULT '' NOT NULL,
288 extension
varchar(255) DEFAULT '' NOT NULL,
289 mime_type
varchar(255) DEFAULT '' NOT NULL,
291 sha1
char(40) DEFAULT '' NOT NULL,
292 size bigint(20) unsigned
DEFAULT '0' NOT NULL,
293 creation_date
int(11) DEFAULT '0' NOT NULL,
294 modification_date
int(11) DEFAULT '0' NOT NULL,
297 KEY sel01 (storage,identifier_hash
),
298 KEY folder (storage,folder_hash
),
300 KEY lastindex (last_indexed
),
305 #
Table structure for table 'sys_file_metadata'
307 CREATE TABLE sys_file_metadata (
308 uid
int(11) NOT NULL auto_increment
,
309 pid
int(11) DEFAULT '0' NOT NULL,
310 tstamp
int(11) DEFAULT '0' NOT NULL,
311 crdate
int(11) DEFAULT '0' NOT NULL,
312 cruser_id
int(11) DEFAULT '0' NOT NULL,
315 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
316 l10n_parent
int(11) DEFAULT '0' NOT NULL,
317 l10n_diffsource mediumblob
NOT NULL,
320 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
321 t3ver_id
int(11) DEFAULT '0' NOT NULL,
322 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
323 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
324 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
325 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
326 t3ver_count
int(11) DEFAULT '0' NOT NULL,
327 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
328 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
329 t3_origuid
int(11) DEFAULT '0' NOT NULL,
331 file int(11) DEFAULT '0' NOT NULL,
333 width
int(11) DEFAULT '0' NOT NULL,
334 height
int(11) DEFAULT '0' NOT NULL,
340 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
341 KEY fal_filelist (l10n_parent
,sys_language_uid
)
346 #
Table structure for table 'sys_file_processedfile'.
347 # which
is a
"temporary" file, like an image preview
348 # This
table does
not have a TCA representation
, as it
is only written
349 #
to using direct
SQL queries
in the code
351 CREATE TABLE sys_file_processedfile (
352 uid
int(11) NOT NULL auto_increment
,
353 tstamp
int(11) DEFAULT '0' NOT NULL,
354 crdate
int(11) DEFAULT '0' NOT NULL,
356 storage int(11) DEFAULT '0' NOT NULL,
357 original
int(11) DEFAULT '0' NOT NULL,
358 identifier
varchar(512) DEFAULT '' NOT NULL,
361 configurationsha1
char(40) DEFAULT '' NOT NULL,
362 originalfilesha1
char(40) DEFAULT '' NOT NULL,
363 task_type
varchar(200) DEFAULT '' NOT NULL,
364 checksum
char(10) DEFAULT '' NOT NULL,
365 width
int(11) DEFAULT '0',
366 height
int(11) DEFAULT '0',
369 KEY combined_1 (original
,task_type
,configurationsha1
),
370 KEY identifier (storage,identifier(199))
374 #
Table structure for table 'sys_file_reference'
375 # which
is one
usage of a
file with overloaded metadata
377 CREATE TABLE sys_file_reference (
378 uid
int(11) NOT NULL auto_increment
,
379 pid
int(11) DEFAULT '0' NOT NULL,
380 tstamp
int(11) DEFAULT '0' NOT NULL,
381 crdate
int(11) DEFAULT '0' NOT NULL,
382 cruser_id
int(11) DEFAULT '0' NOT NULL,
383 sorting
int(10) DEFAULT '0' NOT NULL,
384 deleted
tinyint(4) DEFAULT '0' NOT NULL,
385 hidden
tinyint(4) DEFAULT '0' NOT NULL,
388 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
389 t3ver_id
int(11) DEFAULT '0' NOT NULL,
390 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
391 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
392 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
393 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
394 t3ver_count
int(11) DEFAULT '0' NOT NULL,
395 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
396 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
397 t3_origuid
int(11) DEFAULT '0' NOT NULL,
400 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
401 l10n_parent
int(11) DEFAULT '0' NOT NULL,
402 l10n_diffsource mediumblob
NOT NULL,
404 # Reference
fields (basically same
as MM
table)
405 uid_local
int(11) DEFAULT '0' NOT NULL,
406 uid_foreign
int(11) DEFAULT '0' NOT NULL,
407 tablenames
varchar(64) DEFAULT '' NOT NULL,
408 fieldname
varchar(64) DEFAULT '' NOT NULL,
409 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
410 table_local
varchar(64) DEFAULT '' NOT NULL,
412 #
Local usage overlay fields
415 alternative tinytext
,
416 link varchar(1024) DEFAULT '' NOT NULL,
417 downloadname tinytext
,
418 crop
varchar(4000) DEFAULT '' NOT NULL,
421 KEY parent (pid
,deleted
),
422 KEY tablenames_fieldname (tablenames(32),fieldname(12)),
423 KEY deleted (deleted
),
424 KEY uid_foreign (uid_foreign
)
429 #
Table structure for table 'sys_file_collection'
431 CREATE TABLE sys_file_collection (
432 uid
int(11) NOT NULL auto_increment
,
433 pid
int(11) DEFAULT '0' NOT NULL,
434 tstamp
int(11) DEFAULT '0' NOT NULL,
435 crdate
int(11) DEFAULT '0' NOT NULL,
436 cruser_id
int(11) DEFAULT '0' NOT NULL,
437 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
438 t3ver_id
int(11) DEFAULT '0' NOT NULL,
439 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
440 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
441 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
442 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
443 t3ver_count
int(11) DEFAULT '0' NOT NULL,
444 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
445 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
446 t3_origuid
int(11) DEFAULT '0' NOT NULL,
447 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
448 l10n_parent
int(11) DEFAULT '0' NOT NULL,
449 l10n_diffsource mediumtext
,
450 deleted
tinyint(4) DEFAULT '0' NOT NULL,
451 hidden
tinyint(4) DEFAULT '0' NOT NULL,
452 starttime
int(11) DEFAULT '0' NOT NULL,
453 endtime
int(11) DEFAULT '0' NOT NULL,
458 type varchar(30) DEFAULT 'static' NOT NULL,
461 files
int(11) DEFAULT '0' NOT NULL,
464 storage int(11) DEFAULT '0' NOT NULL,
465 folder
text NOT NULL,
466 recursive tinyint(4) DEFAULT '0' NOT NULL,
469 category
int(11) DEFAULT '0' NOT NULL,
472 KEY parent (pid
,deleted
),
473 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)
477 #
Table structure for table 'sys_collection'
479 CREATE TABLE sys_collection (
480 uid
int(11) NOT NULL auto_increment
,
481 pid
int(11) DEFAULT '0' NOT NULL,
482 tstamp
int(11) DEFAULT '0' NOT NULL,
483 crdate
int(11) DEFAULT '0' NOT NULL,
484 cruser_id
int(11) DEFAULT '0' NOT NULL,
485 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
486 t3ver_id
int(11) DEFAULT '0' NOT NULL,
487 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
488 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
489 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
490 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
491 t3ver_count
int(11) DEFAULT '0' NOT NULL,
492 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
493 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
494 t3_origuid
int(11) DEFAULT '0' NOT NULL,
495 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
496 l10n_parent
int(11) DEFAULT '0' NOT NULL,
497 l10n_diffsource mediumtext
,
498 deleted
tinyint(4) DEFAULT '0' NOT NULL,
499 hidden
tinyint(4) DEFAULT '0' NOT NULL,
500 starttime
int(11) DEFAULT '0' NOT NULL,
501 endtime
int(11) DEFAULT '0' NOT NULL,
502 fe_group
int(11) DEFAULT '0' NOT NULL,
506 type varchar(32) DEFAULT 'static' NOT NULL,
508 items
int(11) DEFAULT '0' NOT NULL,
511 KEY parent (pid
,deleted
),
512 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)
516 #
Table structure for table 'sys_collection_entries'
518 CREATE TABLE sys_collection_entries (
519 uid
int(11) NOT NULL auto_increment
,
520 uid_local
int(11) DEFAULT '0' NOT NULL,
521 uid_foreign
int(11) DEFAULT '0' NOT NULL,
522 tablenames
varchar(64) DEFAULT '' NOT NULL,
523 sorting
int(11) DEFAULT '0' NOT NULL,
525 KEY uid_local (uid_local
),
526 KEY uid_foreign (uid_foreign
),
531 #
Table structure for table 'sys_history'
533 CREATE TABLE sys_history (
534 uid
int(11) unsigned
NOT NULL auto_increment
,
535 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
536 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
537 history_data mediumtext
,
539 recuid
int(11) DEFAULT '0' NOT NULL,
540 tablename
varchar(255) DEFAULT '' NOT NULL,
541 tstamp
int(11) DEFAULT '0' NOT NULL,
542 history_files mediumtext
,
543 snapshot
int(11) DEFAULT '0' NOT NULL,
546 KEY recordident_1 (tablename
,recuid
),
547 KEY recordident_2 (tablename
,tstamp
),
548 KEY sys_log_uid (sys_log_uid
)
552 #
Table structure for table 'sys_lockedrecords'
554 CREATE TABLE sys_lockedrecords (
555 uid
int(11) unsigned
NOT NULL auto_increment
,
556 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
557 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
558 record_table
varchar(255) DEFAULT '' NOT NULL,
559 record_uid
int(11) DEFAULT '0' NOT NULL,
560 record_pid
int(11) DEFAULT '0' NOT NULL,
561 username
varchar(50) DEFAULT '' NOT NULL,
562 feuserid
int(11) unsigned
DEFAULT '0' NOT NULL,
564 KEY event (userid
,tstamp
)
568 #
Table structure for table 'sys_refindex'
570 CREATE TABLE sys_refindex (
571 hash
varchar(32) DEFAULT '' NOT NULL,
572 tablename
varchar(255) DEFAULT '' NOT NULL,
573 recuid
int(11) DEFAULT '0' NOT NULL,
574 field
varchar(40) DEFAULT '' NOT NULL,
575 flexpointer
varchar(255) DEFAULT '' NOT NULL,
576 softref_key
varchar(30) DEFAULT '' NOT NULL,
577 softref_id
varchar(40) DEFAULT '' NOT NULL,
578 sorting
int(11) DEFAULT '0' NOT NULL,
579 deleted
tinyint(1) DEFAULT '0' NOT NULL,
580 workspace
int(11) DEFAULT '0' NOT NULL,
581 ref_table
varchar(255) DEFAULT '' NOT NULL,
582 ref_uid
int(11) DEFAULT '0' NOT NULL,
583 ref_string
varchar(200) DEFAULT '' NOT NULL,
586 KEY lookup_rec (tablename
,recuid
),
587 KEY lookup_uid (ref_table
,ref_uid
),
588 KEY lookup_string (ref_string
)
592 #
Table structure for table 'sys_log'
594 CREATE TABLE sys_log (
595 uid
int(11) unsigned
NOT NULL auto_increment
,
596 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
597 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
598 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
599 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
600 tablename
varchar(255) DEFAULT '' NOT NULL,
601 recpid
int(11) DEFAULT '0' NOT NULL,
602 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
603 details
text NOT NULL,
604 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
605 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
606 details_nr
tinyint(3) DEFAULT '0' NOT NULL,
607 IP
varchar(39) DEFAULT '' NOT NULL,
609 event_pid
int(11) DEFAULT '-1' NOT NULL,
610 workspace
int(11) DEFAULT '0' NOT NULL,
611 NEWid
varchar(30) DEFAULT '' NOT NULL,
612 request_id
varchar(13) DEFAULT '' NOT NULL,
613 time_micro
float DEFAULT '0' NOT NULL,
614 component
varchar(255) DEFAULT '' NOT NULL,
615 level tinyint(1) unsigned
DEFAULT '0' NOT NULL,
620 KEY event (userid
,event_pid
),
621 KEY recuidIdx (recuid
,uid
),
622 KEY user_auth (type,action,tstamp
),
623 KEY request (request_id
)
627 #
Table structure for table 'sys_language'
629 CREATE TABLE sys_language (
630 uid
int(11) unsigned
NOT NULL auto_increment
,
631 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
632 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
633 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
634 title
varchar(80) DEFAULT '' NOT NULL,
635 flag varchar(20) DEFAULT '' NOT NULL,
636 language_isocode
varchar(2) DEFAULT '' NOT NULL,
637 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,
643 #
Table structure for table 'sys_category'
645 CREATE TABLE sys_category (
646 uid
int(11) NOT NULL auto_increment
,
647 pid
int(11) DEFAULT '0' NOT NULL,
648 tstamp
int(11) DEFAULT '0' NOT NULL,
649 crdate
int(11) DEFAULT '0' NOT NULL,
650 cruser_id
int(11) DEFAULT '0' NOT NULL,
651 deleted
tinyint(4) DEFAULT '0' NOT NULL,
652 hidden
tinyint(4) DEFAULT '0' NOT NULL,
653 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
654 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
656 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
657 t3ver_id
int(11) DEFAULT '0' NOT NULL,
658 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
659 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
660 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
661 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
662 t3ver_count
int(11) DEFAULT '0' NOT NULL,
663 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
664 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
665 t3_origuid
int(11) DEFAULT '0' NOT NULL,
666 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
668 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
669 l10n_parent
int(11) DEFAULT '0' NOT NULL,
670 l10n_diffsource mediumblob
NOT NULL,
672 title tinytext
NOT NULL,
673 description
text NOT NULL,
674 parent
int(11) DEFAULT '0' NOT NULL,
675 items
int(11) DEFAULT '0' NOT NULL,
679 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
680 KEY category_parent (parent
),
681 KEY category_list (pid
,deleted
,sys_language_uid
)
685 #
Table structure for table 'sys_category_record_mm'
687 CREATE TABLE sys_category_record_mm (
688 uid_local
int(11) DEFAULT '0' NOT NULL,
689 uid_foreign
int(11) DEFAULT '0' NOT NULL,
690 tablenames
varchar(255) DEFAULT '' NOT NULL,
691 fieldname
varchar(255) DEFAULT '' NOT NULL,
692 sorting
int(11) DEFAULT '0' NOT NULL,
693 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
695 KEY uid_local_foreign (uid_local
,uid_foreign
),
696 KEY uid_foreign_tablefield (uid_foreign
,tablenames(40),fieldname(3),sorting_foreign
)