/*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_379 -- ------------------------------------------------------ -- 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_379` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `OBJ_379` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */; USE `OBJ_379`; -- -- 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 ('routingZone','routingZone','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,3,0,0,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('routingZoneTable','routingZoneTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,3,1,0,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('routingZoneEntry','routingZoneEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','rzIndex','rzIndex',NULL,NULL,2,3,1,1,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('rzRowStatus','rzRowStatus','','',19,1,3,'','','','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6',NULL,NULL,2,3,1,1,3,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('rzSite','rzSite','Key Parameter;Name:Site;','Key Parameter;Name:Site;',19,1,3,'','','','local=0;remote=1','local=0;remote=1','Determine each Routing Zone which configured in MSC Routing Zone table to Local or Remote. iRLS will not be invocated by the calls within local Routing Zone.','Determine each Routing Zone which configured in MSC Routing Zone table to Local or Remote. iRLS will not be invocated by the calls within local Routing Zone.',2,3,1,1,2,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('rzIndex','rzIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',18,3,3,'','1','31',NULL,NULL,'Routing zone index number ranges from 1 to 31.','Routing zone index number ranges from 1 to 31.',2,3,1,1,1,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vimMg','vimMg','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,2,0,0,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('physicalPortTable','physicalPortTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,2,0,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('physicalPortEntry','physicalPortEntry','Table Parameter, level:2','Table Parameter, level:2',21,0,22050,'','','','ppIndex;ppMGIndex','ppIndex;ppMGIndex',NULL,NULL,2,2,2,1,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('ppPlatID','ppPlatID','Key Parameter;Name:Platform ID;','Key Parameter;Name:Platform ID;',19,2,3,'','0','1',NULL,NULL,'Specify the serving MSC platform, either MSC-0 or MSC-1.','Specify the serving MSC platform, either MSC-0 or MSC-1.',2,2,2,1,6,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('ppStatus','ppStatus','Key Parameter;Name:Status;','Key Parameter;Name:Status;',18,3,3,'','','','notReady=0;ready=1','notReady=0;ready=1','The current availability status of the physical port.','The current availability status of the physical port.',2,2,2,1,5,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('ppUsedFlag','ppUsedFlag','Key Parameter;Name:Used Flag;','Key Parameter;Name:Used Flag;',19,1,3,'','','','idle=0;inUse=1','idle=0;inUse=1','The occupancy status of the physical port.','The occupancy status of the physical port.',2,2,2,1,4,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('ppAdministrationState','ppAdministrationState','Key Parameter;Name:Admin State;','Key Parameter;Name:Admin State;',19,3,3,'','','','locked=0;unlocked=1;shutDown=2','locked=0;unlocked=1;shutDown=2','Control the operation of the managed physical port by lock and unlock commands.','Control the operation of the managed physical port by lock and unlock commands.',2,2,2,1,3,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('ppIndex','ppIndex','Key Parameter;Name:Port ID;','Key Parameter;Name:Port ID;',18,3,3,'','1','32',NULL,NULL,'(Read Only) Physical port index number ranges from 1 to 32.','(Read Only) Physical port index number ranges from 1 to 32.',2,2,2,1,2,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('ppMGIndex','ppMGIndex','Name:MG Index;','Name:MG Index;',18,3,3,'','1','8',NULL,NULL,'(Read Only) Index number of the serving media gateway.','(Read Only) Index number of the serving media gateway.',2,2,2,1,1,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vimMgTable','vimMgTable','Name:VIM MG;','Name:VIM MG;',21,0,0,'','','',NULL,NULL,NULL,NULL,2,2,1,0,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vimMgEntry','vimMgEntry','Table Parameter, level:1 Name:VIM MG','Table Parameter, level:1 Name:VIM MG',21,0,22050,'','','','vmIndex','vmIndex',NULL,NULL,2,2,1,1,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmRowStatus','vmRowStatus','Key Parameter;','Key Parameter;',19,1,3,'','','','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6',NULL,NULL,2,2,1,1,15,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmPhysicalPortEntries','vmPhysicalPortEntries','Key Parameter;Name:Port Entries;','Key Parameter;Name:Port Entries;',18,3,3,'','0','32',NULL,NULL,'The total number of the configured physical ports of this media gateway.','The total number of the configured physical ports of this media gateway.',2,2,1,1,14,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmAuditTimer','vmAuditTimer','Name:Audit Timer;','Name:Audit Timer;',19,2,3,'','0','255',NULL,NULL,'The time interval between sending AUEP message from MGC to MGW to check the trunk status. Unit is second.','The time interval between sending AUEP message from MGC to MGW to check the trunk status. Unit is second.',2,2,1,1,13,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmCodecType','vmCodecType','Name:Codec Type;','Name:Codec Type;',18,3,3,'','','','aLaw=0;uLaw=1;fr=2;efr=3;AMR-12-2=4;g729b=5;AMR-10-2=6;AMR-7-95=7;AMR-7-4=8;AMR-6-7=9;AMR-5-15=10;AMR-5-9=11;AMR-4-75=12;g729=13;null=255','aLaw=0;uLaw=1;fr=2;efr=3;AMR-12-2=4;g729b=5;AMR-10-2=6;AMR-7-95=7;AMR-7-4=8;AMR-6-7=9;AMR-5-15=10;AMR-5-9=11;AMR-4-75=12;g729=13;null=255','(Read Only) Codec type of the media gateway.','(Read Only) Codec type of the media gateway.',2,2,1,1,12,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmPacketizationPeriod','vmPacketizationPeriod','Name:Packetization Period;','Name:Packetization Period;',19,1,3,'x20ms','','','x20ms=20;x40ms=40;x60ms=60;x80ms=80','x20ms=20;x40ms=40;x60ms=60;x80ms=80','The period over which encoded voice bits are collected for encapsulation in.','The period over which encoded voice bits are collected for encapsulation in.',2,2,1,1,11,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmMaxChannels','vmMaxChannels','Name:Max Channels;','Name:Max Channels;',19,2,3,'','0','1024',NULL,NULL,'The total channel number of the virtual media gateway. Applicable to virtual media gateway only.','The total channel number of the virtual media gateway. Applicable to virtual media gateway only.',2,2,1,1,10,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmMaxPhysicalPorts','vmMaxPhysicalPorts','Name:Max Ports;','Name:Max Ports;',19,2,3,'','0','32',NULL,NULL,'The total physical port number of the media gateway.','The total physical port number of the media gateway.',2,2,1,1,9,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmType','vmType','Key Parameter;Name:Type;','Key Parameter;Name:Type;',18,3,3,'digitalChannel','','','audioCodes=1;lgcMG=2;lgcCS=3;ipBSS=4;analogLine=11;vim=19;tandem=20;announcementServer=21;interactiveVoiceResponse=31;conferenceBridge=41;packetRelay=51;wiretap=61;atm=71','audioCodes=1;lgcMG=2;lgcCS=3;ipBSS=4;analogLine=11;vim=19;tandem=20;announcementServer=21;interactiveVoiceResponse=31;conferenceBridge=41;packetRelay=51;wiretap=61;atm=71','(Read Only) Type of media gateway endpoint.','(Read Only) Type of media gateway endpoint.',2,2,1,1,8,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmEndPoint','vmEndPoint','Name:Endpoint;','Name:Endpoint;',19,1,3,'structured','','','structured=1;unStructured=2;unStructuredHex=3','structured=1;unStructured=2;unStructuredHex=3','Method of MGCP endpoint description. Select Unstructured as default.','Method of MGCP endpoint description. Select Unstructured as default.',2,2,1,1,7,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmSwitchingMode','vmSwitchingMode','Key Parameter;Name:Switching Mode;','Key Parameter;Name:Switching Mode;',19,1,3,'mgcp','','','mgcp=0;eightECP=1','mgcp=0;eightECP=1','Switching mode of the media gateway. Select MGCP as default.','Switching mode of the media gateway. Select MGCP as default.',2,2,1,1,6,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmDomainName','vmDomainName','Key Parameter;Name:Domain Name;','Key Parameter;Name:Domain Name;',19,2,2,'','0','32',NULL,NULL,'Domain name of the connected media gateway.','Domain name of the connected media gateway.',2,2,1,1,5,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmIP','vmIP','Key Parameter;Name:IP;','Key Parameter;Name:IP;',19,2,5,'','','',NULL,NULL,'IP address of the connected media gateway.','IP address of the connected media gateway.',2,2,1,1,4,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmAdministrationState','vmAdministrationState','Key Parameter;Name:Admin State;','Key Parameter;Name:Admin State;',19,3,3,'','','','locked=0;unlocked=1;shutDown=2','locked=0;unlocked=1;shutDown=2','Control the operation of the managed media gateway by lock and unlock commands.','Control the operation of the managed media gateway by lock and unlock commands.',2,2,1,1,3,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmTitle','vmTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'','0','32',NULL,NULL,'Media gateway name for identification purpose only.','Media gateway name for identification purpose only.',2,2,1,1,2,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('vmIndex','vmIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','1','10',NULL,NULL,'Media gateway index number ranges from 1 to 10.','Media gateway index number ranges from 1 to 10.',2,2,1,1,1,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('system','system','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,1,0,0,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('saveCommand','saveCommand','','',21,0,3,'','','','saveParameter=1','saveParameter=1',NULL,NULL,2,1,2,0,0,0,0,0,0,0); INSERT INTO `paramConf` VALUES ('rLSFlag','rLSFlag','Name:RLS Flag;','Name:RLS Flag;',19,1,3,'','','','off=0;on=1','off=0;on=1','Enable or disable RTP Local Switching function.','Enable or disable RTP Local Switching function.',2,1,1,0,0,0,0,0,0,0); /*!40000 ALTER TABLE `paramConf` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `param_0` -- DROP TABLE IF EXISTS `param_0`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `param_0` ( `level_1` int(5) unsigned NOT NULL DEFAULT 0, `level_2` int(5) unsigned NOT NULL DEFAULT 0, `level_3` int(5) unsigned NOT NULL DEFAULT 0, `level_4` int(5) unsigned NOT NULL DEFAULT 0, `level_5` int(5) unsigned NOT NULL DEFAULT 0, `level_6` int(5) unsigned NOT NULL DEFAULT 0, `level_7` int(5) unsigned NOT NULL DEFAULT 0, `level_8` int(5) unsigned NOT NULL DEFAULT 0, `level_9` int(5) unsigned NOT NULL DEFAULT 0, `level_10` int(5) unsigned NOT NULL DEFAULT 0, `instanceNo` varchar(32) NOT NULL DEFAULT '0', `initValue` varchar(255) NOT NULL, `readValue` varchar(255) NOT NULL, UNIQUE KEY `keyList` (`level_1`,`level_2`,`level_3`,`level_4`,`level_5`,`level_6`,`level_7`,`level_8`,`level_9`,`level_10`,`instanceNo`), KEY `level_1` (`level_1`), KEY `level_2` (`level_2`), KEY `level_3` (`level_3`), KEY `level_4` (`level_4`), KEY `level_5` (`level_5`), KEY `level_6` (`level_6`), KEY `level_7` (`level_7`), KEY `level_8` (`level_8`), KEY `level_9` (`level_9`), KEY `level_10` (`level_10`), KEY `instanceNo` (`instanceNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `param_0` -- LOCK TABLES `param_0` WRITE; /*!40000 ALTER TABLE `param_0` DISABLE KEYS */; /*!40000 ALTER TABLE `param_0` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `param_1` -- DROP TABLE IF EXISTS `param_1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `param_1` ( `level_1` int(5) unsigned NOT NULL DEFAULT 0, `level_2` int(5) unsigned NOT NULL DEFAULT 0, `level_3` int(5) unsigned NOT NULL DEFAULT 0, `level_4` int(5) unsigned NOT NULL DEFAULT 0, `level_5` int(5) unsigned NOT NULL DEFAULT 0, `level_6` int(5) unsigned NOT NULL DEFAULT 0, `level_7` int(5) unsigned NOT NULL DEFAULT 0, `level_8` int(5) unsigned NOT NULL DEFAULT 0, `level_9` int(5) unsigned NOT NULL DEFAULT 0, `level_10` int(5) unsigned NOT NULL DEFAULT 0, `instanceNo` varchar(32) NOT NULL DEFAULT '0', `initValue` varchar(255) NOT NULL, `readValue` varchar(255) NOT NULL, UNIQUE KEY `keyList` (`level_1`,`level_2`,`level_3`,`level_4`,`level_5`,`level_6`,`level_7`,`level_8`,`level_9`,`level_10`,`instanceNo`), KEY `level_1` (`level_1`), KEY `level_2` (`level_2`), KEY `level_3` (`level_3`), KEY `level_4` (`level_4`), KEY `level_5` (`level_5`), KEY `level_6` (`level_6`), KEY `level_7` (`level_7`), KEY `level_8` (`level_8`), KEY `level_9` (`level_9`), KEY `level_10` (`level_10`), KEY `instanceNo` (`instanceNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `param_1` -- LOCK TABLES `param_1` WRITE; /*!40000 ALTER TABLE `param_1` DISABLE KEYS */; /*!40000 ALTER TABLE `param_1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `param_99` -- DROP TABLE IF EXISTS `param_99`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `param_99` ( `level_1` int(5) unsigned NOT NULL DEFAULT 0, `level_2` int(5) unsigned NOT NULL DEFAULT 0, `level_3` int(5) unsigned NOT NULL DEFAULT 0, `level_4` int(5) unsigned NOT NULL DEFAULT 0, `level_5` int(5) unsigned NOT NULL DEFAULT 0, `level_6` int(5) unsigned NOT NULL DEFAULT 0, `level_7` int(5) unsigned NOT NULL DEFAULT 0, `level_8` int(5) unsigned NOT NULL DEFAULT 0, `level_9` int(5) unsigned NOT NULL DEFAULT 0, `level_10` int(5) unsigned NOT NULL DEFAULT 0, `instanceNo` varchar(32) NOT NULL DEFAULT '0', `initValue` varchar(255) NOT NULL, `readValue` varchar(255) NOT NULL, UNIQUE KEY `keyList` (`level_1`,`level_2`,`level_3`,`level_4`,`level_5`,`level_6`,`level_7`,`level_8`,`level_9`,`level_10`,`instanceNo`), KEY `level_1` (`level_1`), KEY `level_2` (`level_2`), KEY `level_3` (`level_3`), KEY `level_4` (`level_4`), KEY `level_5` (`level_5`), KEY `level_6` (`level_6`), KEY `level_7` (`level_7`), KEY `level_8` (`level_8`), KEY `level_9` (`level_9`), KEY `level_10` (`level_10`), KEY `instanceNo` (`instanceNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `param_99` -- LOCK TABLES `param_99` WRITE; /*!40000 ALTER TABLE `param_99` DISABLE KEYS */; /*!40000 ALTER TABLE `param_99` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-06-17 17:20:21