Difference between revisions of "Database Table: reluser"
From Dreamwidth Notes
Foxfirefey (Talk | contribs) m (added to database tables category) |
|||
| Line 4: | Line 4: | ||
[[Category: Database Tables|reluser]] | [[Category: Database Tables|reluser]] | ||
| + | =Definition= | ||
| + | <source lang="sql"> | ||
| + | CREATE TABLE reluser ( | ||
| + | :userid INT UNSIGNED NOT NULL, | ||
| + | :targetid INT UNSIGNED NOT NULL, | ||
| + | :type char(1) NOT NULL, | ||
| + | :PRIMARY KEY (userid,type,targetid), | ||
| + | :KEY (targetid,type) | ||
| + | ) | ||
| + | </source> | ||
| + | |||
| + | =Relationships= | ||
| + | *Foreign key userid to [[user]].userid | ||
| + | *Foreign key targetid to [[user]].userid | ||
| + | |||
| + | Possible values of the ''type'' field are: | ||
| + | *'A' means targetid can administrate userid as a community maintainer | ||
| + | * 'B' means targetid is banned in userid | ||
| + | * 'P' means targetid can post to userid | ||
| + | * 'M' means targetid can moderate the community userid | ||
| + | * 'N' means targetid is preapproved to post to community userid w/o moderation | ||
| + | * 'I' means targetid invited userid to the site | ||
| + | |||
| + | =Location= | ||
| + | Global db | ||
Revision as of 13:39, 20 March 2009
Global. Most of the edges are stored here, since edges can cross clusters. reluser2 is the clustered database.
(Mark's explanation should go up here at some point)
Definition
CREATE TABLE reluser ( :userid INT UNSIGNED NOT NULL, :targetid INT UNSIGNED NOT NULL, :TYPE CHAR(1) NOT NULL, :PRIMARY KEY (userid,TYPE,targetid), :KEY (targetid,TYPE) )
Relationships
Possible values of the type field are:
- 'A' means targetid can administrate userid as a community maintainer
- 'B' means targetid is banned in userid
- 'P' means targetid can post to userid
- 'M' means targetid can moderate the community userid
- 'N' means targetid is preapproved to post to community userid w/o moderation
- 'I' means targetid invited userid to the site
Location
Global db
