--- a/dbicdh/SQLite/deploy/1/001-auto.sql Sun Sep 27 22:45:40 2015 +0200
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,83 +0,0 @@
---
--- 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;