liquid_feedback_core
annotate update/core-update.beta21-beta22.sql @ 63:1af482e378a1
Added "rendered_draft" table for caching
(Version number updated to v1.2.3, update script included)
(Version number updated to v1.2.3, update script included)
author | jbe |
---|---|
date | Sat Jul 24 16:40:51 2010 +0200 (2010-07-24) |
parents | 9970f73c1140 |
children |
rev | line source |
---|---|
jbe@34 | 1 BEGIN; |
jbe@34 | 2 CREATE OR REPLACE VIEW "liquid_feedback_version" AS |
jbe@34 | 3 SELECT * FROM (VALUES ('beta22', NULL, NULL, NULL)) |
jbe@34 | 4 AS "subquery"("string", "major", "minor", "revision"); |
jbe@34 | 5 ALTER TABLE "issue" DROP CONSTRAINT "valid_state"; |
jbe@34 | 6 ALTER TABLE "issue" ADD CONSTRAINT "valid_state" CHECK ( |
jbe@34 | 7 ("accepted" ISNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 8 ("accepted" ISNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 9 ("accepted" NOTNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 10 ("accepted" NOTNULL AND "half_frozen" ISNULL AND "fully_frozen" ISNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 11 ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 12 ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 13 ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL AND "closed" ISNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 14 ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL AND "closed" NOTNULL AND "ranks_available" = FALSE) OR |
jbe@34 | 15 ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL AND "closed" NOTNULL AND "ranks_available" = TRUE) ); |
jbe@34 | 16 COMMIT; |