annotate update/core-update.beta21-beta22.sql @ 102:2daa8ce3d743
Update script added
| author |
jbe |
| date |
Tue Jan 04 02:55:01 2011 +0100 (2011-01-04) |
| 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;
|