Added feature #16396: Implement a Grid View + wizard to enable the backend layout...
[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_hash'
97 #
98 CREATE TABLE cache_hash (
99 id int(11) unsigned NOT NULL auto_increment,
100 hash varchar(32) DEFAULT '' NOT NULL,
101 content mediumblob,
102 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
103 ident varchar(32) DEFAULT '' NOT NULL,
104 PRIMARY KEY (id),
105 KEY hash (hash)
106 ) ENGINE=InnoDB;
107
108
109 #
110 # Table structure for table 'cachingframework_cache_hash'
111 #
112 CREATE TABLE cachingframework_cache_hash (
113 id int(11) unsigned NOT NULL auto_increment,
114 identifier varchar(128) DEFAULT '' NOT NULL,
115 crdate int(11) unsigned DEFAULT '0' NOT NULL,
116 content mediumblob,
117 lifetime int(11) unsigned DEFAULT '0' NOT NULL,
118 PRIMARY KEY (id),
119 KEY cache_id (identifier)
120 ) ENGINE=InnoDB;
121
122
123 #
124 # Table structure for table 'cachingframework_cache_hash_tags'
125 #
126 CREATE TABLE cachingframework_cache_hash_tags (
127 id int(11) unsigned NOT NULL auto_increment,
128 identifier varchar(128) DEFAULT '' NOT NULL,
129 tag varchar(128) DEFAULT '' NOT NULL,
130 PRIMARY KEY (id),
131 KEY cache_id (identifier),
132 KEY cache_tag (tag)
133 ) ENGINE=InnoDB;
134
135
136 #
137 # Table structure for table 'cache_imagesizes'
138 #
139 CREATE TABLE cache_imagesizes (
140 md5hash varchar(32) DEFAULT '' NOT NULL,
141 md5filename varchar(32) DEFAULT '' NOT NULL,
142 tstamp int(11) DEFAULT '0' NOT NULL,
143 filename varchar(255) DEFAULT '' NOT NULL,
144 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
145 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
146 PRIMARY KEY (md5filename)
147 ) ENGINE=InnoDB;
148
149 #
150 # Table structure for table 'pages'
151 #
152 CREATE TABLE pages (
153 uid int(11) NOT NULL auto_increment,
154 pid int(11) DEFAULT '0' NOT NULL,
155 t3ver_oid int(11) DEFAULT '0' NOT NULL,
156 t3ver_id int(11) DEFAULT '0' NOT NULL,
157 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
158 t3ver_label varchar(255) DEFAULT '' NOT NULL,
159 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
160 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
161 t3ver_count int(11) DEFAULT '0' NOT NULL,
162 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
163 t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
164 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
165 t3_origuid int(11) DEFAULT '0' NOT NULL,
166 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
167 sorting int(11) unsigned DEFAULT '0' NOT NULL,
168 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
169 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
170 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
171 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
172 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
173 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
174 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
175 crdate int(11) unsigned DEFAULT '0' NOT NULL,
176 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
177 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
178 title varchar(255) DEFAULT '' NOT NULL,
179 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
180 TSconfig text,
181 storage_pid int(11) DEFAULT '0' NOT NULL,
182 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
183 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
184 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
185 url varchar(255) DEFAULT '' NOT NULL,
186 starttime int(11) unsigned DEFAULT '0' NOT NULL,
187 endtime int(11) unsigned DEFAULT '0' NOT NULL,
188 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
189 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
190 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
191 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
192 fe_group varchar(100) DEFAULT '0' NOT NULL,
193 subtitle varchar(255) DEFAULT '' NOT NULL,
194 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
195 url_scheme tinyint(3) unsigned DEFAULT '0' NOT NULL,
196 target varchar(80) DEFAULT '' NOT NULL,
197 media text,
198 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
199 keywords text,
200 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
201 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
202 description text,
203 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
204 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
205 abstract text,
206 module varchar(10) DEFAULT '' NOT NULL,
207 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
208 author varchar(255) DEFAULT '' NOT NULL,
209 author_email varchar(80) DEFAULT '' NOT NULL,
210 nav_title varchar(255) DEFAULT '' NOT NULL,
211 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
212 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
213 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
214 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
215 alias varchar(32) DEFAULT '' NOT NULL,
216 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
217 fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
218 be_layout int(10) DEFAULT '0' NOT NULL,
219 be_layout_next_level int(10) DEFAULT '0' NOT NULL,
220 PRIMARY KEY (uid),
221 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
222 KEY parent (pid,sorting,deleted,hidden),
223 KEY alias (alias)
224 );
225
226 #
227 # Table structure for table 'sys_registry'
228 #
229 CREATE TABLE sys_registry (
230 uid int(11) unsigned NOT NULL auto_increment,
231 entry_namespace varchar(128) DEFAULT '' NOT NULL,
232 entry_key varchar(128) DEFAULT '' NOT NULL,
233 entry_value blob,
234 PRIMARY KEY (uid),
235 UNIQUE KEY entry_identifier (entry_namespace,entry_key)
236 );
237
238 #
239 # Table structure for table 'sys_be_shortcuts'
240 #
241 CREATE TABLE sys_be_shortcuts (
242 uid int(11) unsigned NOT NULL auto_increment,
243 userid int(11) unsigned DEFAULT '0' NOT NULL,
244 module_name varchar(255) DEFAULT '' NOT NULL,
245 url text,
246 description varchar(255) DEFAULT '' NOT NULL,
247 sorting int(11) DEFAULT '0' NOT NULL,
248 sc_group tinyint(4) DEFAULT '0' NOT NULL,
249 PRIMARY KEY (uid),
250 KEY event (userid)
251 );
252
253
254 #
255 # Table structure for table 'sys_news'
256 #
257 CREATE TABLE sys_news (
258 uid int(11) unsigned NOT NULL auto_increment,
259 pid int(11) unsigned DEFAULT '0' NOT NULL,
260 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
261 crdate int(11) unsigned DEFAULT '0' NOT NULL,
262 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
263 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
264 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
265 starttime int(11) unsigned DEFAULT '0' NOT NULL,
266 endtime int(11) unsigned DEFAULT '0' NOT NULL,
267 title varchar(255) DEFAULT '' NOT NULL,
268 content mediumtext,
269
270 PRIMARY KEY (uid),
271 KEY parent (pid)
272 );
273
274
275 #
276 # Table structure for table 'sys_preview'
277 #
278 CREATE TABLE sys_preview (
279 keyword varchar(32) DEFAULT '' NOT NULL,
280 tstamp int(11) DEFAULT '0' NOT NULL,
281 endtime int(11) DEFAULT '0' NOT NULL,
282 config text,
283 PRIMARY KEY (keyword)
284 );
285
286
287 #
288 # Table structure for table 'sys_filemounts'
289 #
290 CREATE TABLE sys_filemounts (
291 uid int(11) unsigned NOT NULL auto_increment,
292 pid int(11) unsigned DEFAULT '0' NOT NULL,
293 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
294 title varchar(30) DEFAULT '' NOT NULL,
295 path varchar(120) DEFAULT '' NOT NULL,
296 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
297 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
298 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
299 sorting int(11) unsigned DEFAULT '0' NOT NULL,
300 PRIMARY KEY (uid),
301 KEY parent (pid)
302 );
303
304 #
305 # Table structure for table 'sys_workspace'
306 #
307 CREATE TABLE sys_workspace (
308 uid int(11) NOT NULL auto_increment,
309 pid int(11) DEFAULT '0' NOT NULL,
310 tstamp int(11) DEFAULT '0' NOT NULL,
311 deleted tinyint(1) DEFAULT '0' NOT NULL,
312 title varchar(30) DEFAULT '' NOT NULL,
313 description varchar(255) DEFAULT '' NOT NULL,
314 adminusers text,
315 members text,
316 reviewers text,
317 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
318 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
319 publish_time int(11) DEFAULT '0' NOT NULL,
320 unpublish_time int(11) DEFAULT '0' NOT NULL,
321 freeze tinyint(3) DEFAULT '0' NOT NULL,
322 live_edit tinyint(3) DEFAULT '0' NOT NULL,
323 review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
324 vtypes tinyint(3) DEFAULT '0' NOT NULL,
325 disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
326 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
327 publish_access tinyint(3) DEFAULT '0' NOT NULL,
328 stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
329
330 PRIMARY KEY (uid),
331 KEY parent (pid)
332 );
333
334 #
335 # Table structure for table 'sys_history'
336 #
337 CREATE TABLE sys_history (
338 uid int(11) unsigned NOT NULL auto_increment,
339 sys_log_uid int(11) DEFAULT '0' NOT NULL,
340 history_data mediumtext,
341 fieldlist text,
342 recuid int(11) DEFAULT '0' NOT NULL,
343 tablename varchar(255) DEFAULT '' NOT NULL,
344 tstamp int(11) DEFAULT '0' NOT NULL,
345 history_files mediumtext,
346 snapshot tinyint(4) DEFAULT '0' NOT NULL,
347 PRIMARY KEY (uid),
348 KEY recordident (tablename,recuid,tstamp),
349 KEY sys_log_uid (sys_log_uid)
350 );
351
352 #
353 # Table structure for table 'sys_lockedrecords'
354 #
355 CREATE TABLE sys_lockedrecords (
356 uid int(11) unsigned NOT NULL auto_increment,
357 userid int(11) unsigned DEFAULT '0' NOT NULL,
358 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
359 record_table varchar(255) DEFAULT '' NOT NULL,
360 record_uid int(11) DEFAULT '0' NOT NULL,
361 record_pid int(11) DEFAULT '0' NOT NULL,
362 username varchar(50) DEFAULT '' NOT NULL,
363 feuserid int(11) unsigned DEFAULT '0' NOT NULL,
364 PRIMARY KEY (uid),
365 KEY event (userid,tstamp)
366 );
367
368 #
369 # Table structure for table 'sys_refindex'
370 #
371 CREATE TABLE sys_refindex (
372 hash varchar(32) DEFAULT '' NOT NULL,
373 tablename varchar(255) DEFAULT '' NOT NULL,
374 recuid int(11) DEFAULT '0' NOT NULL,
375 field varchar(40) DEFAULT '' NOT NULL,
376 flexpointer varchar(255) DEFAULT '' NOT NULL,
377 softref_key varchar(30) DEFAULT '' NOT NULL,
378 softref_id varchar(40) DEFAULT '' NOT NULL,
379 sorting int(11) DEFAULT '0' NOT NULL,
380 deleted tinyint(1) DEFAULT '0' NOT NULL,
381 ref_table varchar(255) DEFAULT '' NOT NULL,
382 ref_uid int(11) DEFAULT '0' NOT NULL,
383 ref_string varchar(200) DEFAULT '' NOT NULL,
384
385 PRIMARY KEY (hash),
386 KEY lookup_rec (tablename,recuid),
387 KEY lookup_uid (ref_table,ref_uid),
388 KEY lookup_string (ref_string)
389 );
390
391 #
392 # Table structure for table 'sys_refindex_words'
393 #
394 CREATE TABLE sys_refindex_words (
395 wid int(11) DEFAULT '0' NOT NULL,
396 baseword varchar(60) DEFAULT '' NOT NULL,
397 PRIMARY KEY (wid)
398 );
399
400 #
401 # Table structure for table 'sys_refindex_rel'
402 #
403 CREATE TABLE sys_refindex_rel (
404 rid int(11) DEFAULT '0' NOT NULL,
405 wid int(11) DEFAULT '0' NOT NULL,
406 PRIMARY KEY (rid,wid)
407 );
408
409
410 #
411 # Table structure for table 'sys_refindex_res'
412 #
413 CREATE TABLE sys_refindex_res (
414 rid int(11) DEFAULT '0' NOT NULL,
415 tablename varchar(255) DEFAULT '' NOT NULL,
416 recuid int(11) DEFAULT '0' NOT NULL,
417 PRIMARY KEY (rid)
418 );
419
420 #
421 # Table structure for table 'sys_log'
422 #
423 CREATE TABLE sys_log (
424 uid int(11) unsigned NOT NULL auto_increment,
425 userid int(11) unsigned DEFAULT '0' NOT NULL,
426 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
427 recuid int(11) unsigned DEFAULT '0' NOT NULL,
428 tablename varchar(255) DEFAULT '' NOT NULL,
429 recpid int(11) DEFAULT '0' NOT NULL,
430 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
431 details text NOT NULL,
432 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
433 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
434 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
435 IP varchar(39) DEFAULT '' NOT NULL,
436 log_data varchar(255) DEFAULT '' NOT NULL,
437 event_pid int(11) DEFAULT '-1' NOT NULL,
438 workspace int(11) DEFAULT '0' NOT NULL,
439 NEWid varchar(20) DEFAULT '' NOT NULL,
440 PRIMARY KEY (uid),
441 KEY event (userid,event_pid),
442 KEY recuidIdx (recuid,uid)
443 ) ENGINE=InnoDB;
444
445 #
446 # Table structure for table 'sys_language'
447 #
448 CREATE TABLE sys_language (
449 uid int(11) unsigned NOT NULL auto_increment,
450 pid int(11) unsigned DEFAULT '0' NOT NULL,
451 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
452 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
453 title varchar(80) DEFAULT '' NOT NULL,
454 flag varchar(20) DEFAULT '' NOT NULL,
455 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
456 PRIMARY KEY (uid),
457 KEY parent (pid)
458 );