* Added to user authentication that the HTTP_USER_AGENT is hashed and a part of the...
[Packages/TYPO3.CMS.git] / typo3 / sysext / cms / ext_tables.sql
1 # TYPO3 Extension Manager dump 1.0
2 #
3 # Host: TYPO3_host Database: t3_testsite
4 #--------------------------------------------------------
5 # TYPO3 CVS ID: $Id$
6
7
8 #
9 # Table structure for table 'cache_pages'
10 #
11 CREATE TABLE cache_pages (
12 id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
13 hash varchar(32) DEFAULT '' NOT NULL,
14 page_id int(11) unsigned DEFAULT '0' NOT NULL,
15 reg1 int(11) unsigned DEFAULT '0' NOT NULL,
16 HTML mediumblob NOT NULL,
17 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
18 expires int(10) unsigned DEFAULT '0' NOT NULL,
19 cache_data mediumblob NOT NULL,
20 KEY page_id (page_id),
21 KEY sel (hash,page_id),
22 PRIMARY KEY (id)
23 );
24
25
26 #
27 # Table structure for table 'cache_pagesection'
28 #
29 CREATE TABLE cache_pagesection (
30 page_id int(11) unsigned DEFAULT '0' NOT NULL,
31 mpvar_hash int(11) unsigned DEFAULT '0' NOT NULL,
32 content blob NOT NULL,
33 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
34 PRIMARY KEY (page_id,mpvar_hash)
35 );
36
37
38 #
39 # Table structure for table 'cache_typo3temp_log'
40 #
41 CREATE TABLE cache_typo3temp_log (
42 md5hash varchar(32) DEFAULT '' NOT NULL,
43 tstamp int(11) DEFAULT '0' NOT NULL,
44 filename tinytext NOT NULL,
45 orig_filename tinytext NOT NULL,
46 PRIMARY KEY (md5hash)
47 );
48
49
50 #
51 # Table structure for table 'cache_md5params'
52 #
53 CREATE TABLE cache_md5params (
54 md5hash varchar(20) DEFAULT '' NOT NULL,
55 tstamp int(11) DEFAULT '0' NOT NULL,
56 type tinyint(3) DEFAULT '0' NOT NULL,
57 params text NOT NULL,
58 PRIMARY KEY (md5hash)
59 );
60
61
62 #
63 # Table structure for table 'cache_imagesizes'
64 #
65 CREATE TABLE cache_imagesizes (
66 md5hash varchar(32) DEFAULT '' NOT NULL,
67 md5filename varchar(32) DEFAULT '' NOT NULL,
68 tstamp int(11) DEFAULT '0' NOT NULL,
69 filename tinytext NOT NULL,
70 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
71 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
72 PRIMARY KEY (md5filename)
73 );
74
75
76 #
77 # Table structure for table 'fe_groups'
78 #
79 CREATE TABLE fe_groups (
80 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
81 pid int(11) unsigned DEFAULT '0' NOT NULL,
82 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
83 title varchar(20) DEFAULT '' NOT NULL,
84 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
85 lockToDomain varchar(50) DEFAULT '' NOT NULL,
86 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
87 description text NOT NULL,
88 TSconfig blob NOT NULL,
89 PRIMARY KEY (uid),
90 KEY parent (pid)
91 );
92
93
94 #
95 # Table structure for table 'fe_session_data'
96 #
97 CREATE TABLE fe_session_data (
98 hash varchar(32) DEFAULT '' NOT NULL,
99 content blob NOT NULL,
100 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
101 PRIMARY KEY (hash)
102 );
103
104
105 #
106 # Table structure for table 'fe_sessions'
107 #
108 CREATE TABLE fe_sessions (
109 ses_id varchar(32) DEFAULT '' NOT NULL,
110 ses_name varchar(32) DEFAULT '' NOT NULL,
111 ses_iplock varchar(15) DEFAULT '' NOT NULL,
112 ses_hashlock int(11) DEFAULT '0' NOT NULL,
113 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
114 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
115 ses_data blob NOT NULL,
116 PRIMARY KEY (ses_id,ses_name)
117 );
118
119
120 #
121 # Table structure for table 'fe_users'
122 #
123 CREATE TABLE fe_users (
124 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
125 pid int(11) unsigned DEFAULT '0' NOT NULL,
126 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
127 username varchar(50) DEFAULT '' NOT NULL,
128 password varchar(40) DEFAULT '' NOT NULL,
129 usergroup tinyblob NOT NULL,
130 disable 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 name varchar(80) DEFAULT '' NOT NULL,
134 address tinytext NOT NULL,
135 telephone varchar(20) DEFAULT '' NOT NULL,
136 fax varchar(20) DEFAULT '' NOT NULL,
137 email varchar(80) DEFAULT '' NOT NULL,
138 crdate int(11) unsigned DEFAULT '0' NOT NULL,
139 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
140 lockToDomain varchar(50) DEFAULT '' NOT NULL,
141 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
142 uc blob NOT NULL,
143 title varchar(40) DEFAULT '' NOT NULL,
144 zip varchar(10) DEFAULT '' NOT NULL,
145 city varchar(50) DEFAULT '' NOT NULL,
146 country varchar(40) DEFAULT '' NOT NULL,
147 www varchar(80) DEFAULT '' NOT NULL,
148 company varchar(80) DEFAULT '' NOT NULL,
149 image tinyblob NOT NULL,
150 TSconfig blob NOT NULL,
151 module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
152 module_sys_dmail_html tinyint(3) unsigned DEFAULT '0' NOT NULL,
153 fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
154 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
155 is_online int(10) unsigned DEFAULT '0' NOT NULL,
156 PRIMARY KEY (uid),
157 KEY parent (pid),
158 KEY username (username),
159 KEY is_online (is_online),
160 KEY pid (pid,username)
161 );
162
163
164 #
165 # Table structure for table 'pages_language_overlay'
166 #
167 CREATE TABLE pages_language_overlay (
168 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
169 pid int(11) unsigned DEFAULT '0' NOT NULL,
170 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
171 crdate int(11) unsigned DEFAULT '0' NOT NULL,
172 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
173 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
174 title tinytext NOT NULL,
175 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
176 starttime int(11) unsigned DEFAULT '0' NOT NULL,
177 endtime int(11) unsigned DEFAULT '0' NOT NULL,
178 subtitle tinytext NOT NULL,
179 nav_title tinytext NOT NULL,
180 media tinyblob NOT NULL,
181 keywords text NOT NULL,
182 description text NOT NULL,
183 abstract text NOT NULL,
184 author tinytext NOT NULL,
185 author_email varchar(80) DEFAULT '' NOT NULL,
186 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
187 PRIMARY KEY (uid),
188 KEY parent (pid)
189 );
190
191
192 #
193 # Table structure for table 'static_template'
194 #
195 CREATE TABLE static_template (
196 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
197 pid int(11) unsigned DEFAULT '0' NOT NULL,
198 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
199 crdate int(11) unsigned DEFAULT '0' NOT NULL,
200 title tinytext NOT NULL,
201 include_static tinyblob NOT NULL,
202 constants blob NOT NULL,
203 config blob NOT NULL,
204 editorcfg blob NOT NULL,
205 description text NOT NULL,
206 PRIMARY KEY (uid),
207 KEY parent (pid)
208 );
209
210
211 #
212 # Table structure for table 'sys_domain'
213 #
214 CREATE TABLE sys_domain (
215 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
216 pid int(11) unsigned DEFAULT '0' NOT NULL,
217 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
218 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
219 domainName varchar(80) DEFAULT '' NOT NULL,
220 redirectTo varchar(120) DEFAULT '' NOT NULL,
221 sorting int(10) unsigned DEFAULT '0' NOT NULL,
222 prepend_params int(10) DEFAULT '0' NOT NULL,
223
224 PRIMARY KEY (uid),
225 KEY parent (pid)
226 );
227
228
229 #
230 # Table structure for table 'sys_language'
231 #
232 CREATE TABLE sys_language (
233 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
234 pid int(11) unsigned DEFAULT '0' NOT NULL,
235 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
236 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
237 title varchar(80) DEFAULT '' NOT NULL,
238 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
239 PRIMARY KEY (uid),
240 KEY parent (pid)
241 );
242
243
244 #
245 # Table structure for table 'sys_template'
246 #
247 CREATE TABLE sys_template (
248 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
249 pid int(11) unsigned DEFAULT '0' NOT NULL,
250 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
251 sorting int(11) unsigned DEFAULT '0' NOT NULL,
252 crdate int(11) unsigned DEFAULT '0' NOT NULL,
253 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
254 title tinytext NOT NULL,
255 sitetitle tinytext NOT NULL,
256 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
257 starttime int(11) unsigned DEFAULT '0' NOT NULL,
258 endtime int(11) unsigned DEFAULT '0' NOT NULL,
259 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
260 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
261 include_static tinyblob NOT NULL,
262 include_static_file blob NOT NULL,
263 constants blob NOT NULL,
264 config blob NOT NULL,
265 editorcfg blob NOT NULL,
266 resources blob NOT NULL,
267 nextLevel varchar(5) DEFAULT '' NOT NULL,
268 description text NOT NULL,
269 basedOn tinyblob NOT NULL,
270 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
271 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
272 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
273 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
274 PRIMARY KEY (uid),
275 KEY parent (pid)
276 );
277
278
279 #
280 # Table structure for table 'tt_content'
281 #
282 CREATE TABLE tt_content (
283 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
284 pid int(11) unsigned DEFAULT '0' NOT NULL,
285 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
286 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
287 sorting int(11) unsigned DEFAULT '0' NOT NULL,
288 CType varchar(30) DEFAULT '' NOT NULL,
289 header tinytext NOT NULL,
290 header_position varchar(6) DEFAULT '' NOT NULL,
291 bodytext mediumtext NOT NULL,
292 image blob NOT NULL,
293 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
294 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
295 imagecaption text NOT NULL,
296 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
297 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
298 media blob NOT NULL,
299 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
300 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
301 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
302 records blob NOT NULL,
303 pages tinyblob NOT NULL,
304 starttime int(11) unsigned DEFAULT '0' NOT NULL,
305 endtime int(11) unsigned DEFAULT '0' NOT NULL,
306 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
307 subheader tinytext NOT NULL,
308 spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
309 spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
310 fe_group int(11) DEFAULT '0' NOT NULL,
311 header_link tinytext NOT NULL,
312 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
313 image_link tinytext NOT NULL,
314 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
315 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
316 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
317 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
318 header_layout varchar(30) DEFAULT '0' NOT NULL,
319 text_align varchar(6) DEFAULT '' NOT NULL,
320 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
321 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
322 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
323 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
324 menu_type varchar(30) DEFAULT '0' NOT NULL,
325 list_type varchar(36) DEFAULT '0' NOT NULL,
326 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
327 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
328 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
329 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
330 select_key varchar(80) DEFAULT '' NOT NULL,
331 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
332 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
333 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
334 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
335 date int(10) unsigned DEFAULT '0' NOT NULL,
336 splash_layout varchar(30) DEFAULT '0' NOT NULL,
337 multimedia tinyblob NOT NULL,
338 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
339 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
340 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
341 module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
342 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
343 sys_language_uid int(11) DEFAULT '0' NOT NULL,
344 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
345 pi_flexform mediumtext NOT NULL,
346
347 PRIMARY KEY (uid),
348 KEY parent (pid)
349 );
350
351
352 #
353 # Table structure for table 'pages'
354 #
355 CREATE TABLE pages (
356 url tinytext NOT NULL,
357 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
358 starttime int(11) unsigned DEFAULT '0' NOT NULL,
359 endtime int(11) unsigned DEFAULT '0' NOT NULL,
360 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
361 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
362 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
363 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
364 fe_group int(11) DEFAULT '0' NOT NULL,
365 subtitle tinytext NOT NULL,
366 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
367 target varchar(20) DEFAULT '' NOT NULL,
368 media blob NOT NULL,
369 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
370 keywords text NOT NULL,
371 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
372 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
373 description text NOT NULL,
374 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
375 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
376 abstract text NOT NULL,
377 module varchar(10) DEFAULT '' NOT NULL,
378 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
379 author tinytext NOT NULL,
380 author_email varchar(80) DEFAULT '' NOT NULL,
381 nav_title tinytext NOT NULL,
382 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
383 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
384 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
385 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
386 alias varchar(20) DEFAULT '' NOT NULL,
387 KEY alias (alias)
388 );