1  -- Migration: Rename 'pending' status to 'found' in sites table
 2  -- Created: 2026-02-02
 3  -- Reason: Better semantic meaning - sites are "found" from SERPs, not "pending"
 4  
 5  -- Update existing sites with 'pending' status to 'found'
 6  UPDATE sites
 7  SET status = 'found'
 8  WHERE status = 'pending';
 9  
10  -- Note: Schema CHECK constraint will be updated separately in schema.sql
11  -- The constraint change requires dropping and recreating the table,
12  -- which is handled by the init-db script that uses schema.sql