database.mysql 10 KB
Newer Older
1
# MySQL dump 8.14
Dries's avatar
   
Dries committed
2
#
3
# Host: localhost    Database: drupal
Dries's avatar
   
Dries committed
4
#--------------------------------------------------------
Dries's avatar
   
Dries committed
5
# Server version  3.23.38
Dries's avatar
   
Dries committed
6
7
8
9

#
# Table structure for table 'access'
#
10

Dries's avatar
   
Dries committed
11
CREATE TABLE access (
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  aid tinyint(10) NOT NULL auto_increment,
  mask varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  status tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (aid),
  UNIQUE KEY mask (mask)
) TYPE=MyISAM;

#
# Table structure for table 'authmap'
#

CREATE TABLE authmap (
  aid int(10) unsigned NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  authname varchar(128) NOT NULL default '',
  module varchar(128) NOT NULL default '',
  PRIMARY KEY  (aid),
  UNIQUE KEY authname (authname)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
32

Dries's avatar
   
Dries committed
33
34
35
#
# Table structure for table 'blocks'
#
36

Dries's avatar
   
Dries committed
37
CREATE TABLE blocks (
38
39
40
41
42
43
44
45
46
47
  name varchar(64) NOT NULL default '',
  module varchar(64) NOT NULL default '',
  delta tinyint(2) NOT NULL default '0',
  status tinyint(2) NOT NULL default '0',
  weight tinyint(1) NOT NULL default '0',
  region tinyint(1) NOT NULL default '0',
  remove tinyint(1) NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  PRIMARY KEY  (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
48

Dries's avatar
   
Dries committed
49
50
51
#
# Table structure for table 'book'
#
52

Dries's avatar
   
Dries committed
53
CREATE TABLE book (
54
55
56
57
58
59
60
  nid int(10) unsigned NOT NULL default '0',
  parent int(10) NOT NULL default '0',
  weight tinyint(3) NOT NULL default '0',
  format tinyint(2) default '0',
  PRIMARY KEY  (nid),
  KEY nid (nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
61

Dries's avatar
   
Dries committed
62
63
64
#
# Table structure for table 'boxes'
#
65

Dries's avatar
   
Dries committed
66
CREATE TABLE boxes (
67
68
  bid tinyint(4) NOT NULL auto_increment,
  title varchar(64) NOT NULL default '',
Dries's avatar
   
Dries committed
69
  body text,
70
71
72
73
74
75
  info varchar(128) NOT NULL default '',
  type tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (bid),
  UNIQUE KEY info (info),
  UNIQUE KEY subject (title)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
76

Dries's avatar
   
Dries committed
77
78
79
#
# Table structure for table 'bundle'
#
80

Dries's avatar
   
Dries committed
81
CREATE TABLE bundle (
82
83
84
85
86
87
  bid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  attributes varchar(255) NOT NULL default '',
  PRIMARY KEY  (bid),
  UNIQUE KEY title (title)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
88

Dries's avatar
   
Dries committed
89
90
91
#
# Table structure for table 'cache'
#
92

Dries's avatar
   
Dries committed
93
CREATE TABLE cache (
94
  cid varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
95
  data text NOT NULL,
96
97
98
  expire int(11) NOT NULL default '0',
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
99

Dries's avatar
   
Dries committed
100
101
102
#
# Table structure for table 'collection'
#
103

Dries's avatar
   
Dries committed
104
CREATE TABLE collection (
105
106
107
108
109
110
  cid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  types varchar(128) NOT NULL default '',
  PRIMARY KEY  (cid),
  UNIQUE KEY name (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
111

Dries's avatar
   
Dries committed
112
113
114
#
# Table structure for table 'comments'
#
115

Dries's avatar
   
Dries committed
116
CREATE TABLE comments (
117
118
119
120
121
  cid int(10) NOT NULL auto_increment,
  pid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  subject varchar(64) NOT NULL default '',
Dries's avatar
   
Dries committed
122
  comment text NOT NULL,
123
124
125
126
127
128
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  link varchar(16) NOT NULL default '',
  PRIMARY KEY  (cid),
  KEY lid (nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
129

Dries's avatar
   
Dries committed
130
131
132
#
# Table structure for table 'cvs'
#
133

Dries's avatar
   
Dries committed
134
CREATE TABLE cvs (
135
  user varchar(32) NOT NULL default '',
Dries's avatar
   
Dries committed
136
  files text,
137
  status int(2) NOT NULL default '0',
Dries's avatar
   
Dries committed
138
  message text,
139
140
  timestamp int(11) NOT NULL default '0'
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
141

Dries's avatar
   
Dries committed
142
#
143
# Table structure for table 'directory'
Dries's avatar
   
Dries committed
144
#
Dries's avatar
   
Dries committed
145

146
147
148
149
150
151
152
153
154
CREATE TABLE directory (
  link varchar(255) NOT NULL default '',
  name varchar(128) NOT NULL default '',
  mail varchar(128) NOT NULL default '',
  slogan text NOT NULL,
  mission text NOT NULL,
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (link)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
155

Dries's avatar
   
Dries committed
156
157
158
#
# Table structure for table 'feed'
#
159

Dries's avatar
   
Dries committed
160
CREATE TABLE feed (
161
162
163
164
165
166
167
  fid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  refresh int(11) default NULL,
  timestamp int(11) default NULL,
  attributes varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
168
  description text NOT NULL,
169
170
171
172
  PRIMARY KEY  (fid),
  UNIQUE KEY title (title),
  UNIQUE KEY link (url)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
173

Dries's avatar
   
Dries committed
174
#
175
# Table structure for table 'history'
Dries's avatar
   
Dries committed
176
#
177
178
179
180
181
182
183

CREATE TABLE history (
  uid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (uid,nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
184

Dries's avatar
   
Dries committed
185
186
187
#
# Table structure for table 'item'
#
188

Dries's avatar
   
Dries committed
189
CREATE TABLE item (
190
191
192
193
194
  iid int(10) NOT NULL auto_increment,
  fid int(10) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  author varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
195
  description text NOT NULL,
196
197
198
199
  timestamp int(11) default NULL,
  attributes varchar(255) NOT NULL default '',
  PRIMARY KEY  (iid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
200

201
202
203
204
#
# Table structure for table 'layout'
#
CREATE TABLE layout (
205
  uid int(11) DEFAULT '0' NOT NULL,
206
207
208
  block varchar(64) DEFAULT '' NOT NULL
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
209
210
211
#
# Table structure for table 'locales'
#
212

Dries's avatar
   
Dries committed
213
CREATE TABLE locales (
214
215
  lid int(10) NOT NULL auto_increment,
  location varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
216
217
218
219
220
221
222
223
224
  string text NOT NULL,
  da text NOT NULL,
  fi text NOT NULL,
  fr text NOT NULL,
  en text NOT NULL,
  es text NOT NULL,
  nl text NOT NULL,
  no text NOT NULL,
  sw text NOT NULL,
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
  PRIMARY KEY  (lid)
) TYPE=MyISAM;

#
# Table structure for table 'moderate'
#

CREATE TABLE moderate (
  cid int(10) NOT NULL default '0',
  nid int(10) NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  score int(2) NOT NULL default '0',
  timestamp int(11) NOT NULL default '0',
  KEY cid (cid),
  KEY nid (nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
241

Dries's avatar
   
Dries committed
242
243
244
#
# Table structure for table 'modules'
#
245

Dries's avatar
   
Dries committed
246
CREATE TABLE modules (
247
248
249
  name varchar(64) NOT NULL default '',
  PRIMARY KEY  (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
250

Dries's avatar
   
Dries committed
251
252
253
#
# Table structure for table 'node'
#
254

Dries's avatar
   
Dries committed
255
CREATE TABLE node (
256
257
258
259
260
261
262
263
264
265
266
  nid int(10) unsigned NOT NULL auto_increment,
  type varchar(16) NOT NULL default '',
  title varchar(128) NOT NULL default '',
  score int(11) NOT NULL default '0',
  votes int(11) NOT NULL default '0',
  uid int(10) NOT NULL default '0',
  status int(4) NOT NULL default '1',
  created int(11) NOT NULL default '0',
  comment int(2) NOT NULL default '0',
  promote int(2) NOT NULL default '0',
  moderate int(2) NOT NULL default '0',
Dries's avatar
   
Dries committed
267
  users text NOT NULL,
268
269
270
271
272
273
274
  attributes varchar(255) NOT NULL default '',
  teaser text NOT NULL,
  body text NOT NULL,
  changed int(11) NOT NULL default '0',
  revisions text NOT NULL,
  PRIMARY KEY  (nid),
  KEY type (type),
Dries's avatar
   
Dries committed
275
  KEY title (title,type),
Dries's avatar
   
Dries committed
276
  KEY promote (promote),
277
278
279
  KEY status (status),
  KEY uid (uid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
280

Dries's avatar
   
Dries committed
281
282
283
#
# Table structure for table 'page'
#
284

Dries's avatar
   
Dries committed
285
CREATE TABLE page (
286
287
288
289
290
291
  nid int(10) unsigned NOT NULL default '0',
  link varchar(128) NOT NULL default '',
  format tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (nid),
  KEY nid (nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
292

Dries's avatar
   
Dries committed
293
294
295
#
# Table structure for table 'poll'
#
296

297
CREATE TABLE poll (
298
299
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
300
  voters text NOT NULL,
301
  active int(2) unsigned NOT NULL default '0',
Steven Wittens's avatar
Steven Wittens committed
302
  PRIMARY KEY  (nid)
303
) TYPE=MyISAM;
304

Dries's avatar
   
Dries committed
305
306
307
#
# Table structure for table 'poll_choices'
#
308

309
CREATE TABLE poll_choices (
310
311
312
313
314
315
316
317
  chid int(10) unsigned NOT NULL auto_increment,
  nid int(10) unsigned NOT NULL default '0',
  chtext varchar(128) NOT NULL default '',
  chvotes int(6) NOT NULL default '0',
  chorder int(2) NOT NULL default '0',
  PRIMARY KEY  (chid)
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
318
319
320
#
# Table structure for table 'rating'
#
321

Dries's avatar
   
Dries committed
322
CREATE TABLE rating (
323
324
325
326
327
  uid int(10) NOT NULL default '0',
  new int(6) NOT NULL default '0',
  old int(6) NOT NULL default '0',
  PRIMARY KEY  (uid)
) TYPE=MyISAM;
Dries's avatar
Dries committed
328

Dries's avatar
   
Dries committed
329
#
330
# Table structure for table 'referrer'
Dries's avatar
   
Dries committed
331
#
332
333
334
335
336

CREATE TABLE referrer (
  url varchar(255) NOT NULL default '',
  timestamp int(11) NOT NULL default '0'
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
337

Dries's avatar
   
Dries committed
338
339
340
#
# Table structure for table 'role'
#
341

Dries's avatar
   
Dries committed
342
CREATE TABLE role (
343
344
  rid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
Dries's avatar
   
Dries committed
345
  perm text NOT NULL,
346
347
348
  PRIMARY KEY  (rid),
  UNIQUE KEY name (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
349

Dries's avatar
   
Dries committed
350
351
352
#
# Table structure for table 'site'
#
353

Dries's avatar
   
Dries committed
354
CREATE TABLE site (
355
356
357
  sid int(10) unsigned NOT NULL auto_increment,
  name varchar(128) NOT NULL default '',
  link varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
358
  size text NOT NULL,
359
360
361
362
363
364
  timestamp int(11) NOT NULL default '0',
  feed varchar(255) NOT NULL default '',
  PRIMARY KEY  (sid),
  UNIQUE KEY title (name),
  UNIQUE KEY url (link)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
365

Dries's avatar
   
Dries committed
366
367
368
#
# Table structure for table 'tag'
#
Dries's avatar
   
Dries committed
369

370
371
372
373
374
375
376
377
CREATE TABLE tag (
  tid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  attributes varchar(255) NOT NULL default '',
  collections varchar(32) NOT NULL default '',
  PRIMARY KEY  (tid),
  UNIQUE KEY name (name,collections)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
378

Dries's avatar
   
Dries committed
379
380
381
#
# Table structure for table 'users'
#
382

Dries's avatar
   
Dries committed
383
CREATE TABLE users (
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
  uid int(10) unsigned NOT NULL auto_increment,
  name varchar(60) NOT NULL default '',
  pass varchar(32) NOT NULL default '',
  mail varchar(64) default '',
  homepage varchar(128) NOT NULL default '',
  mode tinyint(1) NOT NULL default '0',
  sort tinyint(1) default '0',
  threshold tinyint(1) default '0',
  theme varchar(255) NOT NULL default '',
  signature varchar(255) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  hostname varchar(128) NOT NULL default '',
  status tinyint(4) NOT NULL default '0',
  timezone varchar(8) default NULL,
  rating decimal(8,2) default NULL,
  language char(2) NOT NULL default '',
  role varchar(32) NOT NULL default '',
  sid varchar(32) NOT NULL default '',
  init varchar(64) default '',
  session varchar(32) NOT NULL default '',
404
  data text,
405
406
407
  PRIMARY KEY  (uid),
  UNIQUE KEY name (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
408

Dries's avatar
   
Dries committed
409
410
411
#
# Table structure for table 'variable'
#
412

Dries's avatar
   
Dries committed
413
CREATE TABLE variable (
414
  name varchar(32) NOT NULL default '',
Dries's avatar
   
Dries committed
415
  value text NOT NULL,
416
417
  PRIMARY KEY  (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
418

Dries's avatar
   
Dries committed
419
420
421
#
# Table structure for table 'watchdog'
#
422

Dries's avatar
   
Dries committed
423
CREATE TABLE watchdog (
424
425
426
427
428
429
430
431
432
433
434
435
436
  wid int(5) NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  type varchar(16) NOT NULL default '',
  message varchar(255) NOT NULL default '',
  location varchar(128) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (wid)
) TYPE=MyISAM;

#
# Insert some default values
#
Dries's avatar
   
Dries committed
437

438
439
INSERT INTO variable SET name='update_start', value='2002-01-05';
INSERT INTO blocks SET name='User information', module='user', delta='0', status='2', weight='0', region='1', remove='0', path='';