conductor

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

002_worker_agents.sql (820B)

      1 -- 002_worker_agents.sql - capabilities per machine behind a worker token
      2 --
      3 -- Several hosts may share one token. Only feature names are stored.
      4 
      5 CREATE TABLE worker_agents (
      6   id             VARCHAR(64)  NOT NULL PRIMARY KEY,
      7   token_id       VARCHAR(64)  NOT NULL,
      8   name           VARCHAR(255) NOT NULL,
      9   arches         TEXT         NOT NULL,
     10   features       TEXT         NOT NULL,
     11   first_seen_at  BIGINT       NOT NULL,
     12   last_seen_at   BIGINT       NOT NULL,
     13   last_ip        VARCHAR(64),
     14   UNIQUE KEY idx_worker_agents_identity (token_id, name),
     15   KEY idx_worker_agents_sweep (last_seen_at),
     16   CONSTRAINT fk_worker_agents_token FOREIGN KEY (token_id) REFERENCES worker_tokens(id) ON DELETE CASCADE
     17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
     18 
     19 CREATE INDEX idx_tasks_worker ON tasks (worker_token_id, claimed_at);