Migrations added

3 files changed, 28 insertions, 0 deletions

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