1 /* Copyright © 2017 AT&T, Amdocs, Bell Canada
3 * Licensed under the Apache License, Version 2.0 (the "License");
4 * you may not use this file except in compliance with the License.
5 * You may obtain a copy of the License at
7 * http://www.apache.org/licenses/LICENSE-2.0
9 * Unless required by applicable law or agreed to in writing, software
10 * distributed under the License is distributed on an "AS IS" BASIS,
11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12 * See the License for the specific language governing permissions and
13 * limitations under the License.
17 alter table HEAT_TEMPLATE_PARAMS
19 foreign key FK_p3ol1xcvp831glqohrlu6o07o;
21 alter table MODEL_RECIPE
23 foreign key FK_c23r0puyqug6n44jg39dutm1c;
27 foreign key FK_l3qy594u2xr1tfpmma3uigsna;
29 alter table SERVICE_RECIPE
31 foreign key FK_i3r1b8j6e7dg9hkp49evnnm5y;
33 alter table SERVICE_TO_RESOURCE_CUSTOMIZATIONS
35 foreign key FK_kiddaay6cfe0aob1f1jaio1bb;
39 foreign key FK_12jptc9it7gs3pru08skobxxc;
41 alter table VNF_RESOURCE_CUSTOMIZATION
43 foreign key FK_iff1ayhb1hrp5jhea3vvikuni;
45 drop table if exists ALLOTTED_RESOURCE;
47 drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION;
49 drop table if exists HEAT_ENVIRONMENT;
51 drop table if exists HEAT_FILES;
53 drop table if exists HEAT_NESTED_TEMPLATE;
55 drop table if exists HEAT_TEMPLATE;
57 drop table if exists HEAT_TEMPLATE_PARAMS;
59 drop table if exists MODEL;
61 drop table if exists MODEL_RECIPE;
63 drop table if exists NETWORK_RECIPE;
65 drop table if exists NETWORK_RESOURCE;
67 drop table if exists NETWORK_RESOURCE_CUSTOMIZATION;
69 drop table if exists SERVICE;
71 drop table if exists SERVICE_RECIPE;
73 drop table if exists SERVICE_TO_ALLOTTED_RESOURCES;
75 drop table if exists SERVICE_TO_NETWORKS;
77 drop table if exists SERVICE_TO_RESOURCE_CUSTOMIZATIONS;
79 drop table if exists TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP;
81 drop table if exists TOSCA_CSAR;
83 drop table if exists VF_MODULE;
85 drop table if exists VF_MODULE_CUSTOMIZATION;
87 drop table if exists VF_MODULE_TO_HEAT_FILES;
89 drop table if exists VNF_COMPONENTS;
91 drop table if exists VNF_COMPONENTS_RECIPE;
93 drop table if exists VNF_RECIPE;
95 drop table if exists VNF_RESOURCE;
97 drop table if exists VNF_RESOURCE_CUSTOMIZATION;
99 drop table if exists VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM;
101 create table ALLOTTED_RESOURCE (
102 MODEL_UUID varchar(255) not null,
103 MODEL_INVARIANT_UUID varchar(255),
104 MODEL_VERSION varchar(255),
105 MODEL_NAME varchar(255),
106 TOSCA_NODE_TYPE varchar(255),
107 SUBCATEGORY varchar(255),
108 DESCRIPTION varchar(255),
109 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
110 primary key (MODEL_UUID)
113 create table ALLOTTED_RESOURCE_CUSTOMIZATION (
114 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
115 MODEL_INSTANCE_NAME varchar(255),
116 AR_MODEL_UUID varchar(255),
117 PROVIDING_SERVICE_MODEL_INVARIANT_UUID varchar(255),
118 TARGET_NETWORK_ROLE varchar(255),
119 NF_FUNCTION varchar(255),
120 NF_TYPE varchar(255),
121 NF_ROLE varchar(255),
122 NF_NAMING_CODE varchar(255),
123 MIN_INSTANCES integer,
124 MAX_INSTANCES integer,
125 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
126 primary key (MODEL_CUSTOMIZATION_UUID)
129 create table HEAT_ENVIRONMENT (
130 ARTIFACT_UUID varchar(200) not null,
131 NAME varchar(100) not null,
132 VERSION varchar(20) not null,
133 DESCRIPTION varchar(1200),
134 BODY longtext not null,
135 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
136 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD',
137 primary key (ARTIFACT_UUID)
140 create table HEAT_FILES (
141 ARTIFACT_UUID varchar(255) not null,
142 DESCRIPTION varchar(255),
144 VERSION varchar(255),
146 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
147 ARTIFACT_CHECKSUM varchar(255),
148 primary key (ARTIFACT_UUID)
151 create table HEAT_NESTED_TEMPLATE (
152 PARENT_HEAT_TEMPLATE_UUID varchar(200) not null,
153 CHILD_HEAT_TEMPLATE_UUID varchar(200) not null,
154 PROVIDER_RESOURCE_FILE varchar(100),
155 primary key (PARENT_HEAT_TEMPLATE_UUID, CHILD_HEAT_TEMPLATE_UUID)
158 create table HEAT_TEMPLATE (
159 ARTIFACT_UUID varchar(200) not null,
160 NAME varchar(200) not null,
161 VERSION varchar(20) not null,
162 BODY longtext not null,
163 TIMEOUT_MINUTES integer,
164 DESCRIPTION varchar(1200),
165 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
166 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
167 primary key (ARTIFACT_UUID)
170 create table HEAT_TEMPLATE_PARAMS (
171 HEAT_TEMPLATE_ARTIFACT_UUID varchar(255) not null,
172 PARAM_NAME varchar(255) not null,
173 IS_REQUIRED bit not null,
174 PARAM_TYPE varchar(20),
175 PARAM_ALIAS varchar(45),
176 primary key (HEAT_TEMPLATE_ARTIFACT_UUID, PARAM_NAME)
180 id integer not null auto_increment,
181 MODEL_TYPE varchar(20) not null,
182 MODEL_VERSION_ID varchar(40) not null,
183 MODEL_INVARIANT_ID varchar(40),
184 MODEL_NAME varchar(40) not null,
185 MODEL_VERSION varchar(20),
186 MODEL_CUSTOMIZATION_ID varchar(40),
187 MODEL_CUSTOMIZATION_NAME varchar(40),
188 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
192 create table MODEL_RECIPE (
193 id integer not null auto_increment,
194 MODEL_ID integer not null,
195 ACTION varchar(20) not null,
196 SCHEMA_VERSION varchar(20),
197 DESCRIPTION varchar(1200),
198 ORCHESTRATION_URI varchar(256) not null,
199 MODEL_PARAM_XSD varchar(2048),
200 RECIPE_TIMEOUT integer,
201 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
205 create table NETWORK_RECIPE (
206 id integer not null auto_increment,
207 MODEL_NAME varchar(20) not null,
208 ACTION varchar(20) not null,
209 VERSION_STR varchar(20) not null,
210 SERVICE_TYPE varchar(45),
211 DESCRIPTION varchar(1200),
212 ORCHESTRATION_URI varchar(256) not null,
213 NETWORK_PARAM_XSD varchar(2048),
214 RECIPE_TIMEOUT integer,
215 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
219 create table NETWORK_RESOURCE (
220 MODEL_UUID varchar(200) not null,
221 MODEL_NAME varchar(200) not null,
222 MODEL_INVARIANT_UUID varchar(200),
223 MODEL_VERSION varchar(20),
224 TOSCA_NODE_TYPE varchar(200),
225 NEUTRON_NETWORK_TYPE varchar(20),
226 DESCRIPTION varchar(1200),
227 ORCHESTRATION_MODE varchar(20),
228 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
229 AIC_VERSION_MIN varchar(20) default 2.5 not null,
230 AIC_VERSION_MAX varchar(20) default 2.5,
231 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
232 primary key (MODEL_UUID)
235 create table NETWORK_RESOURCE_CUSTOMIZATION (
236 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
237 NETWORK_RESOURCE_MODEL_UUID varchar(200) not null,
238 MODEL_INSTANCE_NAME varchar(255),
239 NETWORK_TECHNOLOGY varchar(255),
240 NETWORK_TYPE varchar(255),
241 NETWORK_SCOPE varchar(255),
242 NETWORK_ROLE varchar(255),
243 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
244 primary key (MODEL_CUSTOMIZATION_UUID)
247 create table SERVICE (
248 MODEL_UUID varchar(200) not null,
249 MODEL_NAME varchar(200) not null,
250 MODEL_VERSION varchar(20) not null,
251 DESCRIPTION varchar(1200),
252 TOSCA_CSAR_ARTIFACT_UUID varchar(200),
253 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
254 MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
255 SERVICE_TYPE varchar(20),
256 SERVICE_ROLE varchar(20),
257 primary key (MODEL_UUID)
260 create table SERVICE_RECIPE (
261 id integer not null auto_increment,
262 SERVICE_MODEL_UUID varchar(200) not null,
263 ACTION varchar(40) not null,
264 ORCHESTRATION_URI varchar(256) not null,
265 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
266 VERSION_STR varchar(20),
267 DESCRIPTION varchar(1200),
268 SERVICE_PARAM_XSD varchar(2048),
269 RECIPE_TIMEOUT integer,
270 SERVICE_TIMEOUT_INTERIM integer,
274 create table SERVICE_TO_ALLOTTED_RESOURCES (
275 SERVICE_MODEL_UUID varchar(200) not null,
276 AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
277 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
278 primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
281 create table SERVICE_TO_NETWORKS (
282 SERVICE_MODEL_UUID varchar(200) not null,
283 NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
284 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
285 primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
288 create table SERVICE_TO_RESOURCE_CUSTOMIZATIONS (
289 MODEL_TYPE varchar(20) not null,
290 RESOURCE_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
291 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
292 SERVICE_MODEL_UUID varchar(200) not null,
293 primary key (MODEL_TYPE, RESOURCE_MODEL_CUSTOMIZATION_UUID)
296 create table TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP (
297 NETWORK_RESOURCE_MODEL_NAME varchar(200) not null,
298 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
299 AIC_VERSION_MIN varchar(20) not null,
300 AIC_VERSION_MAX varchar(20),
301 primary key (NETWORK_RESOURCE_MODEL_NAME)
304 create table TOSCA_CSAR (
305 ARTIFACT_UUID varchar(200) not null,
306 NAME varchar(200) not null,
307 VERSION varchar(20) not null,
308 ARTIFACT_CHECKSUM varchar(200) not null,
309 URL varchar(200) not null,
310 DESCRIPTION varchar(1200),
311 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
312 primary key (ARTIFACT_UUID)
315 create table VF_MODULE (
316 MODEL_UUID varchar(200) not null,
317 VNF_RESOURCE_MODEL_UUID varchar(200),
318 MODEL_INVARIANT_UUID varchar(200),
319 MODEL_VERSION varchar(20) not null,
320 MODEL_NAME varchar(200) not null,
321 DESCRIPTION varchar(1200),
322 IS_BASE integer not null,
323 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
324 VOL_HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
325 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
326 primary key (MODEL_UUID)
329 create table VF_MODULE_CUSTOMIZATION (
330 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
331 VF_MODULE_MODEL_UUID varchar(200) not null,
332 VOL_ENVIRONMENT_ARTIFACT_UUID varchar(200),
333 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
334 HEAT_ENVIRONMENT_ARTIFACT_UUID varchar(200),
335 MIN_INSTANCES integer,
336 MAX_INSTANCES integer,
337 INITIAL_COUNT integer,
338 AVAILABILITY_ZONE_COUNT integer,
340 primary key (MODEL_CUSTOMIZATION_UUID)
343 create table VF_MODULE_TO_HEAT_FILES (
344 VF_MODULE_MODEL_UUID varchar(200) not null,
345 HEAT_FILES_ARTIFACT_UUID varchar(200) not null,
346 primary key (VF_MODULE_MODEL_UUID, HEAT_FILES_ARTIFACT_UUID)
349 create table VNF_COMPONENTS (
350 VNF_ID integer not null,
351 COMPONENT_TYPE varchar(20) not null,
352 HEAT_TEMPLATE_ID integer,
353 HEAT_ENVIRONMENT_ID integer,
354 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
355 primary key (VNF_ID, COMPONENT_TYPE)
358 create table VNF_COMPONENTS_RECIPE (
359 id integer not null auto_increment,
360 VNF_TYPE varchar(200),
361 VF_MODULE_MODEL_UUID varchar(100),
362 VNF_COMPONENT_TYPE varchar(45) not null,
363 ACTION varchar(20) not null,
364 SERVICE_TYPE varchar(45),
366 DESCRIPTION varchar(1200),
367 ORCHESTRATION_URI varchar(256) not null,
368 VNF_COMPONENT_PARAM_XSD varchar(2048),
369 RECIPE_TIMEOUT integer,
370 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
374 create table VNF_RECIPE (
375 id integer not null auto_increment,
376 VF_MODULE_ID varchar(100),
377 ACTION varchar(20) not null,
378 VERSION_STR varchar(20) not null,
379 VNF_TYPE varchar(200),
380 SERVICE_TYPE varchar(45) default null,
381 DESCRIPTION varchar(1200),
382 ORCHESTRATION_URI varchar(256) not null,
383 VNF_PARAM_XSD varchar(2048),
384 RECIPE_TIMEOUT integer,
385 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
389 create table VNF_RESOURCE (
390 MODEL_UUID varchar(200) not null,
391 MODEL_INVARIANT_UUID varchar(200),
392 MODEL_VERSION varchar(20) not null,
393 MODEL_NAME varchar(200),
394 TOSCA_NODE_TYPE varchar(200),
395 DESCRIPTION varchar(1200),
396 ORCHESTRATION_MODE varchar(20) not null,
397 AIC_VERSION_MIN varchar(20),
398 AIC_VERSION_MAX varchar(20),
399 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
400 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
401 primary key (MODEL_UUID)
404 create table VNF_RESOURCE_CUSTOMIZATION (
405 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
406 MODEL_INSTANCE_NAME varchar(200) not null,
407 MIN_INSTANCES integer,
408 MAX_INSTANCES integer,
409 AVAILABILITY_ZONE_MAX_COUNT integer,
410 NF_FUNCTION varchar(200),
411 NF_TYPE varchar(200),
412 NF_ROLE varchar(200),
413 NF_NAMING_CODE varchar(200),
414 VNF_RESOURCE_MODEL_UUID varchar(200) not null,
415 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
416 primary key (MODEL_CUSTOMIZATION_UUID)
419 create table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM (
420 VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
421 VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
422 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
423 primary key (VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID)
427 add constraint UK_rra00f1rk6eyy7g00k9raxh2v unique (MODEL_TYPE, MODEL_VERSION_ID);
429 alter table MODEL_RECIPE
430 add constraint UK_b4g8j9wtqrkxfycyi3ursk7gb unique (MODEL_ID, ACTION);
432 alter table NETWORK_RECIPE
433 add constraint UK_pbsa8i44m8p10f9529jdgfuk9 unique (MODEL_NAME, ACTION, VERSION_STR);
435 alter table SERVICE_RECIPE
436 add constraint UK_2lr377dpqnvl5aqlp5dtj2fcp unique (SERVICE_MODEL_UUID, ACTION);
438 alter table VNF_COMPONENTS_RECIPE
439 add constraint UK_g3je95aaxxiuest25f0qoy2u8 unique (VNF_TYPE, VF_MODULE_MODEL_UUID, VNF_COMPONENT_TYPE, ACTION, SERVICE_TYPE, VERSION);
441 alter table VNF_RECIPE
442 add constraint UK_f3tvqau498vrifq3cr8qnigkr unique (VF_MODULE_ID, ACTION, VERSION_STR);
444 alter table HEAT_TEMPLATE_PARAMS
445 add constraint FK_p3ol1xcvp831glqohrlu6o07o
446 foreign key (HEAT_TEMPLATE_ARTIFACT_UUID)
447 references HEAT_TEMPLATE (ARTIFACT_UUID);
449 alter table MODEL_RECIPE
450 add constraint FK_c23r0puyqug6n44jg39dutm1c
451 foreign key (MODEL_ID)
452 references MODEL (id);
455 add constraint FK_l3qy594u2xr1tfpmma3uigsna
456 foreign key (TOSCA_CSAR_ARTIFACT_UUID)
457 references TOSCA_CSAR (ARTIFACT_UUID);
459 alter table SERVICE_RECIPE
460 add constraint FK_i3r1b8j6e7dg9hkp49evnnm5y
461 foreign key (SERVICE_MODEL_UUID)
462 references SERVICE (MODEL_UUID);
464 alter table SERVICE_TO_RESOURCE_CUSTOMIZATIONS
465 add constraint FK_kiddaay6cfe0aob1f1jaio1bb
466 foreign key (SERVICE_MODEL_UUID)
467 references SERVICE (MODEL_UUID);
469 alter table VF_MODULE
470 add constraint FK_12jptc9it7gs3pru08skobxxc
471 foreign key (VNF_RESOURCE_MODEL_UUID)
472 references VNF_RESOURCE (MODEL_UUID);
474 alter table VNF_RESOURCE_CUSTOMIZATION
475 add constraint FK_iff1ayhb1hrp5jhea3vvikuni
476 foreign key (VNF_RESOURCE_MODEL_UUID)
477 references VNF_RESOURCE (MODEL_UUID);