Contents

# frozen_string_literal: true

class CreateClientsAndChangeColumnCollation < ActiveRecord::Migration[5.2]
  def up
    create_table :clients do |t|
      t.string :name
      t.string :code, collation: :SQL_Latin1_General_CP1_CS_AS

      t.timestamps
    end

    change_column :clients, :name, :string, collation: 'SQL_Latin1_General_CP1_CS_AS'
    change_column :clients, :code, :string, collation: 'SQL_Latin1_General_CP1_CI_AS'
  end

  def down
    drop_table :clients
  end
end

Version data entries

39 entries across 39 versions & 1 rubygems

Version	Path
activerecord-sqlserver-adapter-7.1.11	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.2.4	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-8.0.2	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.10	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.2.3	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-8.0.1	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-8.0.0	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.2.2	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.9	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.8	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.2.1	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.2.0	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.7	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.6	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.5	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.4	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.0.7	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.3	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.2	test/migrations/create_clients_and_change_column_collation.rb
activerecord-sqlserver-adapter-7.1.1	test/migrations/create_clients_and_change_column_collation.rb