X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/34e3e51456774127d43408b7ab65c24f41373f62..e057175ca964d7471154e02e5a511ef95523ad45:/db/migrate/023_add_changesets.rb diff --git a/db/migrate/023_add_changesets.rb b/db/migrate/023_add_changesets.rb index aac921ad8..8265353a7 100644 --- a/db/migrate/023_add_changesets.rb +++ b/db/migrate/023_add_changesets.rb @@ -1,8 +1,7 @@ -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| @@ -29,20 +28,20 @@ class AddChangesets < ActiveRecord::Migration # 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