diff options
author | Cheung, Pat (kc1472) <kc1472@att.com> | 2020-12-04 18:24:31 +0000 |
---|---|---|
committer | Cheung, Pat (kc1472) <kc1472@att.com> | 2020-12-04 18:24:31 +0000 |
commit | fe74a95f4432e35aa65b7b7928ba49e2158c2c7d (patch) | |
tree | 4c5f1a8d57088c370b3bdfb1ca6e32674be3ab5f /ms/generic-resource-api/src/main/resources/schema-derby.sql | |
parent | 721d88fe8742498ff82139b6163382e3ff814c0e (diff) |
Add vf-module,port-mirror, allotted-resource rpc and CRUD
Adding methods for vf-mdoule, port-mirror, policy-update-notify, and vnf-get-resource rpc and CRUD
Issue-ID: SDNC-1424
Signed-off-by: Cheung, Pat (kc1472) <kc1472@att.com>
Change-Id: I0c62c7c25bc0753e8b820986b56bee9471d3a0b7
Diffstat (limited to 'ms/generic-resource-api/src/main/resources/schema-derby.sql')
-rw-r--r-- | ms/generic-resource-api/src/main/resources/schema-derby.sql | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/ms/generic-resource-api/src/main/resources/schema-derby.sql b/ms/generic-resource-api/src/main/resources/schema-derby.sql index 7b2d78e..9fbf95f 100644 --- a/ms/generic-resource-api/src/main/resources/schema-derby.sql +++ b/ms/generic-resource-api/src/main/resources/schema-derby.sql @@ -2699,3 +2699,57 @@ CREATE TABLE OPERATIONAL_GRA_SERVICES ( svcData clob, primary key (svcInstanceId) ) ; + +CREATE TABLE CONFIG_GRA_PORT_MIRROR_CONFIGURATIONS ( + configurationId varchar(255) not null, + portMirrorConfigurationStatusAction varchar(255), + portMirrorConfigurationStatusFinalIndicator varchar(255), + portMirrorConfigurationStatusRequestStatus varchar(255), + portMirrorConfigurationStatusResponseCode varchar(255), + portMirrorConfigurationStatusResponseMessage varchar(255), + portMirrorConfigurationStatusResponseTimestamp varchar(255), + portMirrorConfigurationStatusRpcAction varchar(255), + portMirrorConfigurationStatusRpcName varchar(255), + pmcData clob, primary key (configurationId) +) ; + +CREATE TABLE OPERATIONAL_GRA_PORT_MIRROR_CONFIGURATIONS ( + configurationId varchar(255) not null, + portMirrorConfigurationStatusAction varchar(255), + portMirrorConfigurationStatusFinalIndicator varchar(255), + portMirrorConfigurationStatusRequestStatus varchar(255), + portMirrorConfigurationStatusResponseCode varchar(255), + portMirrorConfigurationStatusResponseMessage varchar(255), + portMirrorConfigurationStatusResponseTimestamp varchar(255), + portMirrorConfigurationStatusRpcAction varchar(255), + portMirrorConfigurationStatusRpcName varchar(255), + pmcData clob, + primary key (configurationId) +) ; + +CREATE TABLE CONFIG_GRA_CONTRAIL_ROUTE_ALLOTTED_RESOURCES ( + allottedResourceId varchar(255) not null, + allottedResourceStatusAction varchar(255), + allottedResourceStatusFinalIndicator varchar(255), + allottedResourceStatusRequestStatus varchar(255), + allottedResourceStatusResponseCode varchar(255), + allottedResourceStatusResponseMessage varchar(255), + allottedResourceStatusResponseTimestamp varchar(255), + allottedResourceStatusRpcAction varchar(255), + allottedResourceStatusRpcName varchar(255), + arData clob, primary key (allottedResourceId) +) ; + +CREATE TABLE OPERATIONAL_GRA_CONTRAIL_ROUTE_ALLOTTED_RESOURCES ( + allottedResourceId varchar(255) not null, + allottedResourceStatusAction varchar(255), + allottedResourceStatusFinalIndicator varchar(255), + allottedResourceStatusRequestStatus varchar(255), + allottedResourceStatusResponseCode varchar(255), + allottedResourceStatusResponseMessage varchar(255), + allottedResourceStatusResponseTimestamp varchar(255), + allottedResourceStatusRpcAction varchar(255), + allottedResourceStatusRpcName varchar(255), + arData clob, + primary key (allottedResourceId) +) ; |