How do I 'reset' a table in the db so ID starts counting from 1

[sim0n]

So I want to reset the users and the rooms table in the dabase, so when you create a new user, the ID starts counting from 1, same with the rooms table. I tired deleting all users and stuff but then again, when you create a new user the ID of the user is 200 or something.

 

[Nebula]

re-import a clean users table

 

[sim0n]

re-import a clean users table

give me a dl link then

 

[Nebula]

if you're using phoenix just use the one that comes with it, if its bcstorm just make your own users table