delete from mall_app_version;
|
delete from mall_classify_one;
|
delete from mall_classify_two;
|
delete from mall_commission_settlement;
|
delete from mall_commission_settlement_month;
|
-- delete from mall_express_company;
|
delete from mall_goods;
|
delete from mall_goods_cart;
|
delete from mall_goods_detail;
|
delete from mall_goods_set;
|
delete from mall_goods_sku;
|
delete from mall_goods_spec;
|
delete from mall_goods_spec_value;
|
delete from mall_group_spec;
|
delete from mall_order;
|
delete from mall_order_detail;
|
delete from mall_order_detail_group_spec;
|
delete from mall_order_detail_group_spec_log;
|
delete from mall_order_detail_use;
|
delete from mall_order_main;
|
delete from mall_tag;
|
delete from mall_user_address;
|
delete from mall_user_collect;
|
delete from mall_user_evaluation;
|
delete from mall_user_report;
|
delete from mall_vip_equity;
|
-- delete from mem_member_grade;
|
-- delete from mem_member_grade_rule;
|
delete from mem_merchant;
|
delete from mem_merchant_bank;
|
delete from mem_uese_sales;
|
delete from mem_user where id != 1;
|
delete from mem_user_bank_detail where user_id != 1;
|
delete from mem_user_delete;
|
delete from mem_user_login;
|
delete from mem_user_relation where id != 1;
|
delete from merchant_notice;
|
-- delete from merchant_sys_menu;
|
-- delete from merchant_sys_relation;
|
-- delete from merchant_sys_role;
|
-- delete from merchant_sys_user;
|
delete from my_coupon;
|
delete from my_coupon_product;
|
delete from my_doctor;
|
delete from my_store_service;
|
delete from my_user_coupon;
|
delete from my_user_coupon_order;
|
delete from my_user_substance_coupon;
|
delete from sys_area_city;
|
-- delete from sys_dept;
|
-- delete from sys_dict;
|
delete from sys_expense;
|
delete from sys_login_log;
|
delete from sys_notice;
|
delete from sys_operation_log;
|
-- delete from sys_menu;
|
-- delete from sys_relation;
|
-- delete from sys_role;
|
-- delete from sys_user;
|
delete from system_notice;
|
-- delete from t_app_set;
|
delete from t_banner;
|
-- delete from t_city_region;
|
delete from t_feedback;
|
delete from t_notice;
|
delete from t_notice_message;
|
-- delete from t_remote_set;
|
delete from t_sms_record;
|
-- delete from t_system_set;
|
delete from t_system_set_audit;
|
