2023-03-24.sql 404 字节
-- summary_evaluation_value表添加字段
ALTER TABLE public.summary_evaluation_value
    ADD executor jsonb NULL;

-- 初始化旧数据的summary_evaluation_value.executor
UPDATE
    public.summary_evaluation_value
SET
    executor = public.summary_evaluation.executor
FROM
    public.summary_evaluation
WHERE
    public.summary_evaluation_value.summary_evaluation_id = public.summary_evaluation.id;