--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/dbicdh/PostgreSQL/deploy/1/001-auto-__VERSION.sql Sun Feb 08 22:36:04 2015 +0100
@@ -0,0 +1,18 @@
+--
+-- Created by SQL::Translator::Producer::PostgreSQL
+-- Created on Sun Feb 1 19:58:35 2015
+--
+;
+--
+-- Table: dbix_class_deploymenthandler_versions.
+--
+CREATE TABLE "dbix_class_deploymenthandler_versions" (
+ "id" serial NOT NULL,
+ "version" character varying(50) NOT NULL,
+ "ddl" text,
+ "upgrade_sql" text,
+ PRIMARY KEY ("id"),
+ CONSTRAINT "dbix_class_deploymenthandler_versions_version" UNIQUE ("version")
+);
+
+;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/dbicdh/PostgreSQL/deploy/1/001-auto.sql Sun Feb 08 22:36:04 2015 +0100
@@ -0,0 +1,118 @@
+--
+-- 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;
+
+;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/dbicdh/SQLite/deploy/1/001-auto-__VERSION.sql Sun Feb 08 22:36:04 2015 +0100
@@ -0,0 +1,18 @@
+--
+-- Created by SQL::Translator::Producer::SQLite
+-- Created on Sun Feb 1 19:58:35 2015
+--
+
+;
+BEGIN TRANSACTION;
+--
+-- Table: dbix_class_deploymenthandler_versions
+--
+CREATE TABLE dbix_class_deploymenthandler_versions (
+ id INTEGER PRIMARY KEY NOT NULL,
+ version varchar(50) NOT NULL,
+ ddl text,
+ upgrade_sql text
+);
+CREATE UNIQUE INDEX dbix_class_deploymenthandler_versions_version ON dbix_class_deploymenthandler_versions (version);
+COMMIT;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/dbicdh/SQLite/deploy/1/001-auto.sql Sun Feb 08 22:36:04 2015 +0100
@@ -0,0 +1,83 @@
+--
+-- 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;
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/dbicdh/_source/deploy/1/001-auto-__VERSION.yml Sun Feb 08 22:36:04 2015 +0100
@@ -0,0 +1,91 @@
+---
+schema:
+ procedures: {}
+ tables:
+ dbix_class_deploymenthandler_versions:
+ constraints:
+ - deferrable: 1
+ expression: ''
+ fields:
+ - id
+ match_type: ''
+ name: ''
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: PRIMARY KEY
+ - deferrable: 1
+ expression: ''
+ fields:
+ - version
+ match_type: ''
+ name: dbix_class_deploymenthandler_versions_version
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: UNIQUE
+ fields:
+ ddl:
+ data_type: text
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: ddl
+ order: 3
+ size:
+ - 0
+ id:
+ data_type: int
+ default_value: ~
+ is_auto_increment: 1
+ is_nullable: 0
+ is_primary_key: 1
+ is_unique: 0
+ name: id
+ order: 1
+ size:
+ - 0
+ upgrade_sql:
+ data_type: text
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: upgrade_sql
+ order: 4
+ size:
+ - 0
+ version:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 1
+ name: version
+ order: 2
+ size:
+ - 50
+ indices: []
+ name: dbix_class_deploymenthandler_versions
+ options: []
+ order: 1
+ triggers: {}
+ views: {}
+translator:
+ add_drop_table: 0
+ filename: ~
+ no_comments: 0
+ parser_args:
+ sources:
+ - __VERSION
+ parser_type: SQL::Translator::Parser::DBIx::Class
+ producer_args: {}
+ producer_type: SQL::Translator::Producer::YAML
+ show_warnings: 0
+ trace: 0
+ version: 0.11020
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/dbicdh/_source/deploy/1/001-auto.yml Sun Feb 08 22:36:04 2015 +0100
@@ -0,0 +1,587 @@
+---
+schema:
+ procedures: {}
+ tables:
+ crash_frames:
+ constraints:
+ - deferrable: 1
+ expression: ''
+ fields:
+ - id
+ match_type: ''
+ name: ''
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: PRIMARY KEY
+ - deferrable: 1
+ expression: ''
+ fields:
+ - crash_thread_id
+ match_type: ''
+ name: crash_frames_fk_crash_thread_id
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields:
+ - id
+ reference_table: crash_threads
+ type: FOREIGN KEY
+ - deferrable: 1
+ expression: ''
+ fields:
+ - module_id
+ match_type: ''
+ name: crash_frames_fk_module_id
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields:
+ - id
+ reference_table: modules
+ type: FOREIGN KEY
+ fields:
+ crash_thread_id:
+ data_type: int
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: crash_thread_id
+ order: 7
+ size:
+ - 0
+ function:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: function
+ order: 3
+ size:
+ - 128
+ id:
+ data_type: int
+ default_value: ~
+ is_auto_increment: 1
+ is_nullable: 0
+ is_primary_key: 1
+ is_unique: 0
+ name: id
+ order: 1
+ size:
+ - 0
+ module_id:
+ data_type: int
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: module_id
+ order: 8
+ size:
+ - 0
+ number:
+ data_type: int
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: number
+ order: 2
+ size:
+ - 0
+ source_file:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: source_file
+ order: 4
+ size:
+ - 128
+ source_line:
+ data_type: int
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: source_line
+ order: 5
+ size:
+ - 0
+ stack_walk_mode:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: stack_walk_mode
+ order: 6
+ size:
+ - 10
+ indices:
+ - fields:
+ - crash_thread_id
+ name: crash_frames_idx_crash_thread_id
+ options: []
+ type: NORMAL
+ - fields:
+ - module_id
+ name: crash_frames_idx_module_id
+ options: []
+ type: NORMAL
+ name: crash_frames
+ options: []
+ order: 6
+ crash_reports:
+ constraints:
+ - deferrable: 1
+ expression: ''
+ fields:
+ - id
+ match_type: ''
+ name: ''
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: PRIMARY KEY
+ - deferrable: 1
+ expression: ''
+ fields:
+ - crash_user_id
+ match_type: ''
+ name: crash_reports_fk_crash_user_id
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields:
+ - id
+ reference_table: crash_users
+ type: FOREIGN KEY
+ - deferrable: 1
+ expression: ''
+ fields:
+ - product_id
+ match_type: ''
+ name: crash_reports_fk_product_id
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields:
+ - id
+ reference_table: products
+ type: FOREIGN KEY
+ fields:
+ bug_reference:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: bug_reference
+ order: 5
+ size:
+ - 20
+ crash_time:
+ data_type: timestamp
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: crash_time
+ order: 3
+ size:
+ - 0
+ crash_user_id:
+ data_type: int
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: crash_user_id
+ order: 6
+ size:
+ - 0
+ id:
+ data_type: int
+ default_value: ~
+ is_auto_increment: 1
+ is_nullable: 0
+ is_primary_key: 1
+ is_unique: 0
+ name: id
+ order: 1
+ size:
+ - 0
+ product_id:
+ data_type: int
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: product_id
+ order: 7
+ size:
+ - 0
+ start_time:
+ data_type: timestamp
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: start_time
+ order: 2
+ size:
+ - 0
+ uuid:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: uuid
+ order: 4
+ size:
+ - 36
+ indices:
+ - fields:
+ - crash_user_id
+ name: crash_reports_idx_crash_user_id
+ options: []
+ type: NORMAL
+ - fields:
+ - product_id
+ name: crash_reports_idx_product_id
+ options: []
+ type: NORMAL
+ name: crash_reports
+ options: []
+ order: 4
+ crash_threads:
+ constraints:
+ - deferrable: 1
+ expression: ''
+ fields:
+ - id
+ match_type: ''
+ name: ''
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: PRIMARY KEY
+ - deferrable: 1
+ expression: ''
+ fields:
+ - crash_report_id
+ match_type: ''
+ name: crash_threads_fk_crash_report_id
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields:
+ - id
+ reference_table: crash_reports
+ type: FOREIGN KEY
+ fields:
+ crash_report_id:
+ data_type: int
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: crash_report_id
+ order: 4
+ size:
+ - 0
+ crashed:
+ data_type: bool
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: crashed
+ order: 3
+ size:
+ - 0
+ id:
+ data_type: int
+ default_value: ~
+ is_auto_increment: 1
+ is_nullable: 0
+ is_primary_key: 1
+ is_unique: 0
+ name: id
+ order: 1
+ size:
+ - 0
+ number:
+ data_type: int
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: number
+ order: 2
+ size:
+ - 0
+ indices:
+ - fields:
+ - crash_report_id
+ name: crash_threads_idx_crash_report_id
+ options: []
+ type: NORMAL
+ name: crash_threads
+ options: []
+ order: 5
+ crash_users:
+ constraints:
+ - deferrable: 1
+ expression: ''
+ fields:
+ - id
+ match_type: ''
+ name: ''
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: PRIMARY KEY
+ fields:
+ cpu_arch:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: cpu_arch
+ order: 4
+ size:
+ - 10
+ cpu_count:
+ data_type: int
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: cpu_count
+ order: 5
+ size:
+ - 0
+ extra_info:
+ data_type: text
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: extra_info
+ order: 6
+ size:
+ - 0
+ id:
+ data_type: int
+ default_value: ~
+ is_auto_increment: 1
+ is_nullable: 0
+ is_primary_key: 1
+ is_unique: 0
+ name: id
+ order: 1
+ size:
+ - 0
+ os:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: os
+ order: 3
+ size:
+ - 40
+ user_id:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 0
+ name: user_id
+ order: 2
+ size:
+ - 40
+ indices: []
+ name: crash_users
+ options: []
+ order: 1
+ modules:
+ constraints:
+ - deferrable: 1
+ expression: ''
+ fields:
+ - id
+ match_type: ''
+ name: ''
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: PRIMARY KEY
+ - deferrable: 1
+ expression: ''
+ fields:
+ - debug_id
+ - filename
+ match_type: ''
+ name: module_id
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: UNIQUE
+ fields:
+ debug_id:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 1
+ name: debug_id
+ order: 2
+ size:
+ - 33
+ filename:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 0
+ is_primary_key: 0
+ is_unique: 1
+ name: filename
+ order: 3
+ size:
+ - 128
+ id:
+ data_type: int
+ default_value: ~
+ is_auto_increment: 1
+ is_nullable: 0
+ is_primary_key: 1
+ is_unique: 0
+ name: id
+ order: 1
+ size:
+ - 0
+ version:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: version
+ order: 4
+ size:
+ - 64
+ indices: []
+ name: modules
+ options: []
+ order: 2
+ products:
+ constraints:
+ - deferrable: 1
+ expression: ''
+ fields:
+ - id
+ match_type: ''
+ name: ''
+ on_delete: ''
+ on_update: ''
+ options: []
+ reference_fields: []
+ reference_table: ''
+ type: PRIMARY KEY
+ fields:
+ distributor:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: distributor
+ order: 2
+ size:
+ - 40
+ id:
+ data_type: int
+ default_value: ~
+ is_auto_increment: 1
+ is_nullable: 0
+ is_primary_key: 1
+ is_unique: 0
+ name: id
+ order: 1
+ size:
+ - 0
+ name:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: name
+ order: 3
+ size:
+ - 40
+ release_channel:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: release_channel
+ order: 5
+ size:
+ - 0
+ version:
+ data_type: varchar
+ default_value: ~
+ is_nullable: 1
+ is_primary_key: 0
+ is_unique: 0
+ name: version
+ order: 4
+ size:
+ - 16
+ indices: []
+ name: products
+ options: []
+ order: 3
+ triggers: {}
+ views: {}
+translator:
+ add_drop_table: 0
+ filename: ~
+ no_comments: 0
+ parser_args:
+ sources:
+ - CrashFrame
+ - CrashReport
+ - CrashThread
+ - CrashUser
+ - Module
+ - Product
+ parser_type: SQL::Translator::Parser::DBIx::Class
+ producer_args: {}
+ producer_type: SQL::Translator::Producer::YAML
+ show_warnings: 0
+ trace: 0
+ version: 0.11020