CREATE TABLE IF NOT EXISTS automation_logs (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT,
    task_code VARCHAR(80) NOT NULL,
    run_type ENUM('manual','auto') NOT NULL DEFAULT 'manual',
    result VARCHAR(20) NOT NULL,
    notes TEXT NULL,
    executed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id),
    INDEX idx_automation_logs_task (task_code),
    INDEX idx_automation_logs_run (run_type, executed_at)
);