-- One approval is required by default only where someone else can give it

-- (oxygenhub#64): an organisation with fewer than two members goes back to

-- none, as a personal repository has.

UPDATE repositories SET required_approvals = 0

    WHERE required_approvals = 1

      AND owner IN (

        SELECT o.name FROM organisations o

        WHERE (SELECT COUNT(*) FROM org_members m WHERE m.org_id = o.id) < 2

      );