git-svn-id: https://svn.typo3.org/TYPO3v4/Core/trunk@1770 709f56b5-9817-0410-a4d7...
[Packages/TYPO3.CMS.git] / t3lib / stddb / tables.sql
1 # MySQL dump 6.4
2 #
3 # Host: localhost Database: t3_testsite
4 #--------------------------------------------------------
5 # Server version 3.22.27
6 #
7 # TYPO3 CVS ID: $Id$
8
9 #
10 # Table structure for table 'be_groups'
11 #
12 CREATE TABLE be_groups (
13 uid int(11) unsigned NOT NULL auto_increment,
14 pid int(11) unsigned DEFAULT '0' NOT NULL,
15 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
16 title varchar(20) DEFAULT '' NOT NULL,
17 non_exclude_fields text NOT NULL,
18 explicit_allowdeny text NOT NULL,
19 allowed_languages tinytext NOT NULL,
20 custom_options text NOT NULL,
21 db_mountpoints varchar(40) DEFAULT '' NOT NULL,
22 pagetypes_select tinytext NOT NULL,
23 tables_select text NOT NULL,
24 tables_modify text NOT NULL,
25 crdate int(11) unsigned DEFAULT '0' NOT NULL,
26 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
27 groupMods tinytext NOT NULL,
28 file_mountpoints varchar(40) DEFAULT '' NOT NULL,
29 hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
30 inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
31 description text NOT NULL,
32 lockToDomain varchar(50) DEFAULT '' NOT NULL,
33 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
34 TSconfig text NOT NULL,
35 subgroup tinytext NOT NULL,
36 hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
37 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
38 PRIMARY KEY (uid),
39 KEY parent (pid)
40 );
41
42 #
43 # Table structure for table 'be_sessions'
44 #
45 CREATE TABLE be_sessions (
46 ses_id varchar(32) DEFAULT '' NOT NULL,
47 ses_name varchar(32) DEFAULT '' NOT NULL,
48 ses_iplock varchar(39) DEFAULT '' NOT NULL,
49 ses_hashlock int(11) DEFAULT '0' NOT NULL,
50 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
51 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
52 ses_data mediumtext NOT NULL,
53 ses_backuserid int(11) NOT NULL default '0',
54 PRIMARY KEY (ses_id,ses_name)
55 );
56
57 #
58 # Table structure for table 'be_users'
59 #
60 CREATE TABLE be_users (
61 uid int(11) unsigned NOT NULL auto_increment,
62 pid int(11) unsigned DEFAULT '0' NOT NULL,
63 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
64 username varchar(20) DEFAULT '' NOT NULL,
65 password varchar(40) DEFAULT '' NOT NULL,
66 admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
67 usergroup tinytext NOT NULL,
68 disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
69 starttime int(11) unsigned DEFAULT '0' NOT NULL,
70 endtime int(11) unsigned DEFAULT '0' NOT NULL,
71 lang varchar(2) DEFAULT '' NOT NULL,
72 email varchar(80) DEFAULT '' NOT NULL,
73 db_mountpoints varchar(40) DEFAULT '' NOT NULL,
74 options tinyint(4) unsigned DEFAULT '0' NOT NULL,
75 crdate int(11) unsigned DEFAULT '0' NOT NULL,
76 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
77 realName varchar(80) DEFAULT '' NOT NULL,
78 userMods tinytext NOT NULL,
79 allowed_languages tinytext NOT NULL,
80 uc text NOT NULL,
81 file_mountpoints varchar(40) DEFAULT '' NOT NULL,
82 fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
83 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
84 lockToDomain varchar(50) DEFAULT '' NOT NULL,
85 disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
86 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
87 TSconfig text NOT NULL,
88 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
89 createdByAction int(11) DEFAULT '0' NOT NULL,
90 usergroup_cached_list tinytext NOT NULL,
91 workspace_id int(11) DEFAULT '0' NOT NULL,
92 workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
93 PRIMARY KEY (uid),
94 KEY parent (pid),
95 KEY username (username)
96 );
97
98 #
99 # Table structure for table 'cache_hash'
100 #
101 CREATE TABLE cache_hash (
102 hash varchar(32) DEFAULT '' NOT NULL,
103 content mediumtext NOT NULL,
104 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
105 ident varchar(20) DEFAULT '' NOT NULL,
106 PRIMARY KEY (hash)
107 );
108
109 #
110 # Table structure for table 'cache_imagesizes'
111 #
112 CREATE TABLE cache_imagesizes (
113 md5hash varchar(32) DEFAULT '' NOT NULL,
114 md5filename varchar(32) DEFAULT '' NOT NULL,
115 tstamp int(11) DEFAULT '0' NOT NULL,
116 filename tinytext NOT NULL,
117 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
118 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
119 PRIMARY KEY (md5filename)
120 );
121
122 #
123 # Table structure for table 'pages'
124 #
125 CREATE TABLE pages (
126 uid int(11) NOT NULL auto_increment,
127 pid int(11) DEFAULT '0' NOT NULL,
128 t3ver_oid int(11) DEFAULT '0' NOT NULL,
129 t3ver_id int(11) DEFAULT '0' NOT NULL,
130 t3ver_wsid int(11) DEFAULT '0' NOT NULL,
131 t3ver_label varchar(30) DEFAULT '' NOT NULL,
132 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
133 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
134 t3ver_count int(11) DEFAULT '0' NOT NULL,
135 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
136 t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
137 t3_origuid int(11) DEFAULT '0' NOT NULL,
138 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
139 sorting int(11) unsigned DEFAULT '0' NOT NULL,
140 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
141 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
142 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
143 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
144 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
145 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
146 editlock tinyint(4) 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 title tinytext NOT NULL,
150 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
151 TSconfig text NOT NULL,
152 storage_pid int(11) DEFAULT '0' NOT NULL,
153 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
154 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
155 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
156 PRIMARY KEY (uid),
157 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
158 KEY parent (pid)
159 );
160
161 #
162 # Table structure for table 'sys_be_shortcuts'
163 #
164 CREATE TABLE sys_be_shortcuts (
165 uid int(11) unsigned NOT NULL auto_increment,
166 userid int(11) unsigned DEFAULT '0' NOT NULL,
167 module_name tinytext NOT NULL,
168 url text NOT NULL,
169 description tinytext NOT NULL,
170 sorting int(11) DEFAULT '0' NOT NULL,
171 sc_group tinyint(4) DEFAULT '0' NOT NULL,
172 PRIMARY KEY (uid),
173 KEY event (userid)
174 );
175
176
177 #
178 # Table structure for table 'sys_preview'
179 #
180 CREATE TABLE sys_preview (
181 keyword varchar(32) DEFAULT '' NOT NULL,
182 tstamp int(11) DEFAULT '0' NOT NULL,
183 endtime int(11) DEFAULT '0' NOT NULL,
184 config text NOT NULL,
185 PRIMARY KEY (keyword)
186 );
187
188
189 #
190 # Table structure for table 'sys_filemounts'
191 #
192 CREATE TABLE sys_filemounts (
193 uid int(11) unsigned NOT NULL auto_increment,
194 pid int(11) unsigned DEFAULT '0' NOT NULL,
195 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
196 title varchar(30) DEFAULT '' NOT NULL,
197 path varchar(120) DEFAULT '' NOT NULL,
198 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
199 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
200 deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
201 PRIMARY KEY (uid),
202 KEY parent (pid)
203 );
204
205 #
206 # Table structure for table 'sys_workspace'
207 #
208 CREATE TABLE sys_workspace (
209 uid int(11) NOT NULL auto_increment,
210 pid int(11) DEFAULT '0' NOT NULL,
211 tstamp int(11) DEFAULT '0' NOT NULL,
212 deleted tinyint(1) DEFAULT '0' NOT NULL,
213 title varchar(30) DEFAULT '' NOT NULL,
214 description tinytext NOT NULL,
215 adminusers tinytext NOT NULL,
216 members text NOT NULL,
217 reviewers text NOT NULL,
218 db_mountpoints tinytext NOT NULL,
219 file_mountpoints tinytext NOT NULL,
220 publish_time int(11) DEFAULT '0' NOT NULL,
221 unpublish_time int(11) DEFAULT '0' NOT NULL,
222 freeze tinyint(3) DEFAULT '0' NOT NULL,
223 live_edit tinyint(3) DEFAULT '0' NOT NULL,
224 review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
225 vtypes tinyint(3) DEFAULT '0' NOT NULL,
226 disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
227 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
228 publish_access tinyint(3) DEFAULT '0' NOT NULL,
229 stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
230
231 PRIMARY KEY (uid),
232 KEY parent (pid)
233 );
234
235 #
236 # Table structure for table 'sys_history'
237 #
238 CREATE TABLE sys_history (
239 uid int(11) unsigned NOT NULL auto_increment,
240 sys_log_uid int(11) DEFAULT '0' NOT NULL,
241 history_data mediumtext NOT NULL,
242 fieldlist text NOT NULL,
243 recuid int(11) DEFAULT '0' NOT NULL,
244 tablename varchar(40) DEFAULT '' NOT NULL,
245 tstamp int(11) DEFAULT '0' NOT NULL,
246 history_files mediumtext NOT NULL,
247 snapshot tinyint(4) DEFAULT '0' NOT NULL,
248 PRIMARY KEY (uid),
249 KEY recordident (tablename,recuid),
250 KEY sys_log_uid (sys_log_uid)
251 );
252
253 #
254 # Table structure for table 'sys_lockedrecords'
255 #
256 CREATE TABLE sys_lockedrecords (
257 uid int(11) unsigned NOT NULL auto_increment,
258 userid int(11) unsigned DEFAULT '0' NOT NULL,
259 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
260 record_table varchar(40) DEFAULT '' NOT NULL,
261 record_uid int(11) DEFAULT '0' NOT NULL,
262 record_pid int(11) DEFAULT '0' NOT NULL,
263 username varchar(20) DEFAULT '' NOT NULL,
264 PRIMARY KEY (uid),
265 KEY event (userid,tstamp)
266 );
267
268 #
269 # Table structure for table 'sys_refindex'
270 #
271 CREATE TABLE sys_refindex (
272 hash varchar(32) DEFAULT '' NOT NULL,
273 tablename varchar(40) DEFAULT '' NOT NULL,
274 recuid int(11) DEFAULT '0' NOT NULL,
275 field varchar(40) DEFAULT '' NOT NULL,
276 flexpointer tinytext NOT NULL,
277 softref_key varchar(30) DEFAULT '' NOT NULL,
278 softref_id varchar(40) DEFAULT '' NOT NULL,
279 sorting int(11) DEFAULT '0' NOT NULL,
280 deleted tinyint(1) DEFAULT '0' NOT NULL,
281 ref_table varchar(40) DEFAULT '' NOT NULL,
282 ref_uid int(11) DEFAULT '0' NOT NULL,
283 ref_string varchar(200) DEFAULT '' NOT NULL,
284
285 PRIMARY KEY (hash),
286 KEY lookup_rec (tablename,recuid),
287 KEY lookup_uid (ref_table,ref_uid),
288 KEY lookup_string (ref_table,ref_string(199))
289 );
290
291 #
292 # Table structure for table ''
293 #
294 CREATE TABLE sys_refindex_words (
295 wid int(11) DEFAULT '0' NOT NULL,
296 baseword varchar(60) DEFAULT '' NOT NULL,
297 PRIMARY KEY (wid)
298 );
299
300 #
301 # Table structure for table ''
302 #
303 CREATE TABLE sys_refindex_rel (
304 rid int(11) DEFAULT '0' NOT NULL,
305 wid int(11) DEFAULT '0' NOT NULL,
306 PRIMARY KEY (rid,wid)
307 );
308
309
310 #
311 # Table structure for table ''
312 #
313 CREATE TABLE sys_refindex_res (
314 rid int(11) DEFAULT '0' NOT NULL,
315 tablename varchar(100) DEFAULT '' NOT NULL,
316 recuid int(11) DEFAULT '0' NOT NULL,
317 PRIMARY KEY (rid)
318 );
319
320 #
321 # Table structure for table 'sys_log'
322 #
323 CREATE TABLE sys_log (
324 uid int(11) unsigned NOT NULL auto_increment,
325 userid int(11) unsigned DEFAULT '0' NOT NULL,
326 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
327 recuid int(11) unsigned DEFAULT '0' NOT NULL,
328 tablename varchar(40) DEFAULT '' NOT NULL,
329 recpid int(11) DEFAULT '0' NOT NULL,
330 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
331 details tinytext NOT NULL,
332 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
333 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
334 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
335 IP varchar(39) DEFAULT '' NOT NULL,
336 log_data tinytext NOT NULL,
337 event_pid int(11) DEFAULT '-1' NOT NULL,
338 workspace int(11) DEFAULT '0' NOT NULL,
339 NEWid varchar(20) DEFAULT '' NOT NULL,
340 PRIMARY KEY (uid),
341 KEY event (userid,event_pid)
342 );
343
344 #
345 # Table structure for table 'sys_language'
346 #
347 CREATE TABLE sys_language (
348 uid int(11) unsigned NOT NULL auto_increment,
349 pid int(11) unsigned DEFAULT '0' NOT NULL,
350 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
351 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
352 title varchar(80) DEFAULT '' NOT NULL,
353 flag varchar(20) DEFAULT '' NOT NULL,
354 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
355 PRIMARY KEY (uid),
356 KEY parent (pid)
357 );
358