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)