Add Column
Current Schema
CREATE TABLE bulk_recipients (
id INTEGER PRIMARY KEY AUTOINCREMENT,
campaign_id INTEGER NOT NULL,
phone_number TEXT NOT NULL,
recipient_name TEXT,
custom_fields TEXT,
status TEXT DEFAULT 'pending',
error_message TEXT,
sent_at TEXT,
retry_count INTEGER DEFAULT 0,
FOREIGN KEY (campaign_id) REFERENCES bulk_campaigns(id) ON DELETE CASCADE
)