# 测试环境请数据 sql脚本


- 商品相关
```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;
```