6db219e42e40a311bd6cdc02fbef9a6cf3fbaa71
[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,
52 subgroup tinytext,
53 TSconfig text,
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(50) 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(80) 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 );
240
241 #
242 # Table structure for table 'tt_content'
243 #
244 CREATE TABLE tt_content (
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(255) DEFAULT '' NOT NULL,
251 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
252 t3ver_stage int(11) DEFAULT '0' NOT NULL,
253 t3ver_count int(11) DEFAULT '0' NOT NULL,
254 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
255 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
256 t3_origuid int(11) DEFAULT '0' NOT NULL,
257 tstamp 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 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
261 sorting int(11) unsigned DEFAULT '0' NOT NULL,
262 CType varchar(255) DEFAULT '' NOT NULL,
263 header varchar(255) DEFAULT '' NOT NULL,
264 header_position varchar(6) DEFAULT '' NOT NULL,
265 bodytext mediumtext,
266
267 # Even though we're using FAL and an IRRE field for images
268 # now, it needs to stay "text" for the migration to work
269 image text,
270
271 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
272 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
273 imagecaption text,
274 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
275 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
276 media text,
277 layout int(11) unsigned DEFAULT '0' NOT NULL,
278 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
279 cols int(11) unsigned DEFAULT '0' NOT NULL,
280 records text,
281 pages tinytext,
282 starttime int(11) unsigned DEFAULT '0' NOT NULL,
283 endtime int(11) unsigned DEFAULT '0' NOT NULL,
284 colPos int(11) unsigned DEFAULT '0' NOT NULL,
285 subheader varchar(255) DEFAULT '' NOT NULL,
286 spaceBefore smallint(5) unsigned DEFAULT '0' NOT NULL,
287 spaceAfter smallint(5) unsigned DEFAULT '0' NOT NULL,
288 fe_group varchar(100) DEFAULT '0' NOT NULL,
289 header_link varchar(255) DEFAULT '' NOT NULL,
290 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
291 image_link text,
292 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
293 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
294 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
295 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
296 altText text,
297 titleText text,
298 longdescURL text,
299 header_layout varchar(30) DEFAULT '0' NOT NULL,
300 menu_type varchar(30) DEFAULT '0' NOT NULL,
301 list_type varchar(255) DEFAULT '0' NOT NULL,
302 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
303 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
304 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
305 table_bgColor int(11) unsigned DEFAULT '0' NOT NULL,
306 select_key varchar(80) DEFAULT '' NOT NULL,
307 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
308 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
309 file_collections text,
310 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
311 filelink_sorting tinytext NOT NULL,
312 target varchar(30) DEFAULT '' NOT NULL,
313 section_frame int(11) unsigned DEFAULT '0' NOT NULL,
314 date int(10) unsigned DEFAULT '0' NOT NULL,
315 multimedia tinytext,
316 image_frames int(11) unsigned DEFAULT '0' NOT NULL,
317 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
318 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
319 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
320 sys_language_uid int(11) DEFAULT '0' NOT NULL,
321 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
322 pi_flexform mediumtext,
323 accessibility_title varchar(30) DEFAULT '' NOT NULL,
324 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
325 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
326 l18n_parent int(11) DEFAULT '0' NOT NULL,
327 l18n_diffsource mediumblob,
328 selected_categories text,
329 category_field varchar(64) DEFAULT '' NOT NULL,
330
331 PRIMARY KEY (uid),
332 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
333 KEY parent (pid,sorting),
334 KEY language (l18n_parent,sys_language_uid)
335 );
336
337 #
338 # Table structure for table 'backend_layout'
339 #
340 CREATE TABLE backend_layout (
341 uid int(11) NOT NULL auto_increment,
342 pid int(11) DEFAULT '0' NOT NULL,
343 t3ver_oid int(11) DEFAULT '0' NOT NULL,
344 t3ver_id int(11) DEFAULT '0' NOT NULL,
345 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
346 t3ver_label varchar(255) DEFAULT '' NOT NULL,
347 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
348 t3ver_stage int(11) DEFAULT '0' NOT NULL,
349 t3ver_count int(11) DEFAULT '0' NOT NULL,
350 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
351 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
352 t3_origuid int(11) DEFAULT '0' NOT NULL,
353 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
354 crdate int(11) unsigned DEFAULT '0' NOT NULL,
355 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
356 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
357 deleted tinyint(4) DEFAULT '0' NOT NULL,
358 sorting int(11) unsigned DEFAULT '0' NOT NULL,
359 title varchar(255) DEFAULT '' NOT NULL,
360 description text NOT NULL,
361 config text NOT NULL,
362 icon text NOT NULL,
363
364 PRIMARY KEY (uid),
365 KEY parent (pid),
366 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
367 );