From 58d3ade85e7ba8595b5b8c7508f2b2854c937250 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Mon, 22 Feb 2016 15:33:49 +0100 Subject: [PATCH] Fixed missing changes in upgrade sql files. --- sql/alter2.4.sql | 3 +++ sql/alter2.4rc1.sql | 3 +++ 2 files changed, 6 insertions(+) diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql index fed9c845..6359598a 100644 --- a/sql/alter2.4.sql +++ b/sql/alter2.4.sql @@ -304,3 +304,6 @@ UPDATE `0_wo_requirements` r, `0_stock_moves` m WHERE r.unit_cost=0 AND r.stock_id=m.stock_id AND m.trans_no=r.workorder_id AND m.`type`=26 AND m.qty=-r.units_issued; UPDATE `0_bank_trans` SET person_id=trans_no WHERE person_type_id=26; + +ALTER TABLE `0_budget_trans` CHANGE `counter` `id` int(11) NOT NULL AUTO_INCREMENT; +ALTER TABLE `0_sys_prefs` CHANGE `value` `value` text NOT NULL default ''; diff --git a/sql/alter2.4rc1.sql b/sql/alter2.4rc1.sql index 828e0e06..d71a92dc 100644 --- a/sql/alter2.4rc1.sql +++ b/sql/alter2.4rc1.sql @@ -46,3 +46,6 @@ UPDATE `0_wo_requirements` r, `0_stock_moves` m WHERE r.unit_cost=0 AND r.stock_id=m.stock_id AND m.trans_no=r.workorder_id AND m.`type`=26 AND m.qty=-r.units_issued; UPDATE `0_bank_trans` SET person_id=trans_no WHERE person_type_id=26; + +ALTER TABLE `0_budget_trans` CHANGE `counter` `id` int(11) NOT NULL AUTO_INCREMENT; +ALTER TABLE `0_sys_prefs` CHANGE `value` `value` text NOT NULL default ''; -- 2.30.2