From 51611c7c22895ac05f4b4d9b1cbdd829815e8143 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Sat, 19 Jan 2013 11:22:29 +0100 Subject: DB/Creature remove obsolete creature_addon records (default values in all fields) --- sql/updates/world/2013_01_19_05_world_creature_addon.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2013_01_19_05_world_creature_addon.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_19_05_world_creature_addon.sql b/sql/updates/world/2013_01_19_05_world_creature_addon.sql new file mode 100644 index 00000000000..0a384501e36 --- /dev/null +++ b/sql/updates/world/2013_01_19_05_world_creature_addon.sql @@ -0,0 +1,2 @@ +-- delete 31 creature_addon data that contain no information (bytes2=1 is the default) +DELETE FROM `creature_addon` WHERE `guid` IN (132572,126539,126542,126553,126556,126562,126564,126567,126568,126569,126572,126574,126579,126582,127067,132849,132850,132851,132852,132853,132854,132855,132856,132857,132863,108034,108035,108036,108037,203372,203373); -- cgit v1.2.3