1 -- MSO-816 mso_requests DB changes to support tenant isolation
\r
2 -- -----------------------------------------------------------
\r
3 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
\r
4 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
\r
5 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
\r
8 ALTER TABLE `mso_requests`.`infra_active_requests`
\r
9 ADD COLUMN `OPERATIONAL_ENV_ID` VARCHAR(45) NULL DEFAULT NULL AFTER `CONFIGURATION_NAME`,
\r
10 ADD COLUMN `OPERATIONAL_ENV_NAME` VARCHAR(200) NULL DEFAULT NULL AFTER `OPERATIONAL_ENV_ID`,
\r
11 CHANGE COLUMN `REQUEST_SCOPE` `REQUEST_SCOPE` VARCHAR(50) NOT NULL;
\r
15 DROP TABLE IF EXISTS `mso_requests`.`activate_operational_env_per_distributionid_status`;
\r
16 DROP TABLE IF EXISTS `mso_requests`.`activate_operational_env_service_model_distribution_status`;
\r
17 DROP TABLE IF EXISTS `mso_requests`.`watchdog_distributionid_status`;
\r
18 DROP TABLE IF EXISTS `mso_requests`.`watchdog_per_component_distribution_status`;
\r
19 DROP TABLE IF EXISTS `mso_requests`.`watchdog_service_mod_ver_id_lookup`;
\r
21 -- -----------------------------------------------------
\r
22 -- Table `mso_requests`.`activate_operational_env_service_model_distribution_status`
\r
23 -- -----------------------------------------------------
\r
24 CREATE TABLE `mso_requests`.`activate_operational_env_service_model_distribution_status` (
\r
25 `OPERATIONAL_ENV_ID` VARCHAR(45) NOT NULL,
\r
26 `SERVICE_MODEL_VERSION_ID` VARCHAR(45) NOT NULL,
\r
27 `REQUEST_ID` VARCHAR(45) NOT NULL,
\r
28 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` VARCHAR(45) NULL,
\r
29 `RECOVERY_ACTION` VARCHAR(30) NULL,
\r
30 `RETRY_COUNT_LEFT` INT(11) NULL,
\r
31 `WORKLOAD_CONTEXT` VARCHAR(80) NOT NULL,
\r
32 `CREATE_TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
33 `MODIFY_TIME` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
\r
34 PRIMARY KEY (`OPERATIONAL_ENV_ID`, `SERVICE_MODEL_VERSION_ID`, `REQUEST_ID`))
\r
37 -- -----------------------------------------------------
\r
38 -- Table `mso_requests`.`activate_operational_env_per_distributionid_status`
\r
39 -- -----------------------------------------------------
\r
40 CREATE TABLE `mso_requests`.`activate_operational_env_per_distributionid_status` (
\r
41 `DISTRIBUTION_ID` VARCHAR(45) NOT NULL,
\r
42 `DISTRIBUTION_ID_STATUS` VARCHAR(45) NULL,
\r
43 `DISTRIBUTION_ID_ERROR_REASON` VARCHAR(250) NULL,
\r
44 `CREATE_TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
45 `MODIFY_TIME` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
\r
46 `OPERATIONAL_ENV_ID` VARCHAR(45) NOT NULL,
\r
47 `SERVICE_MODEL_VERSION_ID` VARCHAR(45) NOT NULL,
\r
48 `REQUEST_ID` VARCHAR(45) NOT NULL,
\r
49 PRIMARY KEY (`DISTRIBUTION_ID`),
\r
50 INDEX `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID` ASC, `SERVICE_MODEL_VERSION_ID` ASC, `REQUEST_ID` ASC),
\r
51 CONSTRAINT `fk_activate_op_env_per_distributionid_status__aoesmds1`
\r
52 FOREIGN KEY (`OPERATIONAL_ENV_ID` , `SERVICE_MODEL_VERSION_ID` , `REQUEST_ID`)
\r
53 REFERENCES `mso_requests`.`activate_operational_env_service_model_distribution_status` (`OPERATIONAL_ENV_ID` , `SERVICE_MODEL_VERSION_ID` , `REQUEST_ID`)
\r
58 -- -----------------------------------------------------
\r
59 -- Table `mso_requests`.`watchdog_distributionid_status`
\r
60 -- -----------------------------------------------------
\r
61 CREATE TABLE `mso_requests`.`watchdog_distributionid_status` (
\r
62 `DISTRIBUTION_ID` VARCHAR(45) NOT NULL,
\r
63 `DISTRIBUTION_ID_STATUS` VARCHAR(45) NULL,
\r
64 `CREATE_TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
65 `MODIFY_TIME` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
\r
66 PRIMARY KEY (`DISTRIBUTION_ID`))
\r
69 -- -----------------------------------------------------
\r
70 -- Table `mso_requests`.`watchdog_per_component_distribution_status`
\r
71 -- -----------------------------------------------------
\r
72 CREATE TABLE `mso_requests`.`watchdog_per_component_distribution_status` (
\r
73 `DISTRIBUTION_ID` VARCHAR(45) NOT NULL,
\r
74 `COMPONENT_NAME` VARCHAR(45) NOT NULL,
\r
75 `COMPONENT_DISTRIBUTION_STATUS` VARCHAR(45) NULL,
\r
76 `CREATE_TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
77 `MODIFY_TIME` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
\r
78 PRIMARY KEY (`DISTRIBUTION_ID`, `COMPONENT_NAME`),
\r
79 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1`
\r
80 FOREIGN KEY (`DISTRIBUTION_ID`)
\r
81 REFERENCES `mso_requests`.`watchdog_distributionid_status` (`DISTRIBUTION_ID`)
\r
86 -- -----------------------------------------------------
\r
87 -- Table `mso_requests`.`watchdog_service_mod_ver_id_lookup`
\r
88 -- -----------------------------------------------------
\r
89 CREATE TABLE `mso_requests`.`watchdog_service_mod_ver_id_lookup` (
\r
90 `DISTRIBUTION_ID` VARCHAR(45) NOT NULL,
\r
91 `SERVICE_MODEL_VERSION_ID` VARCHAR(45) NOT NULL,
\r
92 `CREATE_TIME` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
\r
93 PRIMARY KEY (`DISTRIBUTION_ID`))
\r
97 SET SQL_MODE=@OLD_SQL_MODE;
\r
98 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
\r
99 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
\r