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