liquid_feedback_core
changeset 186:969ce2bea98c
Bugfixes in core-update.v1.4.0-v1.5.0.sql
author | jbe |
---|---|
date | Sat Jul 30 01:54:31 2011 +0200 (2011-07-30) |
parents | b0b7e0b18d78 |
children | aaf5f62b1aa2 |
files | update/core-update.v1.4.0-v1.5.0.sql |
line diff
1.1 --- a/update/core-update.v1.4.0-v1.5.0.sql Fri Jul 29 20:59:23 2011 +0200 1.2 +++ b/update/core-update.v1.4.0-v1.5.0.sql Sat Jul 30 01:54:31 2011 +0200 1.3 @@ -16,6 +16,7 @@ 1.4 1.5 COMMENT ON COLUMN "member"."created" IS 'Creation of member record and/or invite code'; 1.6 COMMENT ON COLUMN "member"."invite_code" IS 'Optional invite code, to allow a member to initialize his/her account the first time'; 1.7 +COMMENT ON COLUMN "member"."admin_comment" IS 'Hidden comment for administrative purposes'; 1.8 COMMENT ON COLUMN "member"."activated" IS 'Timestamp of activation of account (i.e. usage of "invite_code"); required to be set for "active" members'; 1.9 COMMENT ON COLUMN "member"."last_activity" IS 'Date of last activity of member; required to be set for "active" members'; 1.10 COMMENT ON COLUMN "member"."active" IS 'Memberships, support and votes are taken into account when corresponding members are marked as active. Automatically set to FALSE, if "last_activity" is older than "system_setting"."member_ttl".'; 1.11 @@ -171,8 +172,6 @@ 1.12 CREATE UNIQUE INDEX "battle_null_losing_idx" ON "battle" ("issue_id", "losing_initiative_id") WHERE "winning_initiative_id" ISNULL; 1.13 1.14 ALTER TABLE "suggestion" ADD COLUMN "draft_id" INT8; 1.15 --- more later 1.16 - 1.17 ALTER TABLE "suggestion" ADD FOREIGN KEY ("initiative_id", "draft_id") REFERENCES "draft" ("initiative_id", "id") ON DELETE NO ACTION ON UPDATE CASCADE; 1.18 ALTER TABLE "suggestion" ADD COLUMN "formatting_engine" TEXT; 1.19 ALTER TABLE "suggestion" RENAME COLUMN "description" TO "content"; 1.20 @@ -1249,7 +1248,7 @@ 1.21 FROM ( 1.22 SELECT 1.23 "issue"."id" AS "issue_id", 1.24 - COALESCE(max("initiative"."rank") + 1) AS "rank" 1.25 + COALESCE(max("initiative"."rank") + 1, 1) AS "rank" 1.26 FROM "issue" JOIN "initiative" 1.27 ON "issue"."id" = "initiative"."issue_id" 1.28 WHERE "issue"."state" IN ('finished_without_winner', 'finished_with_winner')