Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th December 2006, 02:39
alexillsley alexillsley is offline
Senior Member
 
Join Date: Dec 2006
Posts: 396
Thanks: 27
Thanked 4 Times in 4 Posts
Default Support Tickets Table

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
Reply With Quote
Sponsored Links
  #2  
Old 26th December 2006, 17:48
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

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`)
);
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 26th December 2006, 20:13
alexillsley alexillsley is offline
Senior Member
 
Join Date: Dec 2006
Posts: 396
Thanks: 27
Thanked 4 Times in 4 Posts
 
Default

Thanks till it fixed it!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR: The PHP binary coming with ISPConfig does not work properly on your system! micko_escalade Installation/Configuration 35 30th March 2007 12:31
Ispconfig update problems from 2.4 to 2.6 adrenalinic Installation/Configuration 23 7th September 2006 13:58
Problem with BIND and ISPConfigs's DNS Manager Nejko Installation/Configuration 66 22nd April 2006 21:47
setup fails on debian 3.1 dtrumbower Installation/Configuration 7 7th March 2006 14:42
ISPConfig Failure on SuSe 9.3 gimhan90 Installation/Configuration 13 2nd February 2006 11:29


All times are GMT +2. The time now is 03:04.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.