From: Christopher Burger <burgerc@freeside.biz>
Date: Fri, 21 Dec 2018 19:06:15 +0000 (-0500)
Subject: RT# 81596 - fixed freeside-upgrade to not drop custom fields
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=c213fdbabc178985a93996aac33a907465b31007

RT# 81596 - fixed freeside-upgrade to not drop custom fields
---

diff --git a/FS/bin/freeside-upgrade b/FS/bin/freeside-upgrade
index c5df06dc3..0df388411 100755
--- a/FS/bin/freeside-upgrade
+++ b/FS/bin/freeside-upgrade
@@ -120,7 +120,7 @@ while ( $cf = $cfsth->fetchrow_hashref ) {
     my $name = $cf->{'name'};
     $name = lc($name) unless driver_name =~ /^mysql/i;
 
-    @statements = grep { $_ !~ /^\s*ALTER\s+TABLE\s+(h_|)$tbl\s+DROP\s+COLUMN\s+cf_$name\s*$/i }
+    @statements = grep { $_ !~ /^\s*ALTER\s+TABLE\s+(h_|)$tbl DROP\s+COLUMN\s+cf_$name/i }
                                                                     @statements;
     push @statements, 
         "ALTER TABLE $tbl ADD COLUMN cf_$name varchar(".$cf->{'length'}.")"