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