dbicdh/_source/deploy/1/001-auto.yml
changeset 78 0ebef32c34af
parent 77 e408da1419cd
child 79 4ae8bb6f8a96
--- a/dbicdh/_source/deploy/1/001-auto.yml	Sun Sep 27 22:45:40 2015 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,587 +0,0 @@
----
-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