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 primary key (MODEL_CUSTOMIZATION_UUID)
114 create table HEAT_ENVIRONMENT (
115 ARTIFACT_UUID varchar(200) not null,
116 NAME varchar(100) not null,
117 VERSION varchar(20) not null,
118 DESCRIPTION varchar(1200),
119 BODY longtext not null,
120 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
121 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD',
122 primary key (ARTIFACT_UUID)
125 create table HEAT_FILES (
126 ARTIFACT_UUID varchar(255) not null,
127 DESCRIPTION varchar(255),
129 VERSION varchar(255),
131 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
132 ARTIFACT_CHECKSUM varchar(255),
133 primary key (ARTIFACT_UUID)
136 create table HEAT_NESTED_TEMPLATE (
137 PARENT_HEAT_TEMPLATE_UUID varchar(200) not null,
138 CHILD_HEAT_TEMPLATE_UUID varchar(200) not null,
139 PROVIDER_RESOURCE_FILE varchar(100),
140 primary key (PARENT_HEAT_TEMPLATE_UUID, CHILD_HEAT_TEMPLATE_UUID)
143 create table HEAT_TEMPLATE (
144 ARTIFACT_UUID varchar(200) not null,
145 NAME varchar(200) not null,
146 VERSION varchar(20) not null,
147 BODY longtext not null,
148 TIMEOUT_MINUTES integer,
149 DESCRIPTION varchar(1200),
150 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
151 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
152 primary key (ARTIFACT_UUID)
155 create table HEAT_TEMPLATE_PARAMS (
156 HEAT_TEMPLATE_ARTIFACT_UUID varchar(255) not null,
157 PARAM_NAME varchar(255) not null,
158 IS_REQUIRED bit not null,
159 PARAM_TYPE varchar(20),
160 PARAM_ALIAS varchar(45),
161 primary key (HEAT_TEMPLATE_ARTIFACT_UUID, PARAM_NAME)
165 id integer not null auto_increment,
166 MODEL_TYPE varchar(20) not null,
167 MODEL_VERSION_ID varchar(40) not null,
168 MODEL_INVARIANT_ID varchar(40),
169 MODEL_NAME varchar(40) not null,
170 MODEL_VERSION varchar(20),
171 MODEL_CUSTOMIZATION_ID varchar(40),
172 MODEL_CUSTOMIZATION_NAME varchar(40),
173 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
177 create table MODEL_RECIPE (
178 id integer not null auto_increment,
179 MODEL_ID integer not null,
180 ACTION varchar(20) not null,
181 SCHEMA_VERSION varchar(20),
182 DESCRIPTION varchar(1200),
183 ORCHESTRATION_URI varchar(256) not null,
184 MODEL_PARAM_XSD varchar(2048),
185 RECIPE_TIMEOUT integer,
186 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
190 create table NETWORK_RECIPE (
191 id integer not null auto_increment,
192 MODEL_NAME varchar(20) not null,
193 ACTION varchar(20) not null,
194 VERSION_STR varchar(20) not null,
195 SERVICE_TYPE varchar(45),
196 DESCRIPTION varchar(1200),
197 ORCHESTRATION_URI varchar(256) not null,
198 NETWORK_PARAM_XSD varchar(2048),
199 RECIPE_TIMEOUT integer,
200 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
204 create table NETWORK_RESOURCE (
205 MODEL_UUID varchar(200) not null,
206 MODEL_NAME varchar(200) not null,
207 MODEL_INVARIANT_UUID varchar(200),
208 MODEL_VERSION varchar(20),
209 TOSCA_NODE_TYPE varchar(200),
210 NEUTRON_NETWORK_TYPE varchar(20),
211 DESCRIPTION varchar(1200),
212 ORCHESTRATION_MODE varchar(20),
213 RESOURCE_CATEGORY varchar(20),
214 RESOURCE_SUB_CATEGORY varchar(20),
215 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
216 AIC_VERSION_MIN varchar(20) default 2.5 not null,
217 AIC_VERSION_MAX varchar(20) default 2.5,
218 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
219 primary key (MODEL_UUID)
222 create table NETWORK_RESOURCE_CUSTOMIZATION (
223 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
224 NETWORK_RESOURCE_MODEL_UUID varchar(200) not null,
225 MODEL_INSTANCE_NAME varchar(255),
226 NETWORK_TECHNOLOGY varchar(255),
227 NETWORK_TYPE varchar(255),
228 NETWORK_SCOPE varchar(255),
229 NETWORK_ROLE varchar(255),
230 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
231 primary key (MODEL_CUSTOMIZATION_UUID)
234 create table SERVICE (
235 MODEL_UUID varchar(200) not null,
236 MODEL_NAME varchar(200) not null,
237 MODEL_VERSION varchar(20) not null,
238 DESCRIPTION varchar(1200),
239 TOSCA_CSAR_ARTIFACT_UUID varchar(200),
240 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
241 MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
242 SERVICE_CATEGORY varchar(20),
243 SERVICE_TYPE varchar(20),
244 SERVICE_ROLE varchar(20),
245 primary key (MODEL_UUID)
248 create table SERVICE_RECIPE (
249 id integer not null auto_increment,
250 SERVICE_MODEL_UUID varchar(200) not null,
251 ACTION varchar(40) not null,
252 ORCHESTRATION_URI varchar(256) not null,
253 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
254 VERSION_STR varchar(20),
255 DESCRIPTION varchar(1200),
256 SERVICE_PARAM_XSD varchar(2048),
257 RECIPE_TIMEOUT integer,
258 SERVICE_TIMEOUT_INTERIM integer,
262 create table SERVICE_TO_ALLOTTED_RESOURCES (
263 SERVICE_MODEL_UUID varchar(200) not null,
264 AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
265 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
266 primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
269 create table SERVICE_TO_NETWORKS (
270 SERVICE_MODEL_UUID varchar(200) not null,
271 NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
272 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
273 primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
276 create table SERVICE_TO_RESOURCE_CUSTOMIZATIONS (
277 MODEL_TYPE varchar(20) not null,
278 RESOURCE_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
279 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
280 SERVICE_MODEL_UUID varchar(200) not null,
281 primary key (MODEL_TYPE, RESOURCE_MODEL_CUSTOMIZATION_UUID)
284 create table TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP (
285 NETWORK_RESOURCE_MODEL_NAME varchar(200) not null,
286 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
287 AIC_VERSION_MIN varchar(20) not null,
288 AIC_VERSION_MAX varchar(20),
289 primary key (NETWORK_RESOURCE_MODEL_NAME)
292 create table TOSCA_CSAR (
293 ARTIFACT_UUID varchar(200) not null,
294 NAME varchar(200) not null,
295 VERSION varchar(20) not null,
296 ARTIFACT_CHECKSUM varchar(200) not null,
297 URL varchar(200) not null,
298 DESCRIPTION varchar(1200),
299 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
300 primary key (ARTIFACT_UUID)
303 create table VF_MODULE (
304 MODEL_UUID varchar(200) not null,
305 VNF_RESOURCE_MODEL_UUID varchar(200),
306 MODEL_INVARIANT_UUID varchar(200),
307 MODEL_VERSION varchar(20) not null,
308 MODEL_NAME varchar(200) not null,
309 DESCRIPTION varchar(1200),
310 IS_BASE integer not null,
311 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
312 VOL_HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
313 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
314 primary key (MODEL_UUID)
317 create table VF_MODULE_CUSTOMIZATION (
318 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
319 VF_MODULE_MODEL_UUID varchar(200) not null,
320 VOL_ENVIRONMENT_ARTIFACT_UUID varchar(200),
321 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
322 HEAT_ENVIRONMENT_ARTIFACT_UUID varchar(200),
323 MIN_INSTANCES integer,
324 MAX_INSTANCES integer,
325 INITIAL_COUNT integer,
326 AVAILABILITY_ZONE_COUNT integer,
328 primary key (MODEL_CUSTOMIZATION_UUID)
331 create table VF_MODULE_TO_HEAT_FILES (
332 VF_MODULE_MODEL_UUID varchar(200) not null,
333 HEAT_FILES_ARTIFACT_UUID varchar(200) not null,
334 primary key (VF_MODULE_MODEL_UUID, HEAT_FILES_ARTIFACT_UUID)
337 create table VNF_COMPONENTS (
338 VNF_ID integer not null,
339 COMPONENT_TYPE varchar(20) not null,
340 HEAT_TEMPLATE_ID integer,
341 HEAT_ENVIRONMENT_ID integer,
342 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
343 primary key (VNF_ID, COMPONENT_TYPE)
346 create table VNF_COMPONENTS_RECIPE (
347 id integer not null auto_increment,
348 VNF_TYPE varchar(200),
349 VF_MODULE_MODEL_UUID varchar(100),
350 VNF_COMPONENT_TYPE varchar(45) not null,
351 ACTION varchar(20) not null,
352 SERVICE_TYPE varchar(45),
354 DESCRIPTION varchar(1200),
355 ORCHESTRATION_URI varchar(256) not null,
356 VNF_COMPONENT_PARAM_XSD varchar(2048),
357 RECIPE_TIMEOUT integer,
358 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
362 create table VNF_RECIPE (
363 id integer not null auto_increment,
364 VF_MODULE_ID varchar(100),
365 ACTION varchar(20) not null,
366 VERSION_STR varchar(20) not null,
367 VNF_TYPE varchar(200),
368 SERVICE_TYPE varchar(45) default null,
369 DESCRIPTION varchar(1200),
370 ORCHESTRATION_URI varchar(256) not null,
371 VNF_PARAM_XSD varchar(2048),
372 RECIPE_TIMEOUT integer,
373 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
377 create table VNF_RESOURCE (
378 MODEL_UUID varchar(200) not null,
379 MODEL_INVARIANT_UUID varchar(200),
380 MODEL_VERSION varchar(20) not null,
381 MODEL_NAME varchar(200),
382 TOSCA_NODE_TYPE varchar(200),
383 DESCRIPTION varchar(1200),
384 ORCHESTRATION_MODE varchar(20) not null,
385 AIC_VERSION_MIN varchar(20),
386 AIC_VERSION_MAX varchar(20),
387 RESOURCE_CATEGORY varchar(20),
388 RESOURCE_SUB_CATEGORY varchar(20),
389 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
390 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
391 primary key (MODEL_UUID)
394 create table VNF_RESOURCE_CUSTOMIZATION (
395 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
396 MODEL_INSTANCE_NAME varchar(200) not null,
397 MIN_INSTANCES integer,
398 MAX_INSTANCES integer,
399 AVAILABILITY_ZONE_MAX_COUNT integer,
400 NF_FUNCTION varchar(200),
401 NF_TYPE varchar(200),
402 NF_ROLE varchar(200),
403 NF_NAMING_CODE varchar(200),
404 VNF_RESOURCE_MODEL_UUID varchar(200) not null,
405 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
406 primary key (MODEL_CUSTOMIZATION_UUID)
409 create table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM (
410 VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
411 VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
412 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
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);