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

-- Active: 1735094924500@@192.168.110.85@3306@xiaoding_test

/**
 * 清空表数据
*/

-- 禁用外键检查
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 member_address;
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 agent_info_records;
TRUNCATE TABLE agent_project;
TRUNCATE TABLE agent_project_cate;
TRUNCATE TABLE agent_real_auth_records;
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 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 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_%' );
*/