Database Table: content_filters

From Dreamwidth Notes
Revision as of 12:47, 27 January 2010 by Exor674 (Talk | contribs)

Jump to: navigation, search

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a clustered table.

Definition

CREATE TABLE content_filters (
  userid INT(10) UNSIGNED NOT NULL,
  filterid INT(10) UNSIGNED NOT NULL,
  filtername VARCHAR(255) NOT NULL,
  is_public enum('0','1') NOT NULL DEFAULT '0',
  sortorder SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
 
  PRIMARY KEY (userid,filterid),
  UNIQUE KEY userid (userid,filtername)
)

Relationships