The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.
---
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:
    DBIx::Class::Schema: ~
    DBIx::Schema: ~
    package: &1 !!perl/hash:Galileo::DB::Schema
      class_mappings:
        DBIx::Class::DeploymentHandler::VersionStorage::Standard::VersionResult: __VERSION
        Galileo::DB::Schema::Result::Menu: Menu
        Galileo::DB::Schema::Result::Page: Page
        Galileo::DB::Schema::Result::User: User
      source_registrations:
        Menu: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            list:
              data_type: VARCHAR
            menu_id:
              data_type: INT
              is_auto_increment: 1
            name:
              data_type: VARCHAR
          _columns_info_loaded: 0
          _ordered_columns:
            - menu_id
            - name
            - list
          _primaries: &2
            - menu_id
          _relationships: {}
          _unique_constraints:
            menus_name:
              - name
            primary: *2
          name: menus
          result_class: Galileo::DB::Schema::Result::Menu
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Menu
        Page: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            author_id:
              data_type: INT
            html:
              data_type: VARCHAR
            md:
              data_type: VARCHAR
            name:
              data_type: VARCHAR
            page_id:
              data_type: INT
              is_auto_increment: 1
            title:
              data_type: VARCHAR
          _columns_info_loaded: 0
          _ordered_columns:
            - page_id
            - author_id
            - name
            - title
            - html
            - md
          _primaries: &3
            - page_id
          _relationships:
            author:
              attrs:
                accessor: single
                fk_columns:
                  author_id: 1
                is_foreign_key_constraint: 1
                undef_on_null_fk: 1
              class: Galileo::DB::Schema::Result::User
              cond:
                foreign.user_id: self.author_id
              source: Galileo::DB::Schema::Result::User
          _unique_constraints:
            pages_name:
              - name
            primary: *3
          name: pages
          result_class: Galileo::DB::Schema::Result::Page
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: Page
        User: !!perl/hash:DBIx::Class::ResultSource::Table
          _columns:
            full:
              data_type: VARCHAR
            is_admin:
              data_type: BOOL
              default_value: 0
            is_author:
              data_type: BOOL
              default_value: 0
            name:
              data_type: VARCHAR
            password:
              data_type: VARCHAR
              encode_check_method: check_password
              encode_class: Crypt::Eksblowfish::Bcrypt
              encode_column: 1
            user_id:
              data_type: INT
              is_auto_increment: 1
          _columns_info_loaded: 0
          _ordered_columns:
            - user_id
            - name
            - full
            - password
            - is_author
            - is_admin
          _primaries: &4
            - user_id
          _relationships:
            pages:
              attrs:
                accessor: multi
                cascade_copy: 1
                cascade_delete: 1
                join_type: LEFT
              class: Galileo::DB::Schema::Result::Page
              cond:
                foreign.author_id: self.user_id
              source: Galileo::DB::Schema::Result::Page
          _unique_constraints:
            primary: *4
            users_name:
              - name
          name: users
          result_class: Galileo::DB::Schema::Result::User
          resultset_attributes: {}
          resultset_class: DBIx::Class::ResultSet
          schema: *1
          source_name: User
        __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: 8010
        _connect_info:
          - dbi:SQLite:dbname=/home/joel/Programs/Dist/Galileo/galileo.db
          - ~
          - ~
          - sqlite_unicode: 1
        _dbh: !!perl/hash:DBI::db {}
        _dbh_autocommit: 1
        _dbh_details: {}
        _dbh_gen: 0
        _dbi_connect_info:
          - dbi:SQLite:dbname=/home/joel/Programs/Dist/Galileo/galileo.db
          - ~
          - ~
          - &6
            AutoCommit: 1
            PrintError: 0
            RaiseError: 1
            ShowErrorStatement: 1
            sqlite_unicode: 1
        _dbic_connect_attributes: *6
        _driver_determined: 1
        _in_do_block: 0
        _sql_maker: !!perl/hash:DBIx::Class::SQLMaker::SQLite
          array_datatypes: 1
          bindtype: columns
          cmp: =
          equality_op: !!perl/regexp (?^i:^(\=|is|(is\s+)?like)$)
          inequality_op: !!perl/regexp (?^i:^(!=|<>|(is\s+)?not(\s+like)?)$)
          injection_guard: !!perl/regexp |-
            (?^mix:
                \;
                  |
                ^ \s* go \s
              )
          limit_dialect: LimitOffset
          logic: OR
          name_sep: .
          special_ops:
            - handler: _where_field_BETWEEN
              regex: !!perl/regexp '(?^ix:^ (?: not \s )? between $)'
            - handler: _where_field_IN
              regex: !!perl/regexp '(?^ix:^ (?: not \s )? in      $)'
            - handler: _where_op_IDENT
              regex: !!perl/regexp (?^ix:^ ident                 $)
            - handler: _where_op_VALUE
              regex: !!perl/regexp (?^ix:^ value                 $)
            - &7
              handler: _where_op_IDENT
              regex: !!perl/regexp (?^ix:^ ident $)
            - &8
              handler: _where_op_VALUE
              regex: !!perl/regexp (?^ix:^ value $)
          sqlfalse: 0=1
          sqltrue: 1=1
          unary_ops:
            - handler: _where_op_ANDOR
              regex: !!perl/regexp '(?^ix:^ and  (?: [_\s]? \d+ )? $)'
            - handler: _where_op_ANDOR
              regex: !!perl/regexp '(?^ix:^ or   (?: [_\s]? \d+ )? $)'
            - handler: _where_op_NEST
              regex: !!perl/regexp '(?^ix:^ nest (?: [_\s]? \d+ )? $)'
            - handler: _where_op_BOOL
              regex: !!perl/regexp '(?^ix:^ (?: not \s )? bool     $)'
            - handler: _where_op_IDENT
              regex: !!perl/regexp (?^ix:^ ident                  $)
            - handler: _where_op_VALUE
              regex: !!perl/regexp (?^ix:^ value                  $)
            - *7
            - *8
        _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.11012