X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/34e3e51456774127d43408b7ab65c24f41373f62..037585db3933a2954b43bd4b30ea5e30ade00be2:/db/migrate/023_add_changesets.rb diff --git a/db/migrate/023_add_changesets.rb b/db/migrate/023_add_changesets.rb index aac921ad8..9039bb5d6 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| @@ -32,17 +31,17 @@ class AddChangesets < ActiveRecord::Migration 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