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