Support Tickets Table

Discussion in 'General' started by alexillsley, Dec 26, 2006.

  1. alexillsley

    alexillsley New Member

    Hello,
    I accidently deleted the support tickets table from the database:eek: 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
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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`)
    );
     
  3. alexillsley

    alexillsley New Member

    Thanks till it fixed it!:)
     

Share This Page