Difference between revisions of "Database Table: reluser2"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
Exor674Bot (Talk | contribs) m (Robot: Changing Category:Database Tables) |
||
| Line 24: | Line 24: | ||
[[Clustered database]] | [[Clustered database]] | ||
| − | [[Category: Database Tables|reluser2]] | + | [[Category:Database Tables Needing Conversion|reluser2]] |
Revision as of 14:05, 2 October 2009
User-space (clustered) relationships table. Only used for 'hide this comm from my profile page'. 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.
