database.mysql 14.2 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 72
  KEY nid (nid),
  KEY parent (parent)
73
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
74

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

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

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

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

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

Dries's avatar
 
Dries committed
106
CREATE TABLE cache (
107
  cid varchar(255) NOT NULL default '',
Dries's avatar
 
Dries committed
108
  data longtext,
109
  expire int(11) NOT NULL default '0',
Dries's avatar
 
Dries committed
110
  created int(11) NOT NULL default '0',
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 127
  hostname varchar(128) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  link varchar(16) NOT NULL default '',
Kjartan's avatar
Kjartan committed
128 129
  score mediumint(9) NOT NULL default '0',
  status tinyint(3) unsigned NOT NULL default '0',
130
  thread varchar(255) NOT NULL,
Dries's avatar
 
Dries committed
131
  users longtext,
132 133 134
  PRIMARY KEY  (cid),
  KEY lid (nid)
) TYPE=MyISAM;
Dries's avatar
 
Dries committed
135

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

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

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

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

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

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

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

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
190

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

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

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

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

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

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

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

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

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

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

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

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

Kjartan's avatar
Kjartan committed
318 319 320
--
-- Table structure for table 'permission'
--
321 322 323

CREATE TABLE permission (
  rid int(10) unsigned NOT NULL default '0',
Dries's avatar
 
Dries committed
324
  perm longtext,
325 326 327 328
  tid int(10) unsigned NOT NULL default '0',
  KEY rid (rid)
) TYPE=MyISAM;

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

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

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

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

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

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

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

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


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
389
  session longtext,
Dries's avatar
 
Dries committed
390 391 392 393 394
  KEY uid (uid),
  KEY sid (sid(4)),
  KEY timestamp (timestamp)
) TYPE=MyISAM;

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

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

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

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

Kjartan's avatar
Kjartan committed
435 436 437
--
-- Table structure for table 'term_data'
--
438 439 440 441 442

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
443
  description longtext,
444 445 446 447 448
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY vid (vid)
) TYPE=MyISAM;

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

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

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

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

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

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

Kjartan's avatar
Kjartan committed
519 520 521
--
-- Table structure for table 'variable'
--
522

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

Kjartan's avatar
Kjartan committed
529 530 531
--
-- Table structure for table 'vocabulary'
--
532 533 534 535

CREATE TABLE vocabulary (
  vid int(10) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
Dries's avatar
 
Dries committed
536
  description longtext,
537 538 539 540
  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
541
  nodes longtext,
542 543 544 545
  weight tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (vid)
) TYPE=MyISAM;

Kjartan's avatar
Kjartan committed
546 547 548
--
-- Table structure for table 'watchdog'
--
549

Dries's avatar
 
Dries committed
550
CREATE TABLE watchdog (
551 552 553
  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
554
  message longtext NOT NULL,
555
  link varchar(255) NOT NULL default '',
556 557 558 559 560 561
  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
562 563 564
--
-- Insert some default values
--
Dries's avatar
 
Dries committed
565

Dries's avatar
 
Dries committed
566 567 568 569 570 571 572 573 574
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
575
INSERT INTO users (uid, name, mail, rid) VALUES ('0', '', '', '1');
Kjartan's avatar
Kjartan committed
576

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

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