annotate update/core-update.beta21-beta22.sql @ 94:fb9688f31740
Corrected "delete_member" and "delete_private_data" functions to refer to "ignored_issue" table instead of non-existing "ignored_voting" table; Delete "ignored_issue" entries in "clean_issue" function as well
| author |
jbe |
| date |
Sun Oct 31 02:38:05 2010 +0200 (2010-10-31) |
| 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;
|