CREATE TABLE `zt_account` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `provider` varchar(255) NOT NULL, `adminURI` varchar(255) NOT NULL, `account` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `extra` text NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `status` varchar(30) NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `name` (`name`), KEY `provider` (`provider`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_acl` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `objectType` char(30) NOT NULL, `objectID` mediumint(9) NOT NULL DEFAULT '0', `type` char(40) NOT NULL DEFAULT 'whitelist', `source` char(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_action` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `objectType` varchar(30) NOT NULL DEFAULT '', `objectID` mediumint(8) unsigned NOT NULL DEFAULT '0', `product` varchar(255) NOT NULL, `project` mediumint(8) unsigned NOT NULL, `execution` mediumint(8) unsigned NOT NULL, `actor` varchar(100) NOT NULL DEFAULT '', `action` varchar(80) NOT NULL DEFAULT '', `date` datetime NOT NULL, `comment` text NOT NULL, `extra` text, `read` enum('0','1') NOT NULL DEFAULT '0', `efforted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `date` (`date`), KEY `actor` (`actor`), KEY `project` (`project`), KEY `action` (`action`), KEY `objectID` (`objectID`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; CREATE TABLE `zt_api` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `product` varchar(255) NOT NULL DEFAULT '', `lib` int(10) unsigned NOT NULL DEFAULT '0', `module` int(10) unsigned NOT NULL DEFAULT '0', `title` varchar(100) NOT NULL DEFAULT '', `path` varchar(255) NOT NULL DEFAULT '', `protocol` varchar(10) NOT NULL DEFAULT '', `method` varchar(10) NOT NULL DEFAULT '', `requestType` varchar(100) NOT NULL DEFAULT '', `responseType` varchar(100) NOT NULL DEFAULT '', `status` varchar(20) NOT NULL DEFAULT '', `owner` varchar(30) NOT NULL DEFAULT '0', `desc` text, `version` smallint(5) unsigned NOT NULL DEFAULT '0', `params` text, `paramsExample` text, `responseExample` text, `response` text, `commonParams` text, `addedBy` varchar(30) NOT NULL DEFAULT '0', `addedDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL DEFAULT '0', `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_api_lib_release` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `lib` int(10) unsigned NOT NULL DEFAULT '0', `desc` varchar(255) NOT NULL DEFAULT '', `version` varchar(255) NOT NULL DEFAULT '', `snap` mediumtext NOT NULL, `addedBy` varchar(30) NOT NULL DEFAULT '0', `addedDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_apispec` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `doc` int(10) unsigned NOT NULL DEFAULT '0', `module` int(10) unsigned NOT NULL DEFAULT '0', `title` varchar(100) NOT NULL DEFAULT '', `path` varchar(255) NOT NULL DEFAULT '', `protocol` varchar(10) NOT NULL DEFAULT '', `method` varchar(10) NOT NULL DEFAULT '', `requestType` varchar(100) NOT NULL DEFAULT '', `responseType` varchar(100) NOT NULL DEFAULT '', `status` varchar(20) NOT NULL DEFAULT '', `owner` varchar(255) NOT NULL DEFAULT '0', `desc` text, `version` smallint(5) unsigned NOT NULL DEFAULT '0', `params` text, `paramsExample` text, `responseExample` text, `response` text, `addedBy` varchar(30) NOT NULL DEFAULT '0', `addedDate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_apistruct` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `lib` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(30) NOT NULL DEFAULT '', `type` varchar(50) NOT NULL DEFAULT '', `desc` varchar(255) NOT NULL DEFAULT '', `version` smallint(5) unsigned NOT NULL DEFAULT '0', `attribute` text, `addedBy` varchar(30) NOT NULL DEFAULT '0', `addedDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL DEFAULT '0', `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_apistruct_spec` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `type` varchar(50) NOT NULL DEFAULT '', `desc` varchar(255) NOT NULL DEFAULT '', `attribute` text, `version` smallint(5) unsigned NOT NULL DEFAULT '0', `addedBy` varchar(30) NOT NULL DEFAULT '0', `addedDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_asset` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `status` varchar(30) NOT NULL, `type` varchar(30) NOT NULL, `group` varchar(128) NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_attend` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `date` date NOT NULL, `signIn` time NOT NULL, `signOut` time NOT NULL, `status` varchar(30) NOT NULL DEFAULT '', `ip` varchar(15) NOT NULL, `device` varchar(30) NOT NULL, `client` varchar(20) NOT NULL, `manualIn` time NOT NULL, `manualOut` time NOT NULL, `reason` varchar(30) NOT NULL DEFAULT '', `desc` text NOT NULL, `reviewStatus` varchar(30) NOT NULL DEFAULT '', `reviewedBy` char(30) NOT NULL, `reviewedDate` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `attend` (`date`,`account`), KEY `account` (`account`), KEY `date` (`date`), KEY `status` (`status`), KEY `reason` (`reason`), KEY `reviewStatus` (`reviewStatus`), KEY `reviewedBy` (`reviewedBy`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; CREATE TABLE `zt_attendstat` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `month` char(10) NOT NULL DEFAULT '', `normal` decimal(12,2) NOT NULL DEFAULT 0.00, `late` decimal(12,2) NOT NULL DEFAULT 0.00, `early` decimal(12,2) NOT NULL DEFAULT 0.00, `absent` decimal(12,2) NOT NULL DEFAULT 0.00, `trip` decimal(12,2) NOT NULL DEFAULT 0.00, `egress` decimal(12,2) NOT NULL DEFAULT 0.00, `lieu` decimal(12,2) NOT NULL DEFAULT 0.00, `paidLeave` decimal(12,2) NOT NULL DEFAULT 0.00, `unpaidLeave` decimal(12,2) NOT NULL DEFAULT 0.00, `timeOvertime` decimal(12,2) NOT NULL DEFAULT 0.00, `restOvertime` decimal(12,2) NOT NULL DEFAULT 0.00, `holidayOvertime` decimal(12,2) NOT NULL DEFAULT 0.00, `deserve` decimal(12,2) NOT NULL DEFAULT 0.00, `actual` decimal(12,2) NOT NULL DEFAULT 0.00, `status` char(30) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `attend` (`month`,`account`), KEY `account` (`account`), KEY `month` (`month`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_baseimage` ( `id` smallint(7) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `path` varchar(255) NOT NULL DEFAULT '', `osType` varchar(50) NOT NULL DEFAULT '', `os` varchar(50) NOT NULL DEFAULT '', `osCategory` varchar(50) NOT NULL DEFAULT '', `osArch` varchar(50) NOT NULL DEFAULT '', `osLang` varchar(50) NOT NULL DEFAULT '', `suggestCore` tinyint(1) unsigned NOT NULL DEFAULT '0', `suggestMemory` mediumint(6) unsigned NOT NULL DEFAULT '0', `suggestVolume` mediumint(6) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_baseimagebrowser` ( `vmBackingID` int(10) NOT NULL, `browserID` int(10) NOT NULL, PRIMARY KEY (`vmBackingID`,`browserID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_block` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `module` varchar(20) NOT NULL, `type` char(30) NOT NULL, `title` varchar(100) NOT NULL, `source` varchar(20) NOT NULL, `block` varchar(20) NOT NULL, `params` text NOT NULL, `order` tinyint(3) unsigned NOT NULL DEFAULT '0', `grid` tinyint(3) unsigned NOT NULL DEFAULT '0', `height` smallint(5) unsigned NOT NULL DEFAULT '0', `hidden` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `account_module_type_order` (`account`,`module`,`type`,`order`), KEY `account` (`account`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; CREATE TABLE `zt_branch` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `product` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL, `default` enum('0','1') NOT NULL DEFAULT '0', `status` enum('active','closed') NOT NULL DEFAULT 'active', `desc` varchar(255) NOT NULL, `createdDate` date NOT NULL, `closedDate` date NOT NULL, `order` smallint(5) unsigned NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_browser` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL DEFAULT '', `type` varchar(255) NOT NULL DEFAULT '', `version` varchar(255) NOT NULL DEFAULT '', `lang` varchar(255) NOT NULL DEFAULT '', `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_bug` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL DEFAULT '0', `branch` mediumint(8) unsigned NOT NULL DEFAULT '0', `module` mediumint(8) unsigned NOT NULL DEFAULT '0', `execution` mediumint(8) unsigned NOT NULL DEFAULT '0', `plan` mediumint(8) unsigned NOT NULL DEFAULT '0', `story` mediumint(8) unsigned NOT NULL DEFAULT '0', `storyVersion` smallint(6) NOT NULL DEFAULT '1', `task` mediumint(8) unsigned NOT NULL DEFAULT '0', `toTask` mediumint(8) unsigned NOT NULL DEFAULT '0', `toStory` mediumint(8) NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL, `keywords` varchar(255) NOT NULL, `severity` tinyint(4) NOT NULL DEFAULT '0', `pri` tinyint(3) unsigned NOT NULL, `type` varchar(30) NOT NULL DEFAULT '', `os` varchar(30) NOT NULL DEFAULT '', `browser` varchar(30) NOT NULL DEFAULT '', `hardware` varchar(30) NOT NULL, `found` varchar(30) NOT NULL DEFAULT '', `steps` text NOT NULL, `status` enum('active','resolved','closed') NOT NULL DEFAULT 'active', `subStatus` varchar(30) NOT NULL DEFAULT '', `color` char(7) NOT NULL, `confirmed` tinyint(1) NOT NULL DEFAULT '0', `activatedCount` smallint(6) NOT NULL, `activatedDate` datetime NOT NULL, `feedbackBy` varchar(100) NOT NULL, `notifyEmail` varchar(100) NOT NULL, `mailto` text, `openedBy` varchar(30) NOT NULL DEFAULT '', `openedDate` datetime NOT NULL, `openedBuild` varchar(255) NOT NULL, `assignedTo` varchar(30) NOT NULL DEFAULT '', `assignedDate` datetime NOT NULL, `deadline` date NOT NULL, `resolvedBy` varchar(30) NOT NULL DEFAULT '', `resolution` varchar(30) NOT NULL DEFAULT '', `resolvedBuild` varchar(30) NOT NULL DEFAULT '', `resolvedDate` datetime NOT NULL, `closedBy` varchar(30) NOT NULL DEFAULT '', `closedDate` datetime NOT NULL, `duplicateBug` mediumint(8) unsigned NOT NULL, `linkBug` varchar(255) NOT NULL, `case` mediumint(8) unsigned NOT NULL, `caseVersion` smallint(6) NOT NULL DEFAULT '1', `feedback` mediumint(8) unsigned NOT NULL DEFAULT '0', `result` mediumint(8) unsigned NOT NULL, `repo` mediumint(8) unsigned NOT NULL, `mr` mediumint(8) unsigned NOT NULL, `entry` varchar(255) NOT NULL, `lines` varchar(10) NOT NULL, `v1` varchar(40) NOT NULL, `v2` varchar(40) NOT NULL, `repoType` varchar(30) NOT NULL DEFAULT '', `testtask` mediumint(8) unsigned NOT NULL, `lastEditedBy` varchar(30) NOT NULL DEFAULT '', `lastEditedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `execution` (`execution`), KEY `status` (`status`), KEY `plan` (`plan`), KEY `story` (`story`), KEY `case` (`case`), KEY `toStory` (`toStory`), KEY `result` (`result`), KEY `assignedTo` (`assignedTo`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_build` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL DEFAULT '0', `branch` mediumint(8) unsigned NOT NULL DEFAULT '0', `execution` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` char(150) NOT NULL, `scmPath` char(255) NOT NULL, `filePath` char(255) NOT NULL, `date` date NOT NULL, `stories` text NOT NULL, `bugs` text NOT NULL, `builder` char(30) NOT NULL DEFAULT '', `desc` text NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `execution` (`execution`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_burn` ( `execution` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `task` mediumint(8) unsigned NOT NULL DEFAULT '0', `date` date NOT NULL, `estimate` float NOT NULL, `left` float NOT NULL, `consumed` float NOT NULL, `storyPoint` float NOT NULL, PRIMARY KEY (`execution`,`date`,`task`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_case` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL DEFAULT '0', `execution` mediumint(8) unsigned NOT NULL, `branch` mediumint(8) unsigned NOT NULL DEFAULT '0', `lib` mediumint(8) unsigned NOT NULL DEFAULT '0', `module` mediumint(8) unsigned NOT NULL DEFAULT '0', `path` mediumint(8) unsigned NOT NULL DEFAULT '0', `story` mediumint(30) unsigned NOT NULL DEFAULT '0', `storyVersion` smallint(6) NOT NULL DEFAULT '1', `title` varchar(255) NOT NULL, `precondition` text NOT NULL, `keywords` varchar(255) NOT NULL, `pri` tinyint(3) unsigned NOT NULL DEFAULT '3', `type` char(30) NOT NULL DEFAULT '1', `auto` varchar(10) NOT NULL DEFAULT 'no', `frame` varchar(10) NOT NULL, `stage` varchar(255) NOT NULL, `howRun` varchar(30) NOT NULL, `scriptedBy` varchar(30) NOT NULL, `scriptedDate` date NOT NULL, `scriptStatus` varchar(30) NOT NULL, `scriptLocation` varchar(255) NOT NULL, `status` char(30) NOT NULL DEFAULT '1', `subStatus` varchar(30) NOT NULL DEFAULT '', `color` char(7) NOT NULL, `frequency` enum('1','2','3') NOT NULL DEFAULT '1', `order` tinyint(30) unsigned NOT NULL DEFAULT '0', `openedBy` char(30) NOT NULL DEFAULT '', `openedDate` datetime NOT NULL, `reviewedBy` varchar(255) NOT NULL, `reviewedDate` date NOT NULL, `lastEditedBy` char(30) NOT NULL DEFAULT '', `lastEditedDate` datetime NOT NULL, `version` tinyint(3) unsigned NOT NULL DEFAULT '0', `linkCase` varchar(255) NOT NULL, `fromBug` mediumint(8) unsigned NOT NULL, `fromCaseID` mediumint(8) unsigned NOT NULL, `fromCaseVersion` mediumint(8) unsigned NOT NULL DEFAULT '1', `deleted` enum('0','1') NOT NULL DEFAULT '0', `lastRunner` varchar(30) NOT NULL, `lastRunDate` datetime NOT NULL, `lastRunResult` char(30) NOT NULL, PRIMARY KEY (`id`), KEY `product` (`product`), KEY `story` (`story`), KEY `fromBug` (`fromBug`), KEY `module` (`module`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_casestep` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `parent` mediumint(8) unsigned NOT NULL DEFAULT '0', `case` mediumint(8) unsigned NOT NULL DEFAULT '0', `version` smallint(3) unsigned NOT NULL DEFAULT '0', `type` varchar(10) NOT NULL DEFAULT 'step', `desc` text NOT NULL, `expect` text NOT NULL, PRIMARY KEY (`id`), KEY `case` (`case`), KEY `version` (`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_company` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` char(120) DEFAULT NULL, `phone` char(20) DEFAULT NULL, `fax` char(20) DEFAULT NULL, `address` char(120) DEFAULT NULL, `zipcode` char(10) DEFAULT NULL, `website` char(120) DEFAULT NULL, `backyard` char(120) DEFAULT NULL, `guest` enum('1','0') NOT NULL DEFAULT '0', `admins` char(255) DEFAULT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; CREATE TABLE `zt_compile` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `job` mediumint(8) unsigned NOT NULL, `queue` mediumint(8) NOT NULL, `status` varchar(255) NOT NULL, `logs` text, `atTime` varchar(10) NOT NULL, `testtask` mediumint(8) unsigned NOT NULL, `tag` varchar(255) NOT NULL, `times` tinyint(3) unsigned NOT NULL DEFAULT '0', `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `updateDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_config` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `owner` char(30) NOT NULL DEFAULT '', `module` varchar(30) NOT NULL, `section` char(30) NOT NULL DEFAULT '', `key` char(30) NOT NULL DEFAULT '', `value` longtext NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique` (`owner`,`module`,`section`,`key`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8; CREATE TABLE `zt_cron` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `m` varchar(20) NOT NULL, `h` varchar(20) NOT NULL, `dom` varchar(20) NOT NULL, `mon` varchar(20) NOT NULL, `dow` varchar(20) NOT NULL, `command` text NOT NULL, `remark` varchar(255) NOT NULL, `type` varchar(20) NOT NULL, `buildin` tinyint(1) NOT NULL DEFAULT '0', `status` varchar(20) NOT NULL, `lastTime` datetime NOT NULL, PRIMARY KEY (`id`), KEY `lastTime` (`lastTime`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; CREATE TABLE `zt_deploy` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `begin` datetime NOT NULL, `end` datetime NOT NULL, `name` varchar(255) NOT NULL, `desc` text NOT NULL, `status` varchar(20) NOT NULL, `owner` char(30) NOT NULL, `members` text NOT NULL, `notify` text NOT NULL, `cases` text NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `result` varchar(20) NOT NULL, `deleted` enum('0','1') NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_deployproduct` ( `deploy` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `release` mediumint(8) unsigned NOT NULL, `package` varchar(255) NOT NULL, UNIQUE KEY `deploy_product_release` (`deploy`,`product`,`release`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_deployscope` ( `deploy` mediumint(8) unsigned NOT NULL, `service` mediumint(8) unsigned NOT NULL, `hosts` text NOT NULL, `remove` text NOT NULL, `add` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_deploystep` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `deploy` mediumint(8) unsigned NOT NULL, `title` varchar(255) NOT NULL, `begin` datetime NOT NULL, `end` datetime NOT NULL, `stage` varchar(30) NOT NULL, `content` text NOT NULL, `status` varchar(30) NOT NULL, `assignedTo` char(30) NOT NULL, `assignedDate` datetime NOT NULL, `finishedBy` char(30) NOT NULL, `finishedDate` datetime NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_dept` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` char(60) NOT NULL, `parent` mediumint(8) unsigned NOT NULL DEFAULT '0', `path` char(255) NOT NULL DEFAULT '', `grade` tinyint(3) unsigned NOT NULL DEFAULT '0', `order` smallint(4) unsigned NOT NULL DEFAULT '0', `position` char(30) NOT NULL DEFAULT '', `function` char(255) NOT NULL DEFAULT '', `manager` char(30) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `parent` (`parent`), KEY `path` (`path`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_design` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` varchar(255) NOT NULL, `product` varchar(255) NOT NULL, `commit` text NOT NULL, `commitedBy` varchar(30) NOT NULL, `execution` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL, `status` varchar(30) NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `assignedTo` varchar(30) NOT NULL, `assignedBy` varchar(30) NOT NULL, `assignedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', `story` char(30) NOT NULL, `desc` text NOT NULL, `version` smallint(6) NOT NULL, `type` char(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_designspec` ( `design` mediumint(8) NOT NULL, `version` smallint(6) NOT NULL, `name` varchar(255) NOT NULL, `desc` text NOT NULL, `files` varchar(255) NOT NULL, UNIQUE KEY `design` (`design`,`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_doc` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `execution` mediumint(8) unsigned NOT NULL, `lib` varchar(30) NOT NULL, `module` varchar(30) NOT NULL, `title` varchar(255) NOT NULL, `keywords` varchar(255) NOT NULL, `type` varchar(30) NOT NULL, `parent` smallint(5) unsigned NOT NULL DEFAULT '0', `path` char(255) NOT NULL DEFAULT '', `grade` tinyint(3) unsigned NOT NULL DEFAULT '0', `order` smallint(5) unsigned NOT NULL DEFAULT '0', `views` smallint(5) unsigned NOT NULL, `draft` longtext NOT NULL, `collector` text NOT NULL, `addedBy` varchar(30) NOT NULL, `addedDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `mailto` text, `acl` varchar(10) NOT NULL DEFAULT 'open', `groups` varchar(255) NOT NULL, `users` text NOT NULL, `version` smallint(5) unsigned NOT NULL DEFAULT '1', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `execution` (`execution`), KEY `lib` (`lib`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_doccontent` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `doc` mediumint(8) unsigned NOT NULL, `title` varchar(255) NOT NULL, `digest` varchar(255) NOT NULL, `content` longtext NOT NULL, `files` text NOT NULL, `type` varchar(10) NOT NULL, `version` smallint(5) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `doc_version` (`doc`,`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_doclib` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(30) NOT NULL, `product` mediumint(8) unsigned NOT NULL, `project` mediumint(8) unsigned NOT NULL, `execution` mediumint(8) unsigned NOT NULL, `name` varchar(60) NOT NULL, `baseUrl` varchar(255) NOT NULL DEFAULT '', `acl` varchar(10) NOT NULL DEFAULT 'open', `groups` varchar(255) NOT NULL, `users` text NOT NULL, `main` enum('0','1') NOT NULL DEFAULT '0', `collector` text NOT NULL, `desc` text NOT NULL, `order` tinyint(5) unsigned NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `execution` (`execution`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_domain` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `domain` varchar(255) NOT NULL, `adminURI` varchar(255) NOT NULL, `resolverURI` varchar(255) NOT NULL, `register` varchar(255) NOT NULL, `expiredDate` datetime NOT NULL, `renew` varchar(255) NOT NULL, `account` varchar(255) NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `domain` (`domain`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_effort` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `objectType` varchar(30) NOT NULL, `objectID` mediumint(8) unsigned NOT NULL, `product` varchar(255) NOT NULL, `project` mediumint(8) unsigned NOT NULL, `execution` mediumint(8) unsigned NOT NULL, `account` varchar(30) NOT NULL, `work` text, `date` date NOT NULL, `left` float NOT NULL, `consumed` float NOT NULL, `begin` smallint(4) unsigned zerofill NOT NULL, `end` smallint(4) unsigned zerofill NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `execution` (`execution`), KEY `objectID` (`objectID`), KEY `date` (`date`), KEY `account` (`account`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_entry` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `account` varchar(30) NOT NULL DEFAULT '', `code` varchar(20) NOT NULL, `key` varchar(32) NOT NULL, `freePasswd` enum('0','1') NOT NULL DEFAULT '0', `ip` varchar(100) NOT NULL, `desc` text NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `calledTime` int(10) unsigned NOT NULL DEFAULT '0', `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_expect` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `userID` mediumint(8) NOT NULL, `project` mediumint(8) NOT NULL DEFAULT '0', `expect` text NOT NULL, `progress` text NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` date NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_extension` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `code` varchar(30) NOT NULL, `version` varchar(50) NOT NULL, `author` varchar(100) NOT NULL, `desc` text NOT NULL, `license` text NOT NULL, `type` varchar(20) NOT NULL DEFAULT 'extension', `site` varchar(150) NOT NULL, `zentaoCompatible` varchar(100) NOT NULL, `installedTime` datetime NOT NULL, `depends` varchar(100) NOT NULL, `dirs` mediumtext NOT NULL, `files` mediumtext NOT NULL, `status` varchar(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`), KEY `name` (`name`), KEY `installedTime` (`installedTime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_faq` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `module` mediumint(9) NOT NULL, `product` mediumint(9) NOT NULL, `question` varchar(255) NOT NULL, `answer` text NOT NULL, `addedtime` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_feedback` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `product` mediumint(8) unsigned NOT NULL, `module` mediumint(8) unsigned NOT NULL, `title` varchar(255) NOT NULL, `type` char(30) NOT NULL, `solution` char(30) NOT NULL, `desc` text NOT NULL, `status` varchar(30) NOT NULL, `subStatus` varchar(30) NOT NULL DEFAULT '', `public` enum('0','1') NOT NULL DEFAULT '0', `notify` enum('0','1') NOT NULL DEFAULT '0', `notifyEmail` varchar(100) NOT NULL, `likes` text NOT NULL, `result` mediumint(8) unsigned NOT NULL, `faq` mediumint(8) unsigned NOT NULL, `openedBy` char(30) NOT NULL, `openedDate` datetime NOT NULL, `reviewedBy` varchar(255) NOT NULL, `reviewedDate` datetime NOT NULL, `processedBy` char(30) NOT NULL, `processedDate` datetime NOT NULL, `closedBy` char(30) NOT NULL, `closedDate` datetime NOT NULL, `closedReason` varchar(30) NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` datetime NOT NULL, `assignedTo` varchar(255) NOT NULL, `assignedDate` datetime NOT NULL, `feedbackBy` varchar(100) NOT NULL, `mailto` varchar(255) NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_feedbackview` ( `account` char(30) NOT NULL, `product` mediumint(8) unsigned NOT NULL, UNIQUE KEY `account_product` (`account`,`product`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_file` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `pathname` char(100) NOT NULL, `title` char(255) NOT NULL, `extension` char(30) NOT NULL, `size` int(10) unsigned NOT NULL DEFAULT '0', `objectType` char(30) NOT NULL, `objectID` mediumint(9) NOT NULL, `addedBy` char(30) NOT NULL DEFAULT '', `addedDate` datetime NOT NULL, `downloads` mediumint(8) unsigned NOT NULL DEFAULT '0', `extra` varchar(255) NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `objectType` (`objectType`), KEY `objectID` (`objectID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_group` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` char(30) NOT NULL, `role` char(30) NOT NULL DEFAULT '', `desc` char(255) NOT NULL DEFAULT '', `acl` text, `developer` enum('0','1') NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; CREATE TABLE `zt_grouppriv` ( `group` mediumint(8) unsigned NOT NULL DEFAULT '0', `module` char(30) NOT NULL DEFAULT '', `method` char(30) NOT NULL DEFAULT '', UNIQUE KEY `group` (`group`,`module`,`method`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_history` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `action` mediumint(8) unsigned NOT NULL DEFAULT '0', `field` varchar(30) NOT NULL DEFAULT '', `old` text NOT NULL, `new` text NOT NULL, `diff` mediumtext NOT NULL, PRIMARY KEY (`id`), KEY `action` (`action`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_holiday` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `type` enum('holiday','working') NOT NULL DEFAULT 'holiday', `desc` text NOT NULL, `year` char(4) NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, PRIMARY KEY (`id`), KEY `year` (`year`), KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_host` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `assetID` mediumint(8) unsigned NOT NULL, `admin` smallint(5) unsigned NOT NULL DEFAULT '0', `serverRoom` mediumint(8) unsigned NOT NULL, `cabinet` varchar(128) NOT NULL, `serverModel` varchar(256) NOT NULL, `hardwareType` varchar(64) NOT NULL, `hostType` enum('physical','virtual') NOT NULL, `cpuBrand` varchar(128) NOT NULL, `cpuModel` varchar(128) NOT NULL, `cpuNumber` varchar(16) NOT NULL, `cpuCores` varchar(30) NOT NULL, `cpuRate` varchar(30) NOT NULL, `memory` varchar(30) NOT NULL, `diskType` varchar(30) NOT NULL, `diskSize` varchar(30) NOT NULL, `unit` enum('GB','TB') NOT NULL DEFAULT 'GB', `privateIP` varchar(128) NOT NULL, `publicIP` varchar(128) NOT NULL, `nic` varchar(128) NOT NULL, `mac` varchar(128) NOT NULL, `osName` varchar(64) NOT NULL, `osVersion` varchar(64) NOT NULL, `webserver` varchar(128) NOT NULL, `database` varchar(128) NOT NULL, `language` varchar(16) NOT NULL, `status` varchar(50) NOT NULL, `agentPort` varchar(10) NOT NULL, `instanceNum` tinyint(4) NOT NULL DEFAULT '0', `pri` smallint(5) unsigned NOT NULL DEFAULT '0', `heartbeatTime` datetime NOT NULL, `tags` varchar(50) NOT NULL DEFAULT '', `provider` varchar(255) NOT NULL DEFAULT '', `bridgeID` varchar(255) NOT NULL DEFAULT '', `cloudKey` varchar(255) NOT NULL DEFAULT '', `cloudSecret` varchar(255) NOT NULL DEFAULT '', `cloudRegion` varchar(255) NOT NULL DEFAULT '', `cloudNamespace` varchar(255) NOT NULL DEFAULT '', `cloudUser` varchar(255) NOT NULL DEFAULT '', `cloudAccount` varchar(255) NOT NULL DEFAULT '', `cloudPassword` varchar(255) NOT NULL DEFAULT '', `couldVPC` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_job` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `repo` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `frame` varchar(20) NOT NULL, `engine` varchar(20) NOT NULL, `server` mediumint(8) unsigned NOT NULL, `pipeline` varchar(500) NOT NULL, `triggerType` varchar(255) NOT NULL, `sonarqubeServer` mediumint(8) unsigned NOT NULL, `projectKey` varchar(255) NOT NULL, `svnDir` varchar(255) NOT NULL, `atDay` varchar(255) DEFAULT NULL, `atTime` varchar(10) DEFAULT NULL, `customParam` text NOT NULL, `comment` varchar(255) DEFAULT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `lastExec` datetime DEFAULT NULL, `lastStatus` varchar(255) DEFAULT NULL, `lastTag` varchar(255) DEFAULT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanban` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `space` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL, `owner` varchar(30) NOT NULL, `team` text NOT NULL, `desc` text NOT NULL, `acl` char(30) NOT NULL DEFAULT 'open', `whitelist` text NOT NULL, `archived` enum('0','1') NOT NULL DEFAULT '0', `performable` enum ('0', '1') NOT NULL DEFAULT '0', `status` enum('active','closed') NOT NULL DEFAULT 'active', `order` smallint(6) NOT NULL DEFAULT '0', `displayCards` smallint(6) NOT NULL default '0', `fluidBoard` enum('0','1') NOT NULL DEFAULT '0', `object` varchar(255) NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `lastEditedBy` char(30) NOT NULL, `lastEditedDate` datetime NOT NULL, `closedBy` char(30) NOT NULL, `closedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanbancard` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `kanban` mediumint(8) unsigned NOT NULL, `region` mediumint(8) unsigned NOT NULL, `group` mediumint(8) unsigned NOT NULL, `fromID` mediumint(8) unsigned NOT NULL, `fromType` varchar(30) NOT NULL, `name` varchar(255) NOT NULL, `status` varchar(30) NOT NULL DEFAULT 'doing', `pri` mediumint(8) unsigned NOT NULL, `assignedTo` text NOT NULL, `desc` text NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `estimate` float unsigned NOT NULL, `color` char(7) NOT NULL, `acl` char(30) NOT NULL DEFAULT 'open', `whitelist` text NOT NULL, `order` smallint(6) NOT NULL DEFAULT '0', `archived` enum('0','1') NOT NULL DEFAULT '0', `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `lastEditedBy` char(30) NOT NULL, `lastEditedDate` datetime NOT NULL, `archivedBy` char(30) NOT NULL, `archivedDate` datetime NOT NULL, `assignedBy` char(30) NOT NULL, `assignedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanbancell` ( `id` int(8) NOT NULL AUTO_INCREMENT, `kanban` mediumint(8) NOT NULL, `lane` mediumint(8) NOT NULL, `column` mediumint(8) NOT NULL, `type` char(30) NOT NULL, `cards` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `card_group` (`kanban`,`type`,`lane`,`column`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanbancolumn` ( `id` int(8) NOT NULL AUTO_INCREMENT, `parent` mediumint(8) NOT NULL DEFAULT '0', `type` char(30) NOT NULL, `region` mediumint(8) unsigned NOT NULL, `group` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `color` char(30) NOT NULL, `limit` smallint(6) NOT NULL DEFAULT '-1', `order` mediumint(8) NOT NULL DEFAULT '0', `archived` enum('0','1') NOT NULL DEFAULT '0', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanbangroup` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `kanban` mediumint(8) unsigned NOT NULL, `region` mediumint(8) unsigned NOT NULL, `order` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanbanlane` ( `id` int(8) NOT NULL AUTO_INCREMENT, `execution` mediumint(8) NOT NULL DEFAULT '0', `type` char(30) NOT NULL, `region` mediumint(8) unsigned NOT NULL, `group` mediumint(8) unsigned NOT NULL, `groupby` char(30) NOT NULL, `extra` char(30) NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `color` char(30) NOT NULL, `order` smallint(6) NOT NULL DEFAULT '0', `lastEditedTime` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanbanregion` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `space` mediumint(8) unsigned NOT NULL, `kanban` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL, `order` smallint(6) NOT NULL DEFAULT '0', `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `lastEditedBy` char(30) NOT NULL, `lastEditedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_kanbanspace` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `type` varchar(50) NOT NULL, `owner` varchar(30) NOT NULL, `team` text NOT NULL, `desc` text NOT NULL, `acl` char(30) NOT NULL DEFAULT 'open', `whitelist` text NOT NULL, `status` enum('active','closed') NOT NULL DEFAULT 'active', `order` smallint(6) NOT NULL DEFAULT '0', `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `lastEditedBy` char(30) NOT NULL, `lastEditedDate` datetime NOT NULL, `closedBy` char(30) NOT NULL, `closedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_lang` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `lang` varchar(30) NOT NULL, `module` varchar(30) NOT NULL, `section` varchar(30) NOT NULL, `key` varchar(60) NOT NULL, `value` text NOT NULL, `system` enum('0','1') NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `lang` (`lang`,`module`,`section`,`key`) ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; CREATE TABLE `zt_leave` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `year` char(4) NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `start` time NOT NULL, `finish` time NOT NULL, `hours` float(4,1) unsigned NOT NULL DEFAULT '0.0', `backDate` datetime NOT NULL, `type` varchar(30) NOT NULL DEFAULT '', `desc` text NOT NULL, `status` varchar(30) NOT NULL DEFAULT '', `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `reviewedBy` char(30) NOT NULL, `reviewedDate` datetime NOT NULL, `level` tinyint(3) NOT NULL, `assignedTo` varchar(30) NOT NULL, `reviewers` text NOT NULL, `backReviewers` text NOT NULL, PRIMARY KEY (`id`), KEY `year` (`year`), KEY `type` (`type`), KEY `status` (`status`), KEY `createdBy` (`createdBy`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_lieu` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `year` char(4) NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `start` time NOT NULL, `finish` time NOT NULL, `hours` float(4,1) unsigned NOT NULL DEFAULT '0.0', `overtime` char(255) NOT NULL, `trip` char(255) NOT NULL, `desc` text NOT NULL, `status` varchar(30) NOT NULL DEFAULT '', `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `reviewedBy` char(30) NOT NULL, `reviewedDate` datetime NOT NULL, `level` tinyint(3) NOT NULL, `assignedTo` varchar(30) NOT NULL, `reviewers` text NOT NULL, PRIMARY KEY (`id`), KEY `year` (`year`), KEY `status` (`status`), KEY `createdBy` (`createdBy`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_log` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `objectType` varchar(30) NOT NULL, `objectID` mediumint(8) unsigned NOT NULL, `action` mediumint(8) unsigned NOT NULL, `date` datetime NOT NULL, `url` varchar(255) NOT NULL, `contentType` varchar(30) NOT NULL, `data` text NOT NULL, `result` text NOT NULL, PRIMARY KEY (`id`), KEY `objectType` (`objectType`), KEY `obejctID` (`objectID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_module` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `root` mediumint(8) unsigned NOT NULL DEFAULT '0', `branch` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` char(60) NOT NULL DEFAULT '', `parent` mediumint(8) unsigned NOT NULL DEFAULT '0', `path` char(255) NOT NULL DEFAULT '', `grade` tinyint(3) unsigned NOT NULL DEFAULT '0', `order` smallint(5) unsigned NOT NULL DEFAULT '0', `type` char(30) NOT NULL, `owner` varchar(30) NOT NULL, `collector` text NOT NULL, `short` varchar(30) NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `root` (`root`), KEY `type` (`type`), KEY `path` (`path`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_mr` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `gitlabID` mediumint(8) unsigned NOT NULL, `sourceProject` int(10) unsigned NOT NULL, `sourceBranch` varchar(100) NOT NULL, `targetProject` int(10) unsigned NOT NULL, `targetBranch` varchar(100) NOT NULL, `mriid` int(10) unsigned NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, `assignee` varchar(255) NOT NULL, `reviewer` varchar(255) NOT NULL, `approver` varchar(255) NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', `status` char(30) NOT NULL, `mergeStatus` char(30) NOT NULL, `approvalStatus` char(30) NOT NULL, `needApproved` enum('0','1') NOT NULL DEFAULT '0', `needCI` enum('0','1') NOT NULL DEFAULT '0', `repoID` mediumint(8) unsigned NOT NULL, `jobID` mediumint(8) unsigned NOT NULL, `compileID` mediumint(8) unsigned NOT NULL, `compileStatus` char(30) NOT NULL, `removeSourceBranch` enum('0','1') NOT NULL DEFAULT '0', `synced` enum('0','1') NOT NULL DEFAULT '1', `syncError` varchar(255) NOT NULL, `diffs` longtext, `hasNoConflict` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_mrapproval` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `mrID` mediumint(8) unsigned NOT NULL, `account` varchar(255) NOT NULL, `date` datetime NOT NULL, `action` char(30) NOT NULL, `comment` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_notify` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `objectType` varchar(50) NOT NULL, `objectID` mediumint(8) unsigned NOT NULL, `action` mediumint(9) NOT NULL, `toList` varchar(255) NOT NULL, `ccList` text NOT NULL, `subject` varchar(255) NOT NULL, `data` text NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `sendTime` datetime NOT NULL, `status` varchar(10) NOT NULL DEFAULT 'wait', `failReason` text NOT NULL, PRIMARY KEY (`id`), KEY `objectType_toList_status` (`objectType`,`toList`,`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_oauth` ( `account` varchar(30) NOT NULL, `openID` varchar(255) NOT NULL, `providerType` varchar(30) NOT NULL, `providerID` mediumint(8) unsigned NOT NULL, KEY `account` (`account`), KEY `providerType` (`providerType`), KEY `providerID` (`providerID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_overtime` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `year` char(4) NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `start` time NOT NULL, `finish` time NOT NULL, `hours` float(4,1) unsigned NOT NULL DEFAULT '0.0', `leave` varchar(255) NOT NULL, `type` varchar(30) NOT NULL DEFAULT '', `desc` text NOT NULL, `status` varchar(30) NOT NULL DEFAULT '', `rejectReason` varchar(100) NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `reviewedBy` char(30) NOT NULL, `reviewedDate` datetime NOT NULL, `level` tinyint(3) NOT NULL, `assignedTo` varchar(30) NOT NULL, `reviewers` text NOT NULL, PRIMARY KEY (`id`), KEY `year` (`year`), KEY `type` (`type`), KEY `status` (`status`), KEY `createdBy` (`createdBy`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_pipeline` ( `id` smallint(8) unsigned NOT NULL AUTO_INCREMENT, `type` char(30) NOT NULL, `name` varchar(50) NOT NULL, `url` varchar(255) DEFAULT NULL, `account` varchar(30) DEFAULT NULL, `password` varchar(255) NOT NULL, `token` varchar(255) DEFAULT NULL, `private` char(32) DEFAULT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_planstory` ( `plan` mediumint(8) unsigned NOT NULL, `story` mediumint(8) unsigned NOT NULL, `order` mediumint(9) NOT NULL, UNIQUE KEY `plan_story` (`plan`,`story`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_product` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `program` mediumint(8) unsigned NOT NULL, `name` varchar(90) NOT NULL, `code` varchar(45) NOT NULL, `bind` enum('0','1') NOT NULL DEFAULT '0', `line` mediumint(8) NOT NULL, `type` varchar(30) NOT NULL DEFAULT 'normal', `status` varchar(30) NOT NULL DEFAULT '', `subStatus` varchar(30) NOT NULL DEFAULT '', `desc` text NOT NULL, `PO` varchar(30) NOT NULL, `QD` varchar(30) NOT NULL, `RD` varchar(30) NOT NULL, `feedback` varchar(30) NOT NULL, `acl` enum('open','private','custom') NOT NULL DEFAULT 'open', `whitelist` text NOT NULL, `reviewer` text NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `createdVersion` varchar(20) NOT NULL, `order` mediumint(8) unsigned NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `acl` (`acl`), KEY `order` (`order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_productplan` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `product` mediumint(8) unsigned NOT NULL, `branch` mediumint(8) unsigned NOT NULL, `parent` mediumint(9) NOT NULL DEFAULT '0', `title` varchar(90) NOT NULL, `status` enum('wait','doing','done','closed') NOT NULL default 'wait', `desc` text NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `order` text NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `end` (`end`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_project` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) NOT NULL DEFAULT '0', `model` char(30) NOT NULL, `type` char(30) NOT NULL DEFAULT 'sprint', `lifetime` char(30) NOT NULL DEFAULT '', `budget` varchar(30) NOT NULL DEFAULT '0', `budgetUnit` char(30) NOT NULL DEFAULT 'CNY', `attribute` varchar(30) NOT NULL DEFAULT '', `percent` float unsigned NOT NULL DEFAULT '0', `milestone` enum('0','1') NOT NULL DEFAULT '0', `output` text NOT NULL, `auth` char(30) NOT NULL, `parent` mediumint(8) unsigned NOT NULL DEFAULT '0', `path` varchar(255) NOT NULL, `grade` tinyint(3) unsigned NOT NULL, `name` varchar(90) NOT NULL, `code` varchar(45) NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `realBegan` date NOT NULL, `realEnd` date NOT NULL, `days` smallint(5) unsigned NOT NULL, `status` varchar(10) NOT NULL, `subStatus` varchar(30) NOT NULL DEFAULT '', `pri` enum('1','2','3','4') NOT NULL DEFAULT '1', `desc` text NOT NULL, `version` smallint(6) NOT NULL, `parentVersion` smallint(6) NOT NULL, `planDuration` int(11) NOT NULL, `realDuration` int(11) NOT NULL, `openedBy` varchar(30) NOT NULL DEFAULT '', `openedDate` datetime NOT NULL, `openedVersion` varchar(20) NOT NULL, `lastEditedBy` varchar(30) NOT NULL DEFAULT '', `lastEditedDate` datetime NOT NULL, `closedBy` varchar(30) NOT NULL DEFAULT '', `closedDate` datetime NOT NULL, `canceledBy` varchar(30) NOT NULL DEFAULT '', `canceledDate` datetime NOT NULL, `suspendedDate` date NOT NULL, `PO` varchar(30) NOT NULL DEFAULT '', `PM` varchar(30) NOT NULL DEFAULT '', `QD` varchar(30) NOT NULL DEFAULT '', `RD` varchar(30) NOT NULL DEFAULT '', `team` varchar(90) NOT NULL, `acl` char(30) NOT NULL DEFAULT 'open', `whitelist` text NOT NULL, `order` mediumint(8) unsigned NOT NULL, `displayCards` smallint(6) NOT NULL default '0', `fluidBoard` enum('0','1') NOT NULL DEFAULT '0', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `parent` (`parent`), KEY `begin` (`begin`), KEY `end` (`end`), KEY `status` (`status`), KEY `acl` (`acl`), KEY `order` (`order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_projectcase` ( `project` mediumint(8) unsigned NOT NULL DEFAULT '0', `product` mediumint(8) unsigned NOT NULL DEFAULT '0', `case` mediumint(8) unsigned NOT NULL DEFAULT '0', `count` mediumint(8) unsigned NOT NULL DEFAULT '1', `version` smallint(6) NOT NULL DEFAULT '1', `order` smallint(6) unsigned NOT NULL, UNIQUE KEY `project` (`project`,`case`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_projectproduct` ( `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `branch` mediumint(8) unsigned NOT NULL, `plan` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`project`,`product`,`branch`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_projectspec` ( `project` mediumint(8) NOT NULL, `version` smallint(6) NOT NULL, `name` varchar(255) NOT NULL, `milestone` enum('0','1') NOT NULL DEFAULT '0', `begin` date NOT NULL, `end` date NOT NULL, UNIQUE KEY `project` (`project`,`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_projectstory` ( `project` mediumint(8) unsigned NOT NULL DEFAULT '0', `product` mediumint(8) unsigned NOT NULL, `branch` mediumint(8) unsigned NOT NULL, `story` mediumint(8) unsigned NOT NULL DEFAULT '0', `version` smallint(6) NOT NULL DEFAULT '1', `order` smallint(6) unsigned NOT NULL, UNIQUE KEY `project` (`project`,`story`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_relation` ( `id` int(8) NOT NULL AUTO_INCREMENT, `project` mediumint(8) NOT NULL, `product` mediumint(8) NOT NULL, `execution` mediumint(8) NOT NULL, `AType` char(30) NOT NULL, `AID` mediumint(8) NOT NULL, `AVersion` char(30) NOT NULL, `relation` char(30) NOT NULL, `BType` char(30) NOT NULL, `BID` mediumint(8) NOT NULL, `BVersion` char(30) NOT NULL, `extra` char(30) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `relation` (`product`,`relation`,`AType`,`BType`,`AID`,`BID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_relationoftasks` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `execution` mediumint(8) unsigned NOT NULL, `pretask` mediumint(8) unsigned NOT NULL, `condition` enum('begin','end') NOT NULL, `task` mediumint(8) unsigned NOT NULL, `action` enum('begin','end') NOT NULL, PRIMARY KEY (`id`), KEY `relationoftasks` (`execution`,`task`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_release` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL DEFAULT '0', `branch` mediumint(8) unsigned NOT NULL DEFAULT '0', `build` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `marker` enum('0','1') NOT NULL DEFAULT '0', `date` date NOT NULL, `stories` text NOT NULL, `bugs` text NOT NULL, `leftBugs` text NOT NULL, `desc` text NOT NULL, `mailto` text, `notify` varchar(255) DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'normal', `subStatus` varchar(30) NOT NULL DEFAULT '', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `build` (`build`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_repo` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `product` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `path` varchar(255) NOT NULL, `prefix` varchar(100) NOT NULL, `encoding` varchar(20) NOT NULL, `SCM` varchar(10) NOT NULL, `client` varchar(100) NOT NULL, `commits` mediumint(8) unsigned NOT NULL, `account` varchar(30) NOT NULL, `password` varchar(30) NOT NULL, `encrypt` varchar(30) NOT NULL DEFAULT 'plain', `acl` text NOT NULL, `synced` tinyint(1) NOT NULL DEFAULT '0', `lastSync` datetime NOT NULL, `desc` text NOT NULL, `extra` char(30) NOT NULL, `preMerge` enum('0','1') NOT NULL DEFAULT '0', `job` mediumint(8) unsigned NOT NULL, `fileServerUrl` text, `fileServerAccount` varchar(40) NOT NULL DEFAULT '', `fileServerPassword` varchar(100) NOT NULL DEFAULT '', `deleted` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_repobranch` ( `repo` mediumint(8) unsigned NOT NULL, `revision` mediumint(8) unsigned NOT NULL, `branch` varchar(255) NOT NULL, UNIQUE KEY `repo_revision_branch` (`repo`,`revision`,`branch`), KEY `branch` (`branch`), KEY `revision` (`revision`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_repofiles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `repo` mediumint(8) unsigned NOT NULL, `revision` mediumint(8) unsigned NOT NULL, `path` varchar(255) NOT NULL, `parent` varchar(255) NOT NULL, `type` varchar(20) NOT NULL, `action` char(1) NOT NULL, PRIMARY KEY (`id`), KEY `path` (`path`), KEY `parent` (`parent`), KEY `repo` (`repo`), KEY `revision` (`revision`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_repohistory` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `repo` mediumint(9) NOT NULL, `revision` varchar(40) NOT NULL, `commit` mediumint(8) unsigned NOT NULL, `comment` text NOT NULL, `committer` varchar(100) NOT NULL, `time` datetime NOT NULL, PRIMARY KEY (`id`), KEY `repo` (`repo`), KEY `revision` (`revision`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_report` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `code` varchar(100) NOT NULL, `name` text NOT NULL, `module` varchar(100) NOT NULL, `sql` text NOT NULL, `vars` text NOT NULL, `langs` text NOT NULL, `params` text NOT NULL, `step` tinyint(1) NOT NULL DEFAULT '2', `desc` text NOT NULL, `addedBy` char(30) NOT NULL, `addedDate` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) ) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8; CREATE TABLE `zt_score` ( `id` bigint(12) unsigned NOT NULL AUTO_INCREMENT, `account` varchar(30) NOT NULL, `module` varchar(30) NOT NULL DEFAULT '', `method` varchar(30) NOT NULL, `desc` varchar(250) NOT NULL DEFAULT '', `before` int(11) NOT NULL DEFAULT '0', `score` int(11) NOT NULL DEFAULT '0', `after` int(11) NOT NULL DEFAULT '0', `time` datetime NOT NULL, PRIMARY KEY (`id`), KEY `account` (`account`), KEY `model` (`module`), KEY `method` (`method`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_searchdict` ( `key` smallint(5) unsigned NOT NULL, `value` char(3) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_searchindex` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `objectType` char(20) NOT NULL, `objectID` mediumint(9) NOT NULL, `title` text NOT NULL, `content` text NOT NULL, `addedDate` datetime NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `object` (`objectType`,`objectID`), KEY `addedDate` (`addedDate`), FULLTEXT KEY `content` (`content`), FULLTEXT KEY `title` (`title`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_serverroom` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL, `city` varchar(128) NOT NULL, `line` varchar(20) NOT NULL, `bandwidth` varchar(128) NOT NULL, `provider` varchar(128) NOT NULL, `owner` varchar(30) NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_service` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `external` enum('0','1') NOT NULL DEFAULT '0', `port` smallint(5) unsigned NOT NULL, `entry` varchar(255) NOT NULL, `deploy` varchar(255) NOT NULL, `version` varchar(64) NOT NULL, `color` char(7) NOT NULL, `desc` text, `dept` varchar(128) NOT NULL, `devel` varchar(30) NOT NULL, `qa` varchar(30) NOT NULL, `ops` varchar(30) NOT NULL, `hosts` text, `softName` varchar(128) NOT NULL, `softVersion` varchar(128) NOT NULL, `type` varchar(20) NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` datetime NOT NULL, `parent` mediumint(8) unsigned NOT NULL DEFAULT '0', `path` char(255) NOT NULL DEFAULT '', `grade` tinyint(3) unsigned NOT NULL DEFAULT '0', `order` smallint(5) unsigned NOT NULL DEFAULT '0', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_stage` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `percent` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; CREATE TABLE `zt_stakeholder` ( `id` mediumint(8) NOT NULL AUTO_INCREMENT, `objectID` mediumint(8) NOT NULL, `objectType` char(30) NOT NULL, `user` char(30) NOT NULL, `type` char(30) NOT NULL, `key` enum('0','1') NOT NULL, `from` char(30) NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` date NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` date NOT NULL, `deleted` enum('0','1') NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_story` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `parent` mediumint(9) NOT NULL DEFAULT '0', `product` mediumint(8) unsigned NOT NULL DEFAULT '0', `branch` mediumint(8) unsigned NOT NULL DEFAULT '0', `module` mediumint(8) unsigned NOT NULL DEFAULT '0', `plan` text, `source` varchar(20) NOT NULL, `sourceNote` varchar(255) NOT NULL, `fromBug` mediumint(8) unsigned NOT NULL DEFAULT '0', `feedback` mediumint(8) unsigned NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL, `keywords` varchar(255) NOT NULL, `type` varchar(30) NOT NULL DEFAULT 'story', `category` varchar(30) NOT NULL DEFAULT 'feature', `pri` tinyint(3) unsigned NOT NULL DEFAULT '3', `estimate` float unsigned NOT NULL, `status` enum('','changed','active','draft','closed') NOT NULL DEFAULT '', `subStatus` varchar(30) NOT NULL DEFAULT '', `color` char(7) NOT NULL, `stage` enum('','wait','planned','projected','developing','developed','testing','tested','verified','released','closed') NOT NULL DEFAULT 'wait', `stagedBy` char(30) NOT NULL, `mailto` text, `openedBy` varchar(30) NOT NULL DEFAULT '', `openedDate` datetime NOT NULL, `assignedTo` varchar(30) NOT NULL DEFAULT '', `assignedDate` datetime NOT NULL, `lastEditedBy` varchar(30) NOT NULL DEFAULT '', `lastEditedDate` datetime NOT NULL, `reviewedBy` varchar(255) NOT NULL, `reviewedDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `closedBy` varchar(30) NOT NULL DEFAULT '', `closedDate` datetime NOT NULL, `closedReason` varchar(30) NOT NULL, `toBug` mediumint(8) unsigned NOT NULL, `childStories` varchar(255) NOT NULL, `linkStories` varchar(255) NOT NULL, `duplicateStory` mediumint(8) unsigned NOT NULL, `version` smallint(6) NOT NULL DEFAULT '1', `feedbackBy` varchar(100) NOT NULL, `notifyEmail` varchar(100) NOT NULL, `URChanged` enum('0','1') NOT NULL DEFAULT '0', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `status` (`status`), KEY `assignedTo` (`assignedTo`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_storyestimate` ( `story` mediumint(9) NOT NULL, `round` smallint(6) NOT NULL, `estimate` text NOT NULL, `average` float NOT NULL, `openedBy` varchar(30) NOT NULL, `openedDate` datetime NOT NULL, UNIQUE KEY `story` (`story`,`round`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_storyreview` ( `story` mediumint(9) NOT NULL, `version` smallint(6) NOT NULL, `reviewer` varchar(30) NOT NULL, `result` varchar(30) NOT NULL, `reviewDate` datetime NOT NULL, UNIQUE KEY `story` (`story`,`version`,`reviewer`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_storyspec` ( `story` mediumint(9) NOT NULL, `version` smallint(6) NOT NULL, `title` varchar(255) NOT NULL, `spec` text NOT NULL, `verify` text NOT NULL, UNIQUE KEY `story` (`story`,`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_storystage` ( `story` mediumint(8) unsigned NOT NULL, `branch` mediumint(8) unsigned NOT NULL, `stage` varchar(50) NOT NULL, `stagedBy` char(30) NOT NULL, UNIQUE KEY `story_branch` (`story`,`branch`), KEY `story` (`story`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_suitecase` ( `suite` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `case` mediumint(8) unsigned NOT NULL, `version` smallint(5) unsigned NOT NULL, UNIQUE KEY `suitecase` (`suite`,`case`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_task` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `parent` mediumint(8) NOT NULL DEFAULT '0', `execution` mediumint(8) unsigned NOT NULL DEFAULT '0', `module` mediumint(8) unsigned NOT NULL DEFAULT '0', `design` mediumint(8) unsigned NOT NULL, `story` mediumint(8) unsigned NOT NULL DEFAULT '0', `storyVersion` smallint(6) NOT NULL DEFAULT '1', `designVersion` smallint(6) unsigned NOT NULL, `fromBug` mediumint(8) unsigned NOT NULL DEFAULT '0', `feedback` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL, `type` varchar(20) NOT NULL, `pri` tinyint(3) unsigned NOT NULL DEFAULT '0', `estimate` float unsigned NOT NULL, `consumed` float unsigned NOT NULL, `left` float unsigned NOT NULL, `deadline` date NOT NULL, `status` enum('wait','doing','done','pause','cancel','closed') NOT NULL DEFAULT 'wait', `subStatus` varchar(30) NOT NULL DEFAULT '', `color` char(7) NOT NULL, `mailto` text, `desc` text NOT NULL, `version` smallint(6) NOT NULL, `openedBy` varchar(30) NOT NULL, `openedDate` datetime NOT NULL, `assignedTo` varchar(30) NOT NULL, `assignedDate` datetime NOT NULL, `estStarted` date NOT NULL, `realStarted` datetime NOT NULL, `finishedBy` varchar(30) NOT NULL, `finishedDate` datetime NOT NULL, `finishedList` text NOT NULL, `canceledBy` varchar(30) NOT NULL, `canceledDate` datetime NOT NULL, `closedBy` varchar(30) NOT NULL, `closedDate` datetime NOT NULL, `planDuration` int(11) NOT NULL, `realDuration` int(11) NOT NULL, `closedReason` varchar(30) NOT NULL, `lastEditedBy` varchar(30) NOT NULL, `lastEditedDate` datetime NOT NULL, `activatedDate` date NOT NULL, `repo` mediumint(8) unsigned NOT NULL, `mr` mediumint(8) unsigned NOT NULL, `entry` varchar(255) NOT NULL, `lines` varchar(10) NOT NULL, `v1` varchar(40) NOT NULL, `v2` varchar(40) NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `execution` (`execution`), KEY `story` (`story`), KEY `parent` (`parent`), KEY `assignedTo` (`assignedTo`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_taskestimate` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `task` mediumint(8) unsigned NOT NULL DEFAULT '0', `date` date NOT NULL, `left` float unsigned NOT NULL DEFAULT '0', `consumed` float unsigned NOT NULL, `account` char(30) NOT NULL DEFAULT '', `work` text, PRIMARY KEY (`id`), KEY `task` (`task`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_taskspec` ( `task` mediumint(8) NOT NULL, `version` smallint(6) NOT NULL, `name` varchar(255) NOT NULL, `estStarted` date NOT NULL, `deadline` date NOT NULL, UNIQUE KEY `task` (`task`,`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_team` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `root` mediumint(8) unsigned NOT NULL DEFAULT '0', `type` enum('project','task','execution') NOT NULL DEFAULT 'project', `account` char(30) NOT NULL DEFAULT '', `role` char(30) NOT NULL DEFAULT '', `limited` char(8) NOT NULL DEFAULT 'no', `join` date NOT NULL DEFAULT '0000-00-00', `days` smallint(5) unsigned NOT NULL, `hours` float(3,1) unsigned NOT NULL DEFAULT '0.0', `estimate` decimal(12,2) unsigned NOT NULL DEFAULT '0.00', `consumed` decimal(12,2) unsigned NOT NULL DEFAULT '0.00', `left` decimal(12,2) unsigned NOT NULL DEFAULT '0.00', `order` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `team` (`root`,`type`,`account`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_testreport` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `execution` mediumint(8) unsigned NOT NULL, `tasks` varchar(255) NOT NULL, `builds` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `owner` char(30) NOT NULL, `members` text NOT NULL, `stories` text NOT NULL, `bugs` text NOT NULL, `cases` text NOT NULL, `report` text NOT NULL, `objectType` varchar(20) NOT NULL, `objectID` mediumint(8) unsigned NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_testresult` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `run` mediumint(8) unsigned NOT NULL, `case` mediumint(8) unsigned NOT NULL, `version` smallint(5) unsigned NOT NULL, `job` mediumint(8) unsigned NOT NULL, `compile` mediumint(8) unsigned NOT NULL, `caseResult` char(30) NOT NULL, `stepResults` text NOT NULL, `lastRunner` varchar(30) NOT NULL, `date` datetime NOT NULL, `duration` float NOT NULL, `xml` text NOT NULL, `deploy` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `case` (`case`), KEY `version` (`version`), KEY `run` (`run`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_testrun` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `task` mediumint(8) unsigned NOT NULL DEFAULT '0', `case` mediumint(8) unsigned NOT NULL DEFAULT '0', `version` tinyint(3) unsigned NOT NULL DEFAULT '0', `assignedTo` char(30) NOT NULL DEFAULT '', `lastRunner` varchar(30) NOT NULL, `lastRunDate` datetime NOT NULL, `lastRunResult` char(30) NOT NULL, `status` char(30) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `task` (`task`,`case`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_testsuite` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL, `desc` text NOT NULL, `type` varchar(20) NOT NULL, `addedBy` char(30) NOT NULL, `addedDate` datetime NOT NULL, `lastEditedBy` char(30) NOT NULL, `lastEditedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL, PRIMARY KEY (`id`), KEY `product` (`product`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_testtask` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `product` mediumint(8) unsigned NOT NULL, `name` char(90) NOT NULL, `execution` mediumint(8) unsigned NOT NULL DEFAULT '0', `build` char(30) NOT NULL, `type` varchar(255) NOT NULL DEFAULT '', `owner` varchar(30) NOT NULL, `pri` tinyint(3) unsigned NOT NULL DEFAULT '0', `begin` date NOT NULL, `end` date NOT NULL, `realFinishedDate` datetime NOT NULL, `mailto` text, `desc` text NOT NULL, `report` text NOT NULL, `status` enum('blocked','doing','wait','done') NOT NULL DEFAULT 'wait', `testreport` mediumint(8) unsigned NOT NULL, `auto` varchar(10) NOT NULL DEFAULT 'no', `subStatus` varchar(30) NOT NULL DEFAULT '', `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `product` (`product`), KEY `build` (`build`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_todo` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `date` date NOT NULL, `begin` smallint(4) unsigned zerofill NOT NULL, `end` smallint(4) unsigned zerofill NOT NULL, `feedback` mediumint(8) unsigned NOT NULL, `type` char(10) NOT NULL, `cycle` tinyint(3) unsigned NOT NULL DEFAULT '0', `idvalue` mediumint(8) unsigned NOT NULL DEFAULT '0', `pri` tinyint(3) unsigned NOT NULL, `name` char(150) NOT NULL, `desc` text NOT NULL, `status` enum('wait','doing','done','closed') NOT NULL DEFAULT 'wait', `private` tinyint(1) NOT NULL, `config` varchar(255) NOT NULL, `assignedTo` varchar(30) NOT NULL DEFAULT '', `assignedBy` varchar(30) NOT NULL DEFAULT '', `assignedDate` datetime NOT NULL, `finishedBy` varchar(30) NOT NULL DEFAULT '', `finishedDate` datetime NOT NULL, `closedBy` varchar(30) NOT NULL DEFAULT '', `closedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account` (`account`), KEY `assignedTo` (`assignedTo`), KEY `finishedBy` (`finishedBy`), KEY `date` (`date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_trip` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `type` enum('trip','egress') NOT NULL DEFAULT 'trip', `customers` varchar(20) NOT NULL, `name` char(30) NOT NULL, `desc` text NOT NULL, `year` char(4) NOT NULL, `begin` date NOT NULL, `end` date NOT NULL, `start` time NOT NULL, `finish` time NOT NULL, `from` char(50) NOT NULL, `to` char(50) NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `year` (`year`), KEY `createdBy` (`createdBy`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_user` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `company` mediumint(8) unsigned NOT NULL, `type` char(30) NOT NULL DEFAULT 'inside', `dept` mediumint(8) unsigned NOT NULL DEFAULT '0', `account` char(30) NOT NULL DEFAULT '', `password` char(32) NOT NULL DEFAULT '', `role` char(10) NOT NULL DEFAULT '', `realname` varchar(100) NOT NULL DEFAULT '', `pinyin` varchar(255) NOT NULL DEFAULT '', `nickname` char(60) NOT NULL DEFAULT '', `commiter` varchar(100) NOT NULL, `avatar` text NOT NULL, `birthday` date NOT NULL DEFAULT '0000-00-00', `gender` enum('f','m') NOT NULL DEFAULT 'f', `email` char(90) NOT NULL DEFAULT '', `skype` char(90) NOT NULL DEFAULT '', `qq` char(20) NOT NULL DEFAULT '', `mobile` char(11) NOT NULL DEFAULT '', `phone` char(20) NOT NULL DEFAULT '', `weixin` varchar(90) NOT NULL DEFAULT '', `dingding` varchar(90) NOT NULL DEFAULT '', `slack` varchar(90) NOT NULL DEFAULT '', `whatsapp` varchar(90) NOT NULL DEFAULT '', `address` char(120) NOT NULL DEFAULT '', `zipcode` char(10) NOT NULL DEFAULT '', `nature` text NOT NULL, `analysis` text NOT NULL, `strategy` text NOT NULL, `join` date NOT NULL DEFAULT '0000-00-00', `visits` mediumint(8) unsigned NOT NULL DEFAULT '0', `ip` char(15) NOT NULL DEFAULT '', `last` int(10) unsigned NOT NULL DEFAULT '0', `fails` tinyint(5) NOT NULL DEFAULT '0', `locked` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `feedback` enum('0','1') NOT NULL DEFAULT '0', `ranzhi` char(30) NOT NULL DEFAULT '', `ldap` char(30) NOT NULL, `score` int(11) NOT NULL DEFAULT '0', `scoreLevel` int(11) NOT NULL DEFAULT '0', `deleted` enum('0','1') NOT NULL DEFAULT '0', `clientStatus` enum('online','away','busy','offline','meeting') NOT NULL DEFAULT 'offline', `clientLang` varchar(10) NOT NULL DEFAULT 'zh-cn', PRIMARY KEY (`id`), UNIQUE KEY `account` (`account`), KEY `dept` (`dept`), KEY `email` (`email`), KEY `commiter` (`commiter`), KEY `deleted` (`deleted`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; CREATE TABLE `zt_usercontact` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `listName` varchar(60) NOT NULL, `userList` text NOT NULL, PRIMARY KEY (`id`), KEY `account` (`account`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_usergroup` ( `account` char(30) NOT NULL DEFAULT '', `group` mediumint(8) unsigned NOT NULL DEFAULT '0', `project` text NOT NULL, UNIQUE KEY `account` (`account`,`group`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_userquery` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `module` varchar(30) NOT NULL, `title` varchar(90) NOT NULL, `form` text NOT NULL, `sql` text NOT NULL, `shortcut` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account` (`account`), KEY `module` (`module`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_usertpl` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `account` char(30) NOT NULL, `type` char(30) NOT NULL, `title` varchar(150) NOT NULL, `content` text NOT NULL, `public` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `account` (`account`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_userview` ( `account` char(30) NOT NULL, `programs` mediumtext NOT NULL, `products` mediumtext NOT NULL, `projects` mediumtext NOT NULL, `sprints` mediumtext NOT NULL, UNIQUE KEY `account` (`account`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_vm` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `hostID` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `osCategory` varchar(50) NOT NULL DEFAULT '', `osType` varchar(50) NOT NULL DEFAULT '', `osArch` varchar(50) NOT NULL DEFAULT '', `osLang` varchar(50) NOT NULL DEFAULT '', `status` varchar(50) NOT NULL DEFAULT '', `destroyAt` datetime DEFAULT NULL, `ip` varchar(200) NOT NULL DEFAULT '', `agentPort` varchar(255) NOT NULL DEFAULT '', `macAddress` varchar(255) NOT NULL DEFAULT '', `workspace` varchar(255) NOT NULL DEFAULT '', `templateID` int(10) unsigned NOT NULL DEFAULT '0', `baseImageID` int(10) unsigned NOT NULL DEFAULT '0', `baseImagePath` varchar(255) NOT NULL DEFAULT '', `desc` varchar(255) NOT NULL DEFAULT '', `heatbeat` datetime DEFAULT NULL, `vnc` varchar(255) NOT NULL DEFAULT '', `instance` varchar(255) NOT NULL DEFAULT '', `eip` varchar(255) NOT NULL DEFAULT '', `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', `public` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_vmtemplate` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `hostID` int(10) unsigned NOT NULL DEFAULT '0', `templateName` varchar(255) NOT NULL DEFAULT '', `osType` varchar(50) NOT NULL DEFAULT '', `osCategory` varchar(50) NOT NULL DEFAULT '', `status` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_webhook` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(15) NOT NULL DEFAULT 'default', `name` varchar(50) NOT NULL, `url` varchar(255) NOT NULL, `domain` varchar(255) NOT NULL, `secret` varchar(255) NOT NULL, `contentType` varchar(30) NOT NULL DEFAULT 'application/json', `sendType` enum('sync','async') NOT NULL DEFAULT 'sync', `products` text NOT NULL, `executions` text NOT NULL, `params` varchar(100) NOT NULL, `actions` text NOT NULL, `desc` text NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, `deleted` enum('0','1') NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_weeklyreport` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `project` mediumint(8) unsigned NOT NULL, `weekStart` date NOT NULL, `pv` float(9,2) NOT NULL, `ev` float(9,2) NOT NULL, `ac` float(9,2) NOT NULL, `sv` float(9,2) NOT NULL, `cv` float(9,2) NOT NULL, `staff` smallint(5) unsigned NOT NULL, `progress` varchar(255) NOT NULL, `workload` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `week` (`project`,`weekStart`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflow` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `parent` varchar(30) NOT NULL, `child` varchar(30) NOT NULL, `type` varchar(10) NOT NULL DEFAULT 'flow', `navigator` varchar(10) NOT NULL, `app` varchar(20) NOT NULL, `position` varchar(30) NOT NULL, `module` varchar(30) NOT NULL, `table` varchar(50) NOT NULL, `name` varchar(30) NOT NULL, `titleField` varchar(30) NOT NULL, `contentField` text NOT NULL, `flowchart` text NOT NULL, `js` text NOT NULL, `css` text NOT NULL, `order` smallint(5) unsigned NOT NULL, `buildin` tinyint(1) unsigned NOT NULL, `administrator` text NOT NULL, `desc` text NOT NULL, `version` varchar(10) NOT NULL DEFAULT '1.0', `status` varchar(10) NOT NULL DEFAULT 'wait', `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique` (`app`,`module`), KEY `type` (`type`), KEY `app` (`app`), KEY `module` (`module`), KEY `order` (`order`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowaction` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(30) NOT NULL, `action` varchar(50) NOT NULL, `method` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `type` enum('single','batch') NOT NULL DEFAULT 'single', `batchMode` enum('same','different') NOT NULL DEFAULT 'different', `extensionType` varchar(10) NOT NULL DEFAULT 'override' COMMENT 'none | extend | override', `open` varchar(20) NOT NULL, `position` enum('menu','browseandview','browse','view') NOT NULL DEFAULT 'browseandview', `layout` char(20) NOT NULL, `show` enum('dropdownlist','direct') NOT NULL DEFAULT 'dropdownlist', `order` smallint(5) unsigned NOT NULL, `buildin` tinyint(1) unsigned NOT NULL, `virtual` tinyint(1) unsigned NOT NULL, `conditions` text NOT NULL, `verifications` text NOT NULL, `hooks` text NOT NULL, `linkages` text NOT NULL, `js` text NOT NULL, `css` text NOT NULL, `toList` char(255) NOT NULL, `blocks` text NOT NULL, `desc` text NOT NULL, `status` varchar(10) NOT NULL DEFAULT 'enable', `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique` (`module`,`action`), KEY `module` (`module`), KEY `action` (`action`), KEY `order` (`order`) ) ENGINE=MyISAM AUTO_INCREMENT=149 DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowdatasource` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `type` enum('system','sql','func','option','lang','category') NOT NULL DEFAULT 'option', `name` varchar(30) NOT NULL, `code` varchar(30) NOT NULL, `datasource` text NOT NULL, `view` varchar(20) NOT NULL, `keyField` varchar(50) NOT NULL, `valueField` varchar(50) NOT NULL, `buildin` tinyint(1) unsigned NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `type` (`type`) ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowfield` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(30) NOT NULL, `field` varchar(50) NOT NULL, `type` varchar(20) NOT NULL DEFAULT 'varchar', `length` varchar(10) NOT NULL, `name` varchar(50) NOT NULL, `control` varchar(20) NOT NULL, `expression` text NOT NULL, `options` text NOT NULL, `default` varchar(100) NOT NULL, `rules` varchar(255) NOT NULL, `placeholder` varchar(100) NOT NULL, `order` smallint(5) unsigned NOT NULL, `searchOrder` smallint(5) unsigned NOT NULL DEFAULT '0', `exportOrder` smallint(5) unsigned NOT NULL DEFAULT '0', `canExport` enum('0','1') NOT NULL DEFAULT '0', `canSearch` enum('0','1') NOT NULL DEFAULT '0', `isValue` enum('0','1') NOT NULL DEFAULT '0', `readonly` enum('0','1') NOT NULL DEFAULT '0', `buildin` tinyint(1) unsigned NOT NULL, `desc` text NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique` (`module`,`field`), KEY `module` (`module`), KEY `field` (`field`), KEY `order` (`order`) ) ENGINE=MyISAM AUTO_INCREMENT=354 DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowlabel` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(30) NOT NULL, `action` varchar(30) NOT NULL DEFAULT 'browse', `code` varchar(30) NOT NULL, `label` varchar(255) NOT NULL, `params` text NOT NULL, `orderBy` text NOT NULL, `order` tinyint(3) NOT NULL, `buildin` tinyint(1) unsigned NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `module` (`module`) ) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowlayout` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(30) NOT NULL, `action` varchar(50) NOT NULL, `field` varchar(50) NOT NULL, `order` smallint(5) unsigned NOT NULL, `width` smallint(5) NOT NULL, `position` text NOT NULL, `readonly` enum('0','1') NOT NULL DEFAULT '0', `mobileShow` enum('0','1') NOT NULL DEFAULT '1', `summary` varchar(20) NOT NULL, `defaultValue` text NOT NULL, `layoutRules` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique` (`module`,`action`,`field`), KEY `module` (`module`), KEY `action` (`action`), KEY `order` (`order`) ) ENGINE=MyISAM AUTO_INCREMENT=112 DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowlinkdata` ( `objectType` varchar(30) NOT NULL, `objectID` mediumint(8) unsigned NOT NULL, `linkedType` varchar(30) NOT NULL, `linkedID` mediumint(8) unsigned NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, UNIQUE KEY `unique` (`objectType`,`objectID`,`linkedType`,`linkedID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowrelation` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `prev` varchar(30) NOT NULL, `next` varchar(30) NOT NULL, `field` varchar(50) NOT NULL, `actions` varchar(20) NOT NULL, `actionCodes` text NOT NULL, `buildin` enum('0','1') NOT NULL DEFAULT '0', `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowrelationlayout` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `prev` varchar(30) NOT NULL, `next` varchar(30) NOT NULL, `action` varchar(50) NOT NULL, `field` varchar(50) NOT NULL, `order` smallint(5) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique` (`prev`,`next`,`action`,`field`), KEY `prev` (`prev`), KEY `next` (`next`), KEY `action` (`action`), KEY `order` (`order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowreport` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(30) NOT NULL COMMENT 'module name', `name` varchar(100) NOT NULL COMMENT 'report name', `type` enum('pie','line','bar') NOT NULL DEFAULT 'pie' COMMENT 'report type', `countType` enum('sum','count') NOT NULL DEFAULT 'sum' COMMENT 'report count method', `displayType` enum('value','percent') NOT NULL DEFAULT 'value' COMMENT 'report display method', `dimension` varchar(130) NOT NULL COMMENT 'dimension field code of zt_workflowfield', `fields` text NOT NULL COMMENT 'count fileds code of zt_workflowfield,use comma split', `order` smallint(5) unsigned NOT NULL DEFAULT '0', `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowrule` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `type` enum('system','regex','func') NOT NULL DEFAULT 'regex', `name` varchar(30) NOT NULL, `rule` text NOT NULL, `createdBy` char(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` char(30) NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `type` (`type`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowsql` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(30) NOT NULL, `field` varchar(50) NOT NULL, `action` varchar(50) NOT NULL, `sql` text NOT NULL, `vars` text NOT NULL, `createdBy` varchar(30) NOT NULL, `createdDate` datetime NOT NULL, `editedBy` varchar(30) NOT NULL, `editedDate` datetime NOT NULL, PRIMARY KEY (`id`), KEY `module` (`module`), KEY `field` (`field`), KEY `action` (`action`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `zt_workflowversion` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module` varchar(30) NOT NULL, `version` varchar(10) NOT NULL, `fields` text NOT NULL, `actions` text NOT NULL, `layouts` text NOT NULL, `sqls` text NOT NULL, `labels` text NOT NULL, `table` text NOT NULL, `datas` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `moduleversion` (`module`,`version`), KEY `module` (`module`), KEY `version` (`version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;