2 #
Table structure for table 'cache_md5params'
4 CREATE TABLE cache_md5params (
5 md5hash
varchar(20) DEFAULT '' NOT NULL,
6 tstamp
int(11) DEFAULT '0' NOT NULL,
7 type tinyint(3) DEFAULT '0' NOT NULL,
14 #
Table structure for table 'cache_treelist'
16 CREATE TABLE cache_treelist (
17 md5hash
char(32) DEFAULT '' NOT NULL,
18 pid
int(11) DEFAULT '0' NOT NULL,
20 tstamp
int(11) DEFAULT '0' NOT NULL,
21 expires
int(11) unsigned
DEFAULT '0' NOT NULL,
27 #
Table structure for table 'fe_groups'
29 CREATE TABLE fe_groups (
30 uid
int(11) unsigned
NOT NULL auto_increment
,
31 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
32 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
33 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
34 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
35 title
varchar(50) DEFAULT '' NOT NULL,
36 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
37 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
38 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
49 #
Table structure for table 'fe_sessions'
51 CREATE TABLE fe_sessions (
52 ses_id
varchar(32) DEFAULT '' NOT NULL,
53 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
54 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
55 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
57 ses_permanent
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
58 ses_anonymous
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
61 KEY ses_tstamp (ses_tstamp
)
65 #
Table structure for table 'fe_users'
67 CREATE TABLE fe_users (
68 uid
int(11) unsigned
NOT NULL auto_increment
,
69 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
70 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
71 username
varchar(255) DEFAULT '' NOT NULL,
72 password varchar(100) DEFAULT '' NOT NULL,
74 disable tinyint(4) unsigned
DEFAULT '0' NOT NULL,
75 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
76 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
77 name varchar(160) DEFAULT '' NOT NULL,
78 first_name
varchar(50) DEFAULT '' NOT NULL,
79 middle_name
varchar(50) DEFAULT '' NOT NULL,
80 last_name
varchar(50) DEFAULT '' NOT NULL,
81 address
varchar(255) DEFAULT '' NOT NULL,
82 telephone
varchar(30) DEFAULT '' NOT NULL,
83 fax
varchar(30) DEFAULT '' NOT NULL,
84 email
varchar(255) DEFAULT '' NOT NULL,
85 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
86 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
87 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
88 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
91 title
varchar(40) DEFAULT '' NOT NULL,
92 zip
varchar(10) DEFAULT '' NOT NULL,
93 city
varchar(50) DEFAULT '' NOT NULL,
94 country
varchar(40) DEFAULT '' NOT NULL,
95 www
varchar(80) DEFAULT '' NOT NULL,
96 company
varchar(80) DEFAULT '' NOT NULL,
99 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
100 is_online
int(10) unsigned
DEFAULT '0' NOT NULL,
103 KEY parent (pid
,username
),
104 KEY username (username
),
105 KEY is_online (is_online
)
109 #
Table structure for table 'pages_language_overlay'
111 CREATE TABLE pages_language_overlay (
112 uid
int(11) NOT NULL auto_increment
,
113 pid
int(11) DEFAULT '0' NOT NULL,
114 doktype
int(11) unsigned
DEFAULT '0' NOT NULL,
115 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
116 t3ver_id
int(11) DEFAULT '0' NOT NULL,
117 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
118 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
119 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
120 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
121 t3ver_count
int(11) DEFAULT '0' NOT NULL,
122 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
123 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
124 t3_origuid
int(11) DEFAULT '0' NOT NULL,
125 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
126 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
127 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
128 sys_language_uid
int(11) unsigned
DEFAULT '0' NOT NULL,
129 title
varchar(255) DEFAULT '' NOT NULL,
130 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
131 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
132 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
133 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
134 subtitle
varchar(255) DEFAULT '' NOT NULL,
135 nav_title
varchar(255) DEFAULT '' NOT NULL,
136 media
int(11) unsigned
DEFAULT '0' NOT NULL,
140 author
varchar(255) DEFAULT '' NOT NULL,
141 author_email
varchar(80) DEFAULT '' NOT NULL,
142 l18n_diffsource mediumblob
,
143 url
varchar(255) DEFAULT '' NOT NULL,
144 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
145 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
148 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
149 KEY parent (pid
,sys_language_uid
)
153 #
Table structure for table 'sys_domain'
155 CREATE TABLE sys_domain (
156 uid
int(11) unsigned
NOT NULL auto_increment
,
157 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
158 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
159 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
160 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
161 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
162 domainName
varchar(80) DEFAULT '' NOT NULL,
163 redirectTo
varchar(255) DEFAULT '' NOT NULL,
164 redirectHttpStatusCode
int(4) unsigned
DEFAULT '301' NOT NULL,
165 sorting
int(10) unsigned
DEFAULT '0' NOT NULL,
166 prepend_params
int(10) DEFAULT '0' NOT NULL,
167 forced
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
171 KEY getSysDomain (redirectTo
,hidden
),
172 KEY getDomainStartPage (pid
,hidden
,domainName
)
176 #
Table structure for table 'sys_template'
178 CREATE TABLE sys_template (
179 uid
int(11) NOT NULL auto_increment
,
180 pid
int(11) DEFAULT '0' NOT NULL,
181 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
182 t3ver_id
int(11) DEFAULT '0' NOT NULL,
183 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
184 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
185 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
186 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
187 t3ver_count
int(11) DEFAULT '0' NOT NULL,
188 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
189 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
190 t3_origuid
int(11) DEFAULT '0' NOT NULL,
191 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
192 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
193 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
194 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
195 title
varchar(255) DEFAULT '' NOT NULL,
196 sitetitle
varchar(255) DEFAULT '' NOT NULL,
197 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
198 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
199 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
200 root
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
201 clear
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
202 include_static_file
text,
205 nextLevel
varchar(5) DEFAULT '' NOT NULL,
208 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
209 includeStaticAfterBasedOn
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
210 static_file_mode
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
213 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
214 KEY parent (pid
,deleted
,hidden
,sorting
),
215 KEY roottemplate (deleted
,hidden
,root
)
219 #
Table structure for table 'tt_content'
221 CREATE TABLE tt_content (
222 uid
int(11) NOT NULL auto_increment
,
223 pid
int(11) DEFAULT '0' NOT NULL,
224 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
225 t3ver_id
int(11) DEFAULT '0' NOT NULL,
226 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
227 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
228 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
229 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
230 t3ver_count
int(11) DEFAULT '0' NOT NULL,
231 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
232 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
233 t3_origuid
int(11) DEFAULT '0' NOT NULL,
234 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
235 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
236 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
237 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
238 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
239 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
240 CType
varchar(255) DEFAULT '' NOT NULL,
241 header varchar(255) DEFAULT '' NOT NULL,
242 header_position
varchar(6) DEFAULT '' NOT NULL,
245 bullets_type
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
246 uploads_description
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
247 uploads_type
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
248 assets
int(11) unsigned
DEFAULT '0' NOT NULL,
249 image
int(11) unsigned
DEFAULT '0' NOT NULL,
250 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
251 imageorient
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
252 imagecols
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
253 imageborder
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
254 media
int(11) unsigned
DEFAULT '0' NOT NULL,
255 layout
int(11) unsigned
DEFAULT '0' NOT NULL,
256 frame_class
varchar(60) DEFAULT 'default' NOT NULL,
257 deleted
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
258 cols
int(11) unsigned
DEFAULT '0' NOT NULL,
259 spaceBefore
smallint(5) unsigned
DEFAULT '0' NOT NULL,
260 spaceAfter
smallint(5) unsigned
DEFAULT '0' NOT NULL,
261 space_before_class
varchar(60) DEFAULT '' NOT NULL,
262 space_after_class
varchar(60) DEFAULT '' NOT NULL,
265 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
266 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
267 colPos
int(11) unsigned
DEFAULT '0' NOT NULL,
268 subheader
varchar(255) DEFAULT '' NOT NULL,
269 fe_group
varchar(100) DEFAULT '0' NOT NULL,
270 header_link
varchar(1024) DEFAULT '' NOT NULL,
271 image_zoom
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
272 header_layout
varchar(30) DEFAULT '0' NOT NULL,
273 list_type
varchar(255) DEFAULT '' NOT NULL,
274 sectionIndex
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
275 linkToTop
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
276 file_collections
text,
277 filelink_size
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
278 filelink_sorting
varchar(17) DEFAULT '' NOT NULL,
279 filelink_sorting_direction
varchar(4) DEFAULT '' NOT NULL,
280 target
varchar(30) DEFAULT '' NOT NULL,
281 date int(10) unsigned
DEFAULT '0' NOT NULL,
282 recursive tinyint(3) unsigned
DEFAULT '0' NOT NULL,
283 imageheight
mediumint(8) unsigned
DEFAULT '0' NOT NULL,
284 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
285 pi_flexform mediumtext
,
286 accessibility_title
varchar(30) DEFAULT '' NOT NULL,
287 accessibility_bypass
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
288 accessibility_bypass_text
varchar(30) DEFAULT '' NOT NULL,
289 l18n_parent
int(11) DEFAULT '0' NOT NULL,
290 l18n_diffsource mediumblob
,
291 l10n_source
int(11) DEFAULT '0' NOT NULL,
292 selected_categories
text,
293 category_field
varchar(64) DEFAULT '' NOT NULL,
294 table_class
varchar(60) DEFAULT '' NOT NULL,
295 table_caption
varchar(255) DEFAULT NULL,
296 table_delimiter
smallint(6) unsigned
DEFAULT '0' NOT NULL,
297 table_enclosure
smallint(6) unsigned
DEFAULT '0' NOT NULL,
298 table_header_position
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
299 table_tfoot
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
302 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
303 KEY parent (pid
,sorting
),
304 KEY language (l18n_parent
,sys_language_uid
)
308 #
Table structure for table 'backend_layout'
310 CREATE TABLE backend_layout (
311 uid
int(11) NOT NULL auto_increment
,
312 pid
int(11) DEFAULT '0' NOT NULL,
313 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
314 t3ver_id
int(11) DEFAULT '0' NOT NULL,
315 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
316 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
317 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
318 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
319 t3ver_count
int(11) DEFAULT '0' NOT NULL,
320 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
321 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
322 t3_origuid
int(11) DEFAULT '0' NOT NULL,
323 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
324 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
325 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
326 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
327 deleted
tinyint(4) DEFAULT '0' NOT NULL,
328 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
329 title
varchar(255) DEFAULT '' NOT NULL,
331 config
text NOT NULL,
336 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
)