From: Elena Mamontova Date: Fri, 23 Sep 2016 14:21:32 +0000 (+0300) Subject: Ticket 37. TIMEZONE fixed to TIMESTAMP for the change_policy_timeout in X-Git-Tag: 2.409~77 X-Git-Url: https://git.stg.codes/stg.git/commitdiff_plain/a42deeff3cbc80e221972ca1f17549fd29cd18ae?ds=inline Ticket 37. TIMEZONE fixed to TIMESTAMP for the change_policy_timeout in 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 e423c672..8e12faad 100644 --- a/projects/stargazer/plugins/store/mysql/mysql_store.cpp +++ b/projects/stargazer/plugins/store/mysql/mysql_store.cpp @@ -370,7 +370,7 @@ if(!IsTablePresent("tariffs",sock)) "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_timeout TIMEZONE NOT NULL DEFAULT '1970-01-01 00:00:00')"; + "change_policy_timeout TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00')"; if(MysqlQuery(res.c_str(),sock)) {