summaryrefslogtreecommitdiffstats
path: root/ms/generic-resource-api/src/main/resources
diff options
context:
space:
mode:
authorCheung, Pat (kc1472) <kc1472@att.com>2020-12-04 18:24:31 +0000
committerCheung, Pat (kc1472) <kc1472@att.com>2020-12-04 18:24:31 +0000
commitfe74a95f4432e35aa65b7b7928ba49e2158c2c7d (patch)
tree4c5f1a8d57088c370b3bdfb1ca6e32674be3ab5f /ms/generic-resource-api/src/main/resources
parent721d88fe8742498ff82139b6163382e3ff814c0e (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')
-rw-r--r--ms/generic-resource-api/src/main/resources/schema-derby.sql54
-rw-r--r--ms/generic-resource-api/src/main/resources/schema-mysql.sql54
2 files changed, 108 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)
+) ;
diff --git a/ms/generic-resource-api/src/main/resources/schema-mysql.sql b/ms/generic-resource-api/src/main/resources/schema-mysql.sql
index 90e4ca7..ddd3217 100644
--- a/ms/generic-resource-api/src/main/resources/schema-mysql.sql
+++ b/ms/generic-resource-api/src/main/resources/schema-mysql.sql
@@ -2791,3 +2791,57 @@ CREATE TABLE OPERATIONAL_GRA_SERVICES (
svcData longtext,
primary key (svcInstanceId)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
+
+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 longtext, primary key (configurationId)
+ ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
+
+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 longtext,
+ primary key (configurationId)
+ ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
+
+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 longtext, primary key (allottedResourceId)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
+
+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 longtext,
+ primary key (allottedResourceId)
+ ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;