X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/c3e2e6462f293596aef5d5de18b0a173edc046c7..366a9e9097e6b8ca19cd3ecb2b08db1fbc0e2274:/db/migrate/023_add_changesets.rb diff --git a/db/migrate/023_add_changesets.rb b/db/migrate/023_add_changesets.rb index 3a6c32e19..933a62cd5 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)" + - "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