Add Column
Current Schema
CREATE TABLE smile_preview_embed_visitors (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
visitor_key TEXT NOT NULL,
ip_hash TEXT NOT NULL,
fingerprint_visitor_id TEXT NOT NULL,
last_job_id INTEGER,
has_completed INTEGER NOT NULL DEFAULT 0,
first_seen_at TEXT NOT NULL,
last_seen_at TEXT NOT NULL,
UNIQUE(chatbot_id, visitor_key),
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
FOREIGN KEY (last_job_id) REFERENCES smile_preview_jobs(id) ON DELETE SET NULL
)