blob: 1d3716eb2f7087a3cb62549832efb547557bcf93 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
class AddUniqueIndexOnTokensValue < ActiveRecord::Migration[4.2]
def up
say_with_time "Adding unique index on tokens, this may take some time..." do
# Just in case
duplicates = Token.connection.select_values("SELECT value FROM #{Token.table_name} GROUP BY value HAVING COUNT(id) > 1")
Token.where(:value => duplicates).delete_all
add_index :tokens, :value, :unique => true, :name => 'tokens_value'
end
end
def down
remove_index :tokens, :name => 'tokens_value'
end
end
|
