6 #
Table structure for table 'be_groups'
8 CREATE TABLE be_groups (
9 uid
int(11) unsigned
NOT NULL auto_increment
,
10 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
11 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
12 title
varchar(50) DEFAULT '' NOT NULL,
13 non_exclude_fields
text,
14 explicit_allowdeny
text,
15 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
17 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
18 pagetypes_select
varchar(255) DEFAULT '' NOT NULL,
21 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
22 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
24 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
25 fileoper_perms
tinyint(4) DEFAULT '0' NOT NULL,
26 hidden
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
27 inc_access_lists
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
29 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
30 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
32 subgroup
varchar(255) DEFAULT '' NOT NULL,
33 hide_in_lists
tinyint(4) DEFAULT '0' NOT NULL,
34 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
40 #
Table structure for table 'be_sessions'
42 CREATE TABLE be_sessions (
43 ses_id
varchar(32) DEFAULT '' NOT NULL,
44 ses_name
varchar(32) DEFAULT '' NOT NULL,
45 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
46 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
47 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
48 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
50 ses_backuserid
int(11) NOT NULL default '0',
51 PRIMARY KEY (ses_id
,ses_name
)
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(40) 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,
70 db_mountpoints
varchar(255) 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,
75 userMods
varchar(255) DEFAULT '' NOT NULL,
76 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
78 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
79 fileoper_perms
tinyint(4) DEFAULT '0' NOT NULL,
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
varchar(255) DEFAULT '' NOT NULL,
88 workspace_id
int(11) DEFAULT '0' NOT NULL,
89 workspace_preview
tinyint(3) DEFAULT '1' NOT NULL,
92 KEY username (username
)
96 #
Table structure for table 'cache_hash'
98 CREATE TABLE cache_hash (
99 id int(11) unsigned
NOT NULL auto_increment
,
100 hash
varchar(32) DEFAULT '' NOT NULL,
102 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
103 ident
varchar(32) DEFAULT '' NOT NULL,
110 #
Table structure for table 'cachingframework_cache_hash'
112 CREATE TABLE cachingframework_cache_hash (
113 id int(11) unsigned
NOT NULL auto_increment
,
114 identifier
varchar(128) DEFAULT '' NOT NULL,
115 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
117 lifetime
int(11) unsigned
DEFAULT '0' NOT NULL,
119 KEY cache_id (identifier
)
124 #
Table structure for table 'cachingframework_cache_hash_tags'
126 CREATE TABLE cachingframework_cache_hash_tags (
127 id int(11) unsigned
NOT NULL auto_increment
,
128 identifier
varchar(128) DEFAULT '' NOT NULL,
129 tag
varchar(128) DEFAULT '' NOT NULL,
131 KEY cache_id (identifier
),
137 #
Table structure for table 'cache_imagesizes'
139 CREATE TABLE cache_imagesizes (
140 md5hash
varchar(32) DEFAULT '' NOT NULL,
141 md5filename
varchar(32) DEFAULT '' NOT NULL,
142 tstamp
int(11) DEFAULT '0' NOT NULL,
143 filename
varchar(255) DEFAULT '' NOT NULL,
144 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
145 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
146 PRIMARY KEY (md5filename
)
150 #
Table structure for table 'pages'
153 uid
int(11) NOT NULL auto_increment
,
154 pid
int(11) DEFAULT '0' NOT NULL,
155 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
156 t3ver_id
int(11) DEFAULT '0' NOT NULL,
157 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
158 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
159 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
160 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
161 t3ver_count
int(11) DEFAULT '0' NOT NULL,
162 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
163 t3ver_swapmode
tinyint(4) DEFAULT '0' NOT NULL,
164 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
165 t3_origuid
int(11) DEFAULT '0' NOT NULL,
166 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
167 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
168 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
169 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
170 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
171 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
172 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
173 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
174 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
175 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
176 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
177 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
178 title
varchar(255) DEFAULT '' NOT NULL,
179 doktype
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
181 storage_pid
int(11) DEFAULT '0' NOT NULL,
182 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
183 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
184 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
185 url
varchar(255) DEFAULT '' NOT NULL,
186 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
187 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
188 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
189 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
190 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
191 no_cache
int(10) unsigned
DEFAULT '0' NOT NULL,
192 fe_group
varchar(100) DEFAULT '0' NOT NULL,
193 subtitle
varchar(255) DEFAULT '' NOT NULL,
194 layout
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
195 url_scheme
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
196 target
varchar(80) DEFAULT '' NOT NULL,
198 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
200 cache_timeout
int(10) unsigned
DEFAULT '0' NOT NULL,
201 newUntil
int(10) unsigned
DEFAULT '0' NOT NULL,
203 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
204 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
206 module varchar(10) DEFAULT '' NOT NULL,
207 extendToSubpages
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
208 author
varchar(255) DEFAULT '' NOT NULL,
209 author_email
varchar(80) DEFAULT '' NOT NULL,
210 nav_title
varchar(255) DEFAULT '' NOT NULL,
211 nav_hide
tinyint(4) DEFAULT '0' NOT NULL,
212 content_from_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
213 mount_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
214 mount_pid_ol
tinyint(4) DEFAULT '0' NOT NULL,
215 alias varchar(32) DEFAULT '' NOT NULL,
216 l18n_cfg
tinyint(4) DEFAULT '0' NOT NULL,
217 fe_login_mode
tinyint(4) DEFAULT '0' NOT NULL,
219 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
220 KEY parent (pid
,sorting
,deleted
,hidden
),
225 #
Table structure for table 'sys_registry'
227 CREATE TABLE sys_registry (
228 uid
int(11) unsigned
NOT NULL auto_increment
,
229 entry_namespace
varchar(128) DEFAULT '' NOT NULL,
230 entry_key
varchar(128) DEFAULT '' NOT NULL,
233 UNIQUE KEY entry_identifier (entry_namespace
,entry_key
)
237 #
Table structure for table 'sys_be_shortcuts'
239 CREATE TABLE sys_be_shortcuts (
240 uid
int(11) unsigned
NOT NULL auto_increment
,
241 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
242 module_name
varchar(255) DEFAULT '' NOT NULL,
244 description
varchar(255) DEFAULT '' NOT NULL,
245 sorting
int(11) DEFAULT '0' NOT NULL,
246 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
253 #
Table structure for table 'sys_news'
255 CREATE TABLE sys_news (
256 uid
int(11) unsigned
NOT NULL auto_increment
,
257 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
258 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
259 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
260 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
261 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
262 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
263 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
264 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
265 title
varchar(255) DEFAULT '' NOT NULL,
274 #
Table structure for table 'sys_preview'
276 CREATE TABLE sys_preview (
277 keyword
varchar(32) DEFAULT '' NOT NULL,
278 tstamp
int(11) DEFAULT '0' NOT NULL,
279 endtime
int(11) DEFAULT '0' NOT NULL,
281 PRIMARY KEY (keyword
)
286 #
Table structure for table 'sys_filemounts'
288 CREATE TABLE sys_filemounts (
289 uid
int(11) unsigned
NOT NULL auto_increment
,
290 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
291 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
292 title
varchar(30) DEFAULT '' NOT NULL,
293 path varchar(120) DEFAULT '' NOT NULL,
294 base
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
295 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
296 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
297 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
303 #
Table structure for table 'sys_workspace'
305 CREATE TABLE sys_workspace (
306 uid
int(11) NOT NULL auto_increment
,
307 pid
int(11) DEFAULT '0' NOT NULL,
308 tstamp
int(11) DEFAULT '0' NOT NULL,
309 deleted
tinyint(1) DEFAULT '0' NOT NULL,
310 title
varchar(30) DEFAULT '' NOT NULL,
311 description
varchar(255) DEFAULT '' NOT NULL,
312 adminusers
varchar(255) DEFAULT '' NOT NULL,
315 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
316 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
317 publish_time
int(11) DEFAULT '0' NOT NULL,
318 unpublish_time
int(11) DEFAULT '0' NOT NULL,
319 freeze tinyint(3) DEFAULT '0' NOT NULL,
320 live_edit
tinyint(3) DEFAULT '0' NOT NULL,
321 review_stage_edit
tinyint(3) DEFAULT '0' NOT NULL,
322 vtypes
tinyint(3) DEFAULT '0' NOT NULL,
323 disable_autocreate
tinyint(1) DEFAULT '0' NOT NULL,
324 swap_modes
tinyint(3) DEFAULT '0' NOT NULL,
325 publish_access
tinyint(3) DEFAULT '0' NOT NULL,
326 stagechg_notification
tinyint(3) DEFAULT '0' NOT NULL,
333 #
Table structure for table 'sys_history'
335 CREATE TABLE sys_history (
336 uid
int(11) unsigned
NOT NULL auto_increment
,
337 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
338 history_data mediumtext
,
340 recuid
int(11) DEFAULT '0' NOT NULL,
341 tablename
varchar(255) DEFAULT '' NOT NULL,
342 tstamp
int(11) DEFAULT '0' NOT NULL,
343 history_files mediumtext
,
344 snapshot
tinyint(4) DEFAULT '0' NOT NULL,
346 KEY recordident (tablename
,recuid
,tstamp
),
347 KEY sys_log_uid (sys_log_uid
)
351 #
Table structure for table 'sys_lockedrecords'
353 CREATE TABLE sys_lockedrecords (
354 uid
int(11) unsigned
NOT NULL auto_increment
,
355 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
356 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
357 record_table
varchar(255) DEFAULT '' NOT NULL,
358 record_uid
int(11) DEFAULT '0' NOT NULL,
359 record_pid
int(11) DEFAULT '0' NOT NULL,
360 username
varchar(50) DEFAULT '' NOT NULL,
361 feuserid
int(11) unsigned
DEFAULT '0' NOT NULL,
363 KEY event (userid
,tstamp
)
367 #
Table structure for table 'sys_refindex'
369 CREATE TABLE sys_refindex (
370 hash
varchar(32) DEFAULT '' NOT NULL,
371 tablename
varchar(255) DEFAULT '' NOT NULL,
372 recuid
int(11) DEFAULT '0' NOT NULL,
373 field
varchar(40) DEFAULT '' NOT NULL,
374 flexpointer
varchar(255) DEFAULT '' NOT NULL,
375 softref_key
varchar(30) DEFAULT '' NOT NULL,
376 softref_id
varchar(40) DEFAULT '' NOT NULL,
377 sorting
int(11) DEFAULT '0' NOT NULL,
378 deleted
tinyint(1) DEFAULT '0' NOT NULL,
379 ref_table
varchar(255) DEFAULT '' NOT NULL,
380 ref_uid
int(11) DEFAULT '0' NOT NULL,
381 ref_string
varchar(200) DEFAULT '' NOT NULL,
384 KEY lookup_rec (tablename
,recuid
),
385 KEY lookup_uid (ref_table
,ref_uid
),
386 KEY lookup_string (ref_string
)
390 #
Table structure for table 'sys_refindex_words'
392 CREATE TABLE sys_refindex_words (
393 wid
int(11) DEFAULT '0' NOT NULL,
394 baseword
varchar(60) DEFAULT '' NOT NULL,
399 #
Table structure for table 'sys_refindex_rel'
401 CREATE TABLE sys_refindex_rel (
402 rid
int(11) DEFAULT '0' NOT NULL,
403 wid
int(11) DEFAULT '0' NOT NULL,
404 PRIMARY KEY (rid
,wid
)
409 #
Table structure for table 'sys_refindex_res'
411 CREATE TABLE sys_refindex_res (
412 rid
int(11) DEFAULT '0' NOT NULL,
413 tablename
varchar(255) DEFAULT '' NOT NULL,
414 recuid
int(11) DEFAULT '0' NOT NULL,
419 #
Table structure for table 'sys_log'
421 CREATE TABLE sys_log (
422 uid
int(11) unsigned
NOT NULL auto_increment
,
423 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
424 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
425 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
426 tablename
varchar(255) DEFAULT '' NOT NULL,
427 recpid
int(11) DEFAULT '0' NOT NULL,
428 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
429 details
text NOT NULL,
430 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
431 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
432 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
433 IP
varchar(39) DEFAULT '' NOT NULL,
434 log_data
varchar(255) DEFAULT '' NOT NULL,
435 event_pid
int(11) DEFAULT '-1' NOT NULL,
436 workspace
int(11) DEFAULT '0' NOT NULL,
437 NEWid
varchar(20) DEFAULT '' NOT NULL,
439 KEY event (userid
,event_pid
),
440 KEY recuidIdx (recuid
,uid
)
444 #
Table structure for table 'sys_language'
446 CREATE TABLE sys_language (
447 uid
int(11) unsigned
NOT NULL auto_increment
,
448 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
449 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
450 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
451 title
varchar(80) DEFAULT '' NOT NULL,
452 flag varchar(20) DEFAULT '' NOT NULL,
453 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,