/*
Created: 03.12.2007
Modified: 03.12.2007
Model: PostgreSQL 8.1
Database: PostgreSQL 8.1
*/

DROP TABLE "cat_relation";
DROP TABLE "category";

-- Create tables section -------------------------------------------------

-- Table category

CREATE TABLE "category"(
 "cat_id" Bigint NOT NULL,
 "cat_revision" Bigint NOT NULL,
 "cat_name" Character varying(64)
)
;

-- Add keys for table category

ALTER TABLE "category" ADD CONSTRAINT "PK1" PRIMARY KEY ("cat_id","cat_revision");

-- Table cat_relation

CREATE TABLE "cat_relation"(
 "cat_id" Bigint NOT NULL,
 "parent_id" Bigint NOT NULL,
 "cat_revision" Bigint NOT NULL,
 "parent_revision" Bigint NOT NULL
)
;

-- Add keys for table cat_relation

ALTER TABLE "cat_relation" ADD CONSTRAINT "Key2" PRIMARY KEY ("cat_id","parent_id","cat_revision","parent_revision");

-- Create relationships section ------------------------------------------------- 

ALTER TABLE "cat_relation" ADD CONSTRAINT "Relationship1" FOREIGN KEY ("cat_id", "cat_revision") REFERENCES "category" ("cat_id", "cat_revision");

ALTER TABLE "cat_relation" ADD CONSTRAINT "Relationship2" FOREIGN KEY ("parent_id", "parent_revision") REFERENCES "category" ("cat_id", "cat_revision");