discourse/db/migrate/20160302063432_rebuild_directory_item_with_index.rb

# frozen_string_literal: true

class RebuildDirectoryItemWithIndex < ActiveRecord::Migration[4.2]
  def up
    remove_index :directory_items, [:period_type]
    execute "TRUNCATE TABLE directory_items RESTART IDENTITY"
    add_index :directory_items, %i[period_type user_id], unique: true
  end

  def down
    remove_index :directory_items, %i[period_type user_id]
    add_index :directory_items, [:period_type]
  end
end