From: Elena Mamontova <helenh463@gmail.com>
Date: Fri, 23 Sep 2016 12:34:56 +0000 (+0300)
Subject: Ticket 37. ALTER TABLE tariffs query added for change_policy_timeout
X-Git-Tag: 2.409~78
X-Git-Url: https://git.stg.codes/stg.git/commitdiff_plain/f15d246cc063274168a1131d4551932245fece67?ds=inline;hp=--cc

Ticket 37. ALTER TABLE tariffs query added for change_policy_timeout
field adding, when schemaversion < 2.
---

f15d246cc063274168a1131d4551932245fece67
diff --git a/projects/stargazer/plugins/store/mysql/mysql_store.cpp b/projects/stargazer/plugins/store/mysql/mysql_store.cpp
index fb8b085c..e423c672 100644
--- a/projects/stargazer/plugins/store/mysql/mysql_store.cpp
+++ b/projects/stargazer/plugins/store/mysql/mysql_store.cpp
@@ -605,7 +605,8 @@ if (schemaVersion  < 1)
 
 if (schemaVersion  < 2)
     {
-    if (MysqlQuery("ALTER TABLE tariffs ADD change_policy VARCHAR(32) NOT NULL DEFAULT 'allow'", sock))
+    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))
         {
         errorStr = "Couldn't update tariffs table to version 2. With error:\n";
         errorStr += mysql_error(sock);