path: root/sql/_source/deploy/2/001-auto.yml

---
schema:
  procedures: {}
  tables:
    commit_push:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - sha256
          match_type: ''
          name: ''
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: PRIMARY KEY
        - deferrable: 1
          expression: ''
          fields:
            - projectid
          match_type: ''
          name: commit_push_fk_projectid
          on_delete: ''
          on_update: ''
          options: []
          reference_fields:
            - projectid
          reference_table: project
          type: FOREIGN KEY
      fields:
        content:
          data_type: text
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: content
          order: 2
          size:
            - 0
        projectid:
          data_type: int
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: projectid
          order: 3
          size:
            - 0
        sha256:
          data_type: text
          default_value: ~
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: sha256
          order: 1
          size:
            - 0
        timestamp:
          data_type: datetime
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: timestamp
          order: 4
          size:
            - 0
      indices:
        - fields:
            - projectid
          name: commit_push_idx_projectid
          options: []
          type: NORMAL
      name: commit_push
      options: []
      order: 2
    project:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - projectid
          match_type: ''
          name: ''
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: PRIMARY KEY
        - deferrable: 1
          expression: ''
          fields:
            - name
          match_type: ''
          name: project_name
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: UNIQUE
      fields:
        description:
          data_type: text
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: description
          order: 4
          size:
            - 0
        name:
          data_type: text
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 1
          name: name
          order: 2
          size:
            - 0
        owner:
          data_type: text
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: owner
          order: 5
          size:
            - 0
        projectid:
          data_type: int
          default_value: ~
          is_auto_increment: 1
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: projectid
          order: 1
          size:
            - 0
        url:
          data_type: text
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: url
          order: 3
          size:
            - 0
      indices: []
      name: project
      options: []
      order: 1
    task:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - taskid
          match_type: ''
          name: ''
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: PRIMARY KEY
        - deferrable: 1
          expression: ''
          fields:
            - projectid
          match_type: ''
          name: task_projectid
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: UNIQUE
        - deferrable: 1
          expression: ''
          fields:
            - sha256
          match_type: ''
          name: task_sha256
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: UNIQUE
        - deferrable: 1
          expression: ''
          fields:
            - sha256
          match_type: ''
          name: task_fk_sha256
          on_delete: ''
          on_update: ''
          options: []
          reference_fields:
            - sha256
          reference_table: commit_push
          type: FOREIGN KEY
        - deferrable: 1
          expression: ''
          fields:
            - projectid
          match_type: ''
          name: task_fk_projectid
          on_delete: ''
          on_update: ''
          options: []
          reference_fields:
            - projectid
          reference_table: project
          type: FOREIGN KEY
      fields:
        projectid:
          data_type: int
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 1
          name: projectid
          order: 3
          size:
            - 0
        running:
          data_type: bool
          default_value: 0
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: running
          order: 4
          size:
            - 0
        sha256:
          data_type: text
          default_value: ~
          is_nullable: 0
          is_primary_key: 0
          is_unique: 1
          name: sha256
          order: 2
          size:
            - 0
        taskid:
          data_type: int
          default_value: ~
          is_auto_increment: 1
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: taskid
          order: 1
          size:
            - 0
      indices:
        - fields:
            - sha256
          name: task_idx_sha256
          options: []
          type: NORMAL
        - fields:
            - projectid
          name: task_idx_projectid
          options: []
          type: NORMAL
      name: task
      options: []
      order: 3
  triggers: {}
  views: {}
translator:
  add_drop_table: 0
  filename: ~
  no_comments: 0
  parser_args:
    package: &1 !!perl/hash:jitterbug::Schema
      class_mappings:
        DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResult: __VERSION
        jitterbug::Schema::Result::Commit: Commit
        jitterbug::Schema::Result::Project: Project
        jitterbug::Schema::Result::Task: Task
      source_registrations:
        Commit: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            content:
              data_type: text
              extra: {}
            projectid:
              data_type: int
              extra: {}
              is_foreign_key: 1
            sha256:
              data_type: text
              extra: {}
              is_auto_increment: 0
            timestamp:
              _inflate_info:
                deflate: !!perl/code '{ "DUMMY" }'
                inflate: !!perl/code '{ "DUMMY" }'
              data_type: datetime
              extra: {}
          _columns_info_loaded: 0
          _ordered_columns:
            - sha256
            - content
            - projectid
            - timestamp
          _primaries: &2
            - sha256
          _relationships:
            project:
              attrs:
                accessor: single
                is_foreign_key_constraint: 1
                undef_on_null_fk: 1
              class: jitterbug::Schema::Result::Project
              cond:
                foreign.projectid: self.projectid
              source: jitterbug::Schema::Result::Project
            tasks:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: jitterbug::Schema::Result::Task
              cond:
                foreign.taskid: self.sha256
              source: jitterbug::Schema::Result::Task
          _unique_constraints:
            primary: *2
          name: commit_push
          result_class: jitterbug::Schema::Result::Commit
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Commit
          sqlt_deploy_callback: default_sqlt_deploy_hook
        Project: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            description:
              data_type: text
            name:
              data_type: text
            owner:
              data_type: text
            projectid:
              data_type: int
              is_auto_increment: 1
            url:
              data_type: text
          _columns_info_loaded: 0
          _ordered_columns:
            - projectid
            - name
            - url
            - description
            - owner
          _primaries: &3
            - projectid
          _relationships:
            commits:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: jitterbug::Schema::Result::Commit
              cond:
                foreign.sha256: self.projectid
              source: jitterbug::Schema::Result::Commit
            tasks:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: jitterbug::Schema::Result::Task
              cond:
                foreign.taskid: self.projectid
              source: jitterbug::Schema::Result::Task
          _unique_constraints:
            primary: *3
            project_name:
              - name
          name: project
          result_class: jitterbug::Schema::Result::Project
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Project
          sqlt_deploy_callback: default_sqlt_deploy_hook
        Task: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            projectid:
              data_type: int
              is_foreign_key: 1
            running:
              data_type: bool
              default_value: 0
            sha256:
              data_type: text
              is_foreign_key: 1
            taskid:
              data_type: int
              is_auto_increment: 1
          _columns_info_loaded: 0
          _ordered_columns:
            - taskid
            - sha256
            - projectid
            - running
          _primaries: &4
            - taskid
          _relationships:
            commit:
              attrs:
                accessor: single
                is_foreign_key_constraint: 1
                undef_on_null_fk: 1
              class: jitterbug::Schema::Result::Commit
              cond:
                foreign.sha256: self.sha256
              source: jitterbug::Schema::Result::Commit
            project:
              attrs:
                accessor: single
                is_foreign_key_constraint: 1
                undef_on_null_fk: 1
              class: jitterbug::Schema::Result::Project
              cond:
                foreign.projectid: self.projectid
              source: jitterbug::Schema::Result::Project
          _unique_constraints:
            primary: *4
            task_projectid:
              - projectid
            task_sha256:
              - sha256
          name: task
          result_class: jitterbug::Schema::Result::Task
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Task
          sqlt_deploy_callback: default_sqlt_deploy_hook
        __VERSION: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            ddl:
              data_type: text
              is_nullable: 1
            id:
              data_type: int
              is_auto_increment: 1
            upgrade_sql:
              data_type: text
              is_nullable: 1
            version:
              data_type: varchar
              size: 50
          _columns_info_loaded: 0
          _ordered_columns:
            - id
            - version
            - ddl
            - upgrade_sql
          _primaries: &5
            - id
          _relationships: {}
          _unique_constraints:
            dbix_class_deploymenthandler_versions_version:
              - version
            primary: *5
          name: dbix_class_deploymenthandler_versions
          result_class: DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResult
          resultset_attributes: {}
          resultset_class: DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResultSet
          schema: *1
          source_name: __VERSION
          sqlt_deploy_callback: default_sqlt_deploy_hook
      storage: !!perl/hash:DBIx::Class::Storage::DBI
        _connect_info:
          - dbi:SQLite:dbname=jitterbug.db
        _dbh_gen: 0
        _dbi_connect_info:
          - dbi:SQLite:dbname=jitterbug.db
          - ~
          - ~
          - &6
            AutoCommit: 1
            PrintError: 0
            RaiseError: 1
        _dbic_connect_attributes: *6
        _in_dbh_do: 0
        _sql_maker: ~
        _sql_maker_opts: {}
        debugobj: !!perl/hash:DBIx::Class::Storage::Statistics {}
        savepoints: []
        schema: *1
        transaction_depth: 0
    sources:
      - Commit
      - Project
      - Task
  parser_type: SQL::Translator::Parser::DBIx::Class
  producer_args: {}
  producer_type: SQL::Translator::Producer::YAML
  show_warnings: 0
  trace: 0
  version: 0.11007