-- Environments (oxygenflow#59): the environment a job deploys to, from

-- its pipeline, so a repository's Deployments page can say what each one

-- runs.

ALTER TABLE flow_jobs ADD COLUMN environment TEXT NOT NULL DEFAULT '';

CREATE INDEX flow_jobs_environment ON flow_jobs(environment) WHERE environment != '';