Difference between revisions of "Database Table: community"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
||
Line 22: | Line 22: | ||
[[Global database]] | [[Global database]] | ||
− | [[Category: Database Tables|community]] | + | [[Category:Database Tables Needing Conversion|community]] |
Revision as of 14:01, 2 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) )