See changelog
[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 PRIMARY KEY (uid),
38 KEY parent (pid)
39 );
40
41 #
42 # Table structure for table 'be_sessions'
43 #
44 CREATE TABLE be_sessions (
45 ses_id varchar(32) DEFAULT '' NOT NULL,
46 ses_name varchar(32) DEFAULT '' NOT NULL,
47 ses_iplock varchar(39) DEFAULT '' NOT NULL,
48 ses_hashlock int(11) DEFAULT '0' NOT NULL,
49 ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
50 ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
51 ses_data mediumblob NOT NULL,
52 PRIMARY KEY (ses_id,ses_name)
53 );
54
55 #
56 # Table structure for table 'be_users'
57 #
58 CREATE TABLE be_users (
59 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
60 pid int(11) unsigned DEFAULT '0' NOT NULL,
61 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
62 username varchar(20) DEFAULT '' NOT NULL,
63 password varchar(40) DEFAULT '' NOT NULL,
64 admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
65 usergroup tinyblob NOT NULL,
66 disable tinyint(4) unsigned DEFAULT '0' NOT NULL,
67 starttime int(11) unsigned DEFAULT '0' NOT NULL,
68 endtime int(11) unsigned DEFAULT '0' NOT NULL,
69 lang char(2) DEFAULT '' NOT NULL,
70 email varchar(80) DEFAULT '' NOT NULL,
71 db_mountpoints varchar(40) DEFAULT '' NOT NULL,
72 options tinyint(4) unsigned DEFAULT '0' NOT NULL,
73 crdate int(11) unsigned DEFAULT '0' NOT NULL,
74 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
75 realName varchar(80) DEFAULT '' NOT NULL,
76 userMods tinyblob NOT NULL,
77 allowed_languages tinyblob NOT NULL,
78 uc blob NOT NULL,
79 file_mountpoints varchar(40) DEFAULT '' NOT NULL,
80 fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
81 lockToDomain varchar(50) DEFAULT '' NOT NULL,
82 disableIPlock tinyint(3) unsigned DEFAULT '0' NOT NULL,
83 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
84 TSconfig blob NOT NULL,
85 lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
86 createdByAction int(11) DEFAULT '0' NOT NULL,
87 usergroup_cached_list tinytext NOT NULL,
88 PRIMARY KEY (uid),
89 KEY parent (pid),
90 KEY username (username)
91 );
92
93 #
94 # Table structure for table 'cache_hash'
95 #
96 CREATE TABLE cache_hash (
97 hash varchar(32) DEFAULT '' NOT NULL,
98 content mediumblob NOT NULL,
99 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
100 ident varchar(20) DEFAULT '' NOT NULL,
101 PRIMARY KEY (hash)
102 );
103
104 #
105 # Table structure for table 'cache_imagesizes'
106 #
107 CREATE TABLE cache_imagesizes (
108 md5hash varchar(32) DEFAULT '' NOT NULL,
109 md5filename varchar(32) DEFAULT '' NOT NULL,
110 tstamp int(11) DEFAULT '0' NOT NULL,
111 filename tinytext NOT NULL,
112 imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
113 imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
114 PRIMARY KEY (md5filename)
115 );
116
117 #
118 # Table structure for table 'pages'
119 #
120 CREATE TABLE pages (
121 uid int(11) DEFAULT '0' NOT NULL auto_increment,
122 pid int(11) DEFAULT '0' NOT NULL,
123 t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
124 t3ver_id int(11) unsigned DEFAULT '0' NOT NULL,
125 t3ver_label varchar(30) DEFAULT '' NOT NULL,
126 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
127 sorting int(11) unsigned DEFAULT '0' NOT NULL,
128 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
129 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
130 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
131 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
132 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
133 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
134 editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
135 crdate int(11) unsigned DEFAULT '0' NOT NULL,
136 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
137 title tinytext NOT NULL,
138 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
139 TSconfig blob NOT NULL,
140 storage_pid int(11) DEFAULT '0' NOT NULL,
141 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
142 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
143 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
144 PRIMARY KEY (uid),
145 KEY t3ver_oid (t3ver_oid),
146 KEY parent (pid)
147 );
148
149 #
150 # Table structure for table 'sys_be_shortcuts'
151 #
152 CREATE TABLE sys_be_shortcuts (
153 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
154 userid int(11) unsigned DEFAULT '0' NOT NULL,
155 module_name tinytext NOT NULL,
156 url text NOT NULL,
157 description tinytext NOT NULL,
158 sorting int(11) DEFAULT '0' NOT NULL,
159 sc_group tinyint(4) DEFAULT '0' NOT NULL,
160 PRIMARY KEY (uid),
161 KEY event (userid)
162 );
163
164 #
165 # Table structure for table 'sys_filemounts'
166 #
167 CREATE TABLE sys_filemounts (
168 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
169 pid int(11) unsigned DEFAULT '0' NOT NULL,
170 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
171 title varchar(30) DEFAULT '' NOT NULL,
172 path varchar(120) DEFAULT '' NOT NULL,
173 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
174 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
175 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
176 PRIMARY KEY (uid),
177 KEY parent (pid)
178 );
179
180 #
181 # Table structure for table 'sys_history'
182 #
183 CREATE TABLE sys_history (
184 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
185 sys_log_uid int(11) DEFAULT '0' NOT NULL,
186 history_data mediumblob NOT NULL,
187 fieldlist blob NOT NULL,
188 recuid int(11) DEFAULT '0' NOT NULL,
189 tablename varchar(40) DEFAULT '' NOT NULL,
190 tstamp int(11) DEFAULT '0' NOT NULL,
191 history_files mediumblob NOT NULL,
192 snapshot tinyint(4) DEFAULT '0' NOT NULL,
193 PRIMARY KEY (uid),
194 KEY recordident (tablename,recuid),
195 KEY sys_log_uid (sys_log_uid)
196 );
197
198 #
199 # Table structure for table 'sys_lockedrecords'
200 #
201 CREATE TABLE sys_lockedrecords (
202 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
203 userid int(11) unsigned DEFAULT '0' NOT NULL,
204 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
205 record_table varchar(40) DEFAULT '' NOT NULL,
206 record_uid int(11) DEFAULT '0' NOT NULL,
207 record_pid int(11) DEFAULT '0' NOT NULL,
208 username varchar(20) DEFAULT '' NOT NULL,
209 PRIMARY KEY (uid),
210 KEY event (userid,tstamp)
211 );
212
213 #
214 # Table structure for table 'sys_log'
215 #
216 CREATE TABLE sys_log (
217 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
218 userid int(11) unsigned DEFAULT '0' NOT NULL,
219 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
220 recuid int(11) unsigned DEFAULT '0' NOT NULL,
221 tablename varchar(40) DEFAULT '' NOT NULL,
222 recpid int(11) DEFAULT '0' NOT NULL,
223 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
224 details tinytext NOT NULL,
225 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
226 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
227 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
228 IP varchar(39) DEFAULT '' NOT NULL,
229 log_data tinyblob NOT NULL,
230 event_pid int(11) DEFAULT '-1' NOT NULL,
231 NEWid varchar(20) DEFAULT '' NOT NULL,
232 PRIMARY KEY (uid),
233 KEY event (userid,event_pid)
234 );
235
236 #
237 # Table structure for table 'sys_language'
238 #
239 CREATE TABLE sys_language (
240 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
241 pid int(11) unsigned DEFAULT '0' NOT NULL,
242 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
243 hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
244 title varchar(80) DEFAULT '' NOT NULL,
245 flag varchar(20) DEFAULT '' NOT NULL,
246 static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
247 PRIMARY KEY (uid),
248 KEY parent (pid)
249 );
250