Add Column
Current Schema
CREATE TABLE notifications (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
conversation_id INTEGER NOT NULL,
user_id TEXT NOT NULL,
reason TEXT NOT NULL,
user_name TEXT,
user_email TEXT,
user_phone TEXT,
conversation_messages TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'pending',
created_at TEXT NOT NULL,
resolved_at TEXT,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
FOREIGN KEY (conversation_id) REFERENCES conversations(id) ON DELETE CASCADE
)