database.mysql 12.7 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
#--------------------------------------------------------
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
  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',
58
  log text,
59
60
61
  PRIMARY KEY  (nid),
  KEY nid (nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
62

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

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

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

Dries's avatar
   
Dries committed
82
CREATE TABLE bundle (
83
84
85
86
87
88
  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
89

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

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

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

Dries's avatar
   
Dries committed
105
CREATE TABLE collection (
106
107
108
109
110
111
  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
112

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

Dries's avatar
 
Dries committed
117
CREATE TABLE comments (
118
119
120
121
122
  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
123
  comment text NOT NULL,
124
125
126
127
128
129
  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
130

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

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

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

147
148
149
150
151
152
153
154
155
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
156

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

Dries's avatar
   
Dries committed
161
CREATE TABLE feed (
162
163
164
165
166
167
168
  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
169
  description text NOT NULL,
170
  PRIMARY KEY  (fid),
171
172
  UNIQUE KEY link (url),
  UNIQUE KEY title (title)
173
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
174

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

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
185

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

Dries's avatar
   
Dries committed
190
CREATE TABLE item (
191
192
193
194
195
  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
196
  description text NOT NULL,
197
198
199
200
  timestamp int(11) default NULL,
  attributes varchar(255) NOT NULL default '',
  PRIMARY KEY  (iid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
201

202
203
204
#
# Table structure for table 'layout'
#
205

206
CREATE TABLE layout (
207
208
  uid int(11) NOT NULL default '0',
  block varchar(64) NOT NULL default ''
209
210
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
211
212
213
#
# Table structure for table 'locales'
#
214

Dries's avatar
   
Dries committed
215
CREATE TABLE locales (
216
217
  lid int(10) NOT NULL auto_increment,
  location varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
218
219
220
221
222
223
224
225
226
  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,
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
  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
243

Dries's avatar
   
Dries committed
244
245
246
#
# Table structure for table 'modules'
#
247

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

Dries's avatar
   
Dries committed
253
254
255
#
# Table structure for table 'node'
#
256

Dries's avatar
   
Dries committed
257
CREATE TABLE node (
258
259
260
261
262
263
264
265
266
267
268
  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
269
  users text NOT NULL,
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,
275
  static int(2) NOT NULL default '0',
276
277
  PRIMARY KEY  (nid),
  KEY type (type),
Dries's avatar
   
Dries committed
278
  KEY title (title,type),
Dries's avatar
   
Dries committed
279
  KEY promote (promote),
280
281
282
  KEY status (status),
  KEY uid (uid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
283

Dries's avatar
   
Dries committed
284
285
286
#
# Table structure for table 'page'
#
287

Dries's avatar
   
Dries committed
288
CREATE TABLE page (
289
290
291
292
293
294
  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
295

296
297
298
299
300
301
302
303
304
305
306
#
# Table structure for table 'permission'
#

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',
  perm text,
  tid int(10) unsigned NOT NULL default '0',
  KEY rid (rid)
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
307
308
309
#
# Table structure for table 'poll'
#
310

311
CREATE TABLE poll (
312
313
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
314
  voters text NOT NULL,
315
  active int(2) unsigned NOT NULL default '0',
Steven Wittens's avatar
Steven Wittens committed
316
  PRIMARY KEY  (nid)
317
) TYPE=MyISAM;
318

Dries's avatar
   
Dries committed
319
320
321
#
# Table structure for table 'poll_choices'
#
322

323
CREATE TABLE poll_choices (
324
325
326
327
328
329
330
331
  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
332
333
334
#
# Table structure for table 'rating'
#
335

Dries's avatar
   
Dries committed
336
CREATE TABLE rating (
337
338
339
340
341
  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
342

Dries's avatar
   
Dries committed
343
#
344
# Table structure for table 'referrer'
Dries's avatar
   
Dries committed
345
#
346
347
348
349
350

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

Dries's avatar
   
Dries committed
352
353
354
#
# Table structure for table 'role'
#
355

Dries's avatar
   
Dries committed
356
CREATE TABLE role (
357
358
359
360
361
  rid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
  PRIMARY KEY  (rid),
  UNIQUE KEY name (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
362

363
364
365
366
367
368
369
370
371
372
373
374
375
#
# Table structure for table 'search_index'
#

CREATE TABLE search_index (
  word varchar(50) default NULL,
  lno int(10) unsigned default NULL,
  type varchar(16) default NULL,
  count int(10) unsigned default NULL,
  KEY lno (lno),
  KEY word (word)
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
376
377
378
#
# Table structure for table 'site'
#
379

Dries's avatar
   
Dries committed
380
CREATE TABLE site (
381
382
383
  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
384
  size text NOT NULL,
385
386
  timestamp int(11) NOT NULL default '0',
  feed varchar(255) NOT NULL default '',
387
388
  refresh int(11) NOT NULL default '0',
  threshold int(11) NOT NULL default '0',
389
  PRIMARY KEY  (sid),
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
  UNIQUE KEY url (link),
  UNIQUE KEY title (name)
) TYPE=MyISAM;

#
# Table structure for table 'system'
#

CREATE TABLE system (
  filename varchar(255) NOT NULL default '',
  name varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  status int(2) NOT NULL default '0',
  PRIMARY KEY  (filename)
405
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
406

Dries's avatar
   
Dries committed
407
408
409
#
# Table structure for table 'tag'
#
Dries's avatar
   
Dries committed
410

411
412
413
414
415
416
417
418
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
419

420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
#
# Table structure for table 'term_data'
#

CREATE TABLE term_data (
  tid int(10) unsigned NOT NULL auto_increment,
  vid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  description text,
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY vid (vid)
) TYPE=MyISAM;

#
# Table structure for table 'term_hierarchy'
#

CREATE TABLE term_hierarchy (
  tid int(10) unsigned NOT NULL default '0',
  parent int(10) unsigned NOT NULL default '0',
  KEY tid (tid),
  KEY parent (parent)
) TYPE=MyISAM;

#
# Table structure for table 'term_node'
#

CREATE TABLE term_node (
  nid int(10) unsigned NOT NULL default '0',
  tid int(10) unsigned NOT NULL default '0',
  KEY nid (nid),
  KEY tid (tid)
) TYPE=MyISAM;

#
# Table structure for table 'term_relation'
#

CREATE TABLE term_relation (
  tid1 int(10) unsigned NOT NULL default '0',
  tid2 int(10) unsigned NOT NULL default '0',
  KEY tid1 (tid1),
  KEY tid2 (tid2)
) TYPE=MyISAM;

#
# Table structure for table 'term_synonym'
#

CREATE TABLE term_synonym (
  tid int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  KEY tid (tid),
  KEY name (name(3))
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
478
479
480
#
# Table structure for table 'users'
#
481

Dries's avatar
 
Dries committed
482
CREATE TABLE users (
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
  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 '',
  sid varchar(32) NOT NULL default '',
  init varchar(64) default '',
  session varchar(32) NOT NULL default '',
502
  data text,
503
  rid int(10) unsigned NOT NULL default '0',
504
505
506
  PRIMARY KEY  (uid),
  UNIQUE KEY name (name)
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
507

Dries's avatar
   
Dries committed
508
509
510
#
# Table structure for table 'variable'
#
511

Dries's avatar
   
Dries committed
512
CREATE TABLE variable (
513
  name varchar(32) NOT NULL default '',
Dries's avatar
   
Dries committed
514
  value text NOT NULL,
515
516
  PRIMARY KEY  (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
517

518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
#
# Table structure for table 'vocabulary'
#

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  description text,
  relations tinyint(3) unsigned NOT NULL default '0',
  hierarchy tinyint(3) unsigned NOT NULL default '0',
  multiple tinyint(3) unsigned NOT NULL default '0',
  required tinyint(3) unsigned NOT NULL default '0',
  types text,
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (vid)
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
535
536
537
#
# Table structure for table 'watchdog'
#
538

Dries's avatar
 
Dries committed
539
CREATE TABLE watchdog (
540
541
542
543
544
545
546
547
548
549
550
551
552
  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
553

Kjartan's avatar
Kjartan committed
554
INSERT INTO variable SET name='update_start', value='2002-04-23 : roles cleanup';
555
556
INSERT INTO blocks SET name='User information', module='user', delta='0', status='2', weight='0', region='1', remove='0', path='';
INSERT INTO blocks SET name='Log in', module='user', delta='1', status='2', weight='0', region='1', remove='0', path='';