Difference between revisions of "Database Table: support answers"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating: Format)
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
{{Database Table|name=support_answers|table type=global|repo=dw-free}}
 +
[[Description::This table stores stock answers for the Support system.]] Answers are viewable by those with the '''supporthelp''' [[Privileges|priv]], and are editable by people who have the ability to grant privileges in their category.
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE support_answers (
 
CREATE TABLE support_answers (
Line 14: Line 15:
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer}}
= Relationships =
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|support_answers]]
+

Latest revision as of 20:18, 11 May 2011

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