文件

8 行
218 B
SQL

ALTER TABLE "approval_rules"
ADD COLUMN "owner_self_fallback_role" "RoleCode";
UPDATE "approval_rules"
SET "owner_self_fallback_role" = 'finance_mgr'
WHERE "enabled" = true
AND "owner_self_fallback_role" IS NULL;