From: Elena Mamontova <helenh463@gmail.com>
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))
     {