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
|
use catalogdb;
create table if not exists ar_recipe (
ID INT(11) not null auto_increment,
MODEL_NAME varchar(200) NOT NULL,
ACTION varchar(200) NOT NULL,
VERSION_STR varchar(200) NOT NULL,
SERVICE_TYPE varchar(200),
DESCRIPTION varchar(200),
ORCHESTRATION_URI varchar(200) NOT NULL,
AR_PARAM_XSD varchar(200),
RECIPE_TIMEOUT INT(11),
CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
primary key (ID),
unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
alter table network_recipe
ADD RESOURCE_CATEGORY varchar(200),
ADD RESOURCE_SUB_CATEGORY varchar(200);
alter table service ADD SERVICE_CATEGORY varchar(200);
alter table vnf_resource
ADD RESOURCE_CATEGORY varchar(200),
ADD RESOURCE_SUB_CATEGORY varchar(200);
alter table network_resource
ADD RESOURCE_CATEGORY varchar(200),
ADD RESOURCE_SUB_CATEGORY varchar(200);
|