-- 表: cron_monitor_logs

DROP TABLE IF EXISTS `cron_monitor_logs`;
CREATE TABLE `cron_monitor_logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `task_name` varchar(50) NOT NULL DEFAULT '',
  `task_type` varchar(20) NOT NULL DEFAULT '',
  `status` varchar(20) NOT NULL DEFAULT 'success' COMMENT '执行状态: success/failed',
  `output` text COMMENT '执行输出',
  `execution_time` int(11) DEFAULT '0' COMMENT '执行耗时(秒)',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `task_type` (`task_type`),
  KEY `status` (`status`),
  KEY `created_at` (`created_at`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='系统监控任务执行日志';
