Difference between revisions of "Database Table: support answers"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (Robot: Updating: Format) |
Exor674Bot (Talk | contribs) m (Robot: Updating: Format) |
||
| (One intermediate revision by one other user not shown) | |||
| 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"> | ||
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) )
