Difference between revisions of "Database Table: community"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) (Robot: Updating: Format, definition) |
Exor674Bot (Talk | contribs) (Robot: Updating: Format) |
||
| Line 1: | Line 1: | ||
| − | {{Database Table|name=community|table type=global}} | + | {{Database Table|name=community|table type=global|repo=dw-free}} |
[[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 = | ||
Latest revision as of 15:55, 22 July 2010
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) )
