OXYGENHUB
# 4e2cad00a484 oxygenhub / crates / hub / migrations / 0026_org_approvals_need_reviewers.sql
420 B · SQL · last changed One approval by default only where someone else can give it 1 month ago source blame history raw
1 
-- One approval is required by default only where someone else can give it
2 
-- (oxygenhub#64): an organisation with fewer than two members goes back to
3 
-- none, as a personal repository has.
4 
UPDATE repositories SET required_approvals = 0
5 
    WHERE required_approvals = 1
6 
      AND owner IN (
7 
        SELECT o.name FROM organisations o
8 
        WHERE (SELECT COUNT(*) FROM org_members m WHERE m.org_id = o.id) < 2
9 
      );