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