/*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_385
-- ------------------------------------------------------
-- 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_385`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `OBJ_385` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;

USE `OBJ_385`;

--
-- 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 ('mRFP','mRFP','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,1,0,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mRFPTable','mRFPTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,1,1,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mRFPEntry','mRFPEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','mrfpIndex','mrfpIndex',NULL,NULL,2,1,1,1,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpRowStatus','mrfpRowStatus','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,1,1,15,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpStatus','mrfpStatus','Key Parameter;Name:Avail State;','Key Parameter;Name:Avail State;',19,1,3,'','','','offLine=0;onLine=1','offLine=0;onLine=1','Indicate the current availability state of the connected MRFP.','Indicate the current availability state of the connected MRFP.',2,1,1,1,14,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpType','mrfpType','Name:Device Type;','Name:Device Type;',19,1,3,'','','','ipMedia=1;iwf=2','ipMedia=1;iwf=2','Specify the device type of the connected MRFP.','Specify the device type of the connected MRFP.',2,1,1,1,13,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpTransUserNumber','mrfpTransUserNumber','Key Parameter;Name:Max Trans Channels;','Key Parameter;Name:Max Trans Channels;',19,2,3,'','0','65535',NULL,NULL,'Assign the maximum number of channels reserved for transcoding use.<br>It cooperates with the preceding parameter to distribute licensed channels between conference and transcoding.','Assign the maximum number of channels reserved for transcoding use.<br>It cooperates with the preceding parameter to distribute licensed channels between conference and transcoding.',2,1,1,1,12,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpConfUserNumber','mrfpConfUserNumber','Key Parameter;Name:Max Conf Channels;','Key Parameter;Name:Max Conf Channels;',19,2,3,'','0','65535',NULL,NULL,'Assign the maximum number of channels reserved for conference call use.<br>It cooperates with the following parameter to distribute licensed channels between conference and transcoding.','Assign the maximum number of channels reserved for conference call use.<br>It cooperates with the following parameter to distribute licensed channels between conference and transcoding.',2,1,1,1,11,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpTransPrefix','mrfpTransPrefix','Name:Trans Prefix;','Name:Trans Prefix;',19,2,2,'','0','15',NULL,NULL,'Enter the transcoding ID that set on the connected MRFP.<br>-  Default = trans','Enter the transcoding ID that set on the connected MRFP.<br>-  Default = trans',2,1,1,1,10,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpConfPrefix','mrfpConfPrefix','Key Parameter;Name:Conf Prefix;','Key Parameter;Name:Conf Prefix;',19,2,2,'','0','15',NULL,NULL,'Enter the conference ID that set on the connected MRFP.<br>-  Default = conf','Enter the conference ID that set on the connected MRFP.<br>-  Default = conf',2,1,1,1,9,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpDestPort','mrfpDestPort','Key Parameter;Name:MRFP Port;','Key Parameter;Name:MRFP Port;',19,2,3,'','0','65535',NULL,NULL,'Enter the SIP UDP transmission port that set on the connected MRFP. Default as 5060.','Enter the SIP UDP transmission port that set on the connected MRFP. Default as 5060.',2,1,1,1,8,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpDestIp','mrfpDestIp','Name:MRFP IP;','Name:MRFP IP;',19,2,5,'','','',NULL,NULL,'IP address of the connected MRFP.','IP address of the connected MRFP.',2,1,1,1,7,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpDestDomain','mrfpDestDomain','Key Parameter;Name:MRFP Domain;','Key Parameter;Name:MRFP Domain;',19,2,2,'','0','16',NULL,NULL,'Domain name of the connected MRFP. Use MRFP IP address as default.','Domain name of the connected MRFP. Use MRFP IP address as default.',2,1,1,1,6,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpLocalDomain','mrfpLocalDomain','Key Parameter;Name:MRFC Domain;','Key Parameter;Name:MRFC Domain;',19,2,2,'','0','16',NULL,NULL,'Domain name of the local MRFC (Multimedia Resource Function Controller). Use MSS IP address as default.','Domain name of the local MRFC (Multimedia Resource Function Controller). Use MSS IP address as default.',2,1,1,1,5,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpAdministrationState','mrfpAdministrationState','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 MRFP.','Control the operation of the managed MRFP.',2,1,1,1,4,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpCreateTimeStamp','mrfpCreateTimeStamp','','',21,0,8,'','','',NULL,NULL,'Creation date and time of the MRFP.','Creation date and time of the MRFP.',2,1,1,1,3,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpTitle','mrfpTitle','Key Parameter;Name:Title;','Key Parameter;Name:Title;',19,2,2,'\"MRFP#\"','0','16',NULL,NULL,'MRFP name for identification purpose only.','MRFP name for identification purpose only.',2,1,1,1,2,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('mrfpIndex','mrfpIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','0','254',NULL,NULL,'MRFP (Multimedia Resource Function Processor) index number ranges from 0 to 254.','MRFP (Multimedia Resource Function Processor) index number ranges from 0 to 254.',2,1,1,1,1,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;
/*!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