From 87a673e74c181c97931ad68c234fbff4293ee8de Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Mon, 30 Jul 2007 22:59:20 +0000
Subject: [PATCH] Add migration to create session table in the database.

---
 db/migrate/003_sql_session_store_setup.rb | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 db/migrate/003_sql_session_store_setup.rb

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
-- 
2.43.2