1.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Thu Mar 31 20:35:10 2016 +0200
     1.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:42:04 2016 +0200
     1.3 @@ -29,62 +29,6 @@
     1.4  CREATE VIEW "updated_initiative" AS
     1.5    SELECT
     1.6      "member"."id" AS "seen_by_member_id",
     1.7 -    CASE WHEN "event"."state" IN (
     1.8 -      'voting',
     1.9 -      'finished_without_winner',
    1.10 -      'finished_with_winner'
    1.11 -    ) THEN
    1.12 -      'voting'::"notify_level"
    1.13 -    ELSE
    1.14 -      CASE WHEN "event"."state" IN (
    1.15 -        'verification',
    1.16 -        'canceled_after_revocation_during_verification',
    1.17 -        'canceled_no_initiative_admitted'
    1.18 -      ) THEN
    1.19 -        'verification'::"notify_level"
    1.20 -      ELSE
    1.21 -        CASE WHEN "event"."state" IN (
    1.22 -          'discussion',
    1.23 -          'canceled_after_revocation_during_discussion'
    1.24 -        ) THEN
    1.25 -          'discussion'::"notify_level"
    1.26 -        ELSE
    1.27 -          'all'::"notify_level"
    1.28 -        END
    1.29 -      END
    1.30 -    END AS "notify_level",
    1.31 -    "event".*
    1.32 -  FROM "member" CROSS JOIN "event"
    1.33 -  LEFT JOIN "issue"
    1.34 -    ON "event"."issue_id" = "issue"."id"
    1.35 -  LEFT JOIN "membership"
    1.36 -    ON "member"."id" = "membership"."member_id"
    1.37 -    AND "issue"."area_id" = "membership"."area_id"
    1.38 -  LEFT JOIN "interest"
    1.39 -    ON "member"."id" = "interest"."member_id"
    1.40 -    AND "event"."issue_id" = "interest"."issue_id"
    1.41 -  LEFT JOIN "ignored_member"
    1.42 -    ON "member"."id" = "ignored_member"."member_id"
    1.43 -    AND "event"."member_id" = "ignored_member"."other_member_id"
    1.44 -  LEFT JOIN "ignored_initiative"
    1.45 -    ON "member"."id" = "ignored_initiative"."member_id"
    1.46 -    AND "event"."initiative_id" = "ignored_initiative"."initiative_id"
    1.47 -  WHERE (
    1.48 -    ( "member"."notify_level" >= 'all' ) OR
    1.49 -    ( "member"."notify_level" >= 'voting' AND
    1.50 -      "event"."state" IN (
    1.51 -        'voting',
    1.52 -        'finished_without_winner',
    1.53 -        'finished_with_winner' ) ) OR
    1.54 -    ( "member"."notify_level" >= 'verification' AND
    1.55 -      "event"."state" IN (
    1.56 -        'verification',
    1.57 -        'canceled_after_revocation_during_verification',
    1.58 -        'canceled_no_initiative_admitted' ) ) OR
    1.59 -    ( "member"."notify_level" >= 'discussion' AND
    1.60 -      "event"."state" IN (
    1.61 -        'discussion',
    1.62 -        'canceled_after_revocation_during_discussion' ) ) )
    1.63      TRUE AS "supported",
    1.64      EXISTS (
    1.65        SELECT NULL FROM "draft"