Difference between revisions of "Database Table: identitymap"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Changing Category:Database Tables)
Line 19: Line 19:
 
[[Global database]]
 
[[Global database]]
  
[[Category: Database Tables|identitymap]]
+
[[Category:Database Tables Needing Conversion|identitymap]]

Revision as of 14:02, 2 October 2009

Definition

CREATE TABLE identitymap (
  idtype    CHAR(1) NOT NULL,
  IDENTITY  VARCHAR(255) BINARY NOT NULL,
  userid    INT UNSIGNED NOT NULL,
  PRIMARY KEY  (idtype, IDENTITY),
  KEY          userid (userid)
)

Relationships

Foreign key userid to user.userid

Location

Global database