2 alter table HEAT_TEMPLATE
4 foreign key FK_ek5sot1q07taorbdmkvnveu98;
6 alter table HEAT_TEMPLATE_PARAMS
8 foreign key FK_8sxvm215cw3tjfh3wni2y3myx;
10 alter table MODEL_RECIPE
12 foreign key FK_c23r0puyqug6n44jg39dutm1c;
14 alter table SERVICE_RECIPE
16 foreign key FK_kv13yx013qtqkn94d5gkwbu3s;
18 drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION;
20 drop table if exists HEAT_ENVIRONMENT;
22 drop table if exists HEAT_FILES;
24 drop table if exists HEAT_NESTED_TEMPLATE;
26 drop table if exists HEAT_TEMPLATE;
28 drop table if exists HEAT_TEMPLATE_PARAMS;
30 drop table if exists MODEL;
32 drop table if exists MODEL_RECIPE;
34 drop table if exists NETWORK_RECIPE;
36 drop table if exists NETWORK_RESOURCE;
38 drop table if exists NETWORK_RESOURCE_CUSTOMIZATION;
40 drop table if exists SERVICE;
42 drop table if exists SERVICE_RECIPE;
44 drop table if exists SERVICE_TO_ALLOTTED_RESOURCES;
46 drop table if exists SERVICE_TO_NETWORKS;
48 drop table if exists VF_MODULE;
50 drop table if exists VF_MODULE_TO_HEAT_FILES;
52 drop table if exists VNF_COMPONENTS;
54 drop table if exists VNF_COMPONENTS_RECIPE;
56 drop table if exists VNF_RECIPE;
58 drop table if exists VNF_RESOURCE;
60 create table ALLOTTED_RESOURCE_CUSTOMIZATION (
61 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
62 MODEL_VERSION varchar(20) not null,
63 MODEL_UUID varchar(200) not null,
64 MODEL_NAME varchar(200) not null,
65 MODEL_INSTANCE_NAME varchar(200) not null,
66 CREATION_TIMESTAMP datetime not null,
67 DESCRIPTION varchar(200) default null,
68 MODEL_INVARIANT_UUID varchar(200) not null,
69 primary key (MODEL_CUSTOMIZATION_UUID)
72 create table HEAT_ENVIRONMENT (
73 id integer not null auto_increment,
74 NAME varchar(100) not null,
75 VERSION varchar(20) not null,
76 ASDC_RESOURCE_NAME varchar(100) default 'MANUAL RECORD' not null,
77 ASDC_UUID varchar(200) default 'MANUAL RECORD' not null,
78 DESCRIPTION varchar(1200),
79 ENVIRONMENT longtext not null,
80 CREATION_TIMESTAMP datetime not null,
81 ASDC_LABEL varchar(200),
82 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
86 create table HEAT_FILES (
87 id integer not null auto_increment,
88 DESCRIPTION varchar(1200) default null,
89 FILE_NAME varchar(200) not null,
90 ASDC_RESOURCE_NAME varchar(100) not null,
91 VERSION varchar(20) not null,
92 ASDC_UUID varchar(200) default 'MANUAL RECORD',
93 FILE_BODY longtext not null,
94 VNF_RESOURCE_ID integer default null,
95 CREATION_TIMESTAMP datetime not null,
96 ASDC_LABEL varchar(200),
97 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
101 create table HEAT_NESTED_TEMPLATE (
102 PARENT_TEMPLATE_ID integer not null,
103 CHILD_TEMPLATE_ID integer not null,
104 PROVIDER_RESOURCE_FILE varchar(100),
105 primary key (PARENT_TEMPLATE_ID, CHILD_TEMPLATE_ID)
108 create table HEAT_TEMPLATE (
109 id integer not null auto_increment,
110 TEMPLATE_NAME varchar(200) not null,
111 VERSION varchar(20) not null,
112 ASDC_RESOURCE_NAME varchar(100) default 'MANUAL RECORD' not null,
113 ASDC_UUID varchar(200) default 'MANUAL RECORD' not null,
114 TEMPLATE_PATH varchar(100),
115 TEMPLATE_BODY longtext not null,
116 TIMEOUT_MINUTES integer,
117 DESCRIPTION varchar(1200),
118 ASDC_LABEL varchar(200),
119 ARTIFACT_CHECKSUM varchar(200) default 'MANUAL RECORD' not null,
120 CREATION_TIMESTAMP datetime not null,
121 CHILD_TEMPLATE_ID integer,
125 create table HEAT_TEMPLATE_PARAMS (
126 id integer not null auto_increment,
127 HEAT_TEMPLATE_ID integer not null,
128 PARAM_NAME varchar(100) not null,
129 IS_REQUIRED bit not null,
130 PARAM_TYPE varchar(20),
131 PARAM_ALIAS varchar(45),
136 id integer not null auto_increment,
137 MODEL_TYPE varchar(20) not null,
138 MODEL_VERSION_ID varchar(40) not null,
139 MODEL_INVARIANT_ID varchar(40),
140 MODEL_NAME varchar(40) not null,
141 MODEL_VERSION varchar(20),
142 MODEL_CUSTOMIZATION_ID varchar(40),
143 MODEL_CUSTOMIZATION_NAME varchar(40),
144 CREATION_TIMESTAMP datetime not null,
148 create table MODEL_RECIPE (
149 id integer not null auto_increment,
150 MODEL_ID integer not null,
151 ACTION varchar(20) not null,
152 SCHEMA_VERSION varchar(20),
153 DESCRIPTION varchar(1200),
154 ORCHESTRATION_URI varchar(256) not null,
155 MODEL_PARAM_XSD varchar(2048),
156 RECIPE_TIMEOUT integer,
157 CREATION_TIMESTAMP datetime not null,
161 create table NETWORK_RECIPE (
162 id integer not null auto_increment,
163 NETWORK_TYPE varchar(20) not null,
164 ACTION varchar(20) not null,
165 VERSION_STR varchar(20) not null,
166 DESCRIPTION varchar(1200),
167 ORCHESTRATION_URI varchar(256) not null,
168 NETWORK_PARAM_XSD varchar(2048),
169 RECIPE_TIMEOUT integer,
170 SERVICE_TYPE varchar(45) default null,
171 CREATION_TIMESTAMP datetime not null,
175 create table NETWORK_RESOURCE (
177 NETWORK_TYPE varchar(45) not null,
178 VERSION_STR varchar(20) not null,
179 ORCHESTRATION_MODE varchar(20),
180 DESCRIPTION varchar(1200),
182 NEUTRON_NETWORK_TYPE varchar(20) default null,
183 CREATION_TIMESTAMP datetime not null,
184 AIC_VERSION_MIN varchar(20) not null,
185 AIC_VERSION_MAX varchar(20) default null,
189 create table NETWORK_RESOURCE_CUSTOMIZATION (
190 MODEL_CUSTOMIZATION_UUID varchar(200) not null,
191 NETWORK_RESOURCE_ID integer default null,
192 MODEL_UUID varchar(200) not null,
193 MODEL_NAME varchar(200) not null,
194 MODEL_INSTANCE_NAME varchar(200) not null,
195 MODEL_VERSION varchar(20) not null,
196 MODEL_INVARIANT_UUID varchar(200) not null,
197 CREATION_TIMESTAMP datetime not null,
198 primary key (MODEL_CUSTOMIZATION_UUID, NETWORK_RESOURCE_ID)
201 create table SERVICE (
202 id integer not null auto_increment,
203 SERVICE_NAME_VERSION_ID varchar(50) default 'MANUAL_RECORD' not null,
204 SERVICE_NAME varchar(40),
205 VERSION_STR varchar(20) not null,
206 DESCRIPTION varchar(1200),
207 SERVICE_VERSION varchar(10),
208 HTTP_METHOD varchar(50),
209 CREATION_TIMESTAMP datetime not null,
210 MODEL_INVARIANT_UUID varchar(200) default 'MANUAL_RECORD' not null,
214 create table SERVICE_RECIPE (
215 id integer not null auto_increment,
216 SERVICE_ID integer not null,
217 ACTION varchar(40) not null,
218 VERSION_STR varchar(20) default null,
219 DESCRIPTION varchar(1200),
220 ORCHESTRATION_URI varchar(256) not null,
221 SERVICE_PARAM_XSD varchar(2048),
222 RECIPE_TIMEOUT integer,
223 SERVICE_TIMEOUT_INTERIM integer,
224 CREATION_TIMESTAMP datetime not null,
228 create table SERVICE_TO_ALLOTTED_RESOURCES (
229 SERVICE_MODEL_UUID varchar(200) not null,
230 AR_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
231 CREATION_TIMESTAMP datetime not null,
232 primary key (SERVICE_MODEL_UUID, AR_MODEL_CUSTOMIZATION_UUID)
235 create table SERVICE_TO_NETWORKS (
236 SERVICE_MODEL_UUID varchar(200) not null,
237 NETWORK_MODEL_CUSTOMIZATION_UUID varchar(200) not null,
238 CREATION_TIMESTAMP datetime not null,
239 primary key (SERVICE_MODEL_UUID, NETWORK_MODEL_CUSTOMIZATION_UUID)
242 create table VF_MODULE (
243 id integer not null auto_increment,
244 ASDC_UUID varchar(200) default null,
245 VOL_ENVIRONMENT_ID integer default null,
246 TYPE varchar(200) not null,
247 ASDC_SERVICE_MODEL_VERSION varchar(20) not null,
248 MODEL_CUSTOMIZATION_UUID varchar(200),
249 MODEL_NAME varchar(200) not null,
250 MODEL_VERSION varchar(20) not null,
251 CREATION_TIMESTAMP datetime not null,
252 DESCRIPTION varchar(255) default null,
253 VOL_TEMPLATE_ID integer default null,
254 TEMPLATE_ID integer default null,
255 VNF_RESOURCE_ID integer not null,
256 IS_BASE integer not null,
257 ENVIRONMENT_ID integer,
258 MODEL_INVARIANT_UUID varchar(200) default null,
259 MIN_INSTANCES integer default 0,
260 MAX_INSTANCES integer default null,
261 INITIAL_COUNT integer default 0,
262 LABEL varchar(200) default null,
266 create table VF_MODULE_TO_HEAT_FILES (
267 VF_MODULE_ID integer not null,
268 HEAT_FILES_ID integer not null,
269 primary key (VF_MODULE_ID, HEAT_FILES_ID)
272 create table VNF_COMPONENTS (
273 VNF_ID integer not null,
274 COMPONENT_TYPE varchar(20) not null,
275 HEAT_TEMPLATE_ID integer,
276 HEAT_ENVIRONMENT_ID integer,
277 CREATION_TIMESTAMP datetime not null,
278 primary key (VNF_ID, COMPONENT_TYPE)
281 create table VNF_COMPONENTS_RECIPE (
282 id integer not null auto_increment,
283 VNF_TYPE varchar(200),
284 VNF_COMPONENT_TYPE varchar(45) not null,
285 VF_MODULE_ID varchar(100),
286 ACTION varchar(20) not null,
287 SERVICE_TYPE varchar(45) default null,
289 DESCRIPTION varchar(1200),
290 ORCHESTRATION_URI varchar(256) not null,
291 VNF_COMPONENT_PARAM_XSD varchar(2048),
292 RECIPE_TIMEOUT integer,
293 CREATION_TIMESTAMP datetime,
297 create table VNF_RECIPE (
298 id integer not null auto_increment,
299 VF_MODULE_ID varchar(100),
300 ACTION varchar(20) not null,
301 VERSION_STR varchar(20) not null,
302 VNF_TYPE varchar(200),
303 SERVICE_TYPE varchar(45) default null,
304 DESCRIPTION varchar(1200),
305 ORCHESTRATION_URI varchar(256) not null,
306 VNF_PARAM_XSD varchar(2048),
307 RECIPE_TIMEOUT integer,
308 CREATION_TIMESTAMP datetime,
312 create table VNF_RESOURCE (
313 id integer not null auto_increment,
314 VNF_TYPE varchar(200) not null,
315 ASDC_SERVICE_MODEL_VERSION varchar(20) not null,
316 SERVICE_MODEL_INVARIANT_UUID varchar(200),
317 MODEL_CUSTOMIZATION_NAME varchar(200),
318 ORCHESTRATION_MODE varchar(20) not null,
319 DESCRIPTION varchar(1200),
321 ENVIRONMENT_ID integer,
322 CREATION_TIMESTAMP datetime not null,
323 ASDC_UUID varchar(200),
324 AIC_VERSION_MIN varchar(20),
325 AIC_VERSION_MAX varchar(20),
326 MODEL_INVARIANT_UUID varchar(200),
327 MODEL_VERSION varchar(20) not null,
328 MODEL_NAME varchar(200),
329 MODEL_CUSTOMIZATION_UUID varchar(255),
333 alter table HEAT_ENVIRONMENT
334 add constraint UK_5wd9texshmrbg5ou83a5p70uk unique (NAME, VERSION, ASDC_RESOURCE_NAME, ASDC_UUID);
336 alter table HEAT_FILES
337 add constraint UK_d3ctpcskoryvei0o24ib3dhj2 unique (FILE_NAME, ASDC_RESOURCE_NAME, VERSION, ASDC_UUID);
339 alter table HEAT_TEMPLATE
340 add constraint UK_rpbyrb4spcnldds0evbyvucvi unique (TEMPLATE_NAME, VERSION, ASDC_RESOURCE_NAME, ASDC_UUID);
342 alter table HEAT_TEMPLATE_PARAMS
343 add constraint UK_pj3cwbmewecf0joqv2mvmbvw3 unique (HEAT_TEMPLATE_ID, PARAM_NAME);
346 add constraint UK_rra00f1rk6eyy7g00k9raxh2v unique (MODEL_TYPE, MODEL_VERSION_ID);
348 alter table MODEL_RECIPE
349 add constraint UK_b4g8j9wtqrkxfycyi3ursk7gb unique (MODEL_ID, ACTION);
351 alter table NETWORK_RECIPE
352 add constraint UK_rl4f296i0p8lyokxveaiwkayi unique (NETWORK_TYPE, ACTION, VERSION_STR);
354 alter table NETWORK_RESOURCE
355 add constraint UK_i4hpdnu3rmdsit3m6fw1ynguq unique (NETWORK_TYPE, VERSION_STR);
358 add constraint UK_iopodavyy29kj79umla8oarak unique (SERVICE_NAME_VERSION_ID, SERVICE_NAME);
360 alter table SERVICE_RECIPE
361 add constraint UK_7fav5dkux2v8g9d2i5ymudlgc unique (SERVICE_ID, ACTION);
363 alter table VF_MODULE
364 add constraint UK_o3bvdqspginaxlp4gxqohd44l unique (TYPE, ASDC_SERVICE_MODEL_VERSION);
366 alter table VNF_COMPONENTS_RECIPE
367 add constraint UK_4dpdwddaaclhc11wxsb7h59ma unique (VNF_TYPE, VNF_COMPONENT_TYPE, VF_MODULE_ID, ACTION, SERVICE_TYPE, VERSION);
369 alter table VNF_RECIPE
370 add constraint UK_f3tvqau498vrifq3cr8qnigkr unique (VF_MODULE_ID, ACTION, VERSION_STR);
372 alter table VNF_RESOURCE
373 add constraint UK_peslcm0k3yojkrj6cvdv1rttb unique (VNF_TYPE, ASDC_SERVICE_MODEL_VERSION, SERVICE_MODEL_INVARIANT_UUID);
375 alter table HEAT_TEMPLATE
376 add constraint FK_ek5sot1q07taorbdmkvnveu98
377 foreign key (CHILD_TEMPLATE_ID)
378 references HEAT_TEMPLATE (id);
380 alter table HEAT_TEMPLATE_PARAMS
381 add constraint FK_8sxvm215cw3tjfh3wni2y3myx
382 foreign key (HEAT_TEMPLATE_ID)
383 references HEAT_TEMPLATE (id);
385 alter table MODEL_RECIPE
386 add constraint FK_c23r0puyqug6n44jg39dutm1c
387 foreign key (MODEL_ID)
388 references MODEL (id);
390 alter table SERVICE_RECIPE
391 add constraint FK_kv13yx013qtqkn94d5gkwbu3s
392 foreign key (SERVICE_ID)
393 references SERVICE (id);