Difference between revisions of "Database Table: community"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
|||
| Line 1: | Line 1: | ||
| − | This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community. | + | {{#ask: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.]] | ||
= Definition = | = Definition = | ||
| Line 12: | Line 13: | ||
) | ) | ||
</source> | </source> | ||
| − | + | {{Database Tabel Footer}} | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 00:19, 5 October 2009
Some subquery has no valid condition. 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) )
