SQL

CREATE TABLE `workflow_job` (
  `job_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `job_client` varchar(64) NOT NULL,
  `job_namespace` varchar(64) NOT NULL,
  `job_reqid` varchar(64) NOT NULL,
  `job_name` varchar(64) NOT NULL,
  `job_status` varchar(64) NOT NULL,
  `job_type` varchar(64) NOT NULL,
  `job_tags` varchar(128) NOT NULL,
  `ret_stat` varchar(64) NOT NULL,
  `ret_data` text,
  `job_cost` double NOT NULL,
  `job_extra` varchar(10240) NOT NULL,
  `job_timeout` int(11) NOT NULL,
  `job_lock` varchar(64) NOT NULL,
  `job_step` int(11) NOT NULL,
  `exe_id` int(11) NOT NULL,
  `operator` varchar(64) NOT NULL,
  `is_valid` tinyint(1) NOT NULL,
  `c_time` datetime NOT NULL,
  `s_time` datetime NOT NULL,
  `e_time` datetime NOT NULL,
  `u_time` datetime NOT NULL,
  PRIMARY KEY (`job_id`),
  UNIQUE KEY `job_job_name` (`job_name`),
  KEY `job_job_client` (`job_client`),
  KEY `job_job_namespace` (`job_namespace`),
  KEY `job_job_reqid` (`job_reqid`),
  KEY `job_job_status` (`job_status`),
  KEY `job_job_type` (`job_type`),
  KEY `job_job_tags` (`job_tags`),
  KEY `job_ret_stat` (`ret_stat`),
  KEY `job_job_cost` (`job_cost`),
  KEY `job_exe_id` (`exe_id`),
  KEY `job_operator` (`operator`),
  KEY `job_is_valid` (`is_valid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `workflow_task` (
  `task_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `job_id` bigint(20) NOT NULL,
  `task_label` varchar(64) NOT NULL,
  `task_reqid` varchar(64) NOT NULL,
  `task_cmd` varchar(128) NOT NULL,
  `task_params` text,
  `task_requires` varchar(1024) NOT NULL,
  `task_provides` varchar(1024) NOT NULL,
  `task_dependencies` varchar(10240) NOT NULL,
  `task_priority` int(11) NOT NULL,
  `task_status` varchar(64) NOT NULL,
  `task_cost` double NOT NULL,
  `task_extra` text NOT NULL,
  `task_is_save` tinyint(1) NOT NULL,
  `ret_stat` varchar(64) NOT NULL,
  `ret_data` text,
  `task_retrymax` int(11) NOT NULL,
  `task_retrycount` int(11) NOT NULL,
  `task_timeout` int(11) NOT NULL,
  `c_time` datetime NOT NULL,
  `s_time` datetime NOT NULL,
  `u_time` datetime NOT NULL,
  PRIMARY KEY (`task_id`),
  KEY `task_job_id` (`job_id`),
  KEY `task_task_label` (`task_label`),
  KEY `task_task_reqid` (`task_reqid`),
  KEY `task_task_cmd` (`task_cmd`),
  KEY `task_task_status` (`task_status`),
  KEY `task_task_cost` (`task_cost`),
  KEY `task_ret_stat` (`ret_stat`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;