ALTER TABLE `hpp` CHANGE `qty_pr` `qty_pr` DOUBLE NULL DEFAULT NULL, CHANGE `hpp_pr` `hpp_pr` DOUBLE NULL DEFAULT NULL, CHANGE `total_pr` `total_pr` DOUBLE NULL DEFAULT NULL, CHANGE `qty_pv` `qty_pv` DOUBLE NULL DEFAULT NULL, CHANGE `hpp_pv` `hpp_pv` DOUBLE NULL DEFAULT NULL, CHANGE `total_pv` `total_pv` DOUBLE NULL DEFAULT NULL, CHANGE `qty_so` `qty_so` DOUBLE NULL DEFAULT NULL, CHANGE `total_so` `total_so` DOUBLE NULL DEFAULT NULL, CHANGE `qty_log` `qty_log` DOUBLE NULL DEFAULT NULL, CHANGE `total_coa` `total_coa` DOUBLE NULL DEFAULT NULL, CHANGE `hpp_act` `hpp_act` DOUBLE NULL DEFAULT NULL, CHANGE `total_act` `total_act` DOUBLE NULL DEFAULT NULL;

ALTER TABLE `jtheader` CHANGE `jt_autoid` `jt_autoid` BIGINT NOT NULL; 