summaryrefslogtreecommitdiff
path: root/util/sql/all.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2013-01-05 13:06:18 +0100
committerYorhel <git@yorhel.nl>2013-01-05 13:06:18 +0100
commit5fb01aeb58c77d2abda4e11d72be2217215a0ce5 (patch)
tree5d59608330ebb3879b9183cbe239d356aa13151f /util/sql/all.sql
parenta208fac4225ab8775a57c72eca0f042ee743b7bc (diff)
Don't use Multi for processing VN cover images
I used to do this to avoid loading Image::Magick in each TUWF process, decreasing memory usage, and lowering the blocking time by avoiding too much processing. Memory isn't much of a problem nowadays, and processing images is fast enough, too, so this complexity isn't necessary anymore. (Character images and screenshots pending)
Diffstat (limited to 'util/sql/all.sql')
-rw-r--r--util/sql/all.sql1
1 files changed, 0 insertions, 1 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index 68739776..94e8bf41 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -64,7 +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 vn_rev_image_notify AFTER INSERT OR UPDATE ON vn_rev FOR EACH ROW WHEN (NEW.image < 0) EXECUTE PROCEDURE vn_rev_image_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();