lachang/data/测试环境清数据脚本.md

测试环境请数据 sql脚本

• 商品相关

  truncate yoshop_ad;
  truncate yoshop_custom_block_goods;
  truncate yoshop_custom_blocks;
  truncate yoshop_goods;
  truncate yoshop_goods_category_rel;
  truncate yoshop_goods_image;
  truncate yoshop_goods_service_rel;
  truncate yoshop_goods_sku;
  truncate yoshop_goods_spec_rel;
  

• 订单信息、米卡信息、门店信息

  truncate yoshop_browse_records;
  truncate yoshop_cart;
  truncate yoshop_comment;
  truncate yoshop_comment_image;
  truncate yoshop_comment_praise;
  truncate yoshop_commission_steps;
  truncate yoshop_commissions_detail;
  
  truncate yoshop_order;
  truncate yoshop_order_address;
  truncate yoshop_order_goods;
  truncate yoshop_order_goods_package;
  truncate yoshop_order_refund;
  truncate yoshop_order_refund_address;
  truncate yoshop_order_refund_his;
  truncate yoshop_order_refund_image;
  truncate yoshop_receipt;
  truncate yoshop_rice_card;
  truncate yoshop_rice_card_goods;
  truncate yoshop_rice_card_order;
  truncate yoshop_rice_card_order_remark;
  truncate yoshop_rice_card_price_values;
  truncate yoshop_shop_goods;
  truncate yoshop_shop_goods_sku;
  
  truncate yoshop_shop_identity;
  truncate yoshop_shops;
  truncate yoshop_staff_mobiles;
  
  truncate yoshop_user_rice_card;
  truncate yoshop_user_rice_card_consume;
  truncate yoshop_user_rice_card_goods;
  truncate yoshop_provider;
  truncate yoshop_category;