database.mysql 14.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
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
285
286
287
  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
288
289
290
  users longtext NOT NULL,
  teaser longtext NOT NULL,
  body longtext NOT NULL,
291
  changed int(11) NOT NULL default '0',
Dries's avatar
   
Dries committed
292
  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
--
Dries's avatar
   
Dries committed
316
-- Table structure for table 'url_alias'
Dries's avatar
   
Dries committed
317
318
--

Dries's avatar
   
Dries committed
319
CREATE TABLE url_alias (
Dries's avatar
   
Dries committed
320
  pid int(10) unsigned NOT NULL auto_increment,
Dries's avatar
   
Dries committed
321
322
  src varchar(128) NOT NULL default '',
  dst varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
323
  PRIMARY KEY  (pid),
Dries's avatar
   
Dries committed
324
325
  UNIQUE KEY dst (dst),
  UNIQUE KEY src (src)
Dries's avatar
   
Dries committed
326
327
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
328
329
330
--
-- Table structure for table 'permission'
--
331
332
333

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
334
  perm longtext,
335
336
337
338
  tid int(10) unsigned NOT NULL default '0',
  KEY rid (rid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
339
340
341
--
-- Table structure for table 'poll'
--
342

343
CREATE TABLE poll (
344
345
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
Dries's avatar
   
Dries committed
346
  voters longtext NOT NULL,
347
  active int(2) unsigned NOT NULL default '0',
Steven Wittens's avatar
Steven Wittens committed
348
  PRIMARY KEY  (nid)
349
) TYPE=MyISAM;
350

Kjartan's avatar
Kjartan committed
351
352
353
--
-- Table structure for table 'poll_choices'
--
354

355
CREATE TABLE poll_choices (
356
357
358
359
360
  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
361
362
  PRIMARY KEY  (chid),
  KEY nid (nid)
363
364
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
365
366
367
--
-- Table structure for table 'role'
--
368

Dries's avatar
   
Dries committed
369
CREATE TABLE role (
370
371
372
373
374
  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
375

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

CREATE TABLE search_index (
Kjartan's avatar
Kjartan committed
381
382
383
384
385
386
387
388
  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
389
--
390
-- Table structure for table 'sessions'
Dries's avatar
   
Dries committed
391
392
393
394
395
396
397
398
--


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
399
  session longtext,
Dries's avatar
   
Dries committed
400
401
402
403
404
  KEY uid (uid),
  KEY sid (sid(4)),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
405
406
407
408
409
410
411
412
--
-- 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)
413
414
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
415
--
Dries's avatar
   
Dries committed
416
-- Table structure for table 'node_counter'
Kjartan's avatar
Kjartan committed
417
418
--

Dries's avatar
   
Dries committed
419
CREATE TABLE node_counter (
Kjartan's avatar
Kjartan committed
420
421
422
423
424
425
426
427
428
429
430
431
432
  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'
--
433
434
435
436
437
438
439

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
440
  throttle tinyint(1) DEFAULT '0' NOT NULL,
Dries's avatar
   
Dries committed
441
  bootstrap int(2) NOT NULL default '0',
442
  PRIMARY KEY  (filename)
Dries's avatar
   
Dries committed
443
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
444

Kjartan's avatar
Kjartan committed
445
446
447
--
-- Table structure for table 'term_data'
--
448
449
450
451
452

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
453
  description longtext,
454
455
456
457
458
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY vid (vid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
459
460
461
--
-- Table structure for table 'term_hierarchy'
--
462
463
464
465
466
467
468
469

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
470
471
472
--
-- Table structure for table 'term_node'
--
473
474
475
476
477
478
479
480

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
481
482
483
--
-- Table structure for table 'term_relation'
--
484
485
486
487
488
489
490
491

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
492
493
494
--
-- Table structure for table 'term_synonym'
--
495
496
497
498
499
500
501
502

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
503
504
505
--
-- Table structure for table 'users'
--
506

Dries's avatar
   
Dries committed
507
CREATE TABLE users (
Dries's avatar
   
Dries committed
508
  uid int(10) unsigned NOT NULL default '0',
509
510
511
512
513
514
515
516
517
518
519
520
521
  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 '',
  timestamp int(11) NOT NULL default '0',
  status tinyint(4) NOT NULL default '0',
  timezone varchar(8) default NULL,
  language char(2) NOT NULL default '',
  init varchar(64) default '',
Dries's avatar
   
Dries committed
522
  data longtext,
523
  rid int(10) unsigned NOT NULL default '0',
524
  PRIMARY KEY  (uid),
Kjartan's avatar
Kjartan committed
525
526
  UNIQUE KEY name (name),
  KEY timestamp (timestamp)
527
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
528

Kjartan's avatar
Kjartan committed
529
530
531
--
-- Table structure for table 'variable'
--
532

Dries's avatar
   
Dries committed
533
CREATE TABLE variable (
Dries's avatar
   
Dries committed
534
  name varchar(48) NOT NULL default '',
Dries's avatar
   
Dries committed
535
  value longtext NOT NULL,
536
537
  PRIMARY KEY  (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
538

Kjartan's avatar
Kjartan committed
539
540
541
--
-- Table structure for table 'vocabulary'
--
542
543
544
545

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
Dries's avatar
   
Dries committed
546
  description longtext,
547
548
549
550
  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
551
  nodes longtext,
552
553
554
555
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (vid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
556
557
558
--
-- Table structure for table 'watchdog'
--
559

Dries's avatar
   
Dries committed
560
CREATE TABLE watchdog (
561
562
563
  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
564
  message longtext NOT NULL,
565
  link varchar(255) NOT NULL default '',
566
567
568
569
570
571
  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
572
573
574
--
-- Insert some default values
--
Dries's avatar
   
Dries committed
575

Dries's avatar
   
Dries committed
576
577
578
579
580
581
582
583
584
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
585
INSERT INTO users (uid, name, mail, rid) VALUES ('0', '', '', '1');
Dries's avatar
   
Dries committed
586
587

INSERT INTO role (rid, name) VALUES (1, 'anonymous user');
Dries's avatar
   
Dries committed
588
INSERT INTO permission VALUES (1,'access content',0);
Dries's avatar
   
Dries committed
589
590

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

Dries's avatar
   
Dries committed
593
REPLACE variable SET name='update_start', value='s:10:"2003-10-27;"';
Dries's avatar
   
Dries committed
594
REPLACE variable SET name='theme_default', value='s:9:"xtemplate";';
Kjartan's avatar
Kjartan committed
595

Dries's avatar
   
Dries committed
596
597
REPLACE blocks SET module = 'user', delta = '0', status = '1';
REPLACE blocks SET module = 'user', delta = '1', status = '1';
598