--
-- Host: localhost    Database: xoomdns_ostt1
-- ------------------------------------------------------


--
-- Current Database: `xoomdns_ostt1`
--


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

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;

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


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

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;

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


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

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;

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

INSERT INTO `ticket_banlist` (`value_id`, `value`) VALUES (1,'mailer-daemon'),(2,'Mail Delivery Subsystem'),(3,'Mail Delivery System');

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

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;

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

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);

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

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;

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

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;');

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

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;

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

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');

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

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;

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


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

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;

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


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

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;

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


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

--
-- Dumping routines for database 'xoomdns_ostt1'
--


