conductor

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

002_ownership.sql (749B)

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