M U L A I---------------2025-12-14 11:00:26


Warning: include(../tjm/inc/init_db.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 7

Warning: include(../tjm/inc/init_db.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 7

Warning: include(): Failed opening '../tjm/inc/init_db.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 7


-----------Create goods_car_del_upd Table-----------


Done: 10


Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 131
0

alter table otomotif_tjm.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
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 141
0
update otomotif_tjm.buy set buy_seq_no = LPAD(trim(buy_seq_no),12,'0')
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 153
0

update otomotif_tjm.buy set pay_status_code= status, pay_date = status_date
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 169
0

alter table otomotif_tjm_cpa.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
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 178
0
update otomotif_tjm_cpa.buy set buy_seq_no = LPAD(trim(buy_seq_no),12,'0')
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 190
0

update otomotif_tjm_cpa.buy set pay_status_code= status, pay_date = status_date
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 203
0

alter table otomotif_tjm.buy_detail change discount discount decimal(5,2) not null, change invoice_no invoice_no char(5) not null
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 214
0

alter table otomotif_tjm_cpa.buy_detail change discount discount decimal(5,2) not null, change invoice_no invoice_no char(5) not null
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 231
0

alter table otomotif_tjm_cpa.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
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 248
0

alter table otomotif_tjm_cpa.sale_detail change discount discount decimal(5,2) not null, change container_no buy_seq_no char(12) not null, drop worker_code
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 256
0
update otomotif_tjm_cpa.sale_detail set buy_seq_no = LPAD(trim(buy_seq_no),12,'0')
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 271
0

alter table otomotif_tjm_cpa.goods_stock change container_no buy_seq_no char(12) not null
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 279
0
update otomotif_tjm_cpa.goods_stock set buy_seq_no = LPAD(trim(buy_seq_no),12,'0')

Done: 11


Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 303
0

alter table otomotif_tjm_cpa.customer change debt_limit credit_limit double unsigned not null
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/_install_tjm_2022-10-12.php on line 312
0

alter table otomotif_tjm_cpa.customer add total_credit double unsigned not null after credit_limit
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/_utility/buy_in_charge_refresh_table.php on line 16



drop table if exists .buy_in_charge