-- 
-- Created by SQL::Translator::Producer::PostgreSQL
-- Created on Sun Feb  1 19:58:35 2015
-- 
;
--
-- Table: crash_users.
--
CREATE TABLE "crash_users" (
  "id" serial NOT NULL,
  "user_id" character varying(40) NOT NULL,
  "os" character varying(40),
  "cpu_arch" character varying(10),
  "cpu_count" integer,
  "extra_info" text,
  PRIMARY KEY ("id")
);

;
--
-- Table: modules.
--
CREATE TABLE "modules" (
  "id" serial NOT NULL,
  "debug_id" character varying(33) NOT NULL,
  "filename" character varying(128) NOT NULL,
  "version" character varying(64),
  PRIMARY KEY ("id"),
  CONSTRAINT "module_id" UNIQUE ("debug_id", "filename")
);

;
--
-- Table: products.
--
CREATE TABLE "products" (
  "id" serial NOT NULL,
  "distributor" character varying(40),
  "name" character varying(40),
  "version" character varying(16),
  "release_channel" character varying,
  PRIMARY KEY ("id")
);

;
--
-- Table: crash_reports.
--
CREATE TABLE "crash_reports" (
  "id" serial NOT NULL,
  "start_time" timestamp,
  "crash_time" timestamp,
  "uuid" character varying(36) NOT NULL,
  "bug_reference" character varying(20),
  "crash_user_id" integer NOT NULL,
  "product_id" integer NOT NULL,
  PRIMARY KEY ("id")
);
CREATE INDEX "crash_reports_idx_crash_user_id" on "crash_reports" ("crash_user_id");
CREATE INDEX "crash_reports_idx_product_id" on "crash_reports" ("product_id");

;
--
-- Table: crash_threads.
--
CREATE TABLE "crash_threads" (
  "id" serial NOT NULL,
  "number" integer NOT NULL,
  "crashed" bool NOT NULL,
  "crash_report_id" integer NOT NULL,
  PRIMARY KEY ("id")
);
CREATE INDEX "crash_threads_idx_crash_report_id" on "crash_threads" ("crash_report_id");

;
--
-- Table: crash_frames.
--
CREATE TABLE "crash_frames" (
  "id" serial NOT NULL,
  "number" integer NOT NULL,
  "function" character varying(128),
  "source_file" character varying(128),
  "source_line" integer,
  "stack_walk_mode" character varying(10),
  "crash_thread_id" integer NOT NULL,
  "module_id" integer NOT NULL,
  PRIMARY KEY ("id")
);
CREATE INDEX "crash_frames_idx_crash_thread_id" on "crash_frames" ("crash_thread_id");
CREATE INDEX "crash_frames_idx_module_id" on "crash_frames" ("module_id");

;
--
-- Foreign Key Definitions
--

;
ALTER TABLE "crash_reports" ADD CONSTRAINT "crash_reports_fk_crash_user_id" FOREIGN KEY ("crash_user_id")
  REFERENCES "crash_users" ("id") DEFERRABLE;

;
ALTER TABLE "crash_reports" ADD CONSTRAINT "crash_reports_fk_product_id" FOREIGN KEY ("product_id")
  REFERENCES "products" ("id") DEFERRABLE;

;
ALTER TABLE "crash_threads" ADD CONSTRAINT "crash_threads_fk_crash_report_id" FOREIGN KEY ("crash_report_id")
  REFERENCES "crash_reports" ("id") DEFERRABLE;

;
ALTER TABLE "crash_frames" ADD CONSTRAINT "crash_frames_fk_crash_thread_id" FOREIGN KEY ("crash_thread_id")
  REFERENCES "crash_threads" ("id") DEFERRABLE;

;
ALTER TABLE "crash_frames" ADD CONSTRAINT "crash_frames_fk_module_id" FOREIGN KEY ("module_id")
  REFERENCES "modules" ("id") DEFERRABLE;

;