CREATE INDEX IF NOT EXISTS idx_record_blobs_repo_blob
    ON record_blobs (repo_id, blob_cid);

CREATE INDEX IF NOT EXISTS idx_comms_jobs_stale_processing
    ON comms_queue (updated_at, scheduled_for, id)
    WHERE status = 'processing';

CREATE INDEX IF NOT EXISTS idx_users_lower_email
    ON users (LOWER(email))
    WHERE email IS NOT NULL;

UPDATE repos
SET record_blobs_backfilled_at = NULL;