From: Tom Hughes <tom@compton.nu>
Date: Mon, 30 Jul 2007 22:59:20 +0000 (+0000)
Subject: Add migration to create session table in the database.
X-Git-Tag: live~8226
X-Git-Url: https://git.openstreetmap.org/rails.git/commitdiff_plain/87a673e74c181c97931ad68c234fbff4293ee8de

Add migration to create session table in the database.
---

diff --git a/db/migrate/003_sql_session_store_setup.rb b/db/migrate/003_sql_session_store_setup.rb
new file mode 100644
index 000000000..7b1c75479
--- /dev/null
+++ b/db/migrate/003_sql_session_store_setup.rb
@@ -0,0 +1,15 @@
+class SqlSessionStoreSetup < ActiveRecord::Migration
+  def self.up
+    create_table "sessions", :options => "ENGINE=InnoDB" 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
+
+  def self.down
+    drop_table "sessions"
+  end
+end