X-Git-Url: https://git.stg.codes/stg.git/blobdiff_plain/f3c345c9cabaa291b0ec12027f309f040debef75..f6eb7e68d3af08757b683092705dcd72ba1f4796:/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp diff --git a/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp b/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp index 72d83851..c3aecbec 100644 --- a/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp +++ b/projects/stargazer/plugins/store/firebird/firebird_store_tariffs.cpp @@ -160,27 +160,37 @@ try if (schemaVersion > 0) query += ", period = ?"; if (schemaVersion > 1) - query += ", change_policy = ?"; + query += ", change_policy = ?, \ + change_policy_timeout = ?"; query += " where pk_tariff = ?"; + unsigned num = 5; st->Prepare(query); st->Set(1, td.tariffConf.fee); st->Set(2, td.tariffConf.free); st->Set(3, td.tariffConf.passiveCost); st->Set(4, td.tariffConf.traffType); + if (schemaVersion == 0) + st->Set(num, id); if (schemaVersion > 0) + { st->Set(5, TARIFF::PeriodToString(td.tariffConf.period)); + if (schemaVersion == 1) + st->Set(num + 1, id); + } + if (schemaVersion > 1) { st->Set(6, TARIFF::ChangePolicyToString(td.tariffConf.changePolicy)); IBPP::Timestamp policyTimeout; time_t2ts(td.tariffConf.changePolicyTimeout, &policyTimeout); st->Set(7, policyTimeout); + if (schemaVersion == 2) + st->Set(num + 3, id); } - st->Set(7, id); st->Execute(); st->Close();