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