liquid_feedback_core

diff update/core-update.v3.2.2-v4.0.0.sql @ 547:3cde0bb68adf

find changesets by author, revision, files, or words in the commit message
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
line diff
     1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 01:14:45 2017 +0200
     1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 12:28:45 2017 +0200
     1.3 @@ -1,12 +1,9 @@
     1.4  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_created';
     1.5  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_updated';
     1.6 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_removed';
     1.7  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_created';
     1.8  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_updated';
     1.9 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_removed';
    1.10  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_created';
    1.11  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_updated';
    1.12 -ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_removed';
    1.13  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'suggestion_removed';
    1.14  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_activated';
    1.15  ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_removed';
    1.16 @@ -985,10 +982,10 @@
    1.17        IF TG_OP = 'UPDATE' THEN
    1.18          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.19            RETURN NULL;
    1.20 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.21 -          "event_v" := 'unit_created';
    1.22 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.23 -          "event_v" := 'unit_removed';
    1.24 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.25 +        --  "event_v" := 'unit_created';
    1.26 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.27 +        --  "event_v" := 'unit_removed';
    1.28          ELSIF OLD != NEW THEN
    1.29            "event_v" := 'unit_updated';
    1.30          ELSE
    1.31 @@ -1018,10 +1015,10 @@
    1.32        IF TG_OP = 'UPDATE' THEN
    1.33          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.34            RETURN NULL;
    1.35 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.36 -          "event_v" := 'area_created';
    1.37 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.38 -          "event_v" := 'area_removed';
    1.39 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.40 +        --  "event_v" := 'area_created';
    1.41 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.42 +        --  "event_v" := 'area_removed';
    1.43          ELSIF OLD != NEW THEN
    1.44            "event_v" := 'area_updated';
    1.45          ELSE
    1.46 @@ -1051,10 +1048,10 @@
    1.47        IF TG_OP = 'UPDATE' THEN
    1.48          IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
    1.49            RETURN NULL;
    1.50 -        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.51 -          "event_v" := 'policy_created';
    1.52 -        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.53 -          "event_v" := 'policy_removed';
    1.54 +        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
    1.55 +        --  "event_v" := 'policy_created';
    1.56 +        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
    1.57 +        --  "event_v" := 'policy_removed';
    1.58          ELSIF OLD != NEW THEN
    1.59            "event_v" := 'policy_updated';
    1.60          ELSE

Impressum / About Us