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