database.mysql 23.6 KB
Newer Older
Kjartan's avatar
Kjartan committed
1
2
3
-- MySQL dump 8.22
--
-- Host: localhost    Database: drupal_devel
Dries's avatar
   
Dries committed
4
-- Server version  3.23.52-nt
Kjartan's avatar
Kjartan committed
5
6
7
8

--
-- Table structure for table 'access'
--
9

Dries's avatar
   
Dries committed
10
CREATE TABLE access (
11
12
13
14
  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',
15
  PRIMARY KEY (aid)
16
17
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
18
19
20
21
22
--
-- Table structure for table 'accesslog'
--

CREATE TABLE accesslog (
Dries's avatar
   
Dries committed
23
  aid int(10) NOT NULL auto_increment,
24
  sid varchar(32) NOT NULL default '',
Dries's avatar
   
Dries committed
25
26
  title varchar(255) default NULL,
  path varchar(255) default NULL,
Kjartan's avatar
Kjartan committed
27
28
29
  url varchar(255) default NULL,
  hostname varchar(128) default NULL,
  uid int(10) unsigned default '0',
Dries's avatar
   
Dries committed
30
  timer int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
31
  timestamp int(11) unsigned NOT NULL default '0',
32
  KEY accesslog_timestamp (timestamp),
33
  PRIMARY KEY (aid)
Kjartan's avatar
Kjartan committed
34
35
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
36
37
38
39
40
41
42
43
44
--
-- Table structure for table 'aggregator_category'
--

CREATE TABLE aggregator_category (
  cid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  block tinyint(2) NOT NULL default '0',
45
  PRIMARY KEY (cid),
Dries's avatar
   
Dries committed
46
47
48
49
50
51
52
53
54
55
  UNIQUE KEY title (title)
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_category_feed'
--

CREATE TABLE aggregator_category_feed (
  fid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
56
  PRIMARY KEY (fid,cid)
Dries's avatar
   
Dries committed
57
58
59
60
61
62
63
64
65
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_category_item'
--

CREATE TABLE aggregator_category_item (
  iid int(10) NOT NULL default '0',
  cid int(10) NOT NULL default '0',
66
  PRIMARY KEY (iid,cid)
Dries's avatar
   
Dries committed
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_feed'
--

CREATE TABLE aggregator_feed (
  fid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  refresh int(10) NOT NULL default '0',
  checked int(10) NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  description longtext NOT NULL,
  image longtext NOT NULL,
  etag varchar(255) NOT NULL default '',
  modified int(10) NOT NULL default '0',
  block tinyint(2) NOT NULL default '0',
85
  PRIMARY KEY (fid),
Dries's avatar
   
Dries committed
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
  UNIQUE KEY link (url),
  UNIQUE KEY title (title)
) TYPE=MyISAM;

--
-- Table structure for table 'aggregator_item'
--

CREATE TABLE aggregator_item (
  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 '',
  description longtext NOT NULL,
  timestamp int(11) default NULL,
102
  PRIMARY KEY (iid)
Dries's avatar
   
Dries committed
103
104
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
105
106
107
--
-- Table structure for table 'authmap'
--
108
109
110
111
112
113

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 '',
114
  PRIMARY KEY (aid),
115
116
  UNIQUE KEY authname (authname)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
117

Kjartan's avatar
Kjartan committed
118
119
120
--
-- Table structure for table 'blocks'
--
121

Dries's avatar
   
Dries committed
122
CREATE TABLE blocks (
Dries's avatar
   
Dries committed
123
  module varchar(64) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
124
  delta varchar(32) NOT NULL default '0',
125
  theme varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
126
127
  status tinyint(2) DEFAULT '0' NOT NULL,
  weight tinyint(1) DEFAULT '0' NOT NULL,
128
  region varchar(64) DEFAULT 'left' NOT NULL,
Dries's avatar
   
Dries committed
129
  custom tinyint(2) DEFAULT '0' NOT NULL,
130
131
  throttle tinyint(1) DEFAULT '0' NOT NULL,
  visibility tinyint(1) DEFAULT '0' NOT NULL,
132
  pages text DEFAULT '' NOT NULL
133
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
134

Kjartan's avatar
Kjartan committed
135
136
137
--
-- Table structure for table 'book'
--
138

Dries's avatar
   
Dries committed
139
CREATE TABLE book (
140
  vid int(10) unsigned NOT NULL default '0',
141
142
143
  nid int(10) unsigned NOT NULL default '0',
  parent int(10) NOT NULL default '0',
  weight tinyint(3) NOT NULL default '0',
144
145
  PRIMARY KEY (vid),
  KEY nid (nid),
Dries's avatar
   
Dries committed
146
  KEY parent (parent)
147
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
148

Kjartan's avatar
Kjartan committed
149
150
151
--
-- Table structure for table 'boxes'
--
152

Dries's avatar
   
Dries committed
153
CREATE TABLE boxes (
154
155
  bid tinyint(4) NOT NULL auto_increment,
  title varchar(64) NOT NULL default '',
Dries's avatar
   
Dries committed
156
  body longtext,
157
  info varchar(128) NOT NULL default '',
158
  format int(4) NOT NULL default '0',
159
  PRIMARY KEY (bid),
Kjartan's avatar
Kjartan committed
160
  UNIQUE KEY info (info)
161
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
162

Kjartan's avatar
Kjartan committed
163
164
165
--
-- Table structure for table 'cache'
--
166

Dries's avatar
   
Dries committed
167
CREATE TABLE cache (
168
  cid varchar(255) NOT NULL default '',
169
  data longblob,
170
  expire int(11) NOT NULL default '0',
Dries's avatar
   
Dries committed
171
  created int(11) NOT NULL default '0',
Dries's avatar
Dries committed
172
  headers text,
173
  PRIMARY KEY (cid),
174
  INDEX expire (expire)
175
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
176

Kjartan's avatar
Kjartan committed
177
178
179
--
-- Table structure for table 'comments'
--
180

Dries's avatar
   
Dries committed
181
CREATE TABLE comments (
182
183
184
185
186
  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
187
  comment longtext NOT NULL,
188
189
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
Kjartan's avatar
Kjartan committed
190
191
  score mediumint(9) NOT NULL default '0',
  status tinyint(3) unsigned NOT NULL default '0',
192
  format int(4) NOT NULL default '0',
193
  thread varchar(255) NOT NULL,
Dries's avatar
   
Dries committed
194
  users longtext,
Dries's avatar
   
Dries committed
195
196
197
  name varchar(60) default NULL,
  mail varchar(64) default NULL,
  homepage varchar(255) default NULL,
198
  PRIMARY KEY (cid),
199
200
  KEY lid (nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
201

202
--
203
204
205
206
-- Table structre for table 'contact'
--

CREATE TABLE contact (
207
  cid int(10) unsigned NOT NULL auto_increment,
Dries's avatar
Dries committed
208
  category varchar(255) NOT NULL default '',
209
  recipients longtext NOT NULL default '',
Dries's avatar
Dries committed
210
  reply longtext NOT NULL default '',
211
212
  weight tinyint(3) NOT NULL default '0',
  selected tinyint(1) NOT NULL default '0',
213
214
  PRIMARY KEY (cid),
  UNIQUE KEY category (category)
Dries's avatar
Dries committed
215
) TYPE=MyISAM;
216
217
218

--
-- Table structre for table 'node_comment_statistics'
219
220
221
222
223
--

CREATE TABLE node_comment_statistics (
  nid int(10) unsigned NOT NULL auto_increment,
  last_comment_timestamp int(11) NOT NULL default '0',
224
  last_comment_name varchar(60) default NULL,
225
226
227
228
229
230
  last_comment_uid int(10) NOT NULL default '0',
  comment_count int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (nid),
  KEY node_comment_timestamp (last_comment_timestamp)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
231
232
233
--
-- Table structure for table 'directory'
--
Dries's avatar
   
Dries committed
234

235
236
237
238
CREATE TABLE directory (
  link varchar(255) NOT NULL default '',
  name varchar(128) NOT NULL default '',
  mail varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
239
240
  slogan longtext NOT NULL,
  mission longtext NOT NULL,
241
  timestamp int(11) NOT NULL default '0',
242
  PRIMARY KEY (link)
243
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
244

Dries's avatar
   
Dries committed
245
246
247
248
249
250
251
--
-- Table structure for table 'files'
--

CREATE TABLE files (
  fid int(10) unsigned NOT NULL default '0',
  nid int(10) unsigned NOT NULL default '0',
252
  vid int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
253
  filename varchar(255) NOT NULL default '',
254
  description varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
255
256
257
258
  filepath varchar(255) NOT NULL default '',
  filemime varchar(255) NOT NULL default '',
  filesize int(10) unsigned NOT NULL default '0',
  list tinyint(1) unsigned NOT NULL default '0',
259
260
  KEY vid (vid),
  KEY fid (fid)
Dries's avatar
   
Dries committed
261
262
) TYPE=MyISAM;

263
264
265
266
267
--
-- Table structure for table 'filter_formats'
--

CREATE TABLE filter_formats (
268
  format int(4) NOT NULL auto_increment,
269
270
271
  name varchar(255) NOT NULL default '',
  roles varchar(255) NOT NULL default '',
  cache tinyint(2) NOT NULL default '0',
272
  PRIMARY KEY (format)
273
274
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
275
276
277
278
279
--
-- Table structure for table 'filters'
--

CREATE TABLE filters (
280
  format int(4) NOT NULL default '0',
Dries's avatar
   
Dries committed
281
  module varchar(64) NOT NULL default '',
282
  delta tinyint(2) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
283
  weight tinyint(2) DEFAULT '0' NOT NULL,
284
  INDEX (weight)
Dries's avatar
   
Dries committed
285
286
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
287
288
289
290
291
292
293
294
295
296
--
-- Table structure for table 'flood'
--

CREATE TABLE flood (
  event varchar(64) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0'
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
297
298
299
300
--
-- Table structure for table 'forum'
--

Dries's avatar
   
Dries committed
301
CREATE TABLE forum (
Kjartan's avatar
Kjartan committed
302
  nid int(10) unsigned NOT NULL default '0',
303
  vid int(10) unsigned NOT NULL default '0',
304
  tid int(10) unsigned NOT NULL default '0',
305
  PRIMARY KEY (nid),
306
  KEY vid (vid),
Kjartan's avatar
Kjartan committed
307
  KEY tid (tid)
308
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
309

Kjartan's avatar
Kjartan committed
310
311
312
--
-- Table structure for table 'history'
--
313
314
315
316
317

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

Kjartan's avatar
Kjartan committed
321
--
Dries's avatar
   
Dries committed
322
-- Table structure for table 'locales_meta'
Kjartan's avatar
Kjartan committed
323
--
324

Dries's avatar
   
Dries committed
325
326
327
328
329
330
331
CREATE TABLE locales_meta (
  locale varchar(12) NOT NULL default '',
  name varchar(64) NOT NULL default '',
  enabled int(2) NOT NULL default '0',
  isdefault int(2) NOT NULL default '0',
  plurals int(1) NOT NULL default '0',
  formula varchar(128) NOT NULL default '',
332
  PRIMARY KEY (locale)
Dries's avatar
   
Dries committed
333
334
335
336
337
338
339
340
) TYPE=MyISAM;

--
-- Table structure for table 'locales_source'
--

CREATE TABLE locales_source (
  lid int(11) NOT NULL auto_increment,
341
  location varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
342
  source blob NOT NULL,
343
  PRIMARY KEY (lid)
344
345
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
--
-- Table structure for table 'locales_target'
--

CREATE TABLE locales_target (
  lid int(11) NOT NULL default '0',
  translation blob NOT NULL,
  locale varchar(12) NOT NULL default '',
  plid int(11) NOT NULL default '0',
  plural int(1) NOT NULL default '0',
  KEY lid (lid),
  KEY lang (locale),
  KEY plid (plid),
  KEY plural (plural)
) TYPE=MyISAM;

362
363
364
365
366
367
368
369
370
--
-- Table structure for table 'menu'
--

CREATE TABLE menu (
  mid int(10) unsigned NOT NULL default '0',
  pid int(10) unsigned NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  title varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
371
  description varchar(255) NOT NULL default '',
372
  weight tinyint(4) NOT NULL default '0',
Dries's avatar
   
Dries committed
373
  type int(2) unsigned NOT NULL default '0',
374
  PRIMARY KEY (mid)
375
376
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
377
378
379
--
-- Table structure for table 'moderation_filters'
--
380

Kjartan's avatar
Kjartan committed
381
382
383
384
CREATE TABLE moderation_filters (
  fid int(10) unsigned NOT NULL auto_increment,
  filter varchar(255) NOT NULL default '',
  minimum smallint(6) NOT NULL default '0',
385
  PRIMARY KEY (fid)
Kjartan's avatar
Kjartan committed
386
387
388
389
390
391
392
393
394
395
) TYPE=MyISAM;

--
-- Table structure for table 'moderation_roles'
--

CREATE TABLE moderation_roles (
  rid int(10) unsigned NOT NULL default '0',
  mid int(10) unsigned NOT NULL default '0',
  value tinyint(4) NOT NULL default '0',
Dries's avatar
   
Dries committed
396
397
  KEY idx_rid (rid),
  KEY idx_mid (mid)
398
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
399

Kjartan's avatar
Kjartan committed
400
401
402
403
404
405
406
407
--
-- Table structure for table 'moderation_votes'
--

CREATE TABLE moderation_votes (
  mid int(10) unsigned NOT NULL auto_increment,
  vote varchar(255) default NULL,
  weight tinyint(4) NOT NULL default '0',
408
  PRIMARY KEY (mid)
Kjartan's avatar
Kjartan committed
409
410
411
412
413
) TYPE=MyISAM;

--
-- Table structure for table 'node'
--
414

Dries's avatar
   
Dries committed
415
CREATE TABLE node (
416
  nid int(10) unsigned NOT NULL auto_increment,
417
  vid int(10) unsigned NOT NULL default '0',
418
  type varchar(32) NOT NULL default '',
419
420
421
422
  title varchar(128) NOT NULL default '',
  uid int(10) NOT NULL default '0',
  status int(4) NOT NULL default '1',
  created int(11) NOT NULL default '0',
Dries's avatar
   
Dries committed
423
  changed int(11) NOT NULL default '0',
424
425
426
  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
427
  sticky int(2) NOT NULL default '0',
428
  PRIMARY KEY (nid),
Dries's avatar
   
Dries committed
429
430
  KEY node_type (type(4)),
  KEY node_title_type (title,type(4)),
431
  KEY status (status),
Dries's avatar
   
Dries committed
432
  KEY uid (uid),
433
  KEY vid (vid),
Dries's avatar
   
Dries committed
434
  KEY node_moderate (moderate),
435
436
  KEY node_promote_status (promote, status),
  KEY node_created (created),
437
438
  KEY node_changed (changed),
  KEY node_status_type (status, type, nid)
439
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
440

441
442
443
--
-- Table structure for table `node_access`
--
Dries's avatar
   
Dries committed
444
445
446
447
448
449
450
451

CREATE TABLE node_access (
  nid int(10) unsigned NOT NULL default '0',
  gid int(10) unsigned NOT NULL default '0',
  realm varchar(255) NOT NULL default '',
  grant_view tinyint(1) unsigned NOT NULL default '0',
  grant_update tinyint(1) unsigned NOT NULL default '0',
  grant_delete tinyint(1) unsigned NOT NULL default '0',
452
  PRIMARY KEY (nid,gid,realm)
Dries's avatar
   
Dries committed
453
454
) TYPE=MyISAM;

455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
--
-- Table structure for table 'node_revisions'
--

CREATE TABLE node_revisions (
  nid int(10) unsigned NOT NULL,
  vid int(10) unsigned NOT NULL,
  uid int(10) NOT NULL default '0',
  title varchar(128) NOT NULL default '',
  body longtext NOT NULL default '',
  teaser longtext NOT NULL default '',
  log longtext NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  format int(4) NOT NULL default '0',
  PRIMARY KEY  (nid,vid),
  KEY uid (uid)
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
473
474
475
476
477
478
479
480
481
482
--
-- Table structure for table 'profile_fields'
--

CREATE TABLE profile_fields (
  fid int(10) NOT NULL auto_increment,
  title varchar(255) default NULL,
  name varchar(128) default NULL,
  explanation TEXT default NULL,
  category varchar(255) default NULL,
Dries's avatar
   
Dries committed
483
  page varchar(255) default NULL,
Dries's avatar
   
Dries committed
484
485
  type varchar(128) default NULL,
  weight tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
486
  required tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
487
  register tinyint(1) DEFAULT '0' NOT NULL,
488
  visibility tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
489
490
491
492
  options text,
  KEY category (category),
  UNIQUE KEY name (name),
  PRIMARY KEY (fid)
493
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
494
495
496
497
498
499

--
-- Table structure for table 'profile_values'
--

CREATE TABLE profile_values (
500
501
  fid int(10) unsigned default '0',
  uid int(10) unsigned default '0',
Dries's avatar
   
Dries committed
502
503
504
  value text,
  KEY uid (uid),
  KEY fid (fid)
505
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
506
507


Dries's avatar
   
Dries committed
508
--
Dries's avatar
   
Dries committed
509
-- Table structure for table 'url_alias'
Dries's avatar
   
Dries committed
510
511
--

Dries's avatar
   
Dries committed
512
CREATE TABLE url_alias (
Dries's avatar
   
Dries committed
513
  pid int(10) unsigned NOT NULL auto_increment,
Dries's avatar
   
Dries committed
514
515
  src varchar(128) NOT NULL default '',
  dst varchar(128) NOT NULL default '',
516
  PRIMARY KEY (pid),
517
518
  UNIQUE KEY dst (dst),
  KEY src (src)
Dries's avatar
   
Dries committed
519
520
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
521
522
523
--
-- Table structure for table 'permission'
--
524
525
526

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
527
  perm longtext,
528
529
530
531
  tid int(10) unsigned NOT NULL default '0',
  KEY rid (rid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
532
533
534
--
-- Table structure for table 'poll'
--
535

536
CREATE TABLE poll (
537
538
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
Dries's avatar
   
Dries committed
539
  polled longtext NOT NULL,
540
  active int(2) unsigned NOT NULL default '0',
541
  PRIMARY KEY (nid)
542
) TYPE=MyISAM;
543

Kjartan's avatar
Kjartan committed
544
545
546
--
-- Table structure for table 'poll_choices'
--
547

548
CREATE TABLE poll_choices (
549
550
551
552
553
  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',
554
  PRIMARY KEY (chid),
Kjartan's avatar
Kjartan committed
555
  KEY nid (nid)
556
557
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
558
559
560
--
-- Table structure for table 'role'
--
561

Dries's avatar
   
Dries committed
562
CREATE TABLE role (
563
564
  rid int(10) unsigned NOT NULL auto_increment,
  name varchar(32) NOT NULL default '',
565
  PRIMARY KEY (rid),
566
567
  UNIQUE KEY name (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
568

569
570
571
572
573
574
575
576
577
578
--
-- Table structure for table 'search_dataset'
--
CREATE TABLE search_dataset (
  sid int(10) unsigned NOT NULL default '0',
  type varchar(16) default NULL,
  data longtext NOT NULL,
  KEY sid_type (sid, type)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
579
580
581
--
-- Table structure for table 'search_index'
--
582
583

CREATE TABLE search_index (
Kjartan's avatar
Kjartan committed
584
  word varchar(50) NOT NULL default '',
585
  sid int(10) unsigned NOT NULL default '0',
Kjartan's avatar
Kjartan committed
586
  type varchar(16) default NULL,
587
588
  fromsid int(10) unsigned NOT NULL default '0',
  fromtype varchar(16) default NULL,
589
590
591
  score float default NULL,
  KEY sid_type (sid, type),
  KEY from_sid_type (fromsid, fromtype),
592
593
594
595
596
597
598
599
600
  KEY word (word)
) TYPE=MyISAM;

--
-- Table structure for table 'search_total'
--

CREATE TABLE search_total (
  word varchar(50) NOT NULL default '',
601
  count float default NULL,
602
  PRIMARY KEY (word)
Kjartan's avatar
Kjartan committed
603
604
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
605
--
606
-- Table structure for table 'sessions'
Dries's avatar
   
Dries committed
607
608
609
610
611
612
613
614
--


CREATE TABLE sessions (
  uid int(10) unsigned NOT NULL,
  sid varchar(32) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
615
  cache int(11) NOT NULL default '0',
Dries's avatar
   
Dries committed
616
  session longtext,
Dries's avatar
   
Dries committed
617
  KEY uid (uid),
618
  PRIMARY KEY (sid),
Dries's avatar
   
Dries committed
619
620
621
  KEY timestamp (timestamp)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
622
623
624
625
626
627
628
--
-- Table structure for table 'sequences'
--

CREATE TABLE sequences (
  name varchar(255) NOT NULL default '',
  id int(10) unsigned NOT NULL default '0',
629
  PRIMARY KEY (name)
630
631
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
632
--
Dries's avatar
   
Dries committed
633
-- Table structure for table 'node_counter'
Kjartan's avatar
Kjartan committed
634
635
--

Dries's avatar
   
Dries committed
636
CREATE TABLE node_counter (
Kjartan's avatar
Kjartan committed
637
638
639
640
  nid int(11) NOT NULL default '0',
  totalcount bigint(20) unsigned NOT NULL default '0',
  daycount mediumint(8) unsigned NOT NULL default '0',
  timestamp int(11) unsigned NOT NULL default '0',
641
  PRIMARY KEY (nid),
Kjartan's avatar
Kjartan committed
642
643
644
645
646
647
648
649
  KEY totalcount (totalcount),
  KEY daycount (daycount),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table 'system'
--
650
651
652
653
654
655
656

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',
Dries's avatar
   
Dries committed
657
  throttle tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
658
  bootstrap int(2) NOT NULL default '0',
659
  schema_version smallint(2) unsigned NOT NULL default 0,
660
  PRIMARY KEY (filename)
Dries's avatar
   
Dries committed
661
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
662

Kjartan's avatar
Kjartan committed
663
664
665
--
-- Table structure for table 'term_data'
--
666
667
668
669
670

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 '',
Dries's avatar
   
Dries committed
671
  description longtext,
672
  weight tinyint(4) NOT NULL default '0',
673
  PRIMARY KEY (tid),
674
675
676
  KEY vid (vid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
677
678
679
--
-- Table structure for table 'term_hierarchy'
--
680
681
682
683
684
685
686
687

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;

Kjartan's avatar
Kjartan committed
688
689
690
--
-- Table structure for table 'term_node'
--
691
692
693
694
695

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

Kjartan's avatar
Kjartan committed
700
701
702
--
-- Table structure for table 'term_relation'
--
703
704
705
706
707
708
709
710

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;

Kjartan's avatar
Kjartan committed
711
712
713
--
-- Table structure for table 'term_synonym'
--
714
715
716
717
718
719
720
721

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;

Kjartan's avatar
Kjartan committed
722
723
724
--
-- Table structure for table 'users'
--
725

Dries's avatar
   
Dries committed
726
CREATE TABLE users (
Dries's avatar
   
Dries committed
727
  uid int(10) unsigned NOT NULL default '0',
728
729
730
731
732
733
734
735
  name varchar(60) NOT NULL default '',
  pass varchar(32) NOT NULL default '',
  mail varchar(64) 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 '',
Dries's avatar
   
Dries committed
736
  created int(11) NOT NULL default '0',
737
  access int(11) NOT NULL default '0',
738
  login int(11) NOT NULL default '0',
739
740
  status tinyint(4) NOT NULL default '0',
  timezone varchar(8) default NULL,
Dries's avatar
   
Dries committed
741
  language varchar(12) NOT NULL default '',
Dries's avatar
   
Dries committed
742
  picture varchar(255) NOT NULL DEFAULT '',
743
  init varchar(64) default '',
Dries's avatar
   
Dries committed
744
  data longtext,
745
  PRIMARY KEY (uid),
Kjartan's avatar
Kjartan committed
746
  UNIQUE KEY name (name),
747
  KEY access (access)
748
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
749

Dries's avatar
   
Dries committed
750
751
752
753
754
755
756
757
758
759
--
-- Table structure for table 'users_roles'
--

CREATE TABLE users_roles (
  uid int(10) unsigned NOT NULL default '0',
  rid int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (uid, rid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
760
761
762
--
-- Table structure for table 'variable'
--
763

Dries's avatar
   
Dries committed
764
CREATE TABLE variable (
Dries's avatar
   
Dries committed
765
  name varchar(48) NOT NULL default '',
Dries's avatar
   
Dries committed
766
  value longtext NOT NULL,
767
  PRIMARY KEY (name)
768
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
769

Kjartan's avatar
Kjartan committed
770
771
772
--
-- Table structure for table 'vocabulary'
--
773
774
775
776

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
777
  description longtext,
778
  help varchar(255) NOT NULL default '',
779
780
781
782
  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',
Dries's avatar
Dries committed
783
  tags tinyint(3) unsigned NOT NULL default '0',
784
  module varchar(255) NOT NULL default '',
785
  weight tinyint(4) NOT NULL default '0',
786
  PRIMARY KEY (vid)
787
788
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
789
790
791
792
793
794
795
796
797
798
--
-- Table structure for table 'vocabulary_node_types'
--

CREATE TABLE vocabulary_node_types (
  vid int(10) unsigned NOT NULL DEFAULT '0',
  type varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (vid, type)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
799
800
801
--
-- Table structure for table 'watchdog'
--
802

Dries's avatar
   
Dries committed
803
CREATE TABLE watchdog (
804
805
806
  wid int(5) NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  type varchar(16) NOT NULL default '',
Dries's avatar
   
Dries committed
807
  message longtext NOT NULL,
808
  severity tinyint(3) unsigned NOT NULL default '0',
809
  link varchar(255) NOT NULL default '',
810
  location varchar(128) NOT NULL default '',
811
  referer varchar(128) NOT NULL default '',
812
813
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
814
  PRIMARY KEY (wid)
815
816
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
817
818
819
--
-- Insert some default values
--
Dries's avatar
   
Dries committed
820

821
822
823
824
825
826
827
828
829
830
831
832
833
834
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/block.module', 'block', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/comment.module', 'comment', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/filter.module', 'filter', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/help.module', 'help', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/menu.module', 'menu', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/node.module', 'node', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/page.module', 'page', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/story.module', 'story', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/system.module', 'system', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/taxonomy.module', 'taxonomy', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/user.module', 'user', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('modules/watchdog.module', 'watchdog', 'module', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/engines/phptemplate/phptemplate.engine', 'phptemplate', 'theme_engine', '', 1, 0, 0, 0);
INSERT INTO system (filename, name, type, description, status, throttle, bootstrap, schema_version) VALUES ('themes/bluemarine/page.tpl.php', 'bluemarine', 'theme', 'themes/engines/phptemplate/phptemplate.engine', 1, 0, 0, 0);
835
836
INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
INSERT INTO users_roles (uid, rid) VALUES (0, 1);
Dries's avatar
   
Dries committed
837
838

INSERT INTO role (rid, name) VALUES (1, 'anonymous user');
Dries's avatar
   
Dries committed
839
INSERT INTO permission VALUES (1,'access content',0);
Dries's avatar
   
Dries committed
840
841

INSERT INTO role (rid, name) VALUES (2, 'authenticated user');
Dries's avatar
   
Dries committed
842
INSERT INTO permission VALUES (2,'access comments, access content, post comments, post comments without approval',0);
Kjartan's avatar
Kjartan committed
843

Dries's avatar
   
Dries committed
844
REPLACE variable SET name='theme_default', value='s:10:"bluemarine";';
Kjartan's avatar
Kjartan committed
845

846
847
REPLACE blocks SET module = 'user', delta = '0', theme = 'bluemarine', status = '1';
REPLACE blocks SET module = 'user', delta = '1', theme = 'bluemarine', status = '1';
848

849
INSERT INTO sequences (name, id) VALUES ('menu_mid', 2);
Dries's avatar
   
Dries committed
850
851

INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);
852
853
854
855
856

INSERT INTO filter_formats VALUES (1,'Filtered HTML',',1,2,',1);
INSERT INTO filter_formats VALUES (2,'PHP code','',0);
INSERT INTO filter_formats VALUES (3,'Full HTML','',1);
INSERT INTO filters VALUES (1,'filter',0,0);
857
INSERT INTO filters VALUES (1,'filter',2,1);
858
INSERT INTO filters VALUES (2,'filter',1,0);
859
INSERT INTO filters VALUES (3,'filter',2,0);
860
INSERT INTO variable (name,value) VALUES ('filter_html_1','i:1;');
Dries's avatar
   
Dries committed
861
862

INSERT INTO locales_meta (locale, name, enabled, isdefault) VALUES ('en', 'English', '1', '1');
863

864
INSERT INTO variable (name, value) VALUES ('node_options_forum', 'a:1:{i:0;s:6:"status";}');
865
866
867
868

INSERT INTO menu VALUES (2, 0, '', 'Primary links', '', 0, 115);
INSERT INTO variable VALUES ('menu_primary_menu', 'i:2;');
INSERT INTO variable VALUES ('menu_secondary_menu', 'i:2;');