69 lines
2.1 KiB
SQL
69 lines
2.1 KiB
SQL
-- =============================================================================
|
||
-- 清空 OA 审批「运行时实例」数据（上线前清理测试数据用）
|
||
--
|
||
-- 删除范围（物理删除）：
|
||
-- oa_instance_view_grant 评论@产生的查看授权
|
||
-- oa_instance_comment 实例评论
|
||
-- oa_relation 关联审批
|
||
-- oa_instance_event 实例操作事件
|
||
-- oa_task 待办/已办/抄送任务
|
||
-- oa_instance 审批实例
|
||
-- oa_instance_draft 发起审批草稿（非模板设计草稿）
|
||
--
|
||
-- 保留（不删除）：
|
||
-- oa_app_group / oa_app / oa_app_version 流程定义与已发布版本
|
||
-- oa_receive_account 收款账户主数据
|
||
--
|
||
-- 使用前请先备份；默认清理全部租户。若只清某一租户，取消下方 @tenant_no 注释并赋值。
|
||
-- =============================================================================
|
||
|
||
-- SET @tenant_no = 'zkxw';
|
||
|
||
START TRANSACTION;
|
||
|
||
-- 1) 评论查看授权
|
||
DELETE FROM `oa_instance_view_grant`
|
||
-- WHERE `tenant_no` = @tenant_no
|
||
;
|
||
|
||
-- 2) 实例评论
|
||
DELETE FROM `oa_instance_comment`
|
||
-- WHERE `tenant_no` = @tenant_no
|
||
;
|
||
|
||
-- 3) 关联审批
|
||
DELETE FROM `oa_relation`
|
||
-- WHERE `tenant_no` = @tenant_no
|
||
;
|
||
|
||
-- 4) 实例事件
|
||
DELETE FROM `oa_instance_event`
|
||
-- WHERE `tenant_no` = @tenant_no
|
||
;
|
||
|
||
-- 5) 审批任务
|
||
DELETE FROM `oa_task`
|
||
-- WHERE `tenant_no` = @tenant_no
|
||
;
|
||
|
||
-- 6) 审批实例
|
||
DELETE FROM `oa_instance`
|
||
-- WHERE `tenant_no` = @tenant_no
|
||
;
|
||
|
||
-- 7) 发起草稿
|
||
DELETE FROM `oa_instance_draft`
|
||
-- WHERE `tenant_no` = @tenant_no
|
||
;
|
||
|
||
COMMIT;
|
||
|
||
-- 执行后核对（期望均为 0）
|
||
SELECT 'oa_instance_view_grant' AS tbl, COUNT(*) AS cnt FROM `oa_instance_view_grant`
|
||
UNION ALL SELECT 'oa_instance_comment', COUNT(*) FROM `oa_instance_comment`
|
||
UNION ALL SELECT 'oa_relation', COUNT(*) FROM `oa_relation`
|
||
UNION ALL SELECT 'oa_instance_event', COUNT(*) FROM `oa_instance_event`
|
||
UNION ALL SELECT 'oa_task', COUNT(*) FROM `oa_task`
|
||
UNION ALL SELECT 'oa_instance', COUNT(*) FROM `oa_instance`
|
||
UNION ALL SELECT 'oa_instance_draft', COUNT(*) FROM `oa_instance_draft`;
|