2cff2068003396f83a7d182a9a2043f9f8c1e423
[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 identifier varchar(32) DEFAULT '' NOT NULL,
12 crdate int(11) unsigned DEFAULT '0' NOT NULL,
13 content mediumtext,
14 tags mediumtext,
15 lifetime int(11) unsigned DEFAULT '0' NOT NULL,
16 PRIMARY KEY (id),
17 KEY cache_id (identifier)
18 ) ENGINE=InnoDB;
19
20
21 #
22 # Table structure for table 'cache_pagesection'
23 #
24 CREATE TABLE cache_pagesection (
25 id int(11) unsigned NOT NULL auto_increment,
26 identifier varchar(32) DEFAULT '' NOT NULL,
27 crdate int(11) unsigned DEFAULT '0' NOT NULL,
28 content mediumtext,
29 tags mediumtext,
30 lifetime int(11) unsigned DEFAULT '0' NOT NULL,
31 PRIMARY KEY (id),
32 KEY cache_id (identifier)
33 ) ENGINE=InnoDB;
34
35
36 #
37 # Table structure for table 'cache_typo3temp_log'
38 #
39 CREATE TABLE cache_typo3temp_log (
40 md5hash varchar(32) DEFAULT '' NOT NULL,
41 tstamp int(11) DEFAULT '0' NOT NULL,
42 filename varchar(255) DEFAULT '' NOT NULL,
43 orig_filename varchar(255) DEFAULT '' NOT NULL,
44 PRIMARY KEY (md5hash)
45 ) ENGINE=InnoDB;
46
47
48 #
49 # Table structure for table 'cache_md5params'
50 #
51 CREATE TABLE cache_md5params (
52 md5hash varchar(20) DEFAULT '' NOT NULL,
53 tstamp int(11) DEFAULT '0' NOT NULL,
54 type tinyint(3) DEFAULT '0' NOT NULL,
55 params text,
56 PRIMARY KEY (md5hash)
57 ) ENGINE=InnoDB;
58
59
60 #
61 # Table structure for table 'cache_imagesizes'
62 #
63 CREATE TABLE cache_imagesizes (
64 md5hash varchar(32) DEFAULT '' NOT NULL,
65 md5filename varchar(32) DEFAULT '' NOT NULL,
66 tstamp int(11) DEFAULT '0' NOT NULL,
67 filename varchar(255) DEFAULT '' NOT NULL,
68 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
69 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
70 PRIMARY KEY (md5filename)
71 ) ENGINE=InnoDB;
72
73
74 #
75 # Table structure for table 'cache_treelist'
76 #
77 CREATE TABLE cache_treelist (
78 md5hash char(32) DEFAULT '' NOT NULL,
79 pid int(11) DEFAULT '0' NOT NULL,
80 treelist text NOT NULL,
81 tstamp int(11) DEFAULT '0' NOT NULL,
82 expires int(11) unsigned DEFAULT '0' NOT NULL,
83 PRIMARY KEY (md5hash)
84 ) ENGINE=InnoDB;
85
86
87 #
88 # Table structure for table 'fe_groups'
89 #
90 CREATE TABLE fe_groups (
91 uid int(11) unsigned NOT NULL auto_increment,
92 pid int(11) unsigned DEFAULT '0' NOT NULL,
93 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
94 crdate int(11) unsigned DEFAULT '0' NOT NULL,
95 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
96 title varchar(50) DEFAULT '' NOT NULL,
97 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
98 lockToDomain varchar(50) DEFAULT '' NOT NULL,
99 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
100 description text,
101 subgroup tinytext,
102 TSconfig text,
103 PRIMARY KEY (uid),
104 KEY parent (pid)
105 );
106
107
108 #
109 # Table structure for table 'fe_session_data'
110 #
111 CREATE TABLE fe_session_data (
112 hash varchar(32) DEFAULT '' NOT NULL,
113 content mediumblob,
114 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
115 PRIMARY KEY (hash)
116 ) ENGINE=InnoDB;
117
118
119 #
120 # Table structure for table 'fe_sessions'
121 #
122 CREATE TABLE fe_sessions (
123 ses_id varchar(32) DEFAULT '' NOT NULL,
124 ses_name varchar(32) DEFAULT '' NOT NULL,
125 ses_iplock varchar(39) DEFAULT '' NOT NULL,
126 ses_hashlock int(11) DEFAULT '0' NOT NULL,
127 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
128 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
129 ses_data blob,
130 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
131 PRIMARY KEY (ses_id,ses_name)
132 ) ENGINE=InnoDB;
133
134
135 #
136 # Table structure for table 'fe_users'
137 #
138 CREATE TABLE fe_users (
139 uid int(11) unsigned NOT NULL auto_increment,
140 pid int(11) unsigned DEFAULT '0' NOT NULL,
141 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
142 username varchar(50) DEFAULT '' NOT NULL,
143 password varchar(40) DEFAULT '' NOT NULL,
144 usergroup tinytext,
145 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
146 starttime int(11) unsigned DEFAULT '0' NOT NULL,
147 endtime int(11) unsigned DEFAULT '0' NOT NULL,
148 name varchar(80) DEFAULT '' NOT NULL,
149 address varchar(255) DEFAULT '' NOT NULL,
150 telephone varchar(20) DEFAULT '' NOT NULL,
151 fax varchar(20) DEFAULT '' NOT NULL,
152 email varchar(80) DEFAULT '' NOT NULL,
153 crdate int(11) unsigned DEFAULT '0' NOT NULL,
154 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
155 lockToDomain varchar(50) DEFAULT '' NOT NULL,
156 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
157 uc blob,
158 title varchar(40) DEFAULT '' NOT NULL,
159 zip varchar(10) DEFAULT '' NOT NULL,
160 city varchar(50) DEFAULT '' NOT NULL,
161 country varchar(40) DEFAULT '' NOT NULL,
162 www varchar(80) DEFAULT '' NOT NULL,
163 company varchar(80) DEFAULT '' NOT NULL,
164 image tinytext,
165 TSconfig text,
166 fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
167 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
168 is_online int(10) unsigned DEFAULT '0' NOT NULL,
169 PRIMARY KEY (uid),
170 KEY parent (pid,username),
171 KEY username (username),
172 KEY is_online (is_online)
173 );
174
175
176 #
177 # Table structure for table 'pages_language_overlay'
178 #
179 CREATE TABLE pages_language_overlay (
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(30) 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 t3_origuid int(11) DEFAULT '0' NOT NULL,
191 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
192 crdate int(11) unsigned DEFAULT '0' NOT NULL,
193 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
194 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
195 title varchar(255) DEFAULT '' NOT NULL,
196 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
197 starttime int(11) unsigned DEFAULT '0' NOT NULL,
198 endtime int(11) unsigned DEFAULT '0' NOT NULL,
199 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
200 subtitle varchar(255) DEFAULT '' NOT NULL,
201 nav_title varchar(255) DEFAULT '' NOT NULL,
202 media tinytext,
203 keywords text,
204 description text,
205 abstract text,
206 author varchar(255) DEFAULT '' NOT NULL,
207 author_email varchar(80) DEFAULT '' NOT NULL,
208 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
209 l18n_diffsource mediumblob,
210
211 PRIMARY KEY (uid),
212 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
213 KEY parent (pid,sys_language_uid)
214 );
215
216
217 #
218 # Table structure for table 'static_template'
219 #
220 CREATE TABLE static_template (
221 uid int(11) unsigned NOT NULL auto_increment,
222 pid int(11) unsigned DEFAULT '0' NOT NULL,
223 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
224 crdate int(11) unsigned DEFAULT '0' NOT NULL,
225 title varchar(255) DEFAULT '' NOT NULL,
226 include_static tinytext,
227 constants text,
228 config text,
229 editorcfg text,
230 description text,
231 PRIMARY KEY (uid),
232 KEY parent (pid)
233 );
234
235
236 #
237 # Table structure for table 'sys_domain'
238 #
239 CREATE TABLE sys_domain (
240 uid int(11) unsigned NOT NULL auto_increment,
241 pid int(11) unsigned DEFAULT '0' NOT NULL,
242 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
243 crdate int(11) unsigned DEFAULT '0' NOT NULL,
244 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
245 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
246 domainName varchar(80) DEFAULT '' NOT NULL,
247 redirectTo varchar(120) DEFAULT '' NOT NULL,
248 redirectHttpStatusCode int(4) unsigned DEFAULT '301' 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 );