GitHub user Neilk1021 added a comment to the discussion: Proposal - Migrating 
User Authentication to a new table to support multiple log-in sources.

> Can you propose how to design the new relations and how to migrate to the new 
> design? 

- Every `auth_provider` role is defined by a primary key of its `provider_type` 
and its `uid`.
- Migration is relatively clean as `googleId` and `password` are both migrated 
to auth_provider with respective `LOCAL` and `GOOGLE` specifications for their 
`provider_type`. 
- The field`google_avatar` can be easily migrated to a generic avatar as 
currently it just holds an image link. 
- The field`created_at` in the new auth_provider field I believe should be 
migrated from the `account_creation_time` of the previous user, or we let the 
field be `NULL`.

GitHub link: 
https://github.com/apache/texera/discussions/6716#discussioncomment-17803628

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to