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 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
214 AIC_VERSION_MIN varchar(20) default 2.5 not null,
215 AIC_VERSION_MAX varchar(20) default 2.5,
216 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
217 primary key (MODEL_UUID)
220 create table NETWORK_RESOURCE_CUSTOMIZATION (
221 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
222 NETWORK_RESOURCE_MODEL_UUID varchar(200) not null,
223 MODEL_INSTANCE_NAME varchar(255),
224 NETWORK_TECHNOLOGY varchar(255),
225 NETWORK_TYPE varchar(255),
226 NETWORK_SCOPE varchar(255),
227 NETWORK_ROLE varchar(255),
228 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
229 primary key (MODEL_CUSTOMIZATION_UUID)
232 create table SERVICE (
233 MODEL_UUID varchar(200) not null,
234 MODEL_NAME varchar(200) not null,
235 MODEL_VERSION varchar(20) not null,
236 DESCRIPTION varchar(1200),
237 TOSCA_CSAR_ARTIFACT_UUID varchar(200),
238 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
239 MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
240 SERVICE_TYPE varchar(20),
241 SERVICE_ROLE varchar(20),
242 primary key (MODEL_UUID)
245 create table SERVICE_RECIPE (
246 id integer not null auto_increment,
247 SERVICE_MODEL_UUID varchar(200) not null,
248 ACTION varchar(40) not null,
249 ORCHESTRATION_URI varchar(256) not null,
250 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
251 VERSION_STR varchar(20),
252 DESCRIPTION varchar(1200),
253 SERVICE_PARAM_XSD varchar(2048),
254 RECIPE_TIMEOUT integer,
255 SERVICE_TIMEOUT_INTERIM integer,
259 create table SERVICE_TO_ALLOTTED_RESOURCES (
260 SERVICE_MODEL_UUID varchar(200) not null,
261 AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
262 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
263 primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
266 create table SERVICE_TO_NETWORKS (
267 SERVICE_MODEL_UUID varchar(200) not null,
268 NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
269 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
270 primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
273 create table SERVICE_TO_RESOURCE_CUSTOMIZATIONS (
274 MODEL_TYPE varchar(20) not null,
275 RESOURCE_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
276 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
277 SERVICE_MODEL_UUID varchar(200) not null,
278 primary key (MODEL_TYPE, RESOURCE_MODEL_CUSTOMIZATION_UUID)
281 create table TEMP_NETWORK_HEAT_TEMPLATE_LOOKUP (
282 NETWORK_RESOURCE_MODEL_NAME varchar(200) not null,
283 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
284 AIC_VERSION_MIN varchar(20) not null,
285 AIC_VERSION_MAX varchar(20),
286 primary key (NETWORK_RESOURCE_MODEL_NAME)
289 create table TOSCA_CSAR (
290 ARTIFACT_UUID varchar(200) not null,
291 NAME varchar(200) not null,
292 VERSION varchar(20) not null,
293 ARTIFACT_CHECKSUM varchar(200) not null,
294 URL varchar(200) not null,
295 DESCRIPTION varchar(1200),
296 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
297 primary key (ARTIFACT_UUID)
300 create table VF_MODULE (
301 MODEL_UUID varchar(200) not null,
302 VNF_RESOURCE_MODEL_UUID varchar(200),
303 MODEL_INVARIANT_UUID varchar(200),
304 MODEL_VERSION varchar(20) not null,
305 MODEL_NAME varchar(200) not null,
306 DESCRIPTION varchar(1200),
307 IS_BASE integer not null,
308 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200) not null,
309 VOL_HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
310 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
311 primary key (MODEL_UUID)
314 create table VF_MODULE_CUSTOMIZATION (
315 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
316 VF_MODULE_MODEL_UUID varchar(200) not null,
317 VOL_ENVIRONMENT_ARTIFACT_UUID varchar(200),
318 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
319 HEAT_ENVIRONMENT_ARTIFACT_UUID varchar(200),
320 MIN_INSTANCES integer,
321 MAX_INSTANCES integer,
322 INITIAL_COUNT integer,
323 AVAILABILITY_ZONE_COUNT integer,
325 primary key (MODEL_CUSTOMIZATION_UUID)
328 create table VF_MODULE_TO_HEAT_FILES (
329 VF_MODULE_MODEL_UUID varchar(200) not null,
330 HEAT_FILES_ARTIFACT_UUID varchar(200) not null,
331 primary key (VF_MODULE_MODEL_UUID, HEAT_FILES_ARTIFACT_UUID)
334 create table VNF_COMPONENTS (
335 VNF_ID integer not null,
336 COMPONENT_TYPE varchar(20) not null,
337 HEAT_TEMPLATE_ID integer,
338 HEAT_ENVIRONMENT_ID integer,
339 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
340 primary key (VNF_ID, COMPONENT_TYPE)
343 create table VNF_COMPONENTS_RECIPE (
344 id integer not null auto_increment,
345 VNF_TYPE varchar(200),
346 VF_MODULE_MODEL_UUID varchar(100),
347 VNF_COMPONENT_TYPE varchar(45) not null,
348 ACTION varchar(20) not null,
349 SERVICE_TYPE varchar(45),
351 DESCRIPTION varchar(1200),
352 ORCHESTRATION_URI varchar(256) not null,
353 VNF_COMPONENT_PARAM_XSD varchar(2048),
354 RECIPE_TIMEOUT integer,
355 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
359 create table VNF_RECIPE (
360 id integer not null auto_increment,
361 VF_MODULE_ID varchar(100),
362 ACTION varchar(20) not null,
363 VERSION_STR varchar(20) not null,
364 VNF_TYPE varchar(200),
365 SERVICE_TYPE varchar(45) default null,
366 DESCRIPTION varchar(1200),
367 ORCHESTRATION_URI varchar(256) not null,
368 VNF_PARAM_XSD varchar(2048),
369 RECIPE_TIMEOUT integer,
370 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
374 create table VNF_RESOURCE (
375 MODEL_UUID varchar(200) not null,
376 MODEL_INVARIANT_UUID varchar(200),
377 MODEL_VERSION varchar(20) not null,
378 MODEL_NAME varchar(200),
379 TOSCA_NODE_TYPE varchar(200),
380 DESCRIPTION varchar(1200),
381 ORCHESTRATION_MODE varchar(20) not null,
382 AIC_VERSION_MIN varchar(20),
383 AIC_VERSION_MAX varchar(20),
384 HEAT_TEMPLATE_ARTIFACT_UUID varchar(200),
385 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
386 primary key (MODEL_UUID)
389 create table VNF_RESOURCE_CUSTOMIZATION (
390 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
391 MODEL_INSTANCE_NAME varchar(200) not null,
392 MIN_INSTANCES integer,
393 MAX_INSTANCES integer,
394 AVAILABILITY_ZONE_MAX_COUNT integer,
395 NF_FUNCTION varchar(200),
396 NF_TYPE varchar(200),
397 NF_ROLE varchar(200),
398 NF_NAMING_CODE varchar(200),
399 VNF_RESOURCE_MODEL_UUID varchar(200) not null,
400 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
401 primary key (MODEL_CUSTOMIZATION_UUID)
404 create table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM (
405 VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
406 VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
407 CREATION_TIMESTAMP datetime default CURRENT_TIMESTAMP,
408 primary key (VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID)
412 add constraint UK_rra00f1rk6eyy7g00k9raxh2v unique (MODEL_TYPE, MODEL_VERSION_ID);
414 alter table MODEL_RECIPE
415 add constraint UK_b4g8j9wtqrkxfycyi3ursk7gb unique (MODEL_ID, ACTION);
417 alter table NETWORK_RECIPE
418 add constraint UK_pbsa8i44m8p10f9529jdgfuk9 unique (MODEL_NAME, ACTION, VERSION_STR);
420 alter table SERVICE_RECIPE
421 add constraint UK_2lr377dpqnvl5aqlp5dtj2fcp unique (SERVICE_MODEL_UUID, ACTION);
423 alter table VNF_COMPONENTS_RECIPE
424 add constraint UK_g3je95aaxxiuest25f0qoy2u8 unique (VNF_TYPE, VF_MODULE_MODEL_UUID, VNF_COMPONENT_TYPE, ACTION, SERVICE_TYPE, VERSION);
426 alter table VNF_RECIPE
427 add constraint UK_f3tvqau498vrifq3cr8qnigkr unique (VF_MODULE_ID, ACTION, VERSION_STR);
429 alter table HEAT_TEMPLATE_PARAMS
430 add constraint FK_p3ol1xcvp831glqohrlu6o07o
431 foreign key (HEAT_TEMPLATE_ARTIFACT_UUID)
432 references HEAT_TEMPLATE (ARTIFACT_UUID);
434 alter table MODEL_RECIPE
435 add constraint FK_c23r0puyqug6n44jg39dutm1c
436 foreign key (MODEL_ID)
437 references MODEL (id);
440 add constraint FK_l3qy594u2xr1tfpmma3uigsna
441 foreign key (TOSCA_CSAR_ARTIFACT_UUID)
442 references TOSCA_CSAR (ARTIFACT_UUID);
444 alter table SERVICE_RECIPE
445 add constraint FK_i3r1b8j6e7dg9hkp49evnnm5y
446 foreign key (SERVICE_MODEL_UUID)
447 references SERVICE (MODEL_UUID);
449 alter table SERVICE_TO_RESOURCE_CUSTOMIZATIONS
450 add constraint FK_kiddaay6cfe0aob1f1jaio1bb
451 foreign key (SERVICE_MODEL_UUID)
452 references SERVICE (MODEL_UUID);
454 alter table VF_MODULE
455 add constraint FK_12jptc9it7gs3pru08skobxxc
456 foreign key (VNF_RESOURCE_MODEL_UUID)
457 references VNF_RESOURCE (MODEL_UUID);
459 alter table VNF_RESOURCE_CUSTOMIZATION
460 add constraint FK_iff1ayhb1hrp5jhea3vvikuni
461 foreign key (VNF_RESOURCE_MODEL_UUID)
462 references VNF_RESOURCE (MODEL_UUID);