update18.4.beta1.sql 1.2 KB

12345678910111213141516
  1. INSERT INTO `zt_cron` (`m`, `h`, `dom`, `mon`, `dow`, `command`, `remark`, `type`, `buildin`, `status`) VALUES ('0','*','*','*','*','moduleName=misc&methodName=cleanCache', '清理缓存文件','zentao', 1, 'normal');
  2. ALTER TABLE `zt_product`
  3. ADD `draftStories` mediumint(8) NOT NULL DEFAULT '0' AFTER `reviewer`,
  4. ADD `activeStories` mediumint(8) NOT NULL DEFAULT '0' AFTER `draftStories`,
  5. ADD `changingStories` mediumint(8) NOT NULL DEFAULT '0' AFTER `activeStories`,
  6. ADD `reviewingStories` mediumint(8) NOT NULL DEFAULT '0' AFTER `changingStories`,
  7. ADD `finishedStories` mediumint NOT NULL DEFAULT '0' AFTER `reviewingStories`,
  8. ADD `closedStories` mediumint(8) NOT NULL DEFAULT '0' AFTER `finishedStories`,
  9. ADD `totalStories` mediumint(8) NOT NULL DEFAULT '0' AFTER `closedStories`,
  10. ADD `unresolvedBugs` mediumint(8) NOT NULL DEFAULT '0' AFTER `totalStories`,
  11. ADD `closedBugs` mediumint(8) NOT NULL DEFAULT '0' AFTER `unresolvedBugs`,
  12. ADD `fixedBugs` mediumint(8) NOT NULL DEFAULT '0' AFTER `closedBugs`,
  13. ADD `totalBugs` mediumint(8) NOT NULL DEFAULT '0' AFTER `fixedBugs`,
  14. ADD `plans` mediumint(8) NOT NULL DEFAULT '0' AFTER `totalBugs`,
  15. ADD `releases` mediumint(8) NOT NULL DEFAULT '0' AFTER `plans`;