[BUGFIX] undefined variable imgExt
[Packages/TYPO3.CMS.git] / typo3 / sysext / cms / ext_tables.sql
1 #
2
3
4 #
5 # Table structure for table 'cache_typo3temp_log'
6 #
7 CREATE TABLE cache_typo3temp_log (
8 md5hash varchar(32) DEFAULT '' NOT NULL,
9 tstamp int(11) DEFAULT '0' NOT NULL,
10 filename varchar(255) DEFAULT '' NOT NULL,
11 orig_filename varchar(255) DEFAULT '' NOT NULL,
12 PRIMARY KEY (md5hash)
13 ) ENGINE=InnoDB;
14
15
16 #
17 # Table structure for table 'cache_md5params'
18 #
19 CREATE TABLE cache_md5params (
20 md5hash varchar(20) DEFAULT '' NOT NULL,
21 tstamp int(11) DEFAULT '0' NOT NULL,
22 type tinyint(3) DEFAULT '0' NOT NULL,
23 params text,
24 PRIMARY KEY (md5hash)
25 ) ENGINE=InnoDB;
26
27
28 #
29 # Table structure for table 'cache_imagesizes'
30 #
31 CREATE TABLE cache_imagesizes (
32 md5hash varchar(32) DEFAULT '' NOT NULL,
33 md5filename varchar(32) DEFAULT '' NOT NULL,
34 tstamp int(11) DEFAULT '0' NOT NULL,
35 filename varchar(255) DEFAULT '' NOT NULL,
36 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
37 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
38 PRIMARY KEY (md5filename)
39 ) ENGINE=InnoDB;
40
41
42 #
43 # Table structure for table 'cache_treelist'
44 #
45 CREATE TABLE cache_treelist (
46 md5hash char(32) DEFAULT '' NOT NULL,
47 pid int(11) DEFAULT '0' NOT NULL,
48 treelist text,
49 tstamp int(11) DEFAULT '0' NOT NULL,
50 expires int(11) unsigned DEFAULT '0' NOT NULL,
51 PRIMARY KEY (md5hash)
52 ) ENGINE=InnoDB;
53
54
55 #
56 # Table structure for table 'fe_groups'
57 #
58 CREATE TABLE fe_groups (
59 uid int(11) unsigned NOT NULL auto_increment,
60 pid int(11) unsigned DEFAULT '0' NOT NULL,
61 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
62 crdate int(11) unsigned DEFAULT '0' NOT NULL,
63 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
64 title varchar(50) DEFAULT '' NOT NULL,
65 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
66 lockToDomain varchar(50) DEFAULT '' NOT NULL,
67 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
68 description text,
69 subgroup tinytext,
70 TSconfig text,
71 PRIMARY KEY (uid),
72 KEY parent (pid)
73 );
74
75
76 #
77 # Table structure for table 'fe_session_data'
78 #
79 CREATE TABLE fe_session_data (
80 hash varchar(32) DEFAULT '' NOT NULL,
81 content mediumblob,
82 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
83 PRIMARY KEY (hash),
84 KEY tstamp (tstamp)
85 ) ENGINE=InnoDB;
86
87
88 #
89 # Table structure for table 'fe_sessions'
90 #
91 CREATE TABLE fe_sessions (
92 ses_id varchar(32) DEFAULT '' NOT NULL,
93 ses_name varchar(32) DEFAULT '' NOT NULL,
94 ses_iplock varchar(39) DEFAULT '' NOT NULL,
95 ses_hashlock int(11) DEFAULT '0' NOT NULL,
96 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
97 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
98 ses_data blob,
99 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
100 PRIMARY KEY (ses_id,ses_name),
101 KEY ses_tstamp (ses_tstamp)
102 ) ENGINE=InnoDB;
103
104
105 #
106 # Table structure for table 'fe_users'
107 #
108 CREATE TABLE fe_users (
109 uid int(11) unsigned NOT NULL auto_increment,
110 pid int(11) unsigned DEFAULT '0' NOT NULL,
111 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
112 username varchar(50) DEFAULT '' NOT NULL,
113 password varchar(60) DEFAULT '' NOT NULL,
114 usergroup tinytext,
115 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
116 starttime int(11) unsigned DEFAULT '0' NOT NULL,
117 endtime int(11) unsigned DEFAULT '0' NOT NULL,
118 name varchar(80) DEFAULT '' NOT NULL,
119 first_name varchar(50) DEFAULT '' NOT NULL,
120 middle_name varchar(50) DEFAULT '' NOT NULL,
121 last_name varchar(50) DEFAULT '' NOT NULL,
122 address varchar(255) DEFAULT '' NOT NULL,
123 telephone varchar(20) DEFAULT '' NOT NULL,
124 fax varchar(20) DEFAULT '' NOT NULL,
125 email varchar(80) DEFAULT '' NOT NULL,
126 crdate int(11) unsigned DEFAULT '0' NOT NULL,
127 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
128 lockToDomain varchar(50) DEFAULT '' NOT NULL,
129 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
130 uc blob,
131 title varchar(40) DEFAULT '' NOT NULL,
132 zip varchar(10) DEFAULT '' NOT NULL,
133 city varchar(50) DEFAULT '' NOT NULL,
134 country varchar(40) DEFAULT '' NOT NULL,
135 www varchar(80) DEFAULT '' NOT NULL,
136 company varchar(80) DEFAULT '' NOT NULL,
137 image tinytext,
138 TSconfig text,
139 fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
140 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
141 is_online int(10) unsigned DEFAULT '0' NOT NULL,
142 PRIMARY KEY (uid),
143 KEY parent (pid,username),
144 KEY username (username),
145 KEY is_online (is_online)
146 );
147
148
149 #
150 # Table structure for table 'pages_language_overlay'
151 #
152 CREATE TABLE pages_language_overlay (
153 uid int(11) NOT NULL auto_increment,
154 pid int(11) DEFAULT '0' NOT NULL,
155 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
156 t3ver_oid int(11) DEFAULT '0' NOT NULL,
157 t3ver_id int(11) DEFAULT '0' NOT NULL,
158 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
159 t3ver_label varchar(255) DEFAULT '' NOT NULL,
160 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
161 t3ver_stage int(11) DEFAULT '0' NOT NULL,
162 t3ver_count int(11) DEFAULT '0' NOT NULL,
163 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
164 t3_origuid int(11) DEFAULT '0' NOT NULL,
165 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
166 crdate int(11) unsigned DEFAULT '0' NOT NULL,
167 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
168 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
169 title varchar(255) DEFAULT '' NOT NULL,
170 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
171 starttime int(11) unsigned DEFAULT '0' NOT NULL,
172 endtime int(11) unsigned DEFAULT '0' NOT NULL,
173 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
174 subtitle varchar(255) DEFAULT '' NOT NULL,
175 nav_title varchar(255) DEFAULT '' NOT NULL,
176 media text,
177 keywords text,
178 description text,
179 abstract text,
180 author varchar(255) DEFAULT '' NOT NULL,
181 author_email varchar(80) DEFAULT '' NOT NULL,
182 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
183 l18n_diffsource mediumblob,
184 url varchar(255) DEFAULT '' NOT NULL,
185 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
186 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
187 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
188
189 PRIMARY KEY (uid),
190 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
191 KEY parent (pid,sys_language_uid)
192 );
193
194
195 #
196 # Table structure for table 'sys_domain'
197 #
198 CREATE TABLE sys_domain (
199 uid int(11) unsigned NOT NULL auto_increment,
200 pid int(11) unsigned DEFAULT '0' NOT NULL,
201 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
202 crdate int(11) unsigned DEFAULT '0' NOT NULL,
203 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
204 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
205 domainName varchar(80) DEFAULT '' NOT NULL,
206 redirectTo varchar(255) DEFAULT '' NOT NULL,
207 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
208 sorting int(10) unsigned DEFAULT '0' NOT NULL,
209 prepend_params int(10) DEFAULT '0' NOT NULL,
210 forced tinyint(3) unsigned DEFAULT '0' NOT NULL,
211
212 PRIMARY KEY (uid),
213 KEY parent (pid)
214 );
215
216
217
218 #
219 # Table structure for table 'sys_template'
220 #
221 CREATE TABLE sys_template (
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 t3_origuid int(11) DEFAULT '0' NOT NULL,
233 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
234 sorting 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 title varchar(255) DEFAULT '' NOT NULL,
238 sitetitle varchar(255) DEFAULT '' NOT NULL,
239 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
240 starttime int(11) unsigned DEFAULT '0' NOT NULL,
241 endtime int(11) unsigned DEFAULT '0' NOT NULL,
242 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
243 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
244 include_static_file text,
245 constants text,
246 config text,
247 resources text,
248 nextLevel varchar(5) DEFAULT '' NOT NULL,
249 description text,
250 basedOn tinytext,
251 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
252 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
253 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
254 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
255 PRIMARY KEY (uid),
256 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
257 KEY parent (pid,deleted,hidden,sorting)
258 );
259
260
261 #
262 # Table structure for table 'tt_content'
263 #
264 CREATE TABLE tt_content (
265 uid int(11) NOT NULL auto_increment,
266 pid int(11) DEFAULT '0' NOT NULL,
267 t3ver_oid int(11) DEFAULT '0' NOT NULL,
268 t3ver_id int(11) DEFAULT '0' NOT NULL,
269 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
270 t3ver_label varchar(255) DEFAULT '' NOT NULL,
271 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
272 t3ver_stage int(11) DEFAULT '0' NOT NULL,
273 t3ver_count int(11) DEFAULT '0' NOT NULL,
274 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
275 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
276 t3_origuid int(11) DEFAULT '0' NOT NULL,
277 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
278 crdate int(11) unsigned DEFAULT '0' NOT NULL,
279 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
280 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
281 sorting int(11) unsigned DEFAULT '0' NOT NULL,
282 CType varchar(30) DEFAULT '' NOT NULL,
283 header varchar(255) DEFAULT '' NOT NULL,
284 header_position varchar(6) DEFAULT '' NOT NULL,
285 bodytext mediumtext,
286 image text,
287 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
288 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
289 imagecaption text,
290 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
291 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
292 media text,
293 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
294 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
295 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
296 records text,
297 pages tinytext,
298 starttime int(11) unsigned DEFAULT '0' NOT NULL,
299 endtime int(11) unsigned DEFAULT '0' NOT NULL,
300 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
301 subheader varchar(255) DEFAULT '' NOT NULL,
302 spaceBefore smallint(5) unsigned DEFAULT '0' NOT NULL,
303 spaceAfter smallint(5) unsigned DEFAULT '0' NOT NULL,
304 fe_group varchar(100) DEFAULT '0' NOT NULL,
305 header_link varchar(255) DEFAULT '' NOT NULL,
306 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
307 image_link text,
308 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
309 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
310 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
311 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
312 altText text,
313 titleText text,
314 longdescURL text,
315 header_layout varchar(30) DEFAULT '0' NOT NULL,
316 text_align varchar(6) DEFAULT '' NOT NULL,
317 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
318 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
319 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
320 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
321 menu_type varchar(30) DEFAULT '0' NOT NULL,
322 list_type varchar(255) DEFAULT '0' NOT NULL,
323 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
324 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
325 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
326 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
327 select_key varchar(80) DEFAULT '' NOT NULL,
328 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
329 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
330 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
331 target varchar(30) DEFAULT '' NOT NULL,
332 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
333 date int(10) unsigned DEFAULT '0' NOT NULL,
334 splash_layout varchar(30) DEFAULT '0' NOT NULL,
335 multimedia tinytext,
336 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
337 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
338 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
339 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
340 sys_language_uid int(11) DEFAULT '0' NOT NULL,
341 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
342 pi_flexform mediumtext,
343 accessibility_title varchar(30) DEFAULT '' NOT NULL,
344 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
345 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
346 l18n_parent int(11) DEFAULT '0' NOT NULL,
347 l18n_diffsource mediumblob,
348
349 PRIMARY KEY (uid),
350 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
351 KEY parent (pid,sorting),
352 KEY language (l18n_parent,sys_language_uid)
353 );
354
355 #
356 # Table structure for table 'backend_layout'
357 #
358 CREATE TABLE backend_layout (
359 uid int(11) NOT NULL auto_increment,
360 pid int(11) DEFAULT '0' NOT NULL,
361 t3ver_oid int(11) DEFAULT '0' NOT NULL,
362 t3ver_id int(11) DEFAULT '0' NOT NULL,
363 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
364 t3ver_label varchar(255) DEFAULT '' NOT NULL,
365 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
366 t3ver_stage int(11) DEFAULT '0' NOT NULL,
367 t3ver_count int(11) DEFAULT '0' NOT NULL,
368 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
369 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
370 t3_origuid int(11) DEFAULT '0' NOT NULL,
371 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
372 crdate int(11) unsigned DEFAULT '0' NOT NULL,
373 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
374 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
375 deleted tinyint(4) DEFAULT '0' NOT NULL,
376 sorting int(11) unsigned DEFAULT '0' NOT NULL,
377 title varchar(255) DEFAULT '' NOT NULL,
378 description text NOT NULL,
379 config text NOT NULL,
380 icon text NOT NULL,
381 PRIMARY KEY (uid),
382 KEY parent (pid),
383 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
384 );