Possible to Use Bigint as UserID in MySQL DB?

Is it possible to use a bigint instead of an int for user id in MySQL?

It’s not that I expect to have more users than the int can store. But instead, I’d like to have a bigint as ID to match my other software database tables that use bigint as an user id type.

Changing the table column type is easy in MySQL, but I’m concerned that if I do change it, something might break in the WordPress PHP code.

Anyone have experience or has a sense if changing from an int to bigint would cause significant problems?

Thanks for any insight.

• This topic was modified 6 years, 4 months ago by Jan Dembowski.