CREATE TABLE IF NOT EXISTS ai_trade_memory (
    id INT AUTO_INCREMENT PRIMARY KEY,
    symbol VARCHAR(20) NOT NULL,
    direction VARCHAR(20) NOT NULL,
    verdict VARCHAR(20) NOT NULL,
    entry_poi DECIMAL(20, 8),
    stop_loss DECIMAL(20, 8),
    target_1 DECIMAL(20, 8),
    target_2 DECIMAL(20, 8),
    status VARCHAR(20) DEFAULT 'ACTIVE',
    raw_analysis TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
