HC社区商城清理演示数据

测试数据不是必须要清理的，如果您没有操作数据库的能力，那么我们不建议你清理以免搞坏系统

1.0 清理店铺资产数据

delete from s_store where store_id not in ('400000000000000001','400000000000000002');
delete from s_store_staff where store_id not in ('400000000000000001','400000000000000002');
delete from s_shop ;
delete from s_shop_appraise ;
delete from s_shop_audit ;
delete from s_shop_community ;
delete from s_shop_goods ;
delete from s_shop_house ;
delete from s_shop_range ;
delete from s_shop_range_rel ;
delete from s_shop_return_address ;
delete from s_shop_type ;
delete from s_shop_vip_level ;
delete from s_shop_vip_user ;
delete from s_shop_visit ;
delete from housekeeping_type ;
delete from store_cart ;
delete from store_order ;
delete from store_order_cart ;
delete from store_order_address ;
delete from store_order_cart_event ;
delete from store_order_cart_return ;
delete from store_order_cart_return_event ;
delete from store_order_cart_send ;
delete from store_order_cart_up ;
delete from product ;
delete from product_attr ;
delete from product_category ;
delete from product_detail ;
delete from product_group ;
delete from product_group_order ;
delete from product_group_order_return ;
delete from product_h5_menu ;
delete from product_label ;
delete from product_price_rule ;
delete from product_seckill ;
delete from product_seckill_order ;
delete from product_serv_keyword ;
delete from product_spec_detail ;
delete from product_spec_value ;
delete from product_stock ;
delete from housekeeping_fee_config ;
delete from housekeeping_fee_type ;
delete from housekeeping_resource ;
delete from housekeeping_resource_fee ;
delete from housekeeping_serv ;
delete from housekeeping_serv_fee ;
delete from housekeeping_serv_pool ;
delete from housekeeping_serv_pool_user ;
delete from housekeeping_serv_user ;
delete from inout_order ;
delete from inout_order_product ;
delete from chain_inout_order ;
delete from chain_inout_order_product ;
delete from chain_product ;
delete from chain_product_detail ;
delete from chain_product_value ;
delete from asset_import_log_detail ;

2.0 删除组织架构

delete from u_user where name not in ('dev','admin');
delete from u_org;
delete from u_org_staff_rel;
delete from p_privilege_user where store_id not in ('400000000000000001','400000000000000002');
delete from c_orders;
delete from c_business;
delete from unitem_log;
delete from c_order_item;