X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/e660e609661edadc1ed5ad49d6e83e936b2f91cd..4d6df34c4bca932b75f2260fe533b4d22c3651f9:/db/migrate/051_add_status_to_user.rb?ds=inline diff --git a/db/migrate/051_add_status_to_user.rb b/db/migrate/051_add_status_to_user.rb index 01d501d01..bea9f125f 100644 --- a/db/migrate/051_add_status_to_user.rb +++ b/db/migrate/051_add_status_to_user.rb @@ -1,14 +1,15 @@ -require 'migrate' +class AddStatusToUser < ActiveRecord::Migration[4.2] + class User < ApplicationRecord + end -class AddStatusToUser < ActiveRecord::Migration def self.up - create_enumeration :user_status_enum, ["pending","active","confirmed","suspended","deleted"] + create_enum :user_status_enum, %w[pending active confirmed suspended deleted] add_column :users, :status, :user_status_enum, :null => false, :default => "pending" - User.update_all("status = 'deleted'", { :visible => false }) - User.update_all("status = 'pending'", { :visible => true, :active => 0 }) - User.update_all("status = 'active'", { :visible => true, :active => 1 }) + User.where(:visible => false).update_all(:status => "deleted") + User.where(:visible => true, :active => 0).update_all(:status => "pending") + User.where(:visible => true, :active => 1).update_all(:status => "active") remove_column :users, :active remove_column :users, :visible @@ -18,9 +19,9 @@ class AddStatusToUser < ActiveRecord::Migration add_column :users, :visible, :boolean, :default => true, :null => false add_column :users, :active, :integer, :default => 0, :null => false - User.update_all("visible = true, active = 1", { :status => "active" }) - User.update_all("visible = true, active = 0", { :status => "pending" }) - User.update_all("visible = false, active = 1", { :status => "deleted" }) + User.where(:status => "active").update_all(:visible => true, :active => 1) + User.where(:status => "pending").update_all(:visible => true, :active => 0) + User.where(:status => "deleted").update_all(:visible => false, :active => 1) remove_column :users, :status