Difference between revisions of "Database Table: community"
From Dreamwidth Notes
m (Lol..) |
|||
| Line 1: | Line 1: | ||
| − | {{ | + | {{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) )
