Difference between revisions of "Database Table: community"
From Dreamwidth Notes
m (Lol..) |
|||
| Line 1: | Line 1: | ||
| − | {{# | + | {{#set: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.]] | ||
| Line 13: | Line 13: | ||
) | ) | ||
</source> | </source> | ||
| − | {{Database | + | {{Database Table Footer}} |
Revision as of 00:20, 5 October 2009
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) )
