chardb: Added image to character entries

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