---
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:
    package: &1 !!perl/hash:MusicBase::Schema
      class_mappings:
        DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResult: __VERSION
        MusicBase::Schema::Result::Artist: Artist
        MusicBase::Schema::Result::Cd: Cd
        MusicBase::Schema::Result::Track: Track
      source_registrations:
        Artist: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            artist_id:
              data_type: integer
            name:
              data_type: varchar
              size: 96
          _columns_info_loaded: 0
          _ordered_columns:
            - artist_id
            - name
          _primaries: &2
            - artist_id
          _relationships:
            cd_rs:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: MusicBase::Schema::Result::Cd
              cond:
                foreign.artist_fk: self.artist_id
              source: MusicBase::Schema::Result::Cd
          _unique_constraints:
            primary: *2
          name: artist
          result_class: MusicBase::Schema::Result::Artist
          resultset_attributes: {}
          resultset_class: MusicBase::Schema::ResultSet::Artist
          schema: *1
          source_name: Artist
        Cd: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            artist_fk:
              data_type: integer
            cd_id:
              data_type: integer
            title:
              data_type: varchar
              size: 96
          _columns_info_loaded: 0
          _ordered_columns:
            - cd_id
            - artist_fk
            - title
          _primaries: &3
            - cd_id
          _relationships:
            artist:
              attrs:
                accessor: single
                fk_columns:
                  artist_fk: 1
                is_foreign_key_constraint: 1
                undef_on_null_fk: 1
              class: MusicBase::Schema::Result::Artist
              cond:
                foreign.artist_id: self.artist_fk
              source: MusicBase::Schema::Result::Artist
            track_rs:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: MusicBase::Schema::Result::Track
              cond:
                foreign.cd_fk: self.cd_id
              source: MusicBase::Schema::Result::Track
          _unique_constraints:
            primary: *3
          name: cd
          result_class: MusicBase::Schema::Result::Cd
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Cd
        Track: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            cd_fk:
              data_type: integer
            title:
              data_type: varchar
              size: 96
            track_id:
              data_type: integer
          _columns_info_loaded: 0
          _ordered_columns:
            - track_id
            - cd_fk
            - title
          _primaries: &4
            - track_id
          _relationships:
            cd:
              attrs:
                accessor: single
                fk_columns:
                  cd_fk: 1
                is_foreign_key_constraint: 1
                undef_on_null_fk: 1
              class: MusicBase::Schema::Result::Cd
              cond:
                foreign.cd_id: self.cd_fk
              source: MusicBase::Schema::Result::Cd
          _unique_constraints:
            primary: *4
          name: track
          result_class: MusicBase::Schema::Result::Track
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Track
        __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
      storage: !!perl/hash:DBIx::Class::Storage::DBI::SQLite
        _conn_pid: 1098
        _connect_info:
          - DBI:SQLite:/Users/johnn/Desktop/MusicBase/share/musicbase-schema.db
          - ''
          - ''
        _dbh: !!perl/hash:DBI::db {}
        _dbh_autocommit: 1
        _dbh_details: {}
        _dbh_gen: 0
        _dbi_connect_info:
          - DBI:SQLite:/Users/johnn/Desktop/MusicBase/share/musicbase-schema.db
          - ''
          - ''
          - &6
            AutoCommit: 1
            PrintError: 0
            RaiseError: 1
            ShowErrorStatement: 1
        _dbic_connect_attributes: *6
        _driver_determined: 1
        _in_do_block: 0
        _sql_maker: ~
        _sql_maker_opts: {}
        savepoints: []
        schema: *1
        transaction_depth: 0
    sources:
      - __VERSION
  parser_type: SQL::Translator::Parser::DBIx::Class
  producer_args: {}
  producer_type: SQL::Translator::Producer::YAML
  show_warnings: 0
  trace: 0
  version: 0.11010