liquid_feedback_core
diff core-update.beta17-beta18.sql @ 17:1cba764373d6
Version beta18
Bug fixed, which caused issue_voting_started events in timeline to be shown only after an issue had been closed
Bug fixed, which caused issue_voting_started events in timeline to be shown only after an issue had been closed
author | jbe |
---|---|
date | Sat Jan 23 12:00:00 2010 +0100 (2010-01-23) |
parents | |
children |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/core-update.beta17-beta18.sql Sat Jan 23 12:00:00 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;