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(255) 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
text NOT NULL,
28 file_mountpoints
varchar(255) 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 longtext
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
char(2) DEFAULT '' NOT NULL,
72 email
varchar(80) DEFAULT '' NOT NULL,
73 db_mountpoints
varchar(255) 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(255) 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_extensions'
101 CREATE TABLE cache_extensions (
102 extkey
varchar(60) NOT NULL default '',
103 version varchar(10) NOT NULL default '',
104 alldownloadcounter
int(11) unsigned
NOT NULL default '0',
105 downloadcounter
int(11) unsigned
NOT NULL default '0',
106 title
varchar(150) NOT NULL default '',
107 description mediumtext
NOT NULL,
108 state int(4) NOT NULL default '0',
109 reviewstate
int(4) unsigned
NOT NULL default '0',
110 category
int(4) NOT NULL default '0',
111 lastuploaddate
int(11) unsigned
NOT NULL default '0',
112 dependencies mediumtext
NOT NULL,
113 authorname
varchar(100) NOT NULL default '',
114 authoremail
varchar(100) NOT NULL default '',
115 ownerusername
varchar(50) NOT NULL default '',
116 t3xfilemd5
varchar(35) NOT NULL default '',
117 uploadcomment mediumtext
NOT NULL,
118 authorcompany
varchar(100) NOT NULL default '',
119 intversion
int(11) NOT NULL default '0',
120 lastversion
int(3) NOT NULL default '0',
121 lastreviewedversion
int(3) NOT NULL default '0',
122 PRIMARY KEY (extkey
,version)
126 #
Table structure for table 'cache_hash'
128 CREATE TABLE cache_hash (
129 hash
varchar(32) DEFAULT '' NOT NULL,
130 content mediumtext
NOT NULL,
131 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
132 ident
varchar(20) DEFAULT '' NOT NULL,
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 tinytext
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(30) 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 t3_origuid
int(11) DEFAULT '0' NOT NULL,
165 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
166 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
167 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
168 perms_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
169 perms_groupid
int(11) unsigned
DEFAULT '0' NOT NULL,
170 perms_user
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
171 perms_group
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
172 perms_everybody
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
173 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
174 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
175 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
176 title tinytext
NOT NULL,
177 doktype
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
178 TSconfig
text NOT NULL,
179 storage_pid
int(11) DEFAULT '0' NOT NULL,
180 is_siteroot
tinyint(4) DEFAULT '0' NOT NULL,
181 php_tree_stop
tinyint(4) DEFAULT '0' NOT NULL,
182 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
184 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
185 KEY parent (pid
,sorting
)
189 #
Table structure for table 'sys_be_shortcuts'
191 CREATE TABLE sys_be_shortcuts (
192 uid
int(11) unsigned
NOT NULL auto_increment
,
193 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
194 module_name tinytext
NOT NULL,
196 description tinytext
NOT NULL,
197 sorting
int(11) DEFAULT '0' NOT NULL,
198 sc_group
tinyint(4) DEFAULT '0' NOT NULL,
205 #
Table structure for table 'sys_preview'
207 CREATE TABLE sys_preview (
208 keyword
varchar(32) DEFAULT '' NOT NULL,
209 tstamp
int(11) DEFAULT '0' NOT NULL,
210 endtime
int(11) DEFAULT '0' NOT NULL,
211 config
text NOT NULL,
212 PRIMARY KEY (keyword
)
217 #
Table structure for table 'sys_filemounts'
219 CREATE TABLE sys_filemounts (
220 uid
int(11) unsigned
NOT NULL auto_increment
,
221 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
222 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
223 title
varchar(30) DEFAULT '' NOT NULL,
224 path varchar(120) DEFAULT '' NOT NULL,
225 base
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
226 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
227 deleted
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
233 #
Table structure for table 'sys_workspace'
235 CREATE TABLE sys_workspace (
236 uid
int(11) NOT NULL auto_increment
,
237 pid
int(11) DEFAULT '0' NOT NULL,
238 tstamp
int(11) DEFAULT '0' NOT NULL,
239 deleted
tinyint(1) DEFAULT '0' NOT NULL,
240 title
varchar(30) DEFAULT '' NOT NULL,
241 description tinytext
NOT NULL,
242 adminusers tinytext
NOT NULL,
243 members
text NOT NULL,
244 reviewers
text NOT NULL,
245 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
246 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
247 publish_time
int(11) DEFAULT '0' NOT NULL,
248 unpublish_time
int(11) DEFAULT '0' NOT NULL,
249 freeze tinyint(3) DEFAULT '0' NOT NULL,
250 live_edit
tinyint(3) DEFAULT '0' NOT NULL,
251 review_stage_edit
tinyint(3) DEFAULT '0' NOT NULL,
252 vtypes
tinyint(3) DEFAULT '0' NOT NULL,
253 disable_autocreate
tinyint(1) DEFAULT '0' NOT NULL,
254 swap_modes
tinyint(3) DEFAULT '0' NOT NULL,
255 publish_access
tinyint(3) DEFAULT '0' NOT NULL,
256 stagechg_notification
tinyint(3) DEFAULT '0' NOT NULL,
263 #
Table structure for table 'sys_history'
265 CREATE TABLE sys_history (
266 uid
int(11) unsigned
NOT NULL auto_increment
,
267 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
268 history_data mediumtext
NOT NULL,
269 fieldlist
text NOT NULL,
270 recuid
int(11) DEFAULT '0' NOT NULL,
271 tablename
varchar(40) DEFAULT '' NOT NULL,
272 tstamp
int(11) DEFAULT '0' NOT NULL,
273 history_files mediumtext
NOT NULL,
274 snapshot
tinyint(4) DEFAULT '0' NOT NULL,
276 KEY recordident (tablename
,recuid
,tstamp
),
277 KEY sys_log_uid (sys_log_uid
),
281 #
Table structure for table 'sys_lockedrecords'
283 CREATE TABLE sys_lockedrecords (
284 uid
int(11) unsigned
NOT NULL auto_increment
,
285 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
286 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
287 record_table
varchar(40) DEFAULT '' NOT NULL,
288 record_uid
int(11) DEFAULT '0' NOT NULL,
289 record_pid
int(11) DEFAULT '0' NOT NULL,
290 username
varchar(20) DEFAULT '' NOT NULL,
292 KEY event (userid
,tstamp
)
296 #
Table structure for table 'sys_refindex'
298 CREATE TABLE sys_refindex (
299 hash
varchar(32) DEFAULT '' NOT NULL,
300 tablename
varchar(40) DEFAULT '' NOT NULL,
301 recuid
int(11) DEFAULT '0' NOT NULL,
302 field
varchar(40) DEFAULT '' NOT NULL,
303 flexpointer tinytext
NOT NULL,
304 softref_key
varchar(30) DEFAULT '' NOT NULL,
305 softref_id
varchar(40) DEFAULT '' NOT NULL,
306 sorting
int(11) DEFAULT '0' NOT NULL,
307 deleted
tinyint(1) DEFAULT '0' NOT NULL,
308 ref_table
varchar(40) DEFAULT '' NOT NULL,
309 ref_uid
int(11) DEFAULT '0' NOT NULL,
310 ref_string
varchar(200) DEFAULT '' NOT NULL,
313 KEY lookup_rec (tablename
,recuid
),
314 KEY lookup_uid (ref_table
,ref_uid
),
315 KEY lookup_string (ref_table
,ref_string
)
319 #
Table structure for table ''
321 CREATE TABLE sys_refindex_words (
322 wid
int(11) DEFAULT '0' NOT NULL,
323 baseword
varchar(60) DEFAULT '' NOT NULL,
328 #
Table structure for table ''
330 CREATE TABLE sys_refindex_rel (
331 rid
int(11) DEFAULT '0' NOT NULL,
332 wid
int(11) DEFAULT '0' NOT NULL,
333 PRIMARY KEY (rid
,wid
)
338 #
Table structure for table ''
340 CREATE TABLE sys_refindex_res (
341 rid
int(11) DEFAULT '0' NOT NULL,
342 tablename
varchar(100) DEFAULT '' NOT NULL,
343 recuid
int(11) DEFAULT '0' NOT NULL,
348 #
Table structure for table 'sys_log'
350 CREATE TABLE sys_log (
351 uid
int(11) unsigned
NOT NULL auto_increment
,
352 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
353 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
354 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
355 tablename
varchar(40) DEFAULT '' NOT NULL,
356 recpid
int(11) DEFAULT '0' NOT NULL,
357 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
358 details tinytext
NOT NULL,
359 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
360 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
361 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
362 IP
varchar(39) DEFAULT '' NOT NULL,
363 log_data tinytext
NOT NULL,
364 event_pid
int(11) DEFAULT '-1' NOT NULL,
365 workspace
int(11) DEFAULT '0' NOT NULL,
366 NEWid
varchar(20) DEFAULT '' NOT NULL,
368 KEY event (userid
,event_pid
),
369 KEY recuidIdx (recuid
,uid
)
373 #
Table structure for table 'sys_language'
375 CREATE TABLE sys_language (
376 uid
int(11) unsigned
NOT NULL auto_increment
,
377 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
378 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
379 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
380 title
varchar(80) DEFAULT '' NOT NULL,
381 flag varchar(20) DEFAULT '' NOT NULL,
382 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,