platform / task-web

2.10.0.sql 1.26 KB
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 
ALTER TABLE `itsm_request`
ADD COLUMN `IS_IN_TEST_CASE`  tinyint(1) NULL COMMENT '是否有测试用例' AFTER `FAULT_USER_NAME`,
ADD COLUMN `IS_TO_TEST_CASE`  tinyint(1) NULL COMMENT '是否应有测试用例' AFTER `IS_IN_TEST_CASE`,
ADD COLUMN `RESPONSIBLE_TYPE`  varchar(50) NULL COMMENT '责任方' AFTER `IS_TO_TEST_CASE`,
ADD COLUMN `RESPONSIBLE_USER_ID`  bigint(20) NULL COMMENT '故障责任人ID' AFTER `RESPONSIBLE_TYPE`,
ADD COLUMN `RESPONSIBLE_USER_NAME`  varchar(100) NULL COMMENT '故障责任人姓名' AFTER `RESPONSIBLE_USER_ID`,
ADD COLUMN `IS_KPI_DOWN`  tinyint(1) NULL COMMENT '是否扣点' AFTER `RESPONSIBLE_USER_NAME`;

ALTER TABLE `pms_issue`
ADD COLUMN `IS_IN_TEST_CASE`  tinyint(1) NULL COMMENT '是否有测试用例' AFTER `MINOR_FAULT_ID`,
ADD COLUMN `IS_TO_TEST_CASE`  tinyint(1) NULL COMMENT '是否应有测试用例' AFTER `IS_IN_TEST_CASE`,
ADD COLUMN `RESPONSIBLE_TYPE`  varchar(50) NULL COMMENT '责任方' AFTER `IS_TO_TEST_CASE`,
ADD COLUMN `RESPONSIBLE_USER_ID`  bigint(20) NULL COMMENT '故障责任人ID' AFTER `RESPONSIBLE_TYPE`,
ADD COLUMN `RESPONSIBLE_USER_NAME`  varchar(100) NULL COMMENT '故障责任人姓名' AFTER `RESPONSIBLE_USER_ID`,
ADD COLUMN `IS_KPI_DOWN`  tinyint(1) NULL COMMENT '是否扣点' AFTER `RESPONSIBLE_USER_NAME`;