Difference between revisions of "Database Table: content filters"

From Dreamwidth Notes
Jump to: navigation, search
m (Created page with '{{Database Table|name=content_filters|table type=global}} Category:Database Tables Needing Description = Definition = <source lang="sql"> CREATE TABLE content_filters ( us…')
(No difference)

Revision as of 12:32, 27 January 2010

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a global 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