[BUGFIX] Remove caches for page title and meta tag
[Packages/TYPO3.CMS.git] / typo3 / sysext / core / ext_tables.sql
1 #
2 # Table structure for table 'be_groups'
3 #
4 CREATE TABLE be_groups (
5 title varchar(50) DEFAULT '' NOT NULL,
6 non_exclude_fields text,
7 explicit_allowdeny text,
8 allowed_languages varchar(255) DEFAULT '' NOT NULL,
9 custom_options text,
10 db_mountpoints text,
11 pagetypes_select varchar(255) DEFAULT '' NOT NULL,
12 tables_select text,
13 tables_modify text,
14 groupMods text,
15 file_mountpoints text,
16 file_permissions text,
17 lockToDomain varchar(50) DEFAULT '' NOT NULL,
18 TSconfig text,
19 subgroup text,
20 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
21 category_perms text
22 );
23
24 #
25 # Table structure for table 'be_sessions'
26 #
27 CREATE TABLE be_sessions (
28 ses_id varchar(32) DEFAULT '' NOT NULL,
29 ses_iplock varchar(39) DEFAULT '' NOT NULL,
30 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
31 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
32 ses_data longblob,
33 ses_backuserid int(11) NOT NULL default '0',
34 PRIMARY KEY (ses_id),
35 KEY ses_tstamp (ses_tstamp)
36 );
37
38 #
39 # Table structure for table 'be_users'
40 #
41 CREATE TABLE be_users (
42 username varchar(50) DEFAULT '' NOT NULL,
43 avatar int(11) unsigned NOT NULL default '0',
44 password varchar(100) DEFAULT '' NOT NULL,
45 admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
46 usergroup varchar(255) DEFAULT '' NOT NULL,
47 lang varchar(6) DEFAULT '' NOT NULL,
48 email varchar(255) DEFAULT '' NOT NULL,
49 db_mountpoints text,
50 options tinyint(4) unsigned DEFAULT '0' NOT NULL,
51 realName varchar(80) DEFAULT '' NOT NULL,
52 userMods text,
53 allowed_languages varchar(255) DEFAULT '' NOT NULL,
54 uc mediumblob,
55 file_mountpoints text,
56 file_permissions text,
57 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
58 lockToDomain varchar(50) DEFAULT '' NOT NULL,
59 disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
60 TSconfig text,
61 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
62 createdByAction int(11) DEFAULT '0' NOT NULL,
63 usergroup_cached_list text,
64 workspace_id int(11) DEFAULT '0' NOT NULL,
65 category_perms text,
66 KEY username (username)
67 );
68
69 #
70 # Table structure for table 'pages'
71 #
72 CREATE TABLE pages (
73 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
74 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
75 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
76 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
77 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
78 title varchar(255) DEFAULT '' NOT NULL,
79 slug varchar(2048),
80 doktype int(11) unsigned DEFAULT '0' NOT NULL,
81 TSconfig text,
82 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
83 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
84 url varchar(255) DEFAULT '' NOT NULL,
85 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
86 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
87 subtitle varchar(255) DEFAULT '' NOT NULL,
88 layout int(11) unsigned DEFAULT '0' NOT NULL,
89 target varchar(80) DEFAULT '' NOT NULL,
90 media int(11) unsigned DEFAULT '0' NOT NULL,
91 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
92 keywords text,
93 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
94 cache_tags varchar(255) DEFAULT '' NOT NULL,
95 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
96 description text,
97 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
98 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
99 abstract text,
100 module varchar(255) DEFAULT '' NOT NULL,
101 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
102 author varchar(255) DEFAULT '' NOT NULL,
103 author_email varchar(255) DEFAULT '' NOT NULL,
104 nav_title varchar(255) DEFAULT '' NOT NULL,
105 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
106 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
107 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
108 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
109 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
110 fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
111 backend_layout varchar(64) DEFAULT '' NOT NULL,
112 backend_layout_next_level varchar(64) DEFAULT '' NOT NULL,
113 tsconfig_includes text,
114 # @deprecated since v9 and will be removed in TYPO3 v11. Legacy connection UID field to pages_language_overlay table
115 legacy_overlay_uid int(11) unsigned DEFAULT '0' NOT NULL,
116
117 KEY determineSiteRoot (is_siteroot),
118 KEY language_identifier (l10n_parent,sys_language_uid)
119 );
120
121 #
122 # Table structure for table 'sys_registry'
123 #
124 CREATE TABLE sys_registry (
125 uid int(11) unsigned NOT NULL auto_increment,
126 entry_namespace varchar(128) DEFAULT '' NOT NULL,
127 entry_key varchar(128) DEFAULT '' NOT NULL,
128 entry_value mediumblob,
129 PRIMARY KEY (uid),
130 UNIQUE KEY entry_identifier (entry_namespace,entry_key)
131 );
132
133 #
134 # Table structure for table 'sys_be_shortcuts'
135 #
136 CREATE TABLE sys_be_shortcuts (
137 uid int(11) unsigned NOT NULL auto_increment,
138 userid int(11) unsigned DEFAULT '0' NOT NULL,
139 module_name varchar(255) DEFAULT '' NOT NULL,
140 url text,
141 description varchar(255) DEFAULT '' NOT NULL,
142 sorting int(11) DEFAULT '0' NOT NULL,
143 sc_group tinyint(4) DEFAULT '0' NOT NULL,
144 PRIMARY KEY (uid),
145 KEY event (userid)
146 );
147
148
149 #
150 # Table structure for table 'sys_news'
151 #
152 CREATE TABLE sys_news (
153 title varchar(255) DEFAULT '' NOT NULL,
154 content mediumtext
155 );
156
157
158 #
159 # Table structure for table 'sys_filemounts'
160 #
161 CREATE TABLE sys_filemounts (
162 title varchar(255) DEFAULT '' NOT NULL,
163 path varchar(255) DEFAULT '' NOT NULL,
164 base int(11) unsigned DEFAULT '0' NOT NULL,
165 read_only tinyint(1) unsigned DEFAULT '0' NOT NULL
166 );
167
168
169 #
170 # Table structure for table 'sys_file_storage'
171 #
172 CREATE TABLE sys_file_storage (
173 name varchar(255) DEFAULT '' NOT NULL,
174 driver tinytext,
175 configuration text,
176 is_default tinyint(4) DEFAULT '0' NOT NULL,
177 is_browsable tinyint(4) DEFAULT '0' NOT NULL,
178 is_public tinyint(4) DEFAULT '0' NOT NULL,
179 is_writable tinyint(4) DEFAULT '0' NOT NULL,
180 is_online tinyint(4) DEFAULT '1' NOT NULL,
181 auto_extract_metadata tinyint(4) DEFAULT '1' NOT NULL,
182 processingfolder tinytext
183 );
184
185 #
186 # Table structure for table 'sys_file'
187 #
188 CREATE TABLE sys_file (
189 last_indexed int(11) DEFAULT '0' NOT NULL,
190
191 # management information
192 missing tinyint(4) DEFAULT '0' NOT NULL,
193 storage int(11) DEFAULT '0' NOT NULL,
194 type varchar(10) DEFAULT '' NOT NULL,
195 metadata int(11) DEFAULT '0' NOT NULL,
196
197 # file info data
198 identifier text,
199 identifier_hash char(40) DEFAULT '' NOT NULL,
200 folder_hash char(40) DEFAULT '' NOT NULL,
201 extension varchar(255) DEFAULT '' NOT NULL,
202 mime_type varchar(255) DEFAULT '' NOT NULL,
203 name tinytext,
204 sha1 char(40) DEFAULT '' NOT NULL,
205 size bigint(20) unsigned DEFAULT '0' NOT NULL,
206 creation_date int(11) DEFAULT '0' NOT NULL,
207 modification_date int(11) DEFAULT '0' NOT NULL,
208
209 KEY sel01 (storage,identifier_hash),
210 KEY folder (storage,folder_hash),
211 KEY tstamp (tstamp),
212 KEY lastindex (last_indexed),
213 KEY sha1 (sha1)
214 );
215
216 #
217 # Table structure for table 'sys_file_metadata'
218 #
219 CREATE TABLE sys_file_metadata (
220 file int(11) DEFAULT '0' NOT NULL,
221 title tinytext,
222 width int(11) DEFAULT '0' NOT NULL,
223 height int(11) DEFAULT '0' NOT NULL,
224 description text,
225 alternative text,
226
227 KEY file (file),
228 KEY fal_filelist (l10n_parent,sys_language_uid)
229 );
230
231
232 #
233 # Table structure for table 'sys_file_processedfile'.
234 # which is a "temporary" file, like an image preview
235 # This table does not have a TCA representation, as it is only written
236 # to using direct SQL queries in the code
237 #
238 CREATE TABLE sys_file_processedfile (
239 uid int(11) NOT NULL auto_increment,
240 tstamp int(11) DEFAULT '0' NOT NULL,
241 crdate int(11) DEFAULT '0' NOT NULL,
242
243 storage int(11) DEFAULT '0' NOT NULL,
244 original int(11) DEFAULT '0' NOT NULL,
245 identifier varchar(512) DEFAULT '' NOT NULL,
246 name tinytext,
247 configuration text,
248 configurationsha1 char(40) DEFAULT '' NOT NULL,
249 originalfilesha1 char(40) DEFAULT '' NOT NULL,
250 task_type varchar(200) DEFAULT '' NOT NULL,
251 checksum char(10) DEFAULT '' NOT NULL,
252 width int(11) DEFAULT '0',
253 height int(11) DEFAULT '0',
254
255 PRIMARY KEY (uid),
256 KEY combined_1 (original,task_type(100),configurationsha1),
257 KEY identifier (storage,identifier(180))
258 );
259
260 #
261 # Table structure for table 'sys_file_reference'
262 # which is one usage of a file with overloaded metadata
263 #
264 CREATE TABLE sys_file_reference (
265 # Reference fields (basically same as MM table)
266 uid_local int(11) DEFAULT '0' NOT NULL,
267 uid_foreign int(11) DEFAULT '0' NOT NULL,
268 tablenames varchar(64) DEFAULT '' NOT NULL,
269 fieldname varchar(64) DEFAULT '' NOT NULL,
270 sorting_foreign int(11) DEFAULT '0' NOT NULL,
271 table_local varchar(64) DEFAULT '' NOT NULL,
272
273 # Local usage overlay fields
274 title tinytext,
275 description text,
276 alternative text,
277 link varchar(1024) DEFAULT '' NOT NULL,
278 crop varchar(4000) DEFAULT '' NOT NULL,
279 autoplay tinyint(4) DEFAULT '0' NOT NULL,
280
281 KEY tablenames_fieldname (tablenames(32),fieldname(12)),
282 KEY deleted (deleted),
283 KEY uid_local (uid_local),
284 KEY uid_foreign (uid_foreign),
285 KEY combined_1 (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)
286 );
287
288
289 #
290 # Table structure for table 'sys_file_collection'
291 #
292 CREATE TABLE sys_file_collection (
293 title tinytext,
294 type varchar(30) DEFAULT 'static' NOT NULL,
295
296 # for type=static
297 files int(11) DEFAULT '0' NOT NULL,
298
299 # for type=folder:
300 storage int(11) DEFAULT '0' NOT NULL,
301 folder text,
302 recursive tinyint(4) DEFAULT '0' NOT NULL,
303
304 # for type=category:
305 category int(11) DEFAULT '0' NOT NULL
306 );
307
308 #
309 # Table structure for table 'sys_collection'
310 #
311 CREATE TABLE sys_collection (
312 title tinytext,
313 type varchar(32) DEFAULT 'static' NOT NULL,
314 table_name tinytext,
315 items int(11) DEFAULT '0' NOT NULL
316 );
317
318 #
319 # Table structure for table 'sys_collection_entries'
320 #
321 CREATE TABLE sys_collection_entries (
322 uid int(11) NOT NULL auto_increment,
323 uid_local int(11) DEFAULT '0' NOT NULL,
324 uid_foreign int(11) DEFAULT '0' NOT NULL,
325 tablenames varchar(64) DEFAULT '' NOT NULL,
326 sorting int(11) DEFAULT '0' NOT NULL,
327
328 KEY uid_local (uid_local),
329 KEY uid_foreign (uid_foreign),
330 PRIMARY KEY (uid)
331 );
332
333 #
334 # Table structure for table 'sys_history'
335 #
336 CREATE TABLE sys_history (
337 uid int(11) unsigned NOT NULL auto_increment,
338 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
339 actiontype tinyint(3) DEFAULT '0' NOT NULL,
340 usertype varchar(2) DEFAULT 'BE' NOT NULL,
341 userid int(11) unsigned,
342 originaluserid int(11) unsigned,
343 recuid int(11) DEFAULT '0' NOT NULL,
344 tablename varchar(255) DEFAULT '' NOT NULL,
345 history_data mediumtext,
346 workspace int(11) DEFAULT '0',
347
348 PRIMARY KEY (uid),
349 KEY recordident_1 (tablename(100),recuid),
350 KEY recordident_2 (tablename(100),tstamp)
351 ) ENGINE=InnoDB;
352
353 #
354 # Table structure for table 'sys_lockedrecords'
355 #
356 CREATE TABLE sys_lockedrecords (
357 uid int(11) unsigned NOT NULL auto_increment,
358 userid int(11) unsigned DEFAULT '0' NOT NULL,
359 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
360 record_table varchar(255) DEFAULT '' NOT NULL,
361 record_uid int(11) DEFAULT '0' NOT NULL,
362 record_pid int(11) DEFAULT '0' NOT NULL,
363 username varchar(50) DEFAULT '' NOT NULL,
364 feuserid int(11) unsigned DEFAULT '0' NOT NULL,
365 PRIMARY KEY (uid),
366 KEY event (userid,tstamp)
367 );
368
369 #
370 # Table structure for table 'sys_refindex'
371 #
372 CREATE TABLE sys_refindex (
373 hash varchar(32) DEFAULT '' NOT NULL,
374 tablename varchar(255) DEFAULT '' NOT NULL,
375 recuid int(11) DEFAULT '0' NOT NULL,
376 field varchar(64) DEFAULT '' NOT NULL,
377 flexpointer varchar(255) DEFAULT '' NOT NULL,
378 softref_key varchar(30) DEFAULT '' NOT NULL,
379 softref_id varchar(40) DEFAULT '' NOT NULL,
380 sorting int(11) DEFAULT '0' NOT NULL,
381 deleted tinyint(1) DEFAULT '0' NOT NULL,
382 workspace int(11) DEFAULT '0' NOT NULL,
383 ref_table varchar(255) DEFAULT '' NOT NULL,
384 ref_uid int(11) DEFAULT '0' NOT NULL,
385 ref_string varchar(1024) DEFAULT '' NOT NULL,
386
387 PRIMARY KEY (hash),
388 KEY lookup_rec (tablename(100),recuid),
389 KEY lookup_uid (ref_table(100),ref_uid),
390 KEY lookup_string (ref_string(191))
391 );
392
393 #
394 # Table structure for table 'sys_log'
395 #
396 CREATE TABLE sys_log (
397 userid int(11) unsigned DEFAULT '0' NOT NULL,
398 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
399 recuid int(11) unsigned DEFAULT '0' NOT NULL,
400 tablename varchar(255) DEFAULT '' NOT NULL,
401 recpid int(11) DEFAULT '0' NOT NULL,
402 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
403 details text,
404 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
405 details_nr tinyint(3) DEFAULT '0' NOT NULL,
406 IP varchar(39) DEFAULT '' NOT NULL,
407 log_data text,
408 event_pid int(11) DEFAULT '-1' NOT NULL,
409 workspace int(11) DEFAULT '0' NOT NULL,
410 NEWid varchar(30) DEFAULT '' NOT NULL,
411 request_id varchar(13) DEFAULT '' NOT NULL,
412 time_micro float DEFAULT '0' NOT NULL,
413 component varchar(255) DEFAULT '' NOT NULL,
414 level tinyint(1) unsigned DEFAULT '0' NOT NULL,
415 message text,
416 data text,
417 KEY event (userid,event_pid),
418 KEY recuidIdx (recuid),
419 KEY user_auth (type,action,tstamp),
420 KEY request (request_id),
421 KEY combined_1 (tstamp, type, userid),
422 KEY errorcount (tstamp,error)
423 ) ENGINE=InnoDB;
424
425 #
426 # Table structure for table 'sys_language'
427 #
428 CREATE TABLE sys_language (
429 title varchar(80) DEFAULT '' NOT NULL,
430 flag varchar(20) DEFAULT '' NOT NULL,
431 language_isocode varchar(2) DEFAULT '' NOT NULL,
432 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL
433 );
434
435 #
436 # Table structure for table 'sys_category'
437 #
438 CREATE TABLE sys_category (
439 title tinytext NOT NULL,
440 parent int(11) DEFAULT '0' NOT NULL,
441 items int(11) DEFAULT '0' NOT NULL,
442
443 KEY category_parent (parent),
444 KEY category_list (pid,deleted,sys_language_uid)
445 );
446
447 #
448 # Table structure for table 'sys_category_record_mm'
449 #
450 CREATE TABLE sys_category_record_mm (
451 uid_local int(11) DEFAULT '0' NOT NULL,
452 uid_foreign int(11) DEFAULT '0' NOT NULL,
453 tablenames varchar(255) DEFAULT '' NOT NULL,
454 fieldname varchar(255) DEFAULT '' NOT NULL,
455 sorting int(11) DEFAULT '0' NOT NULL,
456 sorting_foreign int(11) DEFAULT '0' NOT NULL,
457
458 KEY uid_local_foreign (uid_local,uid_foreign),
459 KEY uid_foreign_tablefield (uid_foreign,tablenames(40),fieldname(3),sorting_foreign)
460 );