See changelog (2004-08-21). Localization features, Tab menus, few bugs fixed.
[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 l18n_diffsource mediumblob NOT NULL,
188
189 PRIMARY KEY (uid),
190 KEY parent (pid)
191 );
192
193
194 #
195 # Table structure for table 'static_template'
196 #
197 CREATE TABLE static_template (
198 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
199 pid int(11) unsigned DEFAULT '0' NOT NULL,
200 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
201 crdate int(11) unsigned DEFAULT '0' NOT NULL,
202 title tinytext NOT NULL,
203 include_static tinyblob NOT NULL,
204 constants blob NOT NULL,
205 config blob NOT NULL,
206 editorcfg blob NOT NULL,
207 description text NOT NULL,
208 PRIMARY KEY (uid),
209 KEY parent (pid)
210 );
211
212
213 #
214 # Table structure for table 'sys_domain'
215 #
216 CREATE TABLE sys_domain (
217 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
218 pid int(11) unsigned DEFAULT '0' NOT NULL,
219 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
220 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
221 domainName varchar(80) DEFAULT '' NOT NULL,
222 redirectTo varchar(120) DEFAULT '' NOT NULL,
223 sorting int(10) unsigned DEFAULT '0' NOT NULL,
224 prepend_params int(10) DEFAULT '0' NOT NULL,
225
226 PRIMARY KEY (uid),
227 KEY parent (pid)
228 );
229
230
231
232 #
233 # Table structure for table 'sys_template'
234 #
235 CREATE TABLE sys_template (
236 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
237 pid int(11) unsigned DEFAULT '0' NOT NULL,
238 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
239 sorting int(11) unsigned DEFAULT '0' NOT NULL,
240 crdate int(11) unsigned DEFAULT '0' NOT NULL,
241 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
242 title tinytext NOT NULL,
243 sitetitle tinytext NOT NULL,
244 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
245 starttime int(11) unsigned DEFAULT '0' NOT NULL,
246 endtime int(11) unsigned DEFAULT '0' NOT NULL,
247 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
248 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
249 include_static tinyblob NOT NULL,
250 include_static_file blob NOT NULL,
251 constants blob NOT NULL,
252 config blob NOT NULL,
253 editorcfg blob NOT NULL,
254 resources blob NOT NULL,
255 nextLevel varchar(5) DEFAULT '' NOT NULL,
256 description text NOT NULL,
257 basedOn tinyblob NOT NULL,
258 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
259 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
260 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
261 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
262 PRIMARY KEY (uid),
263 KEY parent (pid)
264 );
265
266
267 #
268 # Table structure for table 'tt_content'
269 #
270 CREATE TABLE tt_content (
271 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
272 pid int(11) unsigned DEFAULT '0' NOT NULL,
273 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
274 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
275 sorting int(11) unsigned DEFAULT '0' NOT NULL,
276 CType varchar(30) DEFAULT '' NOT NULL,
277 header tinytext NOT NULL,
278 header_position varchar(6) DEFAULT '' NOT NULL,
279 bodytext mediumtext NOT NULL,
280 image blob NOT NULL,
281 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
282 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
283 imagecaption text NOT NULL,
284 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
285 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
286 media blob NOT NULL,
287 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
288 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
289 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
290 records blob NOT NULL,
291 pages tinyblob NOT NULL,
292 starttime int(11) unsigned DEFAULT '0' NOT NULL,
293 endtime int(11) unsigned DEFAULT '0' NOT NULL,
294 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
295 subheader tinytext NOT NULL,
296 spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
297 spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
298 fe_group int(11) DEFAULT '0' NOT NULL,
299 header_link tinytext NOT NULL,
300 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
301 image_link tinytext NOT NULL,
302 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
303 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
304 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
305 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
306 header_layout varchar(30) DEFAULT '0' NOT NULL,
307 text_align varchar(6) DEFAULT '' NOT NULL,
308 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
309 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
310 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
311 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
312 menu_type varchar(30) DEFAULT '0' NOT NULL,
313 list_type varchar(36) DEFAULT '0' NOT NULL,
314 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
315 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
316 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
317 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
318 select_key varchar(80) DEFAULT '' NOT NULL,
319 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
320 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
321 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
322 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
323 date int(10) unsigned DEFAULT '0' NOT NULL,
324 splash_layout varchar(30) DEFAULT '0' NOT NULL,
325 multimedia tinyblob NOT NULL,
326 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
327 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
328 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
329 module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
330 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
331 sys_language_uid int(11) DEFAULT '0' NOT NULL,
332 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
333 pi_flexform mediumtext NOT NULL,
334 l18n_parent int(11) DEFAULT '0' NOT NULL,
335 l18n_diffsource mediumblob NOT NULL,
336
337 PRIMARY KEY (uid),
338 KEY parent (pid)
339 );
340
341
342 #
343 # Table structure for table 'pages'
344 #
345 CREATE TABLE pages (
346 url tinytext NOT NULL,
347 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
348 starttime int(11) unsigned DEFAULT '0' NOT NULL,
349 endtime int(11) unsigned DEFAULT '0' NOT NULL,
350 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
351 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
352 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
353 no_cache int(10) unsigned DEFAULT '0' NOT NULL,
354 fe_group int(11) DEFAULT '0' NOT NULL,
355 subtitle tinytext NOT NULL,
356 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
357 target varchar(20) DEFAULT '' NOT NULL,
358 media blob NOT NULL,
359 lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
360 keywords text NOT NULL,
361 cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
362 newUntil int(10) unsigned DEFAULT '0' NOT NULL,
363 description text NOT NULL,
364 no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
365 SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
366 abstract text NOT NULL,
367 module varchar(10) DEFAULT '' NOT NULL,
368 extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
369 author tinytext NOT NULL,
370 author_email varchar(80) DEFAULT '' NOT NULL,
371 nav_title tinytext NOT NULL,
372 nav_hide tinyint(4) DEFAULT '0' NOT NULL,
373 content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
374 mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
375 mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
376 alias varchar(20) DEFAULT '' NOT NULL,
377 l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
378 KEY alias (alias)
379 );