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