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