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