[FEATURE] Add categories-based menu
[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 );
197
198 #
199 # Table structure for table 'sys_template'
200 #
201 CREATE TABLE sys_template (
202 uid int(11) NOT NULL auto_increment,
203 pid int(11) DEFAULT '0' NOT NULL,
204 t3ver_oid int(11) DEFAULT '0' NOT NULL,
205 t3ver_id int(11) DEFAULT '0' NOT NULL,
206 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
207 t3ver_label varchar(255) DEFAULT '' NOT NULL,
208 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
209 t3ver_stage int(11) DEFAULT '0' NOT NULL,
210 t3ver_count int(11) DEFAULT '0' NOT NULL,
211 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
212 t3_origuid int(11) DEFAULT '0' NOT NULL,
213 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
214 sorting int(11) unsigned DEFAULT '0' NOT NULL,
215 crdate int(11) unsigned DEFAULT '0' NOT NULL,
216 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
217 title varchar(255) DEFAULT '' NOT NULL,
218 sitetitle varchar(255) DEFAULT '' NOT NULL,
219 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
220 starttime int(11) unsigned DEFAULT '0' NOT NULL,
221 endtime int(11) unsigned DEFAULT '0' NOT NULL,
222 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
223 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
224 include_static_file text,
225 constants text,
226 config text,
227 nextLevel varchar(5) DEFAULT '' NOT NULL,
228 description text,
229 basedOn tinytext,
230 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
231 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
232 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
233 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
234
235 PRIMARY KEY (uid),
236 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
237 KEY parent (pid,deleted,hidden,sorting)
238 );
239
240 #
241 # Table structure for table 'tt_content'
242 #
243 CREATE TABLE tt_content (
244 uid int(11) NOT NULL auto_increment,
245 pid int(11) DEFAULT '0' NOT NULL,
246 t3ver_oid int(11) DEFAULT '0' NOT NULL,
247 t3ver_id int(11) DEFAULT '0' NOT NULL,
248 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
249 t3ver_label varchar(255) DEFAULT '' NOT NULL,
250 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
251 t3ver_stage int(11) DEFAULT '0' NOT NULL,
252 t3ver_count int(11) DEFAULT '0' NOT NULL,
253 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
254 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
255 t3_origuid int(11) DEFAULT '0' NOT NULL,
256 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
257 crdate int(11) unsigned DEFAULT '0' NOT NULL,
258 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
259 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
260 sorting int(11) unsigned DEFAULT '0' NOT NULL,
261 CType varchar(255) DEFAULT '' NOT NULL,
262 header varchar(255) DEFAULT '' NOT NULL,
263 header_position varchar(6) DEFAULT '' NOT NULL,
264 bodytext mediumtext,
265
266 # Even though we're using FAL and an IRRE field for images
267 # now, it needs to stay "text" for the migration to work
268 image text,
269
270 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
271 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
272 imagecaption text,
273 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
274 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
275 media text,
276 layout int(11) unsigned DEFAULT '0' NOT NULL,
277 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
278 cols int(11) unsigned DEFAULT '0' NOT NULL,
279 records text,
280 pages tinytext,
281 starttime int(11) unsigned DEFAULT '0' NOT NULL,
282 endtime int(11) unsigned DEFAULT '0' NOT NULL,
283 colPos int(11) unsigned DEFAULT '0' NOT NULL,
284 subheader varchar(255) DEFAULT '' NOT NULL,
285 spaceBefore smallint(5) unsigned DEFAULT '0' NOT NULL,
286 spaceAfter smallint(5) unsigned DEFAULT '0' NOT NULL,
287 fe_group varchar(100) DEFAULT '0' NOT NULL,
288 header_link varchar(255) DEFAULT '' NOT NULL,
289 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
290 image_link text,
291 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
292 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
293 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
294 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
295 altText text,
296 titleText text,
297 longdescURL text,
298 header_layout varchar(30) DEFAULT '0' NOT NULL,
299 text_align varchar(6) DEFAULT '' NOT NULL,
300 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
301 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
302 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
303 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
304 menu_type varchar(30) DEFAULT '0' NOT NULL,
305 list_type varchar(255) DEFAULT '0' NOT NULL,
306 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
307 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
308 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
309 table_bgColor int(11) unsigned DEFAULT '0' NOT NULL,
310 select_key varchar(80) DEFAULT '' NOT NULL,
311 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
312 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
313 file_collections text,
314 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
315 filelink_sorting tinytext NOT NULL,
316 target varchar(30) DEFAULT '' NOT NULL,
317 section_frame int(11) unsigned DEFAULT '0' NOT NULL,
318 date int(10) unsigned DEFAULT '0' NOT NULL,
319 multimedia tinytext,
320 image_frames int(11) unsigned DEFAULT '0' NOT NULL,
321 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
322 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
323 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
324 sys_language_uid int(11) DEFAULT '0' NOT NULL,
325 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
326 pi_flexform mediumtext,
327 accessibility_title varchar(30) DEFAULT '' NOT NULL,
328 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
329 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
330 l18n_parent int(11) DEFAULT '0' NOT NULL,
331 l18n_diffsource mediumblob,
332 selected_categories text,
333
334 PRIMARY KEY (uid),
335 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
336 KEY parent (pid,sorting),
337 KEY language (l18n_parent,sys_language_uid)
338 );
339
340 #
341 # Table structure for table 'backend_layout'
342 #
343 CREATE TABLE backend_layout (
344 uid int(11) NOT NULL auto_increment,
345 pid int(11) DEFAULT '0' NOT NULL,
346 t3ver_oid int(11) DEFAULT '0' NOT NULL,
347 t3ver_id int(11) DEFAULT '0' NOT NULL,
348 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
349 t3ver_label varchar(255) DEFAULT '' NOT NULL,
350 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
351 t3ver_stage int(11) DEFAULT '0' NOT NULL,
352 t3ver_count int(11) DEFAULT '0' NOT NULL,
353 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
354 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
355 t3_origuid int(11) DEFAULT '0' NOT NULL,
356 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
357 crdate int(11) unsigned DEFAULT '0' NOT NULL,
358 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
359 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
360 deleted tinyint(4) DEFAULT '0' NOT NULL,
361 sorting int(11) unsigned DEFAULT '0' NOT NULL,
362 title varchar(255) DEFAULT '' NOT NULL,
363 description text NOT NULL,
364 config text NOT NULL,
365 icon text NOT NULL,
366
367 PRIMARY KEY (uid),
368 KEY parent (pid),
369 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
370 );