Difference between revisions of "Database Table: content flag"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
|||
| Line 1: | Line 1: | ||
This table supports a content-flagging feature that is not currently enabled in DreamWidth. | This table supports a content-flagging feature that is not currently enabled in DreamWidth. | ||
| − | + | = Definition = | |
| − | =Definition= | + | |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE content_flag ( | CREATE TABLE content_flag ( | ||
| Line 24: | Line 24: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
| + | = Location = | ||
| − | |||
[[Global database]] | [[Global database]] | ||
| + | |||
| + | [[Category: Database Tables|content_flag]] | ||
Revision as of 10:57, 31 March 2009
This table supports a content-flagging feature that is not currently enabled in DreamWidth.
Definition
CREATE TABLE content_flag ( flagid INT UNSIGNED NOT NULL AUTO_INCREMENT, journalid INT UNSIGNED NOT NULL, typeid TINYINT UNSIGNED NOT NULL, itemid INT UNSIGNED, catid TINYINT UNSIGNED NOT NULL, reporterid INT UNSIGNED NOT NULL, reporteruniq VARCHAR(15), instime INT UNSIGNED NOT NULL, modtime INT UNSIGNED NOT NULL, STATUS CHAR(1), PRIMARY KEY (flagid), INDEX (journalid, typeid, itemid), INDEX (instime), INDEX (reporterid), INDEX (STATUS) )
