-- 由 gen.py 生成:建表 + 外键 + 索引 + 数据 BEGIN TRANSACTION; DROP TABLE IF EXISTS users; CREATE TABLE users ( "user_id" VARCHAR(32) PRIMARY KEY, "姓名" VARCHAR(64), "手机号" VARCHAR(20), "邮箱" VARCHAR(96), "城市" VARCHAR(160), "注册时间" DATETIME ); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0001', '陈**', '130****6409', 'de****@example.com', '郑州市金水区张江路 88 弄', '2026-05-07 17:23'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0002', '尤**', '185****6772', 'de****@demo-lab.com', '上海市浦东新区望京路 12 号', '2025-08-16 15:26'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0003', '许**', '153****8742', 'te*****@example.com', '洛阳市涧西区望京路 12 号', '2026-06-24 06:54'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0004', '朱**', '155****1303', 'us*****@demo-lab.com', '上海市浦东新区州桥街 3 号', '2026-05-19 15:38'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0005', '李**', '130****5969', 'qa***@test-corp.cn', '洛阳市涧西区花园路 66 号', '2025-02-19 20:41'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0006', '李**', '172****1879', 'qa***@test-corp.cn', '北京市朝阳区州桥街 3 号', '2026-05-24 23:20'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0007', '沈**', '190****3702', 'de****@test-corp.cn', '开封市鼓楼区州桥街 3 号', '2025-07-28 22:50'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0008', '钱**', '183****1903', 'qa***@demo-lab.com', '开封市鼓楼区望京路 12 号', '2026-03-16 20:44'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0009', '杨**', '139****1574', 'us*****@demo-lab.com', '洛阳市涧西区张江路 88 弄', '2025-04-28 09:27'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0010', '周**', '158****2076', 'qa***@test-corp.cn', '洛阳市涧西区望京路 12 号', '2025-05-13 23:46'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0011', '秦**', '187****5116', 'qa***@test-corp.cn', '洛阳市涧西区南昌路 5 号', '2026-08-14 07:04'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0012', '周**', '136****8992', 'de****@mock-data.org', '郑州市金水区花园路 66 号', '2026-03-31 23:46'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0013', '杨**', '195****0806', 'qa***@test-corp.cn', '洛阳市涧西区州桥街 3 号', '2025-08-22 09:09'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0014', '赵**', '151****9102', 'de****@test-corp.cn', '上海市浦东新区望京路 12 号', '2025-08-05 04:29'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0015', '蒋**', '174****5530', 'us*****@mock-data.org', '开封市鼓楼区州桥街 3 号', '2025-07-03 11:20'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0016', '周**', '155****1851', 'qa***@demo-lab.com', '北京市朝阳区张江路 88 弄', '2025-10-20 11:30'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0017', '赵**', '172****5194', 'de****@test-corp.cn', '北京市朝阳区花园路 66 号', '2025-05-15 21:36'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0018', '郑**', '179****1305', 'qa***@mock-data.org', '开封市鼓楼区州桥街 3 号', '2026-03-10 23:11'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0019', '陈**', '131****7281', 'te*****@mock-data.org', '郑州市金水区望京路 12 号', '2026-07-11 03:52'); INSERT INTO users ("user_id", "姓名", "手机号", "邮箱", "城市", "注册时间") VALUES ('U0020', '蒋**', '137****1397', 'qa***@test-corp.cn', '北京市朝阳区南昌路 5 号', '2026-02-20 00:13'); DROP TABLE IF EXISTS orders; CREATE TABLE orders ( "order_id" VARCHAR(32) PRIMARY KEY, "user_id" VARCHAR(32), "下单时间" DATETIME, "状态" VARCHAR(32), "金额" DECIMAL(10,2), "银行卡号" VARCHAR(32), FOREIGN KEY ("user_id") REFERENCES users("user_id") ); CREATE INDEX idx_orders_user_id ON orders("user_id"); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0001', 'U0001', '2025-04-05 03:49', '已完成', '2872.64', '6243********5805'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0002', 'U0002', '2025-11-06 23:30', '已发货', '3533.36', '6254********9640'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0003', 'U0003', '2025-05-02 20:08', '待支付', '3284.71', '6260********1912'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0004', 'U0004', '2026-01-28 07:51', '已取消', '810.57', '6218********3092'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0005', 'U0005', '2025-10-08 06:02', '已支付', '3496.48', '6253********9235'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0006', 'U0006', '2026-07-20 22:52', '待支付', '1828.98', '6274********4894'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0007', 'U0007', '2026-06-24 08:24', '已取消', '743.42', '6276********7274'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0008', 'U0008', '2026-08-03 22:43', '待支付', '2448.23', '6265********0410'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0009', 'U0009', '2025-03-28 06:59', '已支付', '3552.21', '6249********4916'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0010', 'U0010', '2025-01-27 06:51', '待支付', '5986.86', '6250********9995'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0011', 'U0011', '2025-02-22 23:00', '已取消', '2950.80', '6225********5887'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0012', 'U0012', '2025-06-28 03:40', '待支付', '5913.66', '6281********0452'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0013', 'U0013', '2025-07-06 02:48', '已发货', '2414.47', '6227********8009'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0014', 'U0014', '2025-08-22 21:17', '已取消', '556.85', '6218********1318'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0015', 'U0015', '2026-02-09 18:21', '已支付', '1845.22', '6243********8158'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0016', 'U0016', '2025-04-16 12:02', '已支付', '2843.76', '6227********1727'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0017', 'U0017', '2025-02-01 13:33', '已取消', '5857.59', '6256********3479'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0018', 'U0018', '2026-06-19 07:32', '已完成', '5095.51', '6271********9571'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0019', 'U0019', '2025-08-03 09:13', '已支付', '2811.01', '6238********3821'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0020', 'U0020', '2025-08-21 12:49', '待支付', '4767.78', '6266********3823'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0021', 'U0001', '2025-11-20 03:30', '已完成', '311.75', '6200********2748'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0022', 'U0002', '2025-03-19 00:56', '已发货', '4271.32', '6215********8187'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0023', 'U0003', '2026-03-16 08:28', '已取消', '2314.19', '6227********0884'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0024', 'U0004', '2025-02-24 17:14', '已发货', '2761.07', '6234********9424'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0025', 'U0005', '2025-03-06 16:58', '已取消', '3698.58', '6243********5832'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0026', 'U0006', '2026-06-24 23:54', '已完成', '3216.40', '6214********3413'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0027', 'U0007', '2025-11-30 20:04', '已发货', '1027.66', '6246********5041'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0028', 'U0008', '2025-05-27 10:46', '已取消', '4418.03', '6282********7664'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0029', 'U0009', '2025-06-15 20:27', '已支付', '619.99', '6245********9211'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0030', 'U0010', '2025-08-29 02:19', '已完成', '2906.68', '6206********0209'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0031', 'U0011', '2025-07-17 00:09', '已完成', '3306.84', '6205********3799'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0032', 'U0012', '2026-05-24 22:16', '已完成', '5181.09', '6292********3501'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0033', 'U0013', '2025-07-03 10:21', '已取消', '4531.85', '6273********1706'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0034', 'U0014', '2026-01-29 18:24', '已支付', '4635.34', '6297********3858'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0035', 'U0015', '2025-04-15 15:56', '待支付', '1686.07', '6205********1359'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0036', 'U0016', '2026-06-01 06:36', '已完成', '3542.96', '6220********8382'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0037', 'U0017', '2025-01-03 04:55', '已完成', '4368.82', '6294********9142'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0038', 'U0018', '2025-01-03 07:00', '已支付', '4253.51', '6206********6319'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0039', 'U0019', '2026-05-13 11:44', '已支付', '1389.07', '6203********2248'); INSERT INTO orders ("order_id", "user_id", "下单时间", "状态", "金额", "银行卡号") VALUES ('SO0040', 'U0020', '2026-07-17 02:30', '已发货', '5101.58', '6233********0929'); DROP TABLE IF EXISTS order_items; CREATE TABLE order_items ( "item_id" VARCHAR(32) PRIMARY KEY, "order_id" VARCHAR(32), "商品编码" VARCHAR(32), "数量" INTEGER, "单价" DECIMAL(10,2), FOREIGN KEY ("order_id") REFERENCES orders("order_id") ); CREATE INDEX idx_order_items_order_id ON order_items("order_id"); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0001', 'SO0001', 'SKU22094897', '5', '807.21'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0002', 'SO0002', 'SKU85507697', '4', '896.84'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0003', 'SO0003', 'SKU60157030', '4', '330.33'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0004', 'SO0004', 'SKU67774348', '3', '532.10'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0005', 'SO0005', 'SKU79844767', '5', '353.65'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0006', 'SO0006', 'SKU86297710', '3', '355.64'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0007', 'SO0007', 'SKU29707453', '1', '708.14'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0008', 'SO0008', 'SKU89156872', '2', '11.33'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0009', 'SO0009', 'SKU89785117', '4', '566.83'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0010', 'SO0010', 'SKU96950293', '1', '648.34'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0011', 'SO0011', 'SKU46763667', '6', '304.39'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0012', 'SO0012', 'SKU00400707', '5', '206.21'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0013', 'SO0013', 'SKU14904078', '5', '389.72'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0014', 'SO0014', 'SKU49211521', '5', '372.74'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0015', 'SO0015', 'SKU19324973', '5', '727.57'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0016', 'SO0016', 'SKU09817472', '5', '751.89'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0017', 'SO0017', 'SKU22821541', '3', '542.19'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0018', 'SO0018', 'SKU78380037', '1', '345.28'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0019', 'SO0019', 'SKU35517870', '3', '26.57'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0020', 'SO0020', 'SKU45751367', '2', '712.12'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0021', 'SO0021', 'SKU11408922', '4', '600.22'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0022', 'SO0022', 'SKU36685124', '4', '688.41'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0023', 'SO0023', 'SKU56744548', '4', '683.88'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0024', 'SO0024', 'SKU72899056', '5', '125.56'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0025', 'SO0025', 'SKU16130075', '6', '632.21'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0026', 'SO0026', 'SKU25362245', '2', '425.64'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0027', 'SO0027', 'SKU77566432', '3', '561.02'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0028', 'SO0028', 'SKU47984120', '1', '583.08'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0029', 'SO0029', 'SKU48342095', '1', '381.36'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0030', 'SO0030', 'SKU39186652', '5', '785.04'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0031', 'SO0031', 'SKU83343446', '6', '424.64'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0032', 'SO0032', 'SKU88976430', '6', '698.69'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0033', 'SO0033', 'SKU71658877', '6', '59.79'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0034', 'SO0034', 'SKU04206916', '1', '585.24'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0035', 'SO0035', 'SKU02838314', '6', '616.75'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0036', 'SO0036', 'SKU52321243', '6', '522.35'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0037', 'SO0037', 'SKU46788612', '2', '633.88'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0038', 'SO0038', 'SKU57534611', '3', '31.65'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0039', 'SO0039', 'SKU47920623', '6', '13.20'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0040', 'SO0040', 'SKU05334833', '3', '873.83'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0041', 'SO0001', 'SKU69876910', '1', '897.22'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0042', 'SO0002', 'SKU24196423', '1', '500.43'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0043', 'SO0003', 'SKU02057362', '6', '502.11'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0044', 'SO0004', 'SKU96282286', '3', '774.19'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0045', 'SO0005', 'SKU26066416', '5', '747.09'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0046', 'SO0006', 'SKU40042962', '1', '219.24'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0047', 'SO0007', 'SKU51136407', '4', '533.82'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0048', 'SO0008', 'SKU31232796', '1', '362.37'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0049', 'SO0009', 'SKU35398294', '6', '177.08'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0050', 'SO0010', 'SKU67528300', '2', '697.10'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0051', 'SO0011', 'SKU39626462', '1', '811.79'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0052', 'SO0012', 'SKU25248721', '3', '484.26'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0053', 'SO0013', 'SKU51337688', '6', '790.18'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0054', 'SO0014', 'SKU86686761', '3', '466.70'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0055', 'SO0015', 'SKU37983196', '3', '855.71'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0056', 'SO0016', 'SKU04722330', '6', '245.83'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0057', 'SO0017', 'SKU30518953', '4', '863.75'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0058', 'SO0018', 'SKU43002007', '1', '127.77'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0059', 'SO0019', 'SKU57772075', '4', '55.87'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0060', 'SO0020', 'SKU69480051', '5', '734.36'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0061', 'SO0021', 'SKU90307562', '1', '47.90'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0062', 'SO0022', 'SKU45928205', '4', '336.44'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0063', 'SO0023', 'SKU75154999', '6', '786.20'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0064', 'SO0024', 'SKU62757586', '6', '300.91'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0065', 'SO0025', 'SKU49508374', '6', '805.68'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0066', 'SO0026', 'SKU72418677', '5', '475.90'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0067', 'SO0027', 'SKU70073765', '6', '466.18'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0068', 'SO0028', 'SKU95439531', '6', '679.72'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0069', 'SO0029', 'SKU88734895', '5', '504.29'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0070', 'SO0030', 'SKU36233810', '5', '20.19'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0071', 'SO0031', 'SKU14023672', '3', '162.84'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0072', 'SO0032', 'SKU37620701', '5', '181.50'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0073', 'SO0033', 'SKU30213825', '3', '592.47'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0074', 'SO0034', 'SKU28937735', '5', '241.41'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0075', 'SO0035', 'SKU28389791', '2', '322.39'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0076', 'SO0036', 'SKU13613575', '3', '504.56'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0077', 'SO0037', 'SKU33934621', '3', '601.50'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0078', 'SO0038', 'SKU32713532', '1', '19.39'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0079', 'SO0039', 'SKU70472541', '5', '388.11'); INSERT INTO order_items ("item_id", "order_id", "商品编码", "数量", "单价") VALUES ('IT0080', 'SO0040', 'SKU78662684', '1', '474.56'); COMMIT;