From 733f8c5a06f84b625c40e25f1caea912c9c2f7f7 Mon Sep 17 00:00:00 2001 From: Skip Wonnell Date: Wed, 11 Apr 2018 14:01:26 -0500 Subject: [PATCH] Add TRANSACTIONS table to SDNCTL schema Issue-ID: APPC-849 Change-Id: Idf403c77a04bb724bc87e9ef17bbbdce546fb09e Signed-off-by: Skip Wonnell --- installation/appc/src/main/resources/sdnctl.dump | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump index 38daa60..f6ca702 100644 --- a/installation/appc/src/main/resources/sdnctl.dump +++ b/installation/appc/src/main/resources/sdnctl.dump @@ -677,4 +677,28 @@ CREATE TABLE `VNF_STATE_MANAGEMENT` ( PRIMARY KEY (`VNF_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; +DROP TABLE IF EXISTS `TRANSACTIONS`; +CREATE TABLE `TRANSACTIONS` ( + `TRANSACTION_ID` varchar(75) NOT NULL, + `ORIGIN_TIMESTAMP` datetime(3) NOT NULL, + `REQUEST_ID` varchar(256) NOT NULL, + `SUBREQUEST_ID` varchar(256) DEFAULT NULL, + `ORIGINATOR_ID` varchar(256) DEFAULT NULL, + `START_TIME` datetime(3) NOT NULL, + `END_TIME` datetime(3) DEFAULT NULL, + `TARGET_ID` varchar(256) , + `TARGET_TYPE` varchar(256) DEFAULT NULL, + `OPERATION` varchar(256) NOT NULL, + `RESULT_CODE` int(11) DEFAULT NULL, + `DESCRIPTION` text, + `STATE` varchar(50) NOT NULL, + `SERVICE_INSTANCE_ID` varchar(256) DEFAULT NULL, + `VNFC_NAME` varchar(256) DEFAULT NULL, + `VSERVER_ID` varchar(256) DEFAULT NULL, + `VF_MODULE_ID` varchar(256) DEFAULT NULL, + `MODE` varchar(50) NOT NULL, + PRIMARY KEY (`TRANSACTION_ID`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN; -- 2.16.6