CREATE TABLE `xcxmall_lepin_receive_activity` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` varchar(255) CHARACTER SET utf8 DEFAULT "",
`type_name` varchar(255) DEFAULT "",
`user_id` int(10) DEFAULT NULL,
`store_id` int(10) DEFAULT NULL,
`date` date DEFAULT NULL,
`addtime` int(11) DEFAULT NULL,
`money` decimal(10,2) DEFAULT "0.00",
`order_no` varchar(255) DEFAULT "",
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb4;
上面是对应的数据库表
INSERT INTO `xl-pp`.`xcxmall_lepin_receive_activity`(`id`, `type`, `type_name`, `user_id`, `store_id`, `date`, `addtime`, `money`, `order_no`) VALUES (125, "percent2", "满券", 435, 4, "2020-06-06", 1590659535, 0.00, "");
INSERT INTO `xl-pp`.`xcxmall_lepin_receive_activity`(`id`, `type`, `type_name`, `user_id`, `store_id`, `date`, `addtime`, `money`, `order_no`) VALUES (126, "percent1", "0.5元红包", 433, 4, "2020-06-02", 1590659539, 0.50, "PA202005280552199335");
INSERT INTO `xl-pp`.`xcxmall_lepin_receive_activity`(`id`, `type`, `type_name`, `user_id`, `store_id`, `date`, `addtime`, `money`, `order_no`) VALUES (127, "percent2", "满券", 433, 4, "2020-06-03", 1590659565, 0.00, "");
INSERT INTO &#