From: ivan <ivan>
Date: Tue, 29 Dec 2009 04:24:27 +0000 (+0000)
Subject: don't change h_queue.job type under non-mysql, takes forever on large dbs, RT#6946
X-Git-Tag: root_of_svc_elec_features~589
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=d4eab1fdd4a61f9da7cc54afbd4dbff217bd0bdd

don't change h_queue.job type under non-mysql, takes forever on large dbs, RT#6946
---

diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade
index 3882ffb2b..5f9b0f718 100755
--- a/FS/bin/freeside-upgrade
+++ b/FS/bin/freeside-upgrade
@@ -67,7 +67,7 @@ my @statements =
 unless ( driver_name =~ /^mysql/i ) {
   #not necessary under non-mysql, takes forever on big db
   @statements =
-    grep { $_ !~ /^ *ALTER +TABLE +h_queue +ALTER +COLUMN +job +TYPE +varchar\(512\) *$/ }
+    grep { $_ !~ /^ *ALTER +TABLE +h_queue +ALTER +COLUMN +job +TYPE +varchar\(512\) *$/i }
          @statements;
 }