-- 表: cron_monitor_stats

DROP TABLE IF EXISTS `cron_monitor_stats`;
CREATE TABLE `cron_monitor_stats` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `task_type` varchar(20) NOT NULL DEFAULT '',
  `task_name` varchar(50) NOT NULL DEFAULT '',
  `total_count` int(11) NOT NULL DEFAULT '0' COMMENT '总执行次数',
  `success_count` int(11) NOT NULL DEFAULT '0' COMMENT '成功次数',
  `fail_count` int(11) NOT NULL DEFAULT '0' COMMENT '失败次数',
  `last_run_time` datetime DEFAULT NULL COMMENT '最后执行时间',
  `last_run_status` varchar(20) DEFAULT NULL COMMENT '最后执行状态',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_type` (`task_type`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='系统监控任务统计';
