Hello, I accidently deleted the support tickets table from the database please if possible could you tell me the collums in the table help_tickets or the sql to create the help_tickets table? Happy Christmas, Alex
Here is the SQL code for the help_tickets table: CREATE TABLE `help_tickets` ( `doc_id` bigint(20) unsigned NOT NULL auto_increment, `ticket_from` bigint(20) unsigned default NULL, `ticket_to` bigint(20) unsigned default NULL, `ticket_status` char(1) default NULL, `ticket_reply` bigint(20) unsigned default NULL, `ticket_urgency` char(1) default NULL, `ticket_date` datetime default NULL, `ticket_subject` varchar(255) default NULL, `ticket_message` text, PRIMARY KEY (`doc_id`), KEY `ticket_from` (`ticket_from`), KEY `ticket_to` (`ticket_to`), KEY `ticket_status` (`ticket_status`) );