1 # reliable cost change log in stock_moves
2 ALTER TABLE `0_stock_moves` CHANGE COLUMN `standard_cost` `unit_cost` double NOT NULL DEFAULT '0';
3 ALTER TABLE `0_debtor_trans_details` CHANGE COLUMN `standard_cost` `unit_cost` double NOT NULL DEFAULT '0';
6 ALTER TABLE `0_purch_orders` CHANGE COLUMN `requisition_no` `supp_reference` tinytext;
8 # cleanups in work orders
9 ALTER TABLE `0_workorders` DROP INDEX `wo_ref`;
10 ALTER TABLE `0_workorders` ADD KEY `wo_ref` (`wo_ref`);
11 ALTER TABLE `0_workorders` DROP COLUMN `additional_costs`;