conductor

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

002_ownership.sql (629B)

      1 -- 002_ownership.sql - project ownership and run visibility (postgres)
      2 --
      3 -- See migrations/sqlite/002_ownership.sql for the reasoning.
      4 
      5 ALTER TABLE projects
      6   ADD COLUMN owner_id TEXT REFERENCES users(id) ON DELETE CASCADE,
      7   ADD COLUMN visibility TEXT NOT NULL DEFAULT 'private';
      8 
      9 ALTER TABLE worker_tokens
     10   ADD COLUMN owner_id TEXT REFERENCES users(id) ON DELETE CASCADE;
     11 
     12 ALTER TABLE runs
     13   ADD COLUMN visibility TEXT NOT NULL DEFAULT 'private';
     14 
     15 CREATE INDEX idx_projects_owner ON projects (owner_id);
     16 CREATE INDEX idx_worker_tokens_owner ON worker_tokens (owner_id);
     17 CREATE INDEX idx_runs_visibility ON runs (visibility);