Difference between revisions of "Database Table: community"
From Dreamwidth Notes
(Created page with ' community =Definition= <source lang="sql"> CREATE TABLE community ( userid int(10) unsigned NOT NULL default '0', ownerid int(10) unsigned NOT N...') |
|||
| 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. | ||
[[Category: Database Table|community]] | [[Category: Database Table|community]] | ||
Revision as of 02:04, 21 March 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) )
Relationships
Location
Global db
