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