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)
+) ;