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