dodobrands / WebAuthn.Net

WebAuthn (Passkeys) library for .NET.
MIT License
149 stars 2 forks source link

Improve sql #6

Closed vanbukin closed 5 months ago

vanbukin commented 5 months ago

For all databases, a missing unique index has been added to the CredentialId and RpId columns. The unique index previously existing on the columns RpId, UserHandle, and CredentialId has been deleted. Instead, a new unique index with a different column order has been created. More selective columns have been moved to the beginning of the composite index. SQL queries have been reworked in accordance with changes in the indexes. .NET dependencies have been updated.