1 files changed, 15 insertions, 0 deletions
diff --git a/util/dump.sql b/util/dump.sql
index 40347df8..6c08b1b4 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -700,6 +700,21 @@ $$ LANGUAGE plpgsql;
 CREATE TRIGGER vn_anime_aid BEFORE INSERT OR UPDATE ON vn_anime FOR EACH ROW EXECUTE PROCEDURE vn_anime_aid();
 
 
+-- Send a notify whenever anime info should be fetched
+CREATE OR REPLACE FUNCTION anime_fetch_notify() RETURNS trigger AS $$
+BEGIN
+  IF NEW.lastfetch IS NULL THEN
+    NOTIFY anime;
+  END IF;
+  RETURN NULL;
+END;
+$$ LANGUAGE plpgsql;
+
+CREATE TRIGGER anime_fetch_notify AFTER INSERT OR UPDATE ON anime FOR EACH ROW EXECUTE PROCEDURE anime_fetch_notify();
+
+
+
+