radionica3d/backend/alter_db_chat.py

import db
try:
    query = """
    CREATE TABLE IF NOT EXISTS order_messages (
        id INT AUTO_INCREMENT PRIMARY KEY,
        order_id INT NOT NULL,
        user_id INT,
        is_from_admin BOOLEAN DEFAULT FALSE,
        message TEXT NOT NULL,
        is_read BOOLEAN DEFAULT FALSE,
        created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
        FOREIGN KEY (order_id) REFERENCES orders(id) ON DELETE CASCADE
    );
    """
    db.execute_commit(query)
    print("order_messages table created successfully")
except Exception as e:
    print("Error:", e)