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