summaryrefslogtreecommitdiff
path: root/util/sql/all.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2013-01-05 13:30:35 +0100
committerYorhel <git@yorhel.nl>2013-01-05 13:30:35 +0100
commitba2c13150debd75c1cbf1a20950eb44ad6a30f86 (patch)
treed068b931b2c42f6dec54130cd6622c84445a87b5 /util/sql/all.sql
parent68e04dade4a8bddffb13c09114f9c34867d2077b (diff)
Don't use Multi for processing screenshots
TODO: Get rid of the 'processing' flag and all the async loading of screenshot data in the screenshot uploader.
Diffstat (limited to 'util/sql/all.sql')
-rw-r--r--util/sql/all.sql2
1 files changed, 0 insertions, 2 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index bb5359d6..d012a492 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 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
WHEN (OLD.rgraph IS DISTINCT FROM NEW.rgraph
OR OLD.latest IS DISTINCT FROM NEW.latest