- Renewed the PostgreSQL database scheme! Patch by jaa.

1 files changed, 353 insertions, 953 deletions

diff --git a/database/database.pgsql b/database/database.pgsql
index c41d25496..a536f820c 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -1,1066 +1,466 @@
---
--- Selected TOC Entries:
---
-\connect - root
---
--- TOC Entry ID 1 (OID 0)
---
--- Name: drupal Type: DATABASE Owner: root
---
-
-Create Database "drupal";
-
-\connect drupal postgres
-\connect - postgres
---
--- TOC Entry ID 92 (OID 18720)
---
--- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: postgres
---
-
-CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
-
---
--- TOC Entry ID 93 (OID 18721)
---
--- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
---
-
-CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
-
-\connect - root
---
--- TOC Entry ID 27 (OID 46073)
---
--- Name: pga_queries Type: TABLE Owner: root
---
-
-CREATE TABLE "pga_queries" (
-  "queryname" character varying(64),
-  "querytype" character(1),
-  "querycommand" text,
-  "querytables" text,
-  "querylinks" text,
-  "queryresults" text,
-  "querycomments" text
-);
-
---
--- TOC Entry ID 28 (OID 46104)
---
--- Name: pga_forms Type: TABLE Owner: root
---
 
-CREATE TABLE "pga_forms" (
-  "formname" character varying(64),
-  "formsource" text
+CREATE TABLE access (
+  aid SERIAL,
+  mask varchar(255) NOT NULL default '',
+  type varchar(255) NOT NULL default '',
+  status smallint NOT NULL default '0',
+  PRIMARY KEY (aid),
+  UNIQUE (mask)
 );
 
---
--- TOC Entry ID 29 (OID 46130)
---
--- Name: pga_scripts Type: TABLE Owner: root
---
-
-CREATE TABLE "pga_scripts" (
-  "scriptname" character varying(64),
-  "scriptsource" text
-);
 
---
--- TOC Entry ID 30 (OID 46156)
---
--- Name: pga_reports Type: TABLE Owner: root
---
-
-CREATE TABLE "pga_reports" (
-  "reportname" character varying(64),
-  "reportsource" text,
-  "reportbody" text,
-  "reportprocs" text,
-  "reportoptions" text
+CREATE TABLE authmap (
+  aid SERIAL,
+  uid integer NOT NULL default '0',
+  authname varchar(128) NOT NULL default '',
+  module varchar(128) NOT NULL default '',
+  PRIMARY KEY (aid),
+  UNIQUE (authname)
 );
 
---
--- TOC Entry ID 31 (OID 46185)
---
--- Name: pga_schema Type: TABLE Owner: root
---
 
-CREATE TABLE "pga_schema" (
-  "schemaname" character varying(64),
-  "schematables" text,
-  "schemalinks" text
+CREATE TABLE blocks (
+  name varchar(64) NOT NULL default '',
+  module varchar(64) NOT NULL default '',
+  delta smallint NOT NULL default '0',
+  status smallint NOT NULL default '0',
+  weight smallint NOT NULL default '0',
+  region smallint NOT NULL default '0',
+  remove smallint NOT NULL default '0',
+  path varchar(255) NOT NULL default '',
+  custom smallint NOT NULL default '0',
+  PRIMARY KEY  (name)
 );
 
---
--- TOC Entry ID 2 (OID 46212)
---
--- Name: access_aid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "access_aid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 32 (OID 46231)
---
--- Name: access Type: TABLE Owner: root
---
-
-CREATE TABLE "access" (
-  "aid" integer DEFAULT nextval('"access_aid_seq"'::text) NOT NULL,
-  "mask" character varying(255) NOT NULL,
-  "type" character varying(255) NOT NULL,
-  "status" smallint NOT NULL,
-  Constraint "access_pkey" Primary Key ("aid")
-);
 
---
--- TOC Entry ID 3 (OID 46317)
---
--- Name: boxes_bid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "boxes_bid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 33 (OID 46336)
---
--- Name: boxes Type: TABLE Owner: root
---
-
-CREATE TABLE "boxes" (
-  "bid" integer DEFAULT nextval('"boxes_bid_seq"'::text) NOT NULL,
-  "title" character varying(64) NOT NULL,
-  "body" text NOT NULL,
-  "info" character varying(128) NOT NULL,
-  "type" smallint NOT NULL,
-  Constraint "boxes_pkey" Primary Key ("bid")
+CREATE TABLE book (
+  nid integer NOT NULL default '0',
+  parent integer NOT NULL default '0',
+  weight smallint NOT NULL default '0',
+  format smallint default '0',
+  log text,
+  PRIMARY KEY (nid)
 );
 
---
--- TOC Entry ID 4 (OID 46369)
---
--- Name: bundle_bid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "bundle_bid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 34 (OID 46388)
---
--- Name: bundle Type: TABLE Owner: root
---
-
-CREATE TABLE "bundle" (
-  "bid" integer DEFAULT nextval('"bundle_bid_seq"'::text) NOT NULL,
-  "title" character varying(255) NOT NULL,
-  "attributes" character varying(255) NOT NULL,
-  Constraint "bundle_pkey" Primary Key ("bid")
-);
+CREATE INDEX book_nid_idx ON book(nid);
 
---
--- TOC Entry ID 35 (OID 46404)
---
--- Name: cache Type: TABLE Owner: root
---
-
-CREATE TABLE "cache" (
-  "url" character varying(255) NOT NULL,
-  "data" text NOT NULL,
-  "timestamp" integer NOT NULL,
-  Constraint "cache_pkey" Primary Key ("url")
-);
 
---
--- TOC Entry ID 5 (OID 46434)
---
--- Name: category_cid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "category_cid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 36 (OID 46453)
---
--- Name: category Type: TABLE Owner: root
---
-
-CREATE TABLE "category" (
-  "cid" integer DEFAULT nextval('"category_cid_seq"'::text) NOT NULL,
-  "name" character varying(32) NOT NULL,
-  "type" character varying(16) NOT NULL,
-  "post" integer NOT NULL,
-  "dump" integer NOT NULL,
-  "expire" integer NOT NULL,
-  "comment" integer NOT NULL,
-  "submission" integer NOT NULL,
-  "promote" integer NOT NULL,
-  Constraint "category_pkey" Primary Key ("cid")
+CREATE TABLE boxes (
+  bid SERIAL,
+  title varchar(64) NOT NULL default '',
+  body text,
+  info varchar(128) NOT NULL default '',
+  type smallint NOT NULL default '0',
+  PRIMARY KEY  (bid),
+  UNIQUE (info),
+  UNIQUE (title)
 );
 
---
--- TOC Entry ID 6 (OID 46475)
---
--- Name: channel_id_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "channel_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 37 (OID 46494)
---
--- Name: channel Type: TABLE Owner: root
---
-
-CREATE TABLE "channel" (
-  "id" integer DEFAULT nextval('"channel_id_seq"'::text) NOT NULL,
-  "site" character varying(255) NOT NULL,
-  "file" character varying(255) NOT NULL,
-  "url" character varying(255) NOT NULL,
-  "contact" character varying(255) NOT NULL,
-  "timestamp" integer NOT NULL,
-  Constraint "channel_pkey" Primary Key ("id")
-);
 
---
--- TOC Entry ID 7 (OID 46513)
---
--- Name: chatevents_id_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "chatevents_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 38 (OID 46532)
---
--- Name: chatevents Type: TABLE Owner: root
---
-
-CREATE TABLE "chatevents" (
-  "id" integer DEFAULT nextval('"chatevents_id_seq"'::text) NOT NULL,
-  "body" character varying(255) NOT NULL,
-  "timestamp" integer NOT NULL,
-  Constraint "chatevents_pkey" Primary Key ("id")
+CREATE TABLE bundle (
+  bid SERIAL,
+  title varchar(255) NOT NULL default '',
+  attributes varchar(255) NOT NULL default '',
+  PRIMARY KEY  (bid),
+  UNIQUE (title)
 );
 
---
--- TOC Entry ID 8 (OID 46548)
---
--- Name: chatmembers_id_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "chatmembers_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 39 (OID 46567)
---
--- Name: chatmembers Type: TABLE Owner: root
---
-
-CREATE TABLE "chatmembers" (
-  "id" integer DEFAULT nextval('"chatmembers_id_seq"'::text) NOT NULL,
-  "nick" character varying(32) NOT NULL,
-  "timestamp" integer NOT NULL,
-  Constraint "chatmembers_pkey" Primary Key ("id")
-);
 
---
--- TOC Entry ID 9 (OID 46583)
---
--- Name: collection_cid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "collection_cid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 40 (OID 46602)
---
--- Name: collection Type: TABLE Owner: root
---
-
-CREATE TABLE "collection" (
-  "cid" integer DEFAULT nextval('"collection_cid_seq"'::text) NOT NULL,
-  "name" character varying(32) NOT NULL,
-  "types" character varying(128) NOT NULL,
-  Constraint "collection_pkey" Primary Key ("cid")
+CREATE TABLE cache (
+  cid varchar(255) NOT NULL default '',
+  data text,
+  expire integer NOT NULL default '0',
+  PRIMARY KEY  (cid)
 );
 
---
--- TOC Entry ID 10 (OID 46618)
---
--- Name: comments_cid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "comments_cid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 41 (OID 46637)
---
--- Name: cvs Type: TABLE Owner: root
---
-
-CREATE TABLE "cvs" (
-  "username" character varying(32) NOT NULL,
-  "files" text NOT NULL,
-  "status" smallint NOT NULL,
-  "message" text NOT NULL,
-  "timestamp" integer NOT NULL
-);
 
---
--- TOC Entry ID 42 (OID 46695)
---
--- Name: pga_layout Type: TABLE Owner: root
---
-
-CREATE TABLE "pga_layout" (
-  "tablename" character varying(64),
-  "nrcols" smallint,
-  "colnames" text,
-  "colwidth" text
+CREATE TABLE collection (
+  cid SERIAL,
+  name varchar(32) NOT NULL default '',
+  types varchar(128) NOT NULL default '',
+  PRIMARY KEY  (cid),
+  UNIQUE (name)
 );
 
---
--- TOC Entry ID 11 (OID 46773)
---
--- Name: entry_eid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "entry_eid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 43 (OID 46792)
---
--- Name: entry Type: TABLE Owner: root
---
-
-CREATE TABLE "entry" (
-  "eid" integer DEFAULT nextval('"entry_eid_seq"'::text) NOT NULL,
-  "name" character varying NOT NULL,
-  "attributes" character varying(32) NOT NULL,
-  "collection" character varying(32),
-  Constraint "entry_pkey" Primary Key ("eid")
-);
 
---
--- TOC Entry ID 12 (OID 46824)
---
--- Name: feed_fid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "feed_fid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 44 (OID 46843)
---
--- Name: feed Type: TABLE Owner: root
---
-
-CREATE TABLE "feed" (
-  "fid" integer DEFAULT nextval('"feed_fid_seq"'::text) NOT NULL,
-  "title" character varying(255) NOT NULL,
-  "url" character varying(255) NOT NULL,
-  "refresh" integer NOT NULL,
-  "uncache" integer NOT NULL,
-  "timestamp" integer NOT NULL,
-  "attributes" character varying(255) NOT NULL,
-  "link" character varying(255) NOT NULL,
-  "description" text NOT NULL,
-  Constraint "feed_pkey" Primary Key ("fid")
+CREATE TABLE comments (
+  cid SERIAL,
+  pid integer NOT NULL default '0',
+  nid integer NOT NULL default '0',
+  uid integer NOT NULL default '0',
+  subject varchar(64) NOT NULL default '',
+  comment text NOT NULL,
+  hostname varchar(128) NOT NULL default '',
+  timestamp integer NOT NULL default '0',
+  link varchar(16) NOT NULL default '',
+  PRIMARY KEY  (cid)
 );
 
---
--- TOC Entry ID 13 (OID 46880)
---
--- Name: file_lid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "file_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 45 (OID 46899)
---
--- Name: file Type: TABLE Owner: root
---
-
-CREATE TABLE "file" (
-  "lid" integer DEFAULT nextval('"file_lid_seq"'::text) NOT NULL,
-  "nid" integer NOT NULL,
-  "version" character varying(10) NOT NULL,
-  "url" character varying(255) NOT NULL,
-  "downloads" integer NOT NULL,
-  "abstract" text NOT NULL,
-  "description" text NOT NULL,
-  "homepage" character varying(255) NOT NULL,
-  Constraint "file_pkey" Primary Key ("lid")
-);
+CREATE INDEX comments_lid_idx ON comments(nid);
 
---
--- TOC Entry ID 14 (OID 46935)
---
--- Name: forum_lid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "forum_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 15 (OID 46985)
---
--- Name: item_iid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "item_iid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 46 (OID 47004)
---
--- Name: item Type: TABLE Owner: root
---
-
-CREATE TABLE "item" (
-  "iid" integer DEFAULT nextval('"item_iid_seq"'::text) NOT NULL,
-  "fid" integer NOT NULL,
-  "title" character varying(255) NOT NULL,
-  "link" character varying(255) NOT NULL,
-  "author" character varying(255) NOT NULL,
-  "description" text NOT NULL,
-  "timestamp" integer NOT NULL,
-  "attributes" character varying(255) NOT NULL,
-  Constraint "item_pkey" Primary Key ("iid")
-);
-
---
--- TOC Entry ID 47 (OID 47040)
---
--- Name: layout Type: TABLE Owner: root
---
-
-CREATE TABLE "layout" (
-  "userid" integer NOT NULL,
-  "block" character varying(64) NOT NULL
-);
 
---
--- TOC Entry ID 16 (OID 47051)
---
--- Name: locales_id_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "locales_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 48 (OID 47070)
---
--- Name: locales Type: TABLE Owner: root
---
-
-CREATE TABLE "locales" (
-  "id" integer DEFAULT nextval('"locales_id_seq"'::text) NOT NULL,
-  "location" character varying(128) NOT NULL,
-  "string" text NOT NULL,
-  "da" text NOT NULL,
-  "fi" text NOT NULL,
-  "fr" text NOT NULL,
-  "en" text NOT NULL,
-  "es" text NOT NULL,
-  "nl" text NOT NULL,
-  "no" text NOT NULL,
-  "sw" text NOT NULL,
-  Constraint "locales_pkey" Primary Key ("id")
+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 integer NOT NULL default '0',
+  PRIMARY KEY  (link)
 );
 
---
--- TOC Entry ID 49 (OID 47109)
---
--- Name: modules Type: TABLE Owner: root
---
 
-CREATE TABLE "modules" (
-  "name" character varying(64) NOT NULL,
-  Constraint "modules_pkey" Primary Key ("name")
+CREATE TABLE feed (
+  fid SERIAL,
+  title varchar(255) NOT NULL default '',
+  url varchar(255) NOT NULL default '',
+  refresh integer default NULL,
+  timestamp integer default NULL,
+  attributes varchar(255) NOT NULL default '',
+  link varchar(255) NOT NULL default '',
+  description text NOT NULL,
+  PRIMARY KEY  (fid),
+  UNIQUE (title),
+  UNIQUE (url)
 );
 
---
--- TOC Entry ID 17 (OID 47122)
---
--- Name: node_nid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "node_nid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 50 (OID 47141)
---
--- Name: notify Type: TABLE Owner: root
---
-
-CREATE TABLE "notify" (
-  "uid" integer NOT NULL,
-  "status" integer NOT NULL,
-  "node" integer NOT NULL,
-  "comment" integer NOT NULL,
-  "attempts" integer NOT NULL,
-  Constraint "notify_pkey" Primary Key ("uid")
-);
 
---
--- TOC Entry ID 18 (OID 47211)
---
--- Name: poll_lid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "poll_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 51 (OID 47230)
---
--- Name: poll Type: TABLE Owner: root
---
-
-CREATE TABLE "poll" (
-  "lid" integer DEFAULT nextval('"poll_lid_seq"'::text) NOT NULL,
-  "nid" integer NOT NULL,
-  "runtime" integer NOT NULL,
-  "voters" text NOT NULL,
-  "active" integer NOT NULL,
-  Constraint "poll_pkey" Primary Key ("lid")
+CREATE TABLE history (
+  uid integer NOT NULL default '0',
+  nid integer NOT NULL default '0',
+  timestamp integer NOT NULL default '0',
+  PRIMARY KEY  (uid,nid)
 );
 
---
--- TOC Entry ID 19 (OID 47263)
---
--- Name: poll_choices_chid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "poll_choices_chid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 52 (OID 47282)
---
--- Name: poll_choices Type: TABLE Owner: root
---
-
-CREATE TABLE "poll_choices" (
-  "chid" integer DEFAULT nextval('"poll_choices_chid_seq"'::text) NOT NULL,
-  "nid" integer NOT NULL,
-  "chtext" character varying(128) DEFAULT '' NOT NULL,
-  "chvotes" integer NOT NULL,
-  "chorder" integer NOT NULL,
-  Constraint "poll_choices_pkey" Primary Key ("chid")
-);
 
---
--- TOC Entry ID 53 (OID 47301)
---
--- Name: rating Type: TABLE Owner: root
---
-
-CREATE TABLE "rating" (
-  "userid" integer NOT NULL,
-  "new" integer NOT NULL,
-  "old" integer NOT NULL,
-  Constraint "user_pkey" Primary Key ("userid")
+CREATE TABLE item (
+  iid SERIAL,
+  fid integer NOT NULL default '0',
+  title varchar(255) NOT NULL default '',
+  link varchar(255) NOT NULL default '',
+  author varchar(255) NOT NULL default '',
+  description text NOT NULL,
+  timestamp integer default NULL,
+  attributes varchar(255) NOT NULL default '',
+  PRIMARY KEY  (iid)
 );
 
---
--- TOC Entry ID 54 (OID 47316)
---
--- Name: referer Type: TABLE Owner: root
---
 
-CREATE TABLE "referer" (
-  "url" character varying(255) DEFAULT '' NOT NULL,
-  "timestamp" integer NOT NULL
+CREATE TABLE layout (
+  uid integer NOT NULL default '0',
+  block varchar(64) NOT NULL default ''
 );
 
---
--- TOC Entry ID 20 (OID 47328)
---
--- Name: role_rid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "role_rid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 21 (OID 47347)
---
--- Name: site_sid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "site_sid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 55 (OID 47366)
---
--- Name: site Type: TABLE Owner: root
---
-
-CREATE TABLE "site" (
-  "sid" integer DEFAULT nextval('"site_sid_seq"'::text) NOT NULL,
-  "name" character varying(128) DEFAULT '' NOT NULL,
-  "link" character varying(255) DEFAULT '' NOT NULL,
-  "size" text NOT NULL,
-  "timestamp" integer NOT NULL,
-  "feed" character varying(255) DEFAULT '' NOT NULL,
-  Constraint "site_pkey" Primary Key ("sid")
-);
 
---
--- TOC Entry ID 22 (OID 47454)
---
--- Name: tag_tid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "tag_tid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 56 (OID 47473)
---
--- Name: tag Type: TABLE Owner: root
---
-
-CREATE TABLE "tag" (
-  "tid" integer DEFAULT nextval('"tag_tid_seq"'::text) NOT NULL,
-  "name" character varying(32) DEFAULT '' NOT NULL,
-  "attributes" character varying(255) DEFAULT '' NOT NULL,
-  "collections" character varying(32) DEFAULT '' NOT NULL,
-  Constraint "tag_pkey" Primary Key ("tid")
+CREATE TABLE locales (
+  lid SERIAL,
+  location varchar(128) NOT NULL default '',
+  string text NOT NULL,
+  da text NOT NULL,
+  fi text NOT NULL,
+  fr text NOT NULL,
+  en text NOT NULL,
+  es text NOT NULL,
+  nl text NOT NULL,
+  no text NOT NULL,
+  sw text NOT NULL,
+  PRIMARY KEY  (lid)
 );
 
---
--- TOC Entry ID 23 (OID 47493)
---
--- Name: topic_tid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "topic_tid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 57 (OID 47512)
---
--- Name: topic Type: TABLE Owner: root
---
-
-CREATE TABLE "topic" (
-  "tid" integer DEFAULT nextval('"topic_tid_seq"'::text) NOT NULL,
-  "pid" integer NOT NULL,
-  "name" character varying(32) DEFAULT '' NOT NULL,
-  "moderate" text NOT NULL,
-  Constraint "topic_pkey" Primary Key ("tid")
-);
 
---
--- TOC Entry ID 24 (OID 47545)
---
--- Name: trip_link_lid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "trip_link_lid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 58 (OID 47564)
---
--- Name: trip_link Type: TABLE Owner: root
---
-
-CREATE TABLE "trip_link" (
-  "lid" integer DEFAULT nextval('"trip_link_lid_seq"'::text) NOT NULL,
-  "nid" integer NOT NULL,
-  "url" text NOT NULL,
-  "body" text NOT NULL,
-  Constraint "trip_link_pkey" Primary Key ("lid")
+CREATE TABLE moderate (
+  cid integer NOT NULL default '0',
+  nid integer NOT NULL default '0',
+  uid integer NOT NULL default '0',
+  score integer NOT NULL default '0',
+  timestamp integer NOT NULL default '0'
 );
 
---
--- TOC Entry ID 25 (OID 47596)
---
--- Name: users_uid_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "users_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
+CREATE INDEX moderate_cid_idx ON moderate(cid);
+CREATE INDEX moderate_nid_idx ON moderate(nid);
 
---
--- TOC Entry ID 59 (OID 47615)
---
--- Name: variable Type: TABLE Owner: root
---
 
-CREATE TABLE "variable" (
-  "name" character varying(32) DEFAULT '' NOT NULL,
-  "value" text NOT NULL,
-  Constraint "variable_pkey" Primary Key ("name")
+CREATE TABLE modules (
+  name varchar(64) NOT NULL default '',
+  PRIMARY KEY  (name)
 );
 
---
--- TOC Entry ID 26 (OID 47645)
---
--- Name: watchdog_id_seq Type: SEQUENCE Owner: root
---
-
-CREATE SEQUENCE "watchdog_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
-
---
--- TOC Entry ID 60 (OID 47664)
---
--- Name: watchdog Type: TABLE Owner: root
---
-
-CREATE TABLE "watchdog" (
-  "id" integer DEFAULT nextval('"watchdog_id_seq"'::text) NOT NULL,
-  "uid" integer NOT NULL,
-  "type" character varying(16) DEFAULT '' NOT NULL,
-  "message" character varying(255) DEFAULT '' NOT NULL,
-  "location" character varying(128) DEFAULT '' NOT NULL,
-  "hostname" character varying(128) DEFAULT '' NOT NULL,
-  "timestamp" integer NOT NULL,
-  Constraint "watchdog_pkey" Primary Key ("id")
-);
 
---
--- TOC Entry ID 61 (OID 47688)
---
--- Name: users Type: TABLE Owner: root
---
-
-CREATE TABLE "users" (
-  "uid" integer DEFAULT nextval('"users_uid_seq"'::text) NOT NULL,
-  "name" character varying(60) DEFAULT '' NOT NULL,
-  "mail" character varying(64) DEFAULT '',
-  "homepage" character varying(128) DEFAULT '',
-  "mode" integer,
-  "sort" integer,
-  "threshold" integer,
-  "theme" character varying(255) DEFAULT '',
-  "signature" character varying(255) DEFAULT '',
-  "last_access" integer,
-  "last_host" character varying(255),
-  "status" integer NOT NULL,
-  "timezone" character varying(8),
-  "rating" numeric(8,2),
-  "language" character(2) DEFAULT '',
-  "role" character varying(32) DEFAULT '' NOT NULL,
-  "session" character varying(128) DEFAULT '',
-  "hostname" character varying(128) DEFAULT '',
-  "timestamp" integer NOT NULL,
-  "jabber" character varying(128) DEFAULT '',
-  "drupal" character varying(128) DEFAULT '',
-  "init" character varying(64) DEFAULT '',
-  "real_email" character varying(64) DEFAULT '',
-  "pass" character varying(32) DEFAULT '',
-  Constraint "users_pkey" Primary Key ("uid")
+CREATE TABLE node (
+  nid SERIAL,
+  type varchar(16) NOT NULL default '',
+  title varchar(128) NOT NULL default '',
+  score integer NOT NULL default '0',
+  votes integer NOT NULL default '0',
+  uid integer NOT NULL default '0',
+  status integer NOT NULL default '1',
+  created integer NOT NULL default '0',
+  comment integer NOT NULL default '0',
+  promote integer NOT NULL default '0',
+  moderate integer NOT NULL default '0',
+  users text NOT NULL,
+  attributes varchar(255) NOT NULL default '',
+  teaser text NOT NULL,
+  body text NOT NULL,
+  changed integer NOT NULL default '0',
+  revisions text NOT NULL,
+  static integer NOT NULL default '0',
+  PRIMARY KEY  (nid)
 );
 
---
--- TOC Entry ID 62 (OID 47739)
---
--- Name: blocks Type: TABLE Owner: root
---
-
-CREATE TABLE "blocks" (
-  "name" character varying(64) NOT NULL,
-  "module" character varying(64) NOT NULL,
-  "delta" smallint NOT NULL,
-  "status" smallint,
-  "weight" smallint,
-  "region" smallint,
-  "remove" smallint,
-  Constraint "blocks_pkey" Primary Key ("name")
-);
+CREATE INDEX node_type_idx ON node(type);
+CREATE INDEX node_title_idx ON node(title,type);
+CREATE INDEX node_promote_idx ON node(promote);
+CREATE INDEX node_status_idx ON node(status);
+CREATE INDEX node_uid_idx ON node(uid);
 
---
--- TOC Entry ID 63 (OID 47758)
---
--- Name: role Type: TABLE Owner: root
---
-
-CREATE TABLE "role" (
-  "rid" integer DEFAULT nextval('"role_rid_seq"'::text) NOT NULL,
-  "name" character varying(32) DEFAULT '' NOT NULL,
-  "perm" text,
-  Constraint "role_pkey" Primary Key ("rid")
-);
 
---
--- TOC Entry ID 64 (OID 47790)
---
--- Name: node Type: TABLE Owner: root
---
-
-CREATE TABLE "node" (
-  "nid" integer DEFAULT nextval('"node_nid_seq"'::text) NOT NULL,
-  "lid" integer NOT NULL,
-  "type" character varying(16) NOT NULL,
-  "score" integer NOT NULL,
-  "votes" integer NOT NULL,
-  "uid" integer NOT NULL,
-  "status" integer NOT NULL,
-  "timestamp" integer NOT NULL,
-  "comment" smallint NOT NULL,
-  "promote" smallint NOT NULL,
-  "moderate" text NOT NULL,
-  "users" text,
-  "timestamp_posted" integer,
-  "timestamp_queued" integer,
-  "timestamp_hidden" integer,
-  "attributes" character varying(255),
-  "title" character varying(128),
-  Constraint "node_pkey" Primary Key ("nid")
-);
 
---
--- TOC Entry ID 65 (OID 47871)
---
--- Name: moderate Type: TABLE Owner: root
---
-
-CREATE TABLE "moderate" (
-  "cid" integer,
-  "nid" integer,
-  "uid" integer NOT NULL,
-  "score" smallint NOT NULL,
-  "timestamp" integer NOT NULL
+CREATE TABLE page (
+  nid integer NOT NULL default '0',
+  link varchar(128) NOT NULL default '',
+  format smallint NOT NULL default '0',
+  PRIMARY KEY  (nid)
 );
 
---
--- TOC Entry ID 66 (OID 47885)
---
--- Name: comments Type: TABLE Owner: root
---
-
-CREATE TABLE "comments" (
-  "cid" integer DEFAULT nextval('"comments_cid_seq"'::text) NOT NULL,
-  "pid" integer NOT NULL,
-  "lid" integer NOT NULL,
-  "uid" integer NOT NULL,
-  "subject" character varying(64) NOT NULL,
-  "comment" text NOT NULL,
-  "hostname" character varying(128) NOT NULL,
-  "timestamp" integer NOT NULL,
-  "link" character varying(16) NOT NULL,
-  Constraint "comments_pkey" Primary Key ("cid")
-);
+CREATE INDEX page_nid_idx ON page(nid);
 
---
--- TOC Entry ID 67 (OID 48008)
---
--- Name: blog Type: TABLE Owner: root
---
 
-CREATE TABLE "blog" (
-  "nid" integer NOT NULL,
-  "body" text NOT NULL
+CREATE TABLE permission (
+  rid integer NOT NULL default '0',
+  perm text,
+  tid integer NOT NULL default '0'
 );
 
---
--- TOC Entry ID 68 (OID 48061)
---
--- Name: story Type: TABLE Owner: root
---
+CREATE INDEX permission_rid_idx ON permission(rid);
 
-CREATE TABLE "story" (
-  "nid" integer NOT NULL,
-  "abstract" text NOT NULL,
-  "body" text NOT NULL
-);
 
---
--- TOC Entry ID 69 (OID 48116)
---
--- Name: page Type: TABLE Owner: root
---
-
-CREATE TABLE "page" (
-  "nid" integer NOT NULL,
-  "link" character varying(128) DEFAULT '' NOT NULL,
-  "body" text NOT NULL,
-  "format" integer NOT NULL
+CREATE TABLE poll (
+  nid integer NOT NULL default '0',
+  runtime integer NOT NULL default '0',
+  voters text NOT NULL,
+  active integer NOT NULL default '0',
+  PRIMARY KEY  (nid)
 );
 
---
--- TOC Entry ID 70 (OID 48171)
---
--- Name: forum Type: TABLE Owner: root
---
-
-CREATE TABLE "forum" (
-  "nid" integer NOT NULL,
-  "body" text NOT NULL
-);
 
---
--- TOC Entry ID 71 (OID 48228)
---
--- Name: book Type: TABLE Owner: root
---
-
-CREATE TABLE "book" (
-  "nid" integer NOT NULL,
-  "body" text NOT NULL,
-  "section" integer,
-  "parent" integer NOT NULL,
-  "weight" integer NOT NULL,
-  "pid" integer NOT NULL,
-  "log" text NOT NULL
+CREATE TABLE poll_choices (
+  chid SERIAL,
+  nid integer NOT NULL default '0',
+  chtext varchar(128) NOT NULL default '',
+  chvotes integer NOT NULL default '0',
+  chorder integer NOT NULL default '0',
+  PRIMARY KEY  (chid)
 );
 
---
--- TOC Entry ID 72 (OID 46231)
---
--- Name: "mask_access_ukey" Type: INDEX Owner: root
---
 
-CREATE UNIQUE INDEX "mask_access_ukey" on "access" using btree ( "mask" "varchar_ops" );
+CREATE TABLE rating (
+  uid integer NOT NULL default '0',
+  current integer NOT NULL default '0',
+  previous integer NOT NULL default '0',
+  PRIMARY KEY  (uid)
+);
 
---
--- TOC Entry ID 73 (OID 46336)
---
--- Name: "title_boxes_ukey" Type: INDEX Owner: root
---
 
-CREATE UNIQUE INDEX "title_boxes_ukey" on "boxes" using btree ( "title" "varchar_ops" );
+CREATE TABLE referrer (
+  url varchar(255) NOT NULL default '',
+  timestamp integer NOT NULL default '0'
+);
 
---
--- TOC Entry ID 74 (OID 46336)
---
--- Name: "info_boxes_ukey" Type: INDEX Owner: root
---
 
-CREATE UNIQUE INDEX "info_boxes_ukey" on "boxes" using btree ( "info" "varchar_ops" );
+CREATE TABLE role (
+  rid SERIAL,
+  name varchar(32) NOT NULL default '',
+  PRIMARY KEY  (rid),
+  UNIQUE (name)
+);
 
---
--- TOC Entry ID 75 (OID 46453)
---
--- Name: "name_category_ukey" Type: INDEX Owner: root
---
 
-CREATE UNIQUE INDEX "name_category_ukey" on "category" using btree ( "name" "varchar_ops" );
+CREATE TABLE search_index (
+ word varchar(50) NOT NULL,
+ lno integer NOT NULL,
+ type varchar(16) default NULL,
+ count integer default NULL
+);
 
---
--- TOC Entry ID 76 (OID 46494)
---
--- Name: "url_channel_ukey" Type: INDEX Owner: root
---
+CREATE INDEX search_index_lno_idx ON search_index(lno);
+CREATE INDEX search_index_word_idx ON search_index(word);
 
-CREATE UNIQUE INDEX "url_channel_ukey" on "channel" using btree ( "url" "varchar_ops" );
 
---
--- TOC Entry ID 77 (OID 46494)
---
--- Name: "file_channel_ukey" Type: INDEX Owner: root
---
+CREATE TABLE site (
+  sid SERIAL,
+  name varchar(128) NOT NULL default '',
+  link varchar(255) NOT NULL default '',
+  size text NOT NULL,
+  timestamp integer NOT NULL default '0',
+  feed varchar(255) NOT NULL default '',
+  refresh integer NOT NULL default '0',
+  threshold integer NOT NULL default '0',
+  PRIMARY KEY  (sid),
+  UNIQUE (name),
+  UNIQUE (link)
+);
 
-CREATE UNIQUE INDEX "file_channel_ukey" on "channel" using btree ( "file" "varchar_ops" );
 
---
--- TOC Entry ID 78 (OID 46494)
---
--- Name: "site_channel_ukey" Type: INDEX Owner: root
---
+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 integer NOT NULL default '0',
+  PRIMARY KEY  (filename)
+);
 
-CREATE UNIQUE INDEX "site_channel_ukey" on "channel" using btree ( "site" "varchar_ops" );
 
---
--- TOC Entry ID 79 (OID 46602)
---
--- Name: "name_collection_ukey" Type: INDEX Owner: root
---
+CREATE TABLE tag (
+  tid SERIAL,
+  name varchar(32) NOT NULL default '',
+  attributes varchar(255) NOT NULL default '',
+  collections varchar(32) NOT NULL default '',
+  PRIMARY KEY (tid),
+  UNIQUE (name,collections)
+);
 
-CREATE UNIQUE INDEX "name_collection_ukey" on "collection" using btree ( "name" "varchar_ops" );
 
---
--- TOC Entry ID 80 (OID 46792)
---
--- Name: "entry_namcoll_ukey" Type: INDEX Owner: root
---
+CREATE TABLE term_data (
+  tid SERIAL,
+  vid integer NOT NULL default '0',
+  name varchar(255) NOT NULL default '',
+  description text,
+  weight smallint NOT NULL default '0',
+  PRIMARY KEY  (tid)
+);
 
-CREATE UNIQUE INDEX "entry_namcoll_ukey" on "entry" using btree ( "name" "varchar_ops", "collection" "varchar_ops" );
+CREATE INDEX term_data_vid_idx ON term_data(vid);
 
---
--- TOC Entry ID 81 (OID 46843)
---
--- Name: "url_feed_ukey" Type: INDEX Owner: root
---
 
-CREATE UNIQUE INDEX "url_feed_ukey" on "feed" using btree ( "url" "varchar_ops" );
+CREATE TABLE term_hierarchy (
+  tid integer NOT NULL default '0',
+  parent integer NOT NULL default '0'
+);
 
---
--- TOC Entry ID 82 (OID 46843)
---
--- Name: "title_feed_ukey" Type: INDEX Owner: root
---
+CREATE INDEX term_hierarchy_tid_idx ON term_hierarchy(tid);
+CREATE INDEX term_hierarchy_parent_idx ON term_hierarchy(parent);
 
-CREATE UNIQUE INDEX "title_feed_ukey" on "feed" using btree ( "title" "varchar_ops" );
 
---
--- TOC Entry ID 83 (OID 47366)
---
--- Name: "link_site_ukey" Type: INDEX Owner: root
---
+CREATE TABLE term_node (
+  nid integer NOT NULL default '0',
+  tid integer NOT NULL default '0'
+);
 
-CREATE UNIQUE INDEX "link_site_ukey" on "site" using btree ( "link" "varchar_ops" );
+CREATE INDEX term_node_nid_idx ON term_node(nid);
+CREATE INDEX term_node_tid_idx ON term_node(tid);
 
---
--- TOC Entry ID 84 (OID 47366)
---
--- Name: "name_site_ukey" Type: INDEX Owner: root
---
 
-CREATE UNIQUE INDEX "name_site_ukey" on "site" using btree ( "name" "varchar_ops" );
+CREATE TABLE term_relation (
+  tid1 integer NOT NULL default '0',
+  tid2 integer NOT NULL default '0'
+);
 
---
--- TOC Entry ID 85 (OID 47473)
---
--- Name: "tag_namecoll_ukey" Type: INDEX Owner: root
---
+CREATE INDEX term_relation_tid1_idx ON term_relation(tid1);
+CREATE INDEX term_relation_tid2_idx ON term_relation(tid2);
 
-CREATE UNIQUE INDEX "tag_namecoll_ukey" on "tag" using btree ( "name" "varchar_ops", "collections" "varchar_ops" );
 
---
--- TOC Entry ID 86 (OID 47512)
---
--- Name: "name_topic_ukey" Type: INDEX Owner: root
---
+CREATE TABLE term_synonym (
+  tid integer NOT NULL default '0',
+  name varchar(255) NOT NULL default ''
+);
 
-CREATE UNIQUE INDEX "name_topic_ukey" on "topic" using btree ( "name" "varchar_ops" );
+CREATE INDEX term_synonym_tid_idx ON term_synonym(tid);
+CREATE INDEX term_synonym_name_idx ON term_synonym(name);
 
---
--- TOC Entry ID 91 (OID 47790)
---
--- Name: "uid_node_key" Type: INDEX Owner: root
---
 
-CREATE  INDEX "uid_node_key" on "node" using btree ( "uid" "int4_ops" );
+CREATE TABLE users (
+  uid SERIAL,
+  name varchar(60) NOT NULL default '',
+  pass varchar(32) NOT NULL default '',
+  mail varchar(64) default '',
+  homepage varchar(128) NOT NULL default '',
+  mode smallint NOT NULL default '0',
+  sort smallint default '0',
+  threshold smallint default '0',
+  theme varchar(255) NOT NULL default '',
+  signature varchar(255) NOT NULL default '',
+  timestamp integer NOT NULL default '0',
+  hostname varchar(128) NOT NULL default '',
+  status smallint NOT NULL default '0',
+  timezone varchar(8) default NULL,
+  rating decimal(8,2) default NULL,
+  language char(2) NOT NULL default '',
+  sid varchar(32) NOT NULL default '',
+  init varchar(64) default '',
+  session varchar(32) NOT NULL default '',
+  data text,
+  rid integer NOT NULL default '0',
+  PRIMARY KEY  (uid),
+  UNIQUE (name)
+);
 
---
--- TOC Entry ID 87 (OID 47871)
---
--- Name: "moderate_cid_key" Type: INDEX Owner: root
---
 
-CREATE  INDEX "moderate_cid_key" on "moderate" using btree ( "cid" "int4_ops" );
+CREATE TABLE variable (
+  name varchar(32) NOT NULL default '',
+  value text NOT NULL,
+  PRIMARY KEY  (name)
+);
 
---
--- TOC Entry ID 88 (OID 47871)
---
--- Name: "moderate_nid_key" Type: INDEX Owner: root
---
 
-CREATE  INDEX "moderate_nid_key" on "moderate" using btree ( "nid" "int4_ops" );
+CREATE TABLE vocabulary (
+  vid SERIAL,
+  name varchar(255) NOT NULL default '',
+  description text,
+  relations smallint NOT NULL default '0',
+  hierarchy smallint NOT NULL default '0',
+  multiple smallint NOT NULL default '0',
+  required smallint NOT NULL default '0',
+  types text,
+  weight smallint NOT NULL default '0',
+  PRIMARY KEY  (vid)
+);
 
---
--- TOC Entry ID 89 (OID 47885)
---
--- Name: "lid_comments_key" Type: INDEX Owner: root
---
 
-CREATE  INDEX "lid_comments_key" on "comments" using btree ( "lid" "int4_ops" );
+CREATE TABLE watchdog (
+  wid SERIAL,
+  uid integer NOT NULL default '0',
+  type varchar(16) NOT NULL default '',
+  message varchar(255) NOT NULL default '',
+  location varchar(128) NOT NULL default '',
+  hostname varchar(128) NOT NULL default '',
+  timestamp integer NOT NULL default '0',
+  PRIMARY KEY  (wid)
+);
 
---
--- TOC Entry ID 90 (OID 47885)
---
--- Name: "uid_comments_key" Type: INDEX Owner: root
---
 
-CREATE  INDEX "uid_comments_key" on "comments" using btree ( "uid" "int4_ops" );
+INSERT INTO variable(name,value) VALUES('update_start', '2002-05-15');
+INSERT INTO system VALUES ('archive.module','archive','module','',1);
+INSERT INTO system VALUES ('block.module','block','module','',1);
+INSERT INTO system VALUES ('blog.module','blog','module','',1);
+INSERT INTO system VALUES ('book.module','book','module','',1);
+INSERT INTO system VALUES ('cloud.module','cloud','module','',1);
+INSERT INTO system VALUES ('comment.module','comment','module','',1);
+INSERT INTO system VALUES ('forum.module','forum','module','',1);
+INSERT INTO system VALUES ('help.module','help','module','',1);
+INSERT INTO system VALUES ('import.module','import','module','',1);
+INSERT INTO system VALUES ('node.module','node','module','',1);
+INSERT INTO system VALUES ('page.module','page','module','',1);
+INSERT INTO system VALUES ('poll.module','poll','module','',1);
+INSERT INTO system VALUES ('queue.module','queue','module','',1);
+INSERT INTO system VALUES ('rating.module','rating','module','',1);
+INSERT INTO system VALUES ('search.module','search','module','',1);
+INSERT INTO system VALUES ('statistics.module','statistics','module','',1);
+INSERT INTO system VALUES ('story.module','story','module','',1);
+INSERT INTO system VALUES ('taxonomy.module','taxonomy','module','',1);
+INSERT INTO system VALUES ('themes/example/example.theme','example','theme','Internet explorer, Netscape, Opera, Lynx',1);
+INSERT INTO system VALUES ('themes/goofy/goofy.theme','goofy','theme','Internetexplorer, Netscape, Opera',1);
+INSERT INTO system VALUES ('themes/marvin/marvin.theme','marvin','theme','Internet explorer, Netscape, Opera',1);
+INSERT INTO system VALUES ('themes/unconed/unconed.theme','unconed','theme','Internet explorer, Netscape, Opera',1);
+INSERT INTO system VALUES ('tracker.module','tracker','module','',1);
+
+DELETE FROM variable WHERE name='theme_default';
+INSERT INTO variable(value,name) VALUES('marvin', 'theme_default');
+
+DELETE FROM blocks WHERE name='User information';
+INSERT INTO blocks(name,module,delta,status) VALUES('User information', 'user', '0', '1');
+
+DELETE FROM blocks WHERE name='Log in';
+INSERT INTO blocks(name,module,delta,status) VALUES('Log in', 'user', '1', '1');