From 56d4e0abf0ecd5f889cf8c42fb718be0fe234f0d Mon Sep 17 00:00:00 2001
From: kurund <kurund@civicrm.org>
Date: Fri, 30 Aug 2013 14:28:31 +0530
Subject: [PATCH] CRM-13066, move alter to php from template

----------------------------------------
* CRM-13066: 'Clean up Caches' deletes in progress batches
  http://issues.civicrm.org/jira/browse/CRM-13066
---
 CRM/Upgrade/Incremental/php/FourFour.php        | 4 ++++
 CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl | 1 -
 2 files changed, 4 insertions(+), 1 deletion(-)

diff --git a/CRM/Upgrade/Incremental/php/FourFour.php b/CRM/Upgrade/Incremental/php/FourFour.php
index 30f53ff90b..dadc4f00de 100644
--- a/CRM/Upgrade/Incremental/php/FourFour.php
+++ b/CRM/Upgrade/Incremental/php/FourFour.php
@@ -80,6 +80,10 @@ class CRM_Upgrade_Incremental_php_FourFour {
   function upgrade_4_4_beta1($rev) {
     $this->addTask(ts('Upgrade DB to 4.4.beta1: SQL'), 'task_4_4_x_runSql', $rev);
 
+    // add new 'data' column in civicrm_batch
+    $query = 'ALTER TABLE civicrm_batch ADD data LONGTEXT NULL COMMENT "cache entered data"';
+    CRM_Core_DAO::executeQuery($query);
+
     // check if batch entry data exists in civicrm_cache table
     $query = 'SELECT path, data FROM civicrm_cache WHERE group_name = "batch entry"';
     $dao = CRM_Core_DAO::executeQuery($query);
diff --git a/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl
index 6a390d87e2..17cb1cb064 100644
--- a/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.4.beta1.mysql.tpl
@@ -1,2 +1 @@
 {* file to handle db changes in 4.4.beta1 during upgrade *}
-ALTER TABLE civicrm_batch ADD data LONGTEXT NULL COMMENT 'cache entered data';
-- 
2.25.1