# HG changeset patch
# User jbe
# Date 1500373725 -7200
# Node ID 3cde0bb68adf5698080f1c17a9cdeb7d1596054c
# Parent  f46ebb67789882644e8ad7732ed2e4acf34f02a2
Use unit/area/policy_updated event instead of unit/area/policy_removed

diff -r f46ebb677898 -r 3cde0bb68adf core.sql
--- a/core.sql	Tue Jul 18 01:14:45 2017 +0200
+++ b/core.sql	Tue Jul 18 12:28:45 2017 +0200
@@ -1315,13 +1315,10 @@
 CREATE TYPE "event_type" AS ENUM (
         'unit_created',
         'unit_updated',
-        'unit_removed',
         'area_created',
         'area_updated',
-        'area_removed',
         'policy_created',
         'policy_updated',
-        'policy_removed',
         'issue_state_changed',
         'initiative_created_in_new_issue',
         'initiative_created_in_existing_issue',
@@ -1722,10 +1719,10 @@
       IF TG_OP = 'UPDATE' THEN
         IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
           RETURN NULL;
-        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
-          "event_v" := 'unit_created';
-        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
-          "event_v" := 'unit_removed';
+        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
+        --  "event_v" := 'unit_created';
+        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
+        --  "event_v" := 'unit_removed';
         ELSIF OLD != NEW THEN
           "event_v" := 'unit_updated';
         ELSE
@@ -1755,10 +1752,10 @@
       IF TG_OP = 'UPDATE' THEN
         IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
           RETURN NULL;
-        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
-          "event_v" := 'area_created';
-        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
-          "event_v" := 'area_removed';
+        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
+        --  "event_v" := 'area_created';
+        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
+        --  "event_v" := 'area_removed';
         ELSIF OLD != NEW THEN
           "event_v" := 'area_updated';
         ELSE
@@ -1788,10 +1785,10 @@
       IF TG_OP = 'UPDATE' THEN
         IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
           RETURN NULL;
-        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
-          "event_v" := 'policy_created';
-        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
-          "event_v" := 'policy_removed';
+        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
+        --  "event_v" := 'policy_created';
+        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
+        --  "event_v" := 'policy_removed';
         ELSIF OLD != NEW THEN
           "event_v" := 'policy_updated';
         ELSE
diff -r f46ebb677898 -r 3cde0bb68adf update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 01:14:45 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Tue Jul 18 12:28:45 2017 +0200
@@ -1,12 +1,9 @@
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_created';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_updated';
-ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'unit_removed';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_created';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_updated';
-ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'area_removed';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_created';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_updated';
-ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'policy_removed';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'suggestion_removed';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_activated';
 ALTER TYPE "event_type" ADD VALUE IF NOT EXISTS 'member_removed';
@@ -985,10 +982,10 @@
       IF TG_OP = 'UPDATE' THEN
         IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
           RETURN NULL;
-        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
-          "event_v" := 'unit_created';
-        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
-          "event_v" := 'unit_removed';
+        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
+        --  "event_v" := 'unit_created';
+        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
+        --  "event_v" := 'unit_removed';
         ELSIF OLD != NEW THEN
           "event_v" := 'unit_updated';
         ELSE
@@ -1018,10 +1015,10 @@
       IF TG_OP = 'UPDATE' THEN
         IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
           RETURN NULL;
-        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
-          "event_v" := 'area_created';
-        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
-          "event_v" := 'area_removed';
+        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
+        --  "event_v" := 'area_created';
+        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
+        --  "event_v" := 'area_removed';
         ELSIF OLD != NEW THEN
           "event_v" := 'area_updated';
         ELSE
@@ -1051,10 +1048,10 @@
       IF TG_OP = 'UPDATE' THEN
         IF OLD."active" = FALSE AND NEW."active" = FALSE THEN
           RETURN NULL;
-        ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
-          "event_v" := 'policy_created';
-        ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
-          "event_v" := 'policy_removed';
+        --ELSIF OLD."active" = FALSE AND NEW."active" = TRUE THEN
+        --  "event_v" := 'policy_created';
+        --ELSIF OLD."active" = TRUE AND NEW."active" = FALSE THEN
+        --  "event_v" := 'policy_removed';
         ELSIF OLD != NEW THEN
           "event_v" := 'policy_updated';
         ELSE