-- Custom domains are only served once verified; unverified claims expire so they cannot squat a domain.
ALTER TABLE pages_sites ADD COLUMN domain_claimed_at INTEGER;
UPDATE pages_sites SET domain_claimed_at = updated_at WHERE custom_domain IS NOT NULL;