Difference between revisions of "Database Table: community"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (Robot: Updating: Format, definition) |
|||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=community| | + | {{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.]] | ||
| − | |||
= Definition = | = Definition = | ||
| − | |||
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE community ( | 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) | ||
) | ) | ||
</source> | </source> | ||
{{Database Table Footer}} | {{Database Table Footer}} | ||
Revision as of 07:02, 28 January 2010
"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a global table. 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) )
