liquid_feedback_core

diff core.sql @ 248:05eb08f56f09
Bugfix in view "unit_member_count"
author: jbe
date: Sat May 12 18:33:56 2012 +0200 (2012-05-12)
parents: 4b8cc6fc2d00
children: 7b8966b801e5
     1.1 --- a/core.sql	Fri May 11 17:08:55 2012 +0200
     1.2 +++ b/core.sql	Sat May 12 18:33:56 2012 +0200
     1.3 @@ -1888,7 +1888,7 @@
     1.4  CREATE VIEW "unit_member_count" AS
     1.5    SELECT
     1.6      "unit"."id" AS "unit_id",
     1.7 -    sum("member"."id") AS "member_count"
     1.8 +    count("member"."id") AS "member_count"
     1.9    FROM "unit"
    1.10    LEFT JOIN "privilege"
    1.11    ON "privilege"."unit_id" = "unit"."id"