From f15d246cc063274168a1131d4551932245fece67 Mon Sep 17 00:00:00 2001 From: Elena Mamontova Date: Fri, 23 Sep 2016 15:34:56 +0300 Subject: [PATCH] Ticket 37. ALTER TABLE tariffs query added for change_policy_timeout field adding, when schemaversion < 2. --- projects/stargazer/plugins/store/mysql/mysql_store.cpp | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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); -- 2.44.2