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