summaryrefslogtreecommitdiffstats
path: root/ms/generic-resource-api/src/main/resources/schema-derby.sql
diff options
context:
space:
mode:
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.sql26
1 files changed, 26 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 2ff2d15..52afd71 100644
--- a/ms/generic-resource-api/src/main/resources/schema-derby.sql
+++ b/ms/generic-resource-api/src/main/resources/schema-derby.sql
@@ -2670,3 +2670,29 @@ CREATE TABLE VNF_RELATED_NETWORK_ROLE (
PRIMARY KEY (vnf_customization_uuid,network_role,related_network_role)
) ;
+CREATE TABLE CONFIG_GRA_SERVICES (
+ svcInstanceId varchar(255) not null,
+ serviceStatusAction varchar(255),
+ serviceStatusFinalIndicator varchar(255),
+ serviceStatusRequestStatus varchar(255),
+ serviceStatusResponseCode varchar(255),
+ serviceStatusResponseMessage varchar(255),
+ serviceStatusResponseTimestamp varchar(255),
+ serviceStatusRpcAction varchar(255),
+ serviceStatusRpcName varchar(255),
+ svcData clob, primary key (svcInstanceId)
+) ;
+
+CREATE TABLE OPERATIONAL_GRA_SERVICES (
+ svcInstanceId varchar(255) not null,
+ serviceStatusAction varchar(255),
+ serviceStatusFinalIndicator varchar(255),
+ serviceStatusRequestStatus varchar(255),
+ serviceStatusResponseCode varchar(255),
+ serviceStatusResponseMessage varchar(255),
+ serviceStatusResponseTimestamp varchar(255),
+ serviceStatusRpcAction varchar(255),
+ serviceStatusRpcName varchar(255),
+ svcData clob,
+ primary key (svcInstanceId)
+) ;