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
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"

Impressum / About Us