Differential D8344 Diff 19854 resources/sql/patches/002.oauth.sql

Changeset View

Standalone View

	Show All 9 Lines
	);			);

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

	alter table {$NAMESPACE}_user.user drop facebookUID;			alter table {$NAMESPACE}_user.user drop facebookUID;
	No newline at end of file