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_extensions'
98 CREATE TABLE cache_extensions (
99 extkey
varchar(60) NOT NULL default '',
100 version varchar(10) NOT NULL default '',
101 alldownloadcounter
int(11) unsigned
NOT NULL default '0',
102 downloadcounter
int(11) unsigned
NOT NULL default '0',
103 title
varchar(150) NOT NULL default '',
104 description mediumtext
,
105 state int(4) NOT NULL default '0',
106 reviewstate
int(4) NOT NULL default '0',
107 category
int(4) NOT NULL default '0',
108 lastuploaddate
int(11) unsigned
NOT NULL default '0',
109 dependencies mediumtext
,
110 authorname
varchar(100) NOT NULL default '',
111 authoremail
varchar(100) NOT NULL default '',
112 ownerusername
varchar(50) NOT NULL default '',
113 t3xfilemd5
varchar(35) NOT NULL default '',
114 uploadcomment mediumtext
,
115 authorcompany
varchar(100) NOT NULL default '',
116 intversion
int(11) NOT NULL default '0',
117 lastversion
int(3) NOT NULL default '0',
118 lastreviewedversion
int(3) NOT NULL default '0',
119 PRIMARY KEY (extkey
,version)
123 #
Table structure for table 'cache_hash'
125 CREATE TABLE cache_hash (
126 id int(11) unsigned
NOT NULL auto_increment
,
127 hash
varchar(32) DEFAULT '' NOT NULL,
129 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
130 ident
varchar(32) DEFAULT '' NOT NULL,
137 #
Table structure for table 'cachingframework_cache_hash'
139 CREATE TABLE cachingframework_cache_hash (
140 id int(11) unsigned
NOT NULL auto_increment
,
141 identifier
varchar(128) DEFAULT '' NOT NULL,
142 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
144 lifetime
int(11) unsigned
DEFAULT '0' NOT NULL,
146 KEY cache_id (identifier
)
151 #
Table structure for table 'cachingframework_cache_hash_tags'
153 CREATE TABLE cachingframework_cache_hash_tags (
154 id int(11) unsigned
NOT NULL auto_increment
,
155 identifier
varchar(128) DEFAULT '' NOT NULL,
156 tag
varchar(128) DEFAULT '' NOT NULL,
158 KEY cache_id (identifier
),
164 #
Table structure for table 'cache_imagesizes'
166 CREATE TABLE cache_imagesizes (
167 md5hash
varchar(32) DEFAULT '' NOT NULL,
168 md5filename
varchar(32) DEFAULT '' NOT NULL,
169 tstamp
int(11) DEFAULT '0' NOT NULL,
170 filename
varchar(255) DEFAULT '' NOT NULL,
171 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
172 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
173 PRIMARY KEY (md5filename
)
177 #
Table structure for table 'pages'
180 uid
int(11) NOT NULL auto_increment
,
181 pid
int(11) DEFAULT '0' NOT NULL,
182 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
183 t3ver_id
int(11) DEFAULT '0' NOT NULL,
184 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
185 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
186 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
187 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
188 t3ver_count
int(11) DEFAULT '0' NOT NULL,
189 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
190 t3ver_swapmode
tinyint(4) DEFAULT '0' NOT NULL,
191 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
192 t3_origuid
int(11) DEFAULT '0' NOT NULL,
193 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
194 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
195 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
196 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
197 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
198 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
199 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
200 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
201 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
202 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
203 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
204 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
205 title
varchar(255) DEFAULT '' NOT NULL,
206 doktype
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
208 storage_pid
int(11) DEFAULT '0' NOT NULL,
209 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
210 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
211 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
213 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
214 KEY parent (pid
,sorting
,deleted
,hidden
)
218 #
Table structure for table 'sys_registry'
220 CREATE TABLE sys_registry (
221 uid
int(11) unsigned
NOT NULL auto_increment
,
222 entry_namespace
varchar(128) DEFAULT '' NOT NULL,
223 entry_key
varchar(128) DEFAULT '' NOT NULL,
226 UNIQUE KEY entry_identifier (entry_namespace
,entry_key
)
230 #
Table structure for table 'sys_be_shortcuts'
232 CREATE TABLE sys_be_shortcuts (
233 uid
int(11) unsigned
NOT NULL auto_increment
,
234 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
235 module_name
varchar(255) DEFAULT '' NOT NULL,
237 description
varchar(255) DEFAULT '' NOT NULL,
238 sorting
int(11) DEFAULT '0' NOT NULL,
239 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
246 #
Table structure for table 'sys_preview'
248 CREATE TABLE sys_preview (
249 keyword
varchar(32) DEFAULT '' NOT NULL,
250 tstamp
int(11) DEFAULT '0' NOT NULL,
251 endtime
int(11) DEFAULT '0' NOT NULL,
253 PRIMARY KEY (keyword
)
258 #
Table structure for table 'sys_filemounts'
260 CREATE TABLE sys_filemounts (
261 uid
int(11) unsigned
NOT NULL auto_increment
,
262 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
263 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
264 title
varchar(30) DEFAULT '' NOT NULL,
265 path varchar(120) DEFAULT '' NOT NULL,
266 base
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
267 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
268 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
269 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
275 #
Table structure for table 'sys_workspace'
277 CREATE TABLE sys_workspace (
278 uid
int(11) NOT NULL auto_increment
,
279 pid
int(11) DEFAULT '0' NOT NULL,
280 tstamp
int(11) DEFAULT '0' NOT NULL,
281 deleted
tinyint(1) DEFAULT '0' NOT NULL,
282 title
varchar(30) DEFAULT '' NOT NULL,
283 description
varchar(255) DEFAULT '' NOT NULL,
284 adminusers
varchar(255) DEFAULT '' NOT NULL,
287 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
288 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
289 publish_time
int(11) DEFAULT '0' NOT NULL,
290 unpublish_time
int(11) DEFAULT '0' NOT NULL,
291 freeze tinyint(3) DEFAULT '0' NOT NULL,
292 live_edit
tinyint(3) DEFAULT '0' NOT NULL,
293 review_stage_edit
tinyint(3) DEFAULT '0' NOT NULL,
294 vtypes
tinyint(3) DEFAULT '0' NOT NULL,
295 disable_autocreate
tinyint(1) DEFAULT '0' NOT NULL,
296 swap_modes
tinyint(3) DEFAULT '0' NOT NULL,
297 publish_access
tinyint(3) DEFAULT '0' NOT NULL,
298 stagechg_notification
tinyint(3) DEFAULT '0' NOT NULL,
305 #
Table structure for table 'sys_history'
307 CREATE TABLE sys_history (
308 uid
int(11) unsigned
NOT NULL auto_increment
,
309 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
310 history_data mediumtext
,
312 recuid
int(11) DEFAULT '0' NOT NULL,
313 tablename
varchar(255) DEFAULT '' NOT NULL,
314 tstamp
int(11) DEFAULT '0' NOT NULL,
315 history_files mediumtext
,
316 snapshot
tinyint(4) DEFAULT '0' NOT NULL,
318 KEY recordident (tablename
,recuid
,tstamp
),
319 KEY sys_log_uid (sys_log_uid
)
323 #
Table structure for table 'sys_lockedrecords'
325 CREATE TABLE sys_lockedrecords (
326 uid
int(11) unsigned
NOT NULL auto_increment
,
327 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
328 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
329 record_table
varchar(255) DEFAULT '' NOT NULL,
330 record_uid
int(11) DEFAULT '0' NOT NULL,
331 record_pid
int(11) DEFAULT '0' NOT NULL,
332 username
varchar(50) DEFAULT '' NOT NULL,
333 feuserid
int(11) unsigned
DEFAULT '0' NOT NULL,
335 KEY event (userid
,tstamp
)
339 #
Table structure for table 'sys_refindex'
341 CREATE TABLE sys_refindex (
342 hash
varchar(32) DEFAULT '' NOT NULL,
343 tablename
varchar(255) DEFAULT '' NOT NULL,
344 recuid
int(11) DEFAULT '0' NOT NULL,
345 field
varchar(40) DEFAULT '' NOT NULL,
346 flexpointer
varchar(255) DEFAULT '' NOT NULL,
347 softref_key
varchar(30) DEFAULT '' NOT NULL,
348 softref_id
varchar(40) DEFAULT '' NOT NULL,
349 sorting
int(11) DEFAULT '0' NOT NULL,
350 deleted
tinyint(1) DEFAULT '0' NOT NULL,
351 ref_table
varchar(255) DEFAULT '' NOT NULL,
352 ref_uid
int(11) DEFAULT '0' NOT NULL,
353 ref_string
varchar(200) DEFAULT '' NOT NULL,
356 KEY lookup_rec (tablename
,recuid
),
357 KEY lookup_uid (ref_table
,ref_uid
),
358 KEY lookup_string (ref_string
)
362 #
Table structure for table 'sys_refindex_words'
364 CREATE TABLE sys_refindex_words (
365 wid
int(11) DEFAULT '0' NOT NULL,
366 baseword
varchar(60) DEFAULT '' NOT NULL,
371 #
Table structure for table 'sys_refindex_rel'
373 CREATE TABLE sys_refindex_rel (
374 rid
int(11) DEFAULT '0' NOT NULL,
375 wid
int(11) DEFAULT '0' NOT NULL,
376 PRIMARY KEY (rid
,wid
)
381 #
Table structure for table 'sys_refindex_res'
383 CREATE TABLE sys_refindex_res (
384 rid
int(11) DEFAULT '0' NOT NULL,
385 tablename
varchar(255) DEFAULT '' NOT NULL,
386 recuid
int(11) DEFAULT '0' NOT NULL,
391 #
Table structure for table 'sys_log'
393 CREATE TABLE sys_log (
394 uid
int(11) unsigned
NOT NULL auto_increment
,
395 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
396 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
397 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
398 tablename
varchar(255) DEFAULT '' NOT NULL,
399 recpid
int(11) DEFAULT '0' NOT NULL,
400 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
401 details
text NOT NULL,
402 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
403 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
404 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
405 IP
varchar(39) DEFAULT '' NOT NULL,
406 log_data
varchar(255) DEFAULT '' NOT NULL,
407 event_pid
int(11) DEFAULT '-1' NOT NULL,
408 workspace
int(11) DEFAULT '0' NOT NULL,
409 NEWid
varchar(20) DEFAULT '' NOT NULL,
411 KEY event (userid
,event_pid
),
412 KEY recuidIdx (recuid
,uid
)
416 #
Table structure for table 'sys_language'
418 CREATE TABLE sys_language (
419 uid
int(11) unsigned
NOT NULL auto_increment
,
420 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
421 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
422 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
423 title
varchar(80) DEFAULT '' NOT NULL,
424 flag varchar(20) DEFAULT '' NOT NULL,
425 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,