65 lines
5.5 KiB
MySQL
65 lines
5.5 KiB
MySQL
|
CREATE INDEX `objectType` ON `zt_stakeholder` (`objectType`);
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `zt_autocache` (
|
||
|
|
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
`code` varchar(30) NOT NULL DEFAULT '',
|
||
|
|
`fields` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB;
|
||
|
|
CREATE UNIQUE INDEX `cache` ON `zt_autocache` (`code`, `fields`(190));
|
||
|
|
REPLACE INTO `zt_workflowaction` (`module`, `action`, `method`, `name`, `type`, `batchMode`, `extensionType`, `open`, `position`, `layout`, `show`, `order`, `buildin`, `role`, `virtual`, `conditions`, `verifications`, `hooks`, `linkages`, `js`, `css`, `toList`, `blocks`, `desc`, `status`, `vision`, `createdBy`, `createdDate`, `editedBy`, `editedDate`) VALUES
|
||
|
|
('product', 'requirement', 'requirement', '用户需求列表', 'single', 'different', 'none', 'normal', 'browse', 'normal', 'direct', 0, 1, 'buildin', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 'enable', 'rnd', 'admin', '2024-12-16 11:22:30', '', NULL),
|
||
|
|
('product', 'epic', 'epic', '业务需求列表', 'single', 'different', 'none', 'normal', 'browse', 'normal', 'direct', 0, 1, 'buildin', 0, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 'enable', 'rnd', 'admin', '2024-12-16 11:22:30', '', NULL);
|
||
|
|
|
||
|
|
DELETE FROM `zt_config` WHERE `module` = 'datatable' AND `section` IN ('productBrowseRequirement', 'productBrowseEpic') AND `key` = 'cols';
|
||
|
|
|
||
|
|
-- DROP TABLE IF EXISTS `zt_casespec`;
|
||
|
|
CREATE TABLE IF NOT EXISTS `zt_casespec` (
|
||
|
|
`id` mediumint(8) unsigned NOT NULL auto_increment,
|
||
|
|
`case` mediumint(9) NOT NULL DEFAULT '0',
|
||
|
|
`version` smallint(6) NOT NULL DEFAULT '0',
|
||
|
|
`title` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
`precondition` text NULL,
|
||
|
|
`files` text NULL,
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=InnoDB;
|
||
|
|
CREATE UNIQUE INDEX `case` ON `zt_casespec`(`case`,`version`);
|
||
|
|
|
||
|
|
ALTER TABLE `zt_taskteam` ADD COLUMN `storyVersion` smallint(6) NOT NULL DEFAULT '1' AFTER `status`;
|
||
|
|
UPDATE `zt_taskteam` AS t1 LEFT JOIN `zt_task` AS t2 ON t1.`task` = t2.`id` SET t1.`storyVersion` = t2.`storyVersion` WHERE t2.`storyVersion` IS NOT NULL;
|
||
|
|
|
||
|
|
ALTER TABLE `zt_searchdict` DROP INDEX `PRIMARY`;
|
||
|
|
ALTER TABLE `zt_searchdict` ADD UNIQUE `key_value` (`key`, `value`);
|
||
|
|
|
||
|
|
ALTER TABLE `zt_trainrecords` DROP INDEX `PRIMARY`;
|
||
|
|
ALTER TABLE `zt_trainrecords` ADD UNIQUE `object` (`user`, `objectId`, `objectType`);
|
||
|
|
|
||
|
|
ALTER TABLE `zt_burn` DROP INDEX `PRIMARY`;
|
||
|
|
ALTER TABLE `zt_burn` ADD UNIQUE `execution_task` (`execution`,`date`,`task`);
|
||
|
|
|
||
|
|
ALTER TABLE `zt_projectproduct` DROP INDEX `PRIMARY`;
|
||
|
|
ALTER TABLE `zt_projectproduct` ADD UNIQUE `project_product` (`project`, `product`, `branch`);
|
||
|
|
|
||
|
|
ALTER TABLE `zt_userview` ADD `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY (`id`);
|
||
|
|
|
||
|
|
INSERT INTO `zt_cron` (`m`, `h`, `dom`, `mon`, `dow`, `command`, `remark`, `type`, `buildin`, `status`, `lastTime`) VALUES
|
||
|
|
('30', '1', '*', '*', '*', 'moduleName=instance&methodName=cronCleanBackup', 'Devops服务备份清理', 'zentao', 1, 'normal', NULL);
|
||
|
|
|
||
|
|
DELETE FROM `zt_grouppriv` WHERE `module` = 'testcase' AND `method` = 'exportfreemind';
|
||
|
|
INSERT INTO `zt_grouppriv` SELECT `group`, 'testcase', 'exportfreemind' FROM `zt_grouppriv` WHERE `module` = 'testcase' AND `method` = 'exportxmind';
|
||
|
|
|
||
|
|
ALTER TABLE `zt_docblock` MODIFY `content` mediumtext NULL;
|
||
|
|
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`title` from zt_story where `deleted`=\'0\' and `type`=\'story\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'stories';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`name` from zt_task where `deleted`=\'0\' and `vision`=\'rnd\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'tasks';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`name` from zt_task where `deleted`=\'0\' and `vision`=\'rnd\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'bugs';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`name` from zt_build where `deleted`=\'0\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'builds';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`name` from zt_module where `deleted`=\'0\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'modules';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`title` from zt_productplan where `deleted`=\'0\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'plans';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`title` from zt_case where `deleted`=\'0\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'cases';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`name` from zt_task where `deleted`=\'0\' and `vision`=\'lite\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'litetasks';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`name` from zt_module where `deleted`=\'0\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'litemodules';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`title` from zt_feedback where `deleted`=\'0\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'feedbacks';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`title` from zt_story where `deleted`=\'0\' and `type`=\'requirement\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'requirements';
|
||
|
|
UPDATE `zt_workflowdatasource` SET `datasource` = 'select `id`,`title` from zt_story where `deleted`=\'0\' and `type`=\'epic\'' WHERE `type` = 'sql' AND `buildin` = '1' AND `code` = 'epics';
|