summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSkip Wonnell <skip@att.com>2018-04-11 14:01:26 -0500
committerSkip Wonnell <skip@att.com>2018-04-11 14:06:52 -0500
commit733f8c5a06f84b625c40e25f1caea912c9c2f7f7 (patch)
tree1278cac30897782dc0a65d9a218b0013cf37a3d2
parentd64f8407897ac8bca1bc69935edba4222210b932 (diff)
Add TRANSACTIONS table to SDNCTL schema
Issue-ID: APPC-849 Change-Id: Idf403c77a04bb724bc87e9ef17bbbdce546fb09e Signed-off-by: Skip Wonnell <skip@att.com>
-rw-r--r--installation/appc/src/main/resources/sdnctl.dump24
1 files changed, 24 insertions, 0 deletions
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;