Difference between revisions of "Database Table: reluser"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
 
(9 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Global. Most of the edges are stored here, since edges can cross clusters. [[Database Tables: reluser2|reluser2]] is the clustered database.
+
{{Database Table|name=reluser|table type=global|repo=dw-free}}
 +
Global. [[Description::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.
  
(Mark's explanation should go up here at some point)
+
{{Expand|text=Mark's explanation should go up here at some point.}}
 
+
= Definition =
[[Category: Database Tables|reluser]]
+
=Definition=
+
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE reluser (
 
CREATE TABLE reluser (
:userid    INT UNSIGNED NOT NULL,
+
    userid    INT UNSIGNED NOT NULL,
:targetid  INT UNSIGNED NOT NULL,
+
    targetid  INT UNSIGNED NOT NULL,
:type      char(1) NOT NULL,
+
    type      char(1) NOT NULL,
:PRIMARY KEY (userid,type,targetid),
+
    PRIMARY KEY (userid,type,targetid),
:KEY (targetid,type)
+
    KEY (targetid,type)
 
)
 
)
 
</source>
 
</source>
 +
Possible values of the <tt>type</tt> field are:
  
=Relationships=
+
* 'A' means <tt>targetid</tt> can administrate <tt>userid</tt> as a community maintainer
*Foreign key  userid to [[user]].userid
+
* 'B' means <tt>targetid</tt> is banned in <tt>userid</tt>
*Foreign key targetid to [[user]].userid
+
* 'P' means <tt>targetid</tt> can post to <tt>userid</tt>
 
+
* 'M' means <tt>targetid</tt> can moderate the community <tt>userid</tt>
Possible values of the ''type'' field are:
+
* 'N' means <tt>targetid</tt> is preapproved to post to community <tt>userid</tt> without moderation
*'A' means targetid can administrate userid as a community maintainer
+
* 'I' means <tt>targetid</tt> invited <tt>userid</tt> to the site
* 'B' means targetid is banned in userid
+
{{Database Table Footer}}
* '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
+

Latest revision as of 15:56, 22 July 2010

This is a global table. 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)
)

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

Relationships

Outgoing

  • Foreign key: targetid to user.userid
  • Foreign key: userid to user.userid