diff options
author | Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com> | 2014-12-23 12:05:50 +0300 |
---|---|---|
committer | Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com> | 2014-12-23 13:00:48 +0300 |
commit | 3349c5b7636ae4ff735de8d085155e326c7057d4 (patch) | |
tree | db9421796161aa370906749226f3f2881679761b | |
parent | 3620ea42e881119413fb373ccb9481691732ef03 (diff) |
Remove index only if exists
Signed-off-by: Dmitriy Zaporozhets <dmitriy.zaporozhets@gmail.com>
-rw-r--r-- | db/migrate/20141121161704_add_identity_table.rb | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/db/migrate/20141121161704_add_identity_table.rb b/db/migrate/20141121161704_add_identity_table.rb index cf56fd6c227..a85b0426cec 100644 --- a/db/migrate/20141121161704_add_identity_table.rb +++ b/db/migrate/20141121161704_add_identity_table.rb @@ -14,7 +14,10 @@ SELECT provider, extern_uid, id FROM users WHERE provider IS NOT NULL eos - remove_index :users, ["extern_uid", "provider"] + if index_exists?(:users, ["extern_uid", "provider"]) + remove_index :users, ["extern_uid", "provider"] + end + remove_column :users, :extern_uid remove_column :users, :provider end @@ -35,6 +38,9 @@ eos end drop_table :identities - add_index "users", ["extern_uid", "provider"], name: "index_users_on_extern_uid_and_provider", unique: true, using: :btree + + unless index_exists?(:users, ["extern_uid", "provider"]) + add_index "users", ["extern_uid", "provider"], name: "index_users_on_extern_uid_and_provider", unique: true, using: :btree + end end end |