Viewing File: /home/ubuntu/code-backup/code_review/phabricator/resources/sql/patches/20130417.externalaccount.sql

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