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