-- 
-- Created by SQL::Translator::Producer::SQLite
-- Created on Sun Feb  1 19:58:35 2015
-- 

;
BEGIN TRANSACTION;
--
-- Table: crash_users
--
CREATE TABLE crash_users (
  id INTEGER PRIMARY KEY NOT NULL,
  user_id varchar(40) NOT NULL,
  os varchar(40),
  cpu_arch varchar(10),
  cpu_count int,
  extra_info text
);
--
-- Table: modules
--
CREATE TABLE modules (
  id INTEGER PRIMARY KEY NOT NULL,
  debug_id varchar(33) NOT NULL,
  filename varchar(128) NOT NULL,
  version varchar(64)
);
CREATE UNIQUE INDEX module_id ON modules (debug_id, filename);
--
-- Table: products
--
CREATE TABLE products (
  id INTEGER PRIMARY KEY NOT NULL,
  distributor varchar(40),
  name varchar(40),
  version varchar(16),
  release_channel varchar
);
--
-- Table: crash_reports
--
CREATE TABLE crash_reports (
  id INTEGER PRIMARY KEY NOT NULL,
  start_time timestamp,
  crash_time timestamp,
  uuid varchar(36) NOT NULL,
  bug_reference varchar(20),
  crash_user_id int NOT NULL,
  product_id int NOT NULL,
  FOREIGN KEY (crash_user_id) REFERENCES crash_users(id),
  FOREIGN KEY (product_id) REFERENCES products(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 INTEGER PRIMARY KEY NOT NULL,
  number int NOT NULL,
  crashed bool NOT NULL,
  crash_report_id int NOT NULL,
  FOREIGN KEY (crash_report_id) REFERENCES crash_reports(id)
);
CREATE INDEX crash_threads_idx_crash_report_id ON crash_threads (crash_report_id);
--
-- Table: crash_frames
--
CREATE TABLE crash_frames (
  id INTEGER PRIMARY KEY NOT NULL,
  number int NOT NULL,
  function varchar(128),
  source_file varchar(128),
  source_line int,
  stack_walk_mode varchar(10),
  crash_thread_id int NOT NULL,
  module_id int NOT NULL,
  FOREIGN KEY (crash_thread_id) REFERENCES crash_threads(id),
  FOREIGN KEY (module_id) REFERENCES modules(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);
COMMIT;