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