supabase / gotrue / 6936436453

65%

Build Type

push

github

Committed by web-flow

Commit Message

feat: update primary key for identities table (#1311)

## What kind of change does this PR introduce?
* We need to be able to have a consistent identifier to fetch an
identity from the database. The current approach for using a composite
primary key isn't sufficient and not ideal for exposing through the API.
* Remove the composite primary key on (`auth.identities.id`,
`auth.identities.provider`)
* Rename `auth.identities.id` to `auth.identities.provider_id`
* Add a new primary key called `auth.identities.id` 
* Add a unique constraint on (`auth.identities.provider_id`,
`auth.identities.provider`)

---------

Co-authored-by: Stojan Dimitrovski <sdimitrovski@gmail.com>

Run Details

8 of 8 new or added lines in 2 files covered. (100.0%)

1 existing line in 1 file now uncovered.

7597 of 11538 relevant lines covered (65.84%)

54.47 hits per line