1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/core-update.beta17-beta18.sql	Sat Feb 06 03:37:55 2010 +0100
     1.3 @@ -0,0 +1,50 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('beta18', NULL, NULL, NULL))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +CREATE OR REPLACE VIEW "timeline_issue" AS
    1.11 +    SELECT
    1.12 +      "created" AS "occurrence",
    1.13 +      'issue_created'::"timeline_event" AS "event",
    1.14 +      "id" AS "issue_id"
    1.15 +    FROM "issue"
    1.16 +  UNION ALL
    1.17 +    SELECT
    1.18 +      "closed" AS "occurrence",
    1.19 +      'issue_canceled'::"timeline_event" AS "event",
    1.20 +      "id" AS "issue_id"
    1.21 +    FROM "issue" WHERE "closed" NOTNULL AND "fully_frozen" ISNULL
    1.22 +  UNION ALL
    1.23 +    SELECT
    1.24 +      "accepted" AS "occurrence",
    1.25 +      'issue_accepted'::"timeline_event" AS "event",
    1.26 +      "id" AS "issue_id"
    1.27 +    FROM "issue" WHERE "accepted" NOTNULL
    1.28 +  UNION ALL
    1.29 +    SELECT
    1.30 +      "half_frozen" AS "occurrence",
    1.31 +      'issue_half_frozen'::"timeline_event" AS "event",
    1.32 +      "id" AS "issue_id"
    1.33 +    FROM "issue" WHERE "half_frozen" NOTNULL
    1.34 +  UNION ALL
    1.35 +    SELECT
    1.36 +      "fully_frozen" AS "occurrence",
    1.37 +      'issue_voting_started'::"timeline_event" AS "event",
    1.38 +      "id" AS "issue_id"
    1.39 +    FROM "issue"
    1.40 +    WHERE "fully_frozen" NOTNULL
    1.41 +    AND ("closed" ISNULL OR "closed" != "fully_frozen")
    1.42 +  UNION ALL
    1.43 +    SELECT
    1.44 +      "closed" AS "occurrence",
    1.45 +      CASE WHEN "fully_frozen" = "closed" THEN
    1.46 +        'issue_finished_without_voting'::"timeline_event"
    1.47 +      ELSE
    1.48 +        'issue_finished_after_voting'::"timeline_event"
    1.49 +      END AS "event",
    1.50 +      "id" AS "issue_id"
    1.51 +    FROM "issue" WHERE "closed" NOTNULL AND "fully_frozen" NOTNULL;
    1.52 +
    1.53 +COMMIT;