2 #
Table structure for table 'cache_typo3temp_log'
4 CREATE TABLE cache_typo3temp_log (
5 md5hash
varchar(32) DEFAULT '' NOT NULL,
6 tstamp
int(11) DEFAULT '0' NOT NULL,
7 filename
varchar(255) DEFAULT '' NOT NULL,
8 orig_filename
varchar(255) DEFAULT '' NOT NULL,
14 #
Table structure for table 'cache_md5params'
16 CREATE TABLE cache_md5params (
17 md5hash
varchar(20) DEFAULT '' NOT NULL,
18 tstamp
int(11) DEFAULT '0' NOT NULL,
19 type tinyint(3) DEFAULT '0' NOT NULL,
26 #
Table structure for table 'cache_treelist'
28 CREATE TABLE cache_treelist (
29 md5hash
char(32) DEFAULT '' NOT NULL,
30 pid
int(11) DEFAULT '0' NOT NULL,
32 tstamp
int(11) DEFAULT '0' NOT NULL,
33 expires
int(11) unsigned
DEFAULT '0' NOT NULL,
39 #
Table structure for table 'fe_groups'
41 CREATE TABLE fe_groups (
42 uid
int(11) unsigned
NOT NULL auto_increment
,
43 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
44 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
45 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
46 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
47 title
varchar(50) DEFAULT '' NOT NULL,
48 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
49 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
50 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
60 #
Table structure for table 'fe_session_data'
62 CREATE TABLE fe_session_data (
63 hash
varchar(32) DEFAULT '' NOT NULL,
65 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
72 #
Table structure for table 'fe_sessions'
74 CREATE TABLE fe_sessions (
75 ses_id
varchar(32) DEFAULT '' NOT NULL,
76 ses_name
varchar(32) DEFAULT '' NOT NULL,
77 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
78 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
79 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
80 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
82 ses_permanent
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
84 PRIMARY KEY (ses_id
,ses_name
),
85 KEY ses_tstamp (ses_tstamp
)
89 #
Table structure for table 'fe_users'
91 CREATE TABLE fe_users (
92 uid
int(11) unsigned
NOT NULL auto_increment
,
93 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
94 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
95 username
varchar(50) DEFAULT '' NOT NULL,
96 password varchar(100) DEFAULT '' NOT NULL,
98 disable tinyint(4) unsigned
DEFAULT '0' NOT NULL,
99 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
100 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
101 name varchar(80) DEFAULT '' NOT NULL,
102 first_name
varchar(50) DEFAULT '' NOT NULL,
103 middle_name
varchar(50) DEFAULT '' NOT NULL,
104 last_name
varchar(50) DEFAULT '' NOT NULL,
105 address
varchar(255) DEFAULT '' NOT NULL,
106 telephone
varchar(20) DEFAULT '' NOT NULL,
107 fax
varchar(20) DEFAULT '' NOT NULL,
108 email
varchar(80) DEFAULT '' NOT NULL,
109 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
110 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
111 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
112 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
114 title
varchar(40) DEFAULT '' NOT NULL,
115 zip
varchar(10) DEFAULT '' NOT NULL,
116 city
varchar(50) DEFAULT '' NOT NULL,
117 country
varchar(40) DEFAULT '' NOT NULL,
118 www
varchar(80) DEFAULT '' NOT NULL,
119 company
varchar(80) DEFAULT '' NOT NULL,
122 fe_cruser_id
int(10) unsigned
DEFAULT '0' NOT NULL,
123 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
124 is_online
int(10) unsigned
DEFAULT '0' NOT NULL,
127 KEY parent (pid
,username
),
128 KEY username (username
),
129 KEY is_online (is_online
)
133 #
Table structure for table 'pages_language_overlay'
135 CREATE TABLE pages_language_overlay (
136 uid
int(11) NOT NULL auto_increment
,
137 pid
int(11) DEFAULT '0' NOT NULL,
138 doktype
int(11) unsigned
DEFAULT '0' NOT NULL,
139 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
140 t3ver_id
int(11) DEFAULT '0' NOT NULL,
141 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
142 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
143 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
144 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
145 t3ver_count
int(11) DEFAULT '0' NOT NULL,
146 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
147 t3_origuid
int(11) DEFAULT '0' NOT NULL,
148 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
149 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
150 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
151 sys_language_uid
int(11) unsigned
DEFAULT '0' NOT NULL,
152 title
varchar(255) DEFAULT '' NOT NULL,
153 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
154 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
155 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
156 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
157 subtitle
varchar(255) DEFAULT '' NOT NULL,
158 nav_title
varchar(255) DEFAULT '' NOT NULL,
163 author
varchar(255) DEFAULT '' NOT NULL,
164 author_email
varchar(80) DEFAULT '' NOT NULL,
165 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
166 l18n_diffsource mediumblob
,
167 url
varchar(255) DEFAULT '' NOT NULL,
168 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
169 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
170 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
173 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
174 KEY parent (pid
,sys_language_uid
)
178 #
Table structure for table 'sys_domain'
180 CREATE TABLE sys_domain (
181 uid
int(11) unsigned
NOT NULL auto_increment
,
182 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
183 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
184 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
185 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
186 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
187 domainName
varchar(80) DEFAULT '' NOT NULL,
188 redirectTo
varchar(255) DEFAULT '' NOT NULL,
189 redirectHttpStatusCode
int(4) unsigned
DEFAULT '301' NOT NULL,
190 sorting
int(10) unsigned
DEFAULT '0' NOT NULL,
191 prepend_params
int(10) DEFAULT '0' NOT NULL,
192 forced
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
199 #
Table structure for table 'sys_template'
201 CREATE TABLE sys_template (
202 uid
int(11) NOT NULL auto_increment
,
203 pid
int(11) DEFAULT '0' NOT NULL,
204 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
205 t3ver_id
int(11) DEFAULT '0' NOT NULL,
206 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
207 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
208 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
209 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
210 t3ver_count
int(11) DEFAULT '0' NOT NULL,
211 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
212 t3_origuid
int(11) DEFAULT '0' NOT NULL,
213 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
214 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
215 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
216 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
217 title
varchar(255) DEFAULT '' NOT NULL,
218 sitetitle
varchar(255) DEFAULT '' NOT NULL,
219 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
220 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
221 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
222 root
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
223 clear
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
224 include_static_file
text,
227 nextLevel
varchar(5) DEFAULT '' NOT NULL,
230 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
231 includeStaticAfterBasedOn
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
232 static_file_mode
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
233 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
236 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
237 KEY parent (pid
,deleted
,hidden
,sorting
)
241 #
Table structure for table 'tt_content'
243 CREATE TABLE tt_content (
244 uid
int(11) NOT NULL auto_increment
,
245 pid
int(11) DEFAULT '0' NOT NULL,
246 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
247 t3ver_id
int(11) DEFAULT '0' NOT NULL,
248 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
249 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
250 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
251 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
252 t3ver_count
int(11) DEFAULT '0' NOT NULL,
253 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
254 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
255 t3_origuid
int(11) DEFAULT '0' NOT NULL,
256 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
257 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
258 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
259 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
260 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
261 CType
varchar(255) DEFAULT '' NOT NULL,
262 header varchar(255) DEFAULT '' NOT NULL,
263 header_position
varchar(6) DEFAULT '' NOT NULL,
266 # Even though we
're using FAL and an IRRE field for images
267 # now, it needs to stay "text" for the migration to work
270 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
271 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
273 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
274 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
276 layout int(11) unsigned DEFAULT '0' NOT NULL,
277 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
278 cols int(11) unsigned DEFAULT '0' NOT NULL,
281 starttime int(11) unsigned DEFAULT '0' NOT NULL,
282 endtime int(11) unsigned DEFAULT '0' NOT NULL,
283 colPos int(11) unsigned DEFAULT '0' NOT NULL,
284 subheader varchar(255) DEFAULT '' NOT NULL,
285 spaceBefore smallint(5) unsigned DEFAULT '0' NOT NULL,
286 spaceAfter smallint(5) unsigned DEFAULT '0' NOT NULL,
287 fe_group varchar(100) DEFAULT '0' NOT NULL,
288 header_link varchar(255) DEFAULT '' NOT NULL,
289 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
291 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
292 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
293 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
294 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
298 header_layout varchar(30) DEFAULT '0' NOT NULL,
299 text_align varchar(6) DEFAULT '' NOT NULL,
300 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
301 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
302 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
303 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
304 menu_type varchar(30) DEFAULT '0' NOT NULL,
305 list_type varchar(255) DEFAULT '0' NOT NULL,
306 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
307 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
308 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
309 table_bgColor int(11) unsigned DEFAULT '0' NOT NULL,
310 select_key varchar(80) DEFAULT '' NOT NULL,
311 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
312 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
313 file_collections text,
314 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
315 filelink_sorting tinytext NOT NULL,
316 target varchar(30) DEFAULT '' NOT NULL,
317 section_frame int(11) unsigned DEFAULT '0' NOT NULL,
318 date int(10) unsigned DEFAULT '0' NOT NULL,
320 image_frames int(11) unsigned DEFAULT '0' NOT NULL,
321 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
322 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
323 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
324 sys_language_uid int(11) DEFAULT '0' NOT NULL,
325 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
326 pi_flexform mediumtext,
327 accessibility_title varchar(30) DEFAULT '' NOT NULL,
328 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
329 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
330 l18n_parent int(11) DEFAULT '0' NOT NULL,
331 l18n_diffsource mediumblob,
332 selected_categories text,
333 category_field varchar(64) DEFAULT '' NOT NULL,
336 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
337 KEY parent (pid,sorting),
338 KEY language (l18n_parent,sys_language_uid)
342 # Table structure for table 'backend_layout
'
344 CREATE TABLE backend_layout (
345 uid int(11) NOT NULL auto_increment,
346 pid int(11) DEFAULT '0' NOT NULL,
347 t3ver_oid int(11) DEFAULT '0' NOT NULL,
348 t3ver_id int(11) DEFAULT '0' NOT NULL,
349 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
350 t3ver_label varchar(255) DEFAULT '' NOT NULL,
351 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
352 t3ver_stage int(11) DEFAULT '0' NOT NULL,
353 t3ver_count int(11) DEFAULT '0' NOT NULL,
354 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
355 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
356 t3_origuid int(11) DEFAULT '0' NOT NULL,
357 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
358 crdate int(11) unsigned DEFAULT '0' NOT NULL,
359 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
360 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
361 deleted tinyint(4) DEFAULT '0' NOT NULL,
362 sorting int(11) unsigned DEFAULT '0' NOT NULL,
363 title varchar(255) DEFAULT '' NOT NULL,
364 description text NOT NULL,
365 config text NOT NULL,
370 KEY t3ver_oid (t3ver_oid,t3ver_wsid)