1 # TYPO3 Extension Manager dump
1.0
3 #
Host: TYPO3_host
Database: t3_testsite
4 #
--------------------------------------------------------
9 #
Table structure for table 'cache_pages'
11 CREATE TABLE cache_pages (
12 id int(11) unsigned
NOT NULL auto_increment
,
13 hash
varchar(32) DEFAULT '' NOT NULL,
14 page_id
int(11) unsigned
DEFAULT '0' NOT NULL,
15 reg1
int(11) unsigned
DEFAULT '0' NOT NULL,
16 HTML mediumblob
NOT NULL,
17 temp_content
int(1) DEFAULT '0' NOT NULL,
18 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
19 expires
int(10) unsigned
DEFAULT '0' NOT NULL,
20 cache_data mediumblob
NOT NULL,
21 KEY page_id (page_id
),
22 KEY sel (hash
,page_id
),
28 #
Table structure for table 'cache_pagesection'
30 CREATE TABLE cache_pagesection (
31 page_id
int(11) unsigned
DEFAULT '0' NOT NULL,
32 mpvar_hash
int(11) unsigned
DEFAULT '0' NOT NULL,
33 content blob NOT NULL,
34 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
35 PRIMARY KEY (page_id
,mpvar_hash
)
40 #
Table structure for table 'cache_typo3temp_log'
42 CREATE TABLE cache_typo3temp_log (
43 md5hash
varchar(32) DEFAULT '' NOT NULL,
44 tstamp
int(11) DEFAULT '0' NOT NULL,
45 filename tinytext
NOT NULL,
46 orig_filename tinytext
NOT NULL,
52 #
Table structure for table 'cache_md5params'
54 CREATE TABLE cache_md5params (
55 md5hash
varchar(20) DEFAULT '' NOT NULL,
56 tstamp
int(11) DEFAULT '0' NOT NULL,
57 type tinyint(3) DEFAULT '0' NOT NULL,
64 #
Table structure for table 'cache_imagesizes'
66 CREATE TABLE cache_imagesizes (
67 md5hash
varchar(32) DEFAULT '' NOT NULL,
68 md5filename
varchar(32) DEFAULT '' NOT NULL,
69 tstamp
int(11) DEFAULT '0' NOT NULL,
70 filename tinytext
NOT NULL,
71 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
72 imageheight
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
73 PRIMARY KEY (md5filename
)
78 #
Table structure for table 'fe_groups'
80 CREATE TABLE fe_groups (
81 uid
int(11) unsigned
NOT NULL auto_increment
,
82 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
83 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
84 title
varchar(20) DEFAULT '' NOT NULL,
85 hidden
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
86 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
87 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
88 description
text NOT NULL,
89 subgroup tinyblob
NOT NULL,
90 TSconfig
blob NOT NULL,
97 #
Table structure for table 'fe_session_data'
99 CREATE TABLE fe_session_data (
100 hash
varchar(32) DEFAULT '' NOT NULL,
101 content mediumblob
NOT NULL,
102 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
108 #
Table structure for table 'fe_sessions'
110 CREATE TABLE fe_sessions (
111 ses_id
varchar(32) DEFAULT '' NOT NULL,
112 ses_name
varchar(32) DEFAULT '' NOT NULL,
113 ses_iplock
varchar(39) DEFAULT '' NOT NULL,
114 ses_hashlock
int(11) DEFAULT '0' NOT NULL,
115 ses_userid
int(11) unsigned
DEFAULT '0' NOT NULL,
116 ses_tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
117 ses_data
blob NOT NULL,
118 ses_permanent
tinyint(1) unsigned
DEFAULT '0' NOT NULL,
119 PRIMARY KEY (ses_id
,ses_name
)
124 #
Table structure for table 'fe_users'
126 CREATE TABLE fe_users (
127 uid
int(11) unsigned
NOT NULL auto_increment
,
128 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
129 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
130 username
varchar(50) DEFAULT '' NOT NULL,
131 password varchar(40) DEFAULT '' NOT NULL,
132 usergroup tinyblob
NOT NULL,
133 disable tinyint(4) unsigned
DEFAULT '0' NOT NULL,
134 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
135 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
136 name varchar(80) DEFAULT '' NOT NULL,
137 address tinytext
NOT NULL,
138 telephone
varchar(20) DEFAULT '' NOT NULL,
139 fax
varchar(20) DEFAULT '' NOT NULL,
140 email
varchar(80) DEFAULT '' NOT NULL,
141 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
142 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
143 lockToDomain
varchar(50) DEFAULT '' NOT NULL,
144 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
146 title
varchar(40) DEFAULT '' NOT NULL,
147 zip
varchar(10) DEFAULT '' NOT NULL,
148 city
varchar(50) DEFAULT '' NOT NULL,
149 country
varchar(40) DEFAULT '' NOT NULL,
150 www
varchar(80) DEFAULT '' NOT NULL,
151 company
varchar(80) DEFAULT '' NOT NULL,
152 image tinyblob
NOT NULL,
153 TSconfig
blob NOT NULL,
154 fe_cruser_id
int(10) unsigned
DEFAULT '0' NOT NULL,
155 lastlogin
int(10) unsigned
DEFAULT '0' NOT NULL,
156 is_online
int(10) unsigned
DEFAULT '0' NOT NULL,
159 KEY username (username
),
160 KEY is_online (is_online
),
161 KEY pid (pid
,username
)
166 #
Table structure for table 'pages_language_overlay'
168 CREATE TABLE pages_language_overlay (
169 uid
int(11) NOT NULL auto_increment
,
170 pid
int(11) DEFAULT '0' NOT NULL,
171 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
172 t3ver_id
int(11) DEFAULT '0' NOT NULL,
173 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
174 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
175 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
176 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
177 t3ver_count
int(11) DEFAULT '0' NOT NULL,
178 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
179 t3_origuid
int(11) DEFAULT '0' NOT NULL,
180 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
181 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
182 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
183 sys_language_uid
int(11) unsigned
DEFAULT '0' NOT NULL,
184 title tinytext
NOT NULL,
185 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
186 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
187 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
188 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
189 subtitle tinytext
NOT NULL,
190 nav_title tinytext
NOT NULL,
191 media tinyblob
NOT NULL,
192 keywords
text NOT NULL,
193 description
text NOT NULL,
194 abstract
text NOT NULL,
195 author tinytext
NOT NULL,
196 author_email
varchar(80) DEFAULT '' NOT NULL,
197 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
198 l18n_diffsource mediumblob
NOT NULL,
201 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
207 #
Table structure for table 'static_template'
209 CREATE TABLE static_template (
210 uid
int(11) unsigned
NOT NULL auto_increment
,
211 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
212 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
213 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
214 title tinytext
NOT NULL,
215 include_static tinyblob
NOT NULL,
216 constants
blob NOT NULL,
217 config
blob NOT NULL,
218 editorcfg
blob NOT NULL,
219 description
text NOT NULL,
226 #
Table structure for table 'sys_domain'
228 CREATE TABLE sys_domain (
229 uid
int(11) unsigned
NOT NULL auto_increment
,
230 pid
int(11) unsigned
DEFAULT '0' NOT NULL,
231 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
232 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
233 domainName
varchar(80) DEFAULT '' NOT NULL,
234 redirectTo
varchar(120) DEFAULT '' NOT NULL,
235 sorting
int(10) unsigned
DEFAULT '0' NOT NULL,
236 prepend_params
int(10) DEFAULT '0' NOT NULL,
245 #
Table structure for table 'sys_template'
247 CREATE TABLE sys_template (
248 uid
int(11) NOT NULL auto_increment
,
249 pid
int(11) DEFAULT '0' NOT NULL,
250 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
251 t3ver_id
int(11) DEFAULT '0' NOT NULL,
252 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
253 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
254 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
255 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
256 t3ver_count
int(11) DEFAULT '0' NOT NULL,
257 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
258 t3_origuid
int(11) DEFAULT '0' NOT NULL,
259 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
260 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
261 crdate
int(11) unsigned
DEFAULT '0' NOT NULL,
262 cruser_id
int(11) unsigned
DEFAULT '0' NOT NULL,
263 title tinytext
NOT NULL,
264 sitetitle tinytext
NOT NULL,
265 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
266 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
267 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
268 root
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
269 clear
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
270 include_static tinyblob
NOT NULL,
271 include_static_file
blob NOT NULL,
272 constants
blob NOT NULL,
273 config
blob NOT NULL,
274 editorcfg
blob NOT NULL,
275 resources
blob NOT NULL,
276 nextLevel
varchar(5) DEFAULT '' NOT NULL,
277 description
text NOT NULL,
278 basedOn tinyblob
NOT NULL,
279 deleted
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
280 includeStaticAfterBasedOn
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
281 static_file_mode
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
282 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
284 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
285 KEY parent (pid
,sorting
)
290 #
Table structure for table 'tt_content'
292 CREATE TABLE tt_content (
293 uid
int(11) NOT NULL auto_increment
,
294 pid
int(11) DEFAULT '0' NOT NULL,
295 t3ver_oid
int(11) DEFAULT '0' NOT NULL,
296 t3ver_id
int(11) DEFAULT '0' NOT NULL,
297 t3ver_wsid
int(11) DEFAULT '0' NOT NULL,
298 t3ver_label
varchar(30) DEFAULT '' NOT NULL,
299 t3ver_state
tinyint(4) DEFAULT '0' NOT NULL,
300 t3ver_stage
tinyint(4) DEFAULT '0' NOT NULL,
301 t3ver_count
int(11) DEFAULT '0' NOT NULL,
302 t3ver_tstamp
int(11) DEFAULT '0' NOT NULL,
303 t3_origuid
int(11) DEFAULT '0' NOT NULL,
304 tstamp
int(11) unsigned
DEFAULT '0' NOT NULL,
305 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
306 sorting
int(11) unsigned
DEFAULT '0' NOT NULL,
307 CType
varchar(30) DEFAULT '' NOT NULL,
308 header tinytext
NOT NULL,
309 header_position
varchar(6) DEFAULT '' NOT NULL,
310 bodytext mediumtext
NOT NULL,
312 imagewidth
mediumint(11) unsigned
DEFAULT '0' NOT NULL,
313 imageorient
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
314 imagecaption
text NOT NULL,
315 imagecols
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
316 imageborder
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
318 layout
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
319 deleted
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
320 cols
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
321 records
blob NOT NULL,
322 pages tinyblob
NOT NULL,
323 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
324 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
325 colPos
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
326 subheader tinytext
NOT NULL,
327 spaceBefore
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
328 spaceAfter
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
329 fe_group
varchar(100) DEFAULT '0' NOT NULL,
330 header_link tinytext
NOT NULL,
331 imagecaption_position
varchar(6) DEFAULT '' NOT NULL,
332 image_link tinytext
NOT NULL,
333 image_zoom
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
334 image_noRows
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
335 image_effects
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
336 image_compression
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
337 altText
text NOT NULL,
338 titleText
text NOT NULL,
339 longdescURL
text NOT NULL,
340 header_layout
varchar(30) DEFAULT '0' NOT NULL,
341 text_align
varchar(6) DEFAULT '' NOT NULL,
342 text_face
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
343 text_size
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
344 text_color
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
345 text_properties
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
346 menu_type
varchar(30) DEFAULT '0' NOT NULL,
347 list_type
varchar(36) DEFAULT '0' NOT NULL,
348 table_border
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
349 table_cellspacing
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
350 table_cellpadding
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
351 table_bgColor
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
352 select_key
varchar(80) DEFAULT '' NOT NULL,
353 sectionIndex
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
354 linkToTop
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
355 filelink_size
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
356 section_frame
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
357 date int(10) unsigned
DEFAULT '0' NOT NULL,
358 splash_layout
varchar(30) DEFAULT '0' NOT NULL,
359 multimedia tinyblob
NOT NULL,
360 image_frames
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
361 recursive tinyint(3) unsigned
DEFAULT '0' NOT NULL,
362 imageheight
mediumint(8) unsigned
DEFAULT '0' NOT NULL,
363 rte_enabled
tinyint(4) DEFAULT '0' NOT NULL,
364 sys_language_uid
int(11) DEFAULT '0' NOT NULL,
365 tx_impexp_origuid
int(11) DEFAULT '0' NOT NULL,
366 pi_flexform mediumtext
NOT NULL,
367 l18n_parent
int(11) DEFAULT '0' NOT NULL,
368 l18n_diffsource mediumblob
NOT NULL,
371 KEY t3ver_oid (t3ver_oid
,t3ver_wsid
),
377 #
Table structure for table 'pages'
380 url tinytext
NOT NULL,
381 hidden
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
382 starttime
int(11) unsigned
DEFAULT '0' NOT NULL,
383 endtime
int(11) unsigned
DEFAULT '0' NOT NULL,
384 urltype
tinyint(4) unsigned
DEFAULT '0' NOT NULL,
385 shortcut
int(10) unsigned
DEFAULT '0' NOT NULL,
386 shortcut_mode
int(10) unsigned
DEFAULT '0' NOT NULL,
387 no_cache
int(10) unsigned
DEFAULT '0' NOT NULL,
388 fe_group
varchar(100) DEFAULT '0' NOT NULL,
389 subtitle tinytext
NOT NULL,
390 layout
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
391 target
varchar(20) DEFAULT '' NOT NULL,
393 lastUpdated
int(10) unsigned
DEFAULT '0' NOT NULL,
394 keywords
text NOT NULL,
395 cache_timeout
int(10) unsigned
DEFAULT '0' NOT NULL,
396 newUntil
int(10) unsigned
DEFAULT '0' NOT NULL,
397 description
text NOT NULL,
398 no_search
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
399 SYS_LASTCHANGED
int(10) unsigned
DEFAULT '0' NOT NULL,
400 abstract
text NOT NULL,
401 module varchar(10) DEFAULT '' NOT NULL,
402 extendToSubpages
tinyint(3) unsigned
DEFAULT '0' NOT NULL,
403 author tinytext
NOT NULL,
404 author_email
varchar(80) DEFAULT '' NOT NULL,
405 nav_title tinytext
NOT NULL,
406 nav_hide
tinyint(4) DEFAULT '0' NOT NULL,
407 content_from_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
408 mount_pid
int(10) unsigned
DEFAULT '0' NOT NULL,
409 mount_pid_ol
tinyint(4) DEFAULT '0' NOT NULL,
410 alias varchar(32) DEFAULT '' NOT NULL,
411 l18n_cfg
tinyint(4) DEFAULT '0' NOT NULL,
412 fe_login_mode
tinyint(4) DEFAULT '0' NOT NULL,