805 lines
44 KiB
SQL
805 lines
44 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_225
|
|
-- ------------------------------------------------------
|
|
-- 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_225`
|
|
--
|
|
|
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `OBJ_225` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;
|
|
|
|
USE `OBJ_225`;
|
|
|
|
--
|
|
-- Table structure for table `elementParamConf`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `elementParamConf`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `elementParamConf` (
|
|
`paramOBJ` varchar(32)/*old*/ CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
|
|
`paramName` varchar(32)/*old*/ CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
|
|
`webPageName` varchar(32)/*old*/ CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
|
|
`fileOption` varchar(128)/*old*/ CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT ''
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `elementParamConf`
|
|
--
|
|
|
|
LOCK TABLES `elementParamConf` WRITE;
|
|
/*!40000 ALTER TABLE `elementParamConf` DISABLE KEYS */;
|
|
INSERT INTO `elementParamConf` VALUES ('2.10','MSCID To Number','VLR','order.1.2');
|
|
INSERT INTO `elementParamConf` VALUES ('2.8','ConvPrefix','MSC','order.1.2.3.4.5');
|
|
INSERT INTO `elementParamConf` VALUES ('2.9','cli_conv_prefix','MSC','order.1.2.3.4.5.6.7');
|
|
INSERT INTO `elementParamConf` VALUES ('2.8','pstn_prefix','PSTN Prefix','order.1');
|
|
INSERT INTO `elementParamConf` VALUES ('2.8','ConvPrefix','VSS','order.1.2.3.4.5');
|
|
INSERT INTO `elementParamConf` VALUES ('2.8','ConvPrefix','Switch','order.1.2.3.4.5');
|
|
INSERT INTO `elementParamConf` VALUES ('2.8','ConvPrefix','PPS','order.1.2.3.4.5');
|
|
INSERT INTO `elementParamConf` VALUES ('2.8','ConvPrefix','IUA','order.1.2.3.4.5');
|
|
INSERT INTO `elementParamConf` VALUES ('2.8','ConvPrefix','SRF','order.1.2.3.4.5');
|
|
/*!40000 ALTER TABLE `elementParamConf` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- 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 ('localMSISDN','localMSISDN','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,5,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('localMSISDNTable','localMSISDNTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,5,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('localMSISDNEntry','localMSISDNEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','lmIndex','lmIndex',NULL,NULL,2,5,1,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('lmRowStatus','lmRowStatus','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,5,1,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('lmEndNumber','lmEndNumber','Key Parameter;Name:End Number;','Key Parameter;Name:End Number;',19,2,2,'','0','16',NULL,NULL,'Last number in the local MSISDN range.','Last number in the local MSISDN range.',2,5,1,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('lmStartNumber','lmStartNumber','Key Parameter;Name:Start Number;','Key Parameter;Name:Start Number;',19,2,2,'','0','16',NULL,NULL,'First number in the local MSISDN range.','First number in the local MSISDN range.',2,5,1,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('lmTitle','lmTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','7',NULL,NULL,'Local MSISDN entry name for identification purpose only.','Local MSISDN entry name for identification purpose only.',2,5,1,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('lmIndex','lmIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','0','127',NULL,NULL,'Local MSISDN entry index number ranges from 0 to 127.','Local MSISDN entry index number ranges from 0 to 127.',2,5,1,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cLIManipulation','cLIManipulation','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,4,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cLIManipulationTable','cLIManipulationTable','','',21,0,0,'','','',NULL,NULL,'Customize the presented caller number format for receiving short message.','Customize the presented caller number format for receiving short message.',2,4,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cLIManipulationEntry','cLIManipulationEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','cmIndex','cmIndex',NULL,NULL,2,4,1,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmRowStatus','cmRowStatus','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,4,1,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmNumberLength','cmNumberLength','Key Parameter;Name:Number Length;','Key Parameter;Name:Number Length;',19,2,3,'','0','16',NULL,NULL,'The length of the caller number.','The length of the caller number.',2,4,1,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmInsertedDigits','cmInsertedDigits','Key Parameter;Name:Inserted Digits;','Key Parameter;Name:Inserted Digits;',19,2,2,'','0','16',NULL,NULL,'The digits to be added to the front of the calling number.','The digits to be added to the front of the calling number.',2,4,1,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmInsertionCount','cmInsertionCount','Key Parameter;Name:Insertion Count;','Key Parameter;Name:Insertion Count;',19,2,3,'0','0','16',NULL,NULL,'The amount of digits to be inserted to the front of the calling number.','The amount of digits to be inserted to the front of the calling number.',2,4,1,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmModifiedNAI','cmModifiedNAI','Key Parameter;Name:Modified NAI;','Key Parameter;Name:Modified NAI;',19,1,3,'','','','idd=1;ndd=2;unknown=3','idd=1;ndd=2;unknown=3','Number Attribute Identity of the caller number after manipulation.','Number Attribute Identity of the caller number after manipulation.',2,4,1,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmDeletionCount','cmDeletionCount','Key Parameter;Name:Deletion Count;','Key Parameter;Name:Deletion Count;',19,2,3,'0','0','16',NULL,NULL,'The amount of digits to be deleted from the beginning of the calling number.','The amount of digits to be deleted from the beginning of the calling number.',2,4,1,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmPrefix','cmPrefix','Key Parameter;Name:Prefix;','Key Parameter;Name:Prefix;',19,2,2,'','0','16',NULL,NULL,'The initial digits of the caller number.','The initial digits of the caller number.',2,4,1,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmOriginalNAI','cmOriginalNAI','Key Parameter;Name:Original NAI;','Key Parameter;Name:Original NAI;',19,1,3,'','','','idd=1;ndd=2;unknown=3','idd=1;ndd=2;unknown=3','Original Number Attribute Identity of the caller numbers beginning with this prefix.','Original Number Attribute Identity of the caller numbers beginning with this prefix.',2,4,1,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmTitle','cmTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','8',NULL,NULL,'Prefix name for identification purpose only.','Prefix name for identification purpose only.',2,4,1,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cmIndex','cmIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','0','63',NULL,NULL,'Prefix index number ranges from 0 to 63.','Prefix index number ranges from 0 to 63.',2,4,1,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('numberGroup','numberGroup','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,3,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('numberGroupTable','numberGroupTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,3,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('numberGroupEntry','numberGroupEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','ngIndex','ngIndex',NULL,NULL,2,3,1,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngRowStatus','ngRowStatus','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,3,1,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngReplaceDigitWith','ngReplaceDigitWith','Key Parameter;Name:Replace Digits With;','Key Parameter;Name:Replace Digits With;',19,2,2,'','0','12',NULL,NULL,'Replace digits with this string.','Replace digits with this string.',2,3,1,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngReplaceDigitEnd','ngReplaceDigitEnd','Key Parameter;Name:Replace Digits To;','Key Parameter;Name:Replace Digits To;',19,2,3,'','0','255',NULL,NULL,'Last digit to replace (position).','Last digit to replace (position).',2,3,1,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngReplaceDigitStart','ngReplaceDigitStart','Key Parameter;Name:Replace Digits From;','Key Parameter;Name:Replace Digits From;',19,2,3,'','0','255',NULL,NULL,'First digit to replace (position).','First digit to replace (position).',2,3,1,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngEndNumber','ngEndNumber','Key Parameter;Name:End Number;','Key Parameter;Name:End Number;',19,2,2,'','0','16',NULL,NULL,'Last number in the group.','Last number in the group.',2,3,1,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngStartNumber','ngStartNumber','Key Parameter;Name:Start Number;','Key Parameter;Name:Start Number;',19,2,2,'','0','16',NULL,NULL,'First number in the group.','First number in the group.',2,3,1,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngTitle','ngTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','7',NULL,NULL,'Number group name for identification purpose only.','Number group name for identification purpose only.',2,3,1,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ngIndex','ngIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','0','127',NULL,NULL,'Number group index number ranges from 0 to 127.','Number group index number ranges from 0 to 127.',2,3,1,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prefixManipulation','prefixManipulation','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,2,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prefixManipulationTable','prefixManipulationTable','','',21,0,0,'','','',NULL,NULL,'Convert service number format for MAP applications. Such as prepaid charging, querying and voice mail routing.','Convert service number format for MAP applications. Such as prepaid charging, querying and voice mail routing.',2,2,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prefixManipulationEntry','prefixManipulationEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','pmIndex','pmIndex',NULL,NULL,2,2,1,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmRowStatus','pmRowStatus','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,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmNumberLength','pmNumberLength','Key Parameter;Name:Number Length;','Key Parameter;Name:Number Length;',19,2,3,'','0','16',NULL,NULL,'The length of the incoming number.','The length of the incoming number.',2,2,1,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmInsertedDigits','pmInsertedDigits','Key Parameter;Name:Inserted Digits;','Key Parameter;Name:Inserted Digits;',19,2,2,'','0','16',NULL,NULL,'The digits to be added to the front of the dialed number.','The digits to be added to the front of the dialed number.',2,2,1,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmInsertionCount','pmInsertionCount','Key Parameter;Name:Insertion Count;','Key Parameter;Name:Insertion Count;',19,2,3,'0','0','16',NULL,NULL,'The amount of digits to be inserted to the front of the dialed number.','The amount of digits to be inserted to the front of the dialed number.',2,2,1,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmDeletionCount','pmDeletionCount','Key Parameter;Name:Deletion Count;','Key Parameter;Name:Deletion Count;',19,2,3,'0','0','16',NULL,NULL,'The amount of digits to be deleted from the beginning of the incoming number.','The amount of digits to be deleted from the beginning of the incoming number.',2,2,1,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmPrefix','pmPrefix','Key Parameter;Name:Prefix;','Key Parameter;Name:Prefix;',19,2,2,'','0','16',NULL,NULL,'A combination digits that dialed to the destination.','A combination digits that dialed to the destination.',2,2,1,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmTitle','pmTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','7',NULL,NULL,'Prefix name for identification purpose only.','Prefix name for identification purpose only.',2,2,1,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pmIndex','pmIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','0','127',NULL,NULL,'Prefix index number ranges from 0 to 127.','Prefix index number ranges from 0 to 127.',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 ('command','command','','',21,0,3,'','','','saveParameter=1','saveParameter=1',NULL,NULL,2,1,12,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('nationalPrefix','nationalPrefix','Key Parameter;','Key Parameter;',19,2,9,'','2','2','\n [unit]National Prefix[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n National prefix for the operating country to make a national call.','\n [unit]National Prefix[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n National prefix for the operating country to make a national call.',NULL,NULL,2,1,6,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('internationalPrefix','internationalPrefix','Key Parameter;','Key Parameter;',19,2,9,'','2','2','\n [unit]International Prefix[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Access code for international network.','\n [unit]International Prefix[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Access code for international network.',NULL,NULL,2,1,5,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('nDC','nDC','Key Parameter;','Key Parameter;',19,2,9,'','3','3','\n [unit]NDC[u]00.0-02.7[u]input\n [v]keepHex-low-E\n [remark]\n National Destination Code','\n [unit]NDC[u]00.0-02.7[u]input\n [v]keepHex-low-E\n [remark]\n National Destination Code',NULL,NULL,2,1,4,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cC','cC','Key Parameter;','Key Parameter;',19,2,9,'','2','2','\n [unit]CC[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Country Code','\n [unit]CC[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Country Code',NULL,NULL,2,1,3,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mNC','mNC','Key Parameter;','Key Parameter;',19,2,9,'','2','2','\n [unit]MNC[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Mobile Network Code','\n [unit]MNC[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Mobile Network Code',NULL,NULL,2,1,2,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mCC','mCC','Key Parameter;','Key Parameter;',19,2,9,'','2','2','\n [unit]MCC[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Mobile Country Code','\n [unit]MCC[u]00.0-01.7[u]input\n [v]keepHex-low-E\n [remark]\n Mobile Country Code',NULL,NULL,2,1,1,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_2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_2` (
|
|
`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_2`
|
|
--
|
|
|
|
LOCK TABLES `param_2` WRITE;
|
|
/*!40000 ALTER TABLE `param_2` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_2` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_3` (
|
|
`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_3`
|
|
--
|
|
|
|
LOCK TABLES `param_3` WRITE;
|
|
/*!40000 ALTER TABLE `param_3` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_3` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_4` (
|
|
`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_4`
|
|
--
|
|
|
|
LOCK TABLES `param_4` WRITE;
|
|
/*!40000 ALTER TABLE `param_4` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_4` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_5`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_5`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_5` (
|
|
`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_5`
|
|
--
|
|
|
|
LOCK TABLES `param_5` WRITE;
|
|
/*!40000 ALTER TABLE `param_5` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_5` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_6`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_6`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_6` (
|
|
`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_6`
|
|
--
|
|
|
|
LOCK TABLES `param_6` WRITE;
|
|
/*!40000 ALTER TABLE `param_6` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_6` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_7`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_7`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_7` (
|
|
`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_7`
|
|
--
|
|
|
|
LOCK TABLES `param_7` WRITE;
|
|
/*!40000 ALTER TABLE `param_7` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_7` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_8`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_8`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_8` (
|
|
`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_8`
|
|
--
|
|
|
|
LOCK TABLES `param_8` WRITE;
|
|
/*!40000 ALTER TABLE `param_8` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `param_8` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `param_9`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `param_9`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `param_9` (
|
|
`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_9`
|
|
--
|
|
|
|
LOCK TABLES `param_9` WRITE;
|
|
/*!40000 ALTER TABLE `param_9` DISABLE KEYS */;
|
|
INSERT INTO `param_9` VALUES (2,1,1,0,0,0,0,0,0,0,'0000','460E','460E');
|
|
INSERT INTO `param_9` VALUES (2,1,2,0,0,0,0,0,0,0,'0000','02EE','02EE');
|
|
INSERT INTO `param_9` VALUES (2,1,3,0,0,0,0,0,0,0,'0000','86EE','86EE');
|
|
INSERT INTO `param_9` VALUES (2,1,4,0,0,0,0,0,0,0,'0000','755EEE','755EEE');
|
|
INSERT INTO `param_9` VALUES (2,1,5,0,0,0,0,0,0,0,'0000','00EE','00EE');
|
|
INSERT INTO `param_9` VALUES (2,1,6,0,0,0,0,0,0,0,'0000','0EEE','0EEE');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,4,0,0,0,0,0,'0001','66755901999','66755901999');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,3,0,0,0,0,0,'0001','66755900000','66755900000');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,2,0,0,0,0,0,'0001','msisdn_seg#1','msisdn_seg#1');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,5,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,1,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,4,0,0,0,0,0,'0000','86755900999','86755900999');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,3,0,0,0,0,0,'0000','86755900000','86755900000');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0010','10','10');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0009','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0009','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0009','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0009','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0009','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0009','596696','596696');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0009','PSTN','PSTN');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0009','9','9');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0008','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0008','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0008','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0008','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0008','2','2');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0008','0086755','0086755');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0008','Prx_8','Prx_8');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0008','8','8');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0007','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0007','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0007','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0007','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0007','2','2');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0007','0066755','0066755');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0007','Prx_7','Prx_7');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0007','7','7');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0006','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0006','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0006','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0006','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0006','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0006','333','333');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0006','PPS','PPS');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0006','6','6');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0005','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0005','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0005','86755','86755');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0005','5','5');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0005','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0005','90','90');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0005','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0005','5','5');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0004','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0004','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0004','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0004','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0004','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0004','667559','667559');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0004','3G_Subs','3G_Subs');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0003','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0004','4','4');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0003','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0003','66','66');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0003','2','2');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0003','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0003','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0003','0755','0755');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0002','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0003','3','3');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0002','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0002','66','66');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0002','2','2');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0002','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0002','755','755');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,2,0,0,0,0,0,'0000','msisdn_seg#0','msisdn_seg#0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0002','Prx_2','Prx_2');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0002','2','2');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0001','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0001','555','555');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0001','pps ','pps ');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0000','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,5,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_9` VALUES (2,5,1,1,1,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,1,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,2,0,0,0,0,0,'0000','Cli_0','Cli_0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,3,0,0,0,0,0,'0000','1','1');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,4,0,0,0,0,0,'0000','86755','86755');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,5,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,6,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,7,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,8,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,9,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,10,0,0,0,0,0,'0000','1','1');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,1,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,2,0,0,0,0,0,'0001','Cli_1','Cli_1');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,3,0,0,0,0,0,'0001','3','3');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,4,0,0,0,0,0,'0001','0086755','0086755');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,5,0,0,0,0,0,'0001','2','2');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,6,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,7,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,8,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,9,0,0,0,0,0,'0001','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,10,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,1,0,0,0,0,0,'0002','2','2');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,2,0,0,0,0,0,'0002','Cli_2','Cli_2');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,3,0,0,0,0,0,'0002','1','1');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,4,0,0,0,0,0,'0002','667559','667559');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,5,0,0,0,0,0,'0002','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,6,0,0,0,0,0,'0002','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,7,0,0,0,0,0,'0002','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,8,0,0,0,0,0,'0002','','');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,9,0,0,0,0,0,'0002','0','0');
|
|
INSERT INTO `param_9` VALUES (2,4,1,1,10,0,0,0,0,0,'0002','1','1');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0000','867559','867559');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0000','2G_Subs','2G_Subs');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,1,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,2,0,0,0,0,0,'0010','Prx_10','Prx_10');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,3,0,0,0,0,0,'0010','692','692');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,4,0,0,0,0,0,'0010','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,5,0,0,0,0,0,'0010','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,6,0,0,0,0,0,'0010','','');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,7,0,0,0,0,0,'0010','0','0');
|
|
INSERT INTO `param_9` VALUES (2,2,1,1,8,0,0,0,0,0,'0010','1','1');
|
|
/*!40000 ALTER TABLE `param_9` 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 */;
|
|
/*!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:20
|