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