Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add UID for Account #1413

Open
MV-GH opened this issue Feb 26, 2024 · 2 comments
Open

Add UID for Account #1413

MV-GH opened this issue Feb 26, 2024 · 2 comments
Labels
enhancement New feature or request

Comments

@MV-GH
Copy link
Collaborator

MV-GH commented Feb 26, 2024

Currently we use the id of of the user as unique account identifier. Here in lays the problem, this account id is not unique across instances. Meaning it is possible that user A from instance IA has the same ID as user B from IB.

Thus instead we should add a UID (incremental) as primary and drop the unique constraint for id.

Suggestions for naming of this column? iid, uid, sid..

@MV-GH MV-GH added the enhancement New feature or request label Feb 26, 2024
@dessalines
Copy link
Member

Any of those work for me. We'll probably have to copy and rebuild the table in a migration.

@MV-GH
Copy link
Collaborator Author

MV-GH commented Feb 27, 2024

Yeah I'll pick this up once I do some changes to the db schema

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants