Implemented versioning API, phase 1 (tcemain). See changelog
[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) DEFAULT '0' NOT NULL auto_increment,
169 pid int(11) DEFAULT '0' NOT NULL,
170 t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
171 t3ver_id int(11) unsigned DEFAULT '0' NOT NULL,
172 t3ver_label varchar(30) DEFAULT '' NOT NULL,
173 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
174 crdate int(11) unsigned DEFAULT '0' NOT NULL,
175 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
176 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
177 title tinytext NOT NULL,
178 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
179 starttime int(11) unsigned DEFAULT '0' NOT NULL,
180 endtime int(11) unsigned DEFAULT '0' NOT NULL,
181 subtitle tinytext NOT NULL,
182 nav_title tinytext NOT NULL,
183 media tinyblob NOT NULL,
184 keywords text NOT NULL,
185 description text NOT NULL,
186 abstract text NOT NULL,
187 author tinytext NOT NULL,
188 author_email varchar(80) DEFAULT '' NOT NULL,
189 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
190 l18n_diffsource mediumblob NOT NULL,
191
192 PRIMARY KEY (uid),
193 KEY t3ver_oid (t3ver_oid),
194 KEY parent (pid)
195 );
196
197
198 #
199 # Table structure for table 'static_template'
200 #
201 CREATE TABLE static_template (
202 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
203 pid int(11) unsigned DEFAULT '0' NOT NULL,
204 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
205 crdate int(11) unsigned DEFAULT '0' NOT NULL,
206 title tinytext NOT NULL,
207 include_static tinyblob NOT NULL,
208 constants blob NOT NULL,
209 config blob NOT NULL,
210 editorcfg blob NOT NULL,
211 description text NOT NULL,
212 PRIMARY KEY (uid),
213 KEY parent (pid)
214 );
215
216
217 #
218 # Table structure for table 'sys_domain'
219 #
220 CREATE TABLE sys_domain (
221 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
222 pid int(11) unsigned DEFAULT '0' NOT NULL,
223 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
224 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
225 domainName varchar(80) DEFAULT '' NOT NULL,
226 redirectTo varchar(120) DEFAULT '' NOT NULL,
227 sorting int(10) unsigned DEFAULT '0' NOT NULL,
228 prepend_params int(10) DEFAULT '0' NOT NULL,
229
230 PRIMARY KEY (uid),
231 KEY parent (pid)
232 );
233
234
235
236 #
237 # Table structure for table 'sys_template'
238 #
239 CREATE TABLE sys_template (
240 uid int(11) DEFAULT '0' NOT NULL auto_increment,
241 pid int(11) DEFAULT '0' NOT NULL,
242 t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
243 t3ver_id int(11) unsigned DEFAULT '0' NOT NULL,
244 t3ver_label varchar(30) DEFAULT '' NOT NULL,
245 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
246 sorting int(11) unsigned DEFAULT '0' NOT NULL,
247 crdate int(11) unsigned DEFAULT '0' NOT NULL,
248 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
249 title tinytext NOT NULL,
250 sitetitle tinytext NOT NULL,
251 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
252 starttime int(11) unsigned DEFAULT '0' NOT NULL,
253 endtime int(11) unsigned DEFAULT '0' NOT NULL,
254 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
255 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
256 include_static tinyblob NOT NULL,
257 include_static_file blob NOT NULL,
258 constants blob NOT NULL,
259 config blob NOT NULL,
260 editorcfg blob NOT NULL,
261 resources blob NOT NULL,
262 nextLevel varchar(5) DEFAULT '' NOT NULL,
263 description text NOT NULL,
264 basedOn tinyblob NOT NULL,
265 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
266 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
267 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
268 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
269 PRIMARY KEY (uid),
270 KEY t3ver_oid (t3ver_oid),
271 KEY parent (pid)
272 );
273
274
275 #
276 # Table structure for table 'tt_content'
277 #
278 CREATE TABLE tt_content (
279 uid int(11) DEFAULT '0' NOT NULL auto_increment,
280 pid int(11) DEFAULT '0' NOT NULL,
281 t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
282 t3ver_id int(11) unsigned DEFAULT '0' NOT NULL,
283 t3ver_label varchar(30) DEFAULT '' NOT NULL,
284 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
285 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
286 sorting int(11) unsigned DEFAULT '0' NOT NULL,
287 CType varchar(30) DEFAULT '' NOT NULL,
288 header tinytext NOT NULL,
289 header_position varchar(6) DEFAULT '' NOT NULL,
290 bodytext mediumtext NOT NULL,
291 image blob NOT NULL,
292 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
293 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
294 imagecaption text NOT NULL,
295 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
296 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
297 media blob NOT NULL,
298 layout tinyint(3) unsigned DEFAULT '0' NOT NULL,
299 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
300 cols tinyint(3) unsigned DEFAULT '0' NOT NULL,
301 records blob NOT NULL,
302 pages tinyblob NOT NULL,
303 starttime int(11) unsigned DEFAULT '0' NOT NULL,
304 endtime int(11) unsigned DEFAULT '0' NOT NULL,
305 colPos tinyint(3) unsigned DEFAULT '0' NOT NULL,
306 subheader tinytext NOT NULL,
307 spaceBefore tinyint(4) unsigned DEFAULT '0' NOT NULL,
308 spaceAfter tinyint(4) unsigned DEFAULT '0' NOT NULL,
309 fe_group int(11) DEFAULT '0' NOT NULL,
310 header_link tinytext NOT NULL,
311 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
312 image_link tinytext NOT NULL,
313 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
314 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
315 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
316 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
317 header_layout varchar(30) DEFAULT '0' NOT NULL,
318 text_align varchar(6) DEFAULT '' NOT NULL,
319 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
320 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
321 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
322 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
323 menu_type varchar(30) DEFAULT '0' NOT NULL,
324 list_type varchar(36) DEFAULT '0' NOT NULL,
325 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
326 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
327 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
328 table_bgColor tinyint(3) unsigned DEFAULT '0' NOT NULL,
329 select_key varchar(80) DEFAULT '' NOT NULL,
330 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
331 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
332 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
333 section_frame tinyint(3) unsigned DEFAULT '0' NOT NULL,
334 date int(10) unsigned DEFAULT '0' NOT NULL,
335 splash_layout varchar(30) DEFAULT '0' NOT NULL,
336 multimedia tinyblob NOT NULL,
337 image_frames tinyint(3) unsigned DEFAULT '0' NOT NULL,
338 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
339 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
340 module_sys_dmail_category int(10) unsigned DEFAULT '0' NOT NULL,
341 rte_enabled tinyint(4) DEFAULT '0' NOT NULL,
342 sys_language_uid int(11) DEFAULT '0' NOT NULL,
343 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
344 pi_flexform mediumtext NOT NULL,
345 l18n_parent int(11) DEFAULT '0' NOT NULL,
346 l18n_diffsource mediumblob NOT NULL,
347
348 PRIMARY KEY (uid),
349 KEY t3ver_oid (t3ver_oid),
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 );