arcemu/arcemu — pull request #113 by Marforius (2012-02-07 11:47:32+00:00)
Title: Maintenance Updated Request #2

Maintenance Update

From: http://arcemu.org/forums/index.php?showtopic=24820&view=findpost&p=116055

Updated for git.
Update #2: Removed everything not pertaining to strictly cleaning the world and character databases of missing values (Besides the optimization queries).

Updates database maintenance to latest database structures. "Recycles" GUIDs. Cleans duplicate GUIDs. Cleans nonexistent entries (Creature_names with missing proto etc). Cleans double spawned NPCs(X,Y,Z) and GOs(X,Y). Sorts tables where possible ascending. Optimizes all tables.