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