really random question here guys, do you have any idea how I would implement an auto-incrementing field for each new user that's 5 digits long? for instance row 1 would have the field as 00001, next would be 00002, and so forth. any help is appreciated

This can be achieved by creating a function and setting it as the default value for the column.