Database Table: community

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

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

Relationships

Outgoing

• Foreign key: ownerid to user.userid
• Foreign key: userid to user.userid