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