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,
39 description
text NOT NULL,
40 subgroup tinytext
NOT NULL,
41 TSconfig
text NOT NULL,
48 #
Table structure for table 'fe_session_data'
50 CREATE TABLE fe_session_data (
51 hash
varchar(32) DEFAULT '' NOT NULL,
53 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
60 #
Table structure for table 'fe_sessions'
62 CREATE TABLE fe_sessions (
63 ses_id
varchar(32) DEFAULT '' NOT NULL,
64 ses_name
varchar(32) DEFAULT '' NOT NULL,
65 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
66 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
67 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
68 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
70 ses_permanent
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
72 PRIMARY KEY (ses_id
,ses_name
),
73 KEY ses_tstamp (ses_tstamp
)
77 #
Table structure for table 'fe_users'
79 CREATE TABLE fe_users (
80 uid
int(11) unsigned
NOT NULL auto_increment
,
81 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
82 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
83 username
varchar(255) DEFAULT '' NOT NULL,
84 password varchar(100) DEFAULT '' NOT NULL,
86 disable tinyint(4) unsigned
DEFAULT '0' NOT NULL,
87 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
88 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
89 name varchar(80) DEFAULT '' NOT NULL,
90 first_name
varchar(50) DEFAULT '' NOT NULL,
91 middle_name
varchar(50) DEFAULT '' NOT NULL,
92 last_name
varchar(50) DEFAULT '' NOT NULL,
93 address
varchar(255) DEFAULT '' NOT NULL,
94 telephone
varchar(20) DEFAULT '' NOT NULL,
95 fax
varchar(20) DEFAULT '' NOT NULL,
96 email
varchar(255) DEFAULT '' NOT NULL,
97 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
98 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
99 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
100 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
102 title
varchar(40) DEFAULT '' NOT NULL,
103 zip
varchar(10) DEFAULT '' NOT NULL,
104 city
varchar(50) DEFAULT '' NOT NULL,
105 country
varchar(40) DEFAULT '' NOT NULL,
106 www
varchar(80) DEFAULT '' NOT NULL,
107 company
varchar(80) DEFAULT '' NOT NULL,
110 fe_cruser_id
int(10) unsigned
DEFAULT '0' NOT NULL,
111 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
112 is_online
int(10) unsigned
DEFAULT '0' NOT NULL,
115 KEY parent (pid
,username
),
116 KEY username (username
),
117 KEY is_online (is_online
)
121 #
Table structure for table 'pages_language_overlay'
123 CREATE TABLE pages_language_overlay (
124 uid
int(11) NOT NULL auto_increment
,
125 pid
int(11) DEFAULT '0' NOT NULL,
126 doktype
int(11) unsigned
DEFAULT '0' NOT NULL,
127 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
128 t3ver_id
int(11) DEFAULT '0' NOT NULL,
129 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
130 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
131 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
132 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
133 t3ver_count
int(11) DEFAULT '0' NOT NULL,
134 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
135 t3_origuid
int(11) DEFAULT '0' NOT NULL,
136 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
137 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
138 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
139 sys_language_uid
int(11) unsigned
DEFAULT '0' NOT NULL,
140 title
varchar(255) DEFAULT '' NOT NULL,
141 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
142 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
143 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
144 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
145 subtitle
varchar(255) DEFAULT '' NOT NULL,
146 nav_title
varchar(255) DEFAULT '' NOT NULL,
151 author
varchar(255) DEFAULT '' NOT NULL,
152 author_email
varchar(80) DEFAULT '' NOT NULL,
153 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
154 l18n_diffsource mediumblob
,
155 url
varchar(255) DEFAULT '' NOT NULL,
156 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
157 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
158 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
161 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
162 KEY parent (pid
,sys_language_uid
)
166 #
Table structure for table 'sys_domain'
168 CREATE TABLE sys_domain (
169 uid
int(11) unsigned
NOT NULL auto_increment
,
170 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
171 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
172 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
173 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
174 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
175 domainName
varchar(80) DEFAULT '' NOT NULL,
176 redirectTo
varchar(255) DEFAULT '' NOT NULL,
177 redirectHttpStatusCode
int(4) unsigned
DEFAULT '301' NOT NULL,
178 sorting
int(10) unsigned
DEFAULT '0' NOT NULL,
179 prepend_params
int(10) DEFAULT '0' NOT NULL,
180 forced
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
184 KEY getSysDomain (redirectTo
,hidden
)
188 #
Table structure for table 'sys_template'
190 CREATE TABLE sys_template (
191 uid
int(11) NOT NULL auto_increment
,
192 pid
int(11) DEFAULT '0' NOT NULL,
193 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
194 t3ver_id
int(11) DEFAULT '0' NOT NULL,
195 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
196 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
197 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
198 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
199 t3ver_count
int(11) DEFAULT '0' NOT NULL,
200 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
201 t3_origuid
int(11) DEFAULT '0' NOT NULL,
202 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
203 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
204 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
205 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
206 title
varchar(255) DEFAULT '' NOT NULL,
207 sitetitle
varchar(255) DEFAULT '' NOT NULL,
208 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
209 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
210 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
211 root
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
212 clear
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
213 include_static_file
text,
216 nextLevel
varchar(5) DEFAULT '' NOT NULL,
219 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
220 includeStaticAfterBasedOn
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
221 static_file_mode
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
222 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
225 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
226 KEY parent (pid
,deleted
,hidden
,sorting
),
227 KEY roottemplate (deleted
,hidden
,root
)
231 #
Table structure for table 'tt_content'
233 CREATE TABLE tt_content (
234 uid
int(11) NOT NULL auto_increment
,
235 pid
int(11) DEFAULT '0' NOT NULL,
236 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
237 t3ver_id
int(11) DEFAULT '0' NOT NULL,
238 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
239 t3ver_label
varchar(255) DEFAULT '' NOT NULL,
240 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
241 t3ver_stage
int(11) DEFAULT '0' NOT NULL,
242 t3ver_count
int(11) DEFAULT '0' NOT NULL,
243 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
244 t3ver_move_id
int(11) DEFAULT '0' NOT NULL,
245 t3_origuid
int(11) DEFAULT '0' NOT NULL,
246 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
247 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
248 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
249 editlock
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
250 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
251 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
252 CType
varchar(255) DEFAULT '' NOT NULL,
253 header varchar(255) DEFAULT '' NOT NULL,
257 # Even though we
're using FAL and an IRRE field for images
258 # now, it needs to stay "text" for the migration to work
261 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
262 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
263 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
264 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
266 layout int(11) unsigned DEFAULT '0' NOT NULL,
267 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
268 cols int(11) unsigned DEFAULT '0' NOT NULL,
271 starttime int(11) unsigned DEFAULT '0' NOT NULL,
272 endtime int(11) unsigned DEFAULT '0' NOT NULL,
273 colPos int(11) unsigned DEFAULT '0' NOT NULL,
274 subheader varchar(255) DEFAULT '' NOT NULL,
275 fe_group varchar(100) DEFAULT '0' NOT NULL,
276 header_link varchar(1024) DEFAULT '' NOT NULL,
277 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
278 header_layout varchar(30) DEFAULT '0' NOT NULL,
279 menu_type varchar(30) DEFAULT '0' NOT NULL,
280 list_type varchar(255) DEFAULT '0' NOT NULL,
281 select_key varchar(80) DEFAULT '' NOT NULL,
282 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
283 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
284 file_collections text,
285 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
286 filelink_sorting varchar(10) DEFAULT '' NOT NULL,
287 target varchar(30) DEFAULT '' NOT NULL,
288 date int(10) unsigned DEFAULT '0' NOT NULL,
289 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
290 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
291 sys_language_uid int(11) DEFAULT '0' NOT NULL,
292 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
293 pi_flexform mediumtext,
294 accessibility_title varchar(30) DEFAULT '' NOT NULL,
295 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
296 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
297 l18n_parent int(11) DEFAULT '0' NOT NULL,
298 l18n_diffsource mediumblob,
299 selected_categories text,
300 category_field varchar(64) DEFAULT '' NOT NULL,
301 table_caption varchar(255) DEFAULT NULL,
302 table_delimiter smallint(6) unsigned DEFAULT '0' NOT NULL,
303 table_enclosure smallint(6) unsigned DEFAULT '0' NOT NULL,
304 table_header_position tinyint(3) unsigned DEFAULT '0' NOT NULL,
305 table_tfoot tinyint(1) unsigned DEFAULT '0' NOT NULL,
308 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
309 KEY parent (pid,sorting),
310 KEY language (l18n_parent,sys_language_uid)
314 # Table structure for table 'backend_layout
'
316 CREATE TABLE backend_layout (
317 uid int(11) NOT NULL auto_increment,
318 pid int(11) DEFAULT '0' NOT NULL,
319 t3ver_oid int(11) DEFAULT '0' NOT NULL,
320 t3ver_id int(11) DEFAULT '0' NOT NULL,
321 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
322 t3ver_label varchar(255) DEFAULT '' NOT NULL,
323 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
324 t3ver_stage int(11) DEFAULT '0' NOT NULL,
325 t3ver_count int(11) DEFAULT '0' NOT NULL,
326 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
327 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
328 t3_origuid int(11) DEFAULT '0' NOT NULL,
329 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
330 crdate int(11) unsigned DEFAULT '0' NOT NULL,
331 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
332 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
333 deleted tinyint(4) DEFAULT '0' NOT NULL,
334 sorting int(11) unsigned DEFAULT '0' NOT NULL,
335 title varchar(255) DEFAULT '' NOT NULL,
336 description text NOT NULL,
337 config text NOT NULL,
342 KEY t3ver_oid (t3ver_oid,t3ver_wsid)