M U L A I---------------2025-04-29 13:56:56
-----------Create goods_car_del_upd Table-----------
Done: 10
0
alter table otomotif_kurnia.buy
add buy_ref_no varchar(15) not null after in_date,
change invoice_no invoice_no char(5) not null,
change container_no buy_seq_no char(12) not null,
change pay_status pay_status_code char(1) not null,
change discount discount decimal(5,2) not null,
change issued_code bic_code char(4) not null
Table otomotif_kurnia.buy has been updated successfully!
Table otomotif_kurnia.buy (status) has been copied to (pay_status_code) successfully!
0
alter table otomotif_kurnia_dpk.buy
add buy_ref_no varchar(15) not null after in_date,
change invoice_no invoice_no char(5) not null,
change container_no buy_seq_no char(12) not null,
change pay_status pay_status_code char(1) not null,
change discount discount decimal(5,2) not null,
change issued_code bic_code char(4) not null
Table otomotif_kurnia_dpk.buy has been updated successfully!
Table otomotif_kurnia_dpk.buy (status) has been copied to (pay_status_code) successfully!
Table otomotif_kurnia.buy_detail has been alterred successfully!
Table otomotif_kurnia_dpk.buy_detail has been alterred successfully!
0
alter table otomotif_kurnia_dpk.sale
change discount discount decimal(5,2) not null,
change worker_code sic_code char(4) not null,
add lz_periode_date date not null after sic_code ,
add lz_status char(1) not null after lz_periode_date
0
alter table otomotif_kurnia_dpk.sale_detail
change discount discount decimal(5,2) not null,
change container_no buy_seq_no char(12) not null,
drop worker_code
Table otomotif_kurnia_dpk.sale_detail has been updated successfully!
0
alter table otomotif_kurnia_dpk.goods_stock
change container_no buy_seq_no char(12) not null
Table otomotif_kurnia_dpk.goods_stock has been updated successfully!
Done: 11
0
alter table otomotif_kurnia_dpk.customer
change debt_limit credit_limit double unsigned not null
0
alter table otomotif_kurnia_dpk.customer
add total_credit double unsigned not null after credit_limit
Table otomotif_kurnia.buy_in_charge has been created successfully!
0
.....Gagal.....
REPLACE into otomotif_kurnia.buy_in_charge (bic_code, bic_name)
select issued_code, issued_name
from otomotif_kurnia.issued_by