Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/002.oauth.sql
| 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 | |||||