-- 

-- 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;