Best of today...
[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 PRIMARY KEY (ses_id,ses_name)
54 );
55
56 #
57 # Table structure for table 'be_users'
58 #
59 CREATE TABLE be_users (
60 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
61 pid int(11) unsigned DEFAULT '0' NOT NULL,
62 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
63 username varchar(20) DEFAULT '' NOT NULL,
64 password varchar(40) DEFAULT '' NOT NULL,
65 admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
66 usergroup tinyblob NOT NULL,
67 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
68 starttime int(11) unsigned DEFAULT '0' NOT NULL,
69 endtime int(11) unsigned DEFAULT '0' NOT NULL,
70 lang char(2) DEFAULT '' NOT NULL,
71 email varchar(80) DEFAULT '' NOT NULL,
72 db_mountpoints varchar(40) DEFAULT '' NOT NULL,
73 options tinyint(4) unsigned DEFAULT '0' NOT NULL,
74 crdate int(11) unsigned DEFAULT '0' NOT NULL,
75 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
76 realName varchar(80) DEFAULT '' NOT NULL,
77 userMods tinyblob NOT NULL,
78 allowed_languages tinyblob NOT NULL,
79 uc blob NOT NULL,
80 file_mountpoints varchar(40) DEFAULT '' NOT NULL,
81 fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
82 workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
83 lockToDomain varchar(50) DEFAULT '' NOT NULL,
84 disableIPlock tinyint(3) unsigned DEFAULT '0' NOT NULL,
85 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
86 TSconfig blob NOT NULL,
87 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
88 createdByAction int(11) DEFAULT '0' NOT NULL,
89 usergroup_cached_list tinytext NOT NULL,
90 workspace_id int(11) DEFAULT '0' NOT NULL,
91 workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
92 PRIMARY KEY (uid),
93 KEY parent (pid),
94 KEY username (username)
95 );
96
97 #
98 # Table structure for table 'cache_hash'
99 #
100 CREATE TABLE cache_hash (
101 hash varchar(32) DEFAULT '' NOT NULL,
102 content mediumblob NOT NULL,
103 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
104 ident varchar(20) DEFAULT '' NOT NULL,
105 PRIMARY KEY (hash)
106 );
107
108 #
109 # Table structure for table 'cache_imagesizes'
110 #
111 CREATE TABLE cache_imagesizes (
112 md5hash varchar(32) DEFAULT '' NOT NULL,
113 md5filename varchar(32) DEFAULT '' NOT NULL,
114 tstamp int(11) DEFAULT '0' NOT NULL,
115 filename tinytext NOT NULL,
116 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
117 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
118 PRIMARY KEY (md5filename)
119 );
120
121 #
122 # Table structure for table 'pages'
123 #
124 CREATE TABLE pages (
125 uid int(11) DEFAULT '0' NOT NULL auto_increment,
126 pid int(11) 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(30) DEFAULT '' NOT NULL,
131 t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
132 t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
133 t3ver_count int(11) DEFAULT '0' NOT NULL,
134 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
135 t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
136 t3_origuid int(11) DEFAULT '0' NOT NULL,
137 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
138 sorting int(11) unsigned DEFAULT '0' NOT NULL,
139 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
140 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
141 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
142 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
143 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
144 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
145 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
146 crdate int(11) unsigned DEFAULT '0' NOT NULL,
147 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
148 title tinytext NOT NULL,
149 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
150 TSconfig blob NOT NULL,
151 storage_pid int(11) DEFAULT '0' NOT NULL,
152 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
153 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
154 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
155 PRIMARY KEY (uid),
156 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
157 KEY parent (pid)
158 );
159
160 #
161 # Table structure for table 'sys_be_shortcuts'
162 #
163 CREATE TABLE sys_be_shortcuts (
164 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
165 userid int(11) unsigned DEFAULT '0' NOT NULL,
166 module_name tinytext NOT NULL,
167 url text NOT NULL,
168 description tinytext NOT NULL,
169 sorting int(11) DEFAULT '0' NOT NULL,
170 sc_group tinyint(4) DEFAULT '0' NOT NULL,
171 PRIMARY KEY (uid),
172 KEY event (userid)
173 );
174
175 #
176 # Table structure for table 'sys_filemounts'
177 #
178 CREATE TABLE sys_filemounts (
179 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
180 pid int(11) unsigned DEFAULT '0' NOT NULL,
181 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
182 title varchar(30) DEFAULT '' NOT NULL,
183 path varchar(120) DEFAULT '' NOT NULL,
184 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
185 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
186 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
187 PRIMARY KEY (uid),
188 KEY parent (pid)
189 );
190
191 #
192 # Table structure for table 'sys_workspace'
193 #
194 CREATE TABLE sys_workspace (
195 uid int(11) NOT NULL auto_increment,
196 pid int(11) DEFAULT '0' NOT NULL,
197 tstamp int(11) DEFAULT '0' NOT NULL,
198 deleted tinyint(3) DEFAULT '0' NOT NULL,
199 title varchar(30) DEFAULT '' NOT NULL,
200 description tinytext NOT NULL,
201 adminusers tinytext NOT NULL,
202 members text NOT NULL,
203 reviewers text NOT NULL,
204 db_mountpoints tinytext NOT NULL,
205 file_mountpoints tinytext NOT NULL,
206 publish_time int(11) DEFAULT '0' NOT NULL,
207 unpublish_time int(11) DEFAULT '0' NOT NULL,
208 freeze tinyint(3) DEFAULT '0' NOT NULL,
209 live_edit tinyint(3) DEFAULT '0' NOT NULL,
210 vtypes tinyint(3) DEFAULT '0' NOT NULL,
211 disable_autocreate tinyint(3) DEFAULT '0' NOT NULL,
212 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
213 publish_access tinyint(3) DEFAULT '0' NOT NULL,
214 stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
215
216 PRIMARY KEY (uid),
217 KEY parent (pid)
218 );
219
220 #
221 # Table structure for table 'sys_history'
222 #
223 CREATE TABLE sys_history (
224 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
225 sys_log_uid int(11) DEFAULT '0' NOT NULL,
226 history_data mediumblob NOT NULL,
227 fieldlist blob NOT NULL,
228 recuid int(11) DEFAULT '0' NOT NULL,
229 tablename varchar(40) DEFAULT '' NOT NULL,
230 tstamp int(11) DEFAULT '0' NOT NULL,
231 history_files mediumblob NOT NULL,
232 snapshot tinyint(4) DEFAULT '0' NOT NULL,
233 PRIMARY KEY (uid),
234 KEY recordident (tablename,recuid),
235 KEY sys_log_uid (sys_log_uid)
236 );
237
238 #
239 # Table structure for table 'sys_lockedrecords'
240 #
241 CREATE TABLE sys_lockedrecords (
242 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
243 userid int(11) unsigned DEFAULT '0' NOT NULL,
244 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
245 record_table varchar(40) DEFAULT '' NOT NULL,
246 record_uid int(11) DEFAULT '0' NOT NULL,
247 record_pid int(11) DEFAULT '0' NOT NULL,
248 username varchar(20) DEFAULT '' NOT NULL,
249 PRIMARY KEY (uid),
250 KEY event (userid,tstamp)
251 );
252
253 #
254 # Table structure for table 'sys_log'
255 #
256 CREATE TABLE sys_log (
257 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
258 userid int(11) unsigned DEFAULT '0' NOT NULL,
259 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
260 recuid int(11) unsigned DEFAULT '0' NOT NULL,
261 tablename varchar(40) DEFAULT '' NOT NULL,
262 recpid int(11) DEFAULT '0' NOT NULL,
263 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
264 details tinytext NOT NULL,
265 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
266 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
267 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
268 IP varchar(39) DEFAULT '' NOT NULL,
269 log_data tinyblob NOT NULL,
270 event_pid int(11) DEFAULT '-1' NOT NULL,
271 workspace int(11) DEFAULT '0' NOT NULL,
272 NEWid varchar(20) DEFAULT '' NOT NULL,
273 PRIMARY KEY (uid),
274 KEY event (userid,event_pid)
275 );
276
277 #
278 # Table structure for table 'sys_language'
279 #
280 CREATE TABLE sys_language (
281 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
282 pid int(11) unsigned DEFAULT '0' NOT NULL,
283 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
284 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
285 title varchar(80) DEFAULT '' NOT NULL,
286 flag varchar(20) DEFAULT '' NOT NULL,
287 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
288 PRIMARY KEY (uid),
289 KEY parent (pid)
290 );
291