diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-01-19 11:22:29 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2013-01-19 11:22:29 +0100 |
| commit | 51611c7c22895ac05f4b4d9b1cbdd829815e8143 (patch) | |
| tree | ff6a204a8e69bea627f35c23725a0ca8592535a4 | |
| parent | 6ec1652b607704cdba7815b4397993d3f358d154 (diff) | |
DB/Creature remove obsolete creature_addon records (default values in all fields)
| -rw-r--r-- | sql/updates/world/2013_01_19_05_world_creature_addon.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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); |