aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2017-12-20 22:01:55 +0100
committerfunjoker <funjoker109@gmail.com>2021-04-15 05:53:27 +0200
commit138783c99cf17f801a0bfad625d9f96cc49487bf (patch)
tree116817a76298ead01d8fdbf60f0df6a717d2ac6c
parent16ec008290861573fac7137af054be6d9642712f (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.sql11
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");