Database Table: support_answers

From Dreamwidth Notes
Revision as of 19:57, 7 December 2010 by Xtina (Talk | contribs)

Jump to: navigation, search

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)
)

Relationships