3 CREATE TABLE `activate_operational_env_service_model_distribution_status` (
4 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
5 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
6 `REQUEST_ID` varchar(45) NOT NULL,
7 `SERVICE_MOD_VER_FINAL_DISTR_STATUS` varchar(45) DEFAULT NULL,
8 `RECOVERY_ACTION` varchar(30) DEFAULT NULL,
9 `RETRY_COUNT_LEFT` int(11) DEFAULT NULL,
10 `WORKLOAD_CONTEXT` varchar(80) NOT NULL,
11 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
12 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
13 PRIMARY KEY (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`)
14 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17 CREATE TABLE `activate_operational_env_per_distributionid_status` (
18 `DISTRIBUTION_ID` varchar(45) NOT NULL,
19 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
20 `DISTRIBUTION_ID_ERROR_REASON` varchar(250) DEFAULT NULL,
21 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
22 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
23 `OPERATIONAL_ENV_ID` varchar(45) NOT NULL,
24 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
25 `REQUEST_ID` varchar(45) NOT NULL,
26 PRIMARY KEY (`DISTRIBUTION_ID`),
27 KEY `fk_activate_op_env_per_distributionid_status__aoesmds1_idx` (`OPERATIONAL_ENV_ID`,`SERVICE_MODEL_VERSION_ID`,`REQUEST_ID`),
28 CONSTRAINT `fk_activate_op_env_per_distributionid_status__aoesmds1` FOREIGN KEY (`OPERATIONAL_ENV_ID`, `SERVICE_MODEL_VERSION_ID`, `REQUEST_ID`) REFERENCES `activate_operational_env_service_model_distribution_status` (`OPERATIONAL_ENV_ID`, `SERVICE_MODEL_VERSION_ID`, `REQUEST_ID`) ON DELETE CASCADE ON UPDATE CASCADE
29 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
32 CREATE TABLE `active_requests` (
33 `REQUEST_ID` varchar(45) NOT NULL,
34 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
35 `SERVICE_INSTANCE_ID` varchar(50) NOT NULL,
36 `SUBSCRIBER_NAME` varchar(200) DEFAULT NULL,
37 `REQUEST_URI` varchar(255) DEFAULT NULL,
38 `SERVICE_TYPE` varchar(65) NOT NULL,
39 `REQUEST_ACTION` varchar(45) NOT NULL,
40 `NOTIFICATION_URL` varchar(255) DEFAULT NULL,
41 `REQUEST_ID_IN_PROGRESS` varchar(45) DEFAULT NULL,
42 `START_TIME` datetime DEFAULT NULL,
43 `MODIFY_TIME` datetime DEFAULT NULL,
44 `COMPLETION_TIME` datetime DEFAULT NULL,
45 `RESPONSE_CODE` varchar(20) DEFAULT NULL,
46 `RESPONSE_BODY` longtext,
47 `STATUS` varchar(25) DEFAULT NULL,
48 `SERVICE_REQUEST_TIMEOUT` datetime DEFAULT NULL,
49 `FINAL_ERROR_CODE` varchar(20) DEFAULT NULL,
50 `FINAL_ERROR_MESSAGE` varchar(2000) DEFAULT NULL,
51 `ORDER_NUMBER` varchar(45) DEFAULT NULL,
52 `SOURCE` varchar(20) DEFAULT NULL,
53 `RESPONSE_STATUS` varchar(25) DEFAULT NULL,
54 `ORDER_VERSION` varchar(20) DEFAULT NULL,
55 `LAST_MODIFIED_BY` varchar(20) DEFAULT NULL,
56 `MOCARS_TICKET_NUM` varchar(200) DEFAULT NULL,
57 `REQUEST_BODY` longtext,
58 `REQUEST_SUB_ACTION` varchar(45) DEFAULT NULL,
59 `SDNC_CALLBACK_BPEL_URL` varchar(255) DEFAULT NULL,
60 `FEATURE_TYPE` varchar(255) DEFAULT NULL,
61 `FEATURE_INSTANCE_ID` varchar(255) DEFAULT NULL,
62 `REQUEST_TYPE` varchar(255) DEFAULT NULL,
63 `INTERIM_COMPLETION_TIME` datetime DEFAULT NULL,
64 `INTERIM_STAGE_COMPLETION` int(11) DEFAULT NULL,
65 `SERVICE_NAME_VERSION_ID` varchar(50) DEFAULT NULL,
66 `GLOBAL_SUBSCRIBER_ID` varchar(255) DEFAULT NULL,
67 `SERVICE_ID` varchar(50) DEFAULT NULL,
68 `SERVICE_VERSION` varchar(10) DEFAULT NULL,
69 `CORRELATOR` varchar(50) DEFAULT NULL,
70 PRIMARY KEY (`REQUEST_ID`),
71 UNIQUE KEY `UK_f0hdk7xbw5mb2trnxx0fvlh3x` (`CLIENT_REQUEST_ID`)
72 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
74 CREATE TABLE `infra_active_requests` (
75 `REQUEST_ID` varchar(45) NOT NULL,
76 `CLIENT_REQUEST_ID` varchar(45) DEFAULT NULL,
77 `ACTION` varchar(45) DEFAULT NULL,
78 `REQUEST_STATUS` varchar(20) DEFAULT NULL,
79 `STATUS_MESSAGE` longtext,
80 `PROGRESS` bigint(20) DEFAULT NULL,
81 `START_TIME` datetime DEFAULT NULL,
82 `END_TIME` datetime DEFAULT NULL,
83 `SOURCE` varchar(45) DEFAULT NULL,
84 `VNF_ID` varchar(45) DEFAULT NULL,
85 `VNF_NAME` varchar(80) DEFAULT NULL,
86 `VNF_TYPE` varchar(200) DEFAULT NULL,
87 `SERVICE_TYPE` varchar(45) DEFAULT NULL,
88 `AIC_NODE_CLLI` varchar(11) DEFAULT NULL,
89 `TENANT_ID` varchar(45) DEFAULT NULL,
90 `PROV_STATUS` varchar(20) DEFAULT NULL,
91 `VNF_PARAMS` longtext,
92 `VNF_OUTPUTS` longtext,
93 `REQUEST_BODY` longtext,
94 `RESPONSE_BODY` longtext,
95 `LAST_MODIFIED_BY` varchar(100) DEFAULT NULL,
96 `MODIFY_TIME` datetime DEFAULT NULL,
97 `REQUEST_TYPE` varchar(20) DEFAULT NULL,
98 `VOLUME_GROUP_ID` varchar(45) DEFAULT NULL,
99 `VOLUME_GROUP_NAME` varchar(45) DEFAULT NULL,
100 `VF_MODULE_ID` varchar(45) DEFAULT NULL,
101 `VF_MODULE_NAME` varchar(200) DEFAULT NULL,
102 `VF_MODULE_MODEL_NAME` varchar(200) DEFAULT NULL,
103 `AAI_SERVICE_ID` varchar(50) DEFAULT NULL,
104 `AIC_CLOUD_REGION` varchar(11) DEFAULT NULL,
105 `CALLBACK_URL` varchar(200) DEFAULT NULL,
106 `CORRELATOR` varchar(80) DEFAULT NULL,
107 `NETWORK_ID` varchar(45) DEFAULT NULL,
108 `NETWORK_NAME` varchar(80) DEFAULT NULL,
109 `NETWORK_TYPE` varchar(80) DEFAULT NULL,
110 `REQUEST_SCOPE` varchar(50) NOT NULL,
111 `REQUEST_ACTION` varchar(45) NOT NULL DEFAULT 'unknown',
112 `SERVICE_INSTANCE_ID` varchar(45) DEFAULT NULL,
113 `SERVICE_INSTANCE_NAME` varchar(80) DEFAULT NULL,
114 `REQUESTOR_ID` varchar(50) DEFAULT NULL,
115 `CONFIGURATION_ID` varchar(45) DEFAULT NULL,
116 `CONFIGURATION_NAME` varchar(200) DEFAULT NULL,
117 `OPERATIONAL_ENV_ID` varchar(45) DEFAULT NULL,
118 `OPERATIONAL_ENV_NAME` varchar(200) DEFAULT NULL,
119 PRIMARY KEY (`REQUEST_ID`),
120 UNIQUE KEY `UK_bhu6w8p7wvur4pin0gjw2d5ak` (`CLIENT_REQUEST_ID`)
121 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124 CREATE TABLE `site_status` (
125 `SITE_NAME` varchar(255) NOT NULL,
126 `STATUS` bit(1) DEFAULT NULL,
127 `CREATION_TIMESTAMP` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
128 PRIMARY KEY (`SITE_NAME`)
129 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
131 CREATE TABLE `watchdog_distributionid_status` (
132 `DISTRIBUTION_ID` varchar(45) NOT NULL,
133 `DISTRIBUTION_ID_STATUS` varchar(45) DEFAULT NULL,
134 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
135 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
136 PRIMARY KEY (`DISTRIBUTION_ID`)
137 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
139 CREATE TABLE `watchdog_per_component_distribution_status` (
140 `DISTRIBUTION_ID` varchar(45) NOT NULL,
141 `COMPONENT_NAME` varchar(45) NOT NULL,
142 `COMPONENT_DISTRIBUTION_STATUS` varchar(45) DEFAULT NULL,
143 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
144 `MODIFY_TIME` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
145 PRIMARY KEY (`DISTRIBUTION_ID`,`COMPONENT_NAME`),
146 CONSTRAINT `fk_watchdog_component_distribution_status_watchdog_distributi1` FOREIGN KEY (`DISTRIBUTION_ID`) REFERENCES `watchdog_distributionid_status` (`DISTRIBUTION_ID`) ON DELETE CASCADE ON UPDATE CASCADE
147 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
149 CREATE TABLE `watchdog_service_mod_ver_id_lookup` (
150 `DISTRIBUTION_ID` varchar(45) NOT NULL,
151 `SERVICE_MODEL_VERSION_ID` varchar(45) NOT NULL,
152 `CREATE_TIME` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
153 `MODIFY_TIME` timestamp NULL DEFAULT NULL,
154 PRIMARY KEY (`DISTRIBUTION_ID`)
155 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;