Files F18454190

002.oauth.sql
No OneTemporary
Actions

Size

665 B

Referenced Files

None

Subscribers

None

002.oauth.sql
View Options

	create table {$NAMESPACE}_user.user_oauthinfo (
	id int unsigned not null auto_increment primary key,
	userID int unsigned not null,
	oauthProvider varchar(255) not null,
	oauthUID varchar(255) not null,
	unique key (userID, oauthProvider),
	unique key (oauthProvider, oauthUID),
	dateCreated int unsigned not null,
	dateModified int unsigned not null
	);

	insert into {$NAMESPACE}_user.user_oauthinfo
	(userID, oauthProvider, oauthUID, dateCreated, dateModified)
	SELECT id, 'facebook', facebookUID, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
	FROM {$NAMESPACE}_user.user
	WHERE facebookUID is not null;

	alter table {$NAMESPACE}_user.user drop facebookUID;

File Metadata

Mime Type: text/plain
Expires: Tue, May 26, 10:06 PM (1 d, 18 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1551426
Default Alt Text: 002.oauth.sql (665 B)

Event Timeline