Fixed Deadlock issue in Sync API

Issue-ID: APPC-1638
Change-Id: I4f48f570180662870fb22bba0598dd98db961d88
Signed-off-by: Lathish <lathishbabu.ganesan@est.tech>

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index dc7c08b..41e8ef8 100644 (file)
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -1258,7 +1258,8 @@ CREATE TABLE `UPLOAD_CONFIG` (
   `PENDING_DELETE` varchar(1) DEFAULT NULL,
   `CONTENT` longtext,
   PRIMARY KEY (`UPLOAD_CONFIG_ID`),
-  UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
+  UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`),
+  KEY `VNF_ID` (`VNF_ID`)
 ) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;