Add TRANSACTIONS table to SDNCTL schema

Issue-ID: APPC-849
Change-Id: Idf403c77a04bb724bc87e9ef17bbbdce546fb09e
Signed-off-by: Skip Wonnell <skip@att.com>

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index 38daa60..f6ca702 100644 (file)
--- 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;