database.mysql 14 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
56
  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,
  custom tinyint(2) DEFAULT '0' NOT NULL
57
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
58

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

Dries's avatar
   
Dries committed
63
CREATE TABLE book (
64
65
66
67
  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',
68
  log text,
69
  PRIMARY KEY  (nid),
Dries's avatar
   
Dries committed
70
71
  KEY nid (nid),
  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 text,
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 '',
107
  data mediumtext,
108
  expire int(11) NOT NULL default '0',
Dries's avatar
   
Dries committed
109
  created int(11) NOT NULL default '0',
110
111
  PRIMARY KEY  (cid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
112

Kjartan's avatar
Kjartan 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
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  link varchar(16) NOT NULL default '',
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,
Kjartan's avatar
Kjartan committed
130
  users mediumtext,
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
143
144
145
146
147
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
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
158
  refresh int(10) NOT NULL default '0',
  timestamp 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 text NOT NULL,
162
  PRIMARY KEY  (fid),
Kjartan's avatar
Kjartan committed
163
164
165
166
167
168
169
170
  UNIQUE KEY link (url),
  UNIQUE KEY title (title)
) TYPE=MyISAM;

--
-- Table structure for table 'forum'
--

Dries's avatar
   
Dries committed
171
CREATE TABLE forum (
Kjartan's avatar
Kjartan committed
172
  nid int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
173
  tid int(10) unsigned NOT NULL default '0',
Kjartan's avatar
Kjartan committed
174
175
  icon varchar(255) NOT NULL default '',
  shadow int(10) unsigned NOT NULL default '0',
Dries's avatar
   
Dries committed
176
  PRIMARY KEY  (nid)
177
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
178

Kjartan's avatar
Kjartan committed
179
180
181
--
-- Table structure for table 'history'
--
182
183
184
185
186
187
188

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
189

Kjartan's avatar
Kjartan committed
190
191
192
--
-- Table structure for table 'item'
--
193

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

Kjartan's avatar
Kjartan committed
206
207
208
--
-- Table structure for table 'locales'
--
209

Dries's avatar
   
Dries committed
210
CREATE TABLE locales (
211
212
  lid int(10) NOT NULL auto_increment,
  location varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
213
214
215
216
217
218
219
220
221
  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,
222
223
224
  PRIMARY KEY  (lid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
225
226
227
--
-- Table structure for table 'moderation_filters'
--
228

Kjartan's avatar
Kjartan committed
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
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
244
245
  KEY idx_rid (rid),
  KEY idx_mid (mid)
246
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
247

Kjartan's avatar
Kjartan committed
248
249
250
251
252
253
254
255
256
257
258
259
260
261
--
-- 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'
--
262

Dries's avatar
   
Dries committed
263
CREATE TABLE node (
264
265
266
267
268
269
270
271
272
273
274
  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
275
  users text NOT NULL,
276
277
  attributes varchar(255) NOT NULL default '',
  teaser text NOT NULL,
Dries's avatar
   
Dries committed
278
  body mediumtext NOT NULL,
279
280
  changed int(11) NOT NULL default '0',
  revisions text NOT NULL,
281
  static int(2) NOT NULL default '0',
282
  PRIMARY KEY  (nid),
Dries's avatar
   
Dries committed
283
284
  KEY node_type (type(4)),
  KEY node_title_type (title,type(4)),
285
  KEY status (status),
Dries's avatar
   
Dries committed
286
287
288
  KEY uid (uid),
  KEY node_moderate (moderate),
  KEY node_promote_status (promote, status)
289
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
290

Kjartan's avatar
Kjartan committed
291
292
293
--
-- Table structure for table 'page'
--
294

Dries's avatar
   
Dries committed
295
CREATE TABLE page (
296
297
298
  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
299
  description varchar(128) NOT NULL default '',
300
301
302
  PRIMARY KEY  (nid),
  KEY nid (nid)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
303

Dries's avatar
   
Dries committed
304
--
Dries's avatar
   
Dries committed
305
-- Table structure for table 'url_alias'
Dries's avatar
   
Dries committed
306
307
--

Dries's avatar
   
Dries committed
308
CREATE TABLE url_alias (
Dries's avatar
   
Dries committed
309
  pid int(10) unsigned NOT NULL auto_increment,
Dries's avatar
   
Dries committed
310
311
  src varchar(128) NOT NULL default '',
  dst varchar(128) NOT NULL default '',
Dries's avatar
   
Dries committed
312
  PRIMARY KEY  (pid),
Dries's avatar
   
Dries committed
313
314
  UNIQUE KEY dst (dst),
  UNIQUE KEY src (src)
Dries's avatar
   
Dries committed
315
316
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
317
318
319
--
-- Table structure for table 'permission'
--
320
321
322
323
324
325
326
327

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;

Kjartan's avatar
Kjartan committed
328
329
330
--
-- Table structure for table 'poll'
--
331

332
CREATE TABLE poll (
333
334
  nid int(10) unsigned NOT NULL default '0',
  runtime int(10) NOT NULL default '0',
335
  voters text NOT NULL,
336
  active int(2) unsigned NOT NULL default '0',
Steven Wittens's avatar
Steven Wittens committed
337
  PRIMARY KEY  (nid)
338
) TYPE=MyISAM;
339

Kjartan's avatar
Kjartan committed
340
341
342
--
-- Table structure for table 'poll_choices'
--
343

344
CREATE TABLE poll_choices (
345
346
347
348
349
  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
350
351
  PRIMARY KEY  (chid),
  KEY nid (nid)
352
353
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
354
355
356
--
-- Table structure for table 'role'
--
357

Dries's avatar
   
Dries committed
358
CREATE TABLE role (
359
360
361
362
363
  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
364

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

CREATE TABLE search_index (
Kjartan's avatar
Kjartan committed
370
371
372
373
374
375
376
377
  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
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
--
-- Table structure for table 'sessesions'
--


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',
  session text,
  KEY uid (uid),
  KEY sid (sid(4)),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
394
395
396
397
398
399
400
401
--
-- 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)
402
403
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
404
--
Dries's avatar
   
Dries committed
405
-- Table structure for table 'node_counter'
Kjartan's avatar
Kjartan committed
406
407
--

Dries's avatar
   
Dries committed
408
CREATE TABLE node_counter (
Kjartan's avatar
Kjartan committed
409
410
411
412
413
414
415
416
417
418
419
420
421
  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'
--
422
423
424
425
426
427
428

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
429
  bootstrap int(2) NOT NULL default '0',
430
  PRIMARY KEY  (filename)
Dries's avatar
   
Dries committed
431
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
432

Kjartan's avatar
Kjartan committed
433
434
435
--
-- Table structure for table 'term_data'
--
436
437
438
439
440
441
442
443
444
445
446

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;

Kjartan's avatar
Kjartan committed
447
448
449
--
-- Table structure for table 'term_hierarchy'
--
450
451
452
453
454
455
456
457

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
458
459
460
--
-- Table structure for table 'term_node'
--
461
462
463
464
465
466
467
468

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

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

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
491
492
493
--
-- Table structure for table 'users'
--
494

Dries's avatar
 
Dries committed
495
CREATE TABLE users (
Dries's avatar
   
Dries committed
496
  uid int(10) unsigned NOT NULL default '0',
497
498
499
500
501
502
503
504
505
506
507
508
509
  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 '',
510
  data text,
511
  rid int(10) unsigned NOT NULL default '0',
512
  PRIMARY KEY  (uid),
Kjartan's avatar
Kjartan committed
513
514
  UNIQUE KEY name (name),
  KEY timestamp (timestamp)
515
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
516

Kjartan's avatar
Kjartan committed
517
518
519
--
-- Table structure for table 'variable'
--
520

Dries's avatar
   
Dries committed
521
CREATE TABLE variable (
Dries's avatar
   
Dries committed
522
  name varchar(48) NOT NULL default '',
Dries's avatar
   
Dries committed
523
  value text NOT NULL,
524
525
  PRIMARY KEY  (name)
) TYPE=MyISAM;
Dries's avatar
   
Dries committed
526

Kjartan's avatar
Kjartan committed
527
528
529
--
-- Table structure for table 'vocabulary'
--
530
531
532
533
534
535
536
537
538

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',
Dries's avatar
   
Dries committed
539
  nodes text,
540
541
542
543
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (vid)
) TYPE=MyISAM;

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

Dries's avatar
 
Dries committed
548
CREATE TABLE watchdog (
549
550
551
  wid int(5) NOT NULL auto_increment,
  uid int(10) NOT NULL default '0',
  type varchar(16) NOT NULL default '',
Kjartan's avatar
Kjartan committed
552
  message text NOT NULL,
553
  link varchar(255) NOT NULL default '',
554
555
556
557
558
559
  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
560
561
562
--
-- Insert some default values
--
Dries's avatar
   
Dries committed
563

Dries's avatar
   
Dries committed
564
INSERT INTO system VALUES ('modules/admin.module','admin','module','',1);
Dries's avatar
   
Dries committed
565
566
567
568
569
570
571
INSERT INTO system VALUES ('modules/block.module','block','module','',1);
INSERT INTO system VALUES ('modules/comment.module','comment','module','',1);
INSERT INTO system VALUES ('modules/help.module','help','module','',1);
INSERT INTO system VALUES ('modules/node.module','node','module','',1);
INSERT INTO system VALUES ('modules/page.module','page','module','',1);
INSERT INTO system VALUES ('modules/story.module','story','module','',1);
INSERT INTO system VALUES ('modules/taxonomy.module','taxonomy','module','',1);
572
INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Internet explorer, Netscape, Opera',1);
Dries's avatar
   
Dries committed
573
INSERT INTO users (uid, name, mail, rid) VALUES ('0', '', '', '1');
Kjartan's avatar
Kjartan committed
574

Dries's avatar
   
Dries committed
575
REPLACE variable SET name='update_start', value='s:10:"2003-10-27;"';
Kjartan's avatar
Kjartan committed
576
577
REPLACE variable SET name='theme_default', value='s:6:"marvin";';

Dries's avatar
   
Dries committed
578
579
REPLACE blocks SET module = 'user', delta = '0', status = '1';
REPLACE blocks SET module = 'user', delta = '1', status = '1';
580