Added feature #4911: Add an option to add alternative external URL or shortcut for...
[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,
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 doktype tinyint(3) unsigned 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 url varchar(255) DEFAULT '' NOT NULL,
212 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
213 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
214 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
215
216 PRIMARY KEY (uid),
217 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
218 KEY parent (pid,sys_language_uid)
219 );
220
221
222 #
223 # Table structure for table 'static_template'
224 #
225 CREATE TABLE static_template (
226 uid int(11) unsigned NOT NULL auto_increment,
227 pid int(11) unsigned DEFAULT '0' NOT NULL,
228 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
229 crdate int(11) unsigned DEFAULT '0' NOT NULL,
230 title varchar(255) DEFAULT '' NOT NULL,
231 include_static tinytext,
232 constants text,
233 config text,
234 editorcfg text,
235 description text,
236 PRIMARY KEY (uid),
237 KEY parent (pid)
238 );
239
240
241 #
242 # Table structure for table 'sys_domain'
243 #
244 CREATE TABLE sys_domain (
245 uid int(11) unsigned NOT NULL auto_increment,
246 pid int(11) unsigned DEFAULT '0' NOT NULL,
247 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
248 crdate int(11) unsigned DEFAULT '0' NOT NULL,
249 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
250 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
251 domainName varchar(80) DEFAULT '' NOT NULL,
252 redirectTo varchar(120) DEFAULT '' NOT NULL,
253 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
254 sorting int(10) unsigned DEFAULT '0' NOT NULL,
255 prepend_params int(10) DEFAULT '0' NOT NULL,
256
257 PRIMARY KEY (uid),
258 KEY parent (pid)
259 );
260
261
262
263 #
264 # Table structure for table 'sys_template'
265 #
266 CREATE TABLE sys_template (
267 uid int(11) NOT NULL auto_increment,
268 pid int(11) DEFAULT '0' NOT NULL,
269 t3ver_oid int(11) DEFAULT '0' NOT NULL,
270 t3ver_id int(11) DEFAULT '0' NOT NULL,
271 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
272 t3ver_label varchar(30) DEFAULT '' NOT NULL,
273 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
274 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
275 t3ver_count int(11) DEFAULT '0' NOT NULL,
276 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
277 t3_origuid int(11) DEFAULT '0' NOT NULL,
278 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
279 sorting int(11) unsigned DEFAULT '0' NOT NULL,
280 crdate int(11) unsigned DEFAULT '0' NOT NULL,
281 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
282 title varchar(255) DEFAULT '' NOT NULL,
283 sitetitle varchar(255) DEFAULT '' NOT NULL,
284 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
285 starttime int(11) unsigned DEFAULT '0' NOT NULL,
286 endtime int(11) unsigned DEFAULT '0' NOT NULL,
287 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
288 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
289 include_static tinytext,
290 include_static_file text,
291 constants text,
292 config text,
293 editorcfg text,
294 resources text,
295 nextLevel varchar(5) DEFAULT '' NOT NULL,
296 description text,
297 basedOn tinytext,
298 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
299 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
300 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
301 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
302 PRIMARY KEY (uid),
303 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
304 KEY parent (pid,sorting,deleted,hidden)
305 );
306
307
308 #
309 # Table structure for table 'tt_content'
310 #
311 CREATE TABLE tt_content (
312 uid int(11) NOT NULL auto_increment,
313 pid int(11) DEFAULT '0' NOT NULL,
314 t3ver_oid int(11) DEFAULT '0' NOT NULL,
315 t3ver_id int(11) DEFAULT '0' NOT NULL,
316 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
317 t3ver_label varchar(30) DEFAULT '' NOT NULL,
318 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
319 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
320 t3ver_count int(11) DEFAULT '0' NOT NULL,
321 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
322 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
323 t3_origuid int(11) DEFAULT '0' NOT NULL,
324 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
325 crdate int(11) unsigned DEFAULT '0' NOT NULL,
326 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
327 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
328 sorting int(11) unsigned DEFAULT '0' NOT NULL,
329 CType varchar(30) DEFAULT '' NOT NULL,
330 header varchar(255) DEFAULT '' NOT NULL,
331 header_position varchar(6) DEFAULT '' NOT NULL,
332 bodytext mediumtext,
333 image text,
334 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
335 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
336 imagecaption text,
337 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
338 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
339 media text,
340 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
341 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
342 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
343 records text,
344 pages tinytext,
345 starttime int(11) unsigned DEFAULT '0' NOT NULL,
346 endtime int(11) unsigned DEFAULT '0' NOT NULL,
347 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
348 subheader varchar(255) DEFAULT '' NOT NULL,
349 spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
350 spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
351 fe_group varchar(100) DEFAULT '0' NOT NULL,
352 header_link varchar(255) DEFAULT '' NOT NULL,
353 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
354 image_link varchar(255) DEFAULT '' NOT NULL,
355 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
356 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
357 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
358 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
359 altText text,
360 titleText text,
361 longdescURL text,
362 header_layout varchar(30) DEFAULT '0' NOT NULL,
363 text_align varchar(6) DEFAULT '' NOT NULL,
364 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
365 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
366 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
367 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
368 menu_type varchar(30) DEFAULT '0' NOT NULL,
369 list_type varchar(36) DEFAULT '0' NOT NULL,
370 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
371 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
372 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
373 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
374 select_key varchar(80) DEFAULT '' NOT NULL,
375 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
376 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
377 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
378 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
379 date int(10) unsigned DEFAULT '0' NOT NULL,
380 splash_layout varchar(30) DEFAULT '0' NOT NULL,
381 multimedia tinytext,
382 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
383 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
384 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
385 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
386 sys_language_uid int(11) DEFAULT '0' NOT NULL,
387 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
388 pi_flexform mediumtext,
389 l18n_parent int(11) DEFAULT '0' NOT NULL,
390 l18n_diffsource mediumblob,
391
392 PRIMARY KEY (uid),
393 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
394 KEY parent (pid,sorting)
395 );
396
397
398 #
399 # Table structure for table 'pages'
400 #
401 CREATE TABLE pages (
402 url varchar(255) DEFAULT '' NOT NULL,
403 starttime int(11) unsigned DEFAULT '0' NOT NULL,
404 endtime int(11) unsigned DEFAULT '0' NOT NULL,
405 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
406 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
407 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
408 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
409 fe_group varchar(100) DEFAULT '0' NOT NULL,
410 subtitle varchar(255) DEFAULT '' NOT NULL,
411 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
412 target varchar(20) DEFAULT '' NOT NULL,
413 media text,
414 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
415 keywords text,
416 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
417 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
418 description text,
419 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
420 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
421 abstract text,
422 module varchar(10) DEFAULT '' NOT NULL,
423 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
424 author varchar(255) DEFAULT '' NOT NULL,
425 author_email varchar(80) DEFAULT '' NOT NULL,
426 nav_title varchar(255) DEFAULT '' NOT NULL,
427 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
428 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
429 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
430 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
431 alias varchar(32) DEFAULT '' NOT NULL,
432 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
433 fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
434 KEY alias (alias)
435 );