From 9a06dd4aa1ab008b6e12205ec3f8d00a50f79aa1 Mon Sep 17 00:00:00 2001 From: Andrew8xx8 Date: Mon, 4 Mar 2013 18:51:00 +0400 Subject: Migrations added --- db/migrate/20130304104623_add_state_to_user.rb | 5 +++++ db/migrate/20130304104740_convert_blocked_to_state.rb | 14 ++++++++++++++ db/migrate/20130304105317_remove_blocked_from_user.rb | 9 +++++++++ 3 files changed, 28 insertions(+) create mode 100644 db/migrate/20130304104623_add_state_to_user.rb create mode 100644 db/migrate/20130304104740_convert_blocked_to_state.rb create mode 100644 db/migrate/20130304105317_remove_blocked_from_user.rb (limited to 'db') diff --git a/db/migrate/20130304104623_add_state_to_user.rb b/db/migrate/20130304104623_add_state_to_user.rb new file mode 100644 index 00000000000..8154c21065f --- /dev/null +++ b/db/migrate/20130304104623_add_state_to_user.rb @@ -0,0 +1,5 @@ +class AddStateToUser < ActiveRecord::Migration + def change + add_column :users, :state, :string + end +end diff --git a/db/migrate/20130304104740_convert_blocked_to_state.rb b/db/migrate/20130304104740_convert_blocked_to_state.rb new file mode 100644 index 00000000000..91c65d4fd39 --- /dev/null +++ b/db/migrate/20130304104740_convert_blocked_to_state.rb @@ -0,0 +1,14 @@ +class ConvertBlockedToState < ActiveRecord::Migration + def up + User.transaction do + User.where(blocked: true).update_all(state: :blocked) + User.where(blocked: false).update_all(state: :active) + end + end + + def down + User.transaction do + User.where(satate: :blocked).update_all(blocked: :true) + end + end +end diff --git a/db/migrate/20130304105317_remove_blocked_from_user.rb b/db/migrate/20130304105317_remove_blocked_from_user.rb new file mode 100644 index 00000000000..e010474538c --- /dev/null +++ b/db/migrate/20130304105317_remove_blocked_from_user.rb @@ -0,0 +1,9 @@ +class RemoveBlockedFromUser < ActiveRecord::Migration + def up + remove_column :users, :blocked + end + + def down + add_column :users, :blocked, :boolean + end +end -- cgit v1.2.3