From: Elena Mamontova 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; } //-----------------------------------------------------------------------------