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(20) 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(20) 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 vtypes
tinyint(3) DEFAULT '0' NOT NULL,
225 disable_autocreate
tinyint(1) DEFAULT '0' NOT NULL,
226 swap_modes
tinyint(3) DEFAULT '0' NOT NULL,
227 publish_access
tinyint(3) DEFAULT '0' NOT NULL,
228 stagechg_notification
tinyint(3) DEFAULT '0' NOT NULL,
235 #
Table structure for table 'sys_history'
237 CREATE TABLE sys_history (
238 uid
int(11) unsigned
NOT NULL auto_increment
,
239 sys_log_uid
int(11) DEFAULT '0' NOT NULL,
240 history_data mediumtext
NOT NULL,
241 fieldlist
text NOT NULL,
242 recuid
int(11) DEFAULT '0' NOT NULL,
243 tablename
varchar(40) DEFAULT '' NOT NULL,
244 tstamp
int(11) DEFAULT '0' NOT NULL,
245 history_files mediumtext
NOT NULL,
246 snapshot
tinyint(4) DEFAULT '0' NOT NULL,
248 KEY recordident (tablename
,recuid
),
249 KEY sys_log_uid (sys_log_uid
)
253 #
Table structure for table 'sys_lockedrecords'
255 CREATE TABLE sys_lockedrecords (
256 uid
int(11) unsigned
NOT NULL auto_increment
,
257 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
258 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
259 record_table
varchar(40) DEFAULT '' NOT NULL,
260 record_uid
int(11) DEFAULT '0' NOT NULL,
261 record_pid
int(11) DEFAULT '0' NOT NULL,
262 username
varchar(20) DEFAULT '' NOT NULL,
264 KEY event (userid
,tstamp
)
268 #
Table structure for table 'sys_refindex'
270 CREATE TABLE sys_refindex (
271 hash
varchar(32) DEFAULT '' NOT NULL,
272 tablename
varchar(40) DEFAULT '' NOT NULL,
273 recuid
int(11) DEFAULT '0' NOT NULL,
274 field
varchar(40) DEFAULT '' NOT NULL,
275 flexpointer tinytext
NOT NULL,
276 softref_key
varchar(30) DEFAULT '' NOT NULL,
277 softref_id
varchar(40) DEFAULT '' NOT NULL,
278 sorting
int(11) DEFAULT '0' NOT NULL,
279 deleted
tinyint(1) DEFAULT '0' NOT NULL,
280 ref_table
varchar(40) DEFAULT '' NOT NULL,
281 ref_uid
int(11) DEFAULT '0' NOT NULL,
282 ref_string
varchar(200) DEFAULT '' NOT NULL,
285 KEY lookup_rec (tablename
,recuid
),
286 KEY lookup_uid (ref_table
,ref_uid
),
287 KEY lookup_string (ref_table
,ref_string(199))
291 #
Table structure for table 'sys_log'
293 CREATE TABLE sys_log (
294 uid
int(11) unsigned
NOT NULL auto_increment
,
295 userid
int(11) unsigned
DEFAULT '0' NOT NULL,
296 action tinyint(4) unsigned
DEFAULT '0' NOT NULL,
297 recuid
int(11) unsigned
DEFAULT '0' NOT NULL,
298 tablename
varchar(40) DEFAULT '' NOT NULL,
299 recpid
int(11) DEFAULT '0' NOT NULL,
300 error
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
301 details tinytext
NOT NULL,
302 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
303 type tinyint(3) unsigned
DEFAULT '0' NOT NULL,
304 details_nr
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
305 IP
varchar(39) DEFAULT '' NOT NULL,
306 log_data tinytext
NOT NULL,
307 event_pid
int(11) DEFAULT '-1' NOT NULL,
308 workspace
int(11) DEFAULT '0' NOT NULL,
309 NEWid
varchar(20) DEFAULT '' NOT NULL,
311 KEY event (userid
,event_pid
)
315 #
Table structure for table 'sys_language'
317 CREATE TABLE sys_language (
318 uid
int(11) unsigned
NOT NULL auto_increment
,
319 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
320 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
321 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
322 title
varchar(80) DEFAULT '' NOT NULL,
323 flag varchar(20) DEFAULT '' NOT NULL,
324 static_lang_isocode
int(11) unsigned
DEFAULT '0' NOT NULL,