CREATE TABLE confirmed_orders (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
conversation_id INTEGER NOT NULL,
user_id TEXT NOT NULL,
customer_name TEXT NOT NULL,
customer_phone TEXT NOT NULL,
customer_email TEXT,
customer_address TEXT,
order_items TEXT NOT NULL,
total_cost REAL NOT NULL,
currency TEXT DEFAULT 'EUR',
status TEXT DEFAULT 'pending',
created_at TEXT NOT NULL,
updated_at TEXT,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
FOREIGN KEY (conversation_id) REFERENCES conversations(id) ON DELETE CASCADE
)