MySQL

最新推荐文章于 2024-08-15 16:38:30 发布
一直在想名
最新推荐文章于 2024-08-15 16:38:30 发布
阅读量100
点赞数 2
文章标签： java 数据库服务器
本文链接：https://blog.csdn.net/wgh2572701783/article/details/139655144
版权
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (1, 2, '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:19:50', 120.00);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (2, 5, '已支付', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:19:53', 230.50);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (3, 7, '已完成', '2024-06-09 22:19:14', '已支付', '2024-06-05 22:19:58', 345.75);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (4, 9, '已取消', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:46', 0.00);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (5, 2, '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:49', 45.00);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (6, 5, '已支付', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:20:51', 78.00);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (7, 7, '待评价', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:20:53', 90.20);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (8, 9, '待发货', '2024-06-09 22:19:14', '已支付', '2024-06-09 22:20:55', 150.00);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (9, 2, '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:57', 198.00);
INSERT INTO `order`(`order_id`, `user_id`, `order_status`, `order_time`, `payment_status`, `payment_time`, `total_price`) VALUES (10, 5, '待支付', '2024-06-09 22:19:14', '未支付', '2024-06-09 22:20:59', 66.50);

INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (1, 1, 1, 2, 50.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (2, 1, 2, 1, 60.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (3, 2, 3, 3, 70.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (4, 3, 2, 1, 60.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (5, 3, 4, 2, 80.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (6, 5, 1, 1, 50.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (7, 6, 4, 1, 80.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (8, 7, 3, 2, 70.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (9, 8, 2, 2, 60.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (10, 9, 1, 3, 50.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (11, 9, 3, 1, 70.00);
INSERT INTO `order_info`(`order_info_id`, `order_id`, `product_id`, `quantity`, `unit_price`) VALUES (12, 10, 2, 1, 60.00);

INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (1, 'iPhone 13', 6999.00, 100, 1, '2024-06-05 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (2, 'MacBook Pro', 14999.00, 50, 2, '2024-06-06 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (3, '小米智能音箱', 199.00, 200, 3, '2024-06-07 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (4, '三星65寸4K电视', 7999.00, 80, 4, '2024-06-08 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (5, '索尼降噪耳机', 1299.00, 150, 5, '2024-06-09 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (6, '华为MatePad Pro', 3999.00, 70, 2, '2024-05-31 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (7, '小米米家智能灯泡', 79.00, 300, 3, '2024-06-01 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (8, 'LG 27寸显示器', 1499.00, 120, 4, '2024-06-02 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (9, '苹果AirPods Pro', 1599.00, 90, 5, '2024-06-03 22:13:55');
INSERT INTO `product`(`product_id`, `product_name`, `price`, `stock`, `type_id`, `created_at`) VALUES (10, '一加9 Pro', 4999.00, 60, 1, '2024-05-30 22:13:55');

INSERT INTO `product_type`(`type_id`, `type_name`, `parent_id`, `description`, `created_at`) VALUES (1, '智能手机', NULL, '包含各种品牌和型号的智能手机，涵盖不同价格区间和功能特点。', '2024-05-31 22:13:55');
INSERT INTO `product_type`(`type_id`, `type_name`, `parent_id`, `description`, `created_at`) VALUES (2, '笔记本电脑', NULL, '提供多种类型和配置的笔记本电脑，适用于不同工作和学习需求。', '2024-06-01 22:13:55');
INSERT INTO `product_type`(`type_id`, `type_name`, `parent_id`, `description`, `created_at`) VALUES (3, '智能家居', NULL, '包含智能家居设备，如智能音箱、智能照明、智能门锁等。', '2024-06-02 22:13:55');
INSERT INTO `product_type`(`type_id`, `type_name`, `parent_id`, `description`, `created_at`) VALUES (4, '电视与显示器', NULL, '涵盖各种尺寸和分辨率的电视与显示器，适用于家庭和企业使用。', '2024-06-03 22:13:55');
INSERT INTO `product_type`(`type_id`, `type_name`, `parent_id`, `description`, `created_at`) VALUES (5, '耳机与音响', NULL, '提供高品质耳机和音响设备，满足用户的音频体验需求。', '2024-06-04 22:13:55');

INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (1, '王语嫣', 'password1', 'user1@example.com', '13800000001', '2024-06-06 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (2, '小龙女', 'password2', 'user2@example.com', '13800000002', '2024-06-09 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (3, '赵灵儿', 'password3', 'user3@example.com', '13800000003', '2024-06-09 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (4, '杨过', 'password4', 'user4@example.com', '13800000004', '2024-05-31 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (5, '向问天', 'password5', 'user5@example.com', '13800000005', '2024-06-04 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (6, '杨潇', 'password6', 'user6@example.com', '13800000006', '2024-06-01 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (7, '郭靖', 'password7', 'user7@example.com', '13800000007', '2024-06-01 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (8, '黄蓉', 'password8', 'user8@example.com', '13800000008', '2024-06-04 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (9, '程英', 'password9', 'user9@example.com', '13800000009', '2024-06-08 22:07:39');
INSERT INTO `user`(`user_id`, `username`, `password`, `email`, `phone`, `created_at`) VALUES (10, '郭襄', 'password10', 'user10@example.com', '13800000010', '2024-06-08 22:07:39');

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

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