-- Runner updates in waves (oxygenflow#84): the runner build each job ran

-- on, from its claim, to count the jobs that prove a version; and the wave

-- a test group's runners take a version in (none: after every wave).

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

ALTER TABLE runner_groups ADD COLUMN wave BIGINT;

CREATE INDEX flow_jobs_runner_version ON flow_jobs (runner_version) WHERE runner_version <> '';