Contents

class RemovePositionUniqueConstraintFromTool < ActiveRecord::Migration
  def change
    reversible do |dir|
      dir.up do
        execute <<-SQL
          ALTER TABLE bit_core_tools
            DROP CONSTRAINT IF EXISTS bit_core_tool_position
        SQL
      end

      dir.down do
        # make deferrable so that positions can be updated
        execute <<-SQL
          ALTER TABLE bit_core_tools
            ADD CONSTRAINT bit_core_tool_position UNIQUE (position)
            DEFERRABLE INITIALLY IMMEDIATE
        SQL
      end
    end
  end
end

Version data entries

68 entries across 68 versions & 1 rubygems

Version	Path
think_feel_do_engine-3.12.0	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb
think_feel_do_engine-3.11.3	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb
think_feel_do_engine-3.11.0	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb
think_feel_do_engine-3.10.10	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb
think_feel_do_engine-3.10.9	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb
think_feel_do_engine-3.10.8	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb
think_feel_do_engine-3.10.7	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb
think_feel_do_engine-3.10.6	db/migrate/20141202133320_remove_position_unique_constraint_from_tool.rb