Added initial support for workspaces in core.
[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_count int(11) DEFAULT '0' NOT NULL,
133 t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
134 t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
135 t3_origuid int(11) DEFAULT '0' NOT NULL,
136 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
137 sorting int(11) unsigned DEFAULT '0' NOT NULL,
138 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
139 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
140 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
141 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
142 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
143 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
144 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
145 crdate int(11) unsigned DEFAULT '0' NOT NULL,
146 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
147 title tinytext NOT NULL,
148 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
149 TSconfig blob NOT NULL,
150 storage_pid int(11) DEFAULT '0' NOT NULL,
151 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
152 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
153 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
154 PRIMARY KEY (uid),
155 KEY t3ver_oid (t3ver_oid,t3ver_wsid),
156 KEY parent (pid)
157 );
158
159 #
160 # Table structure for table 'sys_be_shortcuts'
161 #
162 CREATE TABLE sys_be_shortcuts (
163 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
164 userid int(11) unsigned DEFAULT '0' NOT NULL,
165 module_name tinytext NOT NULL,
166 url text NOT NULL,
167 description tinytext NOT NULL,
168 sorting int(11) DEFAULT '0' NOT NULL,
169 sc_group tinyint(4) DEFAULT '0' NOT NULL,
170 PRIMARY KEY (uid),
171 KEY event (userid)
172 );
173
174 #
175 # Table structure for table 'sys_filemounts'
176 #
177 CREATE TABLE sys_filemounts (
178 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
179 pid int(11) unsigned DEFAULT '0' NOT NULL,
180 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
181 title varchar(30) DEFAULT '' NOT NULL,
182 path varchar(120) DEFAULT '' NOT NULL,
183 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
184 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
185 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
186 PRIMARY KEY (uid),
187 KEY parent (pid)
188 );
189
190 #
191 # Table structure for table 'sys_workspace'
192 #
193 CREATE TABLE sys_workspace (
194 uid int(11) NOT NULL auto_increment,
195 pid int(11) DEFAULT '0' NOT NULL,
196 tstamp int(11) DEFAULT '0' NOT NULL,
197 deleted tinyint(3) DEFAULT '0' NOT NULL,
198 title varchar(30) DEFAULT '' NOT NULL,
199 description tinytext NOT NULL,
200 adminusers tinytext NOT NULL,
201 members text NOT NULL,
202 reviewers text NOT NULL,
203 db_mountpoints tinytext NOT NULL,
204 file_mountpoints tinytext NOT NULL,
205 publish_time int(11) DEFAULT '0' NOT NULL,
206 unpublish_time int(11) DEFAULT '0' NOT NULL,
207 freeze tinyint(3) DEFAULT '0' NOT NULL,
208 live_edit tinyint(3) DEFAULT '0' NOT NULL,
209 disable_autocreate tinyint(3) DEFAULT '0' NOT NULL,
210 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
211
212 PRIMARY KEY (uid),
213 KEY parent (pid)
214 );
215
216 #
217 # Table structure for table 'sys_history'
218 #
219 CREATE TABLE sys_history (
220 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
221 sys_log_uid int(11) DEFAULT '0' NOT NULL,
222 history_data mediumblob NOT NULL,
223 fieldlist blob NOT NULL,
224 recuid int(11) DEFAULT '0' NOT NULL,
225 tablename varchar(40) DEFAULT '' NOT NULL,
226 tstamp int(11) DEFAULT '0' NOT NULL,
227 history_files mediumblob NOT NULL,
228 snapshot tinyint(4) DEFAULT '0' NOT NULL,
229 PRIMARY KEY (uid),
230 KEY recordident (tablename,recuid),
231 KEY sys_log_uid (sys_log_uid)
232 );
233
234 #
235 # Table structure for table 'sys_lockedrecords'
236 #
237 CREATE TABLE sys_lockedrecords (
238 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
239 userid int(11) unsigned DEFAULT '0' NOT NULL,
240 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
241 record_table varchar(40) DEFAULT '' NOT NULL,
242 record_uid int(11) DEFAULT '0' NOT NULL,
243 record_pid int(11) DEFAULT '0' NOT NULL,
244 username varchar(20) DEFAULT '' NOT NULL,
245 PRIMARY KEY (uid),
246 KEY event (userid,tstamp)
247 );
248
249 #
250 # Table structure for table 'sys_log'
251 #
252 CREATE TABLE sys_log (
253 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
254 userid int(11) unsigned DEFAULT '0' NOT NULL,
255 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
256 recuid int(11) unsigned DEFAULT '0' NOT NULL,
257 tablename varchar(40) DEFAULT '' NOT NULL,
258 recpid int(11) DEFAULT '0' NOT NULL,
259 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
260 details tinytext NOT NULL,
261 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
262 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
263 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
264 IP varchar(39) DEFAULT '' NOT NULL,
265 log_data tinyblob NOT NULL,
266 event_pid int(11) DEFAULT '-1' NOT NULL,
267 NEWid varchar(20) DEFAULT '' NOT NULL,
268 PRIMARY KEY (uid),
269 KEY event (userid,event_pid)
270 );
271
272 #
273 # Table structure for table 'sys_language'
274 #
275 CREATE TABLE sys_language (
276 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
277 pid int(11) unsigned DEFAULT '0' NOT NULL,
278 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
279 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
280 title varchar(80) DEFAULT '' NOT NULL,
281 flag varchar(20) DEFAULT '' NOT NULL,
282 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
283 PRIMARY KEY (uid),
284 KEY parent (pid)
285 );
286