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 NOT NULL,
14 explicit_allowdeny
text NOT NULL,
15 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
16 custom_options
text NOT NULL,
17 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
18 pagetypes_select
varchar(255) DEFAULT '' NOT NULL,
19 tables_select
text NOT NULL,
20 tables_modify
text NOT NULL,
21 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
22 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
23 groupMods
text NOT NULL,
24 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
25 hidden
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
26 inc_access_lists
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
27 description
text NOT NULL,
28 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
29 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
30 TSconfig
text NOT NULL,
31 subgroup
varchar(255) DEFAULT '' NOT NULL,
32 hide_in_lists
tinyint(4) DEFAULT '0' NOT NULL,
33 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
39 #
Table structure for table 'be_sessions'
41 CREATE TABLE be_sessions (
42 ses_id
varchar(32) DEFAULT '' NOT NULL,
43 ses_name
varchar(32) DEFAULT '' NOT NULL,
44 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
45 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
46 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
47 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
48 ses_data longtext
NOT NULL,
49 ses_backuserid
int(11) NOT NULL default '0',
50 PRIMARY KEY (ses_id
,ses_name
)
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(40) 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,
69 db_mountpoints
varchar(255) 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,
74 userMods
varchar(255) DEFAULT '' NOT NULL,
75 allowed_languages
varchar(255) DEFAULT '' NOT NULL,
77 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
78 fileoper_perms
tinyint(4) DEFAULT '0' NOT NULL,
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,
83 TSconfig
text NOT NULL,
84 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
85 createdByAction
int(11) DEFAULT '0' NOT NULL,
86 usergroup_cached_list
varchar(255) DEFAULT '' NOT NULL,
87 workspace_id
int(11) DEFAULT '0' NOT NULL,
88 workspace_preview
tinyint(3) DEFAULT '1' NOT NULL,
91 KEY username (username
)
95 #
Table structure for table 'cache_extensions'
97 CREATE TABLE cache_extensions (
98 extkey
varchar(60) NOT NULL default '',
99 version varchar(10) NOT NULL default '',
100 alldownloadcounter
int(11) unsigned
NOT NULL default '0',
101 downloadcounter
int(11) unsigned
NOT NULL default '0',
102 title
varchar(150) NOT NULL default '',
103 description mediumtext
NOT NULL,
104 state int(4) NOT NULL default '0',
105 reviewstate
int(4) NOT NULL default '0',
106 category
int(4) NOT NULL default '0',
107 lastuploaddate
int(11) unsigned
NOT NULL default '0',
108 dependencies mediumtext
NOT NULL,
109 authorname
varchar(100) NOT NULL default '',
110 authoremail
varchar(100) NOT NULL default '',
111 ownerusername
varchar(50) NOT NULL default '',
112 t3xfilemd5
varchar(35) NOT NULL default '',
113 uploadcomment mediumtext
NOT NULL,
114 authorcompany
varchar(100) NOT NULL default '',
115 intversion
int(11) NOT NULL default '0',
116 lastversion
int(3) NOT NULL default '0',
117 lastreviewedversion
int(3) NOT NULL default '0',
118 PRIMARY KEY (extkey
,version)
122 #
Table structure for table 'cache_hash'
124 CREATE TABLE cache_hash (
125 hash
varchar(32) DEFAULT '' NOT NULL,
126 content mediumblob
NOT NULL,
127 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
128 ident
varchar(20) DEFAULT '' NOT NULL,
133 #
Table structure for table 'cache_imagesizes'
135 CREATE TABLE cache_imagesizes (
136 md5hash
varchar(32) DEFAULT '' NOT NULL,
137 md5filename
varchar(32) DEFAULT '' NOT NULL,
138 tstamp
int(11) DEFAULT '0' NOT NULL,
139 filename
varchar(255) DEFAULT '' NOT NULL,
140 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
141 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
142 PRIMARY KEY (md5filename
)
146 #
Table structure for table 'pages'
149 uid
int(11) NOT NULL auto_increment
,
150 pid
int(11) DEFAULT '0' NOT NULL,
151 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
152 t3ver_id
int(11) DEFAULT '0' NOT NULL,
153 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
154 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
155 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
156 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
157 t3ver_count
int(11) DEFAULT '0' NOT NULL,
158 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
159 t3ver_swapmode
tinyint(4) DEFAULT '0' NOT NULL,
160 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
161 t3_origuid
int(11) DEFAULT '0' NOT NULL,
162 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
163 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
164 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
165 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
166 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
167 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
168 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
169 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
170 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
171 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
172 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
173 title
varchar(255) DEFAULT '' NOT NULL,
174 doktype
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
175 TSconfig
text NOT NULL,
176 storage_pid
int(11) DEFAULT '0' NOT NULL,
177 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
178 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
179 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
181 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
182 KEY parent (pid
,sorting
)
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_preview'
204 CREATE TABLE sys_preview (
205 keyword
varchar(32) DEFAULT '' NOT NULL,
206 tstamp
int(11) DEFAULT '0' NOT NULL,
207 endtime
int(11) DEFAULT '0' NOT NULL,
208 config
text NOT NULL,
209 PRIMARY KEY (keyword
)
214 #
Table structure for table 'sys_filemounts'
216 CREATE TABLE sys_filemounts (
217 uid
int(11) unsigned
NOT NULL auto_increment
,
218 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
219 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
220 title
varchar(30) DEFAULT '' NOT NULL,
221 path varchar(120) DEFAULT '' NOT NULL,
222 base
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
223 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
224 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
230 #
Table structure for table 'sys_workspace'
232 CREATE TABLE sys_workspace (
233 uid
int(11) NOT NULL auto_increment
,
234 pid
int(11) DEFAULT '0' NOT NULL,
235 tstamp
int(11) DEFAULT '0' NOT NULL,
236 deleted
tinyint(1) DEFAULT '0' NOT NULL,
237 title
varchar(30) DEFAULT '' NOT NULL,
238 description
varchar(255) DEFAULT '' NOT NULL,
239 adminusers
varchar(255) DEFAULT '' NOT NULL,
240 members
text NOT NULL,
241 reviewers
text NOT NULL,
242 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
243 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
244 publish_time
int(11) DEFAULT '0' NOT NULL,
245 unpublish_time
int(11) DEFAULT '0' NOT NULL,
246 freeze tinyint(3) DEFAULT '0' NOT NULL,
247 live_edit
tinyint(3) DEFAULT '0' NOT NULL,
248 review_stage_edit
tinyint(3) DEFAULT '0' NOT NULL,
249 vtypes
tinyint(3) DEFAULT '0' NOT NULL,
250 disable_autocreate
tinyint(1) DEFAULT '0' NOT NULL,
251 swap_modes
tinyint(3) DEFAULT '0' NOT NULL,
252 publish_access
tinyint(3) DEFAULT '0' NOT NULL,
253 stagechg_notification
tinyint(3) DEFAULT '0' NOT NULL,
260 #
Table structure for table 'sys_history'
262 CREATE TABLE sys_history (
263 uid
int(11) unsigned
NOT NULL auto_increment
,
264 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
265 history_data mediumtext
NOT NULL,
266 fieldlist
text NOT NULL,
267 recuid
int(11) DEFAULT '0' NOT NULL,
268 tablename
varchar(40) DEFAULT '' NOT NULL,
269 tstamp
int(11) DEFAULT '0' NOT NULL,
270 history_files mediumtext
NOT NULL,
271 snapshot
tinyint(4) DEFAULT '0' NOT NULL,
273 KEY recordident (tablename
,recuid
,tstamp
),
274 KEY sys_log_uid (sys_log_uid
)
278 #
Table structure for table 'sys_lockedrecords'
280 CREATE TABLE sys_lockedrecords (
281 uid
int(11) unsigned
NOT NULL auto_increment
,
282 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
283 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
284 record_table
varchar(40) DEFAULT '' NOT NULL,
285 record_uid
int(11) DEFAULT '0' NOT NULL,
286 record_pid
int(11) DEFAULT '0' NOT NULL,
287 username
varchar(20) DEFAULT '' NOT NULL,
289 KEY event (userid
,tstamp
)
293 #
Table structure for table 'sys_refindex'
295 CREATE TABLE sys_refindex (
296 hash
varchar(32) DEFAULT '' NOT NULL,
297 tablename
varchar(40) DEFAULT '' NOT NULL,
298 recuid
int(11) DEFAULT '0' NOT NULL,
299 field
varchar(40) DEFAULT '' NOT NULL,
300 flexpointer
varchar(255) DEFAULT '' NOT NULL,
301 softref_key
varchar(30) DEFAULT '' NOT NULL,
302 softref_id
varchar(40) DEFAULT '' NOT NULL,
303 sorting
int(11) DEFAULT '0' NOT NULL,
304 deleted
tinyint(1) DEFAULT '0' NOT NULL,
305 ref_table
varchar(40) DEFAULT '' NOT NULL,
306 ref_uid
int(11) DEFAULT '0' NOT NULL,
307 ref_string
varchar(200) DEFAULT '' NOT NULL,
310 KEY lookup_rec (tablename
,recuid
),
311 KEY lookup_uid (ref_table
,ref_uid
),
312 KEY lookup_string (ref_table
,ref_string
)
316 #
Table structure for table ''
318 CREATE TABLE sys_refindex_words (
319 wid
int(11) DEFAULT '0' NOT NULL,
320 baseword
varchar(60) DEFAULT '' NOT NULL,
325 #
Table structure for table ''
327 CREATE TABLE sys_refindex_rel (
328 rid
int(11) DEFAULT '0' NOT NULL,
329 wid
int(11) DEFAULT '0' NOT NULL,
330 PRIMARY KEY (rid
,wid
)
335 #
Table structure for table ''
337 CREATE TABLE sys_refindex_res (
338 rid
int(11) DEFAULT '0' NOT NULL,
339 tablename
varchar(100) DEFAULT '' NOT NULL,
340 recuid
int(11) DEFAULT '0' NOT NULL,
345 #
Table structure for table 'sys_log'
347 CREATE TABLE sys_log (
348 uid
int(11) unsigned
NOT NULL auto_increment
,
349 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
350 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
351 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
352 tablename
varchar(40) DEFAULT '' NOT NULL,
353 recpid
int(11) DEFAULT '0' NOT NULL,
354 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
355 details
varchar(255) DEFAULT '' NOT NULL,
356 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
357 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
358 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
359 IP
varchar(39) DEFAULT '' NOT NULL,
360 log_data
varchar(255) DEFAULT '' NOT NULL,
361 event_pid
int(11) DEFAULT '-1' NOT NULL,
362 workspace
int(11) DEFAULT '0' NOT NULL,
363 NEWid
varchar(20) DEFAULT '' NOT NULL,
365 KEY event (userid
,event_pid
),
366 KEY recuidIdx (recuid
,uid
)
370 #
Table structure for table 'sys_language'
372 CREATE TABLE sys_language (
373 uid
int(11) unsigned
NOT NULL auto_increment
,
374 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
375 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
376 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
377 title
varchar(80) DEFAULT '' NOT NULL,
378 flag varchar(20) DEFAULT '' NOT NULL,
379 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,