Fixed bug #12613: Wrong character encoding in cache tables breaks frontend rendering
[Packages/TYPO3.CMS.git] / typo3 / sysext / cms / ext_tables.sql
1 #
2 # TYPO3 SVN ID: $Id$
3 #
4
5
6 #
7 # Table structure for table 'cache_pages'
8 #
9 CREATE TABLE cache_pages (
10 id int(11) unsigned NOT NULL auto_increment,
11 hash varchar(32) DEFAULT '' NOT NULL,
12 page_id int(11) unsigned DEFAULT '0' NOT NULL,
13 reg1 int(11) unsigned DEFAULT '0' NOT NULL,
14 HTML mediumblob,
15 temp_content int(1) DEFAULT '0' NOT NULL,
16 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
17 expires int(10) unsigned DEFAULT '0' NOT NULL,
18 cache_data mediumblob,
19 KEY page_id (page_id),
20 KEY sel (hash,page_id),
21 PRIMARY KEY (id)
22 ) ENGINE=InnoDB;
23
24
25 #
26 # Table structure for table 'cache_pagesection'
27 #
28 CREATE TABLE cache_pagesection (
29 page_id int(11) unsigned DEFAULT '0' NOT NULL,
30 mpvar_hash int(11) unsigned DEFAULT '0' NOT NULL,
31 content blob,
32 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
33 PRIMARY KEY (page_id,mpvar_hash)
34 ) ENGINE=InnoDB;
35
36
37
38
39 #
40 # Table structure for table 'cachingframework_cache_pages'
41 #
42 CREATE TABLE cachingframework_cache_pages (
43 id int(11) unsigned NOT NULL auto_increment,
44 identifier varchar(128) DEFAULT '' NOT NULL,
45 crdate int(11) unsigned DEFAULT '0' NOT NULL,
46 content mediumtext,
47 lifetime int(11) unsigned DEFAULT '0' NOT NULL,
48 PRIMARY KEY (id),
49 KEY cache_id (identifier)
50 ) ENGINE=InnoDB;
51
52
53 #
54 # Table structure for table 'cachingframework_cache_pages_tags'
55 #
56 CREATE TABLE cachingframework_cache_pages_tags (
57 id int(11) unsigned NOT NULL auto_increment,
58 identifier varchar(128) DEFAULT '' NOT NULL,
59 tag varchar(128) DEFAULT '' NOT NULL,
60 PRIMARY KEY (id),
61 KEY cache_id (identifier),
62 KEY cache_tag (tag)
63 ) ENGINE=InnoDB;
64
65
66 #
67 # Table structure for table 'cachingframework_cache_pagesection'
68 #
69 CREATE TABLE cachingframework_cache_pagesection (
70 id int(11) unsigned NOT NULL auto_increment,
71 identifier varchar(128) DEFAULT '' NOT NULL,
72 crdate int(11) unsigned DEFAULT '0' NOT NULL,
73 content mediumtext,
74 lifetime int(11) unsigned DEFAULT '0' NOT NULL,
75 PRIMARY KEY (id),
76 KEY cache_id (identifier)
77 ) ENGINE=InnoDB;
78
79
80 #
81 # Table structure for table 'cachingframework_cache_pagesection_tags'
82 #
83 CREATE TABLE cachingframework_cache_pagesection_tags (
84 id int(11) unsigned NOT NULL auto_increment,
85 identifier varchar(128) DEFAULT '' NOT NULL,
86 tag varchar(128) DEFAULT '' NOT NULL,
87 PRIMARY KEY (id),
88 KEY cache_id (identifier),
89 KEY cache_tag (tag)
90 ) ENGINE=InnoDB;
91
92
93 #
94 # Table structure for table 'cache_typo3temp_log'
95 #
96 CREATE TABLE cache_typo3temp_log (
97 md5hash varchar(32) DEFAULT '' NOT NULL,
98 tstamp int(11) DEFAULT '0' NOT NULL,
99 filename varchar(255) DEFAULT '' NOT NULL,
100 orig_filename varchar(255) DEFAULT '' NOT NULL,
101 PRIMARY KEY (md5hash)
102 ) ENGINE=InnoDB;
103
104
105 #
106 # Table structure for table 'cache_md5params'
107 #
108 CREATE TABLE cache_md5params (
109 md5hash varchar(20) DEFAULT '' NOT NULL,
110 tstamp int(11) DEFAULT '0' NOT NULL,
111 type tinyint(3) DEFAULT '0' NOT NULL,
112 params text,
113 PRIMARY KEY (md5hash)
114 ) ENGINE=InnoDB;
115
116
117 #
118 # Table structure for table 'cache_imagesizes'
119 #
120 CREATE TABLE cache_imagesizes (
121 md5hash varchar(32) DEFAULT '' NOT NULL,
122 md5filename varchar(32) DEFAULT '' NOT NULL,
123 tstamp int(11) DEFAULT '0' NOT NULL,
124 filename varchar(255) DEFAULT '' NOT NULL,
125 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
126 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
127 PRIMARY KEY (md5filename)
128 ) ENGINE=InnoDB;
129
130
131 #
132 # Table structure for table 'cache_treelist'
133 #
134 CREATE TABLE cache_treelist (
135 md5hash char(32) DEFAULT '' NOT NULL,
136 pid int(11) DEFAULT '0' NOT NULL,
137 treelist text,
138 tstamp int(11) DEFAULT '0' NOT NULL,
139 expires int(11) unsigned DEFAULT '0' NOT NULL,
140 PRIMARY KEY (md5hash)
141 ) ENGINE=InnoDB;
142
143
144 #
145 # Table structure for table 'fe_groups'
146 #
147 CREATE TABLE fe_groups (
148 uid int(11) unsigned NOT NULL auto_increment,
149 pid int(11) unsigned DEFAULT '0' NOT NULL,
150 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
151 crdate int(11) unsigned DEFAULT '0' NOT NULL,
152 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
153 title varchar(50) DEFAULT '' NOT NULL,
154 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
155 lockToDomain varchar(50) DEFAULT '' NOT NULL,
156 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
157 description text,
158 subgroup tinytext,
159 TSconfig text,
160 PRIMARY KEY (uid),
161 KEY parent (pid)
162 );
163
164
165 #
166 # Table structure for table 'fe_session_data'
167 #
168 CREATE TABLE fe_session_data (
169 hash varchar(32) DEFAULT '' NOT NULL,
170 content mediumblob,
171 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
172 PRIMARY KEY (hash)
173 ) ENGINE=InnoDB;
174
175
176 #
177 # Table structure for table 'fe_sessions'
178 #
179 CREATE TABLE fe_sessions (
180 ses_id varchar(32) DEFAULT '' NOT NULL,
181 ses_name varchar(32) DEFAULT '' NOT NULL,
182 ses_iplock varchar(39) DEFAULT '' NOT NULL,
183 ses_hashlock int(11) DEFAULT '0' NOT NULL,
184 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
185 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
186 ses_data blob,
187 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
188 PRIMARY KEY (ses_id,ses_name)
189 ) ENGINE=InnoDB;
190
191
192 #
193 # Table structure for table 'fe_users'
194 #
195 CREATE TABLE fe_users (
196 uid int(11) unsigned NOT NULL auto_increment,
197 pid int(11) unsigned DEFAULT '0' NOT NULL,
198 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
199 username varchar(50) DEFAULT '' NOT NULL,
200 password varchar(40) DEFAULT '' NOT NULL,
201 usergroup tinytext,
202 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
203 starttime int(11) unsigned DEFAULT '0' NOT NULL,
204 endtime int(11) unsigned DEFAULT '0' NOT NULL,
205 name varchar(80) DEFAULT '' NOT NULL,
206 address varchar(255) DEFAULT '' NOT NULL,
207 telephone varchar(20) DEFAULT '' NOT NULL,
208 fax varchar(20) DEFAULT '' NOT NULL,
209 email varchar(80) DEFAULT '' NOT NULL,
210 crdate int(11) unsigned DEFAULT '0' NOT NULL,
211 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
212 lockToDomain varchar(50) DEFAULT '' NOT NULL,
213 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
214 uc blob,
215 title varchar(40) DEFAULT '' NOT NULL,
216 zip varchar(10) DEFAULT '' NOT NULL,
217 city varchar(50) DEFAULT '' NOT NULL,
218 country varchar(40) DEFAULT '' NOT NULL,
219 www varchar(80) DEFAULT '' NOT NULL,
220 company varchar(80) DEFAULT '' NOT NULL,
221 image tinytext,
222 TSconfig text,
223 fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
224 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
225 is_online int(10) unsigned DEFAULT '0' NOT NULL,
226 PRIMARY KEY (uid),
227 KEY parent (pid,username),
228 KEY username (username),
229 KEY is_online (is_online)
230 );
231
232
233 #
234 # Table structure for table 'pages_language_overlay'
235 #
236 CREATE TABLE pages_language_overlay (
237 uid int(11) NOT NULL auto_increment,
238 pid int(11) DEFAULT '0' NOT NULL,
239 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
240 t3ver_oid int(11) DEFAULT '0' NOT NULL,
241 t3ver_id int(11) DEFAULT '0' NOT NULL,
242 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
243 t3ver_label varchar(255) DEFAULT '' NOT NULL,
244 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
245 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
246 t3ver_count int(11) DEFAULT '0' NOT NULL,
247 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
248 t3_origuid int(11) DEFAULT '0' NOT NULL,
249 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
250 crdate int(11) unsigned DEFAULT '0' NOT NULL,
251 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
252 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
253 title varchar(255) DEFAULT '' NOT NULL,
254 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
255 starttime int(11) unsigned DEFAULT '0' NOT NULL,
256 endtime int(11) unsigned DEFAULT '0' NOT NULL,
257 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
258 subtitle varchar(255) DEFAULT '' NOT NULL,
259 nav_title varchar(255) DEFAULT '' NOT NULL,
260 media tinytext,
261 keywords text,
262 description text,
263 abstract text,
264 author varchar(255) DEFAULT '' NOT NULL,
265 author_email varchar(80) DEFAULT '' NOT NULL,
266 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
267 l18n_diffsource mediumblob,
268 url varchar(255) DEFAULT '' NOT NULL,
269 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
270 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
271 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
272
273 PRIMARY KEY (uid),
274 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
275 KEY parent (pid,sys_language_uid)
276 );
277
278
279 #
280 # Table structure for table 'static_template'
281 #
282 CREATE TABLE static_template (
283 uid int(11) unsigned NOT NULL auto_increment,
284 pid int(11) unsigned DEFAULT '0' NOT NULL,
285 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
286 crdate int(11) unsigned DEFAULT '0' NOT NULL,
287 title varchar(255) DEFAULT '' NOT NULL,
288 include_static tinytext,
289 constants text,
290 config text,
291 editorcfg text,
292 description text,
293 PRIMARY KEY (uid),
294 KEY parent (pid)
295 );
296
297
298 #
299 # Table structure for table 'sys_domain'
300 #
301 CREATE TABLE sys_domain (
302 uid int(11) unsigned NOT NULL auto_increment,
303 pid int(11) unsigned DEFAULT '0' NOT NULL,
304 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
305 crdate int(11) unsigned DEFAULT '0' NOT NULL,
306 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
307 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
308 domainName varchar(80) DEFAULT '' NOT NULL,
309 redirectTo varchar(120) DEFAULT '' NOT NULL,
310 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
311 sorting int(10) unsigned DEFAULT '0' NOT NULL,
312 prepend_params int(10) DEFAULT '0' NOT NULL,
313 forced tinyint(3) unsigned DEFAULT '0' NOT NULL,
314
315 PRIMARY KEY (uid),
316 KEY parent (pid)
317 );
318
319
320
321 #
322 # Table structure for table 'sys_template'
323 #
324 CREATE TABLE sys_template (
325 uid int(11) NOT NULL auto_increment,
326 pid int(11) DEFAULT '0' NOT NULL,
327 t3ver_oid int(11) DEFAULT '0' NOT NULL,
328 t3ver_id int(11) DEFAULT '0' NOT NULL,
329 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
330 t3ver_label varchar(255) DEFAULT '' NOT NULL,
331 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
332 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
333 t3ver_count int(11) DEFAULT '0' NOT NULL,
334 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
335 t3_origuid int(11) DEFAULT '0' NOT NULL,
336 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
337 sorting int(11) unsigned DEFAULT '0' NOT NULL,
338 crdate int(11) unsigned DEFAULT '0' NOT NULL,
339 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
340 title varchar(255) DEFAULT '' NOT NULL,
341 sitetitle varchar(255) DEFAULT '' NOT NULL,
342 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
343 starttime int(11) unsigned DEFAULT '0' NOT NULL,
344 endtime int(11) unsigned DEFAULT '0' NOT NULL,
345 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
346 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
347 include_static tinytext,
348 include_static_file text,
349 constants text,
350 config text,
351 editorcfg text,
352 resources text,
353 nextLevel varchar(5) DEFAULT '' NOT NULL,
354 description text,
355 basedOn tinytext,
356 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
357 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
358 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
359 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
360 PRIMARY KEY (uid),
361 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
362 KEY parent (pid,sorting,deleted,hidden)
363 );
364
365
366 #
367 # Table structure for table 'tt_content'
368 #
369 CREATE TABLE tt_content (
370 uid int(11) NOT NULL auto_increment,
371 pid int(11) DEFAULT '0' NOT NULL,
372 t3ver_oid int(11) DEFAULT '0' NOT NULL,
373 t3ver_id int(11) DEFAULT '0' NOT NULL,
374 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
375 t3ver_label varchar(255) DEFAULT '' NOT NULL,
376 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
377 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
378 t3ver_count int(11) DEFAULT '0' NOT NULL,
379 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
380 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
381 t3_origuid int(11) DEFAULT '0' NOT NULL,
382 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
383 crdate int(11) unsigned DEFAULT '0' NOT NULL,
384 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
385 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
386 sorting int(11) unsigned DEFAULT '0' NOT NULL,
387 CType varchar(30) DEFAULT '' NOT NULL,
388 header varchar(255) DEFAULT '' NOT NULL,
389 header_position varchar(6) DEFAULT '' NOT NULL,
390 bodytext mediumtext,
391 image text,
392 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
393 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
394 imagecaption text,
395 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
396 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
397 media text,
398 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
399 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
400 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
401 records text,
402 pages tinytext,
403 starttime int(11) unsigned DEFAULT '0' NOT NULL,
404 endtime int(11) unsigned DEFAULT '0' NOT NULL,
405 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
406 subheader varchar(255) DEFAULT '' NOT NULL,
407 spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
408 spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
409 fe_group varchar(100) DEFAULT '0' NOT NULL,
410 header_link varchar(255) DEFAULT '' NOT NULL,
411 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
412 image_link varchar(255) DEFAULT '' NOT NULL,
413 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
414 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
415 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
416 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
417 altText text,
418 titleText text,
419 longdescURL text,
420 header_layout varchar(30) DEFAULT '0' NOT NULL,
421 text_align varchar(6) DEFAULT '' NOT NULL,
422 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
423 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
424 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
425 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
426 menu_type varchar(30) DEFAULT '0' NOT NULL,
427 list_type varchar(36) DEFAULT '0' NOT NULL,
428 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
429 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
430 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
431 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
432 select_key varchar(80) DEFAULT '' NOT NULL,
433 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
434 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
435 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
436 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
437 date int(10) unsigned DEFAULT '0' NOT NULL,
438 splash_layout varchar(30) DEFAULT '0' NOT NULL,
439 multimedia tinytext,
440 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
441 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
442 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
443 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
444 sys_language_uid int(11) DEFAULT '0' NOT NULL,
445 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
446 pi_flexform mediumtext,
447 l18n_parent int(11) DEFAULT '0' NOT NULL,
448 l18n_diffsource mediumblob,
449
450 PRIMARY KEY (uid),
451 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
452 KEY parent (pid,sorting)
453 );
454
455
456 #
457 # Table structure for table 'pages'
458 #
459 CREATE TABLE pages (
460 url varchar(255) DEFAULT '' NOT NULL,
461 starttime int(11) unsigned DEFAULT '0' NOT NULL,
462 endtime int(11) unsigned DEFAULT '0' NOT NULL,
463 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
464 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
465 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
466 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
467 fe_group varchar(100) DEFAULT '0' NOT NULL,
468 subtitle varchar(255) DEFAULT '' NOT NULL,
469 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
470 target varchar(80) DEFAULT '' NOT NULL,
471 media text,
472 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
473 keywords text,
474 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
475 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
476 description text,
477 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
478 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
479 abstract text,
480 module varchar(10) DEFAULT '' NOT NULL,
481 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
482 author varchar(255) DEFAULT '' NOT NULL,
483 author_email varchar(80) DEFAULT '' NOT NULL,
484 nav_title varchar(255) DEFAULT '' NOT NULL,
485 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
486 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
487 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
488 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
489 alias varchar(32) DEFAULT '' NOT NULL,
490 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
491 fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
492 KEY alias (alias)
493 );