From a796407a552fb5422a81a4cf8a5029d1f39bf419 Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Mon, 14 Feb 2011 12:41:51 +0100
Subject: chardb: Made Multi aware of traits

Added new trait notify and i+ id-matching
---
 util/sql/func.sql            | 4 +++-
 util/updates/update_2.19.sql | 5 +++++
 2 files changed, 8 insertions(+), 1 deletion(-)

(limited to 'util')

diff --git a/util/sql/func.sql b/util/sql/func.sql
index d7b5ab2f..74f08147 100644
--- a/util/sql/func.sql
+++ b/util/sql/func.sql
@@ -590,7 +590,7 @@ $$ LANGUAGE plpgsql;
 
 
 
--- NOTIFY on insert into changes/posts/tags
+-- NOTIFY on insert into changes/posts/tags/trait
 CREATE OR REPLACE FUNCTION insert_notify() RETURNS trigger AS $$
 BEGIN
   IF TG_TABLE_NAME = 'changes' THEN
@@ -599,6 +599,8 @@ BEGIN
     NOTIFY newpost;
   ELSIF TG_TABLE_NAME = 'tags' THEN
     NOTIFY newtag;
+  ELSIF TG_TABLE_NAME = 'traits' THEN
+    NOTIFY newtrait;
   END IF;
   RETURN NULL;
 END;
diff --git a/util/updates/update_2.19.sql b/util/updates/update_2.19.sql
index 9819f685..4bb7f547 100644
--- a/util/updates/update_2.19.sql
+++ b/util/updates/update_2.19.sql
@@ -24,3 +24,8 @@ CREATE TABLE traits_parents (
   PRIMARY KEY(trait, parent)
 );
 
+\i util/sql/func.sql
+
+CREATE TRIGGER insert_notify              AFTER  INSERT           ON traits        FOR EACH STATEMENT EXECUTE PROCEDURE insert_notify();
+
+
-- 
cgit v1.2.3