liquid_feedback_core
annotate update/core-update.beta21-beta22.sql @ 48:74c985baf082
Function "delete_member_data"(...) deletes outgoing delegations
(v1.0.1 with update script)
(v1.0.1 with update script)
author | jbe |
---|---|
date | Tue Apr 20 18:01:07 2010 +0200 (2010-04-20) |
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; |