CREATE TABLE "Attachments"
(
  "key" uuid NOT NULL,
  topic_key uuid NOT NULL,
  user_key uuid NOT NULL,
  upload_time timestamp without time zone NOT NULL,
  revision serial NOT NULL,
  filename character(48) NOT NULL,
  file text,
  CONSTRAINT attachments_key PRIMARY KEY (key)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Attachments" OWNER TO foswikiroot;

CREATE TABLE "Dataform_Data"
(
  "key" uuid NOT NULL,
  topic_key uuid NOT NULL,
  dataform_definition_key uuid NOT NULL,
  CONSTRAINT dataform_data_key PRIMARY KEY (key)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Dataform_Data" OWNER TO foswikiroot;

CREATE TABLE "Dataform_Definition"
(
  "key" uuid NOT NULL,
  topic_key uuid NOT NULL,
  "Name" text NOT NULL,
  "Type" text NOT NULL,
  "Size" text NOT NULL,
  "Values" text,
  "Tooltip_message" text,
  "Attributes" text,
  CONSTRAINT dataform_definition_key PRIMARY KEY (key)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Dataform_Definition" OWNER TO foswikiroot;

CREATE TABLE "Edit_History"
(
  "key" uuid NOT NULL,
  topic_key uuid NOT NULL,
  diff_topic_name text,
  diff_topic_content text,
  diff_dataform_data text,
  diff_authorization_topic_view text,
  diff_authorization_topic_edit text,
  diff_authorization_topic_change text,
  user_key uuid,
  revision serial NOT NULL,
  CONSTRAINT edit_history_key PRIMARY KEY (key)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Edit_History" OWNER TO foswikiroot;


CREATE TABLE "Group_Users_Membership"
(
  "key" uuid NOT NULL,
  user_key uuid NOT NULL,
  group_key uuid NOT NULL,
  CONSTRAINT groups_users_membership_key PRIMARY KEY (key),
  CONSTRAINT membership_group_relation FOREIGN KEY (group_key)
      REFERENCES "Groups" ("key") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT membership_user_relation FOREIGN KEY (user_key)
      REFERENCES "Users" ("key") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Group_Users_Membership" OWNER TO foswikiroot;


CREATE TABLE "Groups"
(
  "key" uuid NOT NULL,
  "Name" text NOT NULL,
  site_key uuid NOT NULL,
  CONSTRAINT groups_key PRIMARY KEY (key),
  CONSTRAINT group_site_relation FOREIGN KEY (site_key)
      REFERENCES "Sites" ("key") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Groups" OWNER TO foswikiroot;


CREATE TABLE "Sites"
(
  "key" uuid NOT NULL,
  site_name text NOT NULL,
  sitepreferences_topic_key uuid,
  sitehome_topic_key uuid,
  CONSTRAINT site_key PRIMARY KEY (key)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Sites" OWNER TO foswikiroot;


CREATE TABLE "Topics"
(
  "key" uuid NOT NULL,
  topic_name text NOT NULL,
  topic_content text,
  dataform_data text,
  web_key uuid NOT NULL,
  parent_topic_key uuid,
  authorization_topic_view_allow text,
  authorization_topic_change_allow text,
  authorization_topic_rename_allow text,
  authorization_topic_view_deny text,
  authorization_topic_change_deny text,
  authorization_topic_rename_deny text,
  CONSTRAINT topic_key PRIMARY KEY (key),
  CONSTRAINT topic_web_relation FOREIGN KEY (web_key)
      REFERENCES "Webs" ("key") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Topics" OWNER TO foswikiroot;


CREATE TABLE "Users"
(
  "key" uuid NOT NULL,
  "First_Name" text NOT NULL,
  "Last_Name" text NOT NULL,
  "Login_Name" character(48) NOT NULL,
  site_key uuid NOT NULL,
  "password" character(64),
  CONSTRAINT users_key PRIMARY KEY (key),
  CONSTRAINT site_user_relation FOREIGN KEY (site_key)
      REFERENCES "Sites" ("key") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Users" OWNER TO foswikiroot;


CREATE TABLE "Webs"
(
  "key" uuid NOT NULL,
  webpreferences_topic_key uuid,
  webhome_topic_key uuid,
  web_name text NOT NULL,
  site_key uuid NOT NULL,
  authorization_web_view_allow text,
  authorization_web_change_allow text,
  authorization_web_rename_allow text,
  authorization_web_view_deny text,
  authorization_web_change_deny text,
  authorization_web_rename_deny text,
  CONSTRAINT web_key PRIMARY KEY (key),
  CONSTRAINT site_web_relation FOREIGN KEY (site_key)
      REFERENCES "Sites" ("key") MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "Webs" OWNER TO foswikiroot;