[!!!][TASK] Remove lockHashKeyWords functionality
[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(32) DEFAULT '' NOT NULL,
65 ses_iplock varchar(39) DEFAULT '' NOT NULL,
66 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
67 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
68 ses_data blob,
69 ses_permanent tinyint(1) unsigned DEFAULT '0' NOT NULL,
70
71 PRIMARY KEY (ses_id,ses_name),
72 KEY ses_tstamp (ses_tstamp)
73 ) ENGINE=InnoDB;
74
75 #
76 # Table structure for table 'fe_users'
77 #
78 CREATE TABLE fe_users (
79 uid int(11) unsigned NOT NULL auto_increment,
80 pid int(11) unsigned DEFAULT '0' NOT NULL,
81 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
82 username varchar(255) DEFAULT '' NOT NULL,
83 password varchar(100) DEFAULT '' NOT NULL,
84 usergroup tinytext,
85 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
86 starttime int(11) unsigned DEFAULT '0' NOT NULL,
87 endtime int(11) unsigned DEFAULT '0' NOT NULL,
88 name varchar(160) DEFAULT '' NOT NULL,
89 first_name varchar(50) DEFAULT '' NOT NULL,
90 middle_name varchar(50) DEFAULT '' NOT NULL,
91 last_name varchar(50) DEFAULT '' NOT NULL,
92 address varchar(255) DEFAULT '' NOT NULL,
93 telephone varchar(30) DEFAULT '' NOT NULL,
94 fax varchar(30) DEFAULT '' NOT NULL,
95 email varchar(255) DEFAULT '' NOT NULL,
96 crdate int(11) unsigned DEFAULT '0' NOT NULL,
97 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
98 lockToDomain varchar(50) DEFAULT '' NOT NULL,
99 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
100 uc blob,
101 title varchar(40) DEFAULT '' NOT NULL,
102 zip varchar(10) DEFAULT '' NOT NULL,
103 city varchar(50) DEFAULT '' NOT NULL,
104 country varchar(40) DEFAULT '' NOT NULL,
105 www varchar(80) DEFAULT '' NOT NULL,
106 company varchar(80) DEFAULT '' NOT NULL,
107 image tinytext,
108 TSconfig text,
109 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
110 is_online int(10) unsigned DEFAULT '0' NOT NULL,
111
112 PRIMARY KEY (uid),
113 KEY parent (pid,username),
114 KEY username (username),
115 KEY is_online (is_online)
116 );
117
118 #
119 # Table structure for table 'pages_language_overlay'
120 #
121 CREATE TABLE pages_language_overlay (
122 uid int(11) NOT NULL auto_increment,
123 pid int(11) DEFAULT '0' NOT NULL,
124 doktype int(11) unsigned DEFAULT '0' NOT NULL,
125 t3ver_oid int(11) DEFAULT '0' NOT NULL,
126 t3ver_id int(11) DEFAULT '0' NOT NULL,
127 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
128 t3ver_label varchar(255) DEFAULT '' NOT NULL,
129 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
130 t3ver_stage int(11) DEFAULT '0' NOT NULL,
131 t3ver_count int(11) DEFAULT '0' NOT NULL,
132 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
133 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
134 t3_origuid int(11) DEFAULT '0' NOT NULL,
135 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
136 crdate int(11) unsigned DEFAULT '0' NOT NULL,
137 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
138 sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
139 title varchar(255) DEFAULT '' NOT NULL,
140 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
141 starttime int(11) unsigned DEFAULT '0' NOT NULL,
142 endtime int(11) unsigned DEFAULT '0' NOT NULL,
143 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
144 subtitle varchar(255) DEFAULT '' NOT NULL,
145 nav_title varchar(255) DEFAULT '' NOT NULL,
146 media int(11) unsigned DEFAULT '0' NOT NULL,
147 keywords text,
148 description text,
149 abstract text,
150 author varchar(255) DEFAULT '' NOT NULL,
151 author_email varchar(80) DEFAULT '' NOT NULL,
152 l18n_diffsource mediumblob,
153 url varchar(255) DEFAULT '' NOT NULL,
154 urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
155 shortcut int(10) unsigned DEFAULT '0' NOT NULL,
156 shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
157
158 PRIMARY KEY (uid),
159 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
160 KEY parent (pid,sys_language_uid)
161 );
162
163 #
164 # Table structure for table 'sys_domain'
165 #
166 CREATE TABLE sys_domain (
167 uid int(11) unsigned NOT NULL auto_increment,
168 pid int(11) unsigned DEFAULT '0' NOT NULL,
169 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
170 crdate int(11) unsigned DEFAULT '0' NOT NULL,
171 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
172 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
173 domainName varchar(80) DEFAULT '' NOT NULL,
174 redirectTo varchar(255) DEFAULT '' NOT NULL,
175 redirectHttpStatusCode int(4) unsigned DEFAULT '301' NOT NULL,
176 sorting int(10) unsigned DEFAULT '0' NOT NULL,
177 prepend_params int(10) DEFAULT '0' NOT NULL,
178 forced tinyint(3) unsigned DEFAULT '0' NOT NULL,
179
180 PRIMARY KEY (uid),
181 KEY parent (pid),
182 KEY getSysDomain (redirectTo,hidden)
183 );
184
185 #
186 # Table structure for table 'sys_template'
187 #
188 CREATE TABLE sys_template (
189 uid int(11) NOT NULL auto_increment,
190 pid int(11) DEFAULT '0' NOT NULL,
191 t3ver_oid int(11) DEFAULT '0' NOT NULL,
192 t3ver_id int(11) DEFAULT '0' NOT NULL,
193 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
194 t3ver_label varchar(255) DEFAULT '' NOT NULL,
195 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
196 t3ver_stage int(11) DEFAULT '0' NOT NULL,
197 t3ver_count int(11) DEFAULT '0' NOT NULL,
198 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
199 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
200 t3_origuid int(11) DEFAULT '0' NOT NULL,
201 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
202 sorting int(11) unsigned DEFAULT '0' NOT NULL,
203 crdate int(11) unsigned DEFAULT '0' NOT NULL,
204 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
205 title varchar(255) DEFAULT '' NOT NULL,
206 sitetitle varchar(255) DEFAULT '' NOT NULL,
207 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
208 starttime int(11) unsigned DEFAULT '0' NOT NULL,
209 endtime int(11) unsigned DEFAULT '0' NOT NULL,
210 root tinyint(4) unsigned DEFAULT '0' NOT NULL,
211 clear tinyint(4) unsigned DEFAULT '0' NOT NULL,
212 include_static_file text,
213 constants text,
214 config text,
215 nextLevel varchar(5) DEFAULT '' NOT NULL,
216 description text,
217 basedOn tinytext,
218 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
219 includeStaticAfterBasedOn tinyint(4) unsigned DEFAULT '0' NOT NULL,
220 static_file_mode tinyint(4) unsigned DEFAULT '0' NOT NULL,
221
222 PRIMARY KEY (uid),
223 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
224 KEY parent (pid,deleted,hidden,sorting),
225 KEY roottemplate (deleted,hidden,root)
226 );
227
228 #
229 # Table structure for table 'tt_content'
230 #
231 CREATE TABLE tt_content (
232 uid int(11) NOT NULL auto_increment,
233 pid int(11) DEFAULT '0' NOT NULL,
234 t3ver_oid int(11) DEFAULT '0' NOT NULL,
235 t3ver_id int(11) DEFAULT '0' NOT NULL,
236 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
237 t3ver_label varchar(255) DEFAULT '' NOT NULL,
238 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
239 t3ver_stage int(11) DEFAULT '0' NOT NULL,
240 t3ver_count int(11) DEFAULT '0' NOT NULL,
241 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
242 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
243 t3_origuid int(11) DEFAULT '0' NOT NULL,
244 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
245 crdate int(11) unsigned DEFAULT '0' NOT NULL,
246 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
247 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
248 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
249 sorting int(11) unsigned DEFAULT '0' NOT NULL,
250 CType varchar(255) DEFAULT '' NOT NULL,
251 header varchar(255) DEFAULT '' NOT NULL,
252 rowDescription text,
253 bodytext mediumtext,
254
255 image int(11) unsigned DEFAULT '0' NOT NULL,
256
257 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
258 imageorient tinyint(4) unsigned DEFAULT '0' NOT NULL,
259 imagecols tinyint(4) unsigned DEFAULT '0' NOT NULL,
260 imageborder tinyint(4) unsigned DEFAULT '0' NOT NULL,
261 media int(11) unsigned DEFAULT '0' NOT NULL,
262 layout int(11) unsigned DEFAULT '0' NOT NULL,
263 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
264 cols int(11) unsigned DEFAULT '0' NOT NULL,
265 records text,
266 pages text,
267 starttime int(11) unsigned DEFAULT '0' NOT NULL,
268 endtime int(11) unsigned DEFAULT '0' NOT NULL,
269 colPos int(11) unsigned DEFAULT '0' NOT NULL,
270 subheader varchar(255) DEFAULT '' NOT NULL,
271 fe_group varchar(100) DEFAULT '0' NOT NULL,
272 header_link varchar(1024) DEFAULT '' NOT NULL,
273 image_zoom tinyint(3) unsigned DEFAULT '0' NOT NULL,
274 header_layout varchar(30) DEFAULT '0' NOT NULL,
275 menu_type varchar(30) DEFAULT '0' NOT NULL,
276 list_type varchar(255) DEFAULT '' NOT NULL,
277 select_key varchar(80) DEFAULT '' NOT NULL,
278 sectionIndex tinyint(3) unsigned DEFAULT '0' NOT NULL,
279 linkToTop tinyint(3) unsigned DEFAULT '0' NOT NULL,
280 file_collections text,
281 filelink_size tinyint(3) unsigned DEFAULT '0' NOT NULL,
282 filelink_sorting varchar(10) DEFAULT '' NOT NULL,
283 target varchar(30) DEFAULT '' NOT NULL,
284 date int(10) unsigned DEFAULT '0' NOT NULL,
285 recursive tinyint(3) unsigned DEFAULT '0' NOT NULL,
286 imageheight mediumint(8) unsigned DEFAULT '0' NOT NULL,
287 sys_language_uid int(11) DEFAULT '0' NOT NULL,
288 pi_flexform mediumtext,
289 accessibility_title varchar(30) DEFAULT '' NOT NULL,
290 accessibility_bypass tinyint(3) unsigned DEFAULT '0' NOT NULL,
291 accessibility_bypass_text varchar(30) DEFAULT '' NOT NULL,
292 l18n_parent int(11) DEFAULT '0' NOT NULL,
293 l18n_diffsource mediumblob,
294 l10n_source int(11) DEFAULT '0' NOT NULL,
295 selected_categories text,
296 category_field varchar(64) DEFAULT '' NOT NULL,
297 table_caption varchar(255) DEFAULT NULL,
298 table_delimiter smallint(6) unsigned DEFAULT '0' NOT NULL,
299 table_enclosure smallint(6) unsigned DEFAULT '0' NOT NULL,
300 table_header_position tinyint(3) unsigned DEFAULT '0' NOT NULL,
301 table_tfoot tinyint(1) unsigned DEFAULT '0' NOT NULL,
302
303 PRIMARY KEY (uid),
304 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
305 KEY parent (pid,sorting),
306 KEY language (l18n_parent,sys_language_uid)
307 );
308
309 #
310 # Table structure for table 'backend_layout'
311 #
312 CREATE TABLE backend_layout (
313 uid int(11) NOT NULL auto_increment,
314 pid int(11) DEFAULT '0' NOT NULL,
315 t3ver_oid int(11) DEFAULT '0' NOT NULL,
316 t3ver_id int(11) DEFAULT '0' NOT NULL,
317 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
318 t3ver_label varchar(255) DEFAULT '' NOT NULL,
319 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
320 t3ver_stage int(11) DEFAULT '0' NOT NULL,
321 t3ver_count int(11) DEFAULT '0' NOT NULL,
322 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
323 t3ver_move_id int(11) DEFAULT '0' NOT NULL,
324 t3_origuid int(11) DEFAULT '0' NOT NULL,
325 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
326 crdate int(11) unsigned DEFAULT '0' NOT NULL,
327 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
328 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
329 deleted tinyint(4) DEFAULT '0' NOT NULL,
330 sorting int(11) unsigned DEFAULT '0' NOT NULL,
331 title varchar(255) DEFAULT '' NOT NULL,
332 description text,
333 config text NOT NULL,
334 icon text NOT NULL,
335
336 PRIMARY KEY (uid),
337 KEY parent (pid),
338 KEY t3ver_oid (t3ver_oid,t3ver_wsid)
339 );