* Added reference index table and class. See mail sent to Dev-list
[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 DEFAULT '0' 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 blob NOT NULL,
18 explicit_allowdeny blob NOT NULL,
19 allowed_languages tinyblob NOT NULL,
20 custom_options blob NOT NULL,
21 db_mountpoints varchar(40) DEFAULT '' NOT NULL,
22 pagetypes_select tinyblob NOT NULL,
23 tables_select blob NOT NULL,
24 tables_modify blob NOT NULL,
25 crdate int(11) unsigned DEFAULT '0' NOT NULL,
26 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
27 groupMods tinyblob NOT NULL,
28 file_mountpoints varchar(40) DEFAULT '' NOT NULL,
29 hidden tinyint(3) 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(3) unsigned DEFAULT '0' NOT NULL,
34 TSconfig blob NOT NULL,
35 subgroup tinyblob 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 mediumblob 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 DEFAULT '0' 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 tinyblob NOT NULL,
68 disable tinyint(4) 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 char(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 tinyblob NOT NULL,
79 allowed_languages tinyblob NOT NULL,
80 uc blob 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(3) unsigned DEFAULT '0' NOT NULL,
86 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
87 TSconfig blob 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 mediumblob 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) DEFAULT '0' 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(4) 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 blob 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 DEFAULT '0' 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 # Table structure for table 'sys_filemounts'
178 #
179 CREATE TABLE sys_filemounts (
180 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
181 pid int(11) unsigned DEFAULT '0' NOT NULL,
182 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
183 title varchar(30) DEFAULT '' NOT NULL,
184 path varchar(120) DEFAULT '' NOT NULL,
185 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
186 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
187 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
188 PRIMARY KEY (uid),
189 KEY parent (pid)
190 );
191
192 #
193 # Table structure for table 'sys_workspace'
194 #
195 CREATE TABLE sys_workspace (
196 uid int(11) NOT NULL auto_increment,
197 pid int(11) DEFAULT '0' NOT NULL,
198 tstamp int(11) DEFAULT '0' NOT NULL,
199 deleted tinyint(3) DEFAULT '0' NOT NULL,
200 title varchar(30) DEFAULT '' NOT NULL,
201 description tinytext NOT NULL,
202 adminusers tinytext NOT NULL,
203 members text NOT NULL,
204 reviewers text NOT NULL,
205 db_mountpoints tinytext NOT NULL,
206 file_mountpoints tinytext NOT NULL,
207 publish_time int(11) DEFAULT '0' NOT NULL,
208 unpublish_time int(11) DEFAULT '0' NOT NULL,
209 freeze tinyint(3) DEFAULT '0' NOT NULL,
210 live_edit tinyint(3) DEFAULT '0' NOT NULL,
211 vtypes tinyint(3) DEFAULT '0' NOT NULL,
212 disable_autocreate tinyint(3) DEFAULT '0' NOT NULL,
213 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
214 publish_access tinyint(3) DEFAULT '0' NOT NULL,
215 stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
216
217 PRIMARY KEY (uid),
218 KEY parent (pid)
219 );
220
221 #
222 # Table structure for table 'sys_history'
223 #
224 CREATE TABLE sys_history (
225 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
226 sys_log_uid int(11) DEFAULT '0' NOT NULL,
227 history_data mediumblob NOT NULL,
228 fieldlist blob NOT NULL,
229 recuid int(11) DEFAULT '0' NOT NULL,
230 tablename varchar(40) DEFAULT '' NOT NULL,
231 tstamp int(11) DEFAULT '0' NOT NULL,
232 history_files mediumblob NOT NULL,
233 snapshot tinyint(4) DEFAULT '0' NOT NULL,
234 PRIMARY KEY (uid),
235 KEY recordident (tablename,recuid),
236 KEY sys_log_uid (sys_log_uid)
237 );
238
239 #
240 # Table structure for table 'sys_lockedrecords'
241 #
242 CREATE TABLE sys_lockedrecords (
243 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
244 userid int(11) unsigned DEFAULT '0' NOT NULL,
245 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
246 record_table varchar(40) DEFAULT '' NOT NULL,
247 record_uid int(11) DEFAULT '0' NOT NULL,
248 record_pid int(11) DEFAULT '0' NOT NULL,
249 username varchar(20) DEFAULT '' NOT NULL,
250 PRIMARY KEY (uid),
251 KEY event (userid,tstamp)
252 );
253
254 #
255 # Table structure for table 'sys_refindex'
256 #
257 CREATE TABLE sys_refindex (
258 hash varchar(32) DEFAULT '' NOT NULL,
259 tablename varchar(40) DEFAULT '' NOT NULL,
260 recuid int(11) DEFAULT '0' NOT NULL,
261 field varchar(40) DEFAULT '' NOT NULL,
262 flexpointer tinytext NOT NULL,
263 softref_key varchar(30) DEFAULT '' NOT NULL,
264 softref_id varchar(40) DEFAULT '' NOT NULL,
265 sorting int(11) DEFAULT '0' NOT NULL,
266 ref_table varchar(40) DEFAULT '' NOT NULL,
267 ref_uid int(11) DEFAULT '0' NOT NULL,
268 ref_string varchar(40) DEFAULT '' NOT NULL,
269
270 PRIMARY KEY (hash),
271 KEY lookup_rec (tablename,recuid),
272 KEY lookup_uid (ref_table,ref_uid),
273 KEY lookup_string (ref_table,ref_string)
274 );
275
276 #
277 # Table structure for table 'sys_log'
278 #
279 CREATE TABLE sys_log (
280 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
281 userid int(11) unsigned DEFAULT '0' NOT NULL,
282 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
283 recuid int(11) unsigned DEFAULT '0' NOT NULL,
284 tablename varchar(40) DEFAULT '' NOT NULL,
285 recpid int(11) DEFAULT '0' NOT NULL,
286 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
287 details tinytext NOT NULL,
288 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
289 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
290 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
291 IP varchar(39) DEFAULT '' NOT NULL,
292 log_data tinyblob NOT NULL,
293 event_pid int(11) DEFAULT '-1' NOT NULL,
294 workspace int(11) DEFAULT '0' NOT NULL,
295 NEWid varchar(20) DEFAULT '' NOT NULL,
296 PRIMARY KEY (uid),
297 KEY event (userid,event_pid)
298 );
299
300 #
301 # Table structure for table 'sys_language'
302 #
303 CREATE TABLE sys_language (
304 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
305 pid int(11) unsigned DEFAULT '0' NOT NULL,
306 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
307 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
308 title varchar(80) DEFAULT '' NOT NULL,
309 flag varchar(20) DEFAULT '' NOT NULL,
310 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
311 PRIMARY KEY (uid),
312 KEY parent (pid)
313 );
314