support

support — Global. Stores data for the Support system. Allows users with the supporthelp priv to see links to support/history.bml, when viewing a Support request, where they can pull up a list of all past requests opened by that user or by that e-mail address.

support

Column name Type Null Default Description
spid int unsigned auto_increment    
reqtype enum('user','email') YES  
requserid int unsigned   0  
reqname varchar(50) YES  
reqemail varchar(70) YES  
state enum('open','closed') YES  
authcode varchar(15)    
spcatid int unsigned   0  
subject varchar(80) YES  
timecreate int unsigned YES  
timetouched int unsigned YES  
timeclosed int unsigned YES  
timelasthelp int unsigned YES  
Key name Type Column(s)
PRIMARY PRIMARY
reqemail INDEX
requserid INDEX
state INDEX