271 lines
27 KiB
SQL
271 lines
27 KiB
SQL
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19 Distrib 10.6.21-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost Database: OBJ_386
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.6.21-MariaDB-0ubuntu0.22.04.2
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!40101 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Current Database: `OBJ_386`
|
|
--
|
|
|
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `OBJ_386` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;
|
|
|
|
USE `OBJ_386`;
|
|
|
|
--
|
|
-- Table structure for table `paramConf`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `paramConf`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `paramConf` (
|
|
`name_1` varchar(64) NOT NULL,
|
|
`name_2` varchar(64) NOT NULL,
|
|
`desc_1` varchar(255) NOT NULL DEFAULT '',
|
|
`desc_2` varchar(255) NOT NULL DEFAULT '',
|
|
`maxAccess` tinyint(1) NOT NULL DEFAULT 0,
|
|
`operType` tinyint(1) NOT NULL DEFAULT 0,
|
|
`valueType` smallint(6) NOT NULL DEFAULT 0,
|
|
`initValue` varchar(255) NOT NULL DEFAULT '',
|
|
`minValue` varchar(255) NOT NULL DEFAULT '',
|
|
`maxValue` varchar(255) NOT NULL DEFAULT '',
|
|
`setTemplate_1` text DEFAULT NULL,
|
|
`setTemplate_2` text DEFAULT NULL,
|
|
`note_1` text DEFAULT NULL,
|
|
`note_2` text DEFAULT NULL,
|
|
`level_1` int(5) NOT NULL DEFAULT 0,
|
|
`level_2` int(5) NOT NULL DEFAULT 0,
|
|
`level_3` int(5) NOT NULL DEFAULT 0,
|
|
`level_4` int(5) NOT NULL DEFAULT 0,
|
|
`level_5` int(5) NOT NULL DEFAULT 0,
|
|
`level_6` int(5) NOT NULL DEFAULT 0,
|
|
`level_7` int(5) NOT NULL DEFAULT 0,
|
|
`level_8` int(5) NOT NULL DEFAULT 0,
|
|
`level_9` int(5) NOT NULL DEFAULT 0,
|
|
`level_10` int(5) NOT NULL DEFAULT 0,
|
|
KEY `level_1` (`level_1`),
|
|
KEY `level_2` (`level_2`),
|
|
KEY `level_3` (`level_3`),
|
|
KEY `level_4` (`level_4`),
|
|
KEY `level_5` (`level_5`),
|
|
KEY `level_6` (`level_6`),
|
|
KEY `level_7` (`level_7`),
|
|
KEY `level_8` (`level_8`),
|
|
KEY `level_9` (`level_9`),
|
|
KEY `level_10` (`level_10`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `paramConf`
|
|
--
|
|
|
|
LOCK TABLES `paramConf` WRITE;
|
|
/*!40000 ALTER TABLE `paramConf` DISABLE KEYS */;
|
|
INSERT INTO `paramConf` VALUES ('parameter','parameter','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mHCNode','mHCNode','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,2,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mHCNodeTable','mHCNodeTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mHCNodeEntry','mHCNodeEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','mnIndex','mnIndex',NULL,NULL,2,2,1,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnRowStatus','mnRowStatus','Key Parameter;','Key Parameter;',19,1,3,'','','','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6',NULL,NULL,2,2,1,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnBlock','mnBlock','Key Parameter;Name:Admin State;','Key Parameter;Name:Admin State;',19,1,3,'','','','unblock=0;block=1','unblock=0;block=1','Control the operation of the managed MHC node.<br>- Unblock = Enable blocked MHC node.<br>- Block = Disable MHC node manually.','Control the operation of the managed MHC node.<br>- Unblock = Enable blocked MHC node.<br>- Block = Disable MHC node manually.',2,2,1,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnIP1','mnIP1','Key Parameter;Name:IP 1;','Key Parameter;Name:IP 1;',19,2,5,'','','',NULL,NULL,'IP address of the MHC installed on platform 1. It is available only for the dual-platform system.','IP address of the MHC installed on platform 1. It is available only for the dual-platform system.',2,2,1,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnIP0','mnIP0','Key Parameter;Name:IP 0;','Key Parameter;Name:IP 0;',19,2,5,'','','',NULL,NULL,'IP address of the MHC installed on platform 0.','IP address of the MHC installed on platform 0.',2,2,1,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnName','mnName','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','127',NULL,NULL,'MHC node name for identification purpose only.','MHC node name for identification purpose only.',2,2,1,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnIndex','mnIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','0','15',NULL,NULL,'MHC node index number ranges from 0 to 15.','MHC node index number ranges from 0 to 15.',2,2,1,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('system','system','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,1,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('replicateRate','replicateRate','Name:Replication Rate;','Name:Replication Rate;',19,2,3,'','0','255',NULL,NULL,'The limited number of replicating subscribers per 50ms.<br>- Range = 1 - 255','The limited number of replicating subscribers per 50ms.<br>- Range = 1 - 255',2,1,12,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('sysCommand','sysCommand','','',19,1,3,'','','','saveUserData=1','saveUserData=1',NULL,NULL,2,1,11,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('hLRChecksumField','hLRChecksumField','','',19,2,9,'','13','13','\n [unit]IMSI[u]00.0-00.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Used flag[u]00.1-00.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MSISDN[u]00.2-00.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Fax number[u]00.3-00.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Data number[u]00.4-00.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Network access mode[u]00.5-00.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Mobile station category[u]00.6-00.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Subscriber status[u]00.7-00.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]ODB general data[u]01.0-01.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]ODB specific data[u]01.1-01.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Bearer service data[u]01.2-01.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Tele service data[u]01.3-01.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Country specification roam type[u]01.4-01.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GSM bearer capability[u]01.5-01.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Regional subscription zone code index[u]01.6-01.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CLIP state[u]01.7-01.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CLIR state[u]02.0-02.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]COLP state[u]02.1-02.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]COLR state[u]02.2-02.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Subscription option[u]02.3-02.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Password[u]02.4-02.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Wrong password attempt count[u]02.5-02.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BAOC state[u]02.6-02.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BAIC state[u]02.7-02.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BOIC except directed to home HPLMN[u]03.0-03.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BAIC state[u]03.1-03.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BIC-Roam state[u]03.2-03.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFU state[u]03.3-03.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFU forwarded-to number[u]03.4-03.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFB state[u]03.5-03.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFB forwarded-to number[u]03.6-03.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRy state[u]03.7-03.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRy no reply condition timer[u]04.0-04.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRy forward-to number[u]04.1-04.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRc state[u]04.2-04.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRc forward-to number[u]04.3-04.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Call waiting state[u]04.4-04.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Call hold state[u]04.5-04.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Explict call transfer state[u]04.6-04.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Multi party state[u]04.7-04.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CAMEL flag[u]05.0-05.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]O-CSI[u]05.1-05.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]T-CSI[u]05.2-05.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]SS-CSI[u]05.3-05.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]SMS-CSI[u]05.4-05.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GPRS-CSI[u]05.5-05.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GPRS flag[u]05.6-05.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]PDP1[u]05.7-05.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]PDP2[u]06.0-06.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]PDP3[u]06.1-06.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]User name[u]06.2-06.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Certificate[u]06.3-06.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Alternative telephone[u]06.4-06.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Remark[u]06.5-06.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MSC area restrict flag[u]06.6-06.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Roaming restrict due to unsupport feature flag[u]06.7-06.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MS purged flag[u]07.0-07.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Mobile station not reachable for GPRS flag[u]07.1-07.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]LMSI[u]07.2-07.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]VLR number[u]07.3-07.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MSC number[u]07.4-07.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]SGSN number[u]07.5-07.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GGSN number[u]07.6-07.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GGSN address[u]07.7-07.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Route param[u]08.0-08.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MWD[u]08.1-08.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Reserved[u]08.2-12.7[u]select\n [remark]<br>Enable or disable checksum for each HLR subscriber data fields.<br>','\n [unit]IMSI[u]00.0-00.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Used flag[u]00.1-00.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MSISDN[u]00.2-00.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Fax number[u]00.3-00.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Data number[u]00.4-00.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Network access mode[u]00.5-00.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Mobile station category[u]00.6-00.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Subscriber status[u]00.7-00.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]ODB general data[u]01.0-01.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]ODB specific data[u]01.1-01.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Bearer service data[u]01.2-01.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Tele service data[u]01.3-01.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Country specification roam type[u]01.4-01.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GSM bearer capability[u]01.5-01.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Regional subscription zone code index[u]01.6-01.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CLIP state[u]01.7-01.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CLIR state[u]02.0-02.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]COLP state[u]02.1-02.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]COLR state[u]02.2-02.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Subscription option[u]02.3-02.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Password[u]02.4-02.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Wrong password attempt count[u]02.5-02.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BAOC state[u]02.6-02.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BAIC state[u]02.7-02.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BOIC except directed to home HPLMN[u]03.0-03.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BAIC state[u]03.1-03.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]BIC-Roam state[u]03.2-03.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFU state[u]03.3-03.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFU forwarded-to number[u]03.4-03.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFB state[u]03.5-03.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFB forwarded-to number[u]03.6-03.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRy state[u]03.7-03.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRy no reply condition timer[u]04.0-04.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRy forward-to number[u]04.1-04.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRc state[u]04.2-04.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CFNRc forward-to number[u]04.3-04.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Call waiting state[u]04.4-04.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Call hold state[u]04.5-04.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Explict call transfer state[u]04.6-04.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Multi party state[u]04.7-04.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]CAMEL flag[u]05.0-05.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]O-CSI[u]05.1-05.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]T-CSI[u]05.2-05.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]SS-CSI[u]05.3-05.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]SMS-CSI[u]05.4-05.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GPRS-CSI[u]05.5-05.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GPRS flag[u]05.6-05.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]PDP1[u]05.7-05.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]PDP2[u]06.0-06.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]PDP3[u]06.1-06.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]User name[u]06.2-06.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Certificate[u]06.3-06.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Alternative telephone[u]06.4-06.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Remark[u]06.5-06.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MSC area restrict flag[u]06.6-06.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Roaming restrict due to unsupport feature flag[u]06.7-06.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MS purged flag[u]07.0-07.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Mobile station not reachable for GPRS flag[u]07.1-07.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]LMSI[u]07.2-07.2[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]VLR number[u]07.3-07.3[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MSC number[u]07.4-07.4[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]SGSN number[u]07.5-07.5[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GGSN number[u]07.6-07.6[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]GGSN address[u]07.7-07.7[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Route param[u]08.0-08.0[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]MWD[u]08.1-08.1[u]select\n [v]0[opt]off\n [v]1[opt]on\n [unit]Reserved[u]08.2-12.7[u]select\n [remark]<br>Enable or disable checksum for each HLR subscriber data fields.<br>',NULL,NULL,2,1,10,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('verificationStartTime','verificationStartTime','Name:Verification Start Time;','Name:Verification Start Time;',19,1,3,'','','','PM12=0;AM01=1;AM02=2;AM03=3;AM04=4;AM05=5;AM06=6;AM07=7;AM08=8;AM09=9;AM10=10;AM11=11;AM12=12;PM01=13;PM02=14;PM03=15;PM04=16;PM05=17;PM06=18;PM07=19;PM08=20;PM09=21;PM10=22;PM11=23','PM12=0;AM01=1;AM02=2;AM03=3;AM04=4;AM05=5;AM06=6;AM07=7;AM08=8;AM09=9;AM10=10;AM11=11;AM12=12;PM01=13;PM02=14;PM03=15;PM04=16;PM05=17;PM06=18;PM07=19;PM08=20;PM09=21;PM10=22;PM11=23','The start time of daily HLR data verification procedure.','The start time of daily HLR data verification procedure.',2,1,9,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('replicationCommand','replicationCommand','','',19,1,3,'','','','replication=1','replication=1','Replication the data from remote server.','Replication the data from remote server.',2,1,8,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('maxReplicationMessageInterval','maxReplicationMessageInterval','Name:Replication Interval;','Name:Replication Interval;',19,2,3,'','0','255',NULL,NULL,'The time interval between sending successive replication commands to the destination nodes.<br>- Range = 1 - 255 seconds','The time interval between sending successive replication commands to the destination nodes.<br>- Range = 1 - 255 seconds',2,1,7,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('maxDownloadMessageInterval','maxDownloadMessageInterval','Name:Download Interval;','Name:Download Interval;',19,2,3,'','0','255',NULL,NULL,'The time interval between sending successive download commands to the destination nodes.<br>- Range = 1 - 255 seconds','The time interval between sending successive download commands to the destination nodes.<br>- Range = 1 - 255 seconds',2,1,6,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('maxVerificationMessageInterval','maxVerificationMessageInterval','Name:Verification Interval;','Name:Verification Interval;',19,2,3,'','0','255',NULL,NULL,'The time interval between sending successive verification commands to the destination nodes.<br>- Range = 1 - 255 seconds','The time interval between sending successive verification commands to the destination nodes.<br>- Range = 1 - 255 seconds',2,1,5,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('maxSynMessageInterval','maxSynMessageInterval','Name:Synchronization Interval;','Name:Synchronization Interval;',19,2,3,'','0','255',NULL,NULL,'The time interval between sending successive SYN commands to the destination nodes.<br>- Range = 1 - 255 seconds','The time interval between sending successive SYN commands to the destination nodes.<br>- Range = 1 - 255 seconds',2,1,4,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cDRFlag','cDRFlag','Name:CDR Flag;','Name:CDR Flag;',19,1,3,'','','','off=0;on=1','off=0;on=1','Enable or disable MHC CDR generation.','Enable or disable MHC CDR generation.',2,1,3,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mHC','mHC','','',18,3,3,'','','','off=0;on=1','off=0;on=1','Enable or disable the MHC function.','Enable or disable the MHC function.',2,1,2,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('license','license','Hidden Parameter;','Hidden Parameter;',18,3,3,'','','',NULL,NULL,'License.','License.',2,1,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('heartbeat','heartbeat','','',18,3,2,'','0','255',NULL,NULL,NULL,NULL,1,0,0,0,0,0,0,0,0,0);
|
|
/*!40000 ALTER TABLE `paramConf` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_0`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_0`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_0` (
|
|
`level_1` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_2` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_3` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_4` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_5` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_6` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_7` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_8` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_9` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_10` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`instanceNo` varchar(32) NOT NULL DEFAULT '0',
|
|
`initValue` varchar(255) NOT NULL,
|
|
`readValue` varchar(255) NOT NULL,
|
|
UNIQUE KEY `keyList` (`level_1`,`level_2`,`level_3`,`level_4`,`level_5`,`level_6`,`level_7`,`level_8`,`level_9`,`level_10`,`instanceNo`),
|
|
KEY `level_1` (`level_1`),
|
|
KEY `level_2` (`level_2`),
|
|
KEY `level_3` (`level_3`),
|
|
KEY `level_4` (`level_4`),
|
|
KEY `level_5` (`level_5`),
|
|
KEY `level_6` (`level_6`),
|
|
KEY `level_7` (`level_7`),
|
|
KEY `level_8` (`level_8`),
|
|
KEY `level_9` (`level_9`),
|
|
KEY `level_10` (`level_10`),
|
|
KEY `instanceNo` (`instanceNo`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `param_0`
|
|
--
|
|
|
|
LOCK TABLES `param_0` WRITE;
|
|
/*!40000 ALTER TABLE `param_0` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_0` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_1` (
|
|
`level_1` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_2` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_3` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_4` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_5` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_6` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_7` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_8` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_9` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_10` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`instanceNo` varchar(32) NOT NULL DEFAULT '0',
|
|
`initValue` varchar(255) NOT NULL,
|
|
`readValue` varchar(255) NOT NULL,
|
|
UNIQUE KEY `keyList` (`level_1`,`level_2`,`level_3`,`level_4`,`level_5`,`level_6`,`level_7`,`level_8`,`level_9`,`level_10`,`instanceNo`),
|
|
KEY `level_1` (`level_1`),
|
|
KEY `level_2` (`level_2`),
|
|
KEY `level_3` (`level_3`),
|
|
KEY `level_4` (`level_4`),
|
|
KEY `level_5` (`level_5`),
|
|
KEY `level_6` (`level_6`),
|
|
KEY `level_7` (`level_7`),
|
|
KEY `level_8` (`level_8`),
|
|
KEY `level_9` (`level_9`),
|
|
KEY `level_10` (`level_10`),
|
|
KEY `instanceNo` (`instanceNo`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `param_1`
|
|
--
|
|
|
|
LOCK TABLES `param_1` WRITE;
|
|
/*!40000 ALTER TABLE `param_1` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_1` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_99`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_99`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_99` (
|
|
`level_1` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_2` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_3` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_4` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_5` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_6` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_7` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_8` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_9` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`level_10` int(5) unsigned NOT NULL DEFAULT 0,
|
|
`instanceNo` varchar(32) NOT NULL DEFAULT '0',
|
|
`initValue` varchar(255) NOT NULL,
|
|
`readValue` varchar(255) NOT NULL,
|
|
UNIQUE KEY `keyList` (`level_1`,`level_2`,`level_3`,`level_4`,`level_5`,`level_6`,`level_7`,`level_8`,`level_9`,`level_10`,`instanceNo`),
|
|
KEY `level_1` (`level_1`),
|
|
KEY `level_2` (`level_2`),
|
|
KEY `level_3` (`level_3`),
|
|
KEY `level_4` (`level_4`),
|
|
KEY `level_5` (`level_5`),
|
|
KEY `level_6` (`level_6`),
|
|
KEY `level_7` (`level_7`),
|
|
KEY `level_8` (`level_8`),
|
|
KEY `level_9` (`level_9`),
|
|
KEY `level_10` (`level_10`),
|
|
KEY `instanceNo` (`instanceNo`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `param_99`
|
|
--
|
|
|
|
LOCK TABLES `param_99` WRITE;
|
|
/*!40000 ALTER TABLE `param_99` DISABLE KEYS */;
|
|
INSERT INTO `param_99` VALUES (2,1,2,0,0,0,0,0,0,0,'0000','1','1');
|
|
INSERT INTO `param_99` VALUES (2,1,3,0,0,0,0,0,0,0,'0000','1','1');
|
|
INSERT INTO `param_99` VALUES (2,1,4,0,0,0,0,0,0,0,'0000','5','5');
|
|
INSERT INTO `param_99` VALUES (2,1,5,0,0,0,0,0,0,0,'0000','10','10');
|
|
INSERT INTO `param_99` VALUES (2,1,6,0,0,0,0,0,0,0,'0000','5','5');
|
|
INSERT INTO `param_99` VALUES (2,1,7,0,0,0,0,0,0,0,'0000','5','5');
|
|
INSERT INTO `param_99` VALUES (2,1,9,0,0,0,0,0,0,0,'0000','17','17');
|
|
INSERT INTO `param_99` VALUES (2,1,10,0,0,0,0,0,0,0,'0000','4D4553482D38300000FFFFFFFF','4D4553482D38300000FFFFFFFF');
|
|
INSERT INTO `param_99` VALUES (2,1,12,0,0,0,0,0,0,0,'0000','3','3');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,1,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,2,0,0,0,0,0,'0000','MHC_Node0','MHC_Node0');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,3,0,0,0,0,0,'0000','155.226.202.188','155.226.202.188');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,4,0,0,0,0,0,'0000','155.226.202.189','155.226.202.189');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,5,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,6,0,0,0,0,0,'0000','Error:NoSuchObject','Error:NoSuchObject');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,1,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,2,0,0,0,0,0,'0001','MHC_Node1','MHC_Node1');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,3,0,0,0,0,0,'0001','155.226.202.182','155.226.202.182');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,4,0,0,0,0,0,'0001','155.226.202.183','155.226.202.183');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,5,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,6,0,0,0,0,0,'0001','1','1');
|
|
/*!40000 ALTER TABLE `param_99` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!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 */;
|
|
|
|
-- Dump completed on 2025-06-17 17:20:21
|