From 2b2f713735edf6e6bf184ac42a5e9fdfd4dc599e Mon Sep 17 00:00:00 2001 From: Elena Mamontova Date: Thu, 16 Jun 2016 13:44:35 +0300 Subject: [PATCH 1/1] 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. --- .../plugins/store/mysql/mysql_store.cpp | 20 +++++++++++++++++++ 1 file changed, 20 insertions(+) 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; } //----------------------------------------------------------------------------- -- 2.44.2