From 746862797a13228a4c41bc83500cdff2751db5c2 Mon Sep 17 00:00:00 2001 From: Elena Mamontova Date: Fri, 23 Sep 2016 17:25:14 +0300 Subject: [PATCH] Ticket 37. TIMEZONE fixed to TIMESTAMP for change_policy_timeout in the ALTER TABLE tariffs query in the MakeUpdate() function. --- projects/stargazer/plugins/store/mysql/mysql_store.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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); -- 2.43.2