Merge branch 'master' of git.freeside.biz:/home/git/freeside

1 files changed, 16 insertions, 0 deletions

diff --git a/rt/etc/upgrade/4.2.8/content b/rt/etc/upgrade/4.2.8/content
new file mode 100644
index 000000000..64b61def7
--- /dev/null
+++ b/rt/etc/upgrade/4.2.8/content
@@ -0,0 +1,16 @@
+use strict;
+use warnings;
+
+our @Initial = (
+    sub {
+        # This upgrade step is identical to the 4.2.7 upgrade, but only
+        # runs on Oracle because 4.2.7 was originally released with
+        # flawed SQL which did not run on Oracle.
+        return unless RT->Config->Get('DatabaseType') eq 'Oracle';
+        RT->DatabaseHandle->dbh->do(<<EOSQL);
+            DELETE FROM Attributes
+             WHERE (Name = 'LinkValueTo' OR Name = 'IncludeContentForValue')
+               AND (LENGTH(Content) = 0 OR Content IS NULL)
+EOSQL
+    },
+);