20130417.externalaccount.sql
No OneTemporary
Actions

Size

558 B

Referenced Files

None

Subscribers

None

20130417.externalaccount.sql
View Options

	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;