diff options
| -rw-r--r-- | installation/appc/src/main/resources/sdnctl.dump | 24 |
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; |