zkxw/docs/sql/migrations/2026-09-22-purge-oa-instance-data.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`;