Difference between revisions of "Database Table: reluser"

From Dreamwidth Notes
Jump to: navigation, search
Line 1: Line 1:
Global. Stores information about permissions for users to post to journals other than their own. Most of the edges are stored here, since edges can cross clusters. [[Database Tables: reluser2|reluser2]] stores related information in the clustered database.
+
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. [[Database Tables: reluser2|reluser2]] stores related information in the clustered database.
  
 
(Mark's explanation should go up here at some point)
 
(Mark's explanation should go up here at some point)
Line 16: Line 16:
  
 
=Relationships=
 
=Relationships=
*Foreign key  userid to [[user]].userid
+
*Foreign key  userid to [[Database Table: user| user]].userid
*Foreign key targetid to [[user]].userid
+
*Foreign key targetid to [[Database Table: user| user]].userid
  
 
Possible values of the ''type'' field are:
 
Possible values of the ''type'' field are:

Revision as of 00:38, 21 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.

(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

  • 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