Difference between revisions of "Database Table: reluser2"
From Dreamwidth Notes
(Created page with 'Stores information about community memberships. This is in the clustered database; reluser stores related information in the global database. [[Cate...') |
|||
| Line 10: | Line 10: | ||
:PRIMARY KEY (userid,type,targetid), | :PRIMARY KEY (userid,type,targetid), | ||
:KEY (targetid,type) | :KEY (targetid,type) | ||
| − | |||
) | ) | ||
</source> | </source> | ||
Revision as of 14:07, 20 March 2009
Stores information about community memberships. This is in the clustered database; reluser stores related information in the global database.
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 type are defined in get_reluser_id, in ljrelation.pl. Note that this does not take the same values as the char(1) type field in reluser.
Location
Clustered db
