[BUGFIX] Wrong namespace in DataHandler test
[Packages/TYPO3.CMS.git] / typo3 / sysext / cms / ext_tables.sql
1 #
2
3
4 #
5 # Table structure for table 'cache_typo3temp_log'
6 #
7 CREATE TABLE cache_typo3temp_log (
8 md5hash varchar(32) DEFAULT '' NOT NULL,
9 tstamp int(11) DEFAULT '0' NOT NULL,
10 filename varchar(255) DEFAULT '' NOT NULL,
11 orig_filename varchar(255) DEFAULT '' NOT NULL,
12 PRIMARY KEY (md5hash)
13 ) ENGINE=InnoDB;
14
15
16 #
17 # Table structure for table 'cache_md5params'
18 #
19 CREATE TABLE cache_md5params (
20 md5hash varchar(20) DEFAULT '' NOT NULL,
21 tstamp int(11) DEFAULT '0' NOT NULL,
22 type tinyint(3) DEFAULT '0' NOT NULL,
23 params text,
24 PRIMARY KEY (md5hash)
25 ) ENGINE=InnoDB;
26
27
28 #
29 # Table structure for table 'cache_treelist'
30 #
31 CREATE TABLE cache_treelist (
32 md5hash char(32) DEFAULT '' NOT NULL,
33 pid int(11) DEFAULT '0' NOT NULL,
34 treelist text,
35 tstamp int(11) DEFAULT '0' NOT NULL,
36 expires int(11) unsigned DEFAULT '0' NOT NULL,
37 PRIMARY KEY (md5hash)
38 ) ENGINE=InnoDB;
39
40
41 #
42 # Table structure for table 'fe_groups'
43 #
44 CREATE TABLE fe_groups (
45 uid int(11) unsigned NOT NULL auto_increment,
46 pid int(11) unsigned DEFAULT '0' NOT NULL,
47 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
48 crdate int(11) unsigned DEFAULT '0' NOT NULL,
49 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
50 title varchar(50) DEFAULT '' NOT NULL,
51 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
52 lockToDomain varchar(50) DEFAULT '' NOT NULL,
53 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
54 description text,
55 subgroup tinytext,
56 TSconfig text,
57 PRIMARY KEY (uid),
58 KEY parent (pid)
59 );
60
61
62 #
63 # Table structure for table 'fe_session_data'
64 #
65 CREATE TABLE fe_session_data (
66 hash varchar(32) DEFAULT '' NOT NULL,
67 content mediumblob,
68 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
69 PRIMARY KEY (hash),
70 KEY tstamp (tstamp)
71 ) ENGINE=InnoDB;
72
73
74 #
75 # Table structure for table 'fe_sessions'
76 #
77 CREATE TABLE fe_sessions (
78 ses_id varchar(32) DEFAULT '' NOT NULL,
79 ses_name varchar(32) DEFAULT '' NOT NULL,
80 ses_iplock varchar(39) DEFAULT '' NOT NULL,
81 ses_hashlock int(11) DEFAULT '0' NOT NULL,
82 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
83 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
84 ses_data blob,
85 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
86 PRIMARY KEY (ses_id,ses_name),
87 KEY ses_tstamp (ses_tstamp)
88 ) ENGINE=InnoDB;
89
90
91 #
92 # Table structure for table 'fe_users'
93 #
94 CREATE TABLE fe_users (
95 uid int(11) unsigned NOT NULL auto_increment,
96 pid int(11) unsigned DEFAULT '0' NOT NULL,
97 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
98 username varchar(50) DEFAULT '' NOT NULL,
99 password varchar(100) DEFAULT '' NOT NULL,
100 usergroup tinytext,
101 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
102 starttime int(11) unsigned DEFAULT '0' NOT NULL,
103 endtime int(11) unsigned DEFAULT '0' NOT NULL,
104 name varchar(80) DEFAULT '' NOT NULL,
105 first_name varchar(50) DEFAULT '' NOT NULL,
106 middle_name varchar(50) DEFAULT '' NOT NULL,
107 last_name varchar(50) DEFAULT '' NOT NULL,
108 address varchar(255) DEFAULT '' NOT NULL,
109 telephone varchar(20) DEFAULT '' NOT NULL,
110 fax varchar(20) DEFAULT '' NOT NULL,
111 email varchar(80) DEFAULT '' NOT NULL,
112 crdate int(11) unsigned DEFAULT '0' NOT NULL,
113 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
114 lockToDomain varchar(50) DEFAULT '' NOT NULL,
115 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
116 uc blob,
117 title varchar(40) DEFAULT '' NOT NULL,
118 zip varchar(10) DEFAULT '' NOT NULL,
119 city varchar(50) DEFAULT '' NOT NULL,
120 country varchar(40) DEFAULT '' NOT NULL,
121 www varchar(80) DEFAULT '' NOT NULL,
122 company varchar(80) DEFAULT '' NOT NULL,
123 image tinytext,
124 TSconfig text,
125 fe_cruser_id int(10) unsigned DEFAULT '0' NOT NULL,
126 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
127 is_online int(10) unsigned DEFAULT '0' NOT NULL,
128 PRIMARY KEY (uid),
129 KEY parent (pid,username),
130 KEY username (username),
131 KEY is_online (is_online)
132 );
133
134
135 #
136 # Table structure for table 'pages_language_overlay'
137 #
138 CREATE TABLE pages_language_overlay (
139 uid int(11) NOT NULL auto_increment,
140 pid int(11) DEFAULT '0' NOT NULL,
141 doktype int(11) unsigned DEFAULT '0' NOT NULL,
142 t3ver_oid int(11) DEFAULT '0' NOT NULL,
143 t3ver_id int(11) DEFAULT '0' NOT NULL,
144 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
145 t3ver_label varchar(255) DEFAULT '' NOT NULL,
146 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
147 t3ver_stage int(11) DEFAULT '0' NOT NULL,
148 t3ver_count int(11) DEFAULT '0' NOT NULL,
149 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
150 t3_origuid int(11) DEFAULT '0' NOT NULL,
151 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
152 crdate int(11) unsigned DEFAULT '0' NOT NULL,
153 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
154 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
155 title varchar(255) DEFAULT '' NOT NULL,
156 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
157 starttime int(11) unsigned DEFAULT '0' NOT NULL,
158 endtime int(11) unsigned DEFAULT '0' NOT NULL,
159 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
160 subtitle varchar(255) DEFAULT '' NOT NULL,
161 nav_title varchar(255) DEFAULT '' NOT NULL,
162 media text,
163 keywords text,
164 description text,
165 abstract text,
166 author varchar(255) DEFAULT '' NOT NULL,
167 author_email varchar(80) DEFAULT '' NOT NULL,
168 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
169 l18n_diffsource mediumblob,
170 url varchar(255) DEFAULT '' NOT NULL,
171 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
172 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
173 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
174
175 PRIMARY KEY (uid),
176 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
177 KEY parent (pid,sys_language_uid)
178 );
179
180
181 #
182 # Table structure for table 'sys_domain'
183 #
184 CREATE TABLE sys_domain (
185 uid int(11) unsigned NOT NULL auto_increment,
186 pid int(11) unsigned DEFAULT '0' NOT NULL,
187 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
188 crdate int(11) unsigned DEFAULT '0' NOT NULL,
189 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
190 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
191 domainName varchar(80) DEFAULT '' NOT NULL,
192 redirectTo varchar(255) DEFAULT '' NOT NULL,
193 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
194 sorting int(10) unsigned DEFAULT '0' NOT NULL,
195 prepend_params int(10) DEFAULT '0' NOT NULL,
196 forced tinyint(3) unsigned DEFAULT '0' NOT NULL,
197
198 PRIMARY KEY (uid),
199 KEY parent (pid)
200 );
201
202
203
204 #
205 # Table structure for table 'sys_template'
206 #
207 CREATE TABLE sys_template (
208 uid int(11) NOT NULL auto_increment,
209 pid int(11) DEFAULT '0' NOT NULL,
210 t3ver_oid int(11) DEFAULT '0' NOT NULL,
211 t3ver_id int(11) DEFAULT '0' NOT NULL,
212 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
213 t3ver_label varchar(255) DEFAULT '' NOT NULL,
214 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
215 t3ver_stage int(11) DEFAULT '0' NOT NULL,
216 t3ver_count int(11) DEFAULT '0' NOT NULL,
217 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
218 t3_origuid int(11) DEFAULT '0' NOT NULL,
219 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
220 sorting int(11) unsigned DEFAULT '0' NOT NULL,
221 crdate int(11) unsigned DEFAULT '0' NOT NULL,
222 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
223 title varchar(255) DEFAULT '' NOT NULL,
224 sitetitle varchar(255) DEFAULT '' NOT NULL,
225 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
226 starttime int(11) unsigned DEFAULT '0' NOT NULL,
227 endtime int(11) unsigned DEFAULT '0' NOT NULL,
228 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
229 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
230 include_static_file text,
231 constants text,
232 config text,
233 nextLevel varchar(5) DEFAULT '' NOT NULL,
234 description text,
235 basedOn tinytext,
236 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
237 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
238 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
239 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
240 PRIMARY KEY (uid),
241 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
242 KEY parent (pid,deleted,hidden,sorting)
243 );
244
245
246 #
247 # Table structure for table 'tt_content'
248 #
249 CREATE TABLE tt_content (
250 uid int(11) NOT NULL auto_increment,
251 pid int(11) DEFAULT '0' NOT NULL,
252 t3ver_oid int(11) DEFAULT '0' NOT NULL,
253 t3ver_id int(11) DEFAULT '0' NOT NULL,
254 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
255 t3ver_label varchar(255) DEFAULT '' NOT NULL,
256 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
257 t3ver_stage int(11) DEFAULT '0' NOT NULL,
258 t3ver_count int(11) DEFAULT '0' NOT NULL,
259 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
260 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
261 t3_origuid int(11) DEFAULT '0' NOT NULL,
262 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
263 crdate int(11) unsigned DEFAULT '0' NOT NULL,
264 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
265 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
266 sorting int(11) unsigned DEFAULT '0' NOT NULL,
267 CType varchar(255) DEFAULT '' NOT NULL,
268 header varchar(255) DEFAULT '' NOT NULL,
269 header_position varchar(6) DEFAULT '' NOT NULL,
270 bodytext mediumtext,
271
272 # Even though we're using FAL and an IRRE field for images now, it needs to stay "text" for the migration to work
273 image text,
274
275 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
276 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
277 imagecaption text,
278 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
279 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
280 media text,
281 layout int(11) unsigned DEFAULT '0' NOT NULL,
282 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
283 cols int(11) unsigned DEFAULT '0' NOT NULL,
284 records text,
285 pages tinytext,
286 starttime int(11) unsigned DEFAULT '0' NOT NULL,
287 endtime int(11) unsigned DEFAULT '0' NOT NULL,
288 colPos int(11) unsigned DEFAULT '0' NOT NULL,
289 subheader varchar(255) DEFAULT '' NOT NULL,
290 spaceBefore smallint(5) unsigned DEFAULT '0' NOT NULL,
291 spaceAfter smallint(5) unsigned DEFAULT '0' NOT NULL,
292 fe_group varchar(100) DEFAULT '0' NOT NULL,
293 header_link varchar(255) DEFAULT '' NOT NULL,
294 imagecaption_position varchar(6) DEFAULT '' NOT NULL,
295 image_link text,
296 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
297 image_noRows tinyint(3) unsigned DEFAULT '0' NOT NULL,
298 image_effects tinyint(3) unsigned DEFAULT '0' NOT NULL,
299 image_compression tinyint(3) unsigned DEFAULT '0' NOT NULL,
300 altText text,
301 titleText text,
302 longdescURL text,
303 header_layout varchar(30) DEFAULT '0' NOT NULL,
304 text_align varchar(6) DEFAULT '' NOT NULL,
305 text_face tinyint(3) unsigned DEFAULT '0' NOT NULL,
306 text_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
307 text_color tinyint(3) unsigned DEFAULT '0' NOT NULL,
308 text_properties tinyint(3) unsigned DEFAULT '0' NOT NULL,
309 menu_type varchar(30) DEFAULT '0' NOT NULL,
310 list_type varchar(255) DEFAULT '0' NOT NULL,
311 table_border tinyint(3) unsigned DEFAULT '0' NOT NULL,
312 table_cellspacing tinyint(3) unsigned DEFAULT '0' NOT NULL,
313 table_cellpadding tinyint(3) unsigned DEFAULT '0' NOT NULL,
314 table_bgColor int(11) unsigned DEFAULT '0' NOT NULL,
315 select_key varchar(80) DEFAULT '' NOT NULL,
316 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
317 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
318 file_collections text,
319 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
320 filelink_sorting tinytext NOT NULL,
321 target varchar(30) DEFAULT '' NOT NULL,
322 section_frame int(11) unsigned DEFAULT '0' NOT NULL,
323 date int(10) unsigned DEFAULT '0' NOT NULL,
324 multimedia tinytext,
325 image_frames int(11) unsigned DEFAULT '0' NOT NULL,
326 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
327 imageheight mediumint(8) 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,
332 accessibility_title varchar(30) DEFAULT '' NOT NULL,
333 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
334 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
335 l18n_parent int(11) DEFAULT '0' NOT NULL,
336 l18n_diffsource mediumblob,
337
338 PRIMARY KEY (uid),
339 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
340 KEY parent (pid,sorting),
341 KEY language (l18n_parent,sys_language_uid)
342 );
343
344 #
345 # Table structure for table 'backend_layout'
346 #
347 CREATE TABLE backend_layout (
348 uid int(11) NOT NULL auto_increment,
349 pid int(11) DEFAULT '0' NOT NULL,
350 t3ver_oid int(11) DEFAULT '0' NOT NULL,
351 t3ver_id int(11) DEFAULT '0' NOT NULL,
352 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
353 t3ver_label varchar(255) DEFAULT '' NOT NULL,
354 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
355 t3ver_stage int(11) DEFAULT '0' NOT NULL,
356 t3ver_count int(11) DEFAULT '0' NOT NULL,
357 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
358 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
359 t3_origuid int(11) DEFAULT '0' NOT NULL,
360 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
361 crdate int(11) unsigned DEFAULT '0' NOT NULL,
362 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
363 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
364 deleted tinyint(4) DEFAULT '0' NOT NULL,
365 sorting int(11) unsigned DEFAULT '0' NOT NULL,
366 title varchar(255) DEFAULT '' NOT NULL,
367 description text NOT NULL,
368 config text NOT NULL,
369 icon text NOT NULL,
370 PRIMARY KEY (uid),
371 KEY parent (pid),
372 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
373 );