【无标题】

INSERT INTO `user` VALUES ('1', '张三', '1223365814', 'er1@exa.com', '13800000001', '2024-06-06 22:07:39');
INSERT INTO `user` VALUES ('2', '李四', '2567892356', 'ir2@exa.com', '13800000002', '2024-06-09 22:07:39');
INSERT INTO `user` VALUES ('3', '赵五', '2345618974', 'er3@exa.com', '13800000003', '2024-06-09 22:07:39');
INSERT INTO `user` VALUES ('4', '杨澳', '6589741258', 'er4@exa.com', '13800000004', '2024-05-31 22:07:39');
INSERT INTO `user` VALUES ('5', '马建', '5687415987', 'user5@ex.com', '13800000005', '2024-06-04 22:07:39');
INSERT INTO `user` VALUES ('6', '沈凯丽', '9856465214', 'ur6@exle.com', '13800000006', '2024-06-01 22:07:39');
INSERT INTO `user` VALUES ('7', '郭浩天', '214565879', 'ur7@exple.com', '13800000007', '2024-06-01 22:07:39');
INSERT INTO `user` VALUES ('8', '黄丽丽', '5246598741', 'ur8@exae.com', '13800000008', '2024-06-04 22:07:39');
INSERT INTO `user` VALUES ('9', '程美丽', '6235487951', 'ur9@exa.com', '13800000009', '2024-06-08 22:07:39');
INSERT INTO `user` VALUES ('10', '郭香香', '1489756348', 'er10@ple.com', '13800000010', '2024-06-08 22:07:39');

INSERT INTO `user_wallet` VALUES ('1', '1', '422.00', '2024-06-08 22:07:42');
INSERT INTO `user_wallet` VALUES ('2', '2', '897.00', '2024-06-04 22:07:42');
INSERT INTO `user_wallet` VALUES ('3', '3', '354.00', '2024-06-03 22:07:42');
INSERT INTO `user_wallet` VALUES ('4', '4', '758.00', '2024-06-07 22:07:42');
INSERT INTO `user_wallet` VALUES ('5', '5', '319.00', '2024-06-06 22:07:42');
INSERT INTO `user_wallet` VALUES ('6', '6', '350.00', '2024-06-08 22:07:42');
INSERT INTO `user_wallet` VALUES ('7', '7', '871.00', '2024-06-04 22:07:42');
INSERT INTO `user_wallet` VALUES ('8', '8', '515.00', '2024-06-05 22:07:42');
INSERT INTO `user_wallet` VALUES ('9', '9', '1042.00', '2024-06-05 22:07:42');
INSERT INTO `user_wallet` VALUES ('10', '10', '273.00', '2024-06-03 22:07:42');


INSERT INTO `user_wallet_log` VALUES ('1', '1', '充值', '100.00', '2024-06-01 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('2', '2', '消费', '50.00', '2024-06-08 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('3', '3', '提现', '200.00', '2024-06-09 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('4', '4', '充值', '150.00', '2024-05-31 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('5', '5', '消费', '75.00', '2024-06-04 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('6', '6', '提现', '300.00', '2024-06-02 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('7', '7', '充值', '250.00', '2024-06-09 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('8', '8', '消费', '120.00', '2024-06-07 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('9', '9', '提现', '400.00', '2024-06-08 22:07:48');
INSERT INTO `user_wallet_log` VALUES ('10', '10', '充值', '300.00', '2024-05-31 22:07:48');

product

INSERT INTO `product_type` VALUES ('1', '非特殊用途化妆品', null, '也被称为普通化妆品，包括日常使用的清洁类、护理类以及美容类化妆品。', '2024-05-31 22:13:55');
INSERT INTO `product_type` VALUES ('2', '男用化妆品', null, '男性多属于脂性皮肤，应选用适于脂性皮肤的原料。', '2024-06-01 22:13:55');
INSERT INTO `product_type` VALUES ('3', '孕妇化妆品', null, '孕期女性的肌肤需求特殊，需要特别注意防晒和某些化学成分。', '2024-06-02 22:13:55');
INSERT INTO `product_type` VALUES ('4', '发用化妆品', null, '专用于头发的化妆品。', '2024-06-03 22:13:55');
INSERT INTO `product_type` VALUES ('5', '指甲用化妆品', null, '用于指甲美容的化妆品。', '2024-06-04 22:13:55');


INSERT INTO `product` VALUES ('1', '膜法世家 绿豆护肤套装系列 ', '399.00', '100', '1', '2024-06-05 22:13:55');
INSERT INTO `product` VALUES ('2', '珀莱雅红宝石水乳套装', '679.00', '50', '2', '2024-06-06 22:13:55');
INSERT INTO `product` VALUES ('3', '韩束男士控油保湿水乳', '199.00', '200', '3', '2024-06-07 22:13:55');
INSERT INTO `product` VALUES ('4', '袋鼠妈妈燕窝水乳套装护肤品', '558.00', '80', '4', '2024-06-08 22:13:55');
INSERT INTO `product` VALUES ('5', '卡诗山茶花护发精油', '370.00', '150', '5', '2024-06-09 22:13:55');
INSERT INTO `product` VALUES ('6', '迪奥甜杏精华护甲霜', '225.00', '70', '2', '2024-05-31 22:13:55');
INSERT INTO `product` VALUES ('7', '爱马仕口红双支装', '1180', '300', '3', '2024-06-01 22:13:55');
INSERT INTO `product` VALUES ('8', '卡芬诗竹炭活力修复面膜', '458.00', '120', '4', '2024-06-02 22:13:55');
INSERT INTO `product` VALUES ('9', '欧莱雅小蜜罐花蜜胶原水乳套装', '659.00', '90', '5', '2024-06-03 22:13:55');
INSERT INTO `product` VALUES ('10', '半分一透亮小源泉粉底液', '310.00', '60', '1', '2024-05-30 22:13:55');

order

INSERT INTO `order` VALUES ('1', '2', '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:19:50', '399.00');
INSERT INTO `order` VALUES ('2', '5', '已支付', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:19:53', '679.00');
INSERT INTO `order` VALUES ('3', '7', '已完成', '2024-06-09 22:19:14', '已支付', '2024-06-05 22:19:58', '199.00');
INSERT INTO `order` VALUES ('4', '9', '已取消', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:46', '0.00');
INSERT INTO `order` VALUES ('5', '2', '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:49', '370.00');
INSERT INTO `order` VALUES ('6', '5', '已支付', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:20:51', '225.00');
INSERT INTO `order` VALUES ('7', '7', '待评价', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:20:53', '1180.00');
INSERT INTO `order` VALUES ('8', '9', '待发货', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:20:55', '458.00');
INSERT INTO `order` VALUES ('9', '2', '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:57', '659.00');
INSERT INTO `order` VALUES ('10', '5', '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:59', '310.00');


INSERT INTO `order_info` VALUES ('1', '1', '1', '2', '399.00');
INSERT INTO `order_info` VALUES ('2', '1', '2', '1', '399.00');
INSERT INTO `order_info` VALUES ('3', '2', '3', '3', '679.00');
INSERT INTO `order_info` VALUES ('4', '3', '2', '1', '199.00');
INSERT INTO `order_info` VALUES ('5', '3', '4', '2', '199.00');
INSERT INTO `order_info` VALUES ('6', '5', '1', '1', '370.00');
INSERT INTO `order_info` VALUES ('7', '6', '4', '1', '225.00');
INSERT INTO `order_info` VALUES ('8', '7', '3', '2', '1180.00');
INSERT INTO `order_info` VALUES ('9', '8', '2', '2', '458.00');
INSERT INTO `order_info` VALUES ('10', '9', '1', '3', '659.00');
INSERT INTO `order_info` VALUES ('11', '9', '3', '1', '659.00');
INSERT INTO `order_info` VALUES ('12', '10', '2', '1', '310.00');