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