Database Table: identitymap

From Dreamwidth Notes
Revision as of 23:53, 4 October 2009 by Exor674 (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

Outgoing

  • Foreign key: userid to user.userid