X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/cd2ca12d4235473cd3611b84e2a61649c17da2f6..35fbcf28154b6f15f697018016fbabc952e018a5:/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..9039bb5d6 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 - @@conv_user_tables = ['current_nodes', - 'current_relations', 'current_ways', 'nodes', 'relations', 'ways' ] - + @conv_user_tables = %w(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)" + + 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" + fail ActiveRecord::IrreversibleMigration + # drop_table "changesets" + # drop_table "changeset_tags" end end