CREATE TABLE `cp_servicedesk` (
 `ticket_id` int(6) NOT NULL AUTO_INCREMENT,
 `account_id` int(7) NOT NULL,
 `category` int(6) NOT NULL,
 `status` varchar(14) NOT NULL DEFAULT 'New Ticket',
 `char_id` text NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `sslink` text NOT NULL,
 `chatlink` text NOT NULL,
 `videolink` text NOT NULL,
 `subject` varchar(64) NOT NULL DEFAULT '0',
 `text` text NOT NULL,
 `ip` varchar(15) NOT NULL DEFAULT '0',
 `team` int(1) NOT NULL DEFAULT '1',
 `curemail` text NOT NULL,
 `lastreply` varchar(24) NOT NULL DEFAULT '0',
 PRIMARY KEY (`ticket_id`)
) ENGINE=MyIsam AUTO_INCREMENT=1235 DEFAULT CHARSET=latin1

CREATE TABLE `cp_servicedeska` (
 `action_id` int(6) NOT NULL AUTO_INCREMENT,
 `ticket_id` int(6) NOT NULL,
 `author` varchar(32) NOT NULL,
 `text` text NOT NULL,
 `action` text NOT NULL,
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `ip` varchar(15) NOT NULL DEFAULT '0',
 `isstaff` int(1) NOT NULL DEFAULT '0',
 PRIMARY KEY (`action_id`)
) ENGINE=MyIsam AUTO_INCREMENT=721 DEFAULT CHARSET=latin1

CREATE TABLE `cp_servicedeskcat` (
 `cat_id` int(3) NOT NULL AUTO_INCREMENT,
 `name` varchar(40) NOT NULL,
 `display` int(1) NOT NULL DEFAULT '1',
 PRIMARY KEY (`cat_id`)
) ENGINE=MyIsam AUTO_INCREMENT=10 DEFAULT CHARSET=latin1

CREATE TABLE `cp_servicedesksettings` (
 `account_id` int(7) NOT NULL,
 `account_name` varchar(32) NOT NULL,
 `prefered_name` varchar(32) NOT NULL,
 `team` int(1) NOT NULL,
 `emailalerts` int(1) NOT NULL DEFAULT '0',
 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`account_id`)
) ENGINE=MyIsam DEFAULT CHARSET=latin1