-- 0.2 升级 0.3 需要更新的 SQL 语句
CREATE TABLE `w5_timer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timer_uuid` varchar(100) NOT NULL DEFAULT '',
  `uuid` varchar(100) NOT NULL DEFAULT '',
  `type` varchar(10) NOT NULL DEFAULT '',
  `interval_type` varchar(10) NOT NULL DEFAULT '',
  `time` varchar(50) NOT NULL DEFAULT '',
  `start_date` varchar(50) NOT NULL DEFAULT '',
  `end_date` varchar(50) NOT NULL DEFAULT '',
  `jitter` int(11) NOT NULL DEFAULT '0',
  `status` int(2) NOT NULL DEFAULT '0',
  `update_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`timer_uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


ALTER TABLE `w5_workflow` 
ADD COLUMN `timer_app` varchar(100) NOT NULL DEFAULT '' AFTER `webhook_app`;