-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: xoomdns_ostt1
-- ------------------------------------------------------
-- Server version	5.7.44

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


--
-- Table structure for table `ticket_answers`
--

DROP TABLE IF EXISTS `ticket_answers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_answers` (
  `ID` int(7) NOT NULL AUTO_INCREMENT,
  `ticket` int(6) DEFAULT '0',
  `message` text COLLATE utf8_unicode_ci,
  `rep` int(5) NOT NULL DEFAULT '0',
  `reference` int(7) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_answers`
--

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

--
-- Table structure for table `ticket_attachments`
--

DROP TABLE IF EXISTS `ticket_attachments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_attachments` (
  `ID` int(7) NOT NULL AUTO_INCREMENT,
  `ticket` int(6) NOT NULL DEFAULT '0',
  `ref` int(7) NOT NULL DEFAULT '0',
  `filename` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_attachments`
--

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

--
-- Table structure for table `ticket_banlist`
--

DROP TABLE IF EXISTS `ticket_banlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_banlist` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`value_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_banlist`
--

LOCK TABLES `ticket_banlist` WRITE;
/*!40000 ALTER TABLE `ticket_banlist` DISABLE KEYS */;
INSERT INTO `ticket_banlist` (`value_id`, `value`) VALUES (1,'mailer-daemon'),(2,'Mail Delivery Subsystem'),(3,'Mail Delivery System');
/*!40000 ALTER TABLE `ticket_banlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket_categories`
--

DROP TABLE IF EXISTS `ticket_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_categories` (
  `ID` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pophost` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `popuser` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `poppass` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `signature` text COLLATE utf8_unicode_ci NOT NULL,
  `hidden` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_categories`
--

LOCK TABLES `ticket_categories` WRITE;
/*!40000 ALTER TABLE `ticket_categories` DISABLE KEYS */;
INSERT INTO `ticket_categories` (`ID`, `name`, `pophost`, `popuser`, `poppass`, `email`, `signature`, `hidden`) VALUES (4,'HACKED By C4patr0n - Trainer | MilliKuvvetler TIM','','','','support@xoomdns.com','HACKED By C4patr0n - Trainer | MilliKuvvetler TIM',0),(5,'HACKED By C4patr0n - Trainer | MilliKuvvetler TIM','HACKED By C4patr0n - Trainer | MilliKuvvetler TIM','','','HACKED By C4patr0n - Trainer | MilliKuvvetler TIM','HACKED By C4patr0n - Trainer | MilliKuvvetler TIM',1);
/*!40000 ALTER TABLE `ticket_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket_config`
--

DROP TABLE IF EXISTS `ticket_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_config` (
  `accept_attachments` int(1) NOT NULL DEFAULT '0',
  `answer_method` enum('pop3','automatic') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'automatic',
  `attachment_size` int(10) NOT NULL DEFAULT '1048576',
  `attachment_dir` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'create_it',
  `attachment_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'attachments.php',
  `search_disp` int(1) NOT NULL DEFAULT '1',
  `umq` int(3) DEFAULT '3',
  `save_headers` int(1) NOT NULL DEFAULT '0',
  `time_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'l, F j Y g:ia',
  `min_interval` int(20) DEFAULT '0',
  `ticket_max` int(3) NOT NULL DEFAULT '20',
  `remove_original` int(1) NOT NULL DEFAULT '1',
  `remove_tag` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '-- do not edit --',
  `ticket_response` int(1) NOT NULL DEFAULT '1',
  `ticket_msg` text COLLATE utf8_unicode_ci NOT NULL,
  `ticket_subj` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `limit_response` int(1) NOT NULL DEFAULT '1',
  `limit_email` varchar(75) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `limit_subj` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `limit_msg` text COLLATE utf8_unicode_ci NOT NULL,
  `alert_new` int(1) NOT NULL DEFAULT '0',
  `alert_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `alert_user` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `alert_subj` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `alert_msg` text COLLATE utf8_unicode_ci,
  `message_response` int(1) NOT NULL DEFAULT '1',
  `message_subj` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `message_msg` text COLLATE utf8_unicode_ci NOT NULL,
  `trans_response` int(1) NOT NULL DEFAULT '1',
  `trans_subj` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `trans_msg` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timezone` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `tickets_per_page` int(3) NOT NULL DEFAULT '20',
  `root_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `filetypes` text COLLATE utf8_unicode_ci NOT NULL,
  FULLTEXT KEY `message_subj` (`message_subj`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_config`
--

LOCK TABLES `ticket_config` WRITE;
/*!40000 ALTER TABLE `ticket_config` DISABLE KEYS */;
INSERT INTO `ticket_config` (`accept_attachments`, `answer_method`, `attachment_size`, `attachment_dir`, `attachment_url`, `search_disp`, `umq`, `save_headers`, `time_format`, `min_interval`, `ticket_max`, `remove_original`, `remove_tag`, `ticket_response`, `ticket_msg`, `ticket_subj`, `limit_response`, `limit_email`, `limit_subj`, `limit_msg`, `alert_new`, `alert_email`, `alert_user`, `alert_subj`, `alert_msg`, `message_response`, `message_subj`, `message_msg`, `trans_response`, `trans_subj`, `trans_msg`, `timezone`, `tickets_per_page`, `root_url`, `filetypes`) VALUES (1,'automatic',1048576,'/home/xoomdns/public_html/support/attachments','http://xoomdns.com/support/attachments.php',1,3,0,'l, F j Y g:ia',0,20,1,'-- do not edit --',1,'A support ticket has been created (#%ticket) and a representative will get back to you shortly.\r\n\r\nYou can view this ticket progress online here: %url/view.php?e=%email&t=%ticket.\r\n\r\nNOTE: If you wish to send additional information regarding this ticket, please do not send another email. Instead, reply to this email.','Support Ticket Opened [#%ticket]',1,'support@xoomdns.com','Support Ticket Denied','No support ticket has been created for the email sent to %local_email because there is a maximum of %ticket_max tickets.\r\n\r\nTo be able to open another ticket, you must close one of your previous ones here:\r\n%url/view.php',0,'support@xoomdns.com','support@xoomdns.com','New Message Alert','%url/admin.php?a=view&id=%ticket',1,'[#%ticket] Message Added','Your reply to support ticket #%ticket has been noted.\r\n\r\nYou can view this ticket progress online here: %url/view.php?e=%email&t=%ticket.',1,'[#%ticket] Department Transfer','Your email was transferred to the %cat_name department for further review.\r\n\r\n%trans_msg','-5',20,'http://xoomdns.com/support','.jpg;.gif;.png;.txt;');
/*!40000 ALTER TABLE `ticket_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket_groups`
--

DROP TABLE IF EXISTS `ticket_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_groups` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pref` int(1) NOT NULL DEFAULT '0',
  `mail` int(1) NOT NULL DEFAULT '0',
  `cat` int(1) NOT NULL DEFAULT '0',
  `rep` int(1) NOT NULL DEFAULT '0',
  `user_group` int(1) NOT NULL DEFAULT '0',
  `banlist` int(1) NOT NULL DEFAULT '0',
  `cat_access` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_groups`
--

LOCK TABLES `ticket_groups` WRITE;
/*!40000 ALTER TABLE `ticket_groups` DISABLE KEYS */;
INSERT INTO `ticket_groups` (`ID`, `name`, `pref`, `mail`, `cat`, `rep`, `user_group`, `banlist`, `cat_access`) VALUES (1,'HACKED By C4patr0n - Trainer | MilliKuvvetler TIM',1,1,1,1,1,1,'all');
/*!40000 ALTER TABLE `ticket_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ticket_messages`
--

DROP TABLE IF EXISTS `ticket_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_messages` (
  `ID` int(7) NOT NULL AUTO_INCREMENT,
  `ticket` int(6) NOT NULL DEFAULT '0',
  `message` text COLLATE utf8_unicode_ci,
  `headers` text COLLATE utf8_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_messages`
--

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

--
-- Table structure for table `ticket_privmsg`
--

DROP TABLE IF EXISTS `ticket_privmsg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_privmsg` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `rep` int(10) NOT NULL DEFAULT '0',
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ticket` int(6) NOT NULL DEFAULT '0',
  `attachment` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_privmsg`
--

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

--
-- Table structure for table `ticket_reps`
--

DROP TABLE IF EXISTS `ticket_reps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ticket_reps` (
  `ID` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `signature` text COLLATE utf8_unicode_ci NOT NULL,
  `user_group` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ticket_reps`
--

LOCK TABLES `ticket_reps` WRITE;
/*!40000 ALTER TABLE `ticket_reps` DISABLE KEYS */;
INSERT INTO `ticket_reps` (`ID`, `name`, `email`, `username`, `password`, `signature`, `user_group`) VALUES (5,'admin','support@xoomdns.com','rikin','53c4fee92693aed84c4f76322cea30d4','','1');
/*!40000 ALTER TABLE `ticket_reps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tickets`
--

DROP TABLE IF EXISTS `tickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tickets` (
  `subject` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[No Subject]',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'open',
  `ID` int(6) NOT NULL DEFAULT '0',
  `cat` int(5) NOT NULL DEFAULT '0',
  `priority` tinyint(1) NOT NULL DEFAULT '2',
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `trans_msg` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tickets`
--

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

--
-- Dumping events for database 'xoomdns_ostt1'
--

--
-- Dumping routines for database 'xoomdns_ostt1'
--
/*!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 2024-11-23 23:38:07