2 alter table HEAT_TEMPLATE_PARAMS
4 foreign key FK_p3ol1xcvp831glqohrlu6o07o;
6 alter table MODEL_RECIPE
8 foreign key FK_c23r0puyqug6n44jg39dutm1c;
12 foreign key FK_l3qy594u2xr1tfpmma3uigsna;
14 alter table SERVICE_RECIPE
16 foreign key FK_i3r1b8j6e7dg9hkp49evnnm5y;
18 alter table SERVICE_TO_RESOURCE_CUSTOMIZATIONS
20 foreign key FK_kiddaay6cfe0aob1f1jaio1bb;
24 foreign key FK_12jptc9it7gs3pru08skobxxc;
26 alter table VNF_RESOURCE_CUSTOMIZATION
28 foreign key FK_iff1ayhb1hrp5jhea3vvikuni;
30 drop table if exists ALLOTTED_RESOURCE;
32 drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION;
34 drop table if exists HEAT_ENVIRONMENT;
36 drop table if exists HEAT_FILES;
38 drop table if exists HEAT_NESTED_TEMPLATE;
40 drop table if exists HEAT_TEMPLATE;
42 drop table if exists HEAT_TEMPLATE_PARAMS;
44 drop table if exists MODEL;
46 drop table if exists MODEL_RECIPE;
48 drop table if exists NETWORK_RECIPE;
50 drop table if exists NETWORK_RESOURCE;
52 drop table if exists NETWORK_RESOURCE_CUSTOMIZATION;
54 drop table if exists SERVICE;
56 drop table if exists SERVICE_RECIPE;
58 drop table if exists SERVICE_TO_ALLOTTED_RESOURCES;
60 drop table if exists SERVICE_TO_NETWORKS;
62 drop table if exists SERVICE_TO_RESOURCE_CUSTOMIZATIONS;
64 drop table if exists TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP;
66 drop table if exists TOSCA_CSAR;
68 drop table if exists VF_MODULE;
70 drop table if exists VF_MODULE_CUSTOMIZATION;
72 drop table if exists VF_MODULE_TO_HEAT_FILES;
74 drop table if exists VNF_COMPONENTS;
76 drop table if exists VNF_COMPONENTS_RECIPE;
78 drop table if exists VNF_RECIPE;
80 drop table if exists VNF_RESOURCE;
82 drop table if exists VNF_RESOURCE_CUSTOMIZATION;
84 drop table if exists VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM;
86 create table ALLOTTED_RESOURCE (
87 MODEL_UUID varchar(255) not null,
88 MODEL_INVARIANT_UUID varchar(255),
89 MODEL_VERSION varchar(255),
90 MODEL_NAME varchar(255),
91 TOSCA_NODE_TYPE varchar(255),
92 SUBCATEGORY varchar(255),
93 DESCRIPTION varchar(255),
94 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
95 primary key (MODEL_UUID)
98 create table ALLOTTED_RESOURCE_CUSTOMIZATION (
99 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
100 MODEL_INSTANCE_NAME varchar(255),
101 AR_MODEL_UUID varchar(255),
102 PROVIDING_SERVICE_MODEL_INVARIANT_UUID varchar(255),
103 TARGET_NETWORK_ROLE varchar(255),
104 NF_FUNCTION varchar(255),
105 NF_TYPE varchar(255),
106 NF_ROLE varchar(255),
107 NF_NAMING_CODE varchar(255),
108 MIN_INSTANCES integer,
109 MAX_INSTANCES integer,
110 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
111 PROVIDING_SERVICE_MODEL_UUID varchar(255),
112 PROVIDING_SERVICE_MODEL_NAME varchar(255),
113 primary key (MODEL_CUSTOMIZATION_UUID)
116 create table HEAT_ENVIRONMENT (
117 ARTIFACT_UUID varchar(200) not null,
118 NAME varchar(100) not null,
119 VERSION varchar(20) not null,
120 DESCRIPTION varchar(1200),
121 BODY longtext not null,
122 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
123 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD',
124 primary key (ARTIFACT_UUID)
127 create table HEAT_FILES (
128 ARTIFACT_UUID varchar(255) not null,
129 DESCRIPTION varchar(255),
131 VERSION varchar(255),
133 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
134 ARTIFACT_CHECKSUM varchar(255),
135 primary key (ARTIFACT_UUID)
138 create table HEAT_NESTED_TEMPLATE (
139 PARENT_HEAT_TEMPLATE_UUID varchar(200) not null,
140 CHILD_HEAT_TEMPLATE_UUID varchar(200) not null,
141 PROVIDER_RESOURCE_FILE varchar(100),
142 primary key (PARENT_HEAT_TEMPLATE_UUID, CHILD_HEAT_TEMPLATE_UUID)
145 create table HEAT_TEMPLATE (
146 ARTIFACT_UUID varchar(200) not null,
147 NAME varchar(200) not null,
148 VERSION varchar(20) not null,
149 BODY longtext not null,
150 TIMEOUT_MINUTES integer,
151 DESCRIPTION varchar(1200),
152 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
153 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
154 primary key (ARTIFACT_UUID)
157 create table HEAT_TEMPLATE_PARAMS (
158 HEAT_TEMPLATE_ARTIFACT_UUID varchar(255) not null,
159 PARAM_NAME varchar(255) not null,
160 IS_REQUIRED bit not null,
161 PARAM_TYPE varchar(20),
162 PARAM_ALIAS varchar(45),
163 primary key (HEAT_TEMPLATE_ARTIFACT_UUID, PARAM_NAME)
167 id integer not null auto_increment,
168 MODEL_TYPE varchar(20) not null,
169 MODEL_VERSION_ID varchar(40) not null,
170 MODEL_INVARIANT_ID varchar(40),
171 MODEL_NAME varchar(40) not null,
172 MODEL_VERSION varchar(20),
173 MODEL_CUSTOMIZATION_ID varchar(40),
174 MODEL_CUSTOMIZATION_NAME varchar(40),
175 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
179 create table MODEL_RECIPE (
180 id integer not null auto_increment,
181 MODEL_ID integer not null,
182 ACTION varchar(40) not null,
183 SCHEMA_VERSION varchar(20),
184 DESCRIPTION varchar(1200),
185 ORCHESTRATION_URI varchar(256) not null,
186 MODEL_PARAM_XSD varchar(2048),
187 RECIPE_TIMEOUT integer,
188 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
192 create table NETWORK_RECIPE (
193 id integer not null auto_increment,
194 MODEL_NAME varchar(20) not null,
195 ACTION varchar(40) not null,
196 VERSION_STR varchar(20) not null,
197 SERVICE_TYPE varchar(45),
198 DESCRIPTION varchar(1200),
199 ORCHESTRATION_URI varchar(256) not null,
200 NETWORK_PARAM_XSD varchar(2048),
201 RECIPE_TIMEOUT integer,
202 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
206 create table NETWORK_RESOURCE (
207 MODEL_UUID varchar(200) not null,
208 MODEL_NAME varchar(200) not null,
209 MODEL_INVARIANT_UUID varchar(200),
210 MODEL_VERSION varchar(20),
211 TOSCA_NODE_TYPE varchar(200),
212 NEUTRON_NETWORK_TYPE varchar(20),
213 DESCRIPTION varchar(1200),
214 ORCHESTRATION_MODE varchar(20),
215 RESOURCE_CATEGORY varchar(20),
216 RESOURCE_SUB_CATEGORY varchar(20),
217 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
218 AIC_VERSION_MIN varchar(20) default 2.5 not null,
219 AIC_VERSION_MAX varchar(20) default 2.5,
220 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
221 primary key (MODEL_UUID)
224 create table NETWORK_RESOURCE_CUSTOMIZATION (
225 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
226 NETWORK_RESOURCE_MODEL_UUID varchar(200) not null,
227 MODEL_INSTANCE_NAME varchar(255),
228 NETWORK_TECHNOLOGY varchar(255),
229 NETWORK_TYPE varchar(255),
230 NETWORK_SCOPE varchar(255),
231 NETWORK_ROLE varchar(255),
232 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
233 primary key (MODEL_CUSTOMIZATION_UUID)
236 create table SERVICE (
237 MODEL_UUID varchar(200) not null,
238 MODEL_NAME varchar(200) not null,
239 MODEL_VERSION varchar(20) not null,
240 DESCRIPTION varchar(1200),
241 TOSCA_CSAR_ARTIFACT_UUID varchar(200),
242 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
243 MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
244 SERVICE_CATEGORY varchar(20),
245 SERVICE_TYPE varchar(20),
246 SERVICE_ROLE varchar(20),
247 ENVIRONMENT_CONTEXT varchar(255) default null,
248 WORKLOAD_CONTEXT varchar(255) default null,
249 primary key (MODEL_UUID)
252 create table SERVICE_RECIPE (
253 id integer not null auto_increment,
254 SERVICE_MODEL_UUID varchar(200) not null,
255 ACTION varchar(40) not null,
256 ORCHESTRATION_URI varchar(256) not null,
257 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
258 VERSION_STR varchar(20),
259 DESCRIPTION varchar(1200),
260 SERVICE_PARAM_XSD varchar(2048),
261 RECIPE_TIMEOUT integer,
262 SERVICE_TIMEOUT_INTERIM integer,
266 create table SERVICE_TO_ALLOTTED_RESOURCES (
267 SERVICE_MODEL_UUID varchar(200) not null,
268 AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
269 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
270 primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
273 create table SERVICE_TO_NETWORKS (
274 SERVICE_MODEL_UUID varchar(200) not null,
275 NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
276 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
277 primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
280 create table SERVICE_TO_RESOURCE_CUSTOMIZATIONS (
281 MODEL_TYPE varchar(20) not null,
282 RESOURCE_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
283 SERVICE_MODEL_UUID varchar(200) not null,
284 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
285 primary key (MODEL_TYPE, RESOURCE_MODEL_CUSTOMIZATION_UUID, SERVICE_MODEL_UUID)
288 create table TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP (
289 NETWORK_RESOURCE_MODEL_NAME varchar(200) not null,
290 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
291 AIC_VERSION_MIN varchar(20) not null,
292 AIC_VERSION_MAX varchar(20),
293 primary key (NETWORK_RESOURCE_MODEL_NAME)
296 create table TOSCA_CSAR (
297 ARTIFACT_UUID varchar(200) not null,
298 NAME varchar(200) not null,
299 VERSION varchar(20) not null,
300 ARTIFACT_CHECKSUM varchar(200) not null,
301 URL varchar(200) not null,
302 DESCRIPTION varchar(1200),
303 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
304 primary key (ARTIFACT_UUID)
307 create table VF_MODULE (
308 MODEL_UUID varchar(200) not null,
309 VNF_RESOURCE_MODEL_UUID varchar(200),
310 MODEL_INVARIANT_UUID varchar(200),
311 MODEL_VERSION varchar(20) not null,
312 MODEL_NAME varchar(200) not null,
313 DESCRIPTION varchar(1200),
314 IS_BASE integer not null,
315 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
316 VOL_HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
317 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
318 primary key (MODEL_UUID)
321 create table VF_MODULE_CUSTOMIZATION (
322 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
323 VF_MODULE_MODEL_UUID varchar(200) not null,
324 VOL_ENVIRONMENT_ARTIFACT_UUID varchar(200),
325 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
326 HEAT_ENVIRONMENT_ARTIFACT_UUID varchar(200),
327 MIN_INSTANCES integer,
328 MAX_INSTANCES integer,
329 INITIAL_COUNT integer,
330 AVAILABILITY_ZONE_COUNT integer,
332 primary key (MODEL_CUSTOMIZATION_UUID)
335 create table VF_MODULE_TO_HEAT_FILES (
336 VF_MODULE_MODEL_UUID varchar(200) not null,
337 HEAT_FILES_ARTIFACT_UUID varchar(200) not null,
338 primary key (VF_MODULE_MODEL_UUID, HEAT_FILES_ARTIFACT_UUID)
341 create table VNF_COMPONENTS (
342 VNF_ID integer not null,
343 COMPONENT_TYPE varchar(20) not null,
344 HEAT_TEMPLATE_ID integer,
345 HEAT_ENVIRONMENT_ID integer,
346 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
347 primary key (VNF_ID, COMPONENT_TYPE)
350 create table VNF_COMPONENTS_RECIPE (
351 id integer not null auto_increment,
352 VNF_TYPE varchar(200),
353 VF_MODULE_MODEL_UUID varchar(100),
354 VNF_COMPONENT_TYPE varchar(45) not null,
355 ACTION varchar(40) not null,
356 SERVICE_TYPE varchar(45),
358 DESCRIPTION varchar(1200),
359 ORCHESTRATION_URI varchar(256) not null,
360 VNF_COMPONENT_PARAM_XSD varchar(2048),
361 RECIPE_TIMEOUT integer,
362 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
366 create table VNF_RECIPE (
367 id integer not null auto_increment,
368 VF_MODULE_ID varchar(100),
369 ACTION varchar(40) not null,
370 VERSION_STR varchar(20) not null,
371 VNF_TYPE varchar(200),
372 SERVICE_TYPE varchar(45) default null,
373 DESCRIPTION varchar(1200),
374 ORCHESTRATION_URI varchar(256) not null,
375 VNF_PARAM_XSD varchar(2048),
376 RECIPE_TIMEOUT integer,
377 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
381 create table VNF_RESOURCE (
382 MODEL_UUID varchar(200) not null,
383 MODEL_INVARIANT_UUID varchar(200),
384 MODEL_VERSION varchar(20) not null,
385 MODEL_NAME varchar(200),
386 TOSCA_NODE_TYPE varchar(200),
387 DESCRIPTION varchar(1200),
388 ORCHESTRATION_MODE varchar(20) not null,
389 AIC_VERSION_MIN varchar(20),
390 AIC_VERSION_MAX varchar(20),
391 RESOURCE_CATEGORY varchar(20),
392 RESOURCE_SUB_CATEGORY varchar(20),
393 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
394 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
395 primary key (MODEL_UUID)
398 create table VNF_RESOURCE_CUSTOMIZATION (
399 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
400 MODEL_INSTANCE_NAME varchar(200) not null,
401 MIN_INSTANCES integer,
402 MAX_INSTANCES integer,
403 AVAILABILITY_ZONE_MAX_COUNT integer,
404 NF_FUNCTION varchar(200),
405 NF_TYPE varchar(200),
406 NF_ROLE varchar(200),
407 NF_NAMING_CODE varchar(200),
408 MULTI_STAGE_DESIGN varchar(200),
409 VNF_RESOURCE_MODEL_UUID varchar(200) not null,
410 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
411 primary key (MODEL_CUSTOMIZATION_UUID)
414 create table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM (
415 VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
416 VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
417 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
418 primary key (VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID)
422 add constraint UK_rra00f1rk6eyy7g00k9raxh2v unique (MODEL_TYPE, MODEL_VERSION_ID);
424 alter table MODEL_RECIPE
425 add constraint UK_b4g8j9wtqrkxfycyi3ursk7gb unique (MODEL_ID, ACTION);
427 alter table NETWORK_RECIPE
428 add constraint UK_pbsa8i44m8p10f9529jdgfuk9 unique (MODEL_NAME, ACTION, VERSION_STR);
430 alter table SERVICE_RECIPE
431 add constraint UK_2lr377dpqnvl5aqlp5dtj2fcp unique (SERVICE_MODEL_UUID, ACTION);
433 alter table VNF_COMPONENTS_RECIPE
434 add constraint UK_g3je95aaxxiuest25f0qoy2u8 unique (VNF_TYPE, VF_MODULE_MODEL_UUID, VNF_COMPONENT_TYPE, ACTION, SERVICE_TYPE, VERSION);
436 alter table VNF_RECIPE
437 add constraint UK_f3tvqau498vrifq3cr8qnigkr unique (VF_MODULE_ID, ACTION, VERSION_STR);
439 alter table HEAT_TEMPLATE_PARAMS
440 add constraint FK_p3ol1xcvp831glqohrlu6o07o
441 foreign key (HEAT_TEMPLATE_ARTIFACT_UUID)
442 references HEAT_TEMPLATE (ARTIFACT_UUID);
444 alter table MODEL_RECIPE
445 add constraint FK_c23r0puyqug6n44jg39dutm1c
446 foreign key (MODEL_ID)
447 references MODEL (id);
450 add constraint FK_l3qy594u2xr1tfpmma3uigsna
451 foreign key (TOSCA_CSAR_ARTIFACT_UUID)
452 references TOSCA_CSAR (ARTIFACT_UUID);
454 alter table SERVICE_RECIPE
455 add constraint FK_i3r1b8j6e7dg9hkp49evnnm5y
456 foreign key (SERVICE_MODEL_UUID)
457 references SERVICE (MODEL_UUID);
459 alter table SERVICE_TO_RESOURCE_CUSTOMIZATIONS
460 add constraint FK_kiddaay6cfe0aob1f1jaio1bb
461 foreign key (SERVICE_MODEL_UUID)
462 references SERVICE (MODEL_UUID);
464 alter table VF_MODULE
465 add constraint FK_12jptc9it7gs3pru08skobxxc
466 foreign key (VNF_RESOURCE_MODEL_UUID)
467 references VNF_RESOURCE (MODEL_UUID);
469 alter table VNF_RESOURCE_CUSTOMIZATION
470 add constraint FK_iff1ayhb1hrp5jhea3vvikuni
471 foreign key (VNF_RESOURCE_MODEL_UUID)
472 references VNF_RESOURCE (MODEL_UUID);