liquid_feedback_core

diff update/core-update.v3.0.5-v3.1.0.sql @ 454:63af9100628c

Require "min_admission_time" to be smaller than or equal to "max_admission_time" in "policy" table
author jbe
date Thu Dec 03 22:30:18 2015 +0100 (2015-12-03)
parents fb7ccc4933a8
children b858e90f6cdd
line diff
     1.1 --- a/update/core-update.v3.0.5-v3.1.0.sql	Thu Dec 03 22:09:25 2015 +0100
     1.2 +++ b/update/core-update.v3.0.5-v3.1.0.sql	Thu Dec 03 22:30:18 2015 +0100
     1.3 @@ -19,6 +19,7 @@
     1.4  ALTER TABLE "policy" ADD CONSTRAINT "timing" CHECK (
     1.5    ( "polling" = FALSE AND
     1.6      "min_admission_time" NOTNULL AND "max_admission_time" NOTNULL AND
     1.7 +    "min_admission_time" <= "max_admission_time"
     1.8      "discussion_time" NOTNULL AND
     1.9      "verification_time" NOTNULL AND
    1.10      "voting_time" NOTNULL ) OR

Impressum / About Us