[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_user.externalaccount (
   2    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    phid VARCHAR(64) COLLATE utf8_bin NOT NULL UNIQUE KEY,
   4    userPHID VARCHAR(64) COLLATE utf8_bin,
   5    accountType VARCHAR(16) COLLATE utf8_bin NOT NULL,
   6    accountDomain VARCHAR(64) COLLATE utf8_bin,
   7    accountSecret LONGTEXT COLLATE utf8_bin,
   8    accountID VARCHAR(160) COLLATE utf8_bin NOT NULL,
   9    displayName VARCHAR(256) COLLATE utf8_bin NOT NULL,
  10    UNIQUE KEY `account_details` (accountType, accountDomain, accountID)
  11  )ENGINE=InnoDB DEFAULT CHARSET=utf8;