summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2013-01-05 13:18:33 +0100
committerYorhel <git@yorhel.nl>2013-01-05 13:18:33 +0100
commit68e04dade4a8bddffb13c09114f9c34867d2077b (patch)
tree7e6776452b421a6bfa8ada4ac96f123d9ffe8cf3 /util
parent5fb01aeb58c77d2abda4e11d72be2217215a0ce5 (diff)
Don't use Multi for processing character images
Diffstat (limited to 'util')
-rw-r--r--util/sql/all.sql2
-rw-r--r--util/sql/func.sql7
-rw-r--r--util/updates/update_2.23.sql3
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();