--
-- Table structure for table `tdp_banfilters`
--

CREATE TABLE `tdp_banfilters` (
  `id` tinyint(1) NOT NULL auto_increment,
  `ipaddress` mediumtext NOT NULL,
  `emails` mediumtext NOT NULL,
  `words` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=2 ;

--
-- Dumping data for table 'tdp_banfilters'
--

INSERT INTO tdp_banfilters (id, ipaddress, emails, words) VALUES(1, '', '', 'viagra,medical,pills,watches');

-- --------------------------------------------------------

--
-- Table structure for table `tdp_departments`
--

CREATE TABLE `tdp_departments` (
  `id` int(8) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM  AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Table structure for table `tdp_dept_assign`
--

CREATE TABLE `tdp_dept_assign` (
  `id` int(7) NOT NULL auto_increment,
  `userID` int(7) NOT NULL default '0',
  `deptID` int(7) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=34 ;

-- --------------------------------------------------------

--
-- Table structure for table `tdp_kbase`
--

CREATE TABLE `tdp_kbase` (
  `id` int(8) NOT NULL auto_increment,
  `question` mediumtext NOT NULL,
  `answer` mediumtext NOT NULL,
  `department` int(3) NOT NULL default '0',
  `adddate` timestamp NOT NULL,
  `filterdate` date default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=42 ;

-- --------------------------------------------------------

--
-- Table structure for table `tdp_replies`
--

CREATE TABLE `tdp_replies` (
  `id` int(8) NOT NULL auto_increment,
  `ticketid` varchar(6) NOT NULL default '',
  `name` varchar(150) NOT NULL default '',
  `comments` mediumtext NOT NULL,
  `posttime` datetime default NULL,
  `postdate` varchar(30) NOT NULL default '',
  `responsetime` varchar(75) NOT NULL default '',
  `adminreply` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=1039 ;

-- --------------------------------------------------------

--
-- Table structure for table `tdp_responses`
--

CREATE TABLE `tdp_responses` (
  `id` int(8) NOT NULL auto_increment,
  `question` mediumtext NOT NULL,
  `answer` mediumtext NOT NULL,
  `adddate` timestamp NOT NULL,
  `filterdate` date default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=42 ;

-- --------------------------------------------------------

--
-- Table structure for table `tdp_settings`
--

CREATE TABLE `tdp_settings` (
  `id` tinyint(1) NOT NULL auto_increment,
  `website` varchar(150) NOT NULL default '',
  `email` varchar(250) NOT NULL default '',
  `script_path` varchar(250) NOT NULL default '',
  `language` varchar(25) NOT NULL default 'english.php',
  `dateformat` varchar(20) NOT NULL default 'D j M Y, G:ia',
  `exampledate` timestamp NOT NULL,
  `kbase` enum('0','1') NOT NULL default '0',
  `attachment` enum('0','1') NOT NULL default '0',
  `auto_zip` enum('0','1') NOT NULL default '0',
  `filetypes` text NOT NULL,
  `maxsize` int(10) NOT NULL default '200',
  `enablelive` enum('0','1') NOT NULL default '0',
  `liverefresh` tinyint(2) NOT NULL default '2',
  `timeout` tinyint(2) NOT NULL default '2',
  `enCaptcha` enum('0','1') NOT NULL default '1',
  `enLiveCaptcha` enum('0','1') NOT NULL default '1',
  `timeOffset` char(3) NOT NULL default '0',
  `autoClose` int(5) NOT NULL default '0',
  `banFilters` enum('0','1') NOT NULL default '0',
  `smtp` enum('0','1') NOT NULL default '0',
  `smtp_host` varchar(100) NOT NULL default 'localhost',
  `smtp_user` varchar(100) NOT NULL default '',
  `smtp_pass` varchar(100) NOT NULL default '',
  `smtp_port` varchar(100) NOT NULL default '25',
  `affiliateURL` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=2 ;

--
-- Dumping data for table 'tdp_settings'
--

INSERT INTO tdp_settings (id, website, email, script_path, language, dateformat, exampledate, kbase, attachment, auto_zip, filetypes, maxsize, enablelive, liverefresh, timeout, enCaptcha, enLiveCaptcha, timeOffset, autoClose, banFilters, smtp, smtp_host, smtp_user, smtp_pass, smtp_port, affiliateURL) VALUES(1, 'Your Website', 'reply@yoursite.com', 'http://www.yoursite.com/helpdesk', 'english.php', 'D j M Y, G:ia', '', '1', '0', '0', '.jpg|.gif|.doc', 200, '0', 2, 6, '1', '0', '0', 0, '0', '0', 'localhost', '', '', '25','');

-- --------------------------------------------------------

--
-- Table structure for table `tdp_tickets`
--

CREATE TABLE `tdp_tickets` (
  `id` int(8) NOT NULL auto_increment,
  `ticketid` varchar(6) NOT NULL default '',
  `department` varchar(100) NOT NULL default '',
  `deptid` int(3) NOT NULL default '0',
  `name` varchar(150) NOT NULL default '',
  `email` varchar(250) NOT NULL default '',
  `subject` varchar(200) NOT NULL default '',
  `comments` mediumtext NOT NULL,
  `priority` enum('1','2','3') NOT NULL default '1',
  `attachstatus` enum('0','1') NOT NULL default '0',
  `attachfile` varchar(200) NOT NULL default '',
  `ticketdate` datetime default NULL,
  `postdate` varchar(30) NOT NULL default '',
  `responder` enum('0','1') NOT NULL default '0',
  `filterdate` date default NULL,
  `status` enum('0','1') NOT NULL default '0',
  `permaClose` enum('0','1') NOT NULL default '0',
  `created` enum('0','1') NOT NULL default '0',
  `ip` varchar(20) NOT NULL default '',
  `livesupport` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=511 ;

-- --------------------------------------------------------

--
-- Table structure for table `tdp_users`
--

CREATE TABLE `tdp_users` (
  `id` int(8) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `email` varchar(250) NOT NULL default '',
  `accpass` varchar(32) NOT NULL default '',
  `department` int(5) NOT NULL default '0',
  `admintype` varchar(5) NOT NULL default '',
  `livesupport` enum('0','1') NOT NULL default '0',
  `signature` text NOT NULL,
  `notify` enum('0','1') NOT NULL default '0',
  `date` date default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM  AUTO_INCREMENT=6 ;

--
-- Dumping data for table 'tdp_users'
--

INSERT INTO tdp_users (id, name, email, accpass, department, admintype, livesupport, signature, notify, date) VALUES(1, 'Your Name', 'you@yoursite.com', '21232f297a57a5a743894a0e4a801fc3', 0, 'admin', '0', '', '1', now());