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