# HG changeset patch
# User jbe
# Date 1498486836 -7200
# Node ID aa261389c993ab1e7a74072be01a195df0963a73
# Parent  750b0be5acb6102eb25f4cffba8f22ba2ea473fb
Stubs for unit/area/policy event triggers

diff -r 750b0be5acb6 -r aa261389c993 core.sql
--- a/core.sql	Mon Jun 26 15:54:26 2017 +0200
+++ b/core.sql	Mon Jun 26 16:20:36 2017 +0200
@@ -1782,6 +1782,51 @@
 COMMENT ON TRIGGER "write_member_history" ON "member" IS 'When changing certain fields of a member, create a history entry in "member_history" table';
 
 
+CREATE FUNCTION "write_event_unit_trigger"()
+  RETURNS TRIGGER
+  LANGUAGE 'plpgsql' VOLATILE AS $$
+    BEGIN
+      RETURN NULL;
+    END;
+  $$;
+
+CREATE TRIGGER "write_event_unit" AFTER INSERT OR UPDATE ON "unit"
+  FOR EACH ROW EXECUTE PROCEDURE "write_event_unit_trigger"();
+
+COMMENT ON FUNCTION "write_event_unit_trigger"() IS 'Implementation of trigger "write_event_unit" on table "unit"';
+COMMENT ON TRIGGER "write_event_unit" ON "unit"  IS 'Create entry in "event" table on new or changed/disabled units';
+
+
+CREATE FUNCTION "write_event_area_trigger"()
+  RETURNS TRIGGER
+  LANGUAGE 'plpgsql' VOLATILE AS $$
+    BEGIN
+      RETURN NULL;
+    END;
+  $$;
+
+CREATE TRIGGER "write_event_area" AFTER INSERT OR UPDATE ON "area"
+  FOR EACH ROW EXECUTE PROCEDURE "write_event_area_trigger"();
+
+COMMENT ON FUNCTION "write_event_area_trigger"() IS 'Implementation of trigger "write_event_area" on table "area"';
+COMMENT ON TRIGGER "write_event_area" ON "area"  IS 'Create entry in "event" table on new or changed/disabled areas';
+
+
+CREATE FUNCTION "write_event_policy_trigger"()
+  RETURNS TRIGGER
+  LANGUAGE 'plpgsql' VOLATILE AS $$
+    BEGIN
+      RETURN NULL;
+    END;
+  $$;
+
+CREATE TRIGGER "write_event_policy" AFTER INSERT OR UPDATE ON "policy"
+  FOR EACH ROW EXECUTE PROCEDURE "write_event_policy_trigger"();
+
+COMMENT ON FUNCTION "write_event_policy_trigger"()  IS 'Implementation of trigger "write_event_policy" on table "policy"';
+COMMENT ON TRIGGER "write_event_policy" ON "policy" IS 'Create entry in "event" table on new or changed/disabled policies';
+
+
 CREATE FUNCTION "write_event_issue_state_changed_trigger"()
   RETURNS TRIGGER
   LANGUAGE 'plpgsql' VOLATILE AS $$
diff -r 750b0be5acb6 -r aa261389c993 update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Jun 26 15:54:26 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Jun 26 16:20:36 2017 +0200
@@ -941,6 +941,51 @@
 COMMENT ON INDEX "event_processed_singleton_idx" IS 'This index ensures that "event_processed" only contains one row maximum.';
 
 
+CREATE FUNCTION "write_event_unit_trigger"()
+  RETURNS TRIGGER
+  LANGUAGE 'plpgsql' VOLATILE AS $$
+    BEGIN
+      RETURN NULL;
+    END;
+  $$;
+
+CREATE TRIGGER "write_event_unit" AFTER INSERT OR UPDATE ON "unit"
+  FOR EACH ROW EXECUTE PROCEDURE "write_event_unit_trigger"();
+
+COMMENT ON FUNCTION "write_event_unit_trigger"() IS 'Implementation of trigger "write_event_unit" on table "unit"';
+COMMENT ON TRIGGER "write_event_unit" ON "unit"  IS 'Create entry in "event" table on new or changed/disabled units';
+
+
+CREATE FUNCTION "write_event_area_trigger"()
+  RETURNS TRIGGER
+  LANGUAGE 'plpgsql' VOLATILE AS $$
+    BEGIN
+      RETURN NULL;
+    END;
+  $$;
+
+CREATE TRIGGER "write_event_area" AFTER INSERT OR UPDATE ON "area"
+  FOR EACH ROW EXECUTE PROCEDURE "write_event_area_trigger"();
+
+COMMENT ON FUNCTION "write_event_area_trigger"() IS 'Implementation of trigger "write_event_area" on table "area"';
+COMMENT ON TRIGGER "write_event_area" ON "area"  IS 'Create entry in "event" table on new or changed/disabled areas';
+
+
+CREATE FUNCTION "write_event_policy_trigger"()
+  RETURNS TRIGGER
+  LANGUAGE 'plpgsql' VOLATILE AS $$
+    BEGIN
+      RETURN NULL;
+    END;
+  $$;
+
+CREATE TRIGGER "write_event_policy" AFTER INSERT OR UPDATE ON "policy"
+  FOR EACH ROW EXECUTE PROCEDURE "write_event_policy_trigger"();
+
+COMMENT ON FUNCTION "write_event_policy_trigger"()  IS 'Implementation of trigger "write_event_policy" on table "policy"';
+COMMENT ON TRIGGER "write_event_policy" ON "policy" IS 'Create entry in "event" table on new or changed/disabled policies';
+
+
 CREATE OR REPLACE FUNCTION "write_event_issue_state_changed_trigger"()
   RETURNS TRIGGER
   LANGUAGE 'plpgsql' VOLATILE AS $$