conductor

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

004_retention.sql (425B)

      1 -- 004_retention.sql - how long artifacts and logs are kept
      2 --
      3 -- See migrations/sqlite/004_retention.sql for the reasoning.
      4 
      5 ALTER TABLE projects ADD COLUMN artifact_keep_runs INTEGER;
      6 ALTER TABLE projects ADD COLUMN artifact_keep_days INTEGER;
      7 ALTER TABLE projects ADD COLUMN log_keep_days INTEGER;
      8 
      9 ALTER TABLE jobs ADD COLUMN log_expired_at BIGINT;
     10 
     11 CREATE INDEX idx_jobs_log_sweep ON jobs (log_expired_at, finished_at);