Added Foreign key checks condition

Add table for multiple ansible servers support

Adding Admin Artifact table in APPC DB to support multiple ansible
servers

Change-Id: I6324ffbd3091ea48ce5a28ad99fa51c82d64f45a
Issue-ID: APPC-1494
Signed-off-by: Manoj Marneni <mm833r@att.com>

1 files changed, 143 insertions, 57 deletions

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index 094095b..1a36a07 100644
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -1,31 +1,33 @@
---  ============LICENSE_START==========================================
---  ONAP : APPC
---  ===================================================================
---  Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
---  ===================================================================
---
---  Unless otherwise specified, all software contained herein is licensed
---  under the Apache License, Version 2.0 (the License);
---  you may not use this software except in compliance with the License.
---  You may obtain a copy of the License at
---
---     http://www.apache.org/licenses/LICENSE-2.0
---
---  Unless required by applicable law or agreed to in writing, software
---  distributed under the License is distributed on an "AS IS" BASIS,
---  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
---  See the License for the specific language governing permissions and
---  limitations under the License.
---
---  ECOMP is a trademark and service mark of AT&T Intellectual Property.
+-- ============LICENSE_START==========================================  
+-- ONAP : APPC   
+-- ===================================================================   
+-- Copyright (C) 2018-2019 AT&T Intellectual Property. All rights reserved.   
+-- ===================================================================   
+-- 
+-- Unless otherwise specified, all software contained herein is licensed   
+-- under the Apache License, Version 2.0 (the License);   
+-- you may not use this software except in compliance with the License.  
+-- You may obtain a copy of the License at  
+-- 
+-- http://www.apache.org/licenses/LICENSE-2.0  
+-- 
+-- Unless required by applicable law or agreed to in writing, software  
+-- distributed under the License is distributed on an "AS IS" BASIS,  
+-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+-- See the License for the specific language governing permissions and  
+-- limitations under the License.  
+-- 
+-- ECOMP is a trademark and service mark of AT&T Intellectual Property.  
 --  ============LICENSE_END============================================
 
+--
+-- Current Database: `sdnctl`
+--
+
 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `sdnctl` /*!40100 DEFAULT CHARACTER SET latin1 */;
 
 USE `sdnctl`;
 
-SET FOREIGN_KEY_CHECKS = 0;
-
 --
 -- Table structure for table `ACTION_LEVEL_REFERENCE`
 --
@@ -42,6 +44,21 @@ CREATE TABLE `ACTION_LEVEL_REFERENCE` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
+-- Table structure for table `APPC_APP_PARAM`
+--
+
+DROP TABLE IF EXISTS `APPC_APP_PARAM`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `APPC_APP_PARAM` (
+  `APPC_APP_PARAM_ID` int(11) NOT NULL AUTO_INCREMENT,
+  `PARAM_KEY` varchar(50) NOT NULL,
+  `PARAM_VALUE` varchar(50) NOT NULL,
+  UNIQUE KEY `APPC_APP_PARAM_ID` (`APPC_APP_PARAM_ID`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
 -- Table structure for table `APPC_HEALTH`
 --
 
@@ -83,7 +100,7 @@ CREATE TABLE `ASDC_ARTIFACTS` (
   `ARTIFACT_CONTENT` longtext,
   PRIMARY KEY (`ASDC_ARTIFACTS_ID`),
   UNIQUE KEY `ASDC_ARTIFACTS_ID` (`ASDC_ARTIFACTS_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=1219 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5093 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -103,7 +120,7 @@ CREATE TABLE `ASDC_REFERENCE` (
   `ARTIFACT_NAME` varchar(255) DEFAULT NULL,
   PRIMARY KEY (`ASDC_REFERENCE_ID`),
   UNIQUE KEY `ASDC_REFERENCE_ID` (`ASDC_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=352 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -130,7 +147,7 @@ CREATE TABLE `CONFIGFILES` (
   `VNF_NAME` varchar(50) DEFAULT NULL,
   PRIMARY KEY (`CONFIG_FILE_ID`),
   UNIQUE KEY `CONFIG_FILE_ID` (`CONFIG_FILE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5751 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -148,7 +165,7 @@ CREATE TABLE `CONFIGURE_ACTION_DG` (
   `DOWNLOAD_CONFIG_DG` varchar(50) DEFAULT NULL,
   PRIMARY KEY (`CONFIGURE_ACTION_DG_ID`),
   UNIQUE KEY ` CONFIGURE_ACTION_DG_ID` (`CONFIGURE_ACTION_DG_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -189,7 +206,7 @@ CREATE TABLE `CONFIG_TRANSACTION_LOG` (
   `MESSAGE` longtext,
   PRIMARY KEY (`CONFIG_TRANSACTION_LOG_ID`),
   UNIQUE KEY ` CONFIG_TRANSACTION_LOG_ID` (`CONFIG_TRANSACTION_LOG_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=6470 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=40247 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -209,10 +226,10 @@ CREATE TABLE `DEVICE_AUTHENTICATION` (
   `PORT_NUMBER` int(11) DEFAULT NULL,
   `URL` varchar(1024) DEFAULT NULL,
   PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
-  UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`),
+  UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`,`URL`),
   KEY `PROTOCOL` (`PROTOCOL`),
   KEY `ACTION` (`ACTION`)
-) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -274,7 +291,7 @@ CREATE TABLE `DEVICE_INTERFACE_PROTOCOL` (
   `DG_RPC` varchar(50) DEFAULT NULL,
   PRIMARY KEY (`DEVICE_INTERFACE_PROTOCOL_ID`),
   UNIQUE KEY `DEVICE_INTERFACE_PROTOCOL_ID` (`DEVICE_INTERFACE_PROTOCOL_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -885,22 +902,22 @@ BEGIN
     
     delete from OPS_HCRESPCACHE where HDENDTIME is null AND time_to_sec(timediff(nowtime, HDSTARTTIME))>maxtimeintbl;
     
-	IF (reftransid is null) then
+    IF (reftransid is null) then
         select CACHEDURATION, EXECTIME into acacheduration, hdexectime from OPS_HCTYPES where HCCODE=ahdcode;
         select count(*) into ccount from OPS_HCRESPCACHE where HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0;
-		if (ccount > 0) then
+        if (ccount > 0) then
             select HDSTARTTIME, HDENDTIME, CACHEEXPIRETIME into ahdstarttime, ahdendtime, acacheexpiretime from OPS_HCRESPCACHE where
-				HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0 order by HDENDTIME desc limit 1 ;
+                HCCODE=ahdcode and hostip=ahostip AND HDENDTIME is not null AND HCRESPONSEID>0 order by HDENDTIME desc limit 1 ;
             select time_to_sec(timediff(ahdendtime, ahdstarttime)) into hdexectime;
-		end if;
+        end if;
 
         if (acacheduration > 0) then
-			set hdexpectedendtime = nowtime + INTERVAL hdexectime second;
-			insert into OPS_HCRESPCACHE(HCRESPONSEID,SDNOTRANSID,HOSTIP,HCRESPONSESTATUS,HCRESPONSE,CREATEDON,SDNOINSTANCE,SDNOINSTANCESERVER,DMAAPSENT,
-				   NODETYPE,HCCODE,USERID,CLIENTNAME,HDSTARTTIME,HDENDTIME,CACHEEXPIRETIME,HDEXPECTEDENDTIME)
-				VALUES(NEW.HCRESPONSEID,NEW.SDNOTRANSID,NEW.HOSTIP,null,null,nowtime,NEW.SDNOINSTANCE,NEW.SDNOINSTANCESERVER,NEW.DMAAPSENT,
-				   NEW.NODETYPE,NEW.HCCODE,NEW.USERID,NEW.CLIENTNAME,NEW.HDSTARTTIME,null,null,hdexpectedendtime);
-		end if;
+            set hdexpectedendtime = nowtime + INTERVAL hdexectime second;
+            insert into OPS_HCRESPCACHE(HCRESPONSEID,SDNOTRANSID,HOSTIP,HCRESPONSESTATUS,HCRESPONSE,CREATEDON,SDNOINSTANCE,SDNOINSTANCESERVER,DMAAPSENT,
+                   NODETYPE,HCCODE,USERID,CLIENTNAME,HDSTARTTIME,HDENDTIME,CACHEEXPIRETIME,HDEXPECTEDENDTIME)
+                VALUES(NEW.HCRESPONSEID,NEW.SDNOTRANSID,NEW.HOSTIP,null,null,nowtime,NEW.SDNOINSTANCE,NEW.SDNOINSTANCESERVER,NEW.DMAAPSENT,
+                   NEW.NODETYPE,NEW.HCCODE,NEW.USERID,NEW.CLIENTNAME,NEW.HDSTARTTIME,null,null,hdexpectedendtime);
+        end if;
    
     END IF;    
 END */;;
@@ -920,9 +937,9 @@ DELIMITER ;
 DELIMITER ;;
 /*!50003 CREATE*/ /*!50017 DEFINER=`sdnctl`@`%`*/ /*!50003 TRIGGER `sdnctl`.`OPS_HEALTHCHECKRESPONSE_BEFORE_UPDATE` BEFORE UPDATE ON `OPS_HEALTHCHECKRESPONSE` FOR EACH ROW
 BEGIN
-	Declare aduration INT;
+    Declare aduration INT;
     declare reftransid varchar(128);
-	DECLARE cachetime datetime;
+    DECLARE cachetime datetime;
     declare ahostip varchar(45);
     declare ahdcode varchar(45);
     declare ahdendtime datetime;
@@ -933,18 +950,18 @@ BEGIN
     SET reftransid:=trim(NEW.REFHCTRANSID);
     
     if (NEW.DMAAPSENT in ('U','Y')) then
-		update OPS_HCRESPCACHE 
-				set DMAAPSENT=NEW.DMAAPSENT where OLD.SDNOTRANSID=NEW.SDNOTRANSID and OLD.CREATEDON=NEW.CREATEDON;
+        update OPS_HCRESPCACHE 
+                set DMAAPSENT=NEW.DMAAPSENT where OLD.SDNOTRANSID=NEW.SDNOTRANSID and OLD.CREATEDON=NEW.CREATEDON;
     ELSEIF (reftransid is null and OLD.HCRESPONSESTATUS is null) then
-		select cacheduration into aduration from OPS_HCTYPES where HCCODE=ahdcode; 
-		if (aduration > 0) then
-			select ahdendtime + INTERVAL aduration MINUTE into cachetime from OPS_HCTYPES where HCCODE=ahdcode;     
-			update OPS_HCRESPCACHE 
-				set HCRESPONSESTATUS=NEW.HCRESPONSESTATUS,HCRESPONSE=NEW.HCRESPONSE,HDENDTIME=NEW.HDENDTIME,CACHEEXPIRETIME=cachetime,HDEXPECTEDENDTIME=null
+        select cacheduration into aduration from OPS_HCTYPES where HCCODE=ahdcode; 
+        if (aduration > 0) then
+            select ahdendtime + INTERVAL aduration MINUTE into cachetime from OPS_HCTYPES where HCCODE=ahdcode;     
+            update OPS_HCRESPCACHE 
+                set HCRESPONSESTATUS=NEW.HCRESPONSESTATUS,HCRESPONSE=NEW.HCRESPONSE,HDENDTIME=NEW.HDENDTIME,CACHEEXPIRETIME=cachetime,HDEXPECTEDENDTIME=null
                 where SDNOTRANSID=NEW.SDNOTRANSID and CREATEDON=NEW.CREATEDON;
-			insert into OPS_HCRESPCOMPACT (HCRESPONSEID, HCTRANSID, HOSTIP, HCRESPONSESTATUS, SDNOINSTANCE, SDNOINSTANCESERVER, NODETYPE, HCCODE, USERID, CLIENTNAME, HDSTARTTIME, HDENDTIME)
-				values(NEW.HCRESPONSEID, NEW.HCTRANSID, NEW.HOSTIP, NEW.HCRESPONSESTATUS, NEW.SDNOINSTANCE, NEW.SDNOINSTANCESERVER, NEW.NODETYPE, NEW.HCCODE, NEW.USERID, NEW.CLIENTNAME, NEW.HDSTARTTIME, NEW.HDENDTIME);
-		end if;
+            insert into OPS_HCRESPCOMPACT (HCRESPONSEID, HCTRANSID, HOSTIP, HCRESPONSESTATUS, SDNOINSTANCE, SDNOINSTANCESERVER, NODETYPE, HCCODE, USERID, CLIENTNAME, HDSTARTTIME, HDENDTIME)
+                values(NEW.HCRESPONSEID, NEW.HCTRANSID, NEW.HOSTIP, NEW.HCRESPONSESTATUS, NEW.SDNOINSTANCE, NEW.SDNOINSTANCESERVER, NEW.NODETYPE, NEW.HCCODE, NEW.USERID, NEW.CLIENTNAME, NEW.HDSTARTTIME, NEW.HDENDTIME);
+        end if;
     END IF;    
 END */;;
 DELIMITER ;
@@ -1102,7 +1119,7 @@ CREATE TABLE `PREPARE_FILE_RELATIONSHIP` (
   KEY `ie2_prepare_file_relationship` (`ASDC_ARTIFACTS_ID`),
   CONSTRAINT `prepare_file_relationship_ibfk_2` FOREIGN KEY (`ASDC_ARTIFACTS_ID`) REFERENCES `ASDC_ARTIFACTS` (`ASDC_ARTIFACTS_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
   CONSTRAINT `prepare_file_replationship_ibfk_1` FOREIGN KEY (`CONFIG_FILE_ID`) REFERENCES `CONFIGFILES` (`CONFIG_FILE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
-) ENGINE=InnoDB AUTO_INCREMENT=338 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=8607 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1144,7 +1161,7 @@ CREATE TABLE `PROTOCOL_REFERENCE` (
   `ACTION_LEVEL` varchar(45) DEFAULT NULL,
   PRIMARY KEY (`PROTOCOL_REFERENCE_ID`),
   UNIQUE KEY ` PROTOCOL_REFERENCE_ID` (`PROTOCOL_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1165,7 +1182,7 @@ CREATE TABLE `REQUEST_ARTIFACTS` (
   `UPDATED_DATE` datetime DEFAULT NULL,
   PRIMARY KEY (`REQUEST_ARTIFACTS_ID`),
   UNIQUE KEY `REQUEST_ARTIFACTS_ID` (`REQUEST_ARTIFACTS_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=1962 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=10273 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1242,7 +1259,7 @@ CREATE TABLE `UPLOAD_CONFIG` (
   `CONTENT` longtext,
   PRIMARY KEY (`UPLOAD_CONFIG_ID`),
   UNIQUE KEY `UPLOAD_CONFIG_ID` (`UPLOAD_CONFIG_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1656 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1286,7 +1303,7 @@ CREATE TABLE `VNFC_REFERENCE` (
   `TEMPLATE_ID` varchar(100) DEFAULT NULL,
   PRIMARY KEY (`VNFC_REFERENCE_ID`),
   UNIQUE KEY ` VNFC_REFERENCE_ID` (`VNFC_REFERENCE_ID`)
-) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=688 DEFAULT CHARSET=latin1;
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 --
@@ -1344,4 +1361,73 @@ CREATE TABLE `VNF_STATE_MANAGEMENT` (
 /*!40101 SET character_set_client = @saved_cs_client */;
 
 SET FOREIGN_KEY_CHECKS = 1;
+--
+-- Current Database: `sdnctl`
+--
+
+USE `sdnctl`;
+
+--
+-- Final view structure for view `DEVICE_CONFIGURATION`
+--
+
+/*!50001 DROP VIEW IF EXISTS `DEVICE_CONFIGURATION`*/;
+/*!50001 SET @saved_cs_client          = @@character_set_client */;
+/*!50001 SET @saved_cs_results         = @@character_set_results */;
+/*!50001 SET @saved_col_connection     = @@collation_connection */;
+/*!50001 SET character_set_client      = utf8 */;
+/*!50001 SET character_set_results     = utf8 */;
+/*!50001 SET collation_connection      = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `DEVICE_CONFIGURATION` AS select 1 AS `UPLOAD_CONFIG_ID`,1 AS `REQUEST_ID`,1 AS `ORIGINATOR_ID`,1 AS `SERVICE_DESCRIPTION`,1 AS `ACTION`,1 AS `UPLOAD_DATE`,1 AS `VNF_ID`,1 AS `VNF_NAME`,1 AS `VM_NAME`,1 AS `VNF_TYPE`,1 AS `VNFC_TYPE`,1 AS `HOST_IP_ADDRESS`,1 AS `CONFIG_INDICATOR`,1 AS `PENDING_DELETE`,1 AS `CONTENT` */;
+/*!50001 SET character_set_client      = @saved_cs_client */;
+/*!50001 SET character_set_results     = @saved_cs_results */;
+/*!50001 SET collation_connection      = @saved_col_connection */;
+
+--
+-- Final view structure for view `OPS_HCRESPCACHEVIEW`
+--
+
+/*!50001 DROP VIEW IF EXISTS `OPS_HCRESPCACHEVIEW`*/;
+/*!50001 SET @saved_cs_client          = @@character_set_client */;
+/*!50001 SET @saved_cs_results         = @@character_set_results */;
+/*!50001 SET @saved_col_connection     = @@collation_connection */;
+/*!50001 SET character_set_client      = utf8 */;
+/*!50001 SET character_set_results     = utf8 */;
+/*!50001 SET collation_connection      = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `OPS_HCRESPCACHEVIEW` AS select 1 AS `ACTIVE`,1 AS `HCRESPONSEID`,1 AS `SDNOTRANSID`,1 AS `HOSTIP`,1 AS `HCRESPONSESTATUS`,1 AS `HCRESPONSE`,1 AS `CREATEDON`,1 AS `SDNOINSTANCE`,1 AS `SDNOINSTANCESERVER`,1 AS `DMAAPSENT`,1 AS `NODETYPE`,1 AS `HCCODE`,1 AS `USERID`,1 AS `CLIENTNAME`,1 AS `HDSTARTTIME`,1 AS `HDENDTIME`,1 AS `CACHEEXPIRETIME`,1 AS `HDEXPECTEDENDTIME` */;
+/*!50001 SET character_set_client      = @saved_cs_client */;
+/*!50001 SET character_set_results     = @saved_cs_results */;
+/*!50001 SET collation_connection      = @saved_col_connection */;
+
+--
+-- Final view structure for view `OPS_HCVIEW`
+--
+
+/*!50001 DROP VIEW IF EXISTS `OPS_HCVIEW`*/;
+/*!50001 SET @saved_cs_client          = @@character_set_client */;
+/*!50001 SET @saved_cs_results         = @@character_set_results */;
+/*!50001 SET @saved_col_connection     = @@collation_connection */;
+/*!50001 SET character_set_client      = utf8 */;
+/*!50001 SET character_set_results     = utf8 */;
+/*!50001 SET collation_connection      = utf8_general_ci */;
+/*!50001 CREATE ALGORITHM=UNDEFINED */
+/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
+/*!50001 VIEW `OPS_HCVIEW` AS select 1 AS `HCCODE`,1 AS `CHCCODE`,1 AS `HCNODETYPE2`,1 AS `STACKLEVEL`,1 AS `SBINTERFACE`,1 AS `COMMAND`,1 AS `COMMANDDESC`,1 AS `EXITONFAIL`,1 AS `PATTERNMATCH`,1 AS `TIMEOUT`,1 AS `PROMPTCHECK`,1 AS `SENDCMDRESP`,1 AS `MANUALEFFORT`,1 AS `FLIPRXRSLT`,1 AS `EXECPRIORITY`,1 AS `VERSION`,1 AS `GPRIORITY`,1 AS `HCNODETYPE` */;
+/*!50001 SET character_set_client      = @saved_cs_client */;
+/*!50001 SET character_set_results     = @saved_cs_results */;
+/*!50001 SET collation_connection      = @saved_col_connection */;
+/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
+/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
+/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
+