Difference between revisions of "Database Table: reluser"
From Dreamwidth Notes
Foxfirefey (Talk | contribs) m (reformat) |
|||
| Line 1: | Line 1: | ||
| − | Global. Stores information about permissions for users to post to journals other than their own, such as community memberships, mod privileges and bans. Most of the edges are stored here, since edges can cross clusters. | + | Global. Stores information about permissions for users to post to journals other than their own, such as community memberships, mod privileges and bans. Most of the edges are stored here, since edges can cross clusters. {{DBTable|reluser2}} stores related information in the clustered database. |
| − | + | {{Expand|text=Mark's explanation should go up here at some point.}} | |
| + | |||
| + | |||
| + | = Definition = | ||
| − | |||
| − | |||
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE reluser ( | CREATE TABLE reluser ( | ||
| Line 16: | Line 17: | ||
=Relationships= | =Relationships= | ||
| − | |||
| − | |||
| − | + | * Foreign key <tt>userid</tt> to {{DBField|user|userid}} | |
| − | * | + | * Foreign key <tt>targetid</tt> to {{DBField|user|userid}} |
| − | + | ||
| − | + | ||
| − | * | + | |
| − | + | ||
| − | + | ||
| − | =Location= | + | Possible values of the <tt>type</tt> field are: |
| − | Global | + | |
| + | * 'A' means <tt>targetid</tt> can administrate <tt>userid</tt> as a community maintainer | ||
| + | * 'B' means <tt>targetid</tt> is banned in <tt>userid</tt> | ||
| + | * 'P' means <tt>targetid</tt> can post to <tt>userid</tt> | ||
| + | * 'M' means <tt>targetid</tt> can moderate the community <tt>userid</tt> | ||
| + | * 'N' means <tt>targetid</tt> is preapproved to post to community <tt>userid</tt> without moderation | ||
| + | * 'I' means <tt>targetid</tt> invited <tt>userid</tt> to the site | ||
| + | |||
| + | = Location = | ||
| + | |||
| + | [[Global database]] | ||
| + | |||
| + | [[Category: Database Tables|reluser]] | ||
Revision as of 20:37, 26 March 2009
Global. Stores information about permissions for users to post to journals other than their own, such as community memberships, mod privileges and bans. Most of the edges are stored here, since edges can cross clusters. reluser2 stores related information in the clustered database.
Expand: 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 without moderation
- 'I' means targetid invited userid to the site
