From f3c72fc3a9018da169bc32610c33b5367b8d43bc Mon Sep 17 00:00:00 2001
From: Jan Schneider <jan@horde.org>
Date: Thu, 23 Dec 2010 17:18:55 +0100
Subject: [PATCH] alarm_params needs to be a BLOB to store serialized
 Horde_Mime_Part objects.

---
 .../migration/Horde/Alarm/2_horde_alarms_params_blob.php    | 13 +++++++++++++
 .../upgrades/2010-12-23_horde_alarms_params_blob.sql        |  1 +
 2 files changed, 14 insertions(+)
 create mode 100644 framework/Alarm/migration/Horde/Alarm/2_horde_alarms_params_blob.php
 create mode 100644 horde/scripts/upgrades/2010-12-23_horde_alarms_params_blob.sql

diff --git a/framework/Alarm/migration/Horde/Alarm/2_horde_alarms_params_blob.php b/framework/Alarm/migration/Horde/Alarm/2_horde_alarms_params_blob.php
new file mode 100644
index 000000000..aa6126511
--- /dev/null
+++ b/framework/Alarm/migration/Horde/Alarm/2_horde_alarms_params_blob.php
@@ -0,0 +1,13 @@
+<?php
+class HordeAlarmsParamsBlob extends Horde_Db_Migration_Base
+{
+    public function up()
+    {
+        $this->changeColumn('horde_alarms', 'alarm_params', 'binary');
+    }
+
+    public function down()
+    {
+        $this->changeColumn('horde_alarms', 'alarm_params', 'text');
+    }
+}
diff --git a/horde/scripts/upgrades/2010-12-23_horde_alarms_params_blob.sql b/horde/scripts/upgrades/2010-12-23_horde_alarms_params_blob.sql
new file mode 100644
index 000000000..ffc7fcb06
--- /dev/null
+++ b/horde/scripts/upgrades/2010-12-23_horde_alarms_params_blob.sql
@@ -0,0 +1 @@
+ALTER TABLE horde_alarms CHANGE COLUMN alarm_params alarm_params BLOB;
-- 
2.11.0