search

tvallotton / rocket_auth

An implementation for an authentication API for Rocket applications.
https://docs.rs/rocket_auth/
Apache License 2.0
73 stars 38 forks source link

Use "AUTOINCREMENT" for user table primary key #53

Open yzernik opened 2 years ago

yzernik commented 2 years ago

I noticed in my app that after I delete a user, when I create a new user, the new user has the same id as the deleted user.

This behavior is not expected. It can be avoided if this line is changed to include AUTOINCREMENT: https://github.com/tvallotton/rocket_auth/blob/ef445dfe22c6738e95c21f5710f85ab1136bdb06/src/db/sqlite/sql.rs#L3