2 create table if not exists ar_recipe (
3 ID INT(11) not null auto_increment,
4 MODEL_NAME varchar(200) NOT NULL,
5 ACTION varchar(200) NOT NULL,
6 VERSION_STR varchar(200) NOT NULL,
7 SERVICE_TYPE varchar(200),
8 DESCRIPTION varchar(200),
9 ORCHESTRATION_URI varchar(200) NOT NULL,
10 AR_PARAM_XSD varchar(200),
11 RECIPE_TIMEOUT INT(11),
12 CREATION_TIMESTAMP DATETIME NOT NULL default current_timestamp,
14 unique key `uk_ar_recipe` (`model_name`,`action`,`version_str`)
15 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17 alter table network_recipe
18 ADD RESOURCE_CATEGORY varchar(200),
19 ADD RESOURCE_SUB_CATEGORY varchar(200);
21 alter table service ADD SERVICE_CATEGORY varchar(200);
23 alter table vnf_resource
24 ADD RESOURCE_CATEGORY varchar(200),
25 ADD RESOURCE_SUB_CATEGORY varchar(200);
27 alter table network_resource
28 ADD RESOURCE_CATEGORY varchar(200),
29 ADD RESOURCE_SUB_CATEGORY varchar(200);