X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/2d6438002327ed6d5a1827275c34ab396677a6ce..f15d246cc063274168a1131d4551932245fece67:/projects/stargazer/plugins/store/mysql/mysql_store.cpp?ds=inline diff --git a/projects/stargazer/plugins/store/mysql/mysql_store.cpp b/projects/stargazer/plugins/store/mysql/mysql_store.cpp index c6217183..e423c672 100644 --- a/projects/stargazer/plugins/store/mysql/mysql_store.cpp +++ b/projects/stargazer/plugins/store/mysql/mysql_store.cpp @@ -425,7 +425,7 @@ if(!IsTablePresent("tariffs",sock)) res += "PassiveCost=0.0, Fee=10.0, Free=0,"\ "SinglePrice0=1, SinglePrice1=1,PriceDayA1=0.75,PriceDayB1=0.75,"\ "PriceNightA0=1.0,PriceNightB0=1.0,TraffType='up+down',period='month',"\ - "change_policy='allow'"; + "change_policy='allow', change_policy_timeout='1970-01-01 00:00:00'"; if(MysqlQuery(res.c_str(),sock)) { @@ -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);