2 #
Table structure for table 'be_groups'
4 CREATE TABLE be_groups (
5 title
varchar(50) DEFAULT '' NOT NULL,
6 non_exclude_fields
text,
7 explicit_allowdeny
text,
8 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
11 pagetypes_select
text,
15 availableWidgets
text,
17 file_mountpoints
text,
18 file_permissions
text,
21 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
26 #
Table structure for table 'be_sessions'
28 CREATE TABLE be_sessions (
29 ses_id
varchar(190) DEFAULT '' NOT NULL,
30 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
31 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
32 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
35 KEY ses_tstamp (ses_tstamp
)
39 #
Table structure for table 'be_users'
41 CREATE TABLE be_users (
42 username
varchar(50) DEFAULT '' NOT NULL,
43 avatar
int(11) unsigned
NOT NULL default '0',
44 password varchar(100) DEFAULT '' NOT NULL,
45 admin tinyint(4) unsigned
DEFAULT '0' NOT NULL,
47 lang
varchar(10) DEFAULT 'default' NOT NULL,
48 email
varchar(255) DEFAULT '' NOT NULL,
50 options tinyint(4) unsigned
DEFAULT '0' NOT NULL,
51 realName
varchar(80) DEFAULT '' NOT NULL,
53 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
55 file_mountpoints
text,
56 file_permissions
text,
57 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
59 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
60 workspace_id
int(11) DEFAULT '0' NOT NULL,
63 KEY username (username
)
67 #
Table structure for table 'pages'
70 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
71 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
72 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
73 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
74 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
75 title
varchar(255) DEFAULT '' NOT NULL,
77 doktype
int(11) unsigned
DEFAULT '0' NOT NULL,
79 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
80 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
81 url
varchar(255) DEFAULT '' NOT NULL,
82 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
83 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
84 subtitle
varchar(255) DEFAULT '' NOT NULL,
85 layout
int(11) unsigned
DEFAULT '0' NOT NULL,
86 target
varchar(80) DEFAULT '' NOT NULL,
87 media
int(11) unsigned
DEFAULT '0' NOT NULL,
88 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
90 cache_timeout
int(10) unsigned
DEFAULT '0' NOT NULL,
91 cache_tags
varchar(255) DEFAULT '' NOT NULL,
92 newUntil
int(10) unsigned
DEFAULT '0' NOT NULL,
94 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
95 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
97 module varchar(255) DEFAULT '' NOT NULL,
98 extendToSubpages
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
99 author
varchar(255) DEFAULT '' NOT NULL,
100 author_email
varchar(255) DEFAULT '' NOT NULL,
101 nav_title
varchar(255) DEFAULT '' NOT NULL,
102 nav_hide
tinyint(4) DEFAULT '0' NOT NULL,
103 content_from_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
104 mount_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
105 mount_pid_ol
tinyint(4) DEFAULT '0' NOT NULL,
106 l18n_cfg
tinyint(4) DEFAULT '0' NOT NULL,
107 fe_login_mode
tinyint(4) DEFAULT '0' NOT NULL,
108 backend_layout
varchar(64) DEFAULT '' NOT NULL,
109 backend_layout_next_level
varchar(64) DEFAULT '' NOT NULL,
110 tsconfig_includes
text,
112 KEY determineSiteRoot (is_siteroot
),
113 KEY language_identifier (l10n_parent
,sys_language_uid
),
118 #
Table structure for table 'sys_registry'
120 CREATE TABLE sys_registry (
121 uid
int(11) unsigned
NOT NULL auto_increment
,
122 entry_namespace
varchar(128) DEFAULT '' NOT NULL,
123 entry_key
varchar(128) DEFAULT '' NOT NULL,
124 entry_value mediumblob
,
126 UNIQUE KEY entry_identifier (entry_namespace
,entry_key
)
130 #
Table structure for table 'sys_be_shortcuts'
132 CREATE TABLE sys_be_shortcuts (
133 uid
int(11) unsigned
NOT NULL auto_increment
,
134 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
135 route
varchar(255) DEFAULT '' NOT NULL,
137 description
varchar(255) DEFAULT '' NOT NULL,
138 sorting
int(11) DEFAULT '0' NOT NULL,
139 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
146 #
Table structure for table 'sys_news'
148 CREATE TABLE sys_news (
149 title
varchar(255) DEFAULT '' NOT NULL,
155 #
Table structure for table 'sys_filemounts'
157 CREATE TABLE sys_filemounts (
158 title
varchar(255) DEFAULT '' NOT NULL,
159 path varchar(255) DEFAULT '' NOT NULL,
160 base
int(11) unsigned
DEFAULT '0' NOT NULL,
161 read_only
tinyint(1) unsigned
DEFAULT '0' NOT NULL
166 #
Table structure for table 'sys_file_storage'
168 CREATE TABLE sys_file_storage (
169 name varchar(255) DEFAULT '' NOT NULL,
172 is_default
tinyint(4) DEFAULT '0' NOT NULL,
173 is_browsable
tinyint(4) DEFAULT '0' NOT NULL,
174 is_public
tinyint(4) DEFAULT '0' NOT NULL,
175 is_writable
tinyint(4) DEFAULT '0' NOT NULL,
176 is_online
tinyint(4) DEFAULT '1' NOT NULL,
177 auto_extract_metadata
tinyint(4) DEFAULT '1' NOT NULL,
178 processingfolder tinytext
182 #
Table structure for table 'sys_file'
184 CREATE TABLE sys_file (
185 last_indexed
int(11) DEFAULT '0' NOT NULL,
187 # management information
188 missing
tinyint(4) DEFAULT '0' NOT NULL,
189 storage int(11) DEFAULT '0' NOT NULL,
190 type varchar(10) DEFAULT '' NOT NULL,
191 metadata
int(11) DEFAULT '0' NOT NULL,
195 identifier_hash
char(40) DEFAULT '' NOT NULL,
196 folder_hash
char(40) DEFAULT '' NOT NULL,
197 extension
varchar(255) DEFAULT '' NOT NULL,
198 mime_type
varchar(255) DEFAULT '' NOT NULL,
200 sha1
char(40) DEFAULT '' NOT NULL,
201 size bigint(20) unsigned
DEFAULT '0' NOT NULL,
202 creation_date
int(11) DEFAULT '0' NOT NULL,
203 modification_date
int(11) DEFAULT '0' NOT NULL,
205 KEY sel01 (storage,identifier_hash
),
206 KEY folder (storage,folder_hash
),
208 KEY lastindex (last_indexed
),
213 #
Table structure for table 'sys_file_metadata'
215 CREATE TABLE sys_file_metadata (
216 file int(11) DEFAULT '0' NOT NULL,
218 width
int(11) DEFAULT '0' NOT NULL,
219 height
int(11) DEFAULT '0' NOT NULL,
224 KEY fal_filelist (l10n_parent
,sys_language_uid
)
229 #
Table structure for table 'sys_file_processedfile'.
230 # which
is a
"temporary" file, like an image preview
231 # This
table does
not have a TCA representation
, as it
is only written
232 #
to using direct
SQL queries
in the code
234 CREATE TABLE sys_file_processedfile (
235 uid
int(11) NOT NULL auto_increment
,
236 tstamp
int(11) DEFAULT '0' NOT NULL,
237 crdate
int(11) DEFAULT '0' NOT NULL,
239 storage int(11) DEFAULT '0' NOT NULL,
240 original
int(11) DEFAULT '0' NOT NULL,
241 identifier
varchar(512) DEFAULT '' NOT NULL,
245 configurationsha1
char(40) DEFAULT '' NOT NULL,
246 originalfilesha1
char(40) DEFAULT '' NOT NULL,
247 task_type
varchar(200) DEFAULT '' NOT NULL,
248 checksum
char(10) DEFAULT '' NOT NULL,
249 width
int(11) DEFAULT '0',
250 height
int(11) DEFAULT '0',
253 KEY combined_1 (original
,task_type(100),configurationsha1
),
254 KEY identifier (storage,identifier(180))
258 #
Table structure for table 'sys_file_reference'
259 # which
is one
usage of a
file with overloaded metadata
261 CREATE TABLE sys_file_reference (
262 # Reference
fields (basically same
as MM
table)
263 uid_local
int(11) DEFAULT '0' NOT NULL,
264 uid_foreign
int(11) DEFAULT '0' NOT NULL,
265 tablenames
varchar(64) DEFAULT '' NOT NULL,
266 fieldname
varchar(64) DEFAULT '' NOT NULL,
267 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
268 table_local
varchar(64) DEFAULT '' NOT NULL,
270 #
Local usage overlay fields
274 link varchar(1024) DEFAULT '' NOT NULL,
275 crop
varchar(4000) DEFAULT '' NOT NULL,
276 autoplay
tinyint(4) DEFAULT '0' NOT NULL,
278 KEY tablenames_fieldname (tablenames(32),fieldname(12)),
279 KEY deleted (deleted
),
280 KEY uid_local (uid_local
),
281 KEY uid_foreign (uid_foreign
),
282 KEY combined_1 (l10n_parent
, t3ver_oid
, t3ver_wsid
, t3ver_state
, deleted
)
287 #
Table structure for table 'sys_file_collection'
289 CREATE TABLE sys_file_collection (
291 type varchar(30) DEFAULT 'static' NOT NULL,
294 files
int(11) DEFAULT '0' NOT NULL,
297 storage int(11) DEFAULT '0' NOT NULL,
299 recursive tinyint(4) DEFAULT '0' NOT NULL,
302 category
int(11) DEFAULT '0' NOT NULL
306 #
Table structure for table 'sys_history'
308 CREATE TABLE sys_history (
309 uid
int(11) unsigned
NOT NULL auto_increment
,
310 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
311 actiontype
tinyint(3) DEFAULT '0' NOT NULL,
312 usertype
varchar(2) DEFAULT 'BE' NOT NULL,
313 userid
int(11) unsigned
,
314 originaluserid
int(11) unsigned
,
315 recuid
int(11) DEFAULT '0' NOT NULL,
316 tablename
varchar(255) DEFAULT '' NOT NULL,
317 history_data mediumtext
,
318 workspace
int(11) DEFAULT '0',
319 correlation_id
varchar(255) DEFAULT '' NOT NULL,
322 KEY recordident_1 (tablename(100),recuid
),
323 KEY recordident_2 (tablename(100),tstamp
)
327 #
Table structure for table 'sys_lockedrecords'
329 CREATE TABLE sys_lockedrecords (
330 uid
int(11) unsigned
NOT NULL auto_increment
,
331 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
332 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
333 record_table
varchar(255) DEFAULT '' NOT NULL,
334 record_uid
int(11) DEFAULT '0' NOT NULL,
335 record_pid
int(11) DEFAULT '0' NOT NULL,
336 username
varchar(50) DEFAULT '' NOT NULL,
337 feuserid
int(11) unsigned
DEFAULT '0' NOT NULL,
339 KEY event (userid
,tstamp
)
343 #
Table structure for table 'sys_refindex'
345 CREATE TABLE sys_refindex (
346 hash
varchar(32) DEFAULT '' NOT NULL,
347 tablename
varchar(255) DEFAULT '' NOT NULL,
348 recuid
int(11) DEFAULT '0' NOT NULL,
349 field
varchar(64) DEFAULT '' NOT NULL,
350 flexpointer
varchar(255) DEFAULT '' NOT NULL,
351 softref_key
varchar(30) DEFAULT '' NOT NULL,
352 softref_id
varchar(40) DEFAULT '' NOT NULL,
353 sorting
int(11) DEFAULT '0' NOT NULL,
354 workspace
int(11) DEFAULT '0' NOT NULL,
355 ref_table
varchar(255) DEFAULT '' NOT NULL,
356 ref_uid
int(11) DEFAULT '0' NOT NULL,
357 ref_string
varchar(1024) DEFAULT '' NOT NULL,
360 KEY lookup_rec (tablename(100),recuid
),
361 KEY lookup_uid (ref_table(100),ref_uid
),
362 KEY lookup_string (ref_string(191))
366 #
Table structure for table 'sys_log'
368 CREATE TABLE sys_log (
369 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
370 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
371 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
372 tablename
varchar(255) DEFAULT '' NOT NULL,
373 recpid
int(11) DEFAULT '0' NOT NULL,
374 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
376 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
377 details_nr
tinyint(3) DEFAULT '0' NOT NULL,
378 IP
varchar(39) DEFAULT '' NOT NULL,
380 event_pid
int(11) DEFAULT '-1' NOT NULL,
381 workspace
int(11) DEFAULT '0' NOT NULL,
382 NEWid
varchar(30) DEFAULT '' NOT NULL,
383 request_id
varchar(13) DEFAULT '' NOT NULL,
384 time_micro
float DEFAULT '0' NOT NULL,
385 component
varchar(255) DEFAULT '' NOT NULL,
386 level tinyint(1) unsigned
DEFAULT '0' NOT NULL,
389 KEY event (userid
,event_pid
),
390 KEY recuidIdx (recuid
),
391 KEY user_auth (type,action,tstamp
),
392 KEY request (request_id
),
393 KEY combined_1 (tstamp
, type, userid
),
394 KEY errorcount (tstamp
,error
)
398 #
Table structure for table 'sys_language'
400 CREATE TABLE sys_language (
401 title
varchar(80) DEFAULT '' NOT NULL,
402 flag varchar(20) DEFAULT '' NOT NULL,
403 language_isocode
varchar(2) DEFAULT '' NOT NULL
407 #
Table structure for table 'sys_category'
409 CREATE TABLE sys_category (
410 title tinytext
NOT NULL,
411 parent
int(11) DEFAULT '0' NOT NULL,
412 items
int(11) DEFAULT '0' NOT NULL,
414 KEY category_parent (parent
),
415 KEY category_list (pid
,deleted
,sys_language_uid
)
419 #
Table structure for table 'sys_category_record_mm'
421 CREATE TABLE sys_category_record_mm (
422 uid_local
int(11) DEFAULT '0' NOT NULL,
423 uid_foreign
int(11) DEFAULT '0' NOT NULL,
424 tablenames
varchar(255) DEFAULT '' NOT NULL,
425 fieldname
varchar(255) DEFAULT '' NOT NULL,
426 sorting
int(11) DEFAULT '0' NOT NULL,
427 sorting_foreign
int(11) DEFAULT '0' NOT NULL,
429 KEY uid_local_foreign (uid_local
,uid_foreign
),
430 KEY uid_foreign_tablefield (uid_foreign
,tablenames(40),fieldname(3),sorting_foreign
)