diff options
author | Ivan Kohler <ivan@freeside.biz> | 2015-07-26 15:41:26 -0700 |
---|---|---|
committer | Ivan Kohler <ivan@freeside.biz> | 2015-07-26 15:41:26 -0700 |
commit | 9aee669886202be7035e6c6049fc71bc99dd3013 (patch) | |
tree | 2fd5bf6de74f3d99270587ffb1833e4188a6373d /rt/etc/upgrade/4.2.7/content | |
parent | ac20214d38d9af00430423f147b5a0e50751b050 (diff) | |
parent | 1add633372bdca3cc7163c2ce48363fed3984437 (diff) |
Merge branch 'master' of git.freeside.biz:/home/git/freeside
Diffstat (limited to 'rt/etc/upgrade/4.2.7/content')
-rw-r--r-- | rt/etc/upgrade/4.2.7/content | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/rt/etc/upgrade/4.2.7/content b/rt/etc/upgrade/4.2.7/content new file mode 100644 index 000000000..e828cc72c --- /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 + }, +); |