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

