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