712 lines
69 KiB
SQL
712 lines
69 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_395
|
|
-- ------------------------------------------------------
|
|
-- 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_395`
|
|
--
|
|
|
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `OBJ_395` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;
|
|
|
|
USE `OBJ_395`;
|
|
|
|
--
|
|
-- Table structure for table `logAttrDef_1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `logAttrDef_1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `logAttrDef_1` (
|
|
`keyId` tinyint(4) NOT NULL AUTO_INCREMENT,
|
|
`fieldName` varchar(50) NOT NULL,
|
|
`name_1` varchar(30) NOT NULL,
|
|
`name_2` varchar(30) NOT NULL,
|
|
`desc_1` varchar(200) NOT NULL,
|
|
`desc_2` varchar(200) NOT NULL,
|
|
`paramType` tinyint(1) NOT NULL DEFAULT 0,
|
|
`operType` tinyint(1) NOT NULL DEFAULT 0,
|
|
`number` int(6) NOT NULL DEFAULT 0,
|
|
`length` smallint(3) NOT NULL DEFAULT 0,
|
|
`valueType` tinyint(1) NOT NULL DEFAULT 0,
|
|
`initValue` varchar(255) NOT NULL,
|
|
`minValue` varchar(255) NOT NULL,
|
|
`maxValue` varchar(255) NOT NULL,
|
|
`setTemplate_1` text NOT NULL,
|
|
`setTemplate_2` text NOT NULL,
|
|
`needNote` tinyint(1) NOT NULL DEFAULT 0,
|
|
`note_1` varchar(200) NOT NULL,
|
|
`note_2` varchar(200) NOT 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,
|
|
PRIMARY KEY (`keyId`),
|
|
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 AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `logAttrDef_1`
|
|
--
|
|
|
|
LOCK TABLES `logAttrDef_1` WRITE;
|
|
/*!40000 ALTER TABLE `logAttrDef_1` DISABLE KEYS */;
|
|
INSERT INTO `logAttrDef_1` VALUES (1,'card_no','card serial number','card serial number','card serial number','card serial number',0,1,1,16,3,'0000000000000000','0000000000000000','9999999999999999','','',0,'','',1,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `logAttrDef_1` VALUES (2,'card_hrn','pwd','pwd','pwd','pwd',0,1,1,8,4,'0000000000000000','0000000000000000','FFFFFFFFFFFFFFFF','','',0,'','',2,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `logAttrDef_1` VALUES (3,'face_value','face value','face value','face value','face value',0,1,1,5,2,'00000000','000000000000','0000000000','','',0,'','',3,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `logAttrDef_1` VALUES (4,'card_status','card status','card status','card status','card status',0,3,1,1,4,'00','00','02','','',0,'','',4,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `logAttrDef_1` VALUES (5,'expiry_date','expiry date','expiry date','expiry date','expiry date',0,3,1,7,4,'00000000000000','00000000000000','99999999999999','','',0,'','',5,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `logAttrDef_1` VALUES (6,'valid_time','valid days','valid days','valid days','valid days',0,1,1,2,2,'0060','0000','9999','','',0,'','',6,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `logAttrDef_1` VALUES (7,'msisdn_used','msisdn charged','msisdn charged','msisdn charged','msisdn charged',0,3,1,12,3,'000000000000000000000','000000000000000000000000','999999999999','','',0,'','',7,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `logAttrDef_1` VALUES (8,'updated_date','charged date','charged date','charged date','charged date',0,3,1,7,4,'00000000000000','00000000000000','99999999999999','','',0,'','',8,0,0,0,0,0,0,0,0,0);
|
|
/*!40000 ALTER TABLE `logAttrDef_1` 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 ('fileOperation','fileOperation','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,5,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('saveCommand','saveCommand','','',19,1,3,'','','','saveUserData=1;saveTariff=2;saveRechargeCard=3;saveAll=4','saveUserData=1;saveTariff=2;saveRechargeCard=3;saveAll=4',NULL,NULL,2,5,5,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('newTariffStarTime','newTariffStarTime','Hidden Parameter;','Hidden Parameter;',19,2,2,'','14','14',NULL,NULL,NULL,NULL,2,5,4,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('newTariffFlag','newTariffFlag','Hidden Parameter;','Hidden Parameter;',19,2,3,'','0','255',NULL,NULL,NULL,NULL,2,5,3,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('importRechangeCard','importRechangeCard','Hidden Parameter;','Hidden Parameter;',19,2,9,'','7','7','\n [unit]Progress Report[u]00.0-00.7[u]select\n [v]0[opt]Idle\n [v]1[opt]Requesting\n [v]2[opt]Processing\n [v]3[opt]Succeeded\n [v]4[opt]Failed\n [unit]Total Cards[u]01.0-03.7[u]input\n [v]toDec-high-0\n [unit]Imported Cards[u]04.0-06.7[u]input\n [v]toDec-high-0','\n [unit]Progress Report[u]00.0-00.7[u]select\n [v]0[opt]Idle\n [v]1[opt]Requesting\n [v]2[opt]Processing\n [v]3[opt]Succeeded\n [v]4[opt]Failed\n [unit]Total Cards[u]01.0-03.7[u]input\n [v]toDec-high-0\n [unit]Imported Cards[u]04.0-06.7[u]input\n [v]toDec-high-0',NULL,NULL,2,5,2,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('importSubs','importSubs','Hidden Parameter;','Hidden Parameter;',19,2,9,'','7','7','\n [unit]Progress Report[u]00.0-00.7[u]select\n [v]0[opt]Idle\n [v]1[opt]Requesting\n [v]2[opt]Processing\n [v]3[opt]Succeeded\n [v]4[opt]Failed\n [unit]Total Subscribers[u]01.0-03.7[u]input\n [v]toDec-high-0\n [unit]Imported Subscribers[u]04.0-06.7[u]input\n [v]toDec-high-0','\n [unit]Progress Report[u]00.0-00.7[u]select\n [v]0[opt]Idle\n [v]1[opt]Requesting\n [v]2[opt]Processing\n [v]3[opt]Succeeded\n [v]4[opt]Failed\n [unit]Total Subscribers[u]01.0-03.7[u]input\n [v]toDec-high-0\n [unit]Imported Subscribers[u]04.0-06.7[u]input\n [v]toDec-high-0',NULL,NULL,2,5,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('callRouteToVMS','callRouteToVMS','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,4,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vMSUserSegmentsTable','vMSUserSegmentsTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,4,30,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vMSUserSegmentsEntry','vMSUserSegmentsEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','vusIndex','vusIndex',NULL,NULL,2,4,30,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusRowStatus','vusRowStatus','Key Parameter;','Key Parameter;',19,2,16,'','','',NULL,NULL,NULL,NULL,2,4,30,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusLeaveMessageDepositNumber','vusLeaveMessageDepositNumber','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,30,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusPSTNServiceNumber','vusPSTNServiceNumber','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,30,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusPLMNServiceNumber','vusPLMNServiceNumber','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,30,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusEndMSISDN','vusEndMSISDN','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,30,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusStartMSISDN','vusStartMSISDN','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,30,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusTitle','vusTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,NULL,NULL,2,4,30,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vusIndex','vusIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','127',NULL,NULL,NULL,NULL,2,4,30,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ringBackServiceKey','ringBackServiceKey','','',19,2,3,'','0','12',NULL,NULL,NULL,NULL,2,4,7,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('isPostpaidAllowed','isPostpaidAllowed','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,4,6,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('routeNumberOption','routeNumberOption','','',19,1,3,'','','','callerNumber=0;calledNumber=1','callerNumber=0;calledNumber=1',NULL,NULL,2,4,5,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('routeMethodOption','routeMethodOption','','',19,1,3,'','','','byPrefix=0;byWholeNumber=1','byPrefix=0;byWholeNumber=1',NULL,NULL,2,4,4,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('vMSLeaveMessageNumber','vMSLeaveMessageNumber','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,3,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pSTNServiceNumber','pSTNServiceNumber','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,2,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('pLMNServiceNumber','pLMNServiceNumber','','',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,4,1,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('srfParameters','srfParameters','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,3,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('serviceKeyTable','serviceKeyTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,3,29,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('serviceKeyEntry','serviceKeyEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','skIndex','skIndex',NULL,NULL,2,3,29,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('skRowStatus','skRowStatus','','',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,29,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('skServiceKey','skServiceKey','Key Parameter;','Key Parameter;',19,2,3,'','0','12',NULL,NULL,NULL,NULL,2,3,29,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('skTitle','skTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,3,29,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('skIndex','skIndex','Key Parameter;','Key Parameter;',18,3,3,'','0','6',NULL,NULL,NULL,NULL,2,3,29,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('serviceNumberTable','serviceNumberTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,3,28,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('serviceNumberEntry','serviceNumberEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','snIndex','snIndex',NULL,NULL,2,3,28,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('snRowStatus','snRowStatus','','',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,28,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('snServiceNumber','snServiceNumber','Key Parameter;','Key Parameter;',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,3,28,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('snTitle','snTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,3,28,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('snIndex','snIndex','Key Parameter;','Key Parameter;',18,3,3,'','0','8',NULL,NULL,NULL,NULL,2,3,28,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('sRFNumberTable','sRFNumberTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,3,27,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('sRFNumberEntry','sRFNumberEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','srfIndex','srfIndex',NULL,NULL,2,3,27,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('srfRowStatus','srfRowStatus','','',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,27,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('srfNumber','srfNumber','Key Parameter;','Key Parameter;',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,3,27,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('srfTitle','srfTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,3,27,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('srfIndex','srfIndex','Key Parameter;','Key Parameter;',18,3,3,'','0','1',NULL,NULL,NULL,NULL,2,3,27,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('iVRSourceTable','iVRSourceTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,3,26,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('iVRSourceEntry','iVRSourceEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','ivrIndex','ivrIndex',NULL,NULL,2,3,26,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ivrRowStatus','ivrRowStatus','','',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,26,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ivrRecharge','ivrRecharge','Key Parameter;','Key Parameter;',19,1,3,'','','','localSRF=0;externalIVR=1','localSRF=0;externalIVR=1',NULL,NULL,2,3,26,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ivrInquiry','ivrInquiry','Key Parameter;','Key Parameter;',19,1,3,'','','','localSRF=0;externalIVR=1','localSRF=0;externalIVR=1',NULL,NULL,2,3,26,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ivrTitle','ivrTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,3,26,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ivrIndex','ivrIndex','Key Parameter;','Key Parameter;',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,3,26,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cOS','cOS','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,2,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gprsControlTable','gprsControlTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,59,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gprsControlEntry','gprsControlEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','gcIndex;gcCOSIndex','gcIndex;gcCOSIndex',NULL,NULL,2,2,59,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcRowStatus','gcRowStatus','','',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,59,1,22,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanTariffID3','gcGprsCapPlanTariffID3','','',19,2,3,'','0','64',NULL,NULL,NULL,NULL,2,2,59,1,21,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanTariffID2','gcGprsCapPlanTariffID2','','',19,2,3,'','0','64',NULL,NULL,NULL,NULL,2,2,59,1,20,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanTariffID1','gcGprsCapPlanTariffID1','','',19,2,3,'','0','64',NULL,NULL,NULL,NULL,2,2,59,1,19,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanTariffID0','gcGprsCapPlanTariffID0','','',19,2,3,'','0','64',NULL,NULL,NULL,NULL,2,2,59,1,18,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanThreshold2','gcGprsCapPlanThreshold2','','',19,2,3,'','0','1073741824',NULL,NULL,NULL,NULL,2,2,59,1,17,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanThreshold1','gcGprsCapPlanThreshold1','','',19,2,3,'','0','1073741824',NULL,NULL,NULL,NULL,2,2,59,1,16,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanThreshold0','gcGprsCapPlanThreshold0','','',19,2,3,'','0','1073741824',NULL,NULL,NULL,NULL,2,2,59,1,15,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsCapPlanType','gcGprsCapPlanType','','',19,1,3,'','','','volume=0;chargedFee=1','volume=0;chargedFee=1',NULL,NULL,2,2,59,1,14,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcChargeBy','gcChargeBy','Key Parameter;','Key Parameter;',19,1,3,'','','','cosDefined=0;sgsnLocation=1','cosDefined=0;sgsnLocation=1',NULL,NULL,2,2,59,1,13,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcDurationThresholdDiff','gcDurationThresholdDiff','Key Parameter;','Key Parameter;',19,2,3,'','30','90',NULL,NULL,NULL,NULL,2,2,59,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcMaxDurationQuotaEachTime','gcMaxDurationQuotaEachTime','Key Parameter;','Key Parameter;',19,2,3,'','60','6000',NULL,NULL,NULL,NULL,2,2,59,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcVolumeThresholdDiff','gcVolumeThresholdDiff','Key Parameter;','Key Parameter;',19,2,3,'','1','102400',NULL,NULL,NULL,NULL,2,2,59,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcMaxVolumeQuotaEachTime','gcMaxVolumeQuotaEachTime','Key Parameter;','Key Parameter;',19,2,3,'','1','1024000',NULL,NULL,NULL,NULL,2,2,59,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcMaxSmsForGprsNotificationPerDay','gcMaxSmsForGprsNotificationPerDay','Key Parameter;','Key Parameter;',19,2,3,'','0','1000',NULL,NULL,NULL,NULL,2,2,59,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsNotificationWhenTerminate','gcGprsNotificationWhenTerminate','Key Parameter;','Key Parameter;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,59,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcInactiveSessionLimit','gcInactiveSessionLimit','','',19,2,3,'','0','36000',NULL,NULL,NULL,NULL,2,2,59,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcMiniBalanceForGprs','gcMiniBalanceForGprs','Key Parameter;','Key Parameter;',19,2,3,'','0','100000',NULL,NULL,NULL,NULL,2,2,59,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcGprsChargeStatus','gcGprsChargeStatus','Key Parameter;','Key Parameter;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,59,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcTitle','gcTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','16',NULL,NULL,NULL,NULL,2,2,59,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcIndex','gcIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','1',NULL,NULL,NULL,NULL,2,2,59,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('gcCOSIndex','gcCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,59,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('poolAccountTable','poolAccountTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,58,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('poolAccountEntry','poolAccountEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','paIndex;paCOSIndex','paIndex;paCOSIndex',NULL,NULL,2,2,58,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paRowStatus','paRowStatus','','',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,58,1,13,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paChildMaxConsumedFee','paChildMaxConsumedFee','Key Parameter;','Key Parameter;',19,2,3,'','0','100000',NULL,NULL,NULL,NULL,2,2,58,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paChildMaxSMSPerDay','paChildMaxSMSPerDay','Key Parameter;','Key Parameter;',19,2,3,'','0','1000',NULL,NULL,NULL,NULL,2,2,58,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paChildMaxCallsPerDay','paChildMaxCallsPerDay','Key Parameter;','Key Parameter;',19,2,3,'','0','1000',NULL,NULL,NULL,NULL,2,2,58,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paChildCreditFrom','paChildCreditFrom','Key Parameter;','Key Parameter;',19,1,3,'','','','autoPeriodicRechargeFromParent=0;parentTransfer=1','autoPeriodicRechargeFromParent=0;parentTransfer=1',NULL,NULL,2,2,58,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paChildAllowSelfTransfer','paChildAllowSelfTransfer','Key Parameter;','Key Parameter;',19,1,3,'','','','no=0;yes=1','no=0;yes=1',NULL,NULL,2,2,58,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paChildAllowSelfRecharge','paChildAllowSelfRecharge','Key Parameter;','Key Parameter;',19,1,3,'','','','no=0;yes=1','no=0;yes=1',NULL,NULL,2,2,58,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paParentChosenCosB','paParentChosenCosB','','',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,58,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paParentChosenCosA','paParentChosenCosA','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,58,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paRole','paRole','Key Parameter;','Key Parameter;',19,1,3,'','','','normal=0;parent=1;child=2','normal=0;parent=1;child=2',NULL,NULL,2,2,58,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paTitle','paTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','16',NULL,NULL,NULL,NULL,2,2,58,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paIndex','paIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','1',NULL,NULL,NULL,NULL,2,2,58,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('paCOSIndex','paCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,58,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cAPPlanTable','cAPPlanTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,57,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cAPPlanEntry','cAPPlanEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','cpIndex;cpCOSIndex','cpIndex;cpCOSIndex',NULL,NULL,2,2,57,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpRowStatus','cpRowStatus','','',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,57,1,13,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpTariffID3','cpTariffID3','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,57,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpTariffID2','cpTariffID2','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,57,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpTariffID1','cpTariffID1','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,57,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpTariffID0','cpTariffID0','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,57,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpThreshold2','cpThreshold2','Key Parameter;','Key Parameter;',19,2,3,'','0','2147483647',NULL,NULL,NULL,NULL,2,2,57,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpThreshold1','cpThreshold1','Key Parameter;','Key Parameter;',19,2,3,'','0','2147483647',NULL,NULL,NULL,NULL,2,2,57,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpThreshold0','cpThreshold0','Key Parameter;','Key Parameter;',19,2,3,'','0','2147483647',NULL,NULL,NULL,NULL,2,2,57,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpType','cpType','Key Parameter;','Key Parameter;',19,1,3,'','','','capByAmount=0;capByCharge=1','capByAmount=0;capByCharge=1',NULL,NULL,2,2,57,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpFlag','cpFlag','Key Parameter;','Key Parameter;',19,1,3,'','','','disable=0;capCallOnly=1;capSMOnly=2;capSMAndCall=3','disable=0;capCallOnly=1;capSMOnly=2;capSMAndCall=3',NULL,NULL,2,2,57,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpTitle','cpTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','16',NULL,NULL,NULL,NULL,2,2,57,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpIndex','cpIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','1',NULL,NULL,NULL,NULL,2,2,57,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cpCOSIndex','cpCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,57,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rechargePromotionTable','rechargePromotionTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,56,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rechargePromotionEntry','rechargePromotionEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','rpIndex;rpCOSIndex','rpIndex;rpCOSIndex',NULL,NULL,2,2,56,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rpRowStatus','rpRowStatus','','',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,56,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rpPromotionValidity','rpPromotionValidity','Key Parameter;','Key Parameter;',19,2,16,'','0','2147483647',NULL,NULL,NULL,NULL,2,2,56,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rpPromotionBonus','rpPromotionBonus','Key Parameter;','Key Parameter;',19,2,16,'','0','2147483647',NULL,NULL,NULL,NULL,2,2,56,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rpRechargeCardCredit','rpRechargeCardCredit','Key Parameter;','Key Parameter;',19,2,16,'','0','2147483647',NULL,NULL,NULL,NULL,2,2,56,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rpTitle','rpTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','16',NULL,NULL,NULL,NULL,2,2,56,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rpIndex','rpIndex','Key Parameter;','Key Parameter;',48,2,16,'','0','3',NULL,NULL,NULL,NULL,2,2,56,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rpCOSIndex','rpCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,56,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rechargeCardValidityTable','rechargeCardValidityTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,55,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rechargeCardValidityEntry','rechargeCardValidityEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','rcvIndex;rcvCOSIndex','rcvIndex;rcvCOSIndex',NULL,NULL,2,2,55,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rcvRowStatus','rcvRowStatus','','',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,55,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rcvMTValidity','rcvMTValidity','Key Parameter;','Key Parameter;',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,55,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rcvMOValidity','rcvMOValidity','Key Parameter;','Key Parameter;',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,55,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rcvCardCredit','rcvCardCredit','Key Parameter;','Key Parameter;',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,55,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rcvTitle','rcvTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,2,55,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rcvIndex','rcvIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','3',NULL,NULL,NULL,NULL,2,2,55,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rcvCOSIndex','rcvCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,55,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('sMSNotificationInquiryTable','sMSNotificationInquiryTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,54,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('sMSNotificationInquiryEntry','sMSNotificationInquiryEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','smsIndex;smsCOSIndex','smsIndex;smsCOSIndex',NULL,NULL,2,2,54,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsRowStatus','smsRowStatus','','',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,54,1,15,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsNotificationWhenApplyOverdraft','smsNotificationWhenApplyOverdraft','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','Notification When Apply Overdraft.','Notification When Apply Overdraft.',2,2,54,1,14,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsNotificationWhenCapPlanChanged','smsNotificationWhenCapPlanChanged','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','Whether or not to send a notification SMS when CAP Plan is to be changed.','Whether or not to send a notification SMS when CAP Plan is to be changed.',2,2,54,1,13,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsNotificationWhenCleanBalance','smsNotificationWhenCleanBalance','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','Wether or not to send a notification SMS when clear expired account balance.','Wether or not to send a notification SMS when clear expired account balance.',2,2,54,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsFreeInquiryPerDay','smsFreeInquiryPerDay','','',19,2,3,'','0','128',NULL,NULL,NULL,NULL,2,2,54,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsChargeWhenInquiryBySMS','smsChargeWhenInquiryBySMS','','',19,1,3,'','','','notCharge=0;charge=1','notCharge=0;charge=1',NULL,NULL,2,2,54,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsInsufficientBalanceThreshold','smsInsufficientBalanceThreshold','','',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,54,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsNotificationWhenBalanceInsufficient','smsNotificationWhenBalanceInsufficient','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,54,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsTheDaysSendingSMSBeforeExpiredDay','smsTheDaysSendingSMSBeforeExpiredDay','','',19,2,3,'','0','32',NULL,NULL,NULL,NULL,2,2,54,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsNotificationWhenExpired','smsNotificationWhenExpired','Key Parameter;','Key Parameter;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,54,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsNotificationWhenInquiry','smsNotificationWhenInquiry','Key Parameter;','Key Parameter;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,54,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsNotificationWhenRecharge','smsNotificationWhenRecharge','Key Parameter;','Key Parameter;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,54,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsTitle','smsTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','16',NULL,NULL,NULL,NULL,2,2,54,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsIndex','smsIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','0',NULL,NULL,NULL,NULL,2,2,54,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('smsCOSIndex','smsCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,54,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('accountValidityTable','accountValidityTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,53,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('accountValidityEntry','accountValidityEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','avIndex;avCOSIndex','avIndex;avCOSIndex',NULL,NULL,2,2,53,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avRowStatus','avRowStatus','','',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,53,1,13,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avValidDaysActivatedByInquiringAccountWithZeroBalance','avValidDaysActivatedByInquiringAccountWithZeroBalance','','',19,2,3,'','0','128',NULL,NULL,NULL,NULL,2,2,53,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avActivationByInquiryIs','avActivationByInquiryIs','','',19,1,3,'','','','disabled=0;eabled=1','disabled=0;eabled=1',NULL,NULL,2,2,53,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avValidDaysChangeTo','avValidDaysChangeTo','','',19,2,3,'','0','128',NULL,NULL,NULL,NULL,2,2,53,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avActionAfterBalanceDepleted','avActionAfterBalanceDepleted','','',19,1,3,'','','','notChangeAccountValidity=0;changeAccountValidity=1','notChangeAccountValidity=0;changeAccountValidity=1',NULL,NULL,2,2,53,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avActionAfterRecharge','avActionAfterRecharge','','',19,1,3,'','','','accumulateValidity=0;replaceValidity=1','accumulateValidity=0;replaceValidity=1',NULL,NULL,2,2,53,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avActionAfterDaysKeepingAnExpiredAccount','avActionAfterDaysKeepingAnExpiredAccount','','',19,1,3,'','','','notClearBalance=0;clearBalance=1','notClearBalance=0;clearBalance=1',NULL,NULL,2,2,53,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avDaysKeepingAnExpiredAccount','avDaysKeepingAnExpiredAccount','','',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,53,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avActionWhenAccountExpires','avActionWhenAccountExpires','Key Parameter;','Key Parameter;',19,1,3,'','','','notClearBalance=0;clearBalance=1','notClearBalance=0;clearBalance=1',NULL,NULL,2,2,53,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avMaxAccountValidityDays','avMaxAccountValidityDays','Key Parameter;','Key Parameter;',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,53,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avTitle','avTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','16',NULL,NULL,NULL,NULL,2,2,53,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avIndex','avIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','0',NULL,NULL,NULL,NULL,2,2,53,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('avCOSIndex','avCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,53,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('serviceControlTable','serviceControlTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,52,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('serviceControlEntry','serviceControlEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','scIndex;scCOSIndex','scIndex;scCOSIndex',NULL,NULL,2,2,52,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scRowStatus','scRowStatus','','',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,52,1,23,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scfCallMeBackThreshold','scfCallMeBackThreshold','','',19,2,3,'','0','255',NULL,NULL,NULL,NULL,2,2,52,1,22,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scFreeSmsRentType','scFreeSmsRentType','','',19,2,3,'','0','8',NULL,NULL,NULL,NULL,2,2,52,1,21,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scFreeSmsActiveDays','scFreeSmsActiveDays','','',19,2,3,'','1','255',NULL,NULL,NULL,NULL,2,2,52,1,20,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scFreeSmsRelatedCOS','scFreeSmsRelatedCOS','','',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,52,1,19,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scPoolAccountFreeChangeTimes','scPoolAccountFreeChangeTimes','','',19,2,3,'','0','127',NULL,NULL,NULL,NULL,2,2,52,1,18,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scPoolAccountChangeChargeFlag','scPoolAccountChangeChargeFlag','','',19,1,3,'','','','notCharge=0;charge=1','notCharge=0;charge=1',NULL,NULL,2,2,52,1,17,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scPoolAccountFlag','scPoolAccountFlag','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,52,1,16,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scCreditVaultAmount','scCreditVaultAmount','','',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,52,1,15,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scCreditVault','scCreditVault','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,52,1,14,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scRechargeViaCreditCard','scRechargeViaCreditCard','','',19,1,3,'','','','support=0;unsupport=1','support=0;unsupport=1',NULL,NULL,2,2,52,1,13,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scCloseUserGroupService','scCloseUserGroupService','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,52,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scFriendFamilyFreeChangeTimes','scFriendFamilyFreeChangeTimes','','',19,2,3,'','0','127',NULL,NULL,NULL,NULL,2,2,52,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scFriendFamilyChangeChargeFlag','scFriendFamilyChangeChargeFlag','','',19,1,3,'','','','notCharge=0;charge=1','notCharge=0;charge=1',NULL,NULL,2,2,52,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scFriendFamilyFlag','scFriendFamilyFlag','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,2,52,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scMTBalanceThreshold','scMTBalanceThreshold','Key Parameter;','Key Parameter;',19,2,3,'','-1000000','1000000',NULL,NULL,NULL,NULL,2,2,52,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scMTBalanceControl','scMTBalanceControl','Key Parameter;','Key Parameter;',19,1,3,'','','','noLimitation=0;thresholdUsed=1','noLimitation=0;thresholdUsed=1',NULL,NULL,2,2,52,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scMTChargeFlag','scMTChargeFlag','Key Parameter;','Key Parameter;',19,1,3,'','','','notCharge=0;charge=1','notCharge=0;charge=1',NULL,NULL,2,2,52,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scMOMinimumBalance','scMOMinimumBalance','Key Parameter;','Key Parameter;',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,2,52,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scMOThresholdSet','scMOThresholdSet','Key Parameter;','Key Parameter;',19,1,3,'','','','notSet=0;set=1','notSet=0;set=1',NULL,NULL,2,2,52,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scTitle','scTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,2,52,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scIndex','scIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','0',NULL,NULL,NULL,NULL,2,2,52,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('scCOSIndex','scCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,52,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffTable','tariffTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,51,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffEntry','tariffEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','tariffIndex;tariffCOSIndex','tariffIndex;tariffCOSIndex',NULL,NULL,2,2,51,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffRowStatus','tariffRowStatus','','',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,51,1,19,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionTransferPriority','tariffPromotionTransferPriority','','',19,1,3,'','','','inferiorToBalance=0;superiorToBalance=1','inferiorToBalance=0;superiorToBalance=1',NULL,NULL,2,2,51,1,18,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionTransfer','tariffPromotionTransfer','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,17,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionGprs','tariffPromotionGprs','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,16,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionLocalMoSMS','tariffPromotionLocalMoSMS','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,15,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionNddMoSMS','tariffPromotionNddMoSMS','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,14,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionIddMoSMS','tariffPromotionIddMoSMS','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,13,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionLocalMoCall','tariffPromotionLocalMoCall','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionNddMoCall','tariffPromotionNddMoCall','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffPromotionIddMoCall','tariffPromotionIddMoCall','','',19,1,3,'','','','notAllowed=0;allowed=1','notAllowed=0;allowed=1',NULL,NULL,2,2,51,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffCAPPlanResetDay','tariffCAPPlanResetDay','','',19,2,3,'','1','28',NULL,NULL,NULL,NULL,2,2,51,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffRechargePromotionEndDate','tariffRechargePromotionEndDate','','',19,2,2,'','8','8',NULL,NULL,NULL,NULL,2,2,51,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffRechargePromotionStartDate','tariffRechargePromotionStartDate','','',19,2,2,'','8','8',NULL,NULL,NULL,NULL,2,2,51,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffChargeBy','tariffChargeBy','','',19,1,3,'','','','tariffSetInSubscriberProfile=0;parameterBasicTariffZone=1','tariffSetInSubscriberProfile=0;parameterBasicTariffZone=1',NULL,NULL,2,2,51,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffMTTariffID','tariffMTTariffID','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,51,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffMOTariffID','tariffMOTariffID','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,51,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffTitle','tariffTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,2,51,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffIndex','tariffIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','0',NULL,NULL,NULL,NULL,2,2,51,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tariffCOSIndex','tariffCOSIndex','','',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,51,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cOSTable','cOSTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,50,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cOSEntry','cOSEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','cosIndex','cosIndex',NULL,NULL,2,2,50,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosRowStatus','cosRowStatus','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,50,1,12,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosGprsControlEntries','cosGprsControlEntries','','',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,2,50,1,11,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosPoolAccountEntries','cosPoolAccountEntries','','',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,2,50,1,10,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosCAPPlanEntries','cosCAPPlanEntries','','',18,3,3,'','2','2',NULL,NULL,NULL,NULL,2,2,50,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosRechargePromotionEntries','cosRechargePromotionEntries','','',18,3,3,'','4','4',NULL,NULL,NULL,NULL,2,2,50,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosRechargeCardValidityEntries','cosRechargeCardValidityEntries','','',18,3,3,'','4','4',NULL,NULL,NULL,NULL,2,2,50,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosSMSNotificationInquiryEntries','cosSMSNotificationInquiryEntries','Key Parameter;','Key Parameter;',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,2,50,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosAccountValidityEntries','cosAccountValidityEntries','Key Parameter;','Key Parameter;',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,2,50,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosServiceControlEntries','cosServiceControlEntries','Key Parameter;','Key Parameter;',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,2,50,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosTariffEntries','cosTariffEntries','Key Parameter;','Key Parameter;',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,2,50,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosTitle','cosTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,NULL,NULL,2,2,50,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cosIndex','cosIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,2,50,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('serviceControl','serviceControl','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,1,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('radiusSGSNTable','radiusSGSNTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,32,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('radiusSGSNEntry','radiusSGSNEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','rsIndex','rsIndex',NULL,NULL,2,1,32,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rsRowStatus','rsRowStatus','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,1,32,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rsTariffID','rsTariffID','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,'Tariff ID.','Tariff ID.',2,1,32,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rsSgsnIP','rsSgsnIP','Key Parameter;Name:SGSN IP;','Key Parameter;Name:SGSN IP;',19,2,5,'','','',NULL,NULL,'SGSN IP.','SGSN IP.',2,1,32,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rsTitle','rsTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,NULL,NULL,2,1,32,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rsIndex','rsIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,1,32,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('radiusGGSNTable','radiusGGSNTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,31,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('radiusGGSNEntry','radiusGGSNEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','rgIndex','rgIndex',NULL,NULL,2,1,31,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rgRowStatus','rgRowStatus','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,1,31,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rgNASPassword','rgNASPassword','Key Parameter;','Key Parameter;',19,2,2,'','0','128',NULL,NULL,'NAS Password.','NAS Password.',2,1,31,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rgNASKey','rgNASKey','Key Parameter;','Key Parameter;',19,2,2,'','0','128',NULL,NULL,'NAS Key.','NAS Key.',2,1,31,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rgNasIP','rgNasIP','Key Parameter;Name:NAS IP;','Key Parameter;Name:NAS IP;',19,2,5,'','','',NULL,NULL,'NAS IP.','NAS IP.',2,1,31,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rgTitle','rgTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,'Title.','Title.',2,1,31,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('rgIndex','rgIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,1,31,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('basicTariffZoneTable','basicTariffZoneTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,25,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('basicTariffZoneEntry','basicTariffZoneEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','btzIndex','btzIndex',NULL,NULL,2,1,25,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzRowStatus','btzRowStatus','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,1,25,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzMTTariffID','btzMTTariffID','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,1,25,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzMOTariffID','btzMOTariffID','Key Parameter;','Key Parameter;',19,2,3,'','0','63',NULL,NULL,NULL,NULL,2,1,25,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzCellID','btzCellID','Key Parameter;','Key Parameter;',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,1,25,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzLAC','btzLAC','Key Parameter;','Key Parameter;',19,2,3,'','0','65535',NULL,NULL,NULL,NULL,2,1,25,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzMNC','btzMNC','Key Parameter;','Key Parameter;',19,2,2,'','2','3',NULL,NULL,NULL,NULL,2,1,25,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzMCC','btzMCC','Key Parameter;','Key Parameter;',19,2,2,'','3','3',NULL,NULL,NULL,NULL,2,1,25,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzTitle','btzTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,NULL,NULL,2,1,25,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('btzIndex','btzIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','63',NULL,NULL,NULL,NULL,2,1,25,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('thirdPartyInfoTable','thirdPartyInfoTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,24,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('thirdPartyInfoEntry','thirdPartyInfoEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','tpiIndex','tpiIndex',NULL,NULL,2,1,24,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tpiRowStatus','tpiRowStatus','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,1,24,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tpiServicePassword','tpiServicePassword','Key Parameter;','Key Parameter;',19,2,2,'','0','8',NULL,NULL,NULL,NULL,2,1,24,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tpiServiceID','tpiServiceID','Key Parameter;','Key Parameter;',19,2,2,'','0','8',NULL,NULL,NULL,NULL,2,1,24,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tpiTitle','tpiTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,NULL,NULL,2,1,24,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('tpiIndex','tpiIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','7',NULL,NULL,NULL,NULL,2,1,24,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('sMSSentenceTable','sMSSentenceTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,22,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('sMSSentenceEntry','sMSSentenceEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','ssIndex','ssIndex',NULL,NULL,2,1,22,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssRowStatus','ssRowStatus','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,1,22,1,9,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssLanguage4Content','ssLanguage4Content','','',21,0,2,'','0','127',NULL,NULL,NULL,NULL,2,1,22,1,8,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssLanguage3Content','ssLanguage3Content','','',21,0,2,'','0','127',NULL,NULL,NULL,NULL,2,1,22,1,7,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssLanguage2Content','ssLanguage2Content','','',21,0,2,'','0','127',NULL,NULL,NULL,NULL,2,1,22,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssLanguage1Content','ssLanguage1Content','','',21,0,2,'','0','127',NULL,NULL,NULL,NULL,2,1,22,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssLanguage0Content','ssLanguage0Content','','',19,2,2,'','0','127',NULL,NULL,NULL,NULL,2,1,22,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssEnglish','ssEnglish','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,1,22,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssTitle','ssTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,NULL,NULL,2,1,22,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('ssIndex','ssIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','4',NULL,NULL,NULL,NULL,2,1,22,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mNPPrefixesTable','mNPPrefixesTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,21,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mNPPrefixesEntry','mNPPrefixesEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','mnpIndex','mnpIndex',NULL,NULL,2,1,21,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnpRowStatus','mnpRowStatus','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,1,21,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnpPrefix','mnpPrefix','Key Parameter;','Key Parameter;',19,2,2,'','0','16',NULL,NULL,NULL,NULL,2,1,21,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnpTitle','mnpTitle','Key Parameter;','Key Parameter;',19,2,2,'','0','64',NULL,NULL,NULL,NULL,2,1,21,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mnpIndex','mnpIndex','Key Parameter;','Key Parameter;',48,2,3,'','0','31',NULL,NULL,NULL,NULL,2,1,21,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('promptResolutionTable','promptResolutionTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,20,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('promptResolutionEntry','promptResolutionEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','prIndex','prIndex',NULL,NULL,2,1,20,1,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prRowStatus','prRowStatus','','',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,1,20,1,6,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prCurrencySymbolPosition','prCurrencySymbolPosition','Key Parameter;','Key Parameter;',19,1,3,'','','','front=0;rear=1','front=0;rear=1',NULL,NULL,2,1,20,1,5,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prDateFormat','prDateFormat','Key Parameter;','Key Parameter;',19,1,3,'','','','yyyymmdd=0;ddmmyyyy=1;mmddyyyy=2','yyyymmdd=0;ddmmyyyy=1;mmddyyyy=2',NULL,NULL,2,1,20,1,4,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prCurrencyResolution','prCurrencyResolution','Key Parameter;','Key Parameter;',19,1,3,'','','','n1=0;n10=1;n100=2','n1=0;n10=1;n100=2',NULL,NULL,2,1,20,1,3,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prTitle','prTitle','Key Parameter;','Key Parameter;',18,3,2,'','0','64',NULL,NULL,NULL,NULL,2,1,20,1,2,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('prIndex','prIndex','Key Parameter;','Key Parameter;',18,3,3,'','0','0',NULL,NULL,NULL,NULL,2,1,20,1,1,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('language4SMEncodeType','language4SMEncodeType','','',19,1,3,'','','','bits7=0;bits8=1;unicode=2','bits7=0;bits8=1;unicode=2',NULL,NULL,2,1,13,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('language3SMEncodeType','language3SMEncodeType','','',19,1,3,'','','','bits7=0;bits8=1;unicode=2','bits7=0;bits8=1;unicode=2',NULL,NULL,2,1,12,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('language2SMEncodeType','language2SMEncodeType','','',19,1,3,'','','','bits7=0;bits8=1;unicode=2','bits7=0;bits8=1;unicode=2',NULL,NULL,2,1,11,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('language1SMEncodeType','language1SMEncodeType','','',19,1,3,'','','','bits7=0;bits8=1;unicode=2','bits7=0;bits8=1;unicode=2',NULL,NULL,2,1,10,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('language0SMEncodeType','language0SMEncodeType','','',19,1,3,'','','','bits7=0;bits8=1;unicode=2','bits7=0;bits8=1;unicode=2',NULL,NULL,2,1,9,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('oprAccountValidity','oprAccountValidity','','',19,2,3,'','0','127',NULL,NULL,'OPR initial validity days.','OPR initial validity days.',2,1,8,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('mNPChargeFlag','mNPChargeFlag','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,1,7,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cOSOption','cOSOption','','',19,1,3,'','','','group64=0;group4=1','group64=0;group4=1',NULL,NULL,2,1,6,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('currencySymbol','currencySymbol','','',19,2,2,'','0','8',NULL,NULL,NULL,NULL,2,1,5,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('maxBalance','maxBalance','','',19,2,3,'','0','1000000',NULL,NULL,NULL,NULL,2,1,4,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('blackListThreshold','blackListThreshold','','',19,2,3,'','0','255',NULL,NULL,NULL,NULL,2,1,3,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('cDRFlag','cDRFlag','','',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1',NULL,NULL,2,1,2,0,0,0,0,0,0,0);
|
|
INSERT INTO `paramConf` VALUES ('license','license','','',18,3,3,'','','',NULL,NULL,NULL,NULL,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,5,2,0,0,0,0,0,0,0,'0000','03000009000009','03000009000009');
|
|
INSERT INTO `param_99` VALUES (2,1,1,0,0,0,0,0,0,0,'0000','0.0.0.0','0.0.0.0');
|
|
INSERT INTO `param_99` VALUES (2,1,2,0,0,0,0,0,0,0,'0000','0.0.0.0','0.0.0.0');
|
|
INSERT INTO `param_99` VALUES (2,1,3,0,0,0,0,0,0,0,'0000','0.0.0.0','0.0.0.0');
|
|
INSERT INTO `param_99` VALUES (2,1,7,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,1,6,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,2,0,0,0,0,0,'0003','500','500');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,3,0,0,0,0,0,'0003','1','1');
|
|
INSERT INTO `param_99` VALUES (2,1,5,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,1,0,0,0,0,0,'0003','3','3');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,3,0,0,0,0,0,'0002','1','1');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,2,0,0,0,0,0,'0002','200','200');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,1,0,0,0,0,0,'0002','2','2');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,3,0,0,0,0,0,'0001','1','1');
|
|
INSERT INTO `param_99` VALUES (2,1,4,0,0,0,0,0,0,0,'0000','0.0.0.0','0.0.0.0');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,2,0,0,0,0,0,'0001','100','100');
|
|
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,3,0,0,0,0,0,'0000','1','1');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,2,0,0,0,0,0,'0000','50','50');
|
|
INSERT INTO `param_99` VALUES (2,2,1,1,1,0,0,0,0,0,'0000','0','0');
|
|
INSERT INTO `param_99` VALUES (2,1,8,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,1,9,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,1,10,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,1,11,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,1,12,0,0,0,0,0,0,0,'0000','','');
|
|
INSERT INTO `param_99` VALUES (2,1,13,0,0,0,0,0,0,0,'0000','','');
|
|
/*!40000 ALTER TABLE `param_99` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `subsParamConf_1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `subsParamConf_1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `subsParamConf_1` (
|
|
`keyId` tinyint(4) NOT NULL AUTO_INCREMENT,
|
|
`fieldName` varchar(50) NOT NULL,
|
|
`name_1` varchar(30) NOT NULL,
|
|
`name_2` varchar(30) NOT NULL,
|
|
`desc_1` varchar(255) NOT NULL,
|
|
`desc_2` varchar(255) NOT NULL,
|
|
`paramType` tinyint(1) NOT NULL DEFAULT 0,
|
|
`operType` tinyint(1) NOT NULL DEFAULT 0,
|
|
`number` int(6) NOT NULL DEFAULT 0,
|
|
`length` smallint(3) NOT NULL DEFAULT 0,
|
|
`valueType` tinyint(1) NOT NULL DEFAULT 0,
|
|
`initValue` varchar(255) NOT NULL,
|
|
`minValue` varchar(255) NOT NULL,
|
|
`maxValue` varchar(255) NOT NULL,
|
|
`setTemplate_1` text NOT NULL,
|
|
`setTemplate_2` text NOT NULL,
|
|
`needNote` tinyint(1) NOT NULL DEFAULT 0,
|
|
`note_1` varchar(200) NOT NULL,
|
|
`note_2` varchar(200) NOT 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,
|
|
PRIMARY KEY (`keyId`),
|
|
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 AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `subsParamConf_1`
|
|
--
|
|
|
|
LOCK TABLES `subsParamConf_1` WRITE;
|
|
/*!40000 ALTER TABLE `subsParamConf_1` DISABLE KEYS */;
|
|
INSERT INTO `subsParamConf_1` VALUES (1,'card_no','card serial number','Card serial number','card serial number','Card serial number',0,1,1,16,3,'000000000000','000000000000','999999999999','','¹§Ï²·¢²Æ',0,'','',1,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `subsParamConf_1` VALUES (2,'card_hrn','pwd','Password','pwd','Password',0,1,1,8,4,'0000000000000000','0000000000000000','FFFFFFFFFFFFFFFF','','',0,'','',2,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `subsParamConf_1` VALUES (3,'face_value','face value','Face value','face value','Face value',0,1,1,5,2,'00000000','000000000000','0000000000','','',0,'','',3,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `subsParamConf_1` VALUES (4,'card_status','card status','Card status','card status','Card status',0,3,1,1,4,'00','00','02','','Card status\r\n[unit]card status[u]00.0-00.7[u]select\r\n[v]0[opt]Not used\r\n[v]1[opt]Used\r\n[v]2[opt]Suspended',0,'','',4,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `subsParamConf_1` VALUES (5,'expiry_date','expiry date','Expiry date','expiry date','Expiry date',0,1,1,7,4,'00000000000000','00000000000000','99999999999999','','',0,'','',5,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `subsParamConf_1` VALUES (6,'valid_time','valid days','Valid days','valid days','Valid days',0,1,1,2,2,'0060','0000','9999','','',0,'','',6,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `subsParamConf_1` VALUES (7,'msisdn_used','msisdn charged','Charged MSISDN',' charged msisdn','Charged MSISDN',0,3,1,18,3,'000000000000000000000','000000000000000000000000','999999999999','','',0,'','',7,0,0,0,0,0,0,0,0,0);
|
|
INSERT INTO `subsParamConf_1` VALUES (8,'updated_date','charged date','Charge date','charged date','Charge date',0,3,1,7,4,'00000000000000','00000000000000','99999999999999','','',0,'','',8,0,0,0,0,0,0,0,0,0);
|
|
/*!40000 ALTER TABLE `subsParamConf_1` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `tmpSubsData_1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `tmpSubsData_1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `tmpSubsData_1` (
|
|
`editFlag` tinyint(4) NOT NULL,
|
|
`card_no` char(20) NOT NULL DEFAULT '0',
|
|
`card_hrn` char(20) NOT NULL,
|
|
`face_value` int(10) unsigned DEFAULT NULL,
|
|
`card_status` tinyint(2) DEFAULT NULL,
|
|
`expiry_date` bigint(20) DEFAULT NULL,
|
|
`valid_time` int(10) unsigned NOT NULL DEFAULT 0,
|
|
`msisdn_used` char(20) DEFAULT '--',
|
|
`updated_date` char(14) NOT NULL DEFAULT '0000000000000',
|
|
PRIMARY KEY (`card_no`),
|
|
UNIQUE KEY `card_no` (`card_no`),
|
|
UNIQUE KEY `card_hrn` (`card_hrn`),
|
|
KEY `card_status` (`card_status`),
|
|
KEY `updated_date` (`updated_date`),
|
|
KEY `editFlag` (`editFlag`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `tmpSubsData_1`
|
|
--
|
|
|
|
LOCK TABLES `tmpSubsData_1` WRITE;
|
|
/*!40000 ALTER TABLE `tmpSubsData_1` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `tmpSubsData_1` 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
|