RT 4.2.11, ticket#13852

[freeside.git] / rt / etc / upgrade / 4.2.7 / content

diff --git a/rt/etc/upgrade/4.2.7/content b/rt/etc/upgrade/4.2.7/content
new file mode 100644 (file)
index 0000000..e828cc7
--- /dev/null
+++ b/rt/etc/upgrade/4.2.7/content
@@ -0,0 +1,15 @@
+use strict;
+use warnings;
+
+our @Initial = (
+    sub {
+        # We do the delete in pure SQL because Attribute collections
+        # otherwise attempt to hash everything in memory.  As this may
+        # be a large list, do it directly.
+        RT->DatabaseHandle->dbh->do(<<EOSQL);
+            DELETE FROM Attributes
+             WHERE (Name = 'LinkValueTo' OR Name = 'IncludeContentForValue')
+               AND (LENGTH(Content) = 0 OR Content IS NULL)
+EOSQL
+    },
+);