conductor

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

002_worker_agents.sql (721B)

      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             TEXT   NOT NULL PRIMARY KEY,
      7   token_id       TEXT   NOT NULL REFERENCES worker_tokens(id) ON DELETE CASCADE,
      8   name           TEXT   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        TEXT
     14 );
     15 
     16 CREATE UNIQUE INDEX idx_worker_agents_identity ON worker_agents (token_id, name);
     17 CREATE INDEX idx_worker_agents_sweep ON worker_agents (last_seen_at);
     18 CREATE INDEX idx_tasks_worker ON tasks (worker_token_id, claimed_at);