260c573eedb08fd7c2777a150000bf2e4775840a
[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 'pages'
102 #
103 CREATE TABLE pages (
104 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
105 pid int(11) unsigned DEFAULT '0' NOT NULL,
106 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
107 sorting int(11) unsigned DEFAULT '0' NOT NULL,
108 deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
109 perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
110 perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
111 perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
112 perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
113 perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
114 crdate int(11) unsigned DEFAULT '0' NOT NULL,
115 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
116 title tinytext NOT NULL,
117 doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
118 TSconfig blob NOT NULL,
119 storage_pid int(11) DEFAULT '0' NOT NULL,
120 is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
121 php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
122 tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
123 PRIMARY KEY (uid),
124 KEY parent (pid),
125 );
126
127 #
128 # Table structure for table 'sys_be_shortcuts'
129 #
130 CREATE TABLE sys_be_shortcuts (
131 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
132 userid int(11) unsigned DEFAULT '0' NOT NULL,
133 module_name tinytext NOT NULL,
134 url text NOT NULL,
135 description tinytext NOT NULL,
136 sorting int(11) DEFAULT '0' NOT NULL,
137 sc_group tinyint(4) DEFAULT '0' NOT NULL,
138 PRIMARY KEY (uid),
139 KEY event (userid)
140 );
141
142 #
143 # Table structure for table 'sys_filemounts'
144 #
145 CREATE TABLE sys_filemounts (
146 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
147 pid int(11) unsigned DEFAULT '0' NOT NULL,
148 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
149 title varchar(30) DEFAULT '' NOT NULL,
150 path varchar(120) DEFAULT '' NOT NULL,
151 base tinyint(4) unsigned DEFAULT '0' NOT NULL,
152 hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
153 deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
154 PRIMARY KEY (uid),
155 KEY parent (pid)
156 );
157
158 #
159 # Table structure for table 'sys_history'
160 #
161 CREATE TABLE sys_history (
162 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
163 sys_log_uid int(11) DEFAULT '0' NOT NULL,
164 history_data mediumblob NOT NULL,
165 fieldlist blob NOT NULL,
166 recuid int(11) DEFAULT '0' NOT NULL,
167 tablename varchar(40) DEFAULT '' NOT NULL,
168 tstamp int(11) DEFAULT '0' NOT NULL,
169 history_files mediumblob NOT NULL,
170 snapshot tinyint(4) DEFAULT '0' NOT NULL,
171 PRIMARY KEY (uid),
172 KEY recordident (tablename,recuid),
173 KEY sys_log_uid (sys_log_uid)
174 );
175
176 #
177 # Table structure for table 'sys_lockedrecords'
178 #
179 CREATE TABLE sys_lockedrecords (
180 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
181 userid int(11) unsigned DEFAULT '0' NOT NULL,
182 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
183 record_table varchar(40) DEFAULT '' NOT NULL,
184 record_uid int(11) DEFAULT '0' NOT NULL,
185 record_pid int(11) DEFAULT '0' NOT NULL,
186 username varchar(20) DEFAULT '' NOT NULL,
187 PRIMARY KEY (uid),
188 KEY event (userid,tstamp)
189 );
190
191 #
192 # Table structure for table 'sys_log'
193 #
194 CREATE TABLE sys_log (
195 uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
196 userid int(11) unsigned DEFAULT '0' NOT NULL,
197 action tinyint(4) unsigned DEFAULT '0' NOT NULL,
198 recuid int(11) unsigned DEFAULT '0' NOT NULL,
199 tablename varchar(40) DEFAULT '' NOT NULL,
200 recpid int(11) DEFAULT '0' NOT NULL,
201 error tinyint(4) unsigned DEFAULT '0' NOT NULL,
202 details tinytext NOT NULL,
203 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
204 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
205 details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
206 IP varchar(15) DEFAULT '' NOT NULL,
207 log_data tinyblob NOT NULL,
208 event_pid int(11) DEFAULT '-1' NOT NULL,
209 NEWid varchar(20) DEFAULT '' NOT NULL,
210 PRIMARY KEY (uid),
211 KEY event (userid,event_pid)
212 );
213
214
215
216
217
218