CREATE TABLE category
(
  cid serial,
  cnid int8 NOT NULL DEFAULT 0,
  description varchar(255) NOT NULL DEFAULT '',
  weight int2 NOT NULL DEFAULT 0,
  depth int2 NOT NULL DEFAULT 0,
  CONSTRAINT category_pkey PRIMARY KEY (cid)
);

CREATE INDEX ca_tid ON category (cnid);
CREATE INDEX ca_weight ON category (weight);

CREATE TABLE category_cont
(
  cid int8 NOT NULL DEFAULT 0,
  help varchar(255) NOT NULL DEFAULT '',
  module varchar(255) NOT NULL DEFAULT '',
  has_relations int2 NOT NULL DEFAULT 0,
  has_synonyms int2 NOT NULL DEFAULT 0,
  hierarchy int2 NOT NULL DEFAULT 0,
  multiple int2 NOT NULL DEFAULT 0,
  required int2 NOT NULL DEFAULT 0,
  tags int2 NOT NULL DEFAULT 0,
  hidden_cont int2 NOT NULL DEFAULT 0,
  CONSTRAINT category_cont_pkey PRIMARY KEY (cid)
);

CREATE TABLE category_cont_distant (
  cid int8 NOT NULL default 0,
  allowed_parent varchar(255) NOT NULL default '',
  CONSTRAINT category_cont_distant_pkey PRIMARY KEY (cid, allowed_parent)
);

CREATE INDEX cc_nid ON category_cont_distant (cid);
CREATE INDEX cc_parent ON category_cont_distant (allowed_parent);

CREATE TABLE category_cont_node_types
(
  cid int8 NOT NULL DEFAULT 0,
  "type" varchar(32) NOT NULL DEFAULT '',
  CONSTRAINT category_cont_node_types_pkey PRIMARY KEY (cid, "type")
);

CREATE TABLE category_display (
  cid int8 NOT NULL default '0',
  toc_for_cats int2 NOT NULL default '0',
  toc_depth int2 NOT NULL default '0',
  navlinks int2 NOT NULL default '0',
  navlinks_before int2 NOT NULL default '0',
  navlinks_after int2 NOT NULL default '0',
  nodelinks int2 NOT NULL default '0',
  emptymsg int2 NOT NULL default '0',
  show_listing int2 NOT NULL default '0',
  CONSTRAINT category_display_pkey PRIMARY KEY (cid)
);

CREATE TABLE category_export (
  cid int8 NOT NULL default '0',
  export_type varchar(255) NOT NULL default '',
  CONSTRAINT category_export_pkey PRIMARY KEY (cid,export_type)
);

CREATE TABLE category_hierarchy
(
  cid int8 NOT NULL DEFAULT 0,
  parent int8 NOT NULL DEFAULT 0
);

CREATE INDEX ch_nid ON category_hierarchy (cid);
CREATE INDEX ch_parent ON category_hierarchy (parent);

CREATE TABLE category_legacy (
  tbcid int8 NOT NULL default '0',
  id_type varchar(255) NOT NULL default '',
  "data" text,
  CONSTRAINT category_legacy_pkey PRIMARY KEY (tbcid,id_type)
);

CREATE TABLE category_legacy_map (
  tbcid int8 NOT NULL default '0',
  id_type varchar(255) NOT NULL default '',
  redirect_id int8 NOT NULL default '0',
  redirect_type varchar(255) NOT NULL default '',
  CONSTRAINT category_legacy_map_pkey PRIMARY KEY (tbcid, id_type)
);

CREATE TABLE category_menu (
  cid int8 NOT NULL default '0',
  item_for_cats int2 NOT NULL default '0',
  item_for_nodes int2 NOT NULL default '0',
  CONSTRAINT category_menu_pkey PRIMARY KEY (cid)
);

CREATE TABLE category_menu_map (
  nid int8 NOT NULL default '0',
  mid int8 NOT NULL default '0',
  PRIMARY KEY (nid)
);

CREATE INDEX cmm_mid on category_menu_map (mid);

CREATE TABLE category_node (
  nid int8 NOT NULL default '0',
  cid int8 NOT NULL default '0',
  CONSTRAINT category_node_pkey PRIMARY KEY  (cid, nid)
);

CREATE INDEX cn_nid ON category_node (nid);
CREATE INDEX cn_cid ON category_node (cid);

CREATE TABLE category_relation (
  cid1 int8 NOT NULL default '0',
  cid2 int8 NOT NULL default '0',
);

CREATE INDEX cr_nid1 ON category_relation (cid1);
CREATE INDEX cr_nid2 ON category_relation (cid2);

CREATE TABLE category_synonym (
  cid int8 NOT NULL default '0',
  "name" varchar(255) NOT NULL default ''
);

CREATE INDEX cs_nid ON category_synonym (cid);
CREATE INDEX cs_name ON category_synonym ("name");

CREATE TABLE category_views (
  cid int8 NOT NULL default '0',
  view_id int4 NOT NULL default '0',
  display_cont int2 NOT NULL default '0',
  display_cat int2 NOT NULL default '0',
  CONSTRAINT category_views_pkey PRIMARY KEY (cid)
);