summaryrefslogtreecommitdiffstats
path: root/ms/generic-resource-api/src/main/resources/schema-derby.sql
diff options
context:
space:
mode:
authorDan Timoney <dtimoney@att.com>2020-08-05 17:43:36 -0400
committerDan Timoney <dtimoney@att.com>2020-08-07 13:56:30 -0400
commit59be7ffb51674ef1c58b83c80214ef417bc211f3 (patch)
tree0eb4a4f89b69c1ae9340b334a563d0ab224a3faf /ms/generic-resource-api/src/main/resources/schema-derby.sql
parentd998254cf8b8888b85cca8f59f9efeed5a55f053 (diff)
Fix docker-compose test issues
Fix issues running service-topology-operation via docker-compose Issue-ID: SDNC-1310 Change-Id: I5c30c7a07f6baf9f2560b4dc405999abeb0441cf Signed-off-by: Dan Timoney <dtimoney@att.com>
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)
+) ;