1.1 --- a/update/core-update.v2.0.11-v2.1.0.sql	Sun Aug 19 23:37:37 2012 +0200
     1.2 +++ b/update/core-update.v2.0.11-v2.1.0.sql	Mon Aug 20 03:28:45 2012 +0200
     1.3 @@ -33,6 +33,10 @@
     1.4              "verification_time" ISNULL AND "voting_time" ISNULL ) );
     1.5  COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues without issue quorum, where certain initiatives (those having the "polling" flag set) do not need to pass the initiative quorum; "admission_time" MUST be set to NULL, the other timings may be set to NULL altogether, allowing individual timing for those issues';
     1.6  
     1.7 +ALTER TABLE "issue" ALTER COLUMN "admission_time" DROP NOT NULL;
     1.8 +ALTER TABLE "issue" ADD CONSTRAINT "admission_time_not_null_unless_instantly_accepted" CHECK (
     1.9 +  "admission_time" NOTNULL OR ("accepted" NOTNULL AND "accepted" = "created") );
    1.10 +
    1.11  ALTER TABLE "initiative" ADD COLUMN "polling" BOOLEAN NOT NULL DEFAULT FALSE;
    1.12  COMMENT ON COLUMN "initiative"."polling" IS 'Initiative does not need to pass the initiative quorum (see "policy"."polling")';
    1.13