From 9361c958f8c54c63b2878fc651630b3480907a54 Mon Sep 17 00:00:00 2001 From: APTX Date: Mon, 23 Jul 2012 21:53:06 +0200 Subject: [PATCH] Add fix_highest_epno --- localmylist/share/schema/schema.sql | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/localmylist/share/schema/schema.sql b/localmylist/share/schema/schema.sql index 60239fd..0bbfe24 100644 --- a/localmylist/share/schema/schema.sql +++ b/localmylist/share/schema/schema.sql @@ -254,6 +254,15 @@ CREATE RULE update_file_rule AS DO UPDATE file_location fl SET renamed = NULL WHERE fl.fid = old.fid; +CREATE OR REPLACE RULE fix_highest_epno AS + ON INSERT TO episode + WHERE new.epno > (( + SELECT anime.highest_epno + FROM anime + WHERE anime.aid = new.aid)) + DO UPDATE anime SET highest_epno = new.epno + WHERE anime.aid = new.aid; + CREATE RULE config_updated_rule AS ON UPDATE TO config DO NOTIFY config_changed; CREATE RULE file_episode_rel_ignore_duplicate AS ON INSERT TO file_episode_rel WHERE (EXISTS (SELECT 1 FROM file_episode_rel WHERE ((file_episode_rel.fid = new.fid) AND (file_episode_rel.eid = new.eid)))) DO INSTEAD NOTHING; -- 2.52.0