projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
RT# 81596 - fixed freeside-upgrade to not drop custom fields
[freeside.git]
/
FS
/
bin
/
freeside-upgrade
diff --git
a/FS/bin/freeside-upgrade
b/FS/bin/freeside-upgrade
index
c5df06d
..
0df3884
100755
(executable)
--- 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;
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'}.")"
@statements;
push @statements,
"ALTER TABLE $tbl ADD COLUMN cf_$name varchar(".$cf->{'length'}.")"