Database Spawn ID Cleanup

[Nyotel]

Out of curiosity, what's the easiest method when completely purging a database to reset monster spawn ID to 0? Obviously emptying the table, but the source code has it adding to the last entered ID.

[Tabasco]

ALTER TABLE <table> AUTO_INCREMENT = 1;

If you're just emptying tables you can also use TRUNCATE <table>