CREATE TABLE IF NOT EXISTS ebay_notifications (
    id INT AUTO_INCREMENT PRIMARY KEY,
    notification_type VARCHAR(255) NOT NULL,
    raw_data TEXT NOT NULL,
    processed TINYINT(1) DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    processed_at TIMESTAMP NULL,
    error_message TEXT NULL,
    INDEX idx_notification_type (notification_type),
    INDEX idx_processed (processed),
    INDEX idx_created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 