view release on metacpan or  search on metacpan

examples/MusicBase/share/migrations/_source/deploy/3/001-auto.yml  view on Meta::CPAN

          is_unique: 0
          name: title
          order: 3
          size:
            - 96
        track_id:
          data_type: integer
          default_value: ~
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: track_id
          order: 1
          size:
            - 0
      indices:
        - fields:
            - cd_fk
          name: track_idx_cd_fk
          options: []
          type: NORMAL
      name: track
      options: []
      order: 4
  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::ArtistCd: ArtistCd
        MusicBase::Schema::Result::Cd: Cd
        MusicBase::Schema::Result::Country: Country
        MusicBase::Schema::Result::Track: Track
      source_registrations:
        Artist: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            artist_id:
              data_type: integer
            country_fk:
              data_type: integer
            name:
              data_type: varchar
              size: 96
          _columns_info_loaded: 0
          _ordered_columns:
            - artist_id
            - country_fk
            - name
          _primaries: &2
            - artist_id
          _relationships:
            artist_cd_rs:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: MusicBase::Schema::Result::ArtistCd
              cond:
                foreign.artist_fk: self.artist_id
              source: MusicBase::Schema::Result::ArtistCd
            has_country:
              attrs:
                accessor: single
                fk_columns:
                  country_fk: 1
                is_foreign_key_constraint: 1
                undef_on_null_fk: 1
              class: MusicBase::Schema::Result::Country
              cond:
                foreign.country_id: self.country_fk
              source: MusicBase::Schema::Result::Country
          _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
        ArtistCd: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            artist_fk:
              data_type: integer
            cd_fk:
              data_type: integer
          _columns_info_loaded: 0
          _ordered_columns:
            - artist_fk
            - cd_fk
          _primaries: &3
            - artist_fk
            - cd_fk
          _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
            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: *3
          name: artist_cd
          result_class: MusicBase::Schema::Result::ArtistCd
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: ArtistCd
        Cd: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            cd_id:
              data_type: integer
            title:
              data_type: varchar
              size: 96
          _columns_info_loaded: 0
          _ordered_columns:
            - cd_id
            - title
          _primaries: &4
            - cd_id
          _relationships:
            artist_cd_rs:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: MusicBase::Schema::Result::ArtistCd
              cond:
                foreign.cd_fk: self.cd_id
              source: MusicBase::Schema::Result::ArtistCd
            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: *4
          name: cd
          result_class: MusicBase::Schema::Result::Cd
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Cd
        Country: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            code:
              data_type: char
              size: 3
            country_id:
              data_type: integer
          _columns_info_loaded: 0
          _ordered_columns:
            - country_id
            - code
          _primaries: &5
            - country_id
          _relationships:
            artist_rs:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: MusicBase::Schema::Result::Artist
              cond:
                foreign.country_fk: self.country_id
              source: MusicBase::Schema::Result::Artist
          _unique_constraints:
            country_code:
              - code
            primary: *5
          name: country
          result_class: MusicBase::Schema::Result::Country
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Country
        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: &6
            - 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: *6
          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: