Reset User Count Iin Datbase
 

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

You can use this SQL:
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.

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