diff options
author | Killyana <morphone1@gmail.com> | 2017-12-20 22:01:55 +0100 |
---|---|---|
committer | funjoker <funjoker109@gmail.com> | 2021-04-15 05:53:27 +0200 |
commit | 138783c99cf17f801a0bfad625d9f96cc49487bf (patch) | |
tree | 116817a76298ead01d8fdbf60f0df6a717d2ac6c | |
parent | 16ec008290861573fac7137af054be6d9642712f (diff) |
DB: Fix Some DB errors related to pooling
(cherry picked from commit aa8cd77501ee3995c856527eb45cb4d0de102aa8)
-rw-r--r-- | sql/updates/world/master/2021_03_18_00_world_2017_12_20_04_world.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_03_18_00_world_2017_12_20_04_world.sql b/sql/updates/world/master/2021_03_18_00_world_2017_12_20_04_world.sql new file mode 100644 index 00000000000..b099bed4337 --- /dev/null +++ b/sql/updates/world/master/2021_03_18_00_world_2017_12_20_04_world.sql @@ -0,0 +1,11 @@ +-- +-- DELETE FROM `gameobject` WHERE `id`=64922 AND `guid`=189980; +-- DELETE FROM `gameobject_addon` WHERE `guid`=189980; +DELETE FROM `pool_gameobject` WHERE `pool_entry`=5217 ; +-- DELETE FROM `pool_creature` WHERE `guid`=134515 AND `pool_entry`=1047; +DELETE FROM `pool_template` WHERE `entry` IN (5217,5450,5506,5517,5608); +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(5450,1,"Icecrown node 3"), +(5506,1,"Icecrown node 59"), +(5517,1,"Icecrown node 70"), +(5608,1,"Icecrown node 161"); |