liquid_feedback_core
diff core.sql @ 129:07cfc7c1ce3f
Bugfix in function "close_voting" related to selection of "area_id" and "unit_id"
Includes update script to v1.4.0_rc2
Includes update script to v1.4.0_rc2
author | jbe |
---|---|
date | Tue May 24 23:13:06 2011 +0200 (2011-05-24) |
parents | 1af27a67ee1a |
children | 284113a50c3b 0fa3c4739ca7 |
line diff
1.1 --- a/core.sql Sun Mar 13 13:29:33 2011 +0100 1.2 +++ b/core.sql Tue May 24 23:13:06 2011 +0200 1.3 @@ -7,7 +7,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('1.4.0_rc1', 1, 4, -1)) 1.8 + SELECT * FROM (VALUES ('1.4.0_rc2', 1, 4, -1)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -3405,8 +3405,8 @@ 1.13 "member_id_v" "member"."id"%TYPE; 1.14 BEGIN 1.15 PERFORM "lock_issue"("issue_id_p"); 1.16 - SELECT "id" INTO "area_id_v" FROM "issue" WHERE "id" = "issue_id_p"; 1.17 - SELECT "id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_v"; 1.18 + SELECT "area_id" INTO "area_id_v" FROM "issue" WHERE "id" = "issue_id_p"; 1.19 + SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_v"; 1.20 DELETE FROM "delegating_voter" 1.21 WHERE "issue_id" = "issue_id_p"; 1.22 DELETE FROM "direct_voter"