From: Elena Mamontova <helenh463@gmail.com>
Date: Thu, 16 Jun 2016 10:44:35 +0000 (+0300)
Subject: Ticket 37. The 'ALTER TABLE tariffs' query added for the 'change_policy'
X-Git-Tag: 2.409~153
X-Git-Url: https://git.stg.codes/stg.git/commitdiff_plain/2b2f713735edf6e6bf184ac42a5e9fdfd4dc599e?ds=sidebyside

Ticket 37. The 'ALTER TABLE tariffs' query added for the 'change_policy'
field adding, 'UPDATE info' query added for the 'version' field change to 2,
when shemaversion value < 2.
---

diff --git a/projects/stargazer/plugins/store/mysql/mysql_store.cpp b/projects/stargazer/plugins/store/mysql/mysql_store.cpp
index 94e12995..37da860b 100644
--- a/projects/stargazer/plugins/store/mysql/mysql_store.cpp
+++ b/projects/stargazer/plugins/store/mysql/mysql_store.cpp
@@ -601,6 +601,26 @@ if (schemaVersion  < 1)
     schemaVersion = 1;
     logger("MYSQL_STORE: Updated DB schema to version %d", schemaVersion);
     }
+
+if (schemaVersion  < 2)
+    {
+    if (MysqlQuery("ALTER TABLE tariffs ADD change_policy VARCHAR(32) NOT NULL DEFAULT 'allow'", sock))
+        {
+        errorStr = "Couldn't update tariffs table to version 2. With error:\n";
+        errorStr += mysql_error(sock);
+        mysql_close(sock);
+        return -1;
+        }
+    if (MysqlQuery("UPDATE info SET version = 2", sock))
+        {
+        errorStr = "Couldn't update DB schema version to 2. With error:\n";
+        errorStr += mysql_error(sock);
+        mysql_close(sock);
+        return -1;
+        }
+    schemaVersion = 2;
+    logger("MYSQL_STORE: Updated DB schema to version %d", schemaVersion);
+    }
 return 0;
 }
 //-----------------------------------------------------------------------------