database.mysql 15.4 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
15
16
17
18
  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;

Kjartan's avatar
Kjartan committed
19
20
21
22
23
24
25
26
27
--
-- Table structure for table 'accesslog'
--

CREATE TABLE accesslog (
  nid int(11) unsigned default '0',
  url varchar(255) default NULL,
  hostname varchar(128) default NULL,
  uid int(10) unsigned default '0',
Dries's avatar
   
Dries committed
28
29
  timestamp int(11) unsigned NOT NULL default '0',
  KEY accesslog_timestamp (timestamp)
Kjartan's avatar
Kjartan committed
30
31
32
33
34
) TYPE=MyISAM;

--
-- Table structure for table 'authmap'
--
35
36
37
38
39
40
41
42
43

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
44

Kjartan's avatar
Kjartan committed
45
46
47
--
-- Table structure for table 'blocks'
--
48

Dries's avatar
   
Dries committed
49
CREATE TABLE blocks (
Dries's avatar
   
Dries committed
50
  module varchar(64) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
51
  delta varchar(32) NOT NULL default '0',
Dries's avatar
   
Dries committed
52
53
54
55
  status tinyint(2) DEFAULT '0' NOT NULL,
  weight tinyint(1) DEFAULT '0' NOT NULL,
  region tinyint(1) DEFAULT '0' NOT NULL,
  path varchar(255) DEFAULT '' NOT NULL,
Dries's avatar
   
Dries committed
56
57
  custom tinyint(2) DEFAULT '0' NOT NULL,
  throttle tinyint(1) DEFAULT '0' NOT NULL
58
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
59

Kjartan's avatar
Kjartan committed
60
61
62
--
-- Table structure for table 'book'
--
63

Dries's avatar
   
Dries committed
64
CREATE TABLE book (
65
66
67
68
  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',
Dries's avatar
   
Dries committed
69
  log longtext,
70
  PRIMARY KEY  (nid),
Dries's avatar
   
Dries committed
71
  KEY parent (parent)
72
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
73

Kjartan's avatar
Kjartan committed
74
75
76
--
-- Table structure for table 'boxes'
--
77

Dries's avatar
   
Dries committed
78
CREATE TABLE boxes (
79
80
  bid tinyint(4) NOT NULL auto_increment,
  title varchar(64) NOT NULL default '',
Dries's avatar
   
Dries committed
81
  body longtext,
82
83
84
  info varchar(128) NOT NULL default '',
  type tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (bid),
Kjartan's avatar
Kjartan committed
85
86
  UNIQUE KEY subject (title),
  UNIQUE KEY info (info)
87
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
88

Kjartan's avatar
Kjartan committed
89
90
91
--
-- Table structure for table 'bundle'
--
92

Dries's avatar
   
Dries committed
93
CREATE TABLE bundle (
94
95
96
97
98
99
  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
100

Kjartan's avatar
Kjartan committed
101
102
103
--
-- Table structure for table 'cache'
--
104

Dries's avatar
   
Dries committed
105
CREATE TABLE cache (
106
  cid varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
107
  data longtext,
108
  expire int(11) NOT NULL default '0',
Dries's avatar
   
Dries committed
109
  created int(11) NOT NULL default '0',
Dries's avatar
Dries committed
110
  headers text,
111
112
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
113

Kjartan's avatar
Kjartan committed
114
115
116
--
-- Table structure for table 'comments'
--
117

Dries's avatar
 
Dries committed
118
CREATE TABLE comments (
119
120
121
122
123
  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
124
  comment longtext NOT NULL,
125
126
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
Kjartan's avatar
Kjartan committed
127
128
  score mediumint(9) NOT NULL default '0',
  status tinyint(3) unsigned NOT NULL default '0',
129
  thread varchar(255) NOT NULL,
Dries's avatar
   
Dries committed
130
  users longtext,
131
132
133
  PRIMARY KEY  (cid),
  KEY lid (nid)
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
134

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

139
140
141
142
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
143
144
  slogan longtext NOT NULL,
  mission longtext NOT NULL,
145
146
147
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (link)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
148

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

Dries's avatar
   
Dries committed
153
CREATE TABLE feed (
154
155
156
  fid int(10) NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
Kjartan's avatar
Kjartan committed
157
  refresh int(10) NOT NULL default '0',
Dries's avatar
   
Dries committed
158
  checked int(10) NOT NULL default '0',
159
160
  attributes varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
161
  description longtext NOT NULL,
Dries's avatar
   
Dries committed
162
  image longtext NOT NULL default '',
Dries's avatar
   
Dries committed
163
164
  etag varchar(255) NOT NULL default '',
  modified int(10) NOT NULL default '0',
165
  PRIMARY KEY  (fid),
Kjartan's avatar
Kjartan committed
166
167
168
169
  UNIQUE KEY link (url),
  UNIQUE KEY title (title)
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
170
171
172
173
174
175
176
177
178
179
--
-- Table structure for table 'filters'
--

CREATE TABLE filters (
  module varchar(64) NOT NULL default '',
  weight tinyint(2) DEFAULT '0' NOT NULL,
  KEY weight (weight)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
180
181
182
183
--
-- Table structure for table 'forum'
--

Dries's avatar
   
Dries committed
184
CREATE TABLE forum (
Kjartan's avatar
Kjartan committed
185
  nid int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
186
  tid int(10) unsigned NOT NULL default '0',
Kjartan's avatar
Kjartan committed
187
  shadow int(10) unsigned NOT NULL default '0',
Kjartan's avatar
Kjartan committed
188
189
  PRIMARY KEY  (nid),
  KEY tid (tid)
190
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
191

Kjartan's avatar
Kjartan committed
192
193
194
--
-- Table structure for table 'history'
--
195
196
197
198
199
200
201

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
202

Kjartan's avatar
Kjartan committed
203
204
205
--
-- Table structure for table 'item'
--
206

Dries's avatar
   
Dries committed
207
CREATE TABLE item (
208
209
210
211
212
  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
213
  description longtext NOT NULL,
214
215
216
217
  timestamp int(11) default NULL,
  attributes varchar(255) NOT NULL default '',
  PRIMARY KEY  (iid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
218

Kjartan's avatar
Kjartan committed
219
220
221
--
-- Table structure for table 'locales'
--
222

Dries's avatar
   
Dries committed
223
CREATE TABLE locales (
224
225
  lid int(10) NOT NULL auto_increment,
  location varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
226
227
228
229
230
231
232
233
234
  string blob NOT NULL,
  da blob NOT NULL,
  fi blob NOT NULL,
  fr blob NOT NULL,
  en blob NOT NULL,
  es blob NOT NULL,
  nl blob NOT NULL,
  no blob NOT NULL,
  sw blob NOT NULL,
235
236
237
  PRIMARY KEY  (lid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
238
239
240
--
-- Table structure for table 'moderation_filters'
--
241

Kjartan's avatar
Kjartan committed
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
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',
  PRIMARY KEY  (fid)
) 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
257
258
  KEY idx_rid (rid),
  KEY idx_mid (mid)
259
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
260

Kjartan's avatar
Kjartan committed
261
262
263
264
265
266
267
268
269
270
271
272
273
274
--
-- 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',
  PRIMARY KEY  (mid)
) TYPE=MyISAM;

--
-- Table structure for table 'node'
--
275

Dries's avatar
   
Dries committed
276
CREATE TABLE node (
277
278
279
280
281
282
283
284
  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',
Dries's avatar
   
Dries committed
285
  changed int(11) NOT NULL default '0',
286
287
288
  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
289
290
291
292
  users longtext NOT NULL,
  teaser longtext NOT NULL,
  body longtext NOT NULL,
  revisions longtext NOT NULL,
293
  static int(2) NOT NULL default '0',
294
  PRIMARY KEY  (nid),
Dries's avatar
   
Dries committed
295
296
  KEY node_type (type(4)),
  KEY node_title_type (title,type(4)),
297
  KEY status (status),
Dries's avatar
   
Dries committed
298
299
300
  KEY uid (uid),
  KEY node_moderate (moderate),
  KEY node_promote_status (promote, status)
301
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
302

Kjartan's avatar
Kjartan committed
303
304
305
--
-- Table structure for table 'page'
--
306

Dries's avatar
   
Dries committed
307
CREATE TABLE page (
308
309
310
  nid int(10) unsigned NOT NULL default '0',
  link varchar(128) NOT NULL default '',
  format tinyint(2) NOT NULL default '0',
Dries's avatar
   
Dries committed
311
  description varchar(128) NOT NULL default '',
Kjartan's avatar
Kjartan committed
312
  PRIMARY KEY  (nid)
313
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
314

Dries's avatar
   
Dries committed
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
--
-- 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,
  type varchar(128) default NULL,
  weight tinyint(1) DEFAULT '0' NOT NULL,
  overview tinyint(1) DEFAULT '0' NOT NULL,
  options text,
  KEY category (category),
  UNIQUE KEY name (name),
  PRIMARY KEY (fid)
);

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

CREATE TABLE profile_values (
  fid int(11) unsigned default '0',
  uid int(11) unsigned default '0',
  value text,
  KEY uid (uid),
  KEY fid (fid)
);


Dries's avatar
   
Dries committed
347
--
Dries's avatar
   
Dries committed
348
-- Table structure for table 'url_alias'
Dries's avatar
   
Dries committed
349
350
--

Dries's avatar
   
Dries committed
351
CREATE TABLE url_alias (
Dries's avatar
   
Dries committed
352
  pid int(10) unsigned NOT NULL auto_increment,
Dries's avatar
   
Dries committed
353
354
  src varchar(128) NOT NULL default '',
  dst varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
355
  PRIMARY KEY  (pid),
Dries's avatar
   
Dries committed
356
357
  UNIQUE KEY dst (dst),
  UNIQUE KEY src (src)
Dries's avatar
   
Dries committed
358
359
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
360
361
362
--
-- Table structure for table 'permission'
--
363
364
365

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
366
  perm longtext,
367
368
369
370
  tid int(10) unsigned NOT NULL default '0',
  KEY rid (rid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
371
372
373
--
-- Table structure for table 'poll'
--
374

375
CREATE TABLE poll (
376
377
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
Dries's avatar
   
Dries committed
378
  voters longtext NOT NULL,
379
  active int(2) unsigned NOT NULL default '0',
Steven Wittens's avatar
Steven Wittens committed
380
  PRIMARY KEY  (nid)
381
) TYPE=MyISAM;
382

Kjartan's avatar
Kjartan committed
383
384
385
--
-- Table structure for table 'poll_choices'
--
386

387
CREATE TABLE poll_choices (
388
389
390
391
392
  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',
Kjartan's avatar
Kjartan committed
393
394
  PRIMARY KEY  (chid),
  KEY nid (nid)
395
396
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
397
398
399
--
-- Table structure for table 'role'
--
400

Dries's avatar
   
Dries committed
401
CREATE TABLE role (
402
403
404
405
406
  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
407

Kjartan's avatar
Kjartan committed
408
409
410
--
-- Table structure for table 'search_index'
--
411
412

CREATE TABLE search_index (
Kjartan's avatar
Kjartan committed
413
414
415
416
417
418
419
420
  word varchar(50) NOT NULL default '',
  lno int(10) unsigned NOT NULL default '0',
  type varchar(16) default NULL,
  count int(10) unsigned default NULL,
  KEY lno (lno),
  KEY word (word)
) TYPE=MyISAM;

Dries's avatar
   
Dries committed
421
--
422
-- Table structure for table 'sessions'
Dries's avatar
   
Dries committed
423
424
425
426
427
428
429
430
--


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',
Dries's avatar
   
Dries committed
431
  session longtext,
Dries's avatar
   
Dries committed
432
433
434
435
436
  KEY uid (uid),
  KEY sid (sid(4)),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
437
438
439
440
441
442
443
444
--
-- Table structure for table 'sequences'
--

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

Kjartan's avatar
Kjartan committed
447
--
Dries's avatar
   
Dries committed
448
-- Table structure for table 'node_counter'
Kjartan's avatar
Kjartan committed
449
450
--

Dries's avatar
   
Dries committed
451
CREATE TABLE node_counter (
Kjartan's avatar
Kjartan committed
452
453
454
455
456
457
458
459
460
461
462
463
464
  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',
  PRIMARY KEY  (nid),
  KEY totalcount (totalcount),
  KEY daycount (daycount),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

--
-- Table structure for table 'system'
--
465
466
467
468
469
470
471

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
472
  throttle tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
473
  bootstrap int(2) NOT NULL default '0',
474
  PRIMARY KEY  (filename)
Dries's avatar
   
Dries committed
475
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
476

Kjartan's avatar
Kjartan committed
477
478
479
--
-- Table structure for table 'term_data'
--
480
481
482
483
484

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
485
  description longtext,
486
487
488
489
490
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY vid (vid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
491
492
493
--
-- Table structure for table 'term_hierarchy'
--
494
495
496
497
498
499
500
501

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
502
503
504
--
-- Table structure for table 'term_node'
--
505
506
507
508
509
510
511
512

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;

Kjartan's avatar
Kjartan committed
513
514
515
--
-- Table structure for table 'term_relation'
--
516
517
518
519
520
521
522
523

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
524
525
526
--
-- Table structure for table 'term_synonym'
--
527
528
529
530
531
532
533
534

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
535
536
537
--
-- Table structure for table 'users'
--
538

Dries's avatar
 
Dries committed
539
CREATE TABLE users (
Dries's avatar
   
Dries committed
540
  uid int(10) unsigned NOT NULL default '0',
541
542
543
544
545
546
547
548
  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
549
550
  created int(11) NOT NULL default '0',
  changed int(11) NOT NULL default '0',
551
552
553
  status tinyint(4) NOT NULL default '0',
  timezone varchar(8) default NULL,
  language char(2) NOT NULL default '',
Dries's avatar
   
Dries committed
554
  picture varchar(255) NOT NULL DEFAULT '',
555
  init varchar(64) default '',
Dries's avatar
   
Dries committed
556
  data longtext,
557
  rid int(10) unsigned NOT NULL default '0',
558
  PRIMARY KEY  (uid),
Kjartan's avatar
Kjartan committed
559
  UNIQUE KEY name (name),
560
  KEY changed (changed)
561
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
562

Kjartan's avatar
Kjartan committed
563
564
565
--
-- Table structure for table 'variable'
--
566

Dries's avatar
   
Dries committed
567
CREATE TABLE variable (
Dries's avatar
   
Dries committed
568
  name varchar(48) NOT NULL default '',
Dries's avatar
   
Dries committed
569
  value longtext NOT NULL,
570
571
  PRIMARY KEY  (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
572

Kjartan's avatar
Kjartan committed
573
574
575
--
-- Table structure for table 'vocabulary'
--
576
577
578
579

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
580
  description longtext,
581
582
583
584
  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
585
  nodes longtext,
586
587
588
589
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (vid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
590
591
592
--
-- Table structure for table 'watchdog'
--
593

Dries's avatar
 
Dries committed
594
CREATE TABLE watchdog (
595
596
597
  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
598
  message longtext NOT NULL,
599
  link varchar(255) NOT NULL default '',
600
601
602
603
604
605
  location varchar(128) NOT NULL default '',
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  PRIMARY KEY  (wid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
606
607
608
--
-- Insert some default values
--
Dries's avatar
   
Dries committed
609

Dries's avatar
   
Dries committed
610
611
612
613
614
615
616
617
618
INSERT INTO system VALUES ('modules/admin.module','admin','module','',1,0,0);
INSERT INTO system VALUES ('modules/block.module','block','module','',1,0,0);
INSERT INTO system VALUES ('modules/comment.module','comment','module','',1,0,0);
INSERT INTO system VALUES ('modules/help.module','help','module','',1,0,0);
INSERT INTO system VALUES ('modules/node.module','node','module','',1,0,0);
INSERT INTO system VALUES ('modules/page.module','page','module','',1,0,0);
INSERT INTO system VALUES ('modules/story.module','story','module','',1,0,0);
INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1,0,0);
INSERT INTO system VALUES ('themes/xtemplate/xtemplate.theme','xtemplate','theme','Internet explorer, Netscape, Opera',1,0,0);
Dries's avatar
   
Dries committed
619
INSERT INTO users (uid, name, mail, rid) VALUES ('0', '', '', '1');
Dries's avatar
   
Dries committed
620
621

INSERT INTO role (rid, name) VALUES (1, 'anonymous user');
Dries's avatar
   
Dries committed
622
INSERT INTO permission VALUES (1,'access content',0);
Dries's avatar
   
Dries committed
623
624

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

Kjartan's avatar
Kjartan committed
627
REPLACE variable SET name='update_start', value='s:10:"2004-02-21;"';
Dries's avatar
   
Dries committed
628
REPLACE variable SET name='theme_default', value='s:9:"xtemplate";';
Kjartan's avatar
Kjartan committed
629

Dries's avatar
   
Dries committed
630
631
REPLACE blocks SET module = 'user', delta = '0', status = '1';
REPLACE blocks SET module = 'user', delta = '1', status = '1';
632