-- 数据库迁移
-- DELETE FROM flyway_schema_history;
-- 组织机构审批人
DELETE FROM hr_org_approver;
-- 组织机构信息
-- DELETE FROM hr_organization WHERE org_id <> 1339554696976781407;
-- 岗位信息
-- DELETE FROM hr_position;


-- 【IM业务】
-- 消息群信息
DELETE FROM im_group;
-- 消息群用户
DELETE FROM im_group_user;
-- 消息通知
DELETE FROM im_notice;
-- IM用户在线状态
DELETE FROM im_user_status;

-- 【系统设置】
-- 系统应用
-- DELETE FROM sys_app;
-- 参数配置
-- DELETE FROM sys_config;
-- 多数据源信息
-- DELETE FROM sys_database_info;
-- 字典
-- DELETE FROM sys_dict;
-- 字典类型
-- DELETE FROM sys_dict_type;
-- 业务拓展
-- DELETE FROM sys_expand;
-- 业务拓展-具体数据
-- DELETE FROM sys_expand_data;
-- 业务拓展-字段信息
-- DELETE FROM sys_expand_field;
-- 文件信息
-- DELETE FROM sys_file_info;
-- 文件存储信息
-- DELETE FROM sys_file_storage;
-- 业务分组
-- DELETE FROM sys_group;
-- 日志记录
DELETE FROM sys_log;
-- 登录记录
DELETE FROM sys_login_log;
-- 系统菜单
-- DELETE FROM sys_menu;
-- 菜单下的按钮
-- DELETE FROM sys_menu_button;
-- 菜单资源绑定
-- DELETE FROM sys_menu_resource;
-- 系统消息
-- DELETE FROM sys_message;
-- 通知管理
-- DELETE FROM sys_notice;
-- 资源
-- DELETE FROM sys_resource;
-- 系统角色
-- DELETE FROM sys_role WHERE role_id <> 1;
-- 角色数据范围
-- DELETE FROM sys_role_data_scope;
-- 角色菜单关联
-- DELETE FROM sys_role_menu;
-- 角色按钮关联
-- DELETE FROM sys_role_menu_button;
-- 角色资源关联
-- DELETE FROM sys_role_resource;
-- 短信发送记录
DELETE FROM sys_sms;
-- 常用功能的统计次数
-- DELETE FROM sys_statistics_count;
-- 常用功能列表
-- DELETE FROM sys_statistics_url;
-- 系统主题
-- DELETE FROM sys_theme;
-- 系统主题-模板
-- DELETE FROM sys_theme_template;
-- 系统主题-模板属性
-- DELETE FROM sys_theme_template_field;
-- 系统主题-模板配置关联关系
-- DELETE FROM sys_theme_template_rel;
-- 定时任务
-- DELETE FROM sys_timers;
-- 多语言
-- DELETE FROM sys_translation;

-- 系统用户
-- DELETE FROM sys_user WHERE user_id <> 1;
-- 用户数据范围
-- DELETE FROM sys_user_data_scope;
-- 用户组
-- DELETE FROM sys_user_group;
-- 用户组详情
-- DELETE FROM sys_user_group_detail;
-- 用户组织机构关联
-- DELETE FROM sys_user_org;
-- 用户角色关联
-- DELETE FROM sys_user_role;


-- 地区码表
-- DELETE FROM t_area;


-- 【基础数据】
-- banner
DELETE FROM t_banner;

-- 【咨询】
-- 合同签订记录
DELETE FROM t_contract_record;
-- 咨询师信息
DELETE FROM t_counselling_info;
-- 咨询订单信息
DELETE FROM t_counselling_order;
-- 咨询订单预约记录
DELETE FROM t_counselling_order_reservation;
-- 咨询记录信息
DELETE FROM t_counselling_reservation_record;
-- 咨询作业
DELETE FROM t_counselling_reservation_work;
-- 咨询套餐信息
DELETE FROM t_counselling_set_meal;
-- 咨询预约特殊时间配置
DELETE FROM t_counselling_special_time_config;
-- 咨询擅长领域标签表
DELETE FROM t_counselling_tag;
-- 咨询预约时间配置
DELETE FROM t_counselling_time_config;


-- 【课程】
-- 课程管理
DELETE FROM t_course;
-- 章节管理
DELETE FROM t_course_chapter;
-- 课程订单信息
DELETE FROM t_course_order;
-- 课程学习笔记
DELETE FROM t_course_study_note;
-- 课程标签
DELETE FROM t_course_tag;
-- 课程学习记录
DELETE FROM t_course_user_learned;
-- 课程章节学习进度
DELETE FROM t_couser_chapter_learning_rate;


-- 【心理测试1v1咨询】
-- 性格分析特殊时间配置
DELETE FROM t_mental_analysis_special_time_config;
-- 性格分析可预约时间
DELETE FROM t_mental_analysis_time;
-- 性格分析时间配置
DELETE FROM t_mental_analysis_time_config;
-- 性格分析预约
DELETE FROM t_mental_appointment;
-- 心理测试分类
-- DELETE FROM t_mental_test_class;
-- 心理测试选项
DELETE FROM t_mental_test_option;
-- 心理测试问题
DELETE FROM t_mental_test_question;
-- 心理测试记录
DELETE FROM t_mental_test_record;
-- 心理测试结果
DELETE FROM t_mental_test_result;
-- 心理测试结果配置
DELETE FROM t_mental_test_result_set;
-- 心理测试题库
DELETE FROM t_mental_test_topic;
-- 心理咨询1V1订单
DELETE FROM t_order_consult_one;
-- 心理测试订单
DELETE FROM t_order_mental_test;


-- 帮助
DELETE FROM t_help;

-- 心理专栏管理
DELETE FROM t_psychological_column;
-- 心理专栏阅读记录
DELETE FROM t_psychological_read;

-- 门店预约
DELETE FROM t_store_appointment;

-- 系统配置（H5、客服电话）
-- DELETE FROM t_system_set;

-- 用户评价表
DELETE FROM t_user_evaluate;
-- C端用户表
DELETE FROM toc_customer WHERE customer_id <> 1;