liquid_feedback_core
diff update/core-update.v3.2.2-v4.0.0.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 | 85f25c413238 |
children | 5d098bcc631a |
line diff
1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Sat Sep 16 21:16:16 2017 +0200 1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Sat Sep 16 21:20:38 2017 +0200 1.3 @@ -4,9 +4,9 @@ 1.4 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_updated'; 1.5 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_created'; 1.6 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_updated'; 1.7 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'suggestion_removed'; 1.8 +ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'suggestion_deleted'; 1.9 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_activated'; 1.10 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_removed'; 1.11 +ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_deleted'; 1.12 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_active'; 1.13 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_name_updated'; 1.14 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_profile_updated'; 1.15 @@ -784,7 +784,7 @@ 1.16 "text_value" ISNULL AND 1.17 "old_text_value" ISNULL )); 1.18 ALTER TABLE "event" ADD 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 @@ -803,7 +803,7 @@ 1.25 ALTER TABLE "event" ADD 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 @@ -997,7 +997,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 @@ -1030,7 +1030,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 @@ -1063,7 +1063,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 @@ -1236,7 +1236,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 @@ -1296,7 +1296,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;