From 3624844d0a319073e5e65d0c4ab8f72b60af1125 Mon Sep 17 00:00:00 2001
From: Michael M Slusarz <slusarz@curecanti.org>
Date: Wed, 26 May 2010 10:03:31 -0600
Subject: [PATCH] Add autoincrement update script

---
 imp/migration/1_imp_base_tables.php            |  4 ++--
 imp/migration/2_imp_autoincrement_sentmail.php | 33 ++++++++++++++++++++++++++
 2 files changed, 35 insertions(+), 2 deletions(-)
 create mode 100644 imp/migration/2_imp_autoincrement_sentmail.php

diff --git a/imp/migration/1_imp_base_tables.php b/imp/migration/1_imp_base_tables.php
index 3d788ec97..cad163294 100644
--- a/imp/migration/1_imp_base_tables.php
+++ b/imp/migration/1_imp_base_tables.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * Create IMP base tables.
+ * Create IMP base tables (as of IMP 4.3).
  *
  * Copyright 2010 The Horde Project (http://www.horde.org/)
  *
@@ -21,7 +21,7 @@ class ImpBaseTables extends Horde_Db_Migration_Base
     {
         // Create: imp_sentmail
         $t = $this->createTable('imp_sentmail', array('primaryKey' => 'sentmail_id'));
-        $t->column('sentmail_id', 'integer', array('autoincrement' => true));
+        $t->column('sentmail_id', 'bigint', array('null' => false));
         $t->column('sentmail_who', 'string', array('limit' => 255, 'null' => false));
         $t->column('sentmail_ts', 'bigint', array('null' => false));
         $t->column('sentmail_messageid', 'string', array('limit' => 255, 'null' => false));
diff --git a/imp/migration/2_imp_autoincrement_sentmail.php b/imp/migration/2_imp_autoincrement_sentmail.php
new file mode 100644
index 000000000..f03ebba28
--- /dev/null
+++ b/imp/migration/2_imp_autoincrement_sentmail.php
@@ -0,0 +1,33 @@
+<?php
+/**
+ * Change sentmail_id column to autoincrement.
+ *
+ * Copyright 2010 The Horde Project (http://www.horde.org/)
+ *
+ * See the enclosed file COPYING for license information (GPL). If you
+ * did not receive this file, see http://www.fsf.org/copyleft/gpl.html.
+ *
+ * @author   Michael Slusarz <slusarz@horde.org>
+ * @category Horde
+ * @license  http://www.fsf.org/copyleft/gpl.html GPL
+ * @package  IMP
+ */
+class ImpAutoIncrementSentmail extends Horde_Db_Migration_Base
+{
+    /**
+     * Upgrade.
+     */
+    public function up()
+    {
+        $t->changeColumn('imp_sentmail', 'sentmail_id', 'integer', array('autoincrement' => true));
+    }
+
+    /**
+     * Downgrade.
+     */
+    public function down()
+    {
+        // No way to downgrade at this time.
+    }
+
+}
-- 
2.11.0