liquid_feedback_core

diff core.sql @ 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
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

Impressum / About Us