From: Elena Mamontova Date: Fri, 23 Sep 2016 07:05:46 +0000 (+0300) Subject: Ticket 37. The changePolicyTimeout field added to the CREATE TABLE X-Git-Tag: 2.409~80 X-Git-Url: https://git.stg.codes/stg.git/commitdiff_plain/2d6438002327ed6d5a1827275c34ab396677a6ce?ds=inline Ticket 37. The changePolicyTimeout field added to the CREATE TABLE tariffs query. --- diff --git a/projects/stargazer/plugins/store/mysql/mysql_store.cpp b/projects/stargazer/plugins/store/mysql/mysql_store.cpp index f3539dd6..c6217183 100644 --- a/projects/stargazer/plugins/store/mysql/mysql_store.cpp +++ b/projects/stargazer/plugins/store/mysql/mysql_store.cpp @@ -369,7 +369,8 @@ if(!IsTablePresent("tariffs",sock)) res += "PassiveCost DOUBLE DEFAULT 0.0, Fee DOUBLE DEFAULT 0.0," "Free DOUBLE DEFAULT 0.0, TraffType VARCHAR(10) DEFAULT ''," "period VARCHAR(32) NOT NULL DEFAULT 'month'," - "change_policy VARCHAR(32) NOT NULL DEFAULT 'allow')"; + "change_policy VARCHAR(32) NOT NULL DEFAULT 'allow'," + "change_policy_timeout TIMEZONE NOT NULL DEFAULT '1970-01-01 00:00:00')"; if(MysqlQuery(res.c_str(),sock)) {