Query
CREATE TABLE widget_connections (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
connection_name TEXT NOT NULL,
api_key TEXT NOT NULL UNIQUE,
status TEXT DEFAULT 'active',
created_at TEXT NOT NULL,
updated_at TEXT,
is_active INTEGER DEFAULT 1,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
UNIQUE(chatbot_id, connection_name)
)