projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
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`;