DROP TABLE IF EXISTS `payment_history`;
CREATE TABLE `payment_history` (
                                   `id` int NOT NULL AUTO_INCREMENT,
                                   `item_id` int DEFAULT NULL,
                                   `pay_order_id` varchar(150) NOT NULL,
                                   `item` varchar(50) NOT NULL,
                                   `payment_code` varchar(50) NOT NULL,
                                   `price` decimal(15,6) NOT NULL,
                                   `bank_code` varchar(50) NOT NULL,
                                   `user_id` int NOT NULL,
                                   `status` tinyint(1) NOT NULL DEFAULT '0',
                                   `insert_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;