Fixed bug #12613: Wrong character encoding in cache tables breaks frontend rendering
[Packages/TYPO3.CMS.git] / t3lib / stddb / tables.sql
1 #
2 # TYPO3 SVN ID: $Id$
3 #
4
5 #
6 # Table structure for table 'be_groups'
7 #
8 CREATE TABLE be_groups (
9 uid int(11) unsigned NOT NULL auto_increment,
10 pid int(11) unsigned DEFAULT '0' NOT NULL,
11 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
12 title varchar(50) DEFAULT '' NOT NULL,
13 non_exclude_fields text,
14 explicit_allowdeny text,
15 allowed_languages varchar(255) DEFAULT '' NOT NULL,
16 custom_options text,
17 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
18 pagetypes_select varchar(255) DEFAULT '' NOT NULL,
19 tables_select text,
20 tables_modify text,
21 crdate int(11) unsigned DEFAULT '0' NOT NULL,
22 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
23 groupMods text,
24 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
25 fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
26 hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
27 inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
28 description text,
29 lockToDomain varchar(50) DEFAULT '' NOT NULL,
30 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
31 TSconfig text,
32 subgroup varchar(255) DEFAULT '' NOT NULL,
33 hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
34 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
35 PRIMARY KEY (uid),
36 KEY parent (pid)
37 );
38
39 #
40 # Table structure for table 'be_sessions'
41 #
42 CREATE TABLE be_sessions (
43 ses_id varchar(32) DEFAULT '' NOT NULL,
44 ses_name varchar(32) DEFAULT '' NOT NULL,
45 ses_iplock varchar(39) DEFAULT '' NOT NULL,
46 ses_hashlock int(11) DEFAULT '0' NOT NULL,
47 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
48 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
49 ses_data longtext,
50 ses_backuserid int(11) NOT NULL default '0',
51 PRIMARY KEY (ses_id,ses_name)
52 );
53
54 #
55 # Table structure for table 'be_users'
56 #
57 CREATE TABLE be_users (
58 uid int(11) unsigned NOT NULL auto_increment,
59 pid int(11) unsigned DEFAULT '0' NOT NULL,
60 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
61 username varchar(50) DEFAULT '' NOT NULL,
62 password varchar(40) DEFAULT '' NOT NULL,
63 admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
64 usergroup varchar(255) DEFAULT '' NOT NULL,
65 disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
66 starttime int(11) unsigned DEFAULT '0' NOT NULL,
67 endtime int(11) unsigned DEFAULT '0' NOT NULL,
68 lang char(2) DEFAULT '' NOT NULL,
69 email varchar(80) DEFAULT '' NOT NULL,
70 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
71 options tinyint(4) unsigned DEFAULT '0' NOT NULL,
72 crdate int(11) unsigned DEFAULT '0' NOT NULL,
73 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
74 realName varchar(80) DEFAULT '' NOT NULL,
75 userMods varchar(255) DEFAULT '' NOT NULL,
76 allowed_languages varchar(255) DEFAULT '' NOT NULL,
77 uc text,
78 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
79 fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
80 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
81 lockToDomain varchar(50) DEFAULT '' NOT NULL,
82 disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
83 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
84 TSconfig text,
85 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
86 createdByAction int(11) DEFAULT '0' NOT NULL,
87 usergroup_cached_list varchar(255) DEFAULT '' NOT NULL,
88 workspace_id int(11) DEFAULT '0' NOT NULL,
89 workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
90 PRIMARY KEY (uid),
91 KEY parent (pid),
92 KEY username (username)
93 );
94
95 #
96 # Table structure for table 'cache_extensions'
97 #
98 CREATE TABLE cache_extensions (
99 extkey varchar(60) NOT NULL default '',
100 version varchar(10) NOT NULL default '',
101 alldownloadcounter int(11) unsigned NOT NULL default '0',
102 downloadcounter int(11) unsigned NOT NULL default '0',
103 title varchar(150) NOT NULL default '',
104 description mediumtext,
105 state int(4) NOT NULL default '0',
106 reviewstate int(4) NOT NULL default '0',
107 category int(4) NOT NULL default '0',
108 lastuploaddate int(11) unsigned NOT NULL default '0',
109 dependencies mediumtext,
110 authorname varchar(100) NOT NULL default '',
111 authoremail varchar(100) NOT NULL default '',
112 ownerusername varchar(50) NOT NULL default '',
113 t3xfilemd5 varchar(35) NOT NULL default '',
114 uploadcomment mediumtext,
115 authorcompany varchar(100) NOT NULL default '',
116 intversion int(11) NOT NULL default '0',
117 lastversion int(3) NOT NULL default '0',
118 lastreviewedversion int(3) NOT NULL default '0',
119 PRIMARY KEY (extkey,version)
120 );
121
122 #
123 # Table structure for table 'cache_hash'
124 #
125 CREATE TABLE cache_hash (
126 id int(11) unsigned NOT NULL auto_increment,
127 hash varchar(32) DEFAULT '' NOT NULL,
128 content mediumblob,
129 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
130 ident varchar(32) DEFAULT '' NOT NULL,
131 PRIMARY KEY (id),
132 KEY hash (hash)
133 ) ENGINE=InnoDB;
134
135
136 #
137 # Table structure for table 'cachingframework_cache_hash'
138 #
139 CREATE TABLE cachingframework_cache_hash (
140 id int(11) unsigned NOT NULL auto_increment,
141 identifier varchar(128) DEFAULT '' NOT NULL,
142 crdate int(11) unsigned DEFAULT '0' NOT NULL,
143 content mediumtext,
144 lifetime int(11) unsigned DEFAULT '0' NOT NULL,
145 PRIMARY KEY (id),
146 KEY cache_id (identifier)
147 ) ENGINE=InnoDB;
148
149
150 #
151 # Table structure for table 'cachingframework_cache_hash_tags'
152 #
153 CREATE TABLE cachingframework_cache_hash_tags (
154 id int(11) unsigned NOT NULL auto_increment,
155 identifier varchar(128) DEFAULT '' NOT NULL,
156 tag varchar(128) DEFAULT '' NOT NULL,
157 PRIMARY KEY (id),
158 KEY cache_id (identifier),
159 KEY cache_tag (tag)
160 ) ENGINE=InnoDB;
161
162
163 #
164 # Table structure for table 'cache_imagesizes'
165 #
166 CREATE TABLE cache_imagesizes (
167 md5hash varchar(32) DEFAULT '' NOT NULL,
168 md5filename varchar(32) DEFAULT '' NOT NULL,
169 tstamp int(11) DEFAULT '0' NOT NULL,
170 filename varchar(255) DEFAULT '' NOT NULL,
171 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
172 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
173 PRIMARY KEY (md5filename)
174 ) ENGINE=InnoDB;
175
176 #
177 # Table structure for table 'pages'
178 #
179 CREATE TABLE pages (
180 uid int(11) NOT NULL auto_increment,
181 pid int(11) DEFAULT '0' NOT NULL,
182 t3ver_oid int(11) DEFAULT '0' NOT NULL,
183 t3ver_id int(11) DEFAULT '0' NOT NULL,
184 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
185 t3ver_label varchar(255) DEFAULT '' NOT NULL,
186 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
187 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
188 t3ver_count int(11) DEFAULT '0' NOT NULL,
189 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
190 t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
191 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
192 t3_origuid int(11) DEFAULT '0' NOT NULL,
193 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
194 sorting int(11) unsigned DEFAULT '0' NOT NULL,
195 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
196 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
197 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
198 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
199 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
200 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
201 editlock tinyint(4) 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 title varchar(255) DEFAULT '' NOT NULL,
206 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
207 TSconfig text,
208 storage_pid int(11) DEFAULT '0' NOT NULL,
209 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
210 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
211 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
212 PRIMARY KEY (uid),
213 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
214 KEY parent (pid,sorting,deleted,hidden)
215 );
216
217 #
218 # Table structure for table 'sys_registry'
219 #
220 CREATE TABLE sys_registry (
221 uid int(11) unsigned NOT NULL auto_increment,
222 entry_namespace varchar(128) DEFAULT '' NOT NULL,
223 entry_key varchar(128) DEFAULT '' NOT NULL,
224 entry_value blob,
225 PRIMARY KEY (uid),
226 UNIQUE KEY entry_identifier (entry_namespace,entry_key)
227 );
228
229 #
230 # Table structure for table 'sys_be_shortcuts'
231 #
232 CREATE TABLE sys_be_shortcuts (
233 uid int(11) unsigned NOT NULL auto_increment,
234 userid int(11) unsigned DEFAULT '0' NOT NULL,
235 module_name varchar(255) DEFAULT '' NOT NULL,
236 url text,
237 description varchar(255) DEFAULT '' NOT NULL,
238 sorting int(11) DEFAULT '0' NOT NULL,
239 sc_group tinyint(4) DEFAULT '0' NOT NULL,
240 PRIMARY KEY (uid),
241 KEY event (userid)
242 );
243
244
245 #
246 # Table structure for table 'sys_preview'
247 #
248 CREATE TABLE sys_preview (
249 keyword varchar(32) DEFAULT '' NOT NULL,
250 tstamp int(11) DEFAULT '0' NOT NULL,
251 endtime int(11) DEFAULT '0' NOT NULL,
252 config text,
253 PRIMARY KEY (keyword)
254 );
255
256
257 #
258 # Table structure for table 'sys_filemounts'
259 #
260 CREATE TABLE sys_filemounts (
261 uid int(11) unsigned NOT NULL auto_increment,
262 pid int(11) unsigned DEFAULT '0' NOT NULL,
263 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
264 title varchar(30) DEFAULT '' NOT NULL,
265 path varchar(120) DEFAULT '' NOT NULL,
266 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
267 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
268 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
269 PRIMARY KEY (uid),
270 KEY parent (pid)
271 );
272
273 #
274 # Table structure for table 'sys_workspace'
275 #
276 CREATE TABLE sys_workspace (
277 uid int(11) NOT NULL auto_increment,
278 pid int(11) DEFAULT '0' NOT NULL,
279 tstamp int(11) DEFAULT '0' NOT NULL,
280 deleted tinyint(1) DEFAULT '0' NOT NULL,
281 title varchar(30) DEFAULT '' NOT NULL,
282 description varchar(255) DEFAULT '' NOT NULL,
283 adminusers varchar(255) DEFAULT '' NOT NULL,
284 members text,
285 reviewers text,
286 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
287 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
288 publish_time int(11) DEFAULT '0' NOT NULL,
289 unpublish_time int(11) DEFAULT '0' NOT NULL,
290 freeze tinyint(3) DEFAULT '0' NOT NULL,
291 live_edit tinyint(3) DEFAULT '0' NOT NULL,
292 review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
293 vtypes tinyint(3) DEFAULT '0' NOT NULL,
294 disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
295 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
296 publish_access tinyint(3) DEFAULT '0' NOT NULL,
297 stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
298
299 PRIMARY KEY (uid),
300 KEY parent (pid)
301 );
302
303 #
304 # Table structure for table 'sys_history'
305 #
306 CREATE TABLE sys_history (
307 uid int(11) unsigned NOT NULL auto_increment,
308 sys_log_uid int(11) DEFAULT '0' NOT NULL,
309 history_data mediumtext,
310 fieldlist text,
311 recuid int(11) DEFAULT '0' NOT NULL,
312 tablename varchar(255) DEFAULT '' NOT NULL,
313 tstamp int(11) DEFAULT '0' NOT NULL,
314 history_files mediumtext,
315 snapshot tinyint(4) DEFAULT '0' NOT NULL,
316 PRIMARY KEY (uid),
317 KEY recordident (tablename,recuid,tstamp),
318 KEY sys_log_uid (sys_log_uid)
319 );
320
321 #
322 # Table structure for table 'sys_lockedrecords'
323 #
324 CREATE TABLE sys_lockedrecords (
325 uid int(11) unsigned NOT NULL auto_increment,
326 userid int(11) unsigned DEFAULT '0' NOT NULL,
327 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
328 record_table varchar(255) DEFAULT '' NOT NULL,
329 record_uid int(11) DEFAULT '0' NOT NULL,
330 record_pid int(11) DEFAULT '0' NOT NULL,
331 username varchar(20) DEFAULT '' NOT NULL,
332 feuserid int(11) unsigned DEFAULT '0' NOT NULL,
333 PRIMARY KEY (uid),
334 KEY event (userid,tstamp)
335 );
336
337 #
338 # Table structure for table 'sys_refindex'
339 #
340 CREATE TABLE sys_refindex (
341 hash varchar(32) DEFAULT '' NOT NULL,
342 tablename varchar(255) DEFAULT '' NOT NULL,
343 recuid int(11) DEFAULT '0' NOT NULL,
344 field varchar(40) DEFAULT '' NOT NULL,
345 flexpointer varchar(255) DEFAULT '' NOT NULL,
346 softref_key varchar(30) DEFAULT '' NOT NULL,
347 softref_id varchar(40) DEFAULT '' NOT NULL,
348 sorting int(11) DEFAULT '0' NOT NULL,
349 deleted tinyint(1) DEFAULT '0' NOT NULL,
350 ref_table varchar(255) DEFAULT '' NOT NULL,
351 ref_uid int(11) DEFAULT '0' NOT NULL,
352 ref_string varchar(200) DEFAULT '' NOT NULL,
353
354 PRIMARY KEY (hash),
355 KEY lookup_rec (tablename,recuid),
356 KEY lookup_uid (ref_table,ref_uid),
357 KEY lookup_string (ref_string)
358 );
359
360 #
361 # Table structure for table 'sys_refindex_words'
362 #
363 CREATE TABLE sys_refindex_words (
364 wid int(11) DEFAULT '0' NOT NULL,
365 baseword varchar(60) DEFAULT '' NOT NULL,
366 PRIMARY KEY (wid)
367 );
368
369 #
370 # Table structure for table 'sys_refindex_rel'
371 #
372 CREATE TABLE sys_refindex_rel (
373 rid int(11) DEFAULT '0' NOT NULL,
374 wid int(11) DEFAULT '0' NOT NULL,
375 PRIMARY KEY (rid,wid)
376 );
377
378
379 #
380 # Table structure for table 'sys_refindex_res'
381 #
382 CREATE TABLE sys_refindex_res (
383 rid int(11) DEFAULT '0' NOT NULL,
384 tablename varchar(255) DEFAULT '' NOT NULL,
385 recuid int(11) DEFAULT '0' NOT NULL,
386 PRIMARY KEY (rid)
387 );
388
389 #
390 # Table structure for table 'sys_log'
391 #
392 CREATE TABLE sys_log (
393 uid int(11) unsigned NOT NULL auto_increment,
394 userid int(11) unsigned DEFAULT '0' NOT NULL,
395 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
396 recuid int(11) unsigned DEFAULT '0' NOT NULL,
397 tablename varchar(255) DEFAULT '' NOT NULL,
398 recpid int(11) DEFAULT '0' NOT NULL,
399 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
400 details varchar(255) DEFAULT '' NOT NULL,
401 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
402 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
403 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
404 IP varchar(39) DEFAULT '' NOT NULL,
405 log_data varchar(255) DEFAULT '' NOT NULL,
406 event_pid int(11) DEFAULT '-1' NOT NULL,
407 workspace int(11) DEFAULT '0' NOT NULL,
408 NEWid varchar(20) DEFAULT '' NOT NULL,
409 PRIMARY KEY (uid),
410 KEY event (userid,event_pid),
411 KEY recuidIdx (recuid,uid)
412 ) ENGINE=InnoDB;
413
414 #
415 # Table structure for table 'sys_language'
416 #
417 CREATE TABLE sys_language (
418 uid int(11) unsigned NOT NULL auto_increment,
419 pid int(11) unsigned DEFAULT '0' NOT NULL,
420 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
421 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
422 title varchar(80) DEFAULT '' NOT NULL,
423 flag varchar(20) DEFAULT '' NOT NULL,
424 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
425 PRIMARY KEY (uid),
426 KEY parent (pid)
427 );