From 49a2516e6b076667e163aaff2ae2e94ed52fa083 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Wed, 16 Feb 2011 19:24:13 +0100
Subject: chardb: Added image to character entries

---
 util/sql/func.sql            | 7 +++++++
 util/updates/update_2.19.sql | 3 +++
 2 files changed, 10 insertions(+)

(limited to 'util')

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
-- 
cgit v1.2.3