-- Runner scopes (oxygenhub#41, part 2): a runner takes jobs from the whole

-- site (both empty), from one owner's repositories (scope_owner), or from

-- one repository (scope_repo_id, with its owner). Registration tokens carry

-- the scope the runner gets.

ALTER TABLE flow_runners ADD COLUMN scope_owner TEXT NOT NULL DEFAULT '';

ALTER TABLE flow_runners ADD COLUMN scope_repo_id INTEGER;

ALTER TABLE flow_runner_registrations ADD COLUMN scope_owner TEXT NOT NULL DEFAULT '';

ALTER TABLE flow_runner_registrations ADD COLUMN scope_repo_id INTEGER;