SQL 004_angi_interview_tcpa_match.sql

-- Add Angi interview, TCPA compliance, and match_type fields to angi_leads
-- P0: Remodeling gap plan, July 2026

-- SQLite does NOT support IF NOT EXISTS in ALTER TABLE ADD COLUMN.
-- Run each ALTER separately; use PRAGMA table_info to check before running.

ALTER TABLE angi_leads ADD COLUMN interview_qa TEXT DEFAULT NULL;
ALTER TABLE angi_leads ADD COLUMN tcpa_compliance BOOLEAN DEFAULT FALSE;
ALTER TABLE angi_leads ADD COLUMN match_type VARCHAR(50) DEFAULT '';