Reset User Count Iin Datbase

[helmer.co]

Hello all,

I am redoing my site and have deleted all the old users. I would like to reset my database to restart from user 3 instead of 1749. Can someone please tell me what fields to reset in my database?

Also is their a field where banned users are kept that will need to be purged as well?

Thanks,

John

[kh99]

You can use this SQL:
ALTER TABLE user AUTO_INCREMENT = 3

Or if you use phpmyadmin, select the table then go to operations, and change it under table options (I think).

The banned user info is kept in the userban table, so you could truncate that if you wanted.

[helmer.co]

Thank you for your reply. I will see if that corrects it.