From 1603d65f51c64a232f8d6ebe70d162ac86887d36 Mon Sep 17 00:00:00 2001
From: Jan Schneider <jan@horde.org>
Date: Fri, 28 Jan 2011 18:13:32 +0100
Subject: [PATCH] Convert Horde_SessionHandler to migrations.

---
 .../1_horde_sessionhandler_base_tables.php           | 20 ++++++++++++++++++++
 horde/scripts/sql/horde_sessionhandler.mssql.sql     |  9 ---------
 horde/scripts/sql/horde_sessionhandler.mysql.sql     |  9 ---------
 horde/scripts/sql/horde_sessionhandler.oci8.sql      |  9 ---------
 horde/scripts/sql/horde_sessionhandler.pgsql.sql     |  8 --------
 horde/scripts/sql/horde_sessionhandler.sql           | 11 -----------
 ...02-13_horde_sessionhandler_lastmodified_index.sql |  1 -
 7 files changed, 20 insertions(+), 47 deletions(-)
 create mode 100644 framework/SessionHandler/migration/Horde/SessionHandler/1_horde_sessionhandler_base_tables.php
 delete mode 100644 horde/scripts/sql/horde_sessionhandler.mssql.sql
 delete mode 100644 horde/scripts/sql/horde_sessionhandler.mysql.sql
 delete mode 100644 horde/scripts/sql/horde_sessionhandler.oci8.sql
 delete mode 100644 horde/scripts/sql/horde_sessionhandler.pgsql.sql
 delete mode 100644 horde/scripts/sql/horde_sessionhandler.sql
 delete mode 100644 horde/scripts/upgrades/2009-02-13_horde_sessionhandler_lastmodified_index.sql

diff --git a/framework/SessionHandler/migration/Horde/SessionHandler/1_horde_sessionhandler_base_tables.php b/framework/SessionHandler/migration/Horde/SessionHandler/1_horde_sessionhandler_base_tables.php
new file mode 100644
index 000000000..53a1f1652
--- /dev/null
+++ b/framework/SessionHandler/migration/Horde/SessionHandler/1_horde_sessionhandler_base_tables.php
@@ -0,0 +1,20 @@
+<?php
+class HordeSessionhandlerBaseTables extends Horde_Db_Migration_Base
+{
+    public function up()
+    {
+        if (!in_array('horde_sessionhandler', $this->tables())) {
+            $t = $this->createTable('horde_sessionhandler', array('primaryKey' => array('session_id')));
+            $t->column('session_id', 'string', array('limit' => 32, 'null' => false));
+            $t->column('session_lastmodified', 'integer', array('null' => false));
+            $t->column('session_data', 'binary');
+            $t->end();
+            $this->addIndex('horde_sessionhandler', array('session_lastmodified'));
+        }
+    }
+
+    public function down()
+    {
+        $this->dropTable('horde_sessionhandler');
+    }
+}
diff --git a/horde/scripts/sql/horde_sessionhandler.mssql.sql b/horde/scripts/sql/horde_sessionhandler.mssql.sql
deleted file mode 100644
index 56e1ab58f..000000000
--- a/horde/scripts/sql/horde_sessionhandler.mssql.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-CREATE TABLE horde_sessionhandler (
-    session_id             VARCHAR(32) NOT NULL,
-    session_lastmodified   INT NOT NULL,
-    session_data           VARBINARY(MAX),
-
-    PRIMARY KEY (session_id)
-);
-
-CREATE INDEX session_lastmodified_idx ON horde_sessionhandler (session_lastmodified);
diff --git a/horde/scripts/sql/horde_sessionhandler.mysql.sql b/horde/scripts/sql/horde_sessionhandler.mysql.sql
deleted file mode 100644
index fa599d900..000000000
--- a/horde/scripts/sql/horde_sessionhandler.mysql.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-CREATE TABLE horde_sessionhandler (
-    session_id             VARCHAR(32) NOT NULL,
-    session_lastmodified   INT NOT NULL,
-    session_data           LONGBLOB,
-
-    PRIMARY KEY (session_id)
-) ENGINE = InnoDB;
-
-CREATE INDEX session_lastmodified_idx ON horde_sessionhandler (session_lastmodified);
diff --git a/horde/scripts/sql/horde_sessionhandler.oci8.sql b/horde/scripts/sql/horde_sessionhandler.oci8.sql
deleted file mode 100644
index 3299f681e..000000000
--- a/horde/scripts/sql/horde_sessionhandler.oci8.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-CREATE TABLE horde_sessionhandler (
-    session_id             VARCHAR2(32) NOT NULL,
-    session_lastmodified   NUMBER(16) NOT NULL,
-    session_data           BLOB,
---
-    PRIMARY KEY (session_id)
-);
-
-CREATE INDEX session_lastmodified_idx ON horde_sessionhandler (session_lastmodified);
diff --git a/horde/scripts/sql/horde_sessionhandler.pgsql.sql b/horde/scripts/sql/horde_sessionhandler.pgsql.sql
deleted file mode 100644
index de8f77112..000000000
--- a/horde/scripts/sql/horde_sessionhandler.pgsql.sql
+++ /dev/null
@@ -1,8 +0,0 @@
-CREATE TABLE horde_sessionhandler (
-    session_id             VARCHAR(32) NOT NULL,
-    session_lastmodified   INT NOT NULL,
-    session_data           TEXT,
-    PRIMARY KEY (session_id)
-);
-
-CREATE INDEX session_lastmodified_idx ON horde_sessionhandler (session_lastmodified);
diff --git a/horde/scripts/sql/horde_sessionhandler.sql b/horde/scripts/sql/horde_sessionhandler.sql
deleted file mode 100644
index 53fbad1c2..000000000
--- a/horde/scripts/sql/horde_sessionhandler.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-CREATE TABLE horde_sessionhandler (
-    session_id             VARCHAR(32) NOT NULL,
-    session_lastmodified   INT NOT NULL,
-    session_data           LONGBLOB,
--- Or, on some DBMS systems:
---  session_data           IMAGE,
-
-    PRIMARY KEY (session_id)
-);
-
-CREATE INDEX session_lastmodified_idx ON horde_sessionhandler (session_lastmodified);
diff --git a/horde/scripts/upgrades/2009-02-13_horde_sessionhandler_lastmodified_index.sql b/horde/scripts/upgrades/2009-02-13_horde_sessionhandler_lastmodified_index.sql
deleted file mode 100644
index 7c1eb2f4f..000000000
--- a/horde/scripts/upgrades/2009-02-13_horde_sessionhandler_lastmodified_index.sql
+++ /dev/null
@@ -1 +0,0 @@
-CREATE INDEX session_lastmodified_idx ON horde_sessionhandler (session_lastmodified);
-- 
2.11.0