liquid_feedback_core
changeset 547:3cde0bb68adf
Use unit/area/policy_updated event instead of unit/area/policy_removed
author | jbe |
---|---|
date | Tue Jul 18 12:28:45 2017 +0200 (2017-07-18) |
parents | f46ebb677898 |
children | 1adb0ad5900c |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Tue Jul 18 01:14:45 2017 +0200 1.2 +++ b/core.sql Tue Jul 18 12:28:45 2017 +0200 1.3 @@ -1315,13 +1315,10 @@ 1.4 CREATE TYPE "event_type" AS ENUM ( 1.5 'unit_created', 1.6 'unit_updated', 1.7 - 'unit_removed', 1.8 'area_created', 1.9 'area_updated', 1.10 - 'area_removed', 1.11 'policy_created', 1.12 'policy_updated', 1.13 - 'policy_removed', 1.14 'issue_state_changed', 1.15 'initiative_created_in_new_issue', 1.16 'initiative_created_in_existing_issue', 1.17 @@ -1722,10 +1719,10 @@ 1.18 IF TG_OP = 'UPDATE' THEN 1.19 IF OLD."active" = FALSE AND NEW."active" = FALSE THEN 1.20 RETURN NULL; 1.21 - ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.22 - "event_v" := 'unit_created'; 1.23 - ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.24 - "event_v" := 'unit_removed'; 1.25 + --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.26 + -- "event_v" := 'unit_created'; 1.27 + --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.28 + -- "event_v" := 'unit_removed'; 1.29 ELSIF OLD != NEW THEN 1.30 "event_v" := 'unit_updated'; 1.31 ELSE 1.32 @@ -1755,10 +1752,10 @@ 1.33 IF TG_OP = 'UPDATE' THEN 1.34 IF OLD."active" = FALSE AND NEW."active" = FALSE THEN 1.35 RETURN NULL; 1.36 - ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.37 - "event_v" := 'area_created'; 1.38 - ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.39 - "event_v" := 'area_removed'; 1.40 + --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.41 + -- "event_v" := 'area_created'; 1.42 + --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.43 + -- "event_v" := 'area_removed'; 1.44 ELSIF OLD != NEW THEN 1.45 "event_v" := 'area_updated'; 1.46 ELSE 1.47 @@ -1788,10 +1785,10 @@ 1.48 IF TG_OP = 'UPDATE' THEN 1.49 IF OLD."active" = FALSE AND NEW."active" = FALSE THEN 1.50 RETURN NULL; 1.51 - ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.52 - "event_v" := 'policy_created'; 1.53 - ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.54 - "event_v" := 'policy_removed'; 1.55 + --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 1.56 + -- "event_v" := 'policy_created'; 1.57 + --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 1.58 + -- "event_v" := 'policy_removed'; 1.59 ELSIF OLD != NEW THEN 1.60 "event_v" := 'policy_updated'; 1.61 ELSE
2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Tue Jul 18 01:14:45 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Tue Jul 18 12:28:45 2017 +0200 2.3 @@ -1,12 +1,9 @@ 2.4 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_created'; 2.5 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_updated'; 2.6 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_removed'; 2.7 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_created'; 2.8 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_updated'; 2.9 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_removed'; 2.10 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_created'; 2.11 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_updated'; 2.12 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_removed'; 2.13 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'suggestion_removed'; 2.14 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_activated'; 2.15 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_removed'; 2.16 @@ -985,10 +982,10 @@ 2.17 IF TG_OP = 'UPDATE' THEN 2.18 IF OLD."active" = FALSE AND NEW."active" = FALSE THEN 2.19 RETURN NULL; 2.20 - ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 2.21 - "event_v" := 'unit_created'; 2.22 - ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 2.23 - "event_v" := 'unit_removed'; 2.24 + --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 2.25 + -- "event_v" := 'unit_created'; 2.26 + --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 2.27 + -- "event_v" := 'unit_removed'; 2.28 ELSIF OLD != NEW THEN 2.29 "event_v" := 'unit_updated'; 2.30 ELSE 2.31 @@ -1018,10 +1015,10 @@ 2.32 IF TG_OP = 'UPDATE' THEN 2.33 IF OLD."active" = FALSE AND NEW."active" = FALSE THEN 2.34 RETURN NULL; 2.35 - ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 2.36 - "event_v" := 'area_created'; 2.37 - ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 2.38 - "event_v" := 'area_removed'; 2.39 + --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 2.40 + -- "event_v" := 'area_created'; 2.41 + --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 2.42 + -- "event_v" := 'area_removed'; 2.43 ELSIF OLD != NEW THEN 2.44 "event_v" := 'area_updated'; 2.45 ELSE 2.46 @@ -1051,10 +1048,10 @@ 2.47 IF TG_OP = 'UPDATE' THEN 2.48 IF OLD."active" = FALSE AND NEW."active" = FALSE THEN 2.49 RETURN NULL; 2.50 - ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 2.51 - "event_v" := 'policy_created'; 2.52 - ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 2.53 - "event_v" := 'policy_removed'; 2.54 + --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN 2.55 + -- "event_v" := 'policy_created'; 2.56 + --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN 2.57 + -- "event_v" := 'policy_removed'; 2.58 ELSIF OLD != NEW THEN 2.59 "event_v" := 'policy_updated'; 2.60 ELSE