Database Table: support_answers

This is a global table. This table stores stock answers for the Support system. Answers are viewable by those with the supporthelp priv, and are editable by people who have the ability to grant privileges in their category.

Definition

CREATE TABLE support_answers (
    ansid INT UNSIGNED NOT NULL,
    spcatid INT UNSIGNED NOT NULL,
    lastmodtime INT UNSIGNED NOT NULL,
    lastmoduserid INT UNSIGNED NOT NULL,
    subject VARCHAR(255),
    body TEXT,
 
    PRIMARY KEY (ansid),
    KEY         (spcatid)
)