X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/bed9cd00ed166ce346da4b8a9b654ddf86e64e70..0e7cc08c7b1055341dc01cfdc331fac1a13964c1:/db/migrate/024_order_relation_members.rb?ds=sidebyside diff --git a/db/migrate/024_order_relation_members.rb b/db/migrate/024_order_relation_members.rb index 5500edfcf..e773da3cd 100644 --- a/db/migrate/024_order_relation_members.rb +++ b/db/migrate/024_order_relation_members.rb @@ -1,16 +1,18 @@ -class OrderRelationMembers < ActiveRecord::Migration +require "migrate" + +class OrderRelationMembers < ActiveRecord::Migration[5.0] def self.up # add sequence column. rails won't let us define an ordering here, # as defaults must be constant. add_column(:relation_members, :sequence_id, :integer, :default => 0, :null => false) - # update the sequence column with default (partial) ordering by + # update the sequence column with default (partial) ordering by # element ID. the sequence ID is a smaller int type, so we can't # just copy the member_id. execute("update relation_members set sequence_id = mod(member_id, 16384)") - # need to update the primary key to include the sequence number, + # need to update the primary key to include the sequence number, # otherwise the primary key will barf when we have repeated members. # mysql barfs on this anyway, so we need a single command. this may # not work in postgres... needs testing.