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