dbicdh/SQLite/deploy/1/001-auto.sql
changeset 78 0ebef32c34af
parent 77 e408da1419cd
child 79 4ae8bb6f8a96
--- 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;