2023-04-03.sql 280 字节 原文件 审查 历史 永久链接 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 -- 调整旧数据 WITH t1 AS ( SELECT evaluation_cycle.id AS cycle_id FROM evaluation_cycle WHERE deleted_at IS NOT NULL) UPDATE summary_evaluation SET deleted_at = now() FROM t1 WHERE summary_evaluation.cycle_id = t1.cycle_id