4 DELETE from service where model_uuid in ( SELECT SERVICE_MODEL_UUID
5 FROM service_to_resource_customizations
7 SERVICE_MODEL_UUID, resource_model_customization_uuid
11 CREATE TABLE IF NOT EXISTS external_service_to_internal_model_mapping (
13 SERVICE_NAME VARCHAR(200) NOT NULL,
14 PRODUCT_FLAVOR VARCHAR(200) NULL,
15 SUBSCRIPTION_SERVICE_TYPE VARCHAR(200) NOT NULL,
16 SERVICE_MODEL_UUID VARCHAR(200) NOT NULL,
18 UNIQUE INDEX UK_external_service_to_internal_model_mapping
19 (SERVICE_NAME ASC, PRODUCT_FLAVOR ASC, SERVICE_MODEL_UUID ASC));
21 CREATE TABLE IF NOT EXISTS `collection_resource` (
22 MODEL_UUID varchar(200) NOT NULL,
23 MODEL_NAME varchar(200) NOT NULL,
24 MODEL_INVARIANT_UUID varchar(200) NOT NULL,
25 MODEL_VERSION varchar(20) NOT NULL,
26 TOSCA_NODE_TYPE varchar(200) NOT NULL,
27 DESCRIPTION varchar(200),
28 CREATION_TIMESTAMP datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
29 PRIMARY KEY (`MODEL_UUID`)
30 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
32 CREATE TABLE IF NOT EXISTS `collection_resource_customization` (
33 MODEL_CUSTOMIZATION_UUID varchar(200) NOT NULL,
34 MODEL_INSTANCE_NAME varchar(200) NOT NULL,
35 ROLE varchar(200) NOT NULL,
36 PRIMARY_TYPE varchar(200) NOT NULL,
37 FUNCTION varchar(200) NOT NULL,
38 SUBINTERFACE_NETWORK_QUANTITY INT,
39 COLLECTION_RESOURCE_TYPE varchar(200) NOT NULL,
40 CREATION_TIMESTAMP datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
41 CR_MODEL_UUID varchar(200) NOT NULL,
42 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`)
43 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
45 CREATE TABLE IF NOT EXISTS `instance_group` (
46 MODEL_UUID varchar(200) NOT NULL,
47 MODEL_NAME varchar(200) NOT NULL,
48 MODEL_INVARIANT_UUID varchar(200) NOT NULL,
49 MODEL_VERSION varchar(20) NOT NULL,
50 TOSCA_NODE_TYPE varchar(200) DEFAULT NULL,
51 ROLE varchar(200) NOT NULL,
52 PRIMARY_TYPE varchar(200) NOT NULL,
53 FUNCTION varchar(200) NOT NULL,
54 DESCRIPTION varchar(200),
55 CREATION_TIMESTAMP datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
56 CR_MODEL_UUID varchar(200) NOT NULL,
57 INSTANCE_GROUP_TYPE varchar(200) NOT NULL,
58 PRIMARY KEY (`MODEL_UUID`)
59 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
61 CREATE TABLE IF NOT EXISTS `catalogdb`.`configuration`
62 ( `MODEL_UUID` VARCHAR(200) NOT NULL,
63 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
64 `MODEL_VERSION` VARCHAR(20) NOT NULL,
65 `MODEL_NAME` VARCHAR(200) NOT NULL,
66 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
67 `DESCRIPTION` VARCHAR(1200) NULL,
68 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
69 PRIMARY KEY (`MODEL_UUID`))
70 ENGINE = InnoDB AUTO_INCREMENT = 20654
71 DEFAULT CHARACTER SET = latin1;
73 CREATE TABLE IF NOT EXISTS `catalogdb`.`service_proxy` (
74 `MODEL_UUID` VARCHAR(200) NOT NULL,
75 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
76 `MODEL_VERSION` VARCHAR(20) NOT NULL,
77 `MODEL_NAME` VARCHAR(200) NOT NULL,
78 `DESCRIPTION` VARCHAR(1200) NULL,
79 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
80 PRIMARY KEY (`MODEL_UUID`))
81 ENGINE = InnoDB AUTO_INCREMENT = 20654
82 DEFAULT CHARACTER SET = latin1;
84 CREATE TABLE IF NOT EXISTS `service_proxy_customization` (
85 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
86 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
87 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
88 `SOURCE_SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL,
89 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
90 `SERVICE_PROXY_MODEL_UUID` VARCHAR(200) NOT NULL,
91 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
92 INDEX `fk_service_proxy_customization__service_proxy1_idx` (`SERVICE_PROXY_MODEL_UUID` ASC),
93 INDEX `fk_service_proxy_customization__service1_idx` (`SOURCE_SERVICE_MODEL_UUID` ASC),
94 CONSTRAINT`fk_spr_customization__service_proxy_resource1`
95 FOREIGN KEY (`SERVICE_PROXY_MODEL_UUID`) REFERENCES `catalogdb`.`service_proxy` (`MODEL_UUID`)
96 ON DELETE CASCADE ON UPDATE CASCADE,
97 CONSTRAINT `fk_service_proxy_resource_customization__service1`
98 FOREIGN KEY (`SOURCE_SERVICE_MODEL_UUID`) REFERENCES `catalogdb`.`service`
99 (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE)
101 AUTO_INCREMENT = 20654
102 DEFAULT CHARACTER SET = latin1;
104 CREATE TABLE IF NOT EXISTS `catalogdb`.`configuration_customization` (
105 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
106 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
107 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
108 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
109 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
110 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
111 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
112 `SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NULL,
113 `CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NULL,
114 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`),
115 INDEX `fk_configuration_customization__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
116 INDEX `fk_configuration_customization__service_proxy_customization_idx`
117 (`SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` ASC),
118 INDEX `fk_configuration_customization__configuration_customization_idx`
119 (`CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID` ASC),
120 CONSTRAINT `fk_configuration_resource_customization__configuration_resour1`
121 FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `catalogdb`.`configuration` (`MODEL_UUID`)
122 ON DELETE CASCADE ON UPDATE CASCADE,
123 CONSTRAINT `fk_configuration_customization__service_proxy_customization1` FOREIGN
124 KEY (`SERVICE_PROXY_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`) REFERENCES
125 `catalogdb`.`service_proxy_customization` (`MODEL_CUSTOMIZATION_UUID`)
126 ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT
127 `fk_configuration_customization__configuration_customization1` FOREIGN
128 KEY (`CONFIGURATION_CUSTOMIZATION_MODEL_CUSTOMIZATION_UUID`) REFERENCES
129 `catalogdb`.`configuration_customization` (`MODEL_CUSTOMIZATION_UUID`)
130 ON DELETE CASCADE ON UPDATE CASCADE)
132 AUTO_INCREMENT =20654
133 DEFAULT CHARACTER SET = latin1;
136 CREATE TABLE `service_proxy_customization_to_service` (
137 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
138 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
139 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
140 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
143 CREATE TABLE `configuration_customization_to_service` (
144 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
145 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
146 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
147 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
150 CREATE TABLE IF NOT EXISTS `collection_resource_customization_to_service` (
151 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
152 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
153 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
154 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
157 CREATE TABLE `network_resource_customization_to_service` (
158 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
159 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
160 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
161 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
163 CREATE TABLE `vnf_resource_customization_to_service` (
164 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
165 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
166 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
167 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
169 CREATE TABLE `allotted_resource_customization_to_service` (
170 `SERVICE_MODEL_UUID` varchar(200) NOT NULL,
171 `RESOURCE_MODEL_CUSTOMIZATION_UUID` varchar(200) NOT NULL,
172 PRIMARY KEY (`SERVICE_MODEL_UUID`,`RESOURCE_MODEL_CUSTOMIZATION_UUID`)
173 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
178 CREATE TABLE IF NOT EXISTS `collection_network_resource_customization` (
179 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
180 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
181 `NETWORK_TECHNOLOGY` VARCHAR(45) NULL,
182 `NETWORK_TYPE` VARCHAR(45) NULL,
183 `NETWORK_ROLE` VARCHAR(200) NULL,
184 `NETWORK_SCOPE` VARCHAR(45) NULL,
185 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
186 `NETWORK_RESOURCE_MODEL_UUID` VARCHAR(200) NOT NULL, `INSTANCE_GROUP_MODEL_UUID` VARCHAR(200) NULL,
187 `CRC_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL, PRIMARY KEY
188 (`MODEL_CUSTOMIZATION_UUID`, `CRC_MODEL_CUSTOMIZATION_UUID`),
189 INDEX `fk_collection_net_resource_customization__network_resource1_idx`
190 (`NETWORK_RESOURCE_MODEL_UUID` ASC), INDEX
191 `fk_collection_net_resource_customization__instance_group1_idx`
192 (`INSTANCE_GROUP_MODEL_UUID` ASC), INDEX
193 `fk_col_net_res_customization__collection_res_customization_idx`
194 (`CRC_MODEL_CUSTOMIZATION_UUID` ASC), CONSTRAINT
195 `fk_collection_net_resource_customization__network_resource10` FOREIGN
196 KEY (`NETWORK_RESOURCE_MODEL_UUID`) REFERENCES
197 `catalogdb`.`network_resource` (`MODEL_UUID`) ON DELETE CASCADE ON
198 UPDATE CASCADE, CONSTRAINT
199 `fk_collection_net_resource_customization__instance_group10` FOREIGN KEY
200 (`INSTANCE_GROUP_MODEL_UUID`) REFERENCES `instance_group`
201 (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT
202 `fk_collection_network_resource_customization__collection_reso1` FOREIGN
203 KEY (`CRC_MODEL_CUSTOMIZATION_UUID`) REFERENCES
204 `collection_resource_customization`
205 (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE
206 = InnoDB DEFAULT CHARACTER SET = latin1;
209 CREATE TABLE IF NOT EXISTS `northbound_request_ref_lookup` (
210 `id` INT(11) NOT NULL AUTO_INCREMENT,
211 `REQUEST_SCOPE` VARCHAR(200) NOT NULL,
212 `MACRO_ACTION` VARCHAR(200) NOT NULL,
213 `ACTION` VARCHAR(200) NOT NULL,
214 `IS_ALACARTE` TINYINT(1) NOT NULL DEFAULT 0,
215 `MIN_API_VERSION` DOUBLE NOT NULL,
216 `MAX_API_VERSION` DOUBLE NULL,
218 UNIQUE INDEX `UK_northbound_request_ref_lookup` (`MIN_API_VERSION` ASC, `REQUEST_SCOPE` ASC, `ACTION` ASC, `IS_ALACARTE` ASC, `MACRO_ACTION` ASC))
220 DEFAULT CHARACTER SET = latin1;
222 CREATE TABLE IF NOT EXISTS `orchestration_flow_reference` (
223 `id` INT(11) NOT NULL AUTO_INCREMENT,
224 `COMPOSITE_ACTION` VARCHAR(200) NOT NULL,
225 `SEQ_NO` INT(11) NOT NULL,
226 `FLOW_NAME` VARCHAR(200) NOT NULL,
227 `FLOW_VERSION` DOUBLE NOT NULL,
228 `NB_REQ_REF_LOOKUP_ID` INT(11) NOT NULL,
230 INDEX `fk_orchestration_flow_reference__northbound_req_ref_look_idx` (`NB_REQ_REF_LOOKUP_ID` ASC),
231 UNIQUE INDEX `UK_orchestration_flow_reference` (`COMPOSITE_ACTION` ASC, `FLOW_NAME` ASC, `SEQ_NO` ASC, `NB_REQ_REF_LOOKUP_ID` ASC),
232 CONSTRAINT `fk_orchestration_flow_reference__northbound_request_ref_look1`
233 FOREIGN KEY (`NB_REQ_REF_LOOKUP_ID`) REFERENCES `northbound_request_ref_lookup` (`id`)
234 ON DELETE CASCADE ON UPDATE CASCADE)
235 ENGINE = InnoDB DEFAULT CHARACTER SET = latin1;
237 CREATE TABLE IF NOT EXISTS `rainy_day_handler_macro` (
238 `id` INT(11) NOT NULL AUTO_INCREMENT,
239 `FLOW_NAME` VARCHAR(200) NOT NULL,
240 `SERVICE_TYPE` VARCHAR(200) NOT NULL,
241 `VNF_TYPE` VARCHAR(200) NOT NULL,
242 `ERROR_CODE` VARCHAR(200) NOT NULL,
243 `WORK_STEP` VARCHAR(200) NOT NULL,
244 `POLICY` VARCHAR(200) NOT NULL,
247 DEFAULT CHARACTER SET = latin1;