1234567891011121314151617181920212223242526272829303132333435 |
- SET FOREIGN_KEY_CHECKS=0;
- DROP TABLE IF EXISTS `qrtz_trigger_log`;
- CREATE TABLE `qrtz_trigger_log` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `job_name` varchar(255) NOT NULL,
- `job_cron` varchar(128) DEFAULT NULL,
- `job_class` varchar(255) DEFAULT NULL,
- `job_data` varchar(2048) DEFAULT NULL,
- `trigger_time` datetime DEFAULT NULL,
- `trigger_status` varchar(255) DEFAULT NULL,
- `trigger_msg` varchar(255) DEFAULT NULL,
- `handle_time` datetime DEFAULT NULL,
- `handle_status` varchar(255) DEFAULT NULL,
- `handle_msg` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;
|