# HG changeset patch # User Vincent Tondellier # Date 1423431364 -3600 # Node ID 4f4f8a52a8744046300253a6c7bd49e05faa8256 # Parent a3e856c4d1611a4a913b4d7b778a323630f13087 Add database v1 schema files diff -r a3e856c4d161 -r 4f4f8a52a874 dbicdh/PostgreSQL/deploy/1/001-auto-__VERSION.sql --- /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") +); + +; diff -r a3e856c4d161 -r 4f4f8a52a874 dbicdh/PostgreSQL/deploy/1/001-auto.sql --- /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; + +; diff -r a3e856c4d161 -r 4f4f8a52a874 dbicdh/SQLite/deploy/1/001-auto-__VERSION.sql --- /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; diff -r a3e856c4d161 -r 4f4f8a52a874 dbicdh/SQLite/deploy/1/001-auto.sql --- /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; diff -r a3e856c4d161 -r 4f4f8a52a874 dbicdh/_source/deploy/1/001-auto-__VERSION.yml --- /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 diff -r a3e856c4d161 -r 4f4f8a52a874 dbicdh/_source/deploy/1/001-auto.yml --- /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