DB/GameObject: Add pooling for Water Barrel and Food Crate

Closes #22933

1 files changed, 24 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_01_10_06_world_335.sql b/sql/updates/world/3.3.5/2019_01_10_06_world_335.sql
new file mode 100644
index 00000000000..4e9960a3e6e
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_01_10_06_world_335.sql
@@ -0,0 +1,24 @@
+-- 
+DELETE FROM `pool_template` WHERE entry IN (501,502,503,504,505,506);
+INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
+(501, 1, 'Water Barrel and Food Crate1'),
+(502, 1, 'Water Barrel and Food Crate2'),
+(503, 1, 'Water Barrel and Food Crate3'),
+(504, 1, 'Water Barrel and Food Crate4'),
+(505, 1, 'Water Barrel and Food Crate5'),
+(506, 1, 'Water Barrel and Food Crate6');
+
+DELETE FROM `pool_gameobject` WHERE pool_entry IN (501,502,503,504,505,506);
+INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`) VALUES
+(29275,501, 0, 'Water Barrel and Food Crate - Spawn 1'),
+(30758,501, 0, 'Water Barrel and Food Crate - Spawn 1'),
+(32754,502, 0, 'Water Barrel and Food Crate - Spawn 2'),
+(32313,502, 0, 'Water Barrel and Food Crate - Spawn 2'),
+(30839,503, 0, 'Water Barrel and Food Crate - Spawn 3'),
+(30677,503, 0, 'Water Barrel and Food Crate - Spawn 3'),
+(29276,504, 0, 'Water Barrel and Food Crate - Spawn 4'),
+(30687,504, 0, 'Water Barrel and Food Crate - Spawn 4'),
+(10677,505, 0, 'Water Barrel and Food Crate - Spawn 5'),
+(1462, 505, 0, 'Water Barrel and Food Crate - Spawn 5'),
+(29609,506, 0, 'Water Barrel and Food Crate - Spawn 6'),
+(29306,506, 0, 'Water Barrel and Food Crate - Spawn 6');