liquid_feedback_core
diff update/core-update.beta21-beta22.sql @ 34:9970f73c1140
Bugfix: Added missing states in "valid_state" constraint of table "issue"
author | jbe |
---|---|
date | Sun Feb 21 16:52:41 2010 +0100 (2010-02-21) |
parents | |
children |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/update/core-update.beta21-beta22.sql Sun Feb 21 16:52:41 2010 +0100 1.3 @@ -0,0 +1,16 @@ 1.4 +BEGIN; 1.5 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS 1.6 + SELECT * FROM (VALUES ('beta22', NULL, NULL, NULL)) 1.7 + AS "subquery"("string", "major", "minor", "revision"); 1.8 +ALTER TABLE "issue" DROP CONSTRAINT "valid_state"; 1.9 +ALTER TABLE "issue" ADD CONSTRAINT "valid_state" CHECK ( 1.10 + ("accepted" ISNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR 1.11 + ("accepted" ISNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR 1.12 + ("accepted" NOTNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR 1.13 + ("accepted" NOTNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR 1.14 + ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR 1.15 + ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR 1.16 + ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR 1.17 + ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR 1.18 + ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL AND "closed" NOTNULL AND "ranks_available" = TRUE) ); 1.19 +COMMIT;