conductor

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

004_retention.sql (387B)


      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
      6   ADD COLUMN artifact_keep_runs INT NULL,
      7   ADD COLUMN artifact_keep_days INT NULL,
      8   ADD COLUMN log_keep_days INT NULL;
      9 
     10 ALTER TABLE jobs
     11   ADD COLUMN log_expired_at BIGINT NULL,
     12   ADD KEY idx_jobs_log_sweep (log_expired_at, finished_at);