Drop the sessions table

[rails.git] / db / migrate / 20120328090602_drop_session_table.rb

diff --git a/db/migrate/20120328090602_drop_session_table.rb b/db/migrate/20120328090602_drop_session_table.rb
new file mode 100644 (file)
index 0000000..e5f9739
--- /dev/null
+++ b/db/migrate/20120328090602_drop_session_table.rb
@@ -0,0 +1,17 @@
+require 'migrate'
+
+class DropSessionTable < ActiveRecord::Migration
+  def up
+    drop_table "sessions"
+  end
+
+  def down
+    create_table "sessions", :options => innodb_option do |t|
+      t.column "session_id", :string
+      t.column "data",       :text
+      t.column "created_at", :timestamp
+      t.column "updated_at", :timestamp
+    end
+    add_index "sessions", ["session_id"], :name => "sessions_session_id_idx", :unique => true
+  end
+end