Database Table: identitymap

From Dreamwidth Notes
Revision as of 11:53, 31 March 2009 by Dreamnestia (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