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 alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM
32 foreign key FK_6tdyg2ib5eguh4k2qgofh4fj7;
34 drop table if exists ALLOTTED_RESOURCE;
36 drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION;
38 drop table if exists HEAT_ENVIRONMENT;
40 drop table if exists HEAT_FILES;
42 drop table if exists HEAT_NESTED_TEMPLATE;
44 drop table if exists HEAT_TEMPLATE;
46 drop table if exists HEAT_TEMPLATE_PARAMS;
48 drop table if exists MODEL;
50 drop table if exists MODEL_RECIPE;
52 drop table if exists NETWORK_RECIPE;
54 drop table if exists NETWORK_RESOURCE;
56 drop table if exists NETWORK_RESOURCE_CUSTOMIZATION;
58 drop table if exists SERVICE;
60 drop table if exists SERVICE_RECIPE;
62 drop table if exists SERVICE_TO_ALLOTTED_RESOURCES;
64 drop table if exists SERVICE_TO_NETWORKS;
66 drop table if exists SERVICE_TO_RESOURCE_CUSTOMIZATIONS;
68 drop table if exists TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP;
70 drop table if exists TOSCA_CSAR;
72 drop table if exists VF_MODULE;
74 drop table if exists VF_MODULE_CUSTOMIZATION;
76 drop table if exists VF_MODULE_TO_HEAT_FILES;
78 drop table if exists VNF_COMPONENTS;
80 drop table if exists VNF_COMPONENTS_RECIPE;
82 drop table if exists VNF_RECIPE;
84 drop table if exists VNF_RESOURCE;
86 drop table if exists VNF_RESOURCE_CUSTOMIZATION;
88 drop table if exists VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM;
90 create table ALLOTTED_RESOURCE (
91 MODEL_UUID varchar(255) not null,
92 MODEL_INVARIANT_UUID varchar(255),
93 MODEL_VERSION varchar(255),
94 MODEL_NAME varchar(255),
95 TOSCA_NODE_TYPE varchar(255),
96 SUBCATEGORY varchar(255),
97 DESCRIPTION varchar(255),
98 CREATION_TIMESTAMP datetime not null,
99 primary key (MODEL_UUID)
102 create table ALLOTTED_RESOURCE_CUSTOMIZATION (
103 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
104 MODEL_INSTANCE_NAME varchar(255),
105 AR_MODEL_UUID varchar(255),
106 PROVIDING_SERVICE_MODEL_INVARIANT_UUID varchar(255),
107 TARGET_NETWORK_ROLE varchar(255),
108 NF_FUNCTION varchar(255),
109 NF_TYPE varchar(255),
110 NF_ROLE varchar(255),
111 NF_NAMING_CODE varchar(255),
112 MIN_INSTANCES integer,
113 MAX_INSTANCES integer,
114 CREATION_TIMESTAMP datetime not null,
115 primary key (MODEL_CUSTOMIZATION_UUID)
118 create table HEAT_ENVIRONMENT (
119 ARTIFACT_UUID varchar(200) not null,
120 NAME varchar(100) not null,
121 VERSION varchar(20) not null,
122 DESCRIPTION varchar(1200),
123 BODY longtext not null,
124 CREATION_TIMESTAMP datetime not null,
125 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD',
126 primary key (ARTIFACT_UUID)
129 create table HEAT_FILES (
130 ARTIFACT_UUID varchar(255) not null,
131 DESCRIPTION varchar(255),
133 VERSION varchar(255),
135 CREATION_TIMESTAMP datetime not null,
136 ARTIFACT_CHECKSUM varchar(255),
137 primary key (ARTIFACT_UUID)
140 create table HEAT_NESTED_TEMPLATE (
141 PARENT_HEAT_TEMPLATE_UUID varchar(200) not null,
142 CHILD_HEAT_TEMPLATE_UUID varchar(200) not null,
143 PROVIDER_RESOURCE_FILE varchar(100),
144 primary key (PARENT_HEAT_TEMPLATE_UUID, CHILD_HEAT_TEMPLATE_UUID)
147 create table HEAT_TEMPLATE (
148 ARTIFACT_UUID varchar(200) not null,
149 NAME varchar(200) not null,
150 VERSION varchar(20) not null,
151 BODY longtext not null,
152 TIMEOUT_MINUTES integer,
153 DESCRIPTION varchar(1200),
154 CREATION_TIMESTAMP datetime not null,
155 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
156 primary key (ARTIFACT_UUID)
159 create table HEAT_TEMPLATE_PARAMS (
160 HEAT_TEMPLATE_ARTIFACT_UUID varchar(255) not null,
161 PARAM_NAME varchar(255) not null,
162 IS_REQUIRED bit not null,
163 PARAM_TYPE varchar(20),
164 PARAM_ALIAS varchar(45),
165 primary key (HEAT_TEMPLATE_ARTIFACT_UUID, PARAM_NAME)
169 id integer not null auto_increment,
170 MODEL_TYPE varchar(20) not null,
171 MODEL_VERSION_ID varchar(40) not null,
172 MODEL_INVARIANT_ID varchar(40),
173 MODEL_NAME varchar(40) not null,
174 MODEL_VERSION varchar(20),
175 MODEL_CUSTOMIZATION_ID varchar(40),
176 MODEL_CUSTOMIZATION_NAME varchar(40),
177 CREATION_TIMESTAMP datetime not null,
181 create table MODEL_RECIPE (
182 id integer not null auto_increment,
183 MODEL_ID integer not null,
184 ACTION varchar(20) not null,
185 SCHEMA_VERSION varchar(20),
186 DESCRIPTION varchar(1200),
187 ORCHESTRATION_URI varchar(256) not null,
188 MODEL_PARAM_XSD varchar(2048),
189 RECIPE_TIMEOUT integer,
190 CREATION_TIMESTAMP datetime not null,
194 create table NETWORK_RECIPE (
195 id integer not null auto_increment,
196 MODEL_NAME varchar(20) not null,
197 ACTION varchar(20) not null,
198 VERSION_STR varchar(20) not null,
199 SERVICE_TYPE varchar(45),
200 DESCRIPTION varchar(1200),
201 ORCHESTRATION_URI varchar(256) not null,
202 NETWORK_PARAM_XSD varchar(2048),
203 RECIPE_TIMEOUT integer,
204 CREATION_TIMESTAMP datetime not null,
208 create table NETWORK_RESOURCE (
209 MODEL_UUID varchar(200) not null,
210 MODEL_NAME varchar(200) not null,
211 MODEL_INVARIANT_UUID varchar(20),
212 MODEL_VERSION varchar(20),
213 TOSCA_NODE_TYPE varchar(200),
214 NEUTRON_NETWORK_TYPE varchar(20),
215 DESCRIPTION varchar(1200),
216 ORCHESTRATION_MODE 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 not null,
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 not null,
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 not null,
243 MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
244 SERVICE_TYPE varchar(20),
245 SERVICE_ROLE varchar(20),
246 primary key (MODEL_UUID)
249 create table SERVICE_RECIPE (
250 id integer not null auto_increment,
251 SERVICE_MODEL_UUID varchar(200) not null,
252 ACTION varchar(40) not null,
253 ORCHESTRATION_URI varchar(256) not null,
254 CREATION_TIMESTAMP datetime not null,
255 VERSION_STR varchar(20),
256 DESCRIPTION varchar(1200),
257 SERVICE_PARAM_XSD varchar(2048),
258 RECIPE_TIMEOUT integer,
259 SERVICE_TIMEOUT_INTERIM integer,
263 create table SERVICE_TO_ALLOTTED_RESOURCES (
264 SERVICE_MODEL_UUID varchar(200) not null,
265 AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
266 CREATION_TIMESTAMP datetime not null,
267 primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
270 create table SERVICE_TO_NETWORKS (
271 SERVICE_MODEL_UUID varchar(200) not null,
272 NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
273 CREATION_TIMESTAMP datetime not null,
274 primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
277 create table SERVICE_TO_RESOURCE_CUSTOMIZATIONS (
278 MODEL_TYPE varchar(20) not null,
279 RESOURCE_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
280 CREATION_TIMESTAMP datetime not null,
281 SERVICE_MODEL_UUID varchar(200) not null,
282 primary key (MODEL_TYPE, RESOURCE_MODEL_CUSTOMIZATION_UUID)
285 create table TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP (
286 NETWORK_RESOURCE_MODEL_NAME varchar(200) not null,
287 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
288 AIC_VERSION_MIN varchar(20) not null,
289 AIC_VERSION_MAX varchar(20),
290 primary key (NETWORK_RESOURCE_MODEL_NAME)
293 create table TOSCA_CSAR (
294 ARTIFACT_UUID varchar(200) not null,
295 NAME varchar(200) not null,
296 VERSION varchar(20) not null,
297 ARTIFACT_CHECKSUM varchar(200) not null,
298 URL varchar(200) not null,
299 DESCRIPTION varchar(1200),
300 CREATION_TIMESTAMP datetime not null,
301 primary key (ARTIFACT_UUID)
304 create table VF_MODULE (
305 MODEL_UUID varchar(200) not null,
306 VNF_RESOURCE_MODEL_UUID varchar(200),
307 MODEL_INVARIANT_UUID varchar(200),
308 MODEL_VERSION varchar(20) not null,
309 MODEL_NAME varchar(200) not null,
310 DESCRIPTION varchar(1200),
311 IS_BASE integer not null,
312 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
313 VOL_HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
314 CREATION_TIMESTAMP datetime not null,
315 primary key (MODEL_UUID)
318 create table VF_MODULE_CUSTOMIZATION (
319 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
320 VF_MODULE_MODEL_UUID varchar(200) not null,
321 VOL_ENVIRONMENT_ARTIFACT_UUID varchar(200),
322 CREATION_TIMESTAMP datetime not null,
323 HEAT_ENVIRONMENT_ARTIFACT_UUID varchar(200),
324 MIN_INSTANCES integer,
325 MAX_INSTANCES integer,
326 INITIAL_COUNT integer,
327 AVAILABILITY_ZONE_COUNT integer,
329 primary key (MODEL_CUSTOMIZATION_UUID)
332 create table VF_MODULE_TO_HEAT_FILES (
333 VF_MODULE_MODEL_UUID varchar(200) not null,
334 HEAT_FILES_ARTIFACT_UUID varchar(200) not null,
335 primary key (VF_MODULE_MODEL_UUID, HEAT_FILES_ARTIFACT_UUID)
338 create table VNF_COMPONENTS (
339 VNF_ID integer not null,
340 COMPONENT_TYPE varchar(20) not null,
341 HEAT_TEMPLATE_ID integer,
342 HEAT_ENVIRONMENT_ID integer,
343 CREATION_TIMESTAMP datetime not null,
344 primary key (VNF_ID, COMPONENT_TYPE)
347 create table VNF_COMPONENTS_RECIPE (
348 id integer not null auto_increment,
349 VNF_TYPE varchar(200),
350 VF_MODULE_MODEL_UUID varchar(100),
351 VNF_COMPONENT_TYPE varchar(45) not null,
352 ACTION varchar(20) not null,
353 SERVICE_TYPE varchar(45),
355 DESCRIPTION varchar(1200),
356 ORCHESTRATION_URI varchar(256) not null,
357 VNF_COMPONENT_PARAM_XSD varchar(2048),
358 RECIPE_TIMEOUT integer,
359 CREATION_TIMESTAMP datetime,
363 create table VNF_RECIPE (
364 id integer not null auto_increment,
365 VF_MODULE_ID varchar(100),
366 ACTION varchar(20) not null,
367 VERSION_STR varchar(20) not null,
368 VNF_TYPE varchar(200),
369 SERVICE_TYPE varchar(45) default null,
370 DESCRIPTION varchar(1200),
371 ORCHESTRATION_URI varchar(256) not null,
372 VNF_PARAM_XSD varchar(2048),
373 RECIPE_TIMEOUT integer,
374 CREATION_TIMESTAMP datetime,
378 create table VNF_RESOURCE (
379 MODEL_UUID varchar(200) not null,
380 MODEL_INVARIANT_UUID varchar(200),
381 MODEL_VERSION varchar(20) not null,
382 MODEL_NAME varchar(200),
383 TOSCA_NODE_TYPE varchar(200),
384 DESCRIPTION varchar(1200),
385 ORCHESTRATION_MODE varchar(20) not null,
386 AIC_VERSION_MIN varchar(20),
387 AIC_VERSION_MAX varchar(20),
388 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
389 CREATION_TIMESTAMP datetime not null,
390 primary key (MODEL_UUID)
393 create table VNF_RESOURCE_CUSTOMIZATION (
394 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
395 MODEL_INSTANCE_NAME varchar(200) not null,
396 MIN_INSTANCES integer,
397 MAX_INSTANCES integer,
398 AVAILABILITY_ZONE_MAX_COUNT integer,
399 NF_FUNCTION varchar(200),
400 NF_TYPE varchar(200),
401 NF_ROLE varchar(200),
402 NF_NAMING_CODE varchar(200),
403 VNF_RESOURCE_MODEL_UUID varchar(200) not null,
404 CREATION_TIMESTAMP datetime not null,
405 primary key (MODEL_CUSTOMIZATION_UUID)
408 create table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM (
409 VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
410 VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
411 CREATION_TIMESTAMP datetime not null,
412 VNF_RESOURCE_MODEL_UUID varchar(200) not null,
413 primary key (VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID)
417 add constraint UK_rra00f1rk6eyy7g00k9raxh2v unique (MODEL_TYPE, MODEL_VERSION_ID);
419 alter table MODEL_RECIPE
420 add constraint UK_b4g8j9wtqrkxfycyi3ursk7gb unique (MODEL_ID, ACTION);
422 alter table NETWORK_RECIPE
423 add constraint UK_pbsa8i44m8p10f9529jdgfuk9 unique (MODEL_NAME, ACTION, VERSION_STR);
425 alter table SERVICE_RECIPE
426 add constraint UK_2lr377dpqnvl5aqlp5dtj2fcp unique (SERVICE_MODEL_UUID, ACTION);
428 alter table VNF_COMPONENTS_RECIPE
429 add constraint UK_g3je95aaxxiuest25f0qoy2u8 unique (VNF_TYPE, VF_MODULE_MODEL_UUID, VNF_COMPONENT_TYPE, ACTION, SERVICE_TYPE, VERSION);
431 alter table VNF_RECIPE
432 add constraint UK_f3tvqau498vrifq3cr8qnigkr unique (VF_MODULE_ID, ACTION, VERSION_STR);
434 alter table HEAT_TEMPLATE_PARAMS
435 add constraint FK_p3ol1xcvp831glqohrlu6o07o
436 foreign key (HEAT_TEMPLATE_ARTIFACT_UUID)
437 references HEAT_TEMPLATE (ARTIFACT_UUID);
439 alter table MODEL_RECIPE
440 add constraint FK_c23r0puyqug6n44jg39dutm1c
441 foreign key (MODEL_ID)
442 references MODEL (id);
445 add constraint FK_l3qy594u2xr1tfpmma3uigsna
446 foreign key (TOSCA_CSAR_ARTIFACT_UUID)
447 references TOSCA_CSAR (ARTIFACT_UUID);
449 alter table SERVICE_RECIPE
450 add constraint FK_i3r1b8j6e7dg9hkp49evnnm5y
451 foreign key (SERVICE_MODEL_UUID)
452 references SERVICE (MODEL_UUID);
454 alter table SERVICE_TO_RESOURCE_CUSTOMIZATIONS
455 add constraint FK_kiddaay6cfe0aob1f1jaio1bb
456 foreign key (SERVICE_MODEL_UUID)
457 references SERVICE (MODEL_UUID);
459 alter table VF_MODULE
460 add constraint FK_12jptc9it7gs3pru08skobxxc
461 foreign key (VNF_RESOURCE_MODEL_UUID)
462 references VNF_RESOURCE (MODEL_UUID);
464 alter table VNF_RESOURCE_CUSTOMIZATION
465 add constraint FK_iff1ayhb1hrp5jhea3vvikuni
466 foreign key (VNF_RESOURCE_MODEL_UUID)
467 references VNF_RESOURCE (MODEL_UUID);
469 alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM
470 add constraint FK_6tdyg2ib5eguh4k2qgofh4fj7
471 foreign key (VNF_RESOURCE_MODEL_UUID)
472 references VNF_RESOURCE_CUSTOMIZATION (MODEL_CUSTOMIZATION_UUID);