Difference between revisions of "Database Table: community"

From Dreamwidth Notes
Jump to: navigation, search
m (Lol..)
Line 1: Line 1:
{{#set:name=community|Table type=global}}
+
{{Database Table|name=community|Table type=global}}
 
[[Description::This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community.]]
 
[[Description::This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community.]]
  

Revision as of 12:30, 27 January 2010

  • "{{{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