Sha256: d7db59aeae22f94b1c1a2b58a3d6a40407e517bc47f19bf8d9d28e3c268a161a

Contents?: true

Size: 1.42 KB

Versions: 37

Compression:

Stored size: 1.42 KB

Contents

class SchemaConstraintsCleanup < ActiveRecord::Migration
  # Set reasonable size limit to a bunch of indexed string columns. They were defaulted to 255
  def change
    change_column :github_hooks, :event, :string, limit: 50, null: false # The biggest existing event is 27
    change_column :github_hooks, :organization, :string, limit: 39 # https://github.com/Shopify/shipit-engine/blob/d9aa8d54902de9ab3bd1ea4503003cca7df5d431/app/models/stack.rb#L4

    change_column :stacks, :repo_name, :string, limit: 100, null: false # https://github.com/Shopify/shipit-engine/blob/d9aa8d54902de9ab3bd1ea4503003cca7df5d431/app/models/stack.rb#L5
    change_column :stacks, :repo_owner, :string, limit: 39, null: false # https://github.com/Shopify/shipit-engine/blob/d9aa8d54902de9ab3bd1ea4503003cca7df5d431/app/models/stack.rb#L4
    change_column :stacks, :environment, :string, limit: 50, null: false, default: 'production'

    change_column :tasks, :status, :string, limit: 10, null: false, default: 'pending'

    change_column :teams, :organization, :string, limit: 39 # https://github.com/Shopify/shipit-engine/blob/d9aa8d54902de9ab3bd1ea4503003cca7df5d431/app/models/stack.rb#L4
    change_column :teams, :slug, :string, limit: 50 # No real limit GH side AFAICT, but come on...

    change_column :users, :login, :string, limit: 39 # https://github.com/Shopify/shipit-engine/blob/d9aa8d54902de9ab3bd1ea4503003cca7df5d431/app/models/stack.rb#L4
  end
end

Version data entries

37 entries across 37 versions & 1 rubygems

Version Path
shipit-engine-0.18.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.17.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.16.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.15.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.14.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.13.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.12.1 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.12.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.11.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.10.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.9.0 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.9 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.8 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.7 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.6 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.5 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.4 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.3 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.2 db/migrate/20151102201634_schema_constraints_cleanup.rb
shipit-engine-0.8.1 db/migrate/20151102201634_schema_constraints_cleanup.rb