1.1 --- a/update/core-update.v2.0.11-v2.1.0.sql	Mon Aug 20 03:28:45 2012 +0200
     1.2 +++ b/update/core-update.v2.0.11-v2.1.0.sql	Mon Aug 20 13:22:33 2012 +0200
     1.3 @@ -21,6 +21,8 @@
     1.4  ALTER TABLE "policy" ALTER COLUMN "discussion_time"   DROP NOT NULL;
     1.5  ALTER TABLE "policy" ALTER COLUMN "verification_time" DROP NOT NULL;
     1.6  ALTER TABLE "policy" ALTER COLUMN "voting_time"       DROP NOT NULL;
     1.7 +ALTER TABLE "policy" ALTER COLUMN "issue_quorum_num"  DROP NOT NULL;
     1.8 +ALTER TABLE "policy" ALTER COLUMN "issue_quorum_den"  DROP NOT NULL;
     1.9  ALTER TABLE "policy" ADD CONSTRAINT "timing" CHECK (
    1.10            ( "polling" = FALSE AND
    1.11              "admission_time" NOTNULL AND "discussion_time" NOTNULL AND
    1.12 @@ -31,6 +33,9 @@
    1.13            ( "polling" = TRUE AND
    1.14              "admission_time" ISNULL AND "discussion_time" ISNULL AND
    1.15              "verification_time" ISNULL AND "voting_time" ISNULL ) );
    1.16 +ALTER TABLE "policy" ADD CONSTRAINT "issue_quorum_if_and_only_if_not_polling" CHECK (
    1.17 +          "polling" = "issue_quorum_num" ISNULL AND
    1.18 +          "polling" = "issue_quorum_den" ISNULL );
    1.19  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.20  
    1.21  ALTER TABLE "issue" ALTER COLUMN "admission_time" DROP NOT NULL;