1  -- Add email tracking fields to outreaches table
2  -- Tracks when emails are opened and clicked
3  
4  ALTER TABLE outreaches ADD COLUMN opened_at DATETIME;
5  ALTER TABLE outreaches ADD COLUMN email_id TEXT; -- Resend email ID for webhook correlation
6  
7  -- Index for querying opened emails
8  CREATE INDEX IF NOT EXISTS idx_outreaches_opened ON outreaches(opened_at);
9  CREATE INDEX IF NOT EXISTS idx_outreaches_email_id ON outreaches(email_id);