owl-admin/doc/系统设计/数据库设计/数据库备份/清理所有业务表数据.sql

-- Active: 1735126617549@@192.168.110.85@3306@xiaoding_dev

/**
 * 清空表数据
*/

use xiaoding_dev;
-- 禁用外键检查
SET FOREIGN_KEY_CHECKS = 0;

-- 代理相关表
TRUNCATE TABLE agent_info_records;
TRUNCATE TABLE agent_infos;
TRUNCATE TABLE agent_project;
TRUNCATE TABLE agent_project_cate;
TRUNCATE TABLE agent_real_auth_records;

-- 教练相关表
TRUNCATE TABLE coach_alerts;
TRUNCATE TABLE coach_comment_tags;
TRUNCATE TABLE coach_flow_orders;
TRUNCATE TABLE coach_info_records;
TRUNCATE TABLE coach_locations;
TRUNCATE TABLE coach_order_comment_tags;
TRUNCATE TABLE coach_order_comments;
TRUNCATE TABLE coach_project;
TRUNCATE TABLE coach_qual_records;
TRUNCATE TABLE coach_real_records;
TRUNCATE TABLE coach_schedules;
TRUNCATE TABLE coach_scores;
TRUNCATE TABLE coach_statistics;
TRUNCATE TABLE coach_users;

-- 优惠券相关表
TRUNCATE TABLE coupon_info;

-- 会员相关表
TRUNCATE TABLE member_address;
TRUNCATE TABLE member_bad_behaviors;
TRUNCATE TABLE member_social_accounts;
TRUNCATE TABLE member_users;

-- 订单相关表
TRUNCATE TABLE order_comments;
TRUNCATE TABLE order_dist_records;
TRUNCATE TABLE order_exc_records;
TRUNCATE TABLE order_grab_records;
TRUNCATE TABLE order_records;

-- 项目相关表
TRUNCATE TABLE project_cate;

-- 商店相关表
TRUNCATE TABLE shop_auth_records;
TRUNCATE TABLE shop_coach_services;
TRUNCATE TABLE shop_infos;
TRUNCATE TABLE shop_services;

-- 用户反馈表
TRUNCATE TABLE user_feedbacks;

-- 钱包相关表
TRUNCATE TABLE wallet_payment_records;
TRUNCATE TABLE wallet_refund_records;
TRUNCATE TABLE wallet_split_records;
TRUNCATE TABLE wallet_trans_records;
TRUNCATE TABLE wallet_withdraw_records;

-- 设置相关表
TRUNCATE TABLE setting_groups;

-- 启用外键检查
SET FOREIGN_KEY_CHECKS = 1;


/*
select table_name from information_schema.TABLES where `TABLE_SCHEMA` = 'xiaoding_test'
and `TABLE_NAME` like 'coach_%' and `TABLE_TYPE` = 'BASE TABLE'
or ( `TABLE_NAME` like 'agent_%' or `TABLE_NAME` like 'coupon_%' or
 `TABLE_NAME` like 'order_%' or `TABLE_NAME` like 'user_%' or `TABLE_NAME` like 'member_%'
or `TABLE_NAME` like 'project_%' or `TABLE_NAME` like 'setting_%' or `TABLE_NAME` like 'shop_%'
or `TABLE_NAME` like 'wallet_%' );
*/