3 #
Host: localhost
Database: t3_testsite
4 #
--------------------------------------------------------
5 #
Server version 3.22.27
10 #
Table structure for table 'be_groups'
12 CREATE TABLE be_groups (
13 uid
int(11) unsigned
NOT NULL auto_increment
,
14 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
15 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
16 title
varchar(50) DEFAULT '' NOT NULL,
17 non_exclude_fields
text NOT NULL,
18 explicit_allowdeny
text NOT NULL,
19 allowed_languages tinytext
NOT NULL,
20 custom_options
text NOT NULL,
21 db_mountpoints
varchar(40) DEFAULT '' NOT NULL,
22 pagetypes_select tinytext
NOT NULL,
23 tables_select
text NOT NULL,
24 tables_modify
text NOT NULL,
25 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
26 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
27 groupMods tinytext
NOT NULL,
28 file_mountpoints
varchar(40) DEFAULT '' NOT NULL,
29 hidden
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
30 inc_access_lists
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
31 description
text NOT NULL,
32 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
33 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
34 TSconfig
text NOT NULL,
35 subgroup tinytext
NOT NULL,
36 hide_in_lists
tinyint(4) DEFAULT '0' NOT NULL,
37 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
43 #
Table structure for table 'be_sessions'
45 CREATE TABLE be_sessions (
46 ses_id
varchar(32) DEFAULT '' NOT NULL,
47 ses_name
varchar(32) DEFAULT '' NOT NULL,
48 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
49 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
50 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
51 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
52 ses_data mediumtext
NOT NULL,
53 ses_backuserid
int(11) NOT NULL default '0',
54 PRIMARY KEY (ses_id
,ses_name
)
58 #
Table structure for table 'be_users'
60 CREATE TABLE be_users (
61 uid
int(11) unsigned
NOT NULL auto_increment
,
62 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
63 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
64 username
varchar(50) DEFAULT '' NOT NULL,
65 password varchar(40) DEFAULT '' NOT NULL,
66 admin tinyint(4) unsigned
DEFAULT '0' NOT NULL,
67 usergroup tinytext
NOT NULL,
68 disable tinyint(1) unsigned
DEFAULT '0' NOT NULL,
69 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
70 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
71 lang
varchar(2) DEFAULT '' NOT NULL,
72 email
varchar(80) DEFAULT '' NOT NULL,
73 db_mountpoints
varchar(40) DEFAULT '' NOT NULL,
74 options tinyint(4) unsigned
DEFAULT '0' NOT NULL,
75 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
76 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
77 realName
varchar(80) DEFAULT '' NOT NULL,
78 userMods tinytext
NOT NULL,
79 allowed_languages tinytext
NOT NULL,
81 file_mountpoints
varchar(40) DEFAULT '' NOT NULL,
82 fileoper_perms
tinyint(4) DEFAULT '0' NOT NULL,
83 workspace_perms
tinyint(3) DEFAULT '1' NOT NULL,
84 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
85 disableIPlock
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
86 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
87 TSconfig
text NOT NULL,
88 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
89 createdByAction
int(11) DEFAULT '0' NOT NULL,
90 usergroup_cached_list tinytext
NOT NULL,
91 workspace_id
int(11) DEFAULT '0' NOT NULL,
92 workspace_preview
tinyint(3) DEFAULT '1' NOT NULL,
95 KEY username (username
)
99 #
Table structure for table 'cache_hash'
101 CREATE TABLE cache_hash (
102 hash
varchar(32) DEFAULT '' NOT NULL,
103 content mediumtext
NOT NULL,
104 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
105 ident
varchar(20) DEFAULT '' NOT NULL,
110 #
Table structure for table 'cache_imagesizes'
112 CREATE TABLE cache_imagesizes (
113 md5hash
varchar(32) DEFAULT '' NOT NULL,
114 md5filename
varchar(32) DEFAULT '' NOT NULL,
115 tstamp
int(11) DEFAULT '0' NOT NULL,
116 filename tinytext
NOT NULL,
117 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
118 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
119 PRIMARY KEY (md5filename
)
123 #
Table structure for table 'pages'
126 uid
int(11) NOT NULL auto_increment
,
127 pid
int(11) DEFAULT '0' NOT NULL,
128 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
129 t3ver_id
int(11) DEFAULT '0' NOT NULL,
130 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
131 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
132 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
133 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
134 t3ver_count
int(11) DEFAULT '0' NOT NULL,
135 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
136 t3ver_swapmode
tinyint(4) DEFAULT '0' NOT NULL,
137 t3_origuid
int(11) DEFAULT '0' NOT NULL,
138 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
139 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
140 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
141 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
142 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
143 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
144 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
145 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
146 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
147 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
148 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
149 title tinytext
NOT NULL,
150 doktype
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
151 TSconfig
text NOT NULL,
152 storage_pid
int(11) DEFAULT '0' NOT NULL,
153 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
154 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
155 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
157 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
162 #
Table structure for table 'sys_be_shortcuts'
164 CREATE TABLE sys_be_shortcuts (
165 uid
int(11) unsigned
NOT NULL auto_increment
,
166 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
167 module_name tinytext
NOT NULL,
169 description tinytext
NOT NULL,
170 sorting
int(11) DEFAULT '0' NOT NULL,
171 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
178 #
Table structure for table 'sys_preview'
180 CREATE TABLE sys_preview (
181 keyword
varchar(32) DEFAULT '' NOT NULL,
182 tstamp
int(11) DEFAULT '0' NOT NULL,
183 endtime
int(11) DEFAULT '0' NOT NULL,
184 config
text NOT NULL,
185 PRIMARY KEY (keyword
)
190 #
Table structure for table 'sys_filemounts'
192 CREATE TABLE sys_filemounts (
193 uid
int(11) unsigned
NOT NULL auto_increment
,
194 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
195 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
196 title
varchar(30) DEFAULT '' NOT NULL,
197 path varchar(120) DEFAULT '' NOT NULL,
198 base
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
199 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
200 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
206 #
Table structure for table 'sys_workspace'
208 CREATE TABLE sys_workspace (
209 uid
int(11) NOT NULL auto_increment
,
210 pid
int(11) DEFAULT '0' NOT NULL,
211 tstamp
int(11) DEFAULT '0' NOT NULL,
212 deleted
tinyint(1) DEFAULT '0' NOT NULL,
213 title
varchar(30) DEFAULT '' NOT NULL,
214 description tinytext
NOT NULL,
215 adminusers tinytext
NOT NULL,
216 members
text NOT NULL,
217 reviewers
text NOT NULL,
218 db_mountpoints tinytext
NOT NULL,
219 file_mountpoints tinytext
NOT NULL,
220 publish_time
int(11) DEFAULT '0' NOT NULL,
221 unpublish_time
int(11) DEFAULT '0' NOT NULL,
222 freeze tinyint(3) DEFAULT '0' NOT NULL,
223 live_edit
tinyint(3) DEFAULT '0' NOT NULL,
224 review_stage_edit
tinyint(3) DEFAULT '0' NOT NULL,
225 vtypes
tinyint(3) DEFAULT '0' NOT NULL,
226 disable_autocreate
tinyint(1) DEFAULT '0' NOT NULL,
227 swap_modes
tinyint(3) DEFAULT '0' NOT NULL,
228 publish_access
tinyint(3) DEFAULT '0' NOT NULL,
229 stagechg_notification
tinyint(3) DEFAULT '0' NOT NULL,
236 #
Table structure for table 'sys_history'
238 CREATE TABLE sys_history (
239 uid
int(11) unsigned
NOT NULL auto_increment
,
240 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
241 history_data mediumtext
NOT NULL,
242 fieldlist
text NOT NULL,
243 recuid
int(11) DEFAULT '0' NOT NULL,
244 tablename
varchar(40) DEFAULT '' NOT NULL,
245 tstamp
int(11) DEFAULT '0' NOT NULL,
246 history_files mediumtext
NOT NULL,
247 snapshot
tinyint(4) DEFAULT '0' NOT NULL,
249 KEY recordident (tablename
,recuid
),
250 KEY sys_log_uid (sys_log_uid
)
254 #
Table structure for table 'sys_lockedrecords'
256 CREATE TABLE sys_lockedrecords (
257 uid
int(11) unsigned
NOT NULL auto_increment
,
258 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
259 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
260 record_table
varchar(40) DEFAULT '' NOT NULL,
261 record_uid
int(11) DEFAULT '0' NOT NULL,
262 record_pid
int(11) DEFAULT '0' NOT NULL,
263 username
varchar(20) DEFAULT '' NOT NULL,
265 KEY event (userid
,tstamp
)
269 #
Table structure for table 'sys_refindex'
271 CREATE TABLE sys_refindex (
272 hash
varchar(32) DEFAULT '' NOT NULL,
273 tablename
varchar(40) DEFAULT '' NOT NULL,
274 recuid
int(11) DEFAULT '0' NOT NULL,
275 field
varchar(40) DEFAULT '' NOT NULL,
276 flexpointer tinytext
NOT NULL,
277 softref_key
varchar(30) DEFAULT '' NOT NULL,
278 softref_id
varchar(40) DEFAULT '' NOT NULL,
279 sorting
int(11) DEFAULT '0' NOT NULL,
280 deleted
tinyint(1) DEFAULT '0' NOT NULL,
281 ref_table
varchar(40) DEFAULT '' NOT NULL,
282 ref_uid
int(11) DEFAULT '0' NOT NULL,
283 ref_string
varchar(200) DEFAULT '' NOT NULL,
286 KEY lookup_rec (tablename
,recuid
),
287 KEY lookup_uid (ref_table
,ref_uid
),
288 KEY lookup_string (ref_table
,ref_string
)
292 #
Table structure for table ''
294 CREATE TABLE sys_refindex_words (
295 wid
int(11) DEFAULT '0' NOT NULL,
296 baseword
varchar(60) DEFAULT '' NOT NULL,
301 #
Table structure for table ''
303 CREATE TABLE sys_refindex_rel (
304 rid
int(11) DEFAULT '0' NOT NULL,
305 wid
int(11) DEFAULT '0' NOT NULL,
306 PRIMARY KEY (rid
,wid
)
311 #
Table structure for table ''
313 CREATE TABLE sys_refindex_res (
314 rid
int(11) DEFAULT '0' NOT NULL,
315 tablename
varchar(100) DEFAULT '' NOT NULL,
316 recuid
int(11) DEFAULT '0' NOT NULL,
321 #
Table structure for table 'sys_log'
323 CREATE TABLE sys_log (
324 uid
int(11) unsigned
NOT NULL auto_increment
,
325 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
326 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
327 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
328 tablename
varchar(40) DEFAULT '' NOT NULL,
329 recpid
int(11) DEFAULT '0' NOT NULL,
330 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
331 details tinytext
NOT NULL,
332 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
333 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
334 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
335 IP
varchar(39) DEFAULT '' NOT NULL,
336 log_data tinytext
NOT NULL,
337 event_pid
int(11) DEFAULT '-1' NOT NULL,
338 workspace
int(11) DEFAULT '0' NOT NULL,
339 NEWid
varchar(20) DEFAULT '' NOT NULL,
341 KEY event (userid
,event_pid
)
345 #
Table structure for table 'sys_language'
347 CREATE TABLE sys_language (
348 uid
int(11) unsigned
NOT NULL auto_increment
,
349 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
350 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
351 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
352 title
varchar(80) DEFAULT '' NOT NULL,
353 flag varchar(20) DEFAULT '' NOT NULL,
354 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,