Database Table: identitymap

From Dreamwidth Notes
Revision as of 23:54, 21 March 2009 by SlowSculpture (Talk | contribs)

Jump to: navigation, search

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