ALTER TABLE `tbl_prr_items` ADD `balance_qty` INT NOT NULL DEFAULT '0' AFTER `qty`;
ALTER TABLE `tbl_prr_items` ADD `total_delivered_qty` INT NOT NULL DEFAULT '0' AFTER `delivered_qty`;

CREATE TABLE `tbl_prr_status_log` (`log_id` bigint(250) NOT NULL, `prr_id` bigint(250) NOT NULL DEFAULT '0', `from_status` bigint(250) NOT NULL DEFAULT '0', `to_status` bigint(250) NOT NULL DEFAULT '0', `action_by` bigint(250) NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `tbl_prr_status_log` ADD PRIMARY KEY (`log_id`);
ALTER TABLE `tbl_prr_status_log` MODIFY `log_id` bigint(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;