Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page Database Spawn ID Cleanup

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2012, 12:56 PM
Nyotel
Fire Beetle
  
Join Date: Oct 2012
Posts: 2
Default 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.
Reply With Quote
  #2  
Old 10-05-2012, 03:36 PM
Tabasco's Avatar
Tabasco
Discordant
  
Join Date: Sep 2009
Posts: 270
Default
ALTER TABLE <table> AUTO_INCREMENT = 1;

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

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

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

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3