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;
  

• 订单信息、米卡信息、门店信息 ```sql 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; ```