supportnotify

supportnotify — Global. Stores user subscriptions to Support request categories for e-mail notification of new requests.

supportnotify

Column name Type Null Default Description
spcatid int unsigned   0  
userid int unsigned   0 The userid of the subscribing user.
level enum('all','new') YES Either "all" for user to get notifications and then a copy of each comment/solution posted, or "new" for user to get notifications when a new Support request in that category is posted.
Key name Type Column(s)
PRIMARY PRIMARY
spcatid INDEX
userid INDEX