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

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

USE `OBJ_355`;

--
-- 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 ('allowedUserPrefix','allowedUserPrefix','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,3,0,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('allowedUserPrefixTable','allowedUserPrefixTable','','',21,0,0,'','','',NULL,NULL,NULL,NULL,2,3,1,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('allowedUserPrefixEntry','allowedUserPrefixEntry','Table Parameter, level:1','Table Parameter, level:1',21,0,22050,'','','','aupIndex','aupIndex',NULL,NULL,2,3,1,1,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('aupRowStatus','aupRowStatus','Key Parameter;','Key Parameter;',19,1,3,'','','','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6','active=1;notInService=2;notReady=3;createAndGo=4;createAndWait=5;destroy=6',NULL,NULL,2,3,1,1,3,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('aupPrefix','aupPrefix','Key Parameter;Name:Prefix;','Key Parameter;Name:Prefix;',19,2,2,'','0','16',NULL,NULL,'Prefix determines the range of subscribers allowed to receive email messages.','Prefix determines the range of subscribers allowed to receive email messages.',2,3,1,1,2,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('aupIndex','aupIndex','Key Parameter;Name:Index;','Key Parameter;Name:Index;',48,2,3,'','1','16',NULL,NULL,'Allowed user prefix index number ranges from 1 to 16.','Allowed user prefix index number ranges from 1 to 16.',2,3,1,1,1,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('protocol','protocol','','',0,2,0,'','','',NULL,NULL,NULL,NULL,2,2,0,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('sMTPAuthenticationPassword','sMTPAuthenticationPassword','Name:SMTP AUTH Password;','Name:SMTP AUTH Password;',19,2,2,'','0','16',NULL,NULL,'Password for SMTP Authentication.','Password for SMTP Authentication.',2,2,5,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('sMTPAuthenticationUserName','sMTPAuthenticationUserName','Name:SMTP AUTH User;','Name:SMTP AUTH User;',19,2,2,'','0','32',NULL,NULL,'User name for SMTP Authentication.','User name for SMTP Authentication.',2,2,4,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('sMTPAuthenticationFlag','sMTPAuthenticationFlag','Name:SMTP AUTH Flag;','Name:SMTP AUTH Flag;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','SMTP Authentication provides an access control mechanism. It is used to allow legitimate users to relay mail while denying relay service to unauthorized users, such as spammers. Configure the authentication parameters when it is enabled on the email server side.','SMTP Authentication provides an access control mechanism. It is used to allow legitimate users to relay mail while denying relay service to unauthorized users, such as spammers. Configure the authentication parameters when it is enabled on the email server side.',2,2,3,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('sMTPEmailServerIP','sMTPEmailServerIP','Name:SMTP Email Server IP;','Name:SMTP Email Server IP;',19,2,5,'','','',NULL,NULL,'IP address of the email server.','IP address of the email server.',2,2,2,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('sMPPLinkAlias','sMPPLinkAlias','Name:SMPP Link Alias;','Name:SMPP Link Alias;',19,2,2,'','0','16',NULL,NULL,'Alias of the SMPP link which corresponds to the link configured in EMS &gt Configuration &gt NSS &gt SMPP.','Alias of the SMPP link which corresponds to the link configured in EMS &gt Configuration &gt NSS &gt SMPP.',2,2,1,0,0,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 ('flag','flag','Name:Flag;','Name:Flag;',19,1,3,'','','','disable=0;enable=1','disable=0;enable=1','Open or close SMEG service.','Open or close SMEG service.',2,1,8,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('saveCommand','saveCommand','','',21,0,3,'','','','saveParameter=1','saveParameter=1',NULL,NULL,2,1,7,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('domainNameForEmail','domainNameForEmail','Name:Domain Name for Email;','Name:Domain Name for Email;',19,2,2,'','0','32',NULL,NULL,'The domain name of email server is the domain-part after the @ sign in the email address. This email address is used to communicate emails between external email servers and the email server which connected with SMEG. It is the domain name which can be looked up in the public Domain Name System.','The domain name of email server is the domain-part after the @ sign in the email address. This email address is used to communicate emails between external email servers and the email server which connected with SMEG. It is the domain name which can be looked up in the public Domain Name System.',2,1,6,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('localDomainName','localDomainName','Name:Local Domain Name;','Name:Local Domain Name;',19,2,2,'','0','32',NULL,NULL,'This name is the domain-part after the @ sign in the email address. This email address is used to transfer emails from email server to SMEG. Normally, it is the SMEG\'s host name.','This name is the domain-part after the @ sign in the email address. This email address is used to transfer emails from email server to SMEG. Normally, it is the SMEG\'s host name.',2,1,5,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('maxSMSPerEmail','maxSMSPerEmail','Name:Max SMS per Email;','Name:Max SMS per Email;',19,2,3,'','0','16',NULL,NULL,'Define the maximum number of SMS can be concatenated per long email.','Define the maximum number of SMS can be concatenated per long email.',2,1,4,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('nationalDestinationCode','nationalDestinationCode','Name:NDC;','Name:NDC;',19,2,2,'','0','3',NULL,NULL,'National Destination Code defines the national calling area or national network to which the subscriber belongs.','National Destination Code defines the national calling area or national network to which the subscriber belongs.',2,1,3,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('countryCode','countryCode','Name:CC;','Name:CC;',19,2,2,'','0','3',NULL,NULL,'Country Code identifies the country\'s network.','Country Code identifies the country\'s network.',2,1,2,0,0,0,0,0,0,0);
INSERT INTO `paramConf` VALUES ('license','license','Name:License;','Name:License;',18,3,3,'','','',NULL,NULL,'(Read Only) The maximum BHSM capacity of SMEG determined by License Control. SMEG will stop transiting SMS once the traffic reaches the maximum BHSM.','(Read Only) The maximum BHSM capacity of SMEG determined by License Control. SMEG will stop transiting SMS once the traffic reaches the maximum BHSM.',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;
/*!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