-- 回滚脚本：销售台账 RB120260810001(id=94) / RB120260611001(id=97) 补录的审批记录
|
-- 生成时间：2026-09-22 来源库：36.213.90.123:11101 / product-inventory-management-rbhb
|
-- 补录内容：当时这两条台账由 Excel 导入产生，approval_status 为空、无审批实例。
|
-- 按实例 265（台账 103，已通过）的形状补了 2 实例 x (1 node + 1 task + 2 record)，
|
-- 并把 sales_ledger.approval_status 置为 '通过'。
|
-- 执行顺序：record -> task -> node -> instance -> sales_ledger（外键语义由应用维护，这里按依赖倒序删）
|
-- 注意：两个实例 id 分别为 268/269，换库执行时以 instance_no 为准
|
|
delete from approval_record
|
where instance_id in (select id from (
|
select id from approval_instance where instance_no in ('SP20260922001','SP20260922002')) t);
|
|
delete from approval_task
|
where instance_id in (select id from (
|
select id from approval_instance where instance_no in ('SP20260922001','SP20260922002')) t);
|
|
delete from approval_instance_node
|
where instance_id in (select id from (
|
select id from approval_instance where instance_no in ('SP20260922001','SP20260922002')) t);
|
|
delete from approval_instance
|
where instance_no in ('SP20260922001','SP20260922002');
|
|
-- 仅还原本次补录的两条；若期间已被人工重新走流程/驳回，不要执行下面这句
|
update sales_ledger set approval_status = null where id in (94, 97);
|
