[TASK] Increase size of domain name field
[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,
40 subgroup tinytext,
41 TSconfig text,
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(100) 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 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
136 t3_origuid int(11) DEFAULT '0' NOT NULL,
137 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
138 crdate int(11) unsigned DEFAULT '0' NOT NULL,
139 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
140 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
141 title varchar(255) DEFAULT '' NOT NULL,
142 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
143 starttime int(11) unsigned DEFAULT '0' NOT NULL,
144 endtime int(11) unsigned DEFAULT '0' NOT NULL,
145 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
146 subtitle varchar(255) DEFAULT '' NOT NULL,
147 nav_title varchar(255) DEFAULT '' NOT NULL,
148 media int(11) unsigned DEFAULT '0' NOT NULL,
149 keywords text,
150 description text,
151 abstract text,
152 author varchar(255) DEFAULT '' NOT NULL,
153 author_email varchar(80) DEFAULT '' NOT NULL,
154 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
155 l18n_diffsource mediumblob,
156 url varchar(255) DEFAULT '' NOT NULL,
157 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
158 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
159 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
160
161 PRIMARY KEY (uid),
162 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
163 KEY parent (pid,sys_language_uid)
164 );
165
166 #
167 # Table structure for table 'sys_domain'
168 #
169 CREATE TABLE sys_domain (
170 uid int(11) unsigned NOT NULL auto_increment,
171 pid int(11) unsigned DEFAULT '0' NOT NULL,
172 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
173 crdate int(11) unsigned DEFAULT '0' NOT NULL,
174 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
175 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
176 domainName varchar(255) DEFAULT '' NOT NULL,
177 redirectTo varchar(255) DEFAULT '' NOT NULL,
178 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
179 sorting int(10) unsigned DEFAULT '0' NOT NULL,
180 prepend_params int(10) DEFAULT '0' NOT NULL,
181 forced tinyint(3) unsigned DEFAULT '0' NOT NULL,
182
183 PRIMARY KEY (uid),
184 KEY parent (pid),
185 KEY getSysDomain (redirectTo,hidden)
186 );
187
188 #
189 # Table structure for table 'sys_template'
190 #
191 CREATE TABLE sys_template (
192 uid int(11) NOT NULL auto_increment,
193 pid int(11) DEFAULT '0' NOT NULL,
194 t3ver_oid int(11) DEFAULT '0' NOT NULL,
195 t3ver_id int(11) DEFAULT '0' NOT NULL,
196 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
197 t3ver_label varchar(255) DEFAULT '' NOT NULL,
198 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
199 t3ver_stage int(11) DEFAULT '0' NOT NULL,
200 t3ver_count int(11) DEFAULT '0' NOT NULL,
201 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
202 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
203 t3_origuid int(11) DEFAULT '0' NOT NULL,
204 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
205 sorting int(11) unsigned DEFAULT '0' NOT NULL,
206 crdate int(11) unsigned DEFAULT '0' NOT NULL,
207 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
208 title varchar(255) DEFAULT '' NOT NULL,
209 sitetitle varchar(255) DEFAULT '' NOT NULL,
210 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
211 starttime int(11) unsigned DEFAULT '0' NOT NULL,
212 endtime int(11) unsigned DEFAULT '0' NOT NULL,
213 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
214 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
215 include_static_file text,
216 constants text,
217 config text,
218 nextLevel varchar(5) DEFAULT '' NOT NULL,
219 description text,
220 basedOn tinytext,
221 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
222 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
223 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
224 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
225
226 PRIMARY KEY (uid),
227 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
228 KEY parent (pid,deleted,hidden,sorting),
229 KEY roottemplate (deleted,hidden,root)
230 );
231
232 #
233 # Table structure for table 'tt_content'
234 #
235 CREATE TABLE tt_content (
236 uid int(11) NOT NULL auto_increment,
237 pid int(11) DEFAULT '0' NOT NULL,
238 t3ver_oid int(11) DEFAULT '0' NOT NULL,
239 t3ver_id int(11) DEFAULT '0' NOT NULL,
240 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
241 t3ver_label varchar(255) DEFAULT '' NOT NULL,
242 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
243 t3ver_stage int(11) DEFAULT '0' NOT NULL,
244 t3ver_count int(11) DEFAULT '0' NOT NULL,
245 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
246 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
247 t3_origuid int(11) DEFAULT '0' NOT NULL,
248 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
249 crdate int(11) unsigned DEFAULT '0' NOT NULL,
250 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
251 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
252 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
253 sorting int(11) unsigned DEFAULT '0' NOT NULL,
254 CType varchar(255) DEFAULT '' NOT NULL,
255 header varchar(255) DEFAULT '' NOT NULL,
256 rowDescription text,
257 bodytext mediumtext,
258
259 image int(11) unsigned DEFAULT '0' NOT NULL,
260
261 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
262 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
263 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
264 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
265 media int(11) unsigned DEFAULT '0' NOT NULL,
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 text,
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 fe_group varchar(100) DEFAULT '0' NOT NULL,
276 header_link varchar(1024) DEFAULT '' NOT NULL,
277 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
278 header_layout varchar(30) DEFAULT '0' NOT NULL,
279 menu_type varchar(30) DEFAULT '0' NOT NULL,
280 list_type varchar(255) DEFAULT '' NOT NULL,
281 select_key varchar(80) DEFAULT '' NOT NULL,
282 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
283 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
284 file_collections text,
285 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
286 filelink_sorting varchar(10) DEFAULT '' NOT NULL,
287 target varchar(30) DEFAULT '' NOT NULL,
288 date int(10) unsigned DEFAULT '0' NOT NULL,
289 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
290 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
291 sys_language_uid int(11) DEFAULT '0' NOT NULL,
292 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
293 pi_flexform mediumtext,
294 accessibility_title varchar(30) DEFAULT '' NOT NULL,
295 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
296 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
297 l18n_parent int(11) DEFAULT '0' NOT NULL,
298 l18n_diffsource mediumblob,
299 selected_categories text,
300 category_field varchar(64) DEFAULT '' NOT NULL,
301 table_caption varchar(255) DEFAULT NULL,
302 table_delimiter smallint(6) unsigned DEFAULT '0' NOT NULL,
303 table_enclosure smallint(6) unsigned DEFAULT '0' NOT NULL,
304 table_header_position tinyint(3) unsigned DEFAULT '0' NOT NULL,
305 table_tfoot tinyint(1) unsigned DEFAULT '0' NOT NULL,
306
307 PRIMARY KEY (uid),
308 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
309 KEY parent (pid,sorting),
310 KEY language (l18n_parent,sys_language_uid)
311 );
312
313 #
314 # Table structure for table 'backend_layout'
315 #
316 CREATE TABLE backend_layout (
317 uid int(11) NOT NULL auto_increment,
318 pid int(11) DEFAULT '0' NOT NULL,
319 t3ver_oid int(11) DEFAULT '0' NOT NULL,
320 t3ver_id int(11) DEFAULT '0' NOT NULL,
321 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
322 t3ver_label varchar(255) DEFAULT '' NOT NULL,
323 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
324 t3ver_stage int(11) DEFAULT '0' NOT NULL,
325 t3ver_count int(11) DEFAULT '0' NOT NULL,
326 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
327 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
328 t3_origuid int(11) DEFAULT '0' NOT NULL,
329 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
330 crdate int(11) unsigned DEFAULT '0' NOT NULL,
331 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
332 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
333 deleted tinyint(4) DEFAULT '0' NOT NULL,
334 sorting int(11) unsigned DEFAULT '0' NOT NULL,
335 title varchar(255) DEFAULT '' NOT NULL,
336 description text,
337 config text NOT NULL,
338 icon text NOT NULL,
339
340 PRIMARY KEY (uid),
341 KEY parent (pid),
342 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
343 );