conductor

CI task system
git clone git://git.finwo.net/app/conductor
Log | Files | Refs | README | LICENSE

004_task_outputs.sql (676B)


      1 -- 004_task_outputs.sql - values a task produced while it ran
      2 --
      3 -- Written by ::set-output, read by ${{ tasks.<name>.outputs.<key> }} when a
      4 -- later task is dispatched. Sealed like project variables whether masked or
      5 -- not; masked only decides whether the value may be shown again.
      6 
      7 CREATE TABLE task_outputs (
      8   task_id     VARCHAR(64)  NOT NULL,
      9   name        VARCHAR(191) NOT NULL,
     10   value       TEXT         NOT NULL,
     11   masked      TINYINT      NOT NULL DEFAULT 1,
     12   created_at  BIGINT       NOT NULL,
     13   PRIMARY KEY (task_id, name),
     14   CONSTRAINT fk_task_outputs_task FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE
     15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;