Files
FASS/2.0.0/update/2.4.1.0/01 flow_task_template.sql
2026-07-14 21:33:39 +08:00

9 lines
571 B
SQL

ALTER TABLE "flow_task_template"
ADD COLUMN "is_break" bool,
ADD COLUMN "is_preempt" bool;
UPDATE "flow_task_template" SET "is_break" = TRUE, "is_preempt" = FALSE WHERE "id" = 'Standby';
UPDATE "flow_task_template" SET "is_break" = FALSE, "is_preempt" = FALSE WHERE "id" = 'Charge';
UPDATE "flow_task_template" SET "is_break" = TRUE, "is_preempt" = TRUE WHERE "id" = 'Avoid';
UPDATE "flow_task_template" SET "is_break" = TRUE, "is_preempt" = FALSE WHERE "id" = 'Single';
UPDATE "flow_task_template" SET "is_break" = TRUE, "is_preempt" = FALSE WHERE "id" = 'Double';