Revision 10a9a917
Added by Justin Sherrill over 8 years ago
db/migrate/20140805114754_add_unique_index_to_parameter.rb | ||
---|---|---|
class AddUniqueIndexToParameter < ActiveRecord::Migration
|
||
def up
|
||
found = []
|
||
Parameter.find_each do |param|
|
||
new_param = {:name => param.name, :type => param.type, :reference_id => param.reference_id}
|
||
if found.include?(new_param)
|
||
param.destroy
|
||
else
|
||
found << new_param
|
||
end
|
||
end
|
||
|
||
add_index :parameters, [:type, :reference_id, :name], :unique => true
|
||
end
|
||
|
Also available in: Unified diff
Fixes #11339 - ensure unique parameters before adding uniq index
(cherry picked from commit fe5010723b86f26018fc7fb4ee054c734173b5a2)