znt/db/update18.5.sql

ALTER TABLE `zt_privrelation` MODIFY `priv` VARCHAR(100) NOT NULL;
ALTER TABLE `zt_privrelation` MODIFY `relationPriv` VARCHAR(100) NOT NULL;
DELETE FROM `zt_privrelation`;
REPLACE INTO `zt_privrelation` (`priv`, `type`, `relationPriv`) VALUES ('account-browse','depend','ops-index'),('account-browse','recommend','account-create'),('account-browse','recommend','account-edit'),('account-browse','recommend','account-view'),('account-create','depend','account-browse'),('account-create','depend','ops-index'),('account-create','recommend','account-edit'),('account-delete','depend','account-browse'),('account-delete','depend','ops-index'),('account-delete','recommend','account-create'),('account-delete','recommend','account-edit'),('account-edit','depend','account-browse'),('account-edit','depend','ops-index'),('account-edit','recommend','account-create'),('account-view','depend','account-browse'),('account-view','depend','ops-index'),('account-view','recommend','account-create'),('account-view','recommend','account-edit'),('action-editComment','depend','action-comment'),('action-hideAll','depend','action-trash'),('action-hideAll','recommend','action-hideOne'),('action-hideOne','depend','action-trash'),('action-hideOne','recommend','action-hideAll'),('action-undelete','depend','action-trash'),('activity-assignTo','depend','activity-browse'),('activity-assignTo','recommend','activity-create'),('activity-assignTo','recommend','activity-edit'),('activity-batchCreate','depend','activity-browse'),('activity-batchCreate','recommend','activity-create'),('activity-create','depend','activity-browse'),('activity-create','recommend','activity-assignTo'),('activity-create','recommend','activity-batchCreate'),('activity-create','recommend','activity-delete'),('activity-create','recommend','activity-edit'),('activity-create','recommend','activity-outputList'),('activity-create','recommend','activity-updateOrder'),('activity-create','recommend','activity-view'),('activity-delete','depend','activity-browse'),('activity-delete','recommend','activity-create'),('activity-edit','depend','activity-browse'),('activity-edit','recommend','activity-assignTo'),('activity-edit','recommend','activity-batchCreate'),('activity-edit','recommend','activity-create'),('activity-edit','recommend','activity-delete'),('activity-edit','recommend','activity-outputList'),('activity-edit','recommend','activity-updateOrder'),('activity-edit','recommend','activity-view'),('activity-outputList','depend','activity-browse'),('activity-outputList','recommend','activity-create'),('activity-outputList','recommend','activity-edit'),('activity-outputList','recommend','activity-view'),('activity-updateOrder','depend','activity-browse'),('activity-updateOrder','recommend','activity-create'),('activity-updateOrder','recommend','activity-edit'),('activity-view','depend','activity-browse'),('activity-view','recommend','activity-outputList'),('admin-checkWeak','depend','admin-index'),('admin-resetPWDSetting','depend','admin-index'),('admin-safe','depend','admin-index'),('admin-sso','depend','admin-index'),('admin-sso','depend','admin-register'),('admin-tableEngine','depend','admin-index'),('api-addCatalog','depend','api-index'),('api-addCatalog','recommend','api-editCatalog'),('api-create','depend','api-index'),('api-create','recommend','api-createRelease'),('api-create','recommend','api-edit'),('api-create','recommend','api-releases'),('api-createLib','depend','api-index'),('api-createLib','recommend','api-editLib'),('api-createRelease','depend','api-index'),('api-createRelease','recommend','api-create'),('api-createRelease','recommend','api-edit'),('api-createRelease','recommend','api-releases'),('api-createStruct','depend','api-index'),('api-createStruct','recommend','api-editStruct'),('api-createStruct','recommend','api-struct'),('api-delete','depend','api-index'),('api-deleteCatalog','depend','api-index'),('api-deleteLib','depend','api-index'),('api-deleteRelease','depend','api-index'),('api-deleteStruct','depend','api-index'),('api-edit','depend','api-index'),('api-edit','recommend','api-create'),('api-edit','recommend','api-createRelease'),('api-edit','recommend','api-releases'),('api-editCatalog','depend','api-index'),('api-editCatalog','recomm

REPLACE INTO `zt_priv` (`id`, `module`, `method`, `parent`, `edition`, `vision`, `system`, `order`) VALUES (2116, 'file', 'preview', '260', ',open,biz,max,ipd,', ',rnd,lite,or,', '1', '26');
REPLACE INTO `zt_privlang` (`objectID`, `objectType`, `lang`, `key`, `value`, `desc`) VALUES (2116, 'priv', 'de',    'file-previewFile', '', '');
REPLACE INTO `zt_privlang` (`objectID`, `objectType`, `lang`, `key`, `value`, `desc`) VALUES (2116, 'priv', 'en',    'file-previewFile', '', '');
REPLACE INTO `zt_privlang` (`objectID`, `objectType`, `lang`, `key`, `value`, `desc`) VALUES (2116, 'priv', 'fr',    'file-previewFile', '', '');
REPLACE INTO `zt_privlang` (`objectID`, `objectType`, `lang`, `key`, `value`, `desc`) VALUES (2116, 'priv', 'zh-cn', 'file-previewFile', '', '');
REPLACE INTO `zt_privlang` (`objectID`, `objectType`, `lang`, `key`, `value`, `desc`) VALUES (2116, 'priv', 'zh-tw', 'file-previewFile', '', '');

REPLACE INTO `zt_grouppriv` (SELECT `group`,'file','preview' FROM zt_grouppriv WHERE module = 'file' AND method = 'download');
DELETE FROM zt_privrelation WHERE `priv` = 'branch-manage' AND relationPriv = 'product-create';
DELETE FROM zt_privrelation WHERE `priv` = 'branch-manage' AND relationPriv = 'product-edit';

UPDATE `zt_cron` SET `type` = 'zentao' WHERE `command` = 'moduleName=weekly&methodName=computeWeekly' AND `type` = 'system';

ALTER TABLE `zt_doc` ADD `editedList` text NULL;

CREATE INDEX `scene` ON `zt_case`(`scene`);
UPDATE `zt_case` SET `sort` = `id` WHERE `sort` = 0;
UPDATE `zt_case` SET `scene` = `scene` - 100000000 WHERE `scene` > 100000000;
UPDATE `zt_scene` SET `sort` = `sort` - 100000000 WHERE `sort` > 100000000;
UPDATE `zt_scene` SET `parent` = `parent` - 100000000 WHERE `parent` > 100000000;
UPDATE `zt_scene` SET `path` = REPLACE(`path`, ',10000000', ',');
UPDATE `zt_scene` SET `path` = REPLACE(`path`, ',1000000', ',');
UPDATE `zt_scene` SET `path` = REPLACE(`path`, ',100000', ',');
UPDATE `zt_scene` SET `path` = REPLACE(`path`, ',10000', ',');

DROP VIEW IF EXISTS `ztv_scenecase`;

-- DROP TABLE IF EXISTS `zt_actionrecent`;
CREATE TABLE IF NOT EXISTS `zt_actionrecent` (
  `id` int(9) unsigned NOT NULL AUTO_INCREMENT,
  `objectType` varchar(30) NOT NULL DEFAULT '',
  `objectID` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `product` text NULL,
  `project` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `execution` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `actor` varchar(100) NOT NULL DEFAULT '',
  `action` varchar(80) NOT NULL DEFAULT '',
  `date` datetime NULL,
  `comment` text NULL,
  `extra` text NULL,
  `read` enum('0','1') NOT NULL DEFAULT '0',
  `vision` varchar(10) NOT NULL DEFAULT 'rnd',
  `efforted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;
CREATE INDEX `date`     ON `zt_actionrecent`(`date`);
CREATE INDEX `actor`    ON `zt_actionrecent`(`actor`);
CREATE INDEX `project`  ON `zt_actionrecent`(`project`);
CREATE INDEX `action`   ON `zt_actionrecent`(`action`);
CREATE INDEX `objectID` ON `zt_actionrecent`(`objectID`);

ALTER TABLE `zt_notify` ADD `toListCopy` text NULL;
UPDATE `zt_notify` SET `toListCopy` = `toList`;
ALTER TABLE `zt_notify` DROP `toList`;
ALTER TABLE `zt_notify` CHANGE COLUMN `toListCopy` `toList` text;

ALTER TABLE `zt_notify` ADD `subjectCopy` text NULL;
UPDATE `zt_notify` SET `subjectCopy` = `subject`;
ALTER TABLE `zt_notify` DROP `subject`;
ALTER TABLE `zt_notify` CHANGE COLUMN `subjectCopy` `subject` text;

DROP INDEX `objectType_toList_status` ON `zt_notify`;
CREATE INDEX `objectType` ON `zt_notify` (`objectType`);
CREATE INDEX `status` ON `zt_notify` (`status`);

CREATE INDEX `deleted` ON `zt_bug` (`deleted`);
CREATE INDEX `product_status_deleted` ON `zt_bug` (`product`,`status`,`deleted`);

UPDATE `zt_cron` SET `m` = '*/1' WHERE `m` = '*/5' AND `command` in ('moduleName=mail&methodName=asyncSend', 'moduleName=webhook&methodName=asyncSend') and `type` = 'zentao';

CREATE INDEX `type_order` ON `zt_project` (`type`,`order`);

CREATE INDEX `vision` ON `zt_config`(`vision`);
CREATE INDEX `owner`  ON `zt_config`(`owner`);
CREATE INDEX `module` ON `zt_config`(`module`);
CREATE INDEX `key`    ON `zt_config`(`key`);

UPDATE `zt_programoutput` SET `activity` = (SELECT `activity` FROM `zt_zoutput` WHERE `zt_programoutput`.`output` = `zt_zoutput`.`id`);

ALTER TABLE `zt_reviewissue` ADD `opinionCopy` mediumtext NULL;
UPDATE `zt_reviewissue` SET `opinionCopy` = `opinion`;
ALTER TABLE `zt_reviewissue` DROP `opinion`;
ALTER TABLE `zt_reviewissue` CHANGE COLUMN `opinionCopy` `opinion` text;

INSERT INTO `zt_actionrecent`(`objectType`,`objectID`,`product`,`project`,`execution`,`actor`,`action`,`date`,`comment`,`extra`,`read`,`vision`,`efforted`)
SELECT `objectType`,`objectID`,`product`,`project`,`execution`,`actor`,`action`,`date`,`comment`,`extra`,`read`,`vision`,`efforted` FROM `zt_action`
WHERE `date` >= DATE_SUB(NOW(), INTERVAL '1' MONTH);