liquid_feedback_core
changeset 6:3ea7a72ed7e7 beta7
Version beta7
Fixed bug in function close_voting(...) leading to wrong voter_count values in issue table
Added avatar column to member table for storing a small picture of the member
Fixed bug in function close_voting(...) leading to wrong voter_count values in issue table
Added avatar column to member table for storing a small picture of the member
author | jbe |
---|---|
date | Wed Nov 18 12:00:00 2009 +0100 (2009-11-18) |
parents | 1cbdd3975a61 |
children | 69d84040fb93 |
files | core.sql |
line diff
1.1 --- a/core.sql Tue Nov 17 12:00:00 2009 +0100 1.2 +++ b/core.sql Wed Nov 18 12:00:00 2009 +0100 1.3 @@ -6,7 +6,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('beta6', NULL, NULL, NULL)) 1.8 + SELECT * FROM (VALUES ('beta7', NULL, NULL, NULL)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -23,7 +23,8 @@ 1.13 "active" BOOLEAN NOT NULL DEFAULT TRUE, 1.14 "admin" BOOLEAN NOT NULL DEFAULT FALSE, 1.15 "name" TEXT, 1.16 - "ident_number" TEXT UNIQUE ); 1.17 + "ident_number" TEXT UNIQUE, 1.18 + "avatar" BYTEA ); 1.19 CREATE INDEX "member_active_idx" ON "member" ("active"); 1.20 1.21 COMMENT ON TABLE "member" IS 'Users of the system, e.g. members of an organization'; 1.22 @@ -2041,7 +2042,8 @@ 1.23 "voter_count" = ( 1.24 SELECT coalesce(sum("weight"), 0) 1.25 FROM "direct_voter" WHERE "issue_id" = "issue_id_p" 1.26 - ); 1.27 + ) 1.28 + WHERE "id" = "issue_id_p"; 1.29 UPDATE "initiative" SET 1.30 "positive_votes" = "subquery"."positive_votes", 1.31 "negative_votes" = "subquery"."negative_votes"