Add Column
Current Schema
CREATE TABLE form_submissions_dynamic (
id INTEGER PRIMARY KEY AUTOINCREMENT,
form_id INTEGER NOT NULL,
chatbot_id INTEGER NOT NULL,
widget_connection_id INTEGER,
submission_data TEXT NOT NULL,
source TEXT DEFAULT 'website',
ip_address TEXT,
user_agent TEXT,
created_at TEXT NOT NULL,
processed INTEGER DEFAULT 0,
notes TEXT,
FOREIGN KEY (form_id) REFERENCES forms(id) ON DELETE CASCADE,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE
)