CREATE TABLE task_desc_tab
(
  id INT(11) PRIMARY KEY NOT NULL COMMENT '自增主鍵' AUTO_INCREMENT,
  strong>taskname/strong> VARCHAR(200) NOT NULL COMMENT '任務(wù)名字',
  sqlname VARCHAR(20) NOT NULL COMMENT 'sql文件名字',
  params VARCHAR(5000) NOT NULL COMMENT '任務(wù)參數(shù),格式為一個(gè)JSON字符串',
  updatetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '更新時(shí)間',
  detail VARCHAR(3000) COMMENT '任務(wù)一些描述信息,只是備注信息作用'
)
 ENGINE = InnoDB
 DEFAULT CHARSET = utf8;

CREATE TABLE exec_plan_tab
(
  id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  strong>taskname/strong> VARCHAR(200) NOT NULL,
  startdate DATE NOT NULL,
  enddate DATE NOT NULL,
  updatetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT exec_plan_tab_task_desc_tab_taskname_fk FOREIGN KEY (taskname) REFERENCES task_desc_tab (taskname)
)
 ENGINE = InnoDB
 DEFAULT CHARSET = utf8;