liquid_feedback_core
diff core.sql @ 537:aa261389c993
Stubs for unit/area/policy event triggers
author | jbe |
---|---|
date | Mon Jun 26 16:20:36 2017 +0200 (2017-06-26) |
parents | 750b0be5acb6 |
children | 1bc3dfe5823e |
line diff
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 $$