about summary refs log tree commit diff
path: root/db/migrate/20170112154826_migrate_settings.rb
blob: 0f5afe1d39b480a12d3da10bca0b351c9327cb5a (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
class MigrateSettings < ActiveRecord::Migration[4.2]
  def up
    remove_index :settings, [:target_type, :target_id, :var]
    rename_column :settings, :target_id, :thing_id
    rename_column :settings, :target_type, :thing_type
    change_column :settings, :thing_id, :integer, null: true, default: nil
    change_column :settings, :thing_type, :string, null: true, default: nil
    add_index :settings, [:thing_type, :thing_id, :var], unique: true
  end

  def down
    remove_index :settings, [:thing_type, :thing_id, :var]
    rename_column :settings, :thing_id, :target_id
    rename_column :settings, :thing_type, :target_type
    change_column :settings, :target_id, :integer, null: false
    change_column :settings, :target_type, :string, null: false, default: ''
    add_index :settings, [:target_type, :target_id, :var], unique: true
  end
end