X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/497009ed2b98dfdeeb349e891c1fbd88d14ff087..8a4405dd0c3af7783d0cc9a4f864f4ee5cd0e71d:/db/migrate/023_add_changesets.rb?ds=sidebyside diff --git a/db/migrate/023_add_changesets.rb b/db/migrate/023_add_changesets.rb index 3a6c32e19..8d19fc1c3 100644 --- a/db/migrate/023_add_changesets.rb +++ b/db/migrate/023_add_changesets.rb @@ -1,9 +1,8 @@ -require 'migrate' +require "migrate" + +class AddChangesets < ActiveRecord::Migration[5.0] + @conv_user_tables = %w[current_nodes current_relations current_ways nodes relations ways] -class AddChangesets < ActiveRecord::Migration - @@conv_user_tables = ['current_nodes', - 'current_relations', 'current_ways', 'nodes', 'relations', 'ways' ] - def self.up create_table "changesets", :id => false do |t| t.column "id", :bigserial, :primary_key => true, :null => false @@ -23,26 +22,26 @@ class AddChangesets < ActiveRecord::Migration end add_index "changeset_tags", ["id"], :name => "changeset_tags_id_idx" - + # - # Initially we will have one changeset for every user containing - # all edits up to the API change, + # Initially we will have one changeset for every user containing + # all edits up to the API change, # all the changesets will have the id of the user that made them. # We need to generate a changeset for each user in the database - execute "INSERT INTO changesets (id, user_id, created_at, open)" + - "SELECT id, id, creation_time, false from users;" + execute "INSERT INTO changesets (id, user_id, created_at, open)" \ + "SELECT id, id, creation_time, false from users;" - @@conv_user_tables.each { |tbl| + @conv_user_tables.each do |tbl| rename_column tbl, :user_id, :changeset_id - #foreign keys too + # foreign keys too add_foreign_key tbl, :changesets, :name => "#{tbl}_changeset_id_fkey" - } + end end def self.down # It's not easy to generate the user ids from the changesets raise ActiveRecord::IrreversibleMigration - #drop_table "changesets" - #drop_table "changeset_tags" + # drop_table "changesets" + # drop_table "changeset_tags" end end