167 行
21 KiB
SQL
167 行
21 KiB
SQL
-- 酒类商品模拟数据导入脚本
|
|
-- 包含白酒、红酒、啤酒、洋酒、黄酒、果酒、保健酒、酒具配件等完整数据
|
|
|
|
-- 插入白酒商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('五粮液 52度 500ml', 9, '6901234567890', 280.00, 398.00, 368.00, 50, 100, 5, '五粮液是中国著名白酒品牌，采用五种粮食酿造，口感醇厚，香味浓郁，是商务宴请的首选。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 1),
|
|
('茅台酒 53度 500ml', 9, '6901234567891', 1200.00, 1699.00, 1599.00, 30, 50, 3, '贵州茅台酒，中国国酒，酱香型白酒的典型代表，历史悠久，品质卓越，收藏价值极高。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 2),
|
|
('剑南春 52度 500ml', 9, '6901234567892', 180.00, 268.00, 248.00, 60, 120, 5, '剑南春，浓香型白酒，口感绵甜，回味悠长，是四川名酒的代表，深受消费者喜爱。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 3),
|
|
('水井坊 52度 500ml', 9, '6901234567893', 220.00, 328.00, 298.00, 40, 80, 4, '水井坊，中国白酒鼻祖，传承千年酿酒工艺，口感醇和，香气优雅，彰显品味。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 4),
|
|
('洋河蓝色经典 52度 500ml', 9, '6901234567894', 160.00, 238.00, 218.00, 70, 140, 6, '洋河蓝色经典，绵柔型白酒开创者，口感绵柔甘甜，入口顺滑，深受消费者喜爱。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 5),
|
|
('郎酒 53度 500ml', 9, '6901234567895', 200.00, 298.00, 268.00, 45, 90, 4, '郎酒，酱香型白酒，产自四川古蔺，酒体醇厚，香味独特，品质上乘。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 6),
|
|
('泸州老窖 52度 500ml', 9, '6901234567896', 140.00, 208.00, 188.00, 80, 160, 7, '泸州老窖，浓香鼻祖，中国四大名酒之一，口感甘美，回味悠长，历史悠久。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 7),
|
|
('西凤酒 45度 500ml', 9, '6901234567897', 120.00, 178.00, 158.00, 90, 180, 8, '西凤酒，凤香型白酒代表，陕西名酒，口感清香甘润，风味独特，性价比高。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 8),
|
|
('汾酒 53度 500ml', 26, '6901234567898', 100.00, 148.00, 128.00, 100, 200, 10, '汾酒，清香型白酒典型代表，山西名酒，口感清香纯正，酒质清澈透明。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 9),
|
|
('董酒 54度 500ml', 27, '6901234567899', 180.00, 268.00, 238.00, 55, 110, 5, '董酒，酱香型白酒，贵州名酒，工艺独特，口感醇厚，具有药香特色。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 10);
|
|
|
|
-- 插入红酒商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `good_number`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('长城干红葡萄酒 750ml', 31, '6901234568001', 'HJ001', 45.00, 68.00, 58.00, 120, 240, 10, '长城干红葡萄酒，选用优质葡萄酿造，口感醇厚，果香浓郁，是国产红酒的代表品牌。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 11),
|
|
('张裕解百纳 750ml', 31, '6901234568002', 'HJ002', 55.00, 88.00, 78.00, 100, 200, 8, '张裕解百纳，中国葡萄酒知名品牌，口感平衡，单宁柔和，适合配餐饮用。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 12),
|
|
('王朝干红葡萄酒 750ml', 31, '6901234568003', 'HJ003', 35.00, 58.00, 48.00, 150, 300, 12, '王朝干红葡萄酒，口感柔顺，果香清新，性价比高，适合日常饮用。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 13),
|
|
('威龙干红葡萄酒 750ml', 31, '6901234568004', 'HJ004', 40.00, 65.00, 55.00, 130, 260, 10, '威龙干红葡萄酒，来自山东烟台，口感清爽，酸度适中，是入门级红酒的好选择。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 14),
|
|
('通化红酒 750ml', 31, '6901234568005', 'HJ005', 30.00, 48.00, 38.00, 180, 360, 15, '通化红酒，东北特色葡萄酒，口感甜润，适合不常饮酒的消费者。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 15),
|
|
('新天干红葡萄酒 750ml', 31, '6901234568006', 'HJ006', 50.00, 78.00, 68.00, 110, 220, 9, '新天干红葡萄酒，来自新疆天山北麓，日照充足，葡萄品质优良，酒体饱满。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 16),
|
|
('尼雅干红葡萄酒 750ml', 31, '6901234568007', 'HJ007', 60.00, 98.00, 88.00, 90, 180, 7, '尼雅干红葡萄酒，新疆特色红酒，口感浓郁，层次丰富，具有独特的地域风味。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 17),
|
|
('楼兰干红葡萄酒 750ml', 31, '6901234568008', 'HJ008', 65.00, 108.00, 98.00, 85, 170, 6, '楼兰干红葡萄酒，新疆吐鲁番产区，沙漠气候造就独特风味，口感醇厚甘美。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 18),
|
|
('拉菲传奇 750ml', 31, '6901234568009', 'HJ009', 180.00, 288.00, 258.00, 40, 80, 3, '拉菲传奇，法国进口红酒，口感优雅，层次丰富，是高端红酒的代表。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 19),
|
|
('奔富寇兰山 750ml', 31, '6901234568010', 'HJ010', 120.00, 198.00, 178.00, 60, 120, 4, '奔富寇兰山，澳洲进口红酒，果香浓郁，口感饱满，性价比优秀。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '750ml', 1, 1, 0, 20);
|
|
|
|
-- 插入啤酒商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `good_number`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('青岛啤酒 500ml', 39, '6901234569001', 'PJ001', 3.50, 5.50, 4.80, 500, 1000, 50, '青岛啤酒，中国啤酒知名品牌，口感清爽，泡沫丰富，是夏日消暑的好选择。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 21),
|
|
('雪花啤酒 500ml', 39, '6901234569002', 'PJ002', 3.20, 5.00, 4.50, 600, 1200, 60, '雪花啤酒，中国销量领先的啤酒品牌，口感淡爽，适合大众消费。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 22),
|
|
('燕京啤酒 500ml', 39, '6901234569003', 'PJ003', 3.30, 5.20, 4.60, 550, 1100, 55, '燕京啤酒，北京本土品牌，口感醇和，麦香浓郁，深受北方消费者喜爱。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 23),
|
|
('哈尔滨啤酒 500ml', 39, '6901234569004', 'PJ004', 3.40, 5.30, 4.70, 520, 1040, 52, '哈尔滨啤酒，东北老牌啤酒，口感清冽，具有浓郁的麦芽香味。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 24),
|
|
('珠江啤酒 500ml', 39, '6901234569005', 'PJ005', 3.10, 4.80, 4.30, 650, 1300, 65, '珠江啤酒，广东本土品牌，口感清淡，适合南方气候，是广东人的首选啤酒。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 25),
|
|
('重庆啤酒 500ml', 39, '6901234569006', 'PJ006', 3.60, 5.60, 5.00, 480, 960, 48, '重庆啤酒，西南地区知名品牌，口感浓郁，具有独特的山城风味。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 26),
|
|
('金威啤酒 500ml', 39, '6901234569007', 'PJ007', 3.80, 5.80, 5.20, 450, 900, 45, '金威啤酒，深圳本土品牌，口感醇厚，泡沫持久，是华南地区的优质啤酒。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 27),
|
|
('百威啤酒 500ml', 39, '6901234569008', 'PJ008', 6.50, 9.80, 8.80, 300, 600, 30, '百威啤酒，国际知名品牌，口感纯正，品质稳定，是进口啤酒的代表。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 28),
|
|
('喜力啤酒 500ml', 39, '6901234569009', 'PJ009', 7.20, 10.80, 9.80, 280, 560, 28, '喜力啤酒，荷兰进口，口感清爽，具有独特的苦味和香味，是高端啤酒的选择。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 29),
|
|
('嘉士伯啤酒 500ml', 39, '6901234569010', 'PJ010', 6.80, 10.20, 9.20, 320, 640, 32, '嘉士伯啤酒，丹麦进口，口感醇厚，麦香浓郁，品质优良。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 30);
|
|
|
|
-- 插入洋酒商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `good_number`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('芝华士12年 700ml', 47, '6901234570001', 'YJ001', 280.00, 428.00, 398.00, 40, 80, 3, '芝华士12年，苏格兰威士忌，口感醇厚，层次丰富，是威士忌爱好者的首选。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 31),
|
|
('杰克丹尼 700ml', 47, '6901234570002', 'YJ002', 220.00, 338.00, 308.00, 50, 100, 4, '杰克丹尼，美国田纳西威士忌，口感顺滑，香味独特，深受年轻人喜爱。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 32),
|
|
('皇家礼炮21年 700ml', 47, '6901234570003', 'YJ003', 800.00, 1288.00, 1188.00, 20, 40, 2, '皇家礼炮21年，苏格兰威士忌，陈年醇香，口感复杂，是高端威士忌的代表。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 33),
|
|
('轩尼诗XO 700ml', 48, '6901234570004', 'YJ004', 1200.00, 1888.00, 1788.00, 15, 30, 1, '轩尼诗XO，法国干邑白兰地，口感醇厚，香味浓郁，是干邑的顶级之选。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 34),
|
|
('马爹利蓝牌 700ml', 48, '6901234570005', 'YJ005', 350.00, 528.00, 488.00, 35, 70, 3, '马爹利蓝牌，法国干邑白兰地，口感柔和，果香浓郁，性价比优秀。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 35),
|
|
('人头马VSOP 700ml', 48, '6901234570006', 'YJ006', 450.00, 688.00, 638.00, 30, 60, 2, '人头马VSOP，法国干邑白兰地，口感醇厚，层次丰富，是干邑的经典之作。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 36),
|
|
('绝对伏特加 700ml', 49, '6901234570007', 'YJ007', 120.00, 188.00, 168.00, 80, 160, 6, '绝对伏特加，瑞典进口，口感纯净，是调制鸡尾酒的优质基酒。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 37),
|
|
('哥顿金酒 700ml', 50, '6901234570008', 'YJ008', 100.00, 158.00, 138.00, 90, 180, 8, '哥顿金酒，英国进口，口感清香，杜松子香味浓郁，是金酒的经典品牌。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 38),
|
|
('百加得朗姆酒 700ml', 51, '6901234570009', 'YJ009', 110.00, 168.00, 148.00, 85, 170, 7, '百加得朗姆酒，古巴风味，口感甘甜，是调制莫吉托的经典选择。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 39),
|
|
('豪帅龙舌兰 700ml', 52, '6901234570010', 'YJ010', 150.00, 238.00, 208.00, 70, 140, 5, '豪帅龙舌兰，墨西哥进口，口感独特，是调制玛格丽特的必备基酒。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '700ml', 1, 1, 0, 40);
|
|
|
|
-- 插入黄酒商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `good_number`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('古越龙山黄酒 500ml', 55, '6901234571001', 'HH001', 25.00, 38.00, 33.00, 200, 400, 15, '古越龙山黄酒，绍兴特产，口感醇厚，营养丰富，是传统黄酒的代表品牌。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 41),
|
|
('会稽山黄酒 500ml', 55, '6901234571002', 'HH002', 22.00, 35.00, 30.00, 220, 440, 18, '会稽山黄酒，绍兴老字号，工艺传统，口感甘甜，深受消费者喜爱。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 42),
|
|
('女儿红黄酒 500ml', 55, '6901234571003', 'HH003', 28.00, 42.00, 37.00, 180, 360, 12, '女儿红黄酒，绍兴名酒，历史悠久，口感醇香，是黄酒中的精品。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 43),
|
|
('塔牌黄酒 500ml', 55, '6901234571004', 'HH004', 20.00, 32.00, 28.00, 250, 500, 20, '塔牌黄酒，绍兴特产，性价比高，口感纯正，适合日常饮用。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 44),
|
|
('客家黄酒 500ml', 56, '6901234571005', 'HH005', 18.00, 28.00, 24.00, 280, 560, 25, '客家黄酒，广东特色，口感甘甜，具有浓郁的地方风味。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 45);
|
|
|
|
-- 插入果酒商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `good_number`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('梅见青梅酒 330ml', 65, '6901234572001', 'GJ001', 15.00, 25.00, 22.00, 300, 600, 25, '梅见青梅酒，口感清香甘甜，酸甜适中，是年轻人喜爱的低度果酒。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '330ml', 1, 1, 0, 46),
|
|
('苹果酒 330ml', 66, '6901234572002', 'GJ002', 12.00, 20.00, 18.00, 350, 700, 30, '苹果酒，选用优质苹果发酵，口感清爽，果香浓郁，健康美味。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '330ml', 1, 1, 0, 47),
|
|
('蓝莓酒 330ml', 69, '6901234572003', 'GJ003', 18.00, 30.00, 26.00, 250, 500, 20, '蓝莓酒，富含花青素，口感酸甜，具有很好的保健功效。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '330ml', 1, 1, 0, 48),
|
|
('樱桃酒 330ml', 68, '6901234572004', 'GJ004', 20.00, 32.00, 28.00, 220, 440, 18, '樱桃酒，选用新鲜樱桃酿造，口感甘甜，色泽诱人，营养丰富。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '330ml', 1, 1, 0, 49),
|
|
('荔枝酒 330ml', 67, '6901234572005', 'GJ005', 16.00, 26.00, 23.00, 280, 560, 22, '荔枝酒，岭南特色，口感香甜，具有浓郁的荔枝香味。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '330ml', 1, 1, 0, 50);
|
|
|
|
-- 插入保健酒商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `good_number`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('劲酒 125ml', 71, '6901234573001', 'BJ001', 8.00, 12.00, 10.50, 500, 1000, 40, '劲酒，中国保健酒知名品牌，添加多种中药材，具有保健功效。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '125ml', 1, 1, 0, 51),
|
|
('椰岛鹿龟酒 500ml', 72, '6901234573002', 'BJ002', 45.00, 68.00, 58.00, 150, 300, 12, '椰岛鹿龟酒，海南特产，添加鹿茸等名贵中药材，滋补养生。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 52),
|
|
('枸杞酒 500ml', 73, '6901234573003', 'BJ003', 35.00, 55.00, 48.00, 180, 360, 15, '枸杞酒，选用宁夏枸杞，具有明目养肝的保健功效。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 53),
|
|
('人参酒 500ml', 71, '6901234573004', 'BJ004', 80.00, 128.00, 108.00, 100, 200, 8, '人参酒，添加长白山人参，具有大补元气的功效，适合体虚者饮用。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 54),
|
|
('竹叶青酒 500ml', 78, '6901234573005', 'BJ005', 25.00, 38.00, 33.00, 200, 400, 16, '竹叶青酒，山西特产，添加竹叶等中药材，口感清香，具有保健功效。', '', 0, UNIX_TIMESTAMP(), 1, 1, '瓶', '500ml', 1, 1, 0, 55);
|
|
|
|
-- 插入酒具配件商品数据
|
|
INSERT INTO `ls_retail_goods` (`goods_name`, `goods_class_id`, `goods_code`, `good_number`, `purch_price`, `sale_price`, `vip_price`, `goods_num`, `more_num`, `less_num`, `details`, `goods_img`, `status`, `addtime`, `merchantid`, `storeid`, `company`, `specifications`, `can_exchange_weigh`, `attribute`, `serial_number_state`, `goods_brand_id`) VALUES
|
|
('水晶红酒杯套装', 79, '6901234574001', 'JJ001', 45.00, 78.00, 68.00, 80, 160, 6, '水晶红酒杯套装，6只装，材质优良，造型优雅，是品酒的必备器具。', '', 0, UNIX_TIMESTAMP(), 1, 1, '套', '6只装', 1, 1, 0, 56),
|
|
('白酒分酒器', 79, '6901234574002', 'JJ002', 25.00, 45.00, 38.00, 120, 240, 10, '白酒分酒器，陶瓷材质，古朴典雅，是白酒品鉴的专业器具。', '', 0, UNIX_TIMESTAMP(), 1, 1, '个', '1个', 1, 1, 0, 57),
|
|
('醒酒器', 81, '6901234574003', 'JJ003', 80.00, 138.00, 118.00, 60, 120, 4, '醒酒器，水晶材质，造型优美，能够充分醒酒，提升红酒口感。', '', 0, UNIX_TIMESTAMP(), 1, 1, '个', '1个', 1, 1, 0, 58),
|
|
('酒柜恒温器', 82, '6901234574004', 'JJ004', 200.00, 328.00, 288.00, 30, 60, 2, '酒柜恒温器，智能控温，保持酒类最佳储存温度，延长保质期。', '', 0, UNIX_TIMESTAMP(), 1, 1, '台', '1台', 1, 1, 0, 59),
|
|
('真空保鲜塞', 83, '6901234574005', 'JJ005', 15.00, 25.00, 22.00, 200, 400, 15, '真空保鲜塞，有效保持开瓶后红酒的新鲜度，延长保存时间。', '', 0, UNIX_TIMESTAMP(), 1, 1, '个', '1个', 1, 1, 0, 60),
|
|
('酒标收藏册', 84, '6901234574006', 'JJ006', 30.00, 48.00, 42.00, 100, 200, 8, '酒标收藏册，精美装帧，是酒类爱好者收藏酒标的理想选择。', '', 0, UNIX_TIMESTAMP(), 1, 1, '本', '1本', 1, 1, 0, 61),
|
|
('酒类礼品盒', 86, '6901234574007', 'JJ007', 20.00, 35.00, 30.00, 150, 300, 12, '酒类礼品盒，高档包装，适合节日送礼，提升酒类产品档次。', '', 0, UNIX_TIMESTAMP(), 1, 1, '个', '1个', 1, 1, 0, 62);
|
|
|
|
-- 更新商品统计信息
|
|
UPDATE `ls_retail_goods_class` SET `goods_count` = (
|
|
SELECT COUNT(*) FROM `ls_retail_goods` WHERE `goods_class_id` = `ls_retail_goods_class`.`id` AND `status` = 0
|
|
) WHERE `id` IN (9, 26, 27, 31, 39, 47, 48, 49, 50, 51, 52, 55, 56, 65, 66, 67, 68, 69, 71, 72, 73, 78, 79, 81, 82, 83, 84, 86);
|
|
|
|
-- 插入商品品牌数据
|
|
INSERT INTO `ls_retail_goods_brand` (`name`, `merchantid`, `addtime`, `state`) VALUES
|
|
('五粮液', 1, UNIX_TIMESTAMP(), 0),
|
|
('茅台', 1, UNIX_TIMESTAMP(), 0),
|
|
('剑南春', 1, UNIX_TIMESTAMP(), 0),
|
|
('水井坊', 1, UNIX_TIMESTAMP(), 0),
|
|
('洋河', 1, UNIX_TIMESTAMP(), 0),
|
|
('郎酒', 1, UNIX_TIMESTAMP(), 0),
|
|
('泸州老窖', 1, UNIX_TIMESTAMP(), 0),
|
|
('西凤酒', 1, UNIX_TIMESTAMP(), 0),
|
|
('汾酒', 1, UNIX_TIMESTAMP(), 0),
|
|
('董酒', 1, UNIX_TIMESTAMP(), 0),
|
|
('长城', 1, UNIX_TIMESTAMP(), 0),
|
|
('张裕', 1, UNIX_TIMESTAMP(), 0),
|
|
('王朝', 1, UNIX_TIMESTAMP(), 0),
|
|
('威龙', 1, UNIX_TIMESTAMP(), 0),
|
|
('通化', 1, UNIX_TIMESTAMP(), 0),
|
|
('新天', 1, UNIX_TIMESTAMP(), 0),
|
|
('尼雅', 1, UNIX_TIMESTAMP(), 0),
|
|
('楼兰', 1, UNIX_TIMESTAMP(), 0),
|
|
('拉菲', 1, UNIX_TIMESTAMP(), 0),
|
|
('奔富', 1, UNIX_TIMESTAMP(), 0),
|
|
('青岛啤酒', 1, UNIX_TIMESTAMP(), 0),
|
|
('雪花', 1, UNIX_TIMESTAMP(), 0),
|
|
('燕京', 1, UNIX_TIMESTAMP(), 0),
|
|
('哈尔滨', 1, UNIX_TIMESTAMP(), 0),
|
|
('珠江', 1, UNIX_TIMESTAMP(), 0),
|
|
('重庆啤酒', 1, UNIX_TIMESTAMP(), 0),
|
|
('金威', 1, UNIX_TIMESTAMP(), 0),
|
|
('百威', 1, UNIX_TIMESTAMP(), 0),
|
|
('喜力', 1, UNIX_TIMESTAMP(), 0),
|
|
('嘉士伯', 1, UNIX_TIMESTAMP(), 0),
|
|
('芝华士', 1, UNIX_TIMESTAMP(), 0),
|
|
('杰克丹尼', 1, UNIX_TIMESTAMP(), 0),
|
|
('皇家礼炮', 1, UNIX_TIMESTAMP(), 0),
|
|
('轩尼诗', 1, UNIX_TIMESTAMP(), 0),
|
|
('马爹利', 1, UNIX_TIMESTAMP(), 0),
|
|
('人头马', 1, UNIX_TIMESTAMP(), 0),
|
|
('绝对伏特加', 1, UNIX_TIMESTAMP(), 0),
|
|
('哥顿', 1, UNIX_TIMESTAMP(), 0),
|
|
('百加得', 1, UNIX_TIMESTAMP(), 0),
|
|
('豪帅', 1, UNIX_TIMESTAMP(), 0),
|
|
('古越龙山', 1, UNIX_TIMESTAMP(), 0),
|
|
('会稽山', 1, UNIX_TIMESTAMP(), 0),
|
|
('女儿红', 1, UNIX_TIMESTAMP(), 0),
|
|
('塔牌', 1, UNIX_TIMESTAMP(), 0),
|
|
('客家', 1, UNIX_TIMESTAMP(), 0),
|
|
('梅见', 1, UNIX_TIMESTAMP(), 0),
|
|
('果然爱', 1, UNIX_TIMESTAMP(), 0),
|
|
('蓝莓庄园', 1, UNIX_TIMESTAMP(), 0),
|
|
('樱桃园', 1, UNIX_TIMESTAMP(), 0),
|
|
('荔枝王', 1, UNIX_TIMESTAMP(), 0),
|
|
('劲酒', 1, UNIX_TIMESTAMP(), 0),
|
|
('椰岛', 1, UNIX_TIMESTAMP(), 0),
|
|
('宁夏红', 1, UNIX_TIMESTAMP(), 0),
|
|
('长白山', 1, UNIX_TIMESTAMP(), 0),
|
|
('竹叶青', 1, UNIX_TIMESTAMP(), 0),
|
|
('水晶坊', 1, UNIX_TIMESTAMP(), 0),
|
|
('陶艺轩', 1, UNIX_TIMESTAMP(), 0),
|
|
('醒酒师', 1, UNIX_TIMESTAMP(), 0),
|
|
('恒温宝', 1, UNIX_TIMESTAMP(), 0),
|
|
('保鲜王', 1, UNIX_TIMESTAMP(), 0),
|
|
('收藏家', 1, UNIX_TIMESTAMP(), 0),
|
|
('礼品汇', 1, UNIX_TIMESTAMP(), 0);
|
|
|
|
-- 完成数据导入
|
|
SELECT '酒类商品模拟数据导入完成！' AS message;
|
|
SELECT COUNT(*) AS total_goods FROM `ls_retail_goods` WHERE `status` = 0;
|
|
SELECT `class_name`, COUNT(*) AS goods_count FROM `ls_retail_goods` g
|
|
JOIN `ls_retail_goods_class` c ON g.`goods_class_id` = c.`id`
|
|
WHERE g.`status` = 0
|
|
GROUP BY g.`goods_class_id`, c.`class_name`
|
|
ORDER BY c.`id`; |