supportnotify — Global. Stores user subscriptions to Support request categories for e-mail notification of new requests.
| 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 |