diff options
Diffstat (limited to 'util/updates/update_2.22.sql')
-rw-r--r-- | util/updates/update_2.22.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/util/updates/update_2.22.sql b/util/updates/update_2.22.sql new file mode 100644 index 00000000..3268481e --- /dev/null +++ b/util/updates/update_2.22.sql @@ -0,0 +1,11 @@ + + +DROP TRIGGER vn_vnsearch_notify ON vn; + +CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON vn FOR EACH ROW + WHEN (OLD.c_search IS NOT NULL AND NEW.c_search IS NULL + OR NEW.latest IS DISTINCT FROM OLD.latest + ) EXECUTE PROCEDURE vn_vnsearch_notify(); + +\i util/sql/func.sql + |