tables.sql 7.49 KB
Newer Older
Kasper Skårhøj's avatar
Kasper Skårhøj committed
1
2
3
4
5
# MySQL dump 6.4
#
# Host: localhost    Database: t3_testsite
#--------------------------------------------------------
# Server version	3.22.27
6
7
#
# TYPO3 CVS ID: $Id$
Kasper Skårhøj's avatar
Kasper Skårhøj committed
8
9
10
11
12

#
# Table structure for table 'be_groups'
#
CREATE TABLE be_groups (
13
14
15
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
16
17
  title varchar(20) DEFAULT '' NOT NULL,
  non_exclude_fields blob NOT NULL,
18
19
20
  explicit_allowdeny blob NOT NULL,
  allowed_languages tinyblob NOT NULL,
  custom_options blob NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
21
22
23
24
  db_mountpoints varchar(40) DEFAULT '' NOT NULL,
  pagetypes_select tinyblob NOT NULL,
  tables_select blob NOT NULL,
  tables_modify blob NOT NULL,
25
26
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
27
28
  groupMods tinyblob NOT NULL,
  file_mountpoints varchar(40) DEFAULT '' NOT NULL,
29
30
  hidden tinyint(3) DEFAULT '0' NOT NULL,
  inc_access_lists tinyint(3) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
31
32
  description text NOT NULL,
  lockToDomain varchar(50) DEFAULT '' NOT NULL,
33
  deleted tinyint(3) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
34
35
36
37
38
39
40
41
42
43
44
45
46
  TSconfig blob NOT NULL,
  subgroup tinyblob NOT NULL,
  hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
  PRIMARY KEY (uid),
  KEY parent (pid)
);

#
# Table structure for table 'be_sessions'
#
CREATE TABLE be_sessions (
  ses_id varchar(32) DEFAULT '' NOT NULL,
  ses_name varchar(32) DEFAULT '' NOT NULL,
47
  ses_iplock varchar(39) DEFAULT '' NOT NULL,
Kasper Skårhøj's avatar
   
Kasper Skårhøj committed
48
  ses_hashlock int(11) DEFAULT '0' NOT NULL,
49
50
  ses_userid int(11) DEFAULT '0' NOT NULL,
  ses_tstamp int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
51
  ses_data mediumblob NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
52
53
54
55
56
57
58
  PRIMARY KEY (ses_id,ses_name)
);

#
# Table structure for table 'be_users'
#
CREATE TABLE be_users (
59
60
61
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
62
63
  username varchar(20) DEFAULT '' NOT NULL,
  password varchar(40) DEFAULT '' NOT NULL,
64
  admin tinyint(4) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
65
  usergroup tinyblob NOT NULL,
66
67
68
  disable tinyint(4) DEFAULT '0' NOT NULL,
  starttime int(11) DEFAULT '0' NOT NULL,
  endtime int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
69
70
71
  lang char(2) DEFAULT '' NOT NULL,
  email varchar(80) DEFAULT '' NOT NULL,
  db_mountpoints varchar(40) DEFAULT '' NOT NULL,
72
73
74
  options tinyint(4) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
75
76
  realName varchar(80) DEFAULT '' NOT NULL,
  userMods tinyblob NOT NULL,
77
  allowed_languages tinyblob NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
78
79
80
81
  uc blob NOT NULL,
  file_mountpoints varchar(40) DEFAULT '' NOT NULL,
  fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
  lockToDomain varchar(50) DEFAULT '' NOT NULL,
82
83
  disableIPlock tinyint(3) DEFAULT '0' NOT NULL,
  deleted tinyint(3) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
84
  TSconfig blob NOT NULL,
85
  lastlogin int(10) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
86
87
88
89
90
91
92
93
94
95
96
97
98
  createdByAction int(11) DEFAULT '0' NOT NULL,
  usergroup_cached_list tinytext NOT NULL,
  PRIMARY KEY (uid),
  KEY parent (pid),
  KEY username (username)
);

#
# Table structure for table 'cache_hash'
#
CREATE TABLE cache_hash (
  hash varchar(32) DEFAULT '' NOT NULL,
  content mediumblob NOT NULL,
99
  tstamp int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
100
101
102
103
  ident varchar(20) DEFAULT '' NOT NULL,
  PRIMARY KEY (hash)
);

Kasper Skårhøj's avatar
   
Kasper Skårhøj committed
104
105
106
107
108
109
110
111
#
# Table structure for table 'cache_imagesizes'
#
CREATE TABLE cache_imagesizes (
  md5hash varchar(32) DEFAULT '' NOT NULL,
  md5filename varchar(32) DEFAULT '' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  filename tinytext NOT NULL,
112
113
  imagewidth mediumint(11) DEFAULT '0' NOT NULL,
  imageheight mediumint(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
   
Kasper Skårhøj committed
114
115
116
  PRIMARY KEY (md5filename)
);

Kasper Skårhøj's avatar
Kasper Skårhøj committed
117
118
119
120
#
# Table structure for table 'pages'
#
CREATE TABLE pages (
121
122
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
123
124
  t3ver_oid int(11) DEFAULT '0' NOT NULL,
  t3ver_id int(11) DEFAULT '0' NOT NULL,
125
  t3ver_label varchar(30) DEFAULT '' NOT NULL,
126
127
128
129
130
131
132
133
134
135
136
  tstamp int(11) DEFAULT '0' NOT NULL,
  sorting int(11) DEFAULT '0' NOT NULL,
  deleted tinyint(4) DEFAULT '0' NOT NULL,
  perms_userid int(11) DEFAULT '0' NOT NULL,
  perms_groupid int(11) DEFAULT '0' NOT NULL,
  perms_user tinyint(4) DEFAULT '0' NOT NULL,
  perms_group tinyint(4) DEFAULT '0' NOT NULL,
  perms_everybody tinyint(4) DEFAULT '0' NOT NULL,
  editlock tinyint(4) DEFAULT '0' NOT NULL,
  crdate int(11) DEFAULT '0' NOT NULL,
  cruser_id int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
137
  title tinytext NOT NULL,
138
  doktype tinyint(3) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
139
140
141
142
143
144
  TSconfig blob NOT NULL,
  storage_pid int(11) DEFAULT '0' NOT NULL,
  is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
  php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
  tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (uid),
145
  KEY t3ver_oid (t3ver_oid),
146
  KEY parent (pid)
Kasper Skårhøj's avatar
Kasper Skårhøj committed
147
148
149
150
151
152
);

#
# Table structure for table 'sys_be_shortcuts'
#
CREATE TABLE sys_be_shortcuts (
153
154
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  userid int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
155
156
157
158
159
160
161
162
163
164
165
166
167
  module_name tinytext NOT NULL,
  url text NOT NULL,
  description tinytext NOT NULL,
  sorting int(11) DEFAULT '0' NOT NULL,
  sc_group tinyint(4) DEFAULT '0' NOT NULL,
  PRIMARY KEY (uid),
  KEY event (userid)
);

#
# Table structure for table 'sys_filemounts'
#
CREATE TABLE sys_filemounts (
168
169
170
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
171
172
  title varchar(30) DEFAULT '' NOT NULL,
  path varchar(120) DEFAULT '' NOT NULL,
173
174
175
  base tinyint(4) DEFAULT '0' NOT NULL,
  hidden tinyint(3) DEFAULT '0' NOT NULL,
  deleted tinyint(3) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
176
177
178
179
180
181
182
183
  PRIMARY KEY (uid),
  KEY parent (pid)
);

#
# Table structure for table 'sys_history'
#
CREATE TABLE sys_history (
184
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
  sys_log_uid int(11) DEFAULT '0' NOT NULL,
  history_data mediumblob NOT NULL,
  fieldlist blob NOT NULL,
  recuid int(11) DEFAULT '0' NOT NULL,
  tablename varchar(40) DEFAULT '' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  history_files mediumblob NOT NULL,
  snapshot tinyint(4) DEFAULT '0' NOT NULL,
  PRIMARY KEY (uid),
  KEY recordident (tablename,recuid),
  KEY sys_log_uid (sys_log_uid)
);

#
# Table structure for table 'sys_lockedrecords'
#
CREATE TABLE sys_lockedrecords (
202
203
204
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  userid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
205
206
207
208
209
210
211
212
213
214
215
216
  record_table varchar(40) DEFAULT '' NOT NULL,
  record_uid int(11) DEFAULT '0' NOT NULL,
  record_pid int(11) DEFAULT '0' NOT NULL,
  username varchar(20) DEFAULT '' NOT NULL,
  PRIMARY KEY (uid),
  KEY event (userid,tstamp)
);

#
# Table structure for table 'sys_log'
#
CREATE TABLE sys_log (
217
218
219
220
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  userid int(11) DEFAULT '0' NOT NULL,
  action tinyint(4) DEFAULT '0' NOT NULL,
  recuid int(11) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
221
222
  tablename varchar(40) DEFAULT '' NOT NULL,
  recpid int(11) DEFAULT '0' NOT NULL,
223
  error tinyint(4) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
224
  details tinytext NOT NULL,
225
226
227
  tstamp int(11) DEFAULT '0' NOT NULL,
  type tinyint(3) DEFAULT '0' NOT NULL,
  details_nr tinyint(3) DEFAULT '0' NOT NULL,
Kasper Skårhøj's avatar
   
Kasper Skårhøj committed
228
  IP varchar(39) DEFAULT '' NOT NULL,
Kasper Skårhøj's avatar
Kasper Skårhøj committed
229
230
231
232
233
234
235
  log_data tinyblob NOT NULL,
  event_pid int(11) DEFAULT '-1' NOT NULL,
  NEWid varchar(20) DEFAULT '' NOT NULL,
  PRIMARY KEY (uid),
  KEY event (userid,event_pid)
);

236
237
238
239
#
# Table structure for table 'sys_language'
#
CREATE TABLE sys_language (
240
241
242
243
  uid int(11) DEFAULT '0' NOT NULL auto_increment,
  pid int(11) DEFAULT '0' NOT NULL,
  tstamp int(11) DEFAULT '0' NOT NULL,
  hidden tinyint(4) DEFAULT '0' NOT NULL,
244
245
  title varchar(80) DEFAULT '' NOT NULL,
  flag varchar(20) DEFAULT '' NOT NULL,
246
  static_lang_isocode int(11) DEFAULT '0' NOT NULL,
247
248
249
  PRIMARY KEY (uid),
  KEY parent (pid)
);
Kasper Skårhøj's avatar
Kasper Skårhøj committed
250