See my changelog comment from 2004-06-28 + locallang-XML changes (done to german...
[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 flag varchar(20) DEFAULT '' NOT NULL,
239 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
240 PRIMARY KEY (uid),
241 KEY parent (pid)
242 );
243
244
245 #
246 # Table structure for table 'sys_template'
247 #
248 CREATE TABLE sys_template (
249 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
250 pid int(11) unsigned DEFAULT '0' NOT NULL,
251 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
252 sorting int(11) unsigned DEFAULT '0' NOT NULL,
253 crdate int(11) unsigned DEFAULT '0' NOT NULL,
254 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
255 title tinytext NOT NULL,
256 sitetitle tinytext NOT NULL,
257 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
258 starttime int(11) unsigned DEFAULT '0' NOT NULL,
259 endtime int(11) unsigned DEFAULT '0' NOT NULL,
260 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
261 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
262 include_static tinyblob NOT NULL,
263 include_static_file blob NOT NULL,
264 constants blob NOT NULL,
265 config blob NOT NULL,
266 editorcfg blob NOT NULL,
267 resources blob NOT NULL,
268 nextLevel varchar(5) DEFAULT '' NOT NULL,
269 description text NOT NULL,
270 basedOn tinyblob NOT NULL,
271 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
272 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
273 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
274 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
275 PRIMARY KEY (uid),
276 KEY parent (pid)
277 );
278
279
280 #
281 # Table structure for table 'tt_content'
282 #
283 CREATE TABLE tt_content (
284 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
285 pid int(11) unsigned DEFAULT '0' NOT NULL,
286 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
287 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
288 sorting int(11) unsigned DEFAULT '0' NOT NULL,
289 CType varchar(30) DEFAULT '' NOT NULL,
290 header tinytext NOT NULL,
291 header_position varchar(6) DEFAULT '' NOT NULL,
292 bodytext mediumtext NOT NULL,
293 image blob NOT NULL,
294 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
295 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
296 imagecaption text NOT NULL,
297 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
298 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
299 media blob NOT NULL,
300 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
301 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
302 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
303 records blob NOT NULL,
304 pages tinyblob NOT NULL,
305 starttime int(11) unsigned DEFAULT '0' NOT NULL,
306 endtime int(11) unsigned DEFAULT '0' NOT NULL,
307 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
308 subheader tinytext NOT NULL,
309 spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
310 spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
311 fe_group int(11) DEFAULT '0' NOT NULL,
312 header_link tinytext NOT NULL,
313 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
314 image_link tinytext NOT NULL,
315 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
316 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
317 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
318 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
319 header_layout varchar(30) DEFAULT '0' NOT NULL,
320 text_align varchar(6) DEFAULT '' NOT NULL,
321 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
322 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
323 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
324 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
325 menu_type varchar(30) DEFAULT '0' NOT NULL,
326 list_type varchar(36) DEFAULT '0' NOT NULL,
327 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
328 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
329 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
330 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
331 select_key varchar(80) DEFAULT '' NOT NULL,
332 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
333 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
334 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
335 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
336 date int(10) unsigned DEFAULT '0' NOT NULL,
337 splash_layout varchar(30) DEFAULT '0' NOT NULL,
338 multimedia tinyblob NOT NULL,
339 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
340 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
341 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
342 module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
343 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
344 sys_language_uid int(11) DEFAULT '0' NOT NULL,
345 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
346 pi_flexform mediumtext NOT NULL,
347 l18n_parent int(11) DEFAULT '0' NOT NULL,
348
349 PRIMARY KEY (uid),
350 KEY parent (pid)
351 );
352
353
354 #
355 # Table structure for table 'pages'
356 #
357 CREATE TABLE pages (
358 url tinytext NOT NULL,
359 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
360 starttime int(11) unsigned DEFAULT '0' NOT NULL,
361 endtime int(11) unsigned DEFAULT '0' NOT NULL,
362 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
363 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
364 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
365 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
366 fe_group int(11) DEFAULT '0' NOT NULL,
367 subtitle tinytext NOT NULL,
368 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
369 target varchar(20) DEFAULT '' NOT NULL,
370 media blob NOT NULL,
371 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
372 keywords text NOT NULL,
373 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
374 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
375 description text NOT NULL,
376 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
377 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
378 abstract text NOT NULL,
379 module varchar(10) DEFAULT '' NOT NULL,
380 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
381 author tinytext NOT NULL,
382 author_email varchar(80) DEFAULT '' NOT NULL,
383 nav_title tinytext NOT NULL,
384 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
385 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
386 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
387 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
388 alias varchar(20) DEFAULT '' NOT NULL,
389 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
390 KEY alias (alias)
391 );