Difference between revisions of "Database Table: support answers"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (Robot: Updating: Format) |
|||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=support_answers|table type=global | + | {{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 18: | ||
) | ) | ||
</source> | </source> | ||
| + | |||
{{Database Table Footer}} | {{Database Table Footer}} | ||
Revision as of 19:57, 7 December 2010
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) )
