liquid_feedback_core
view update/core-update.v1.2.5-v1.2.6.sql @ 378:e88d0606891f
Bugfix regarding "proportional_order" of suggestions:
Use NULL values explicitly to be sorted last
(includes new suggestions as well as suggestions without any individual rankings)
Use NULL values explicitly to be sorted last
(includes new suggestions as well as suggestions without any individual rankings)
author | jbe |
---|---|
date | Mon Mar 18 09:36:21 2013 +0100 (2013-03-18) |
parents | dcaa1525c388 |
children |
line source
1 BEGIN;
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
4 SELECT * FROM (VALUES ('1.2.6', 1, 2, 6))
5 AS "subquery"("string", "major", "minor", "revision");
7 CREATE VIEW "active_delegation" AS
8 SELECT "delegation".* FROM "delegation"
9 JOIN "member" ON "delegation"."truster_id" = "member"."id"
10 WHERE "member"."active" = TRUE;
12 COMMENT ON VIEW "active_delegation" IS 'Delegations where the truster_id refers to an active member';
14 DROP VIEW "global_delegation";
16 CREATE VIEW "global_delegation" AS
17 SELECT * FROM "active_delegation"
18 WHERE "scope" = 'global';
20 COMMENT ON VIEW "global_delegation" IS 'Global delegations from active members';
22 CREATE OR REPLACE VIEW "area_delegation" AS
23 SELECT DISTINCT ON ("area"."id", "delegation"."truster_id")
24 "area"."id" AS "area_id",
25 "delegation"."id",
26 "delegation"."truster_id",
27 "delegation"."trustee_id",
28 "delegation"."scope"
29 FROM "area" JOIN "active_delegation" AS "delegation"
30 ON "delegation"."scope" = 'global'
31 OR "delegation"."area_id" = "area"."id"
32 ORDER BY
33 "area"."id",
34 "delegation"."truster_id",
35 "delegation"."scope" DESC;
37 COMMENT ON VIEW "area_delegation" IS 'Resulting area delegations from active members';
39 CREATE OR REPLACE VIEW "issue_delegation" AS
40 SELECT DISTINCT ON ("issue"."id", "delegation"."truster_id")
41 "issue"."id" AS "issue_id",
42 "delegation"."id",
43 "delegation"."truster_id",
44 "delegation"."trustee_id",
45 "delegation"."scope"
46 FROM "issue" JOIN "active_delegation" AS "delegation"
47 ON "delegation"."scope" = 'global'
48 OR "delegation"."area_id" = "issue"."area_id"
49 OR "delegation"."issue_id" = "issue"."id"
50 ORDER BY
51 "issue"."id",
52 "delegation"."truster_id",
53 "delegation"."scope" DESC;
55 COMMENT ON VIEW "issue_delegation" IS 'Resulting issue delegations from active members';
57 COMMIT;