diff options
author | Yorhel <git@yorhel.nl> | 2013-01-05 13:18:33 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2013-01-05 13:18:33 +0100 |
commit | 68e04dade4a8bddffb13c09114f9c34867d2077b (patch) | |
tree | 7e6776452b421a6bfa8ada4ac96f123d9ffe8cf3 /util | |
parent | 5fb01aeb58c77d2abda4e11d72be2217215a0ce5 (diff) |
Don't use Multi for processing character images
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/all.sql | 2 | ||||
-rw-r--r-- | util/sql/func.sql | 7 | ||||
-rw-r--r-- | util/updates/update_2.23.sql | 3 |
3 files changed, 3 insertions, 9 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql index 94e8bf41..bb5359d6 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -64,8 +64,6 @@ CREATE TRIGGER vn_anime_aid_edit BEFORE UPDATE ON vn_anime CREATE TRIGGER anime_fetch_notify AFTER INSERT OR UPDATE ON anime FOR EACH ROW WHEN (NEW.lastfetch IS NULL) EXECUTE PROCEDURE anime_fetch_notify(); -CREATE TRIGGER chars_rev_image_notify AFTER INSERT OR UPDATE ON chars_rev FOR EACH ROW WHEN (NEW.image < 0) EXECUTE PROCEDURE chars_rev_image_notify(); - CREATE TRIGGER screenshot_process_notify AFTER INSERT OR UPDATE ON screenshots FOR EACH ROW WHEN (NEW.processed = FALSE) EXECUTE PROCEDURE screenshot_process_notify(); CREATE TRIGGER vn_relgraph_notify AFTER UPDATE ON vn FOR EACH ROW diff --git a/util/sql/func.sql b/util/sql/func.sql index 261ce9ad..3f52475e 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -603,13 +603,6 @@ $$ LANGUAGE plpgsql; --- Send a notify when a new character image is uploaded -CREATE OR REPLACE FUNCTION chars_rev_image_notify() RETURNS trigger AS $$ - BEGIN NOTIFY charimage; RETURN NULL; END; -$$ LANGUAGE plpgsql; - - - -- Send a notify when a screenshot needs to be processed CREATE OR REPLACE FUNCTION screenshot_process_notify() RETURNS trigger AS $$ BEGIN NOTIFY screenshot; RETURN NULL; END; diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql index 1846593d..305781b6 100644 --- a/util/updates/update_2.23.sql +++ b/util/updates/update_2.23.sql @@ -58,3 +58,6 @@ ALTER TYPE prefs_key ADD VALUE 'vn_list_wish' AFTER 'vn_list_own'; DROP TRIGGER vn_rev_image_notify ON vn_rev; DROP FUNCTION vn_rev_image_notify(); + +DROP TRIGGER chars_rev_image_notify ON chars_rev; +DROP FUNCTION chars_rev_image_notify(); |