annotate update/core-update.beta21-beta22.sql @ 95:625f88e41125
Added tag v1.3.0 for changeset fb9688f31740
author |
jbe |
date |
Mon Nov 08 01:46:58 2010 +0100 (2010-11-08) |
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;
|