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 ;
truncate table website_access_log;
truncate table store_order_ledger_acct;
truncate table integral;
truncate table store_order_cart_fee;
truncate table group_buy_batch;
truncate table account_detail;
truncate table gold_detail;
truncate table distribution_mode;
truncate table store_order_integral;
truncate table gold_detail_order;
truncate table shop_printer_log;
truncate table account;
truncate table store_order_writeoff;
truncate table asset_inventory_product;
truncate table integral_detail;
truncate table shop_sms;
truncate table shop_sms_detail;
truncate table u_user_address;
truncate table asset_inventory;
truncate table store_order_up;
truncate table gold;
truncate table payment_pool_value;
truncate table online_pay;
truncate table account_withdrawal_apply;
truncate table affiliate_withdrawal;
truncate table chain_supplier;
truncate table gold_withdrawal;
truncate table integral_withdrawal;

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;