[BUGFIX] Remove duplicate database indices
[Packages/TYPO3.CMS.git] / typo3 / sysext / frontend / ext_tables.sql
1 #
2 # Table structure for table 'cache_md5params'
3 #
4 CREATE TABLE cache_md5params (
5 md5hash varchar(20) DEFAULT '' NOT NULL,
6 tstamp int(11) DEFAULT '0' NOT NULL,
7 type tinyint(3) DEFAULT '0' NOT NULL,
8 params text,
9
10 PRIMARY KEY (md5hash)
11 ) ENGINE=InnoDB;
12
13 #
14 # Table structure for table 'cache_treelist'
15 #
16 CREATE TABLE cache_treelist (
17 md5hash char(32) DEFAULT '' NOT NULL,
18 pid int(11) DEFAULT '0' NOT NULL,
19 treelist mediumtext,
20 tstamp int(11) DEFAULT '0' NOT NULL,
21 expires int(11) unsigned DEFAULT '0' NOT NULL,
22
23 PRIMARY KEY (md5hash)
24 ) ENGINE=InnoDB;
25
26 #
27 # Table structure for table 'fe_groups'
28 #
29 CREATE TABLE fe_groups (
30 uid int(11) unsigned NOT NULL auto_increment,
31 pid int(11) unsigned DEFAULT '0' NOT NULL,
32 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
33 crdate int(11) unsigned DEFAULT '0' NOT NULL,
34 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
35 title varchar(50) DEFAULT '' NOT NULL,
36 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
37 lockToDomain varchar(50) DEFAULT '' NOT NULL,
38 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
39 description text,
40 subgroup tinytext,
41 TSconfig text,
42
43 PRIMARY KEY (uid),
44 KEY parent (pid)
45 );
46
47
48 #
49 # Table structure for table 'fe_sessions'
50 #
51 CREATE TABLE fe_sessions (
52 ses_id varchar(32) DEFAULT '' NOT NULL,
53 ses_iplock varchar(39) DEFAULT '' NOT NULL,
54 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
55 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
56 ses_data mediumblob,
57 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
58 ses_anonymous tinyint(1) unsigned DEFAULT '0' NOT NULL,
59
60 PRIMARY KEY (ses_id),
61 KEY ses_tstamp (ses_tstamp)
62 ) ENGINE=InnoDB;
63
64 #
65 # Table structure for table 'fe_users'
66 #
67 CREATE TABLE fe_users (
68 uid int(11) unsigned NOT NULL auto_increment,
69 pid int(11) unsigned DEFAULT '0' NOT NULL,
70 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
71 username varchar(255) DEFAULT '' NOT NULL,
72 password varchar(100) DEFAULT '' NOT NULL,
73 usergroup tinytext,
74 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
75 starttime int(11) unsigned DEFAULT '0' NOT NULL,
76 endtime int(11) unsigned DEFAULT '0' NOT NULL,
77 name varchar(160) DEFAULT '' NOT NULL,
78 first_name varchar(50) DEFAULT '' NOT NULL,
79 middle_name varchar(50) DEFAULT '' NOT NULL,
80 last_name varchar(50) DEFAULT '' NOT NULL,
81 address varchar(255) DEFAULT '' NOT NULL,
82 telephone varchar(30) DEFAULT '' NOT NULL,
83 fax varchar(30) DEFAULT '' NOT NULL,
84 email varchar(255) DEFAULT '' NOT NULL,
85 crdate int(11) unsigned DEFAULT '0' NOT NULL,
86 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
87 lockToDomain varchar(50) DEFAULT '' NOT NULL,
88 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
89 description text,
90 uc blob,
91 title varchar(40) DEFAULT '' NOT NULL,
92 zip varchar(10) DEFAULT '' NOT NULL,
93 city varchar(50) DEFAULT '' NOT NULL,
94 country varchar(40) DEFAULT '' NOT NULL,
95 www varchar(80) DEFAULT '' NOT NULL,
96 company varchar(80) DEFAULT '' NOT NULL,
97 image tinytext,
98 TSconfig text,
99 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
100 is_online int(10) unsigned DEFAULT '0' NOT NULL,
101
102 PRIMARY KEY (uid),
103 KEY parent (pid,username),
104 KEY username (username),
105 KEY is_online (is_online)
106 );
107
108 #
109 # Table structure for table 'pages_language_overlay'
110 #
111 CREATE TABLE pages_language_overlay (
112 uid int(11) NOT NULL auto_increment,
113 pid int(11) DEFAULT '0' NOT NULL,
114 doktype int(11) unsigned DEFAULT '0' NOT NULL,
115 t3ver_oid int(11) DEFAULT '0' NOT NULL,
116 t3ver_id int(11) DEFAULT '0' NOT NULL,
117 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
118 t3ver_label varchar(255) DEFAULT '' NOT NULL,
119 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
120 t3ver_stage int(11) DEFAULT '0' NOT NULL,
121 t3ver_count int(11) DEFAULT '0' NOT NULL,
122 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
123 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
124 t3_origuid int(11) DEFAULT '0' NOT NULL,
125 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
126 crdate int(11) unsigned DEFAULT '0' NOT NULL,
127 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
128 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
129 title varchar(255) DEFAULT '' NOT NULL,
130 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
131 starttime int(11) unsigned DEFAULT '0' NOT NULL,
132 endtime int(11) unsigned DEFAULT '0' NOT NULL,
133 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
134 subtitle varchar(255) DEFAULT '' NOT NULL,
135 nav_title varchar(255) DEFAULT '' NOT NULL,
136 media int(11) unsigned DEFAULT '0' NOT NULL,
137 keywords text,
138 description text,
139 abstract text,
140 author varchar(255) DEFAULT '' NOT NULL,
141 author_email varchar(80) DEFAULT '' NOT NULL,
142 l18n_diffsource mediumblob,
143 url varchar(255) DEFAULT '' NOT NULL,
144 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
145 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
146 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
147
148 PRIMARY KEY (uid),
149 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
150 KEY parent (pid,sys_language_uid)
151 );
152
153 #
154 # Table structure for table 'sys_domain'
155 #
156 CREATE TABLE sys_domain (
157 uid int(11) unsigned NOT NULL auto_increment,
158 pid int(11) unsigned DEFAULT '0' NOT NULL,
159 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
160 crdate int(11) unsigned DEFAULT '0' NOT NULL,
161 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
162 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
163 domainName varchar(255) DEFAULT '' NOT NULL,
164 redirectTo varchar(255) DEFAULT '' NOT NULL,
165 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
166 sorting int(10) unsigned DEFAULT '0' NOT NULL,
167 prepend_params int(10) DEFAULT '0' NOT NULL,
168 forced tinyint(3) unsigned DEFAULT '0' NOT NULL,
169
170 PRIMARY KEY (uid),
171 KEY getSysDomain (redirectTo,hidden),
172 KEY getDomainStartPage (pid,hidden,domainName)
173 );
174
175 #
176 # Table structure for table 'sys_template'
177 #
178 CREATE TABLE sys_template (
179 uid int(11) NOT NULL auto_increment,
180 pid int(11) DEFAULT '0' NOT NULL,
181 t3ver_oid int(11) DEFAULT '0' NOT NULL,
182 t3ver_id int(11) DEFAULT '0' NOT NULL,
183 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
184 t3ver_label varchar(255) DEFAULT '' NOT NULL,
185 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
186 t3ver_stage int(11) DEFAULT '0' NOT NULL,
187 t3ver_count int(11) DEFAULT '0' NOT NULL,
188 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
189 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
190 t3_origuid int(11) DEFAULT '0' NOT NULL,
191 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
192 sorting int(11) unsigned DEFAULT '0' NOT NULL,
193 crdate int(11) unsigned DEFAULT '0' NOT NULL,
194 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
195 title varchar(255) DEFAULT '' NOT NULL,
196 sitetitle varchar(255) DEFAULT '' NOT NULL,
197 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
198 starttime int(11) unsigned DEFAULT '0' NOT NULL,
199 endtime int(11) unsigned DEFAULT '0' NOT NULL,
200 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
201 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
202 include_static_file text,
203 constants text,
204 config text,
205 nextLevel varchar(5) DEFAULT '' NOT NULL,
206 description text,
207 basedOn tinytext,
208 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
209 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
210 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
211
212 PRIMARY KEY (uid),
213 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
214 KEY parent (pid,deleted,hidden,sorting),
215 KEY roottemplate (deleted,hidden,root)
216 );
217
218 #
219 # Table structure for table 'tt_content'
220 #
221 CREATE TABLE tt_content (
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 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
233 t3_origuid int(11) DEFAULT '0' NOT NULL,
234 tstamp 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 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
238 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
239 sorting int(11) unsigned DEFAULT '0' NOT NULL,
240 CType varchar(255) DEFAULT '' NOT NULL,
241 header varchar(255) DEFAULT '' NOT NULL,
242 header_position varchar(6) DEFAULT '' NOT NULL,
243 rowDescription text,
244 bodytext mediumtext,
245 bullets_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
246 uploads_description tinyint(1) unsigned DEFAULT '0' NOT NULL,
247 uploads_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
248 assets int(11) unsigned DEFAULT '0' NOT NULL,
249 image int(11) unsigned DEFAULT '0' NOT NULL,
250 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
251 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
252 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
253 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
254 media int(11) unsigned DEFAULT '0' NOT NULL,
255 layout int(11) unsigned DEFAULT '0' NOT NULL,
256 frame_class varchar(60) DEFAULT 'default' NOT NULL,
257 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
258 cols int(11) unsigned DEFAULT '0' NOT NULL,
259 spaceBefore smallint(5) unsigned DEFAULT '0' NOT NULL,
260 spaceAfter smallint(5) unsigned DEFAULT '0' NOT NULL,
261 space_before_class varchar(60) DEFAULT '' NOT NULL,
262 space_after_class varchar(60) DEFAULT '' NOT NULL,
263 records text,
264 pages text,
265 starttime int(11) unsigned DEFAULT '0' NOT NULL,
266 endtime int(11) unsigned DEFAULT '0' NOT NULL,
267 colPos int(11) unsigned DEFAULT '0' NOT NULL,
268 subheader varchar(255) DEFAULT '' NOT NULL,
269 fe_group varchar(100) DEFAULT '0' NOT NULL,
270 header_link varchar(1024) DEFAULT '' NOT NULL,
271 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
272 header_layout varchar(30) DEFAULT '0' NOT NULL,
273 list_type varchar(255) DEFAULT '' NOT NULL,
274 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
275 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
276 file_collections text,
277 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
278 filelink_sorting varchar(10) DEFAULT '' NOT NULL,
279 target varchar(30) DEFAULT '' NOT NULL,
280 date int(10) unsigned DEFAULT '0' NOT NULL,
281 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
282 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
283 sys_language_uid int(11) DEFAULT '0' NOT NULL,
284 pi_flexform mediumtext,
285 accessibility_title varchar(30) DEFAULT '' NOT NULL,
286 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
287 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
288 l18n_parent int(11) DEFAULT '0' NOT NULL,
289 l18n_diffsource mediumblob,
290 l10n_source int(11) DEFAULT '0' NOT NULL,
291 selected_categories text,
292 category_field varchar(64) DEFAULT '' NOT NULL,
293 table_class varchar(60) DEFAULT '' NOT NULL,
294 table_caption varchar(255) DEFAULT NULL,
295 table_delimiter smallint(6) unsigned DEFAULT '0' NOT NULL,
296 table_enclosure smallint(6) unsigned DEFAULT '0' NOT NULL,
297 table_header_position tinyint(3) unsigned DEFAULT '0' NOT NULL,
298 table_tfoot tinyint(1) unsigned DEFAULT '0' NOT NULL,
299
300 PRIMARY KEY (uid),
301 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
302 KEY parent (pid,sorting),
303 KEY language (l18n_parent,sys_language_uid)
304 );
305
306 #
307 # Table structure for table 'backend_layout'
308 #
309 CREATE TABLE backend_layout (
310 uid int(11) NOT NULL auto_increment,
311 pid int(11) DEFAULT '0' NOT NULL,
312 t3ver_oid int(11) DEFAULT '0' NOT NULL,
313 t3ver_id int(11) DEFAULT '0' NOT NULL,
314 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
315 t3ver_label varchar(255) DEFAULT '' NOT NULL,
316 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
317 t3ver_stage int(11) DEFAULT '0' NOT NULL,
318 t3ver_count int(11) DEFAULT '0' NOT NULL,
319 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
320 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
321 t3_origuid int(11) DEFAULT '0' NOT NULL,
322 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
323 crdate int(11) unsigned DEFAULT '0' NOT NULL,
324 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
325 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
326 deleted tinyint(4) DEFAULT '0' NOT NULL,
327 sorting int(11) unsigned DEFAULT '0' NOT NULL,
328 title varchar(255) DEFAULT '' NOT NULL,
329 description text,
330 config text NOT NULL,
331 icon text NOT NULL,
332
333 PRIMARY KEY (uid),
334 KEY parent (pid),
335 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
336 );