Da

✏️ Editing: tyoptics1_mai889.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: tyoptics1_mai889
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB-log

/*!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: `tyoptics1_mai889`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `tyoptics1_mai889` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `tyoptics1_mai889`;

--
-- Table structure for table `msbh_admin_pages`
--

DROP TABLE IF EXISTS `msbh_admin_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_admin_pages` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `title` mediumtext DEFAULT NULL,
  `information` mediumtext DEFAULT NULL,
  `enPage` enum('yes','no') NOT NULL DEFAULT 'yes',
  `orderBy` int(8) NOT NULL DEFAULT 0,
  `accounts` mediumtext DEFAULT NULL,
  `tmp` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_admin_pages`
--

LOCK TABLES `msbh_admin_pages` WRITE;
/*!40000 ALTER TABLE `msbh_admin_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_admin_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_attachments`
--

DROP TABLE IF EXISTS `msbh_attachments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_attachments` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `ticketID` varchar(20) NOT NULL DEFAULT '',
  `replyID` int(11) NOT NULL DEFAULT 0,
  `department` int(5) NOT NULL DEFAULT 0,
  `fileName` varchar(250) NOT NULL DEFAULT '',
  `fileSize` varchar(20) NOT NULL DEFAULT '',
  `mimeType` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tickid_index` (`ticketID`),
  KEY `repid_index` (`replyID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_attachments`
--

LOCK TABLES `msbh_attachments` WRITE;
/*!40000 ALTER TABLE `msbh_attachments` DISABLE KEYS */;
INSERT INTO `msbh_attachments` VALUES (1,1676345074,'3',0,1,'3-0-d769507e7480ab1ce234.pdf','15753','application/pdf'),(2,1676345226,'4',0,1,'4-0-0db416b350a303a8599a.jpg','4056','image/jpeg');
/*!40000 ALTER TABLE `msbh_attachments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_ban`
--

DROP TABLE IF EXISTS `msbh_ban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_ban` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL DEFAULT '',
  `ip` varchar(250) NOT NULL DEFAULT '',
  `count` int(5) NOT NULL DEFAULT 0,
  `banstamp` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_ban`
--

LOCK TABLES `msbh_ban` WRITE;
/*!40000 ALTER TABLE `msbh_ban` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_ban` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_categories`
--

DROP TABLE IF EXISTS `msbh_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_categories` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `summary` varchar(250) NOT NULL DEFAULT '',
  `enCat` enum('yes','no') NOT NULL DEFAULT 'yes',
  `orderBy` int(5) NOT NULL DEFAULT 0,
  `subcat` int(5) NOT NULL DEFAULT 0,
  `private` enum('yes','no') NOT NULL DEFAULT 'no',
  `accounts` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_categories`
--

LOCK TABLES `msbh_categories` WRITE;
/*!40000 ALTER TABLE `msbh_categories` DISABLE KEYS */;
INSERT INTO `msbh_categories` VALUES (1,'Software Questions','This category relates to our software','yes',1,0,'no',NULL),(2,'Company Questions','This category relates to our company','yes',2,0,'no',NULL);
/*!40000 ALTER TABLE `msbh_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_cusfields`
--

DROP TABLE IF EXISTS `msbh_cusfields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_cusfields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fieldInstructions` varchar(250) NOT NULL DEFAULT '',
  `fieldType` enum('textarea','input','select','checkbox','calendar') NOT NULL DEFAULT 'input',
  `fieldReq` enum('yes','no') NOT NULL DEFAULT 'no',
  `fieldOptions` mediumtext DEFAULT NULL,
  `fieldLoc` varchar(25) NOT NULL DEFAULT '',
  `orderBy` int(5) NOT NULL DEFAULT 0,
  `repeatPref` enum('yes','no') NOT NULL DEFAULT 'yes',
  `enField` enum('yes','no') NOT NULL DEFAULT 'yes',
  `departments` mediumtext DEFAULT NULL,
  `accounts` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_cusfields`
--

LOCK TABLES `msbh_cusfields` WRITE;
/*!40000 ALTER TABLE `msbh_cusfields` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_cusfields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_departments`
--

DROP TABLE IF EXISTS `msbh_departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_departments` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `showDept` enum('yes','no') NOT NULL DEFAULT 'no',
  `dept_subject` mediumtext DEFAULT NULL,
  `dept_comments` mediumtext DEFAULT NULL,
  `orderBy` int(5) NOT NULL DEFAULT 0,
  `manual_assign` enum('yes','no') NOT NULL DEFAULT 'no',
  `days` mediumtext DEFAULT NULL,
  `dept_priority` varchar(50) NOT NULL DEFAULT '',
  `auto_admin` enum('yes','no') NOT NULL DEFAULT 'yes',
  `auto_response` enum('yes','no') NOT NULL DEFAULT 'no',
  `response` mediumtext DEFAULT NULL,
  `response_sbj` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_departments`
--

LOCK TABLES `msbh_departments` WRITE;
/*!40000 ALTER TABLE `msbh_departments` DISABLE KEYS */;
INSERT INTO `msbh_departments` VALUES (1,'IT Support','yes','','',1,'no','','0','yes','no','','');
/*!40000 ALTER TABLE `msbh_departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_disputes`
--

DROP TABLE IF EXISTS `msbh_disputes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_disputes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ticketID` int(15) NOT NULL DEFAULT 0,
  `visitorID` int(8) NOT NULL DEFAULT 0,
  `postPrivileges` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  KEY `tickid_index` (`ticketID`),
  KEY `vis_index` (`visitorID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_disputes`
--

LOCK TABLES `msbh_disputes` WRITE;
/*!40000 ALTER TABLE `msbh_disputes` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_disputes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_faq`
--

DROP TABLE IF EXISTS `msbh_faq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_faq` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `question` mediumtext DEFAULT NULL,
  `answer` mediumtext DEFAULT NULL,
  `kviews` int(10) NOT NULL DEFAULT 0,
  `kuseful` int(10) NOT NULL DEFAULT 0,
  `knotuseful` int(10) NOT NULL DEFAULT 0,
  `enFaq` enum('yes','no') NOT NULL DEFAULT 'yes',
  `featured` enum('yes','no') NOT NULL DEFAULT 'no',
  `orderBy` int(5) NOT NULL DEFAULT 0,
  `cat` int(7) NOT NULL DEFAULT 0,
  `private` enum('yes','no') NOT NULL DEFAULT 'no',
  `tmp` varchar(250) NOT NULL DEFAULT '',
  `searchkeys` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_faq`
--

LOCK TABLES `msbh_faq` WRITE;
/*!40000 ALTER TABLE `msbh_faq` DISABLE KEYS */;
INSERT INTO `msbh_faq` VALUES (1,1676344608,'Why is our software the best?','This is a test question created when installing Maian Support\n\nPlease update or remove via your admin control panel',0,0,0,'yes','no',1,1,'no','',NULL),(2,1676344608,'Why is our company the best?','This is a test question created when installing Maian Support\n\nPlease update or remove via your admin control panel',0,0,0,'yes','no',2,2,'no','',NULL);
/*!40000 ALTER TABLE `msbh_faq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_faqassign`
--

DROP TABLE IF EXISTS `msbh_faqassign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_faqassign` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `question` int(7) NOT NULL DEFAULT 0,
  `itemID` int(7) NOT NULL DEFAULT 0,
  `desc` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `que_index` (`question`),
  KEY `att_index` (`itemID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_faqassign`
--

LOCK TABLES `msbh_faqassign` WRITE;
/*!40000 ALTER TABLE `msbh_faqassign` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_faqassign` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_faqattach`
--

DROP TABLE IF EXISTS `msbh_faqattach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_faqattach` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `name` varchar(250) NOT NULL DEFAULT '',
  `remote` varchar(250) NOT NULL DEFAULT '',
  `path` varchar(250) NOT NULL DEFAULT '',
  `size` varchar(30) NOT NULL DEFAULT '',
  `orderBy` int(8) NOT NULL DEFAULT 0,
  `enAtt` enum('yes','no') NOT NULL DEFAULT 'yes',
  `mimeType` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_faqattach`
--

LOCK TABLES `msbh_faqattach` WRITE;
/*!40000 ALTER TABLE `msbh_faqattach` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_faqattach` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_faqdl`
--

DROP TABLE IF EXISTS `msbh_faqdl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_faqdl` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `question` int(7) NOT NULL DEFAULT 0,
  `token` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_faqdl`
--

LOCK TABLES `msbh_faqdl` WRITE;
/*!40000 ALTER TABLE `msbh_faqdl` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_faqdl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_faqhistory`
--

DROP TABLE IF EXISTS `msbh_faqhistory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_faqhistory` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `faqID` int(11) NOT NULL DEFAULT 0,
  `action` mediumtext DEFAULT NULL,
  `ip` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `faq_index` (`faqID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_faqhistory`
--

LOCK TABLES `msbh_faqhistory` WRITE;
/*!40000 ALTER TABLE `msbh_faqhistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_faqhistory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_imap`
--

DROP TABLE IF EXISTS `msbh_imap`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_imap` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT,
  `im_piping` enum('yes','no') NOT NULL DEFAULT 'no',
  `im_protocol` enum('pop3','imap') NOT NULL DEFAULT 'pop3',
  `im_host` varchar(100) NOT NULL DEFAULT '',
  `im_user` varchar(250) NOT NULL DEFAULT '',
  `im_pass` varchar(100) NOT NULL DEFAULT '',
  `im_port` int(5) NOT NULL DEFAULT 110,
  `im_name` varchar(50) NOT NULL DEFAULT '',
  `im_flags` varchar(250) NOT NULL DEFAULT '',
  `im_attach` enum('yes','no') NOT NULL DEFAULT 'no',
  `im_move` varchar(50) NOT NULL DEFAULT '',
  `im_messages` int(3) NOT NULL DEFAULT 20,
  `im_ssl` enum('yes','no') NOT NULL DEFAULT 'no',
  `im_priority` varchar(250) NOT NULL DEFAULT '',
  `im_status` varchar(100) NOT NULL DEFAULT '',
  `im_dept` int(5) NOT NULL DEFAULT 0,
  `im_email` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_imap`
--

LOCK TABLES `msbh_imap` WRITE;
/*!40000 ALTER TABLE `msbh_imap` DISABLE KEYS */;
INSERT INTO `msbh_imap` VALUES (1,'yes','imap','mail.tyopticsonline.com','its@tyopticsonline.com','Ty1Q2w3e4r5t!',143,'inbox','/novalidate-cert','no','',50,'no','low','open',1,'');
/*!40000 ALTER TABLE `msbh_imap` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_imapban`
--

DROP TABLE IF EXISTS `msbh_imapban`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_imapban` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `filter` mediumtext DEFAULT NULL,
  `account` enum('yes','no') NOT NULL DEFAULT 'yes',
  `spam` enum('yes','no') NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `filter` (`filter`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_imapban`
--

LOCK TABLES `msbh_imapban` WRITE;
/*!40000 ALTER TABLE `msbh_imapban` DISABLE KEYS */;
INSERT INTO `msbh_imapban` VALUES (1,'mailer-daemon','yes','no');
/*!40000 ALTER TABLE `msbh_imapban` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_levels`
--

DROP TABLE IF EXISTS `msbh_levels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_levels` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `display` enum('yes','no') NOT NULL DEFAULT 'no',
  `marker` varchar(100) NOT NULL DEFAULT '',
  `orderBy` int(5) NOT NULL DEFAULT 0,
  `colors` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_levels`
--

LOCK TABLES `msbh_levels` WRITE;
/*!40000 ALTER TABLE `msbh_levels` DISABLE KEYS */;
INSERT INTO `msbh_levels` VALUES (1,'Low','yes','low',1,'a:2:{s:2:\"fg\";s:6:\"000000\";s:2:\"bg\";s:6:\"CCECF2\";}'),(2,'Medium','yes','medium',2,'a:2:{s:2:\"fg\";s:6:\"FFFFFF\";s:2:\"bg\";s:6:\"B4A7BE\";}'),(3,'High','yes','high',3,'a:2:{s:2:\"fg\";s:6:\"FFFFFF\";s:2:\"bg\";s:6:\"D42449\";}');
/*!40000 ALTER TABLE `msbh_levels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_log`
--

DROP TABLE IF EXISTS `msbh_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `userID` int(5) NOT NULL DEFAULT 0,
  `ip` varchar(250) NOT NULL DEFAULT '',
  `type` enum('user','acc') NOT NULL DEFAULT 'user',
  PRIMARY KEY (`id`),
  KEY `useid_index` (`userID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_log`
--

LOCK TABLES `msbh_log` WRITE;
/*!40000 ALTER TABLE `msbh_log` DISABLE KEYS */;
INSERT INTO `msbh_log` VALUES (1,1676344756,1,'182.53.142.193','user');
/*!40000 ALTER TABLE `msbh_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_mailassoc`
--

DROP TABLE IF EXISTS `msbh_mailassoc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_mailassoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `staffID` int(8) NOT NULL DEFAULT 0,
  `mailID` int(8) NOT NULL DEFAULT 0,
  `folder` varchar(10) NOT NULL DEFAULT 'inbox',
  `status` enum('read','unread') NOT NULL DEFAULT 'unread',
  `lastUpdate` int(30) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `staff_index` (`staffID`),
  KEY `mail_index` (`mailID`),
  KEY `status_index` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_mailassoc`
--

LOCK TABLES `msbh_mailassoc` WRITE;
/*!40000 ALTER TABLE `msbh_mailassoc` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_mailassoc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_mailbox`
--

DROP TABLE IF EXISTS `msbh_mailbox`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_mailbox` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `staffID` int(8) NOT NULL DEFAULT 0,
  `subject` varchar(250) NOT NULL DEFAULT '',
  `message` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_index` (`staffID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_mailbox`
--

LOCK TABLES `msbh_mailbox` WRITE;
/*!40000 ALTER TABLE `msbh_mailbox` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_mailbox` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_mailfolders`
--

DROP TABLE IF EXISTS `msbh_mailfolders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_mailfolders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `staffID` int(8) NOT NULL DEFAULT 0,
  `folder` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `staff_index` (`staffID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_mailfolders`
--

LOCK TABLES `msbh_mailfolders` WRITE;
/*!40000 ALTER TABLE `msbh_mailfolders` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_mailfolders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_mailreplies`
--

DROP TABLE IF EXISTS `msbh_mailreplies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_mailreplies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `mailID` int(8) NOT NULL DEFAULT 0,
  `staffID` int(8) NOT NULL DEFAULT 0,
  `message` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_index` (`mailID`),
  KEY `staff_index` (`staffID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_mailreplies`
--

LOCK TABLES `msbh_mailreplies` WRITE;
/*!40000 ALTER TABLE `msbh_mailreplies` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_mailreplies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_pages`
--

DROP TABLE IF EXISTS `msbh_pages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_pages` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `title` mediumtext DEFAULT NULL,
  `information` mediumtext DEFAULT NULL,
  `enPage` enum('yes','no') NOT NULL DEFAULT 'yes',
  `orderBy` int(8) NOT NULL DEFAULT 0,
  `secure` enum('yes','no') NOT NULL DEFAULT 'no',
  `accounts` mediumtext DEFAULT NULL,
  `tmp` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_pages`
--

LOCK TABLES `msbh_pages` WRITE;
/*!40000 ALTER TABLE `msbh_pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_pages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_portal`
--

DROP TABLE IF EXISTS `msbh_portal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_portal` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `ts` int(30) NOT NULL DEFAULT 0,
  `email` varchar(250) NOT NULL DEFAULT '',
  `userPass` varchar(250) NOT NULL DEFAULT '',
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
  `verified` enum('yes','no') NOT NULL DEFAULT 'no',
  `timezone` varchar(50) NOT NULL DEFAULT '0',
  `ip` mediumtext DEFAULT NULL,
  `notes` mediumtext DEFAULT NULL,
  `reason` mediumtext DEFAULT NULL,
  `system1` varchar(250) NOT NULL DEFAULT '',
  `system2` varchar(250) NOT NULL DEFAULT '',
  `language` varchar(100) NOT NULL DEFAULT '',
  `enableLog` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`),
  KEY `em_index` (`email`),
  KEY `nm_index` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_portal`
--

LOCK TABLES `msbh_portal` WRITE;
/*!40000 ALTER TABLE `msbh_portal` DISABLE KEYS */;
INSERT INTO `msbh_portal` VALUES (1,'xxx',1676344937,'x9954249@gmail.com','$2y$10$wUBwZv47eiSkusQWPlhgUO7x0Fuuz4OClu1A7xM05mobEA7OwHmam','yes','yes','Europe/London','182.53.142.193','',NULL,'','','english','yes');
/*!40000 ALTER TABLE `msbh_portal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_replies`
--

DROP TABLE IF EXISTS `msbh_replies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_replies` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `ticketID` int(15) NOT NULL DEFAULT 0,
  `comments` mediumtext DEFAULT NULL,
  `mailBodyFilter` varchar(30) NOT NULL DEFAULT '',
  `replyType` enum('none','visitor','admin') NOT NULL DEFAULT 'none',
  `replyUser` int(8) NOT NULL DEFAULT 0,
  `isMerged` enum('yes','no') NOT NULL DEFAULT 'no',
  `ipAddresses` mediumtext DEFAULT NULL,
  `disputeUser` int(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `tickid_index` (`ticketID`),
  KEY `repuse_index` (`replyUser`),
  KEY `disuse_index` (`disputeUser`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_replies`
--

LOCK TABLES `msbh_replies` WRITE;
/*!40000 ALTER TABLE `msbh_replies` DISABLE KEYS */;
INSERT INTO `msbh_replies` VALUES (1,1676345245,4,'ok naja','','admin',1,'no','182.53.142.193',0),(2,1676345414,5,'bcvbcvbcvb','','admin',1,'no','182.53.142.193',0),(3,1676345447,5,'bcvbcvbcvb','','admin',1,'no','182.53.142.193',0);
/*!40000 ALTER TABLE `msbh_replies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_responses`
--

DROP TABLE IF EXISTS `msbh_responses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_responses` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `title` mediumtext DEFAULT NULL,
  `answer` mediumtext DEFAULT NULL,
  `enResponse` enum('yes','no') NOT NULL DEFAULT 'yes',
  `orderBy` int(8) NOT NULL DEFAULT 0,
  `departments` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_responses`
--

LOCK TABLES `msbh_responses` WRITE;
/*!40000 ALTER TABLE `msbh_responses` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_responses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_settings`
--

DROP TABLE IF EXISTS `msbh_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_settings` (
  `id` tinyint(1) NOT NULL AUTO_INCREMENT,
  `website` varchar(150) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `replyto` varchar(250) NOT NULL DEFAULT '',
  `scriptpath` varchar(250) NOT NULL DEFAULT '',
  `attachpath` varchar(250) NOT NULL DEFAULT '',
  `attachhref` varchar(250) NOT NULL DEFAULT '',
  `attachpathfaq` varchar(250) NOT NULL DEFAULT '',
  `attachhreffaq` varchar(250) NOT NULL DEFAULT '',
  `bfolder` varchar(250) NOT NULL DEFAULT '',
  `language` varchar(250) NOT NULL DEFAULT 'english',
  `langSets` mediumtext DEFAULT NULL,
  `dateformat` varchar(20) NOT NULL DEFAULT 'D j M Y, G:ia',
  `timeformat` varchar(15) NOT NULL DEFAULT 'H:iA',
  `timezone` varchar(50) NOT NULL DEFAULT 'Europe/London',
  `weekStart` enum('mon','sun') NOT NULL DEFAULT 'sun',
  `jsDateFormat` varchar(15) NOT NULL DEFAULT 'DD/MM/YYYY',
  `kbase` enum('yes','no') NOT NULL DEFAULT 'yes',
  `enableVotes` enum('yes','no') NOT NULL DEFAULT 'yes',
  `multiplevotes` enum('yes','no') NOT NULL DEFAULT 'no',
  `popquestions` int(5) NOT NULL DEFAULT 0,
  `quePerPage` int(3) NOT NULL DEFAULT 10,
  `cookiedays` int(5) NOT NULL DEFAULT 0,
  `renamefaq` enum('yes','no') NOT NULL DEFAULT 'no',
  `attachment` enum('yes','no') NOT NULL DEFAULT 'no',
  `rename` enum('yes','no') NOT NULL DEFAULT 'no',
  `attachboxes` int(3) NOT NULL DEFAULT 2,
  `filetypes` mediumtext DEFAULT NULL,
  `maxsize` int(15) NOT NULL DEFAULT 200,
  `enableBBCode` enum('yes','no') NOT NULL DEFAULT 'yes',
  `afolder` varchar(50) NOT NULL DEFAULT '',
  `autoClose` int(5) NOT NULL DEFAULT 0,
  `autoCloseMail` enum('yes','no') NOT NULL DEFAULT 'yes',
  `smtp_host` varchar(100) NOT NULL DEFAULT 'localhost',
  `smtp_user` varchar(100) NOT NULL DEFAULT '',
  `smtp_pass` varchar(100) NOT NULL DEFAULT '',
  `smtp_port` int(4) NOT NULL DEFAULT 25,
  `smtp_security` varchar(10) NOT NULL DEFAULT '',
  `smtp_debug` enum('yes','no') NOT NULL DEFAULT 'no',
  `smtp_html` enum('yes','no') NOT NULL DEFAULT 'yes',
  `prodKey` char(60) NOT NULL DEFAULT '',
  `publicFooter` mediumtext DEFAULT NULL,
  `adminFooter` mediumtext DEFAULT NULL,
  `encoderVersion` varchar(5) NOT NULL DEFAULT '',
  `softwareVersion` varchar(10) NOT NULL DEFAULT '',
  `apiKey` varchar(100) NOT NULL DEFAULT '',
  `apiLog` enum('yes','no') NOT NULL DEFAULT 'no',
  `apiHandlers` varchar(100) NOT NULL DEFAULT '',
  `sysstatus` enum('yes','no') NOT NULL DEFAULT 'yes',
  `autoenable` date NOT NULL DEFAULT '1970-01-01',
  `disputes` enum('yes','no') NOT NULL DEFAULT 'no',
  `offlineReason` mediumtext DEFAULT NULL,
  `createPref` enum('yes','no') NOT NULL DEFAULT 'yes',
  `createAcc` enum('yes','no') NOT NULL DEFAULT 'yes',
  `loginLimit` int(5) NOT NULL DEFAULT 0,
  `banTime` int(5) NOT NULL DEFAULT 0,
  `ticketHistory` enum('yes','no') NOT NULL DEFAULT 'yes',
  `backupEmails` mediumtext DEFAULT NULL,
  `closenotify` enum('yes','no') NOT NULL DEFAULT 'no',
  `minPassValue` int(3) NOT NULL DEFAULT 8,
  `accProfNotify` enum('yes','no') NOT NULL DEFAULT 'yes',
  `newAccNotify` enum('yes','no') NOT NULL DEFAULT 'yes',
  `enableLog` enum('yes','no') NOT NULL DEFAULT 'yes',
  `defKeepLogs` varchar(100) NOT NULL DEFAULT '',
  `minTickDigits` int(2) NOT NULL DEFAULT 5,
  `enableMail` enum('yes','no') NOT NULL DEFAULT 'yes',
  `imap_debug` enum('yes','no') NOT NULL DEFAULT 'no',
  `imap_param` varchar(10) NOT NULL DEFAULT '',
  `imap_memory` varchar(3) NOT NULL DEFAULT '10',
  `imap_timeout` varchar(3) NOT NULL DEFAULT '120',
  `imap_attach` enum('yes','no') NOT NULL DEFAULT 'no',
  `imap_notify` enum('yes','no') NOT NULL DEFAULT 'no',
  `disputeAdminStop` enum('yes','no') NOT NULL DEFAULT 'no',
  `faqcounts` enum('yes','no') NOT NULL DEFAULT 'no',
  `closeadmin` enum('yes','no') NOT NULL DEFAULT 'no',
  `adminlock` enum('yes','no') NOT NULL DEFAULT 'no',
  `locktime` int(7) NOT NULL DEFAULT 0,
  `imap_clean` enum('yes','no') NOT NULL DEFAULT 'yes',
  `tawk` mediumtext DEFAULT NULL,
  `tawk_home` enum('yes','no') NOT NULL DEFAULT 'no',
  `defdept` int(5) NOT NULL DEFAULT 0,
  `defprty` varchar(50) NOT NULL DEFAULT '',
  `rantick` enum('yes','no') NOT NULL DEFAULT 'no',
  `imap_open` enum('yes','no') NOT NULL DEFAULT 'no',
  `autospam` int(5) NOT NULL DEFAULT 0,
  `wordwrap` varchar(200) NOT NULL DEFAULT '',
  `timetrack` enum('yes','no') NOT NULL DEFAULT 'yes',
  `selfsign` enum('yes','no') NOT NULL DEFAULT 'no',
  `openlimit` enum('yes','no') NOT NULL DEFAULT 'no',
  `mail` enum('smtp','mail') NOT NULL DEFAULT 'smtp',
  `accautodel` int(5) NOT NULL DEFAULT 0,
  `visclose` enum('yes','no') NOT NULL DEFAULT 'no',
  `imapspamcloseacc` enum('yes','no') NOT NULL DEFAULT 'no',
  `navmenu` mediumtext DEFAULT NULL,
  `faqHistory` enum('yes','no') NOT NULL DEFAULT 'no',
  `spam_score_header` varchar(100) NOT NULL DEFAULT '',
  `spam_score_value` varchar(100) NOT NULL DEFAULT '0',
  `en_cap` enum('yes','no') NOT NULL DEFAULT 'no',
  `editor` enum('wys','bb') NOT NULL DEFAULT 'wys',
  `tprefix` varchar(30) NOT NULL DEFAULT '',
  `notify_close` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notify_open` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notify_other` enum('yes','no') NOT NULL DEFAULT 'yes',
  `viscloseticket` enum('yes','no') NOT NULL DEFAULT 'yes',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_settings`
--

LOCK TABLES `msbh_settings` WRITE;
/*!40000 ALTER TABLE `msbh_settings` DISABLE KEYS */;
INSERT INTO `msbh_settings` VALUES (1,'IT Helpdesk System @TY OPTICS','its@tyopticsonline.com','','https://tyopticsonline.com/itsupport','/home/tyoptics1/domains/tyopticsonline.com/public_html/itsupport/content/attachments','http://tyopticsonline.com/itsupport/content/attachments','/home/tyoptics1/domains/tyopticsonline.com/public_html/itsupport/content/attachments-faq','http://tyopticsonline.com/itsupport/content/attachments-faq','backups','english','a:1:{s:7:\"english\";s:12:\"_default_set\";}','d M Y','H:iA','Europe/London','sun','DD-MM-YYYY','yes','yes','yes',10,10,360,'no','yes','yes',1,'.jpg|.zip|.gif|.rar|.png|.pdf',20971520,'yes','admin',0,'yes','mail.tyopticsonline.com','its@tyopticsonline.com','Ty1Q2w3e4r5t!',587,'','no','yes','FKWWJY6F7RW62FDXHDEPZSKW8LJHEYE5JCCSFBHJWIHKFJDILGMVVPCXZGJ9','To add your own footer code, go to &quot;Settings &amp; Tools > Other Options > Edit Footers&quot;','To add your own footer code, go to &quot;Settings &amp; Tools > Other Options > Edit Footers&quot;','msw','4.5','B844E15306-C27630F1','yes','json,xml','yes','1970-01-01','no','','no','yes',5,5,'yes','','no',8,'yes','yes','yes','a:2:{s:4:\"user\";s:2:\"50\";s:3:\"acc\";s:2:\"50\";}',5,'yes','yes','pipe','0','0','no','no','no','no','no','no',0,'yes','','no',0,'0','no','no',0,'a:3:{s:2:\"pc\";s:3:\"400\";s:6:\"mobile\";s:2:\"40\";s:6:\"tablet\";s:3:\"100\";}','no','no','no','smtp',0,'no','no','','no','','','no','wys','','yes','yes','yes','yes');
/*!40000 ALTER TABLE `msbh_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_social`
--

DROP TABLE IF EXISTS `msbh_social`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_social` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `desc` varchar(50) NOT NULL DEFAULT '',
  `param` mediumtext DEFAULT NULL,
  `value` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `descK` (`desc`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_social`
--

LOCK TABLES `msbh_social` WRITE;
/*!40000 ALTER TABLE `msbh_social` DISABLE KEYS */;
INSERT INTO `msbh_social` VALUES (1,'ctalk','key','');
/*!40000 ALTER TABLE `msbh_social` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_statuses`
--

DROP TABLE IF EXISTS `msbh_statuses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_statuses` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `perms` enum('yes','no') NOT NULL DEFAULT 'no',
  `marker` varchar(100) NOT NULL DEFAULT '',
  `orderBy` int(5) NOT NULL DEFAULT 0,
  `colors` varchar(200) NOT NULL DEFAULT '',
  `visitor` enum('yes','no') NOT NULL DEFAULT 'yes',
  `autoclose` enum('yes','no') NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_statuses`
--

LOCK TABLES `msbh_statuses` WRITE;
/*!40000 ALTER TABLE `msbh_statuses` DISABLE KEYS */;
INSERT INTO `msbh_statuses` VALUES (1,'Open','yes','open',2,'','yes','no'),(2,'Closed','yes','close',1,'','yes','no'),(3,'Locked','yes','closed',3,'','yes','no');
/*!40000 ALTER TABLE `msbh_statuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_ticketfields`
--

DROP TABLE IF EXISTS `msbh_ticketfields`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_ticketfields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ticketID` varchar(20) NOT NULL DEFAULT '',
  `fieldID` int(15) NOT NULL DEFAULT 0,
  `replyID` int(15) NOT NULL DEFAULT 0,
  `fieldData` mediumtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tickid_index` (`ticketID`),
  KEY `fldid_index` (`fieldID`),
  KEY `repid_index` (`replyID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_ticketfields`
--

LOCK TABLES `msbh_ticketfields` WRITE;
/*!40000 ALTER TABLE `msbh_ticketfields` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_ticketfields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_tickethistory`
--

DROP TABLE IF EXISTS `msbh_tickethistory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_tickethistory` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `ticketID` int(11) NOT NULL DEFAULT 0,
  `action` mediumtext DEFAULT NULL,
  `ip` varchar(250) NOT NULL DEFAULT '',
  `staff` int(5) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `ticket_index` (`ticketID`),
  KEY `staff` (`staff`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_tickethistory`
--

LOCK TABLES `msbh_tickethistory` WRITE;
/*!40000 ALTER TABLE `msbh_tickethistory` DISABLE KEYS */;
INSERT INTO `msbh_tickethistory` VALUES (1,1676344938,1,'New ticket created by xxx','182.53.142.193',0),(2,1676344987,2,'New ticket created by xxx','182.53.142.193',0),(3,1676345074,3,'New ticket created by xxx','182.53.142.193',0),(4,1676345226,4,'New ticket created by xxx','182.53.142.193',0),(5,1676345245,4,'Reply ID 1 added by IT Admin','182.53.142.193',0),(6,1676345400,5,'New ticket created by xxx','182.53.142.193',0),(7,1676345414,5,'Reply ID 2 added by IT Admin','182.53.142.193',0),(8,1676345447,5,'Reply ID 3 added by IT Admin','182.53.142.193',0),(9,1676345483,5,'Status changed to \"Closed\" by IT Admin','182.53.142.193',0),(10,1676345487,4,'Status changed to \"Closed\" by IT Admin','182.53.142.193',0);
/*!40000 ALTER TABLE `msbh_tickethistory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_tickets`
--

DROP TABLE IF EXISTS `msbh_tickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_tickets` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tickno` varchar(250) NOT NULL DEFAULT '',
  `ts` int(30) NOT NULL DEFAULT 0,
  `lastrevision` int(30) NOT NULL DEFAULT 0,
  `department` int(8) NOT NULL DEFAULT 0,
  `assignedto` varchar(250) NOT NULL DEFAULT '',
  `visitorID` int(8) NOT NULL DEFAULT 0,
  `subject` varchar(250) NOT NULL DEFAULT '',
  `mailBodyFilter` varchar(30) NOT NULL DEFAULT '',
  `comments` mediumtext DEFAULT NULL,
  `priority` varchar(250) NOT NULL DEFAULT '',
  `ticketStatus` varchar(20) NOT NULL DEFAULT '',
  `ipAddresses` varchar(250) NOT NULL DEFAULT '',
  `ticketNotes` mediumtext DEFAULT NULL,
  `isDisputed` enum('yes','no') NOT NULL DEFAULT 'no',
  `disPostPriv` enum('yes','no') NOT NULL DEFAULT 'yes',
  `source` varchar(10) NOT NULL DEFAULT 'standard',
  `spamFlag` enum('yes','no') NOT NULL DEFAULT 'no',
  `lockteam` int(7) NOT NULL DEFAULT 0,
  `lockrelease` int(30) NOT NULL DEFAULT 0,
  `worktime` varchar(50) NOT NULL DEFAULT '00:00:00',
  PRIMARY KEY (`id`),
  KEY `depid_index` (`department`),
  KEY `pry_index` (`priority`),
  KEY `isdis_index` (`isDisputed`),
  KEY `ts_index` (`ts`),
  KEY `vis_index` (`visitorID`),
  KEY `lockteam` (`lockteam`),
  KEY `ticketStatus` (`ticketStatus`),
  KEY `tickno` (`tickno`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_tickets`
--

LOCK TABLES `msbh_tickets` WRITE;
/*!40000 ALTER TABLE `msbh_tickets` DISABLE KEYS */;
INSERT INTO `msbh_tickets` VALUES (1,'',1676344938,1676344938,1,'',1,'Test','','Test','high','open','182.53.142.193','','no','yes','standard','no',0,0,'00:00:00'),(2,'',1676344987,1676344987,1,'',1,'test2','','nvnvnbv','high','open','182.53.142.193','','no','yes','standard','no',0,0,'00:00:00'),(3,'',1676345074,1676345074,1,'',1,'test3','','aaaaaaaaaaaaaaaaaaaaa','low','open','182.53.142.193','','no','yes','standard','no',0,0,'00:00:00'),(4,'',1676345226,1676345487,1,'',1,'test4','','vbvcbcvnb','medium','close','182.53.142.193','','no','yes','standard','no',0,0,'00:00:00'),(5,'',1676345400,1676345483,1,'',1,'test5','','fdsfdgdfggfdgdf','high','close','182.53.142.193','','no','yes','standard','no',0,0,'00:00:00');
/*!40000 ALTER TABLE `msbh_tickets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_userdepts`
--

DROP TABLE IF EXISTS `msbh_userdepts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_userdepts` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `userID` int(5) NOT NULL DEFAULT 0,
  `deptID` int(5) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `userid_index` (`userID`),
  KEY `depid_index` (`deptID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_userdepts`
--

LOCK TABLES `msbh_userdepts` WRITE;
/*!40000 ALTER TABLE `msbh_userdepts` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_userdepts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_users`
--

DROP TABLE IF EXISTS `msbh_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_users` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `ts` int(30) NOT NULL DEFAULT 0,
  `name` varchar(100) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `email2` mediumtext DEFAULT NULL,
  `accpass` varchar(250) NOT NULL DEFAULT '',
  `signature` mediumtext DEFAULT NULL,
  `notify` enum('yes','no') NOT NULL DEFAULT 'yes',
  `pageAccess` mediumtext DEFAULT NULL,
  `emailSigs` enum('yes','no') NOT NULL DEFAULT 'no',
  `notePadEnable` enum('yes','no') NOT NULL DEFAULT 'yes',
  `delPriv` enum('yes','no') NOT NULL DEFAULT 'no',
  `nameFrom` varchar(250) NOT NULL DEFAULT '',
  `emailFrom` varchar(250) NOT NULL DEFAULT '',
  `assigned` enum('yes','no') NOT NULL DEFAULT 'no',
  `timezone` varchar(50) NOT NULL DEFAULT '0',
  `enabled` enum('yes','no') NOT NULL DEFAULT 'yes',
  `notes` mediumtext DEFAULT NULL,
  `ticketHistory` enum('yes','no') NOT NULL DEFAULT 'yes',
  `enableLog` enum('yes','no') NOT NULL DEFAULT 'yes',
  `mailbox` enum('yes','no') NOT NULL DEFAULT 'yes',
  `mailFolders` int(3) NOT NULL DEFAULT 5,
  `mailDeletion` enum('yes','no') NOT NULL DEFAULT 'yes',
  `mailScreen` enum('yes','no') NOT NULL DEFAULT 'yes',
  `mailCopy` enum('yes','no') NOT NULL DEFAULT 'yes',
  `mailPurge` int(3) NOT NULL DEFAULT 0,
  `addpages` mediumtext DEFAULT NULL,
  `mergeperms` enum('yes','no') NOT NULL DEFAULT 'yes',
  `digest` enum('yes','no') NOT NULL DEFAULT 'yes',
  `profile` enum('yes','no') NOT NULL DEFAULT 'yes',
  `helplink` enum('yes','no') NOT NULL DEFAULT 'no',
  `defDays` int(3) NOT NULL DEFAULT 45,
  `editperms` mediumtext DEFAULT NULL,
  `lock` enum('yes','no') NOT NULL DEFAULT 'yes',
  `close` enum('yes','no') NOT NULL DEFAULT 'yes',
  `admin` enum('yes','no') NOT NULL DEFAULT 'no',
  `timer` enum('yes','no') NOT NULL DEFAULT 'yes',
  `startwork` enum('yes','no') NOT NULL DEFAULT 'yes',
  `workedit` enum('yes','no') NOT NULL DEFAULT 'yes',
  `language` varchar(250) NOT NULL DEFAULT 'english',
  `spamnotify` enum('yes','no') NOT NULL DEFAULT 'yes',
  `savedstaff` mediumtext DEFAULT NULL,
  `staffupnotify` enum('yes','no') NOT NULL DEFAULT 'no',
  `faqHistory` enum('yes','no') NOT NULL DEFAULT 'no',
  `digestops` mediumtext DEFAULT NULL,
  `digestdays` mediumtext DEFAULT NULL,
  `moveperms` enum('yes','no') NOT NULL DEFAULT 'no',
  `cstatus` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `email_index` (`email`),
  KEY `nty_index` (`notify`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_users`
--

LOCK TABLES `msbh_users` WRITE;
/*!40000 ALTER TABLE `msbh_users` DISABLE KEYS */;
INSERT INTO `msbh_users` VALUES (1,1676344608,'IT Admin','its@tyopticsonline.com',NULL,'$2y$10$ZGUmOpjkM6dBzCEHaXGGIeVg2UM.QCrKCOg95mmktEvPKWdPQrLXK','','yes','','no','yes','yes','IT Admin','its@tyopticsonline.com','no','Europe/London','yes',NULL,'yes','yes','yes',5,'yes','yes','yes',0,NULL,'yes','yes','yes','yes',45,NULL,'yes','yes','yes','no','yes','yes','english','yes','','no','no',NULL,NULL,'no','');
/*!40000 ALTER TABLE `msbh_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msbh_usersaccess`
--

DROP TABLE IF EXISTS `msbh_usersaccess`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msbh_usersaccess` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `page` varchar(100) NOT NULL DEFAULT '',
  `userID` varchar(250) NOT NULL DEFAULT '',
  `type` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_index` (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msbh_usersaccess`
--

LOCK TABLES `msbh_usersaccess` WRITE;
/*!40000 ALTER TABLE `msbh_usersaccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `msbh_usersaccess` 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-10-31 13:30:09

📁 Sid Gifari File Manager