EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Database Spawn ID Cleanup (https://www.eqemulator.org/forums/showthread.php?t=35830)

Nyotel 10-05-2012 12:56 PM

Database Spawn ID Cleanup
 
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 10-05-2012 03:36 PM

ALTER TABLE <table> AUTO_INCREMENT = 1;

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


All times are GMT -4. The time now is 07:26 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.