Support Tickets Table

[alexillsley]

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

[till]

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

[alexillsley]

Thanks till it fixed it!