liquid_feedback_core

changeset 454:63af9100628c

find changesets by author, revision, files, or words in the commit message
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
files core.sql update/core-update.v3.0.5-v3.1.0.sql
line diff
     1.1 --- a/core.sql	Thu Dec 03 22:09:25 2015 +0100
     1.2 +++ b/core.sql	Thu Dec 03 22:30:18 2015 +0100
     1.3 @@ -387,6 +387,7 @@
     1.4          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" AND
     1.8              "discussion_time" NOTNULL AND
     1.9              "verification_time" NOTNULL AND
    1.10              "voting_time" NOTNULL ) OR

     2.1 --- a/update/core-update.v3.0.5-v3.1.0.sql	Thu Dec 03 22:09:25 2015 +0100
     2.2 +++ b/update/core-update.v3.0.5-v3.1.0.sql	Thu Dec 03 22:30:18 2015 +0100
     2.3 @@ -19,6 +19,7 @@
     2.4  ALTER TABLE "policy" ADD CONSTRAINT "timing" CHECK (
     2.5    ( "polling" = FALSE AND
     2.6      "min_admission_time" NOTNULL AND "max_admission_time" NOTNULL AND
     2.7 +    "min_admission_time" <= "max_admission_time"
     2.8      "discussion_time" NOTNULL AND
     2.9      "verification_time" NOTNULL AND
    2.10      "voting_time" NOTNULL ) OR

Impressum / About Us