Query
CREATE TABLE products (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
name TEXT NOT NULL,
description TEXT,
category TEXT,
brand TEXT,
base_price REAL,
currency TEXT DEFAULT 'EUR',
tags TEXT,
is_active INTEGER DEFAULT 1,
created_at TEXT NOT NULL,
updated_at TEXT,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE
)