/*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_375
-- ------------------------------------------------------
-- 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_375`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `OBJ_375` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;
USE `OBJ_375`;
--
-- 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 ('iMDX','iMDX','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,3,0,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('privateDialingPrefixTable','privateDialingPrefixTable','','',21,0,0,'','','',NULL,NULL,'MT is a private user if any prefix of MT MSISDN is exist in this table.','MT is a private user if any prefix of MT MSISDN is exist in this table.',2,3,20,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('privateDialingPrefixEntry','privateDialingPrefixEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','pdpIndex','pdpIndex',NULL,NULL,2,3,20,1,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pdpRowStatus','pdpRowStatus','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,20,1,5,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pdpPrivateDialingPrefix','pdpPrivateDialingPrefix','Key Parameter;Name:Prefix;','Key Parameter;Name:Prefix;',19,2,2,'','0','16',NULL,NULL,'Specify dialing prefix of the incoming private call. Originating call with this prefix will be treated as private call.','Specify dialing prefix of the incoming private call. Originating call with this prefix will be treated as private call.',2,3,20,1,4,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pdpAttribution','pdpAttribution','Key Parameter;Name:Attribution;','Key Parameter;Name:Attribution;',19,2,2,'','0','2',NULL,NULL,'Specify number plan of the the incoming private calls.
- 80 = Unknown
- 81 = National number
- 91 = International number','Specify number plan of the the incoming private calls.
- 80 = Unknown
- 81 = National number
- 91 = International number',2,3,20,1,3,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pdpTitle','pdpTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','15',NULL,NULL,'Private dialing prefix name for identification purpose only.','Private dialing prefix name for identification purpose only.',2,3,20,1,2,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pdpIndex','pdpIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','1','16',NULL,NULL,'Private dialing prefix index number ranges from 1 to 16.','Private dialing prefix index number ranges from 1 to 16.',2,3,20,1,1,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('exclusiveRejectionCause','exclusiveRejectionCause','Name:Exclusive Rejection Cause;','Name:Exclusive Rejection Cause;',19,1,3,'','','','c11=0;c12=1;c13=2','c11=0;c12=1;c13=2','In the exclusive access mode, the network sends a Location Area Updating Reject message to MS to indicate the cause of rejection:
- C11 = PLMN not allowed
- C12 = LA not allowed
- C13 = Roaming not allowed in this LA','In the exclusive access mode, the network sends a Location Area Updating Reject message to MS to indicate the cause of rejection:
- C11 = PLMN not allowed
- C12 = LA not allowed
- C13 = Roaming not allowed in this LA',2,3,2,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('exclusiveLevel','exclusiveLevel','Name:Exclusive Level;','Name:Exclusive Level;',19,1,3,'','','','normal=0;exclusiveHalf=1;exclusiveFull=2;shutdown=3','normal=0;exclusiveHalf=1;exclusiveFull=2;shutdown=3','Exclusive access provides solutions to restrict the IMDX registration from a predefined range of users:
- Normal = Full IMDX functions.
- Exclusive Half = Prohibit the public (roaming) users from registration.
- Exclusive Full = Prohibit both public (roaming) and hybrid users from registration.
- Shutdown = Shutdown IMDX. Forbid all users from registration.','Exclusive access provides solutions to restrict the IMDX registration from a predefined range of users:
- Normal = Full IMDX functions.
- Exclusive Half = Prohibit the public (roaming) users from registration.
- Exclusive Full = Prohibit both public (roaming) and hybrid users from registration.
- Shutdown = Shutdown IMDX. Forbid all users from registration.',2,3,1,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('oPR','oPR','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,2,0,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pLMNListTable','pLMNListTable','','',21,0,0,'','','',NULL,NULL,'This table is controled by plmnListOption.The MccMnc is not allowed to register OPR service When plmnListOption is allow and MccMnc is not exist in the table;he MccMnc is not allowed to register OPR service When plmnListOption is bar and MccMnc is exist in the table;The MccMnc is allowed to register OPR service When plmnListOption is allow and MccMnc is exist in the table;The MccMnc is allowed to register OPR service When plmnListOption is bar and MccMnc is not exist in the table;','This table is controled by plmnListOption.The MccMnc is not allowed to register OPR service When plmnListOption is allow and MccMnc is not exist in the table;he MccMnc is not allowed to register OPR service When plmnListOption is bar and MccMnc is exist in the table;The MccMnc is allowed to register OPR service When plmnListOption is allow and MccMnc is exist in the table;The MccMnc is allowed to register OPR service When plmnListOption is bar and MccMnc is not exist in the table;',2,2,20,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pLMNListEntry','pLMNListEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','plIndex','plIndex',NULL,NULL,2,2,20,1,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('plRowStatus','plRowStatus','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,20,1,4,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('plMCCAndMNC','plMCCAndMNC','Key Parameter;Name:MCC & MNC;','Key Parameter;Name:MCC & MNC;',19,2,2,'','5','5',NULL,NULL,'Mobile Country Code and Mobile Network Code of this PLMN.','Mobile Country Code and Mobile Network Code of this PLMN.',2,2,20,1,3,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('plTitle','plTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','15',NULL,NULL,'PLMN name for identification purpose only.','PLMN name for identification purpose only.',2,2,20,1,2,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('plIndex','plIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','1','32',NULL,NULL,'PLMN index number ranges from 1 to 32.','PLMN index number ranges from 1 to 32.',2,2,20,1,1,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('pLMNListOption','pLMNListOption','Name:PLMN List Option;','Name:PLMN List Option;',19,1,3,'','','','allow=0;bar=1','allow=0;bar=1','Allow or reject the mobile subscribers from the specific PLMNs to register to the local network.
- Allow = The following PLMN list is a white-list.
- Bar = The following PLMN list is a black-list.','Allow or reject the mobile subscribers from the specific PLMNs to register to the local network.
- Allow = The following PLMN list is a white-list.
- Bar = The following PLMN list is a black-list.',2,2,5,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('welcomeSMS','welcomeSMS','Name:Welcome SMS;','Name:Welcome SMS;',19,2,2,'\"\"','0','120',NULL,NULL,'Customize the text format in a welcome short message. It is sent to the user when he successfully registered to the OPR service and informs him his local phone number and PIN.','Customize the text format in a welcome short message. It is sent to the user when he successfully registered to the OPR service and informs him his local phone number and PIN.',2,2,4,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('autoCleanupThreshold','autoCleanupThreshold','Name:Auto-Cleanup Threshold;','Name:Auto-Cleanup Threshold;',19,2,2,'','4','4',NULL,NULL,'The OPPS will send a warning alarm and clean up database by deleting the trial accounts when the OPR license utilization level reaches this threshold.
- Range = 0.50 - 0.99','The OPPS will send a warning alarm and clean up database by deleting the trial accounts when the OPR license utilization level reaches this threshold.
- Range = 0.50 - 0.99',2,2,3,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('autoRegisterOption','autoRegisterOption','Name:Auto-Registration Option;','Name:Auto-Registration Option;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','Enable or disable auto-registration function to the OPR subscribers from the PLMN without roaming agreement.','Enable or disable auto-registration function to the OPR subscribers from the PLMN without roaming agreement.',2,2,2,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('cosID','cosID','Name:COS ID;','Name:COS ID;',19,2,3,'','0','63',NULL,NULL,'Specify index of a Class of Service (COS) to the OPR applications for charging purpose.','Specify index of a Class of Service (COS) to the OPR applications for charging purpose.',2,2,1,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('sysControl','sysControl','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,1,0,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 IMEIs[u]01.0-03.7[u]input\n [v]toDec-high-0\n [unit]Imported IMEIs[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 IMEIs[u]01.0-03.7[u]input\n [v]toDec-high-0\n [unit]Imported IMEIs[u]04.0-06.7[u]input\n [v]toDec-high-0',NULL,NULL,2,1,7,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('command','command','','',19,1,3,'','','','saveUserData=1','saveUserData=1',NULL,NULL,2,1,6,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('replaceOption','replaceOption','Name:Replace Option;','Name:Replace Option;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','Enable or disable overwrite the existing OPPS subscriber data when create an OPPS subscriber with the same MSISDN.','Enable or disable overwrite the existing OPPS subscriber data when create an OPPS subscriber with the same MSISDN.',2,1,5,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('cDROption','cDROption','Name:CDR Flag;','Name:CDR Flag;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','Enable or disable OPR CDR generation.','Enable or disable OPR CDR generation.',2,1,4,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('iMDXStatus','iMDXStatus','Name:IMDX Status;','Name:IMDX Status;',18,3,3,'','','','disable=0;enable=1','disable=0;enable=1','(Read Only) The administration state of IMDX service which determined by License Control.','(Read Only) The administration state of IMDX service which determined by License Control.',2,1,3,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('oPRStatus','oPRStatus','Name:OPR Status;','Name:OPR Status;',18,3,3,'','','','disable=0;enable=1','disable=0;enable=1','(Read Only) The administration state of OPR service which determined by License Control.','(Read Only) The administration state of OPR service which determined by License Control.',2,1,2,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('license','license','Name:License;','Name:License;',18,3,2,'\"\"','4','4',NULL,NULL,'(Read Only) The maximum subscriber capacity of OPPS determined by License Control.','(Read Only) The maximum subscriber capacity of OPPS determined by License Control.',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 */;
/*!40000 ALTER TABLE `param_99` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `subsParamConf_0`
--
DROP TABLE IF EXISTS `subsParamConf_0`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `subsParamConf_0` (
`keyId` tinyint(4) NOT NULL AUTO_INCREMENT,
`fieldName` varchar(50)/*old*/ NOT NULL DEFAULT '',
`name_1` varchar(30)/*old*/ NOT NULL DEFAULT '',
`name_2` varchar(30)/*old*/ NOT NULL DEFAULT '',
`desc_1` varchar(255)/*old*/ NOT NULL DEFAULT '',
`desc_2` varchar(255)/*old*/ NOT NULL DEFAULT '',
`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)/*old*/ NOT NULL DEFAULT '',
`minValue` varchar(255)/*old*/ NOT NULL DEFAULT '',
`maxValue` varchar(255)/*old*/ NOT NULL DEFAULT '',
`setTemplate_1` text NOT NULL DEFAULT '',
`setTemplate_2` text NOT NULL DEFAULT '',
`needNote` tinyint(1) NOT NULL DEFAULT 0,
`note_1` varchar(255)/*old*/ NOT NULL DEFAULT '',
`note_2` varchar(255)/*old*/ NOT NULL DEFAULT '',
`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=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `subsParamConf_0`
--
LOCK TABLES `subsParamConf_0` WRITE;
/*!40000 ALTER TABLE `subsParamConf_0` DISABLE KEYS */;
INSERT INTO `subsParamConf_0` VALUES (1,'msisdn','msisdn','MSISDN','msisdn','MSISDN',0,1,1,16,3,'0000000000000000','0000000000000000','9999999999999999','','MSISDN
\r\n[unit]MSISDN[u]00.0-17.7[u]input\r\n[v]keepHex-low-F\r\n[remark]\r\nThe local phone number of OPPS subscriber.\r\n\r\nThe MSISDN of OPR subscriber consists of three parts: \r\n\r\n- CC = country code \r\n\r\n- NDC = national destination code\r\n\r\n- SN = subscriber number \r\n\r\n',0,'','',1,0,0,0,0,0,0,0,0,0);
INSERT INTO `subsParamConf_0` VALUES (2,'imsi','imsi','IMSI','imsi','IMSI',0,3,1,15,3,'000000000000000','000000000000000','999999999999999','','IMSI
\r\n[unit]IMSI[u]00.0-14.7[u]input\r\n[v]keepHex-low-F\r\n[remark]\r\nAn IMSI consists of 15 digits in the format: MCC+MNC+MSIN, where:\r\n\r\n- MCC = mobile country code (3 digits)\r\n\r\n- MNC = mobile network code (2 digits)\r\n\r\n- MSIN = mobile subscriber identification number\r\n\r\nThis number must be a unique number in the OPPS account database. \r\n\r\nNOTE: When creating or importing not registered OPR subscribers, this field can be left as idle.\r\n',0,'','',2,0,0,0,0,0,0,0,0,0);
INSERT INTO `subsParamConf_0` VALUES (3,'imei','imei','IMEI','imei','IMEI',0,3,1,15,3,'000000000000000','000000000000000','999999999999999','','IMEI
\r\n[unit]IMEI[u]00.0-14.7[u]input\r\n[v]keepHex-low-F\r\n[remark]\r\nThe International Mobile Equipment Identity uniquely identifies a mobile station internationally. It is a kind of serial number allocated by the equipment manufacturer. \r\n\r\nNOTE: This field is reserved for OPR user only. When creating or importing not registered OPR subscribers, this field can be left as idle.\r\n',0,'','',3,0,0,0,0,0,0,0,0,0);
INSERT INTO `subsParamConf_0` VALUES (4,'oprFlag','User Status','User Status','User Status','User Status',0,3,1,1,3,'0','0','5','','User Status\r\n[unit]User Status[u]00.0-00.7[u]select\r\n[v]0[opt]OPR Not Registered\r\n[v]1[opt]OPR without Roaming Agreement\r\n[v]2[opt]OPR with Roaming Agreement\r\n[v]3[opt]OPR in Roaming\r\n[v]4[opt]IMDX Private (Ordinary)\r\n[v]5[opt]IMDX Private (Premium)\r\n[v]6[opt]IMDX Hybrid\r\n[remark]\r\nThis field indicates the type of the OPPS subscriber.\r\n\r\n- OPR not Registered = Initial status of a new created or imported OPR account. The associated MSISDN will be allocated to an auto-registered subscriber.\r\n\r\n- OPR with Roaming Agreement = OPR subscriber is from PLMN with roaming agreement.\r\n\r\n- OPR without Roaming Agreement = OPR subscriber is from PLMN without roaming agreement.\r\n\r\n- OPR in Roaming = OPR subscriber is from PLMN with roaming agreement. But its current application status is switched to roaming mode.\r\n\r\n- IMDX Hybrid = IMDX hybrid subscriber.\r\n\r\n- IMDX Private = IMDX private subscriber.\r\n',0,'','',4,0,0,0,0,0,0,0,0,0);
INSERT INTO `subsParamConf_0` VALUES (5,'class','Class','Class','Class','Class',0,3,1,1,3,'0','0','2','','Class\r\n[unit]Class[u]00.0-00.7[u]select\r\n[v]0[opt]Ordinary\r\n[v]1[opt]Premium\r\n[v]2[opt]VIP\r\n[remark]\r\nThis field indicates the class of the OPPS subscriber.',0,'','',5,0,0,0,0,0,0,0,0,0);
INSERT INTO `subsParamConf_0` VALUES (6,'userType','User Type','User Type','User Type','User Type',0,3,1,1,3,'0','0','2','','User Type\r\n[unit]User Type[u]00.0-00.7[u]select\r\n[v]0[opt]OPPS\r\n[v]1[opt]Reserved\r\n[v]2[opt]iPALIM\r\n[remark]\r\nThis field indicates the user type of the OPPS subscriber.',0,'','',6,0,0,0,0,0,0,0,0,0);
/*!40000 ALTER TABLE `subsParamConf_0` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tmpSubsData_0`
--
DROP TABLE IF EXISTS `tmpSubsData_0`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tmpSubsData_0` (
`editFlag` tinyint(4) NOT NULL,
`msisdn` char(18) NOT NULL,
`imsi` char(15) NOT NULL,
`imei` char(15) NOT NULL,
`oprFlag` tinyint(3) unsigned NOT NULL DEFAULT 0,
`class` tinyint(3) unsigned NOT NULL DEFAULT 0,
`userType` tinyint(3) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`msisdn`),
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_0`
--
LOCK TABLES `tmpSubsData_0` WRITE;
/*!40000 ALTER TABLE `tmpSubsData_0` DISABLE KEYS */;
INSERT INTO `tmpSubsData_0` VALUES (0,'6767600010','123242353453465','454654675765765',4,0,0);
INSERT INTO `tmpSubsData_0` VALUES (0,'','','',0,0,0);
INSERT INTO `tmpSubsData_0` VALUES (0,'3424325435436546','000000000000000','000000000000000',0,0,0);
INSERT INTO `tmpSubsData_0` VALUES (0,'0000000000000000','000000000000000','000000000000000',0,0,0);
/*!40000 ALTER TABLE `tmpSubsData_0` 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