1.1 --- a/core.sql	Mon Jun 26 15:54:26 2017 +0200
     1.2 +++ b/core.sql	Mon Jun 26 16:20:36 2017 +0200
     1.3 @@ -1782,6 +1782,51 @@
     1.4  COMMENT ON TRIGGER "write_member_history" ON "member" IS 'When changing certain fields of a member, create a history entry in "member_history" table';
     1.5  
     1.6  
     1.7 +CREATE FUNCTION "write_event_unit_trigger"()
     1.8 +  RETURNS TRIGGER
     1.9 +  LANGUAGE 'plpgsql' VOLATILE AS $$
    1.10 +    BEGIN
    1.11 +      RETURN NULL;
    1.12 +    END;
    1.13 +  $$;
    1.14 +
    1.15 +CREATE TRIGGER "write_event_unit" AFTER INSERT OR UPDATE ON "unit"
    1.16 +  FOR EACH ROW EXECUTE PROCEDURE "write_event_unit_trigger"();
    1.17 +
    1.18 +COMMENT ON FUNCTION "write_event_unit_trigger"() IS 'Implementation of trigger "write_event_unit" on table "unit"';
    1.19 +COMMENT ON TRIGGER "write_event_unit" ON "unit"  IS 'Create entry in "event" table on new or changed/disabled units';
    1.20 +
    1.21 +
    1.22 +CREATE FUNCTION "write_event_area_trigger"()
    1.23 +  RETURNS TRIGGER
    1.24 +  LANGUAGE 'plpgsql' VOLATILE AS $$
    1.25 +    BEGIN
    1.26 +      RETURN NULL;
    1.27 +    END;
    1.28 +  $$;
    1.29 +
    1.30 +CREATE TRIGGER "write_event_area" AFTER INSERT OR UPDATE ON "area"
    1.31 +  FOR EACH ROW EXECUTE PROCEDURE "write_event_area_trigger"();
    1.32 +
    1.33 +COMMENT ON FUNCTION "write_event_area_trigger"() IS 'Implementation of trigger "write_event_area" on table "area"';
    1.34 +COMMENT ON TRIGGER "write_event_area" ON "area"  IS 'Create entry in "event" table on new or changed/disabled areas';
    1.35 +
    1.36 +
    1.37 +CREATE FUNCTION "write_event_policy_trigger"()
    1.38 +  RETURNS TRIGGER
    1.39 +  LANGUAGE 'plpgsql' VOLATILE AS $$
    1.40 +    BEGIN
    1.41 +      RETURN NULL;
    1.42 +    END;
    1.43 +  $$;
    1.44 +
    1.45 +CREATE TRIGGER "write_event_policy" AFTER INSERT OR UPDATE ON "policy"
    1.46 +  FOR EACH ROW EXECUTE PROCEDURE "write_event_policy_trigger"();
    1.47 +
    1.48 +COMMENT ON FUNCTION "write_event_policy_trigger"()  IS 'Implementation of trigger "write_event_policy" on table "policy"';
    1.49 +COMMENT ON TRIGGER "write_event_policy" ON "policy" IS 'Create entry in "event" table on new or changed/disabled policies';
    1.50 +
    1.51 +
    1.52  CREATE FUNCTION "write_event_issue_state_changed_trigger"()
    1.53    RETURNS TRIGGER
    1.54    LANGUAGE 'plpgsql' VOLATILE AS $$

     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Jun 26 15:54:26 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Jun 26 16:20:36 2017 +0200
     2.3 @@ -941,6 +941,51 @@
     2.4  COMMENT ON INDEX "event_processed_singleton_idx" IS 'This index ensures that "event_processed" only contains one row maximum.';
     2.5  
     2.6  
     2.7 +CREATE FUNCTION "write_event_unit_trigger"()
     2.8 +  RETURNS TRIGGER
     2.9 +  LANGUAGE 'plpgsql' VOLATILE AS $$
    2.10 +    BEGIN
    2.11 +      RETURN NULL;
    2.12 +    END;
    2.13 +  $$;
    2.14 +
    2.15 +CREATE TRIGGER "write_event_unit" AFTER INSERT OR UPDATE ON "unit"
    2.16 +  FOR EACH ROW EXECUTE PROCEDURE "write_event_unit_trigger"();
    2.17 +
    2.18 +COMMENT ON FUNCTION "write_event_unit_trigger"() IS 'Implementation of trigger "write_event_unit" on table "unit"';
    2.19 +COMMENT ON TRIGGER "write_event_unit" ON "unit"  IS 'Create entry in "event" table on new or changed/disabled units';
    2.20 +
    2.21 +
    2.22 +CREATE FUNCTION "write_event_area_trigger"()
    2.23 +  RETURNS TRIGGER
    2.24 +  LANGUAGE 'plpgsql' VOLATILE AS $$
    2.25 +    BEGIN
    2.26 +      RETURN NULL;
    2.27 +    END;
    2.28 +  $$;
    2.29 +
    2.30 +CREATE TRIGGER "write_event_area" AFTER INSERT OR UPDATE ON "area"
    2.31 +  FOR EACH ROW EXECUTE PROCEDURE "write_event_area_trigger"();
    2.32 +
    2.33 +COMMENT ON FUNCTION "write_event_area_trigger"() IS 'Implementation of trigger "write_event_area" on table "area"';
    2.34 +COMMENT ON TRIGGER "write_event_area" ON "area"  IS 'Create entry in "event" table on new or changed/disabled areas';
    2.35 +
    2.36 +
    2.37 +CREATE FUNCTION "write_event_policy_trigger"()
    2.38 +  RETURNS TRIGGER
    2.39 +  LANGUAGE 'plpgsql' VOLATILE AS $$
    2.40 +    BEGIN
    2.41 +      RETURN NULL;
    2.42 +    END;
    2.43 +  $$;
    2.44 +
    2.45 +CREATE TRIGGER "write_event_policy" AFTER INSERT OR UPDATE ON "policy"
    2.46 +  FOR EACH ROW EXECUTE PROCEDURE "write_event_policy_trigger"();
    2.47 +
    2.48 +COMMENT ON FUNCTION "write_event_policy_trigger"()  IS 'Implementation of trigger "write_event_policy" on table "policy"';
    2.49 +COMMENT ON TRIGGER "write_event_policy" ON "policy" IS 'Create entry in "event" table on new or changed/disabled policies';
    2.50 +
    2.51 +
    2.52  CREATE OR REPLACE FUNCTION "write_event_issue_state_changed_trigger"()
    2.53    RETURNS TRIGGER
    2.54    LANGUAGE 'plpgsql' VOLATILE AS $$