heya! peeps, give me the power~ can i use user_id as bigInteger without useridmapping?

Hey @tomita0022 not really. You will have to use the user id mapping feature for it.

thank you. @rp then i have to migrate original user data into supertokens, original ones use bigInteger, also has autoincrement. In useridmapping, can i do make external_id to be autoincrement?

You can set the extranal user id to anything you like. Its set via an api call you make, so when you make the api call, you can set it to anything that time

so you mean, i have to make api call to set external user_id for useridmapping? my objective is to remove user table in origin server, so i have to remain origin user_id for previous app logic and it has to be autoincremented by itself when i insert a record.

so you can maintain a counter of sorts somewhere and use that as the source of the next external user id when calling the API to map the supertokens user id to the external one

um,, that's what i thought.

happy to help 🙂

it's me again, sorry to disturb u. is it okay if i maintain the counter of sorts in

key_value

table?

i would advice against that. You want to maintain a counter somewhere in your own schema / table.

why's that?

Cause we may change the schema in future versions and then it would cause migration issues for you

umm..i got it, thanks for your help.