Overhead and labour cost changed to define standard costs.

[fa-stable.git] / sql / alter2.4rc1.sql

diff --git a/sql/alter2.4rc1.sql b/sql/alter2.4rc1.sql
index b220d62ad76a268d602ef473549775c06effe06b..a2f3e6f2c17266d7b624057de93caa3ba3be6650 100644 (file)
--- a/sql/alter2.4rc1.sql
+++ b/sql/alter2.4rc1.sql
@@ -30,3 +30,4 @@ ALTER TABLE `0_wo_issue_items` ADD COLUMN  `unit_cost` double NOT NULL default '
 ALTER TABLE `0_wo_requirements` CHANGE COLUMN `std_cost` `unit_cost` double NOT NULL default '0';
 
 ALTER TABLE `0_stock_master` DROP COLUMN `last_cost`;
+UPDATE `0_stock_master` SET `material_cost`=`material_cost`+`labour_cost`+`overhead_cost`;