faq — Holds Frequently Asked Question information for the FAQ section of the support system. Alternate text can be loaded for the questions if available.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| faqid | mediumint unsigned auto_increment | The unique id number of the FAQ. | ||
| question | text | YES | The question text, in plaintext. | |
| answer | text | YES | The answer text, in plaintext. | |
| sortorder | int | YES | The sorting number the questions are ordered by. Used while SELECT'ing them. | |
| faqcat | varchar(20) | YES | The name of the main category the FAQ item belongs to. Is the index to faqcat | |
| uses | int | 0 | ||
| lastmodtime | datetime | YES | The date the FAQ item was last modified. | |
| lastmoduserid | int unsigned | 0 | The userid of the user who last modified the FAQ item. |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY |