-- mergefix proposals: runs default to a reviewable proposal; one-shot auto apply is explicit or a repo opt-in.

ALTER TABLE repo_mergefix_settings ADD COLUMN auto_apply INTEGER NOT NULL DEFAULT 0;

ALTER TABLE mergefix_runs ADD COLUMN mode TEXT NOT NULL DEFAULT 'auto' CHECK (mode IN ('propose', 'auto'));
ALTER TABLE mergefix_runs ADD COLUMN stale INTEGER NOT NULL DEFAULT 0;
ALTER TABLE mergefix_runs ADD COLUMN applied_by TEXT;
ALTER TABLE mergefix_runs ADD COLUMN applied_files TEXT;