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