diff options
Diffstat (limited to 'util/updates/update_2.6.sql')
-rw-r--r-- | util/updates/update_2.6.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql index e3516e30..28f82420 100644 --- a/util/updates/update_2.6.sql +++ b/util/updates/update_2.6.sql @@ -48,3 +48,16 @@ $$ 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(); + + |