DROP TABLE IF EXISTS `sale_pos_history`;
CREATE TABLE `sale_pos_history` (
                                    `sales_id` int NOT NULL,
                                    `bank_code` varchar(50) NOT NULL,
                                    `installment` int NOT NULL,
                                    `pos_order_id` varchar(150) NOT NULL,
                                    `price` decimal(15,6) NOT NULL,
                                    `status` varchar(50) NOT NULL,
                                    `insert_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;