审查视图

sql/2023-03-29.sql 259 字节
tangxvhui authored
1 2 3 4 5 6 7 8 9 10 11 12 13
-- 添加summary_cycle 表字段
ALTER TABLE public.evaluation_cycle
    ADD summary_state int4 NOT NULL DEFAULT 0;

-- 初始化数据的值
UPDATE
    public.evaluation_cycle
SET
    summary_state = 1
WHERE
    time_end <= now()
    AND summary_state = 0;