liquid_feedback_core
diff core.sql @ 554:3e7ad7233404
Renamed events 'member_removed' and 'suggestion_removed' to 'member_deleted' and 'suggestion_deleted'
author | jbe |
---|---|
date | Sat Sep 16 21:20:38 2017 +0200 (2017-09-16) |
parents | a676d305502f |
children | 5d098bcc631a |
line diff
1.1 --- a/core.sql Sat Sep 16 21:16:16 2017 +0200 1.2 +++ b/core.sql Sat Sep 16 21:20:38 2017 +0200 1.3 @@ -1331,9 +1331,9 @@ 1.4 'initiative_revoked', 1.5 'new_draft_created', 1.6 'suggestion_created', 1.7 - 'suggestion_removed', 1.8 + 'suggestion_deleted', 1.9 'member_activated', 1.10 - 'member_removed', 1.11 + 'member_deleted', 1.12 'member_active', 1.13 'member_name_updated', 1.14 'member_profile_updated', 1.15 @@ -1439,7 +1439,7 @@ 1.16 "text_value" ISNULL AND 1.17 "old_text_value" ISNULL )), 1.18 CONSTRAINT "constr_for_suggestion_removal" CHECK ( 1.19 - "event" != 'suggestion_removed' OR ( 1.20 + "event" != 'suggestion_deleted' OR ( 1.21 "member_id" ISNULL AND 1.22 "other_member_id" ISNULL AND 1.23 "scope" ISNULL AND 1.24 @@ -1458,7 +1458,7 @@ 1.25 CONSTRAINT "constr_for_value_less_member_event" CHECK ( 1.26 "event" NOT IN ( 1.27 'member_activated', 1.28 - 'member_removed', 1.29 + 'member_deleted', 1.30 'member_profile_updated', 1.31 'member_image_updated' 1.32 ) OR ( 1.33 @@ -1728,7 +1728,7 @@ 1.34 --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.35 -- "event_v" := 'unit_created'; 1.36 --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.37 - -- "event_v" := 'unit_removed'; 1.38 + -- "event_v" := 'unit_deleted'; 1.39 ELSIF OLD != NEW THEN 1.40 "event_v" := 'unit_updated'; 1.41 ELSE 1.42 @@ -1761,7 +1761,7 @@ 1.43 --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.44 -- "event_v" := 'area_created'; 1.45 --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.46 - -- "event_v" := 'area_removed'; 1.47 + -- "event_v" := 'area_deleted'; 1.48 ELSIF OLD != NEW THEN 1.49 "event_v" := 'area_updated'; 1.50 ELSE 1.51 @@ -1794,7 +1794,7 @@ 1.52 --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.53 -- "event_v" := 'policy_created'; 1.54 --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.55 - -- "event_v" := 'policy_removed'; 1.56 + -- "event_v" := 'policy_deleted'; 1.57 ELSIF OLD != NEW THEN 1.58 "event_v" := 'policy_updated'; 1.59 ELSE 1.60 @@ -1995,7 +1995,7 @@ 1.61 "unit_id", "area_id", "policy_id", "issue_id", "state", 1.62 "initiative_id", "suggestion_id" 1.63 ) VALUES ( 1.64 - 'suggestion_removed', 1.65 + 'suggestion_deleted', 1.66 "area_row"."unit_id", "issue_row"."area_id", 1.67 "issue_row"."policy_id", 1.68 "initiative_row"."issue_id", "issue_row"."state", 1.69 @@ -2055,7 +2055,7 @@ 1.70 (NEW."activated" ISNULL OR NEW."deleted" NOTNULL) 1.71 THEN 1.72 INSERT INTO "event" ("event", "member_id") 1.73 - VALUES ('member_removed', NEW."id"); 1.74 + VALUES ('member_deleted', NEW."id"); 1.75 END IF; 1.76 END IF; 1.77 RETURN NULL;