From: Elena Mamontova <helenh463@gmail.com>
Date: Fri, 23 Sep 2016 14:25:14 +0000 (+0300)
Subject: Ticket 37. TIMEZONE fixed to TIMESTAMP for change_policy_timeout in
X-Git-Tag: 2.409~76
X-Git-Url: https://git.stg.codes/stg.git/commitdiff_plain/746862797a13228a4c41bc83500cdff2751db5c2?hp=a42deeff3cbc80e221972ca1f17549fd29cd18ae

Ticket 37. TIMEZONE fixed to TIMESTAMP for change_policy_timeout in
the ALTER TABLE tariffs query in the MakeUpdate() function.
---

diff --git a/projects/stargazer/plugins/store/mysql/mysql_store.cpp b/projects/stargazer/plugins/store/mysql/mysql_store.cpp
index 8e12faad..381c4d9c 100644
--- a/projects/stargazer/plugins/store/mysql/mysql_store.cpp
+++ b/projects/stargazer/plugins/store/mysql/mysql_store.cpp
@@ -606,7 +606,7 @@ if (schemaVersion  < 1)
 if (schemaVersion  < 2)
     {
     if (MysqlQuery("ALTER TABLE tariffs ADD change_policy VARCHAR(32) NOT NULL DEFAULT 'allow'", sock) ||
-        MysqlQuery("ALTER TABLE tariffs ADD change_policy_timeout TIMEZONE NOT NULL DEFAULT '1970-01-01 00:00:00'", sock))
+        MysqlQuery("ALTER TABLE tariffs ADD change_policy_timeout TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:00'", sock))
         {
         errorStr = "Couldn't update tariffs table to version 2. With error:\n";
         errorStr += mysql_error(sock);