-- 数据库迁移
|
-- 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;
|
-- 角色数据范围
|
-- 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;
|
-- 用户数据范围
|
-- 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;
|
