liquid_feedback_core
changeset 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 |
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