diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/func.sql | 7 | ||||
-rw-r--r-- | util/updates/update_2.19.sql | 3 |
2 files changed, 10 insertions, 0 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index 23ae0fb2..2b204902 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -560,6 +560,13 @@ $$ 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.19.sql b/util/updates/update_2.19.sql index 0360feda..462e4eed 100644 --- a/util/updates/update_2.19.sql +++ b/util/updates/update_2.19.sql @@ -75,6 +75,8 @@ CREATE TABLE chars_vns ( PRIMARY KEY(cid, vid, rid) ); +CREATE SEQUENCE charimg_seq; + -- allow characters to be versioned using the changes table @@ -86,6 +88,7 @@ DROP TYPE dbentry_type; ALTER TYPE dbentry_type_tmp RENAME TO dbentry_type; CREATE TRIGGER hidlock_update BEFORE UPDATE ON chars FOR EACH ROW WHEN (OLD.latest IS DISTINCT FROM NEW.latest) EXECUTE PROCEDURE update_hidlock(); +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(); -- load the updated functions |