Database Table: community

From Dreamwidth Notes
Revision as of 00:19, 5 October 2009 by Exor674 (Talk | contribs)

Jump to: navigation, search

Some subquery has no valid condition. This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community.

Definition

CREATE TABLE community (
  userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  ownerid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  membership enum('open','closed') NOT NULL DEFAULT 'open',
  postlevel enum('members','select','screened') DEFAULT NULL,
  PRIMARY KEY  (userid)
)

Template:Database Tabel Footer