jerboa icon indicating copy to clipboard operation
jerboa copied to clipboard

Add UID for Account

Open MV-GH opened this issue 11 months ago • 2 comments

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 avatar Feb 26 '24 23:02 MV-GH

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

dessalines avatar Feb 27 '24 02:02 dessalines

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

MV-GH avatar Feb 27 '24 07:02 MV-GH