Difference between revisions of "Database Table: content flag"

From Dreamwidth Notes
Jump to: navigation, search
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
This table supports a content-flagging feature that is not currently enabled in DreamWidth.
+
{{Database Table|name=content_flag|table type=global|repo=dw-free|removed=1|removed in=7532a74af098}}
 
+
[[description::This table supports a content-flagging feature that is not enabled in DreamWidth.]]
 +
Removed in [http://bugs.dwscoalition.org/show_bug.cgi?id=599 bug 599]
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE content_flag (
 
CREATE TABLE content_flag (
Line 23: Line 23:
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer|removed=1}}
= Relationships =
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|content_flag]]
+

Latest revision as of 16:23, 22 July 2010

Note: This table is removed and no longer used. This table was removed in dw-free changeset 7532a74af098 [1]
This is a global table. This table supports a content-flagging feature that is not enabled in DreamWidth. Removed in bug 599

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