7 #
Table structure for table 'cache_pages'
9 CREATE TABLE cache_pages (
10 id int(11) unsigned
NOT NULL auto_increment
,
11 identifier
varchar(250) DEFAULT '' NOT NULL,
12 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
15 lifetime
int(11) unsigned
DEFAULT '0' NOT NULL,
17 KEY cache_id (identifier
)
22 #
Table structure for table 'cache_pagesection'
24 CREATE TABLE cache_pagesection (
25 id int(11) unsigned
NOT NULL auto_increment
,
26 identifier
varchar(250) DEFAULT '' NOT NULL,
27 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
30 lifetime
int(11) unsigned
DEFAULT '0' NOT NULL,
32 KEY cache_id (identifier
)
37 #
Table structure for table 'cache_typo3temp_log'
39 CREATE TABLE cache_typo3temp_log (
40 md5hash
varchar(32) DEFAULT '' NOT NULL,
41 tstamp
int(11) DEFAULT '0' NOT NULL,
42 filename
varchar(255) DEFAULT '' NOT NULL,
43 orig_filename
varchar(255) DEFAULT '' NOT NULL,
49 #
Table structure for table 'cache_md5params'
51 CREATE TABLE cache_md5params (
52 md5hash
varchar(20) DEFAULT '' NOT NULL,
53 tstamp
int(11) DEFAULT '0' NOT NULL,
54 type tinyint(3) DEFAULT '0' NOT NULL,
61 #
Table structure for table 'cache_imagesizes'
63 CREATE TABLE cache_imagesizes (
64 md5hash
varchar(32) DEFAULT '' NOT NULL,
65 md5filename
varchar(32) DEFAULT '' NOT NULL,
66 tstamp
int(11) DEFAULT '0' NOT NULL,
67 filename
varchar(255) DEFAULT '' NOT NULL,
68 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
69 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
70 PRIMARY KEY (md5filename
)
75 #
Table structure for table 'cache_treelist'
77 CREATE TABLE cache_treelist (
78 md5hash
char(32) DEFAULT '' NOT NULL,
79 pid
int(11) DEFAULT '0' NOT NULL,
81 tstamp
int(11) DEFAULT '0' NOT NULL,
82 expires
int(11) unsigned
DEFAULT '0' NOT NULL,
88 #
Table structure for table 'fe_groups'
90 CREATE TABLE fe_groups (
91 uid
int(11) unsigned
NOT NULL auto_increment
,
92 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
93 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
94 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
95 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
96 title
varchar(50) DEFAULT '' NOT NULL,
97 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
98 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
99 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
109 #
Table structure for table 'fe_session_data'
111 CREATE TABLE fe_session_data (
112 hash
varchar(32) DEFAULT '' NOT NULL,
114 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
120 #
Table structure for table 'fe_sessions'
122 CREATE TABLE fe_sessions (
123 ses_id
varchar(32) DEFAULT '' NOT NULL,
124 ses_name
varchar(32) DEFAULT '' NOT NULL,
125 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
126 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
127 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
128 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
130 ses_permanent
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
131 PRIMARY KEY (ses_id
,ses_name
)
136 #
Table structure for table 'fe_users'
138 CREATE TABLE fe_users (
139 uid
int(11) unsigned
NOT NULL auto_increment
,
140 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
141 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
142 username
varchar(50) DEFAULT '' NOT NULL,
143 password varchar(40) DEFAULT '' NOT NULL,
145 disable tinyint(4) unsigned
DEFAULT '0' NOT NULL,
146 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
147 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
148 name varchar(80) DEFAULT '' NOT NULL,
149 address
varchar(255) DEFAULT '' NOT NULL,
150 telephone
varchar(20) DEFAULT '' NOT NULL,
151 fax
varchar(20) DEFAULT '' NOT NULL,
152 email
varchar(80) DEFAULT '' NOT NULL,
153 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
154 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
155 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
156 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
158 title
varchar(40) DEFAULT '' NOT NULL,
159 zip
varchar(10) DEFAULT '' NOT NULL,
160 city
varchar(50) DEFAULT '' NOT NULL,
161 country
varchar(40) DEFAULT '' NOT NULL,
162 www
varchar(80) DEFAULT '' NOT NULL,
163 company
varchar(80) DEFAULT '' NOT NULL,
166 fe_cruser_id
int(10) unsigned
DEFAULT '0' NOT NULL,
167 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
168 is_online
int(10) unsigned
DEFAULT '0' NOT NULL,
170 KEY parent (pid
,username
),
171 KEY username (username
),
172 KEY is_online (is_online
)
177 #
Table structure for table 'pages_language_overlay'
179 CREATE TABLE pages_language_overlay (
180 uid
int(11) NOT NULL auto_increment
,
181 pid
int(11) DEFAULT '0' NOT NULL,
182 doktype
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
183 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
184 t3ver_id
int(11) DEFAULT '0' NOT NULL,
185 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
186 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
187 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
188 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
189 t3ver_count
int(11) DEFAULT '0' NOT NULL,
190 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
191 t3_origuid
int(11) DEFAULT '0' NOT NULL,
192 tstamp
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 sys_language_uid
int(11) unsigned
DEFAULT '0' NOT NULL,
196 title
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 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
201 subtitle
varchar(255) DEFAULT '' NOT NULL,
202 nav_title
varchar(255) DEFAULT '' NOT NULL,
207 author
varchar(255) DEFAULT '' NOT NULL,
208 author_email
varchar(80) DEFAULT '' NOT NULL,
209 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
210 l18n_diffsource mediumblob
,
211 url
varchar(255) DEFAULT '' NOT NULL,
212 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
213 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
214 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
217 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
218 KEY parent (pid
,sys_language_uid
)
223 #
Table structure for table 'static_template'
225 CREATE TABLE static_template (
226 uid
int(11) unsigned
NOT NULL auto_increment
,
227 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
228 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
229 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
230 title
varchar(255) DEFAULT '' NOT NULL,
231 include_static tinytext
,
242 #
Table structure for table 'sys_domain'
244 CREATE TABLE sys_domain (
245 uid
int(11) unsigned
NOT NULL auto_increment
,
246 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
247 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
248 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
249 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
250 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
251 domainName
varchar(80) DEFAULT '' NOT NULL,
252 redirectTo
varchar(120) DEFAULT '' NOT NULL,
253 redirectHttpStatusCode
int(4) unsigned
DEFAULT '301' NOT NULL,
254 sorting
int(10) unsigned
DEFAULT '0' NOT NULL,
255 prepend_params
int(10) DEFAULT '0' NOT NULL,
264 #
Table structure for table 'sys_template'
266 CREATE TABLE sys_template (
267 uid
int(11) NOT NULL auto_increment
,
268 pid
int(11) DEFAULT '0' NOT NULL,
269 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
270 t3ver_id
int(11) DEFAULT '0' NOT NULL,
271 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
272 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
273 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
274 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
275 t3ver_count
int(11) DEFAULT '0' NOT NULL,
276 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
277 t3_origuid
int(11) DEFAULT '0' NOT NULL,
278 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
279 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
280 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
281 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
282 title
varchar(255) DEFAULT '' NOT NULL,
283 sitetitle
varchar(255) DEFAULT '' NOT NULL,
284 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
285 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
286 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
287 root
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
288 clear
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
289 include_static tinytext
,
290 include_static_file
text,
295 nextLevel
varchar(5) DEFAULT '' NOT NULL,
298 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
299 includeStaticAfterBasedOn
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
300 static_file_mode
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
301 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
303 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
304 KEY parent (pid
,sorting
,deleted
,hidden
)
309 #
Table structure for table 'tt_content'
311 CREATE TABLE tt_content (
312 uid
int(11) NOT NULL auto_increment
,
313 pid
int(11) DEFAULT '0' NOT NULL,
314 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
315 t3ver_id
int(11) DEFAULT '0' NOT NULL,
316 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
317 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
318 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
319 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
320 t3ver_count
int(11) DEFAULT '0' NOT NULL,
321 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
322 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
323 t3_origuid
int(11) DEFAULT '0' NOT NULL,
324 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
325 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
326 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
327 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
328 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
329 CType
varchar(30) DEFAULT '' NOT NULL,
330 header varchar(255) DEFAULT '' NOT NULL,
331 header_position
varchar(6) DEFAULT '' NOT NULL,
334 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
335 imageorient
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
337 imagecols
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
338 imageborder
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
340 layout
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
341 deleted
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
342 cols
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
345 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
346 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
347 colPos
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
348 subheader
varchar(255) DEFAULT '' NOT NULL,
349 spaceBefore
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
350 spaceAfter
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
351 fe_group
varchar(100) DEFAULT '0' NOT NULL,
352 header_link
varchar(255) DEFAULT '' NOT NULL,
353 imagecaption_position
varchar(6) DEFAULT '' NOT NULL,
354 image_link
varchar(255) DEFAULT '' NOT NULL,
355 image_zoom
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
356 image_noRows
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
357 image_effects
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
358 image_compression
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
362 header_layout
varchar(30) DEFAULT '0' NOT NULL,
363 text_align
varchar(6) DEFAULT '' NOT NULL,
364 text_face
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
365 text_size
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
366 text_color
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
367 text_properties
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
368 menu_type
varchar(30) DEFAULT '0' NOT NULL,
369 list_type
varchar(36) DEFAULT '0' NOT NULL,
370 table_border
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
371 table_cellspacing
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
372 table_cellpadding
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
373 table_bgColor
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
374 select_key
varchar(80) DEFAULT '' NOT NULL,
375 sectionIndex
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
376 linkToTop
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
377 filelink_size
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
378 section_frame
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
379 date int(10) unsigned
DEFAULT '0' NOT NULL,
380 splash_layout
varchar(30) DEFAULT '0' NOT NULL,
382 image_frames
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
383 recursive tinyint(3) unsigned
DEFAULT '0' NOT NULL,
384 imageheight
mediumint(8) unsigned
DEFAULT '0' NOT NULL,
385 rte_enabled
tinyint(4) DEFAULT '0' NOT NULL,
386 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
387 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
388 pi_flexform mediumtext
,
389 l18n_parent
int(11) DEFAULT '0' NOT NULL,
390 l18n_diffsource mediumblob
,
393 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
394 KEY parent (pid
,sorting
)
399 #
Table structure for table 'pages'
402 url
varchar(255) DEFAULT '' NOT NULL,
403 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
404 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
405 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
406 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
407 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
408 no_cache
int(10) unsigned
DEFAULT '0' NOT NULL,
409 fe_group
varchar(100) DEFAULT '0' NOT NULL,
410 subtitle
varchar(255) DEFAULT '' NOT NULL,
411 layout
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
412 target
varchar(20) DEFAULT '' NOT NULL,
414 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
416 cache_timeout
int(10) unsigned
DEFAULT '0' NOT NULL,
417 newUntil
int(10) unsigned
DEFAULT '0' NOT NULL,
419 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
420 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
422 module varchar(10) DEFAULT '' NOT NULL,
423 extendToSubpages
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
424 author
varchar(255) DEFAULT '' NOT NULL,
425 author_email
varchar(80) DEFAULT '' NOT NULL,
426 nav_title
varchar(255) DEFAULT '' NOT NULL,
427 nav_hide
tinyint(4) DEFAULT '0' NOT NULL,
428 content_from_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
429 mount_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
430 mount_pid_ol
tinyint(4) DEFAULT '0' NOT NULL,
431 alias varchar(32) DEFAULT '' NOT NULL,
432 l18n_cfg
tinyint(4) DEFAULT '0' NOT NULL,
433 fe_login_mode
tinyint(4) DEFAULT '0' NOT NULL,