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
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -677,4 +677,28 @@
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;