Inicio Explorar Ayuda
Registro Iniciar sesión
zhengwentao
/
game-box
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Rama: master
Ramas Etiquetas
game-box
/
add_mp.sql

add_mp.sql 8.1 KB
Permalink Histórico Raw

12345678910111213141516171819202122232425 
  1. 

  2. INSERT INTO `shopyueyouhudong`.`ai_fastshop_banner` (`member_miniapp_id`, `group_id`, `open_type`, `title`, `link`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 2, 'navigate', '双12大促', '/pages/index/index', 'https://shop.yueyouhudong.com/res/0005/20211203/c4b69f7696768b102e39ef0d61a6177c.png', 0, 1638503080, 1638503080);
    3. 

  3. 

  4. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 0, 0, 0, '运动', '运动系列', '', 0, 1638501562, 1638501562);
    5. 

  5. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 0, 0, 0, '休闲', '休闲系列', '', 0, 1638501591, 1638501591);
    6. 

  6. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 0, 0, 0, '户外', '户外系列', '', 0, 1638501618, 1638501618);
    7. 

  7. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 0, 0, 0, '时尚', '时尚系列', '', 0, 1638501650, 1638501650);
    8. 

  8. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 0, 0, 0, '童装', '童装系列', '', 0, 1638501663, 1638501663);
    9. 

  9. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 5, 5, 0, '男装', '儿童男装', '', 0, 1638501707, 1638501707);
    10. 

  10. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 5, 5, 0, '女装', '儿童女装', '', 0, 1638501720, 1638501720);
    11. 

  11. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 1, 1, 0, '登山', '登山系列', '', 0, 1638501761, 1638501761);
    12. 

  12. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 1, 1, 0, '晨跑', '晨跑系列', '', 0, 1638501779, 1638501779);
    13. 

  13. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 5, 5, 0, '男鞋', '儿童男鞋', '', 0, 1638501862, 1638501862);
    14. 

  14. INSERT INTO `shopyueyouhudong`.`ai_fastshop_cate` (`member_miniapp_id`, `parent_id`, `root_id`, `types`, `title`, `name`, `picture`, `sort`, `update_time`, `create_time`) VALUES (11, 5, 5, 0, '女鞋', '儿童女鞋', '', 0, 1638501873, 1638501873);
    15. 

  15. 

  16. INSERT INTO `shopyueyouhudong`.`ai_fastshop_config` (`member_miniapp_id`, `is_pay_types`, `goodpay_tax`, `shop_types`, `regvip_price`, `regvip_level1_ratio`, `regvip_level2_ratio`, `reward_types`, `reward_nth`, `reward_ratio`, `tax`, `profit`, `shopping_name`, `shopping`, `cycle`, `message`, `payment_type`, `payment_point`, `payment_type_shop`, `payment_point_shop`, `amountlimit`, `lack_cash`, `is_priority`, `update_time`, `day_ordernum`, `sale_ordernum`, `old_users`, `rules`, `platform_ratio`, `platform_amout`, `lock_sale_day`, `num_referee_people`) VALUES (11, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '积分值', NULL, 3, '演示商城请勿下单!!!', 0, 0, 0, 0, 1000, 10000, 0, 1638519076, 5, 2, 10, NULL, 0, 0, 0, 3);
    17. 

  17. 

  18. INSERT INTO `shopyueyouhudong`.`ai_fastshop_fare` (`member_miniapp_id`, `first_weight`, `first_price`, `second_weight`, `second_price`, `update_time`) VALUES (11, 1000, 8.00, 500, 6.00, NULL);
    19. 

  19. 

  20. INSERT INTO `shopyueyouhudong`.`ai_fastshop_item` (`member_miniapp_id`, `category_id`, `category_path_id`, `is_shopping`, `is_sale`, `name`, `price`, `sell_price`, `market_price`, `cost_price`, `points`, `repoints`, `weight`, `imgs`, `img`, `content`, `sort`, `types`, `update_time`) VALUES (11, 11, '5,11', 0, 2, '晴鹿女童马丁靴2019新款英伦风秋冬加绒儿童短靴中大童网红靴子童鞋女 米白色 34码/内长21.5cm', 16000, 238.00, 288.00, 160.00, 0, 0, 0, '[\"https:\\/\\/shop.yueyouhudong.com\\/res\\/0005\\/20211203\\/ec17393d5f0daa622538e6d4d659a5eb.png\",\"https:\\/\\/shop.yueyouhudong.com\\/res\\/0005\\/20211203\\/7f3afa4d314501715a8ae29cb8b78f26.png\"]', 'https://shop.yueyouhudong.com/res/0005/20211203/ec17393d5f0daa622538e6d4d659a5eb.png', '<p>\r\n	<img class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/66760/25/13976/229164/5db486d6E2f96d8a2/74456f7ae06fbd18.jpg" /><img class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/104290/7/823/132256/5db486d6Ecb2d0c26/0f1972e9fdf6c528.jpg" /><img class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/86203/11/859/175852/5db486d6E6309a854/4d336e141593f8d3.jpg" /><img class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/81512/30/13973/160419/5db486d7E03541f7a/987f84f9ec93802e.jpg" /><img class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/77679/15/14017/140873/5db486d7E3f9bce83/d7fd32197014c36f.jpg" />\r\n</p>', NULL, 1, 1638510063);
    21. 

  21. INSERT INTO `shopyueyouhudong`.`ai_fastshop_item` (`member_miniapp_id`, `category_id`, `category_path_id`, `is_shopping`, `is_sale`, `name`, `price`, `sell_price`, `market_price`, `cost_price`, `points`, `repoints`, `weight`, `imgs`, `img`, `content`, `sort`, `types`, `update_time`) VALUES (11, 11, '5,11', 0, 2, '回力童鞋女童靴子男童加绒棉鞋儿童雪地靴 黑色 31码/内长约20厘米', 15800, 198.00, 238.00, 158.00, 0, 0, 0, '[\"https:\\/\\/shop.yueyouhudong.com\\/res\\/0005\\/20211203\\/3c901de4c5a548bee53973259911990e.png\",\"https:\\/\\/shop.yueyouhudong.com\\/res\\/0005\\/20211203\\/573c102373051158ab2643085323d410.png\"]', 'https://shop.yueyouhudong.com/res/0005/20211203/3c901de4c5a548bee53973259911990e.png', '<p>\r\n	<img id="1" alt="" class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/15552/40/1243/618421/5c106fc7Ea313a250/0d16dcf5a23c9a52.jpg" /><br />\r\n<img id="1" alt="" class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/10036/20/4849/410601/5c106fc6Eaa505f8c/7502bdcf8a05e4fe.jpg" /><br />\r\n<img id="1" alt="" class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/28991/36/1264/220680/5c106fc6E799b85b8/76e6fdc46b25bf86.jpg" /><br />\r\n<img id="1" alt="" class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/17633/11/1251/287718/5c106fc6E4b69c682/32fb222030f95e92.jpg" /><br />\r\n<img id="1" alt="" class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/7077/11/8950/397521/5c106fc6E63e99ce2/20ef85417a181d79.jpg" /><br />\r\n<img id="1" alt="" class="" src="http://img30.360buyimg.com/popWaterMark/jfs/t1/20846/10/1267/609413/5c106fc7Ed3a4a6d2/c599f74cf0fc0349.jpg" />\r\n</p>', NULL, 1, 1638502677);
    22. 

  22. 

  23. INSERT INTO `shopyueyouhudong`.`ai_fastshop_sales` (`member_miniapp_id`, `category_id`, `class_id`, `is_fusion`, `is_vip`, `is_newuser`, `types`, `title`, `item_id`, `sale_nums`, `cost_price`, `sale_price`, `market_price`, `gift`, `img`, `sort`, `start_time`, `end_time`, `update_time`) VALUES (11, 0, NULL, 0, 0, 1, 1, '优惠大放送', 1, 0, 15800, 19900, 23800, '[{\"item_id\":\"1\",\"cost_price\":15800,\"sale_price\":19900,\"market_price\":23800}]', NULL, NULL, 1638288000, 1643558400, 1638504421);
    24. 

  24. 

  25. INSERT INTO `shopyueyouhudong`.`ai_fastshop_times` (`member_miniapp_id`, `name`, `start_time`, `end_time`, `sort`) VALUES (11, '整点福利', 20, 21, 0);
    26.