summaryrefslogtreecommitdiff
path: root/util/sql/all.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/sql/all.sql')
-rw-r--r--util/sql/all.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index eac8d58a..bb5829f7 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -104,8 +104,7 @@ CREATE TRIGGER notify_dbedit AFTER UPDATE ON chars
CREATE TRIGGER notify_announce AFTER INSERT ON threads_posts FOR EACH ROW WHEN (NEW.num = 1) EXECUTE PROCEDURE notify_announce();
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 AND NOT NEW.hidden
- OR NEW.hidden IS DISTINCT FROM OLD.hidden
+ 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();
CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON releases FOR EACH ROW