Commits

Anonymous committed 3ea7a72

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

Comments (0)

Files changed (1)

 BEGIN;
 
 CREATE VIEW "liquid_feedback_version" AS
-  SELECT * FROM (VALUES ('beta6', NULL, NULL, NULL))
+  SELECT * FROM (VALUES ('beta7', NULL, NULL, NULL))
   AS "subquery"("string", "major", "minor", "revision");
 
 
         "active"                BOOLEAN         NOT NULL DEFAULT TRUE,
         "admin"                 BOOLEAN         NOT NULL DEFAULT FALSE,
         "name"                  TEXT,
-        "ident_number"          TEXT            UNIQUE );
+        "ident_number"          TEXT            UNIQUE,
+        "avatar"                BYTEA );
 CREATE INDEX "member_active_idx" ON "member" ("active");
 
 COMMENT ON TABLE "member" IS 'Users of the system, e.g. members of an organization';
         "voter_count" = (
           SELECT coalesce(sum("weight"), 0)
           FROM "direct_voter" WHERE "issue_id" = "issue_id_p"
-        );
+        )
+        WHERE "id" = "issue_id_p";
       UPDATE "initiative" SET
         "positive_votes" = "subquery"."positive_votes",
         "negative_votes" = "subquery"."negative_votes"