Database Table: content_flag

From Dreamwidth Notes
Revision as of 04:07, 30 January 2010 by Exor674 (Talk | contribs)

Jump to: navigation, search

Note: This table is removed and no longer used.
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)
)