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