DB/Fishing: Update fishing skill requirements for 100% catch

Closes #23139

2 files changed, 107 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_07_28_00_world.sql b/sql/updates/world/3.3.5/2019_03_28_00_world.sql
index 179572fdefb..179572fdefb 100644
--- a/sql/updates/world/3.3.5/2019_07_28_00_world.sql
+++ b/sql/updates/world/3.3.5/2019_03_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_03_30_00_world.sql b/sql/updates/world/3.3.5/2019_03_30_00_world.sql
new file mode 100644
index 00000000000..2c398e60ab9
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_03_30_00_world.sql
@@ -0,0 +1,107 @@
+-- 
+DELETE FROM `skill_fishing_base_level`;
+INSERT INTO `skill_fishing_base_level` (`entry`,`skill`) VALUES
+(   1, 25),  -- Dun Morogh
+(  12, 25),  -- Elwynn Forest
+(  14, 25),  -- Durotar
+(  85, 25),  -- Tirisfal Glades
+( 141, 25),  -- Teldrassil
+( 215, 25),  -- Mulgore
+(3524, 25),  -- Azuremyst Isle
+(3430, 25),  -- Eversong Woods
+(  17, 75),  -- The Barrens
+(  38, 75),  -- Loch Modan
+(  40, 75),  -- Westfall
+( 130, 75),  -- Silverpine Forest
+( 148, 75),  -- Darkshore
+( 718, 75),  -- Wailing Caverns
+( 719, 75),  -- Blackfathom Deeps
+(1497, 75),  -- Undercity
+(1519, 75),  -- Stormwind City
+(1537, 75),  -- Ironforge
+(1581, 75),  -- The Deadmines
+(1637, 75),  -- Orgrimmar
+(1638, 75),  -- Thunder Bluff
+(1657, 75),  -- Darnassus
+(3433, 75),  -- Ghostlands
+(3525, 75),  -- Bloodmyst Isle
+( 386,100),  -- The Forgotten Pools
+( 387,100),  -- Lushwater Oasis
+( 388,100),  -- The Stagnant Oasis
+(  10,150),  -- Duskwood
+(  11,150),  -- Wetlands
+(  44,150),  -- Redridge Mountains
+( 267,150),  -- Hillsbrad Foothills
+( 331,150),  -- Ashenvale
+( 406,150),  -- Stonetalon Mountains
+(   8,225),  -- Swamp of Sorrows
+(  15,225),  -- Dustwallow Marsh
+(  33,225),  -- Stranglethorn Vale
+(  36,225),  -- Alterac Mountains
+(  45,225),  -- Arathi Highlands
+( 400,225),  -- Thousand Needles
+( 405,225),  -- Desolace
+( 796,225),  -- Scarlet Monastery
+(  16,300),  -- Azshara
+(  28,300),  -- Western Plaguelands
+(  47,300),  -- The Hinterlands
+( 297,300),  -- Jaguero Isle
+( 357,300),  -- Feralas
+( 361,300),  -- Felwood
+( 440,300),  -- Tanaris
+( 490,300),  -- Un'Goro Crater
+( 493,300),  -- Moonglade
+(1417,300),  -- Sunken Temple
+(1477,300),  -- The Temple of Atal'Hakkar
+(2100,300),  -- Maraudon
+(3483,375),  -- Hellfire Peninsula
+(3520,375),  -- Shadowmoon Valley
+(3625,375),  -- Forge Camp: Hate
+(3521,400),  -- Zangarmarsh
+(3607,400),  -- Serpentshrine Cavern
+(3905,400),  -- Coilfang Reservoir
+(  41,425),  -- Deadwind Pass
+(  46,425),  -- Burning Steppes
+( 139,425),  -- Eastern Plaguelands
+( 618,425),  -- Winterspring
+(1377,425),  -- Silithus
+(2017,425),  -- Stratholme
+(2057,425),  -- Scholomance
+(3805,425),  -- Zul'Aman
+(  19,425),  -- Zul'Gurub
+(1112,425),  -- Jademir Lake
+(1222,425),  -- Hetaera's Clutch
+(1227,425),  -- Bay of Storms
+(3140,425),  -- Scalebeard's Cave
+(3519,450),  -- Terokkar Forest
+(3653,450),  -- Serpent Lake
+(3656,450),  -- Marshlight Lake
+(3658,450),  -- Sporewind Lake
+(4080,450),  -- Isle of Quel'Danas
+(  65,475),  -- Dragonblight
+(  66,475),  -- Zul'Drak
+( 394,475),  -- Grizzly Hills
+( 495,475),  -- Howling Fjord
+(3518,475),  -- Nagrand
+(3523,475),  -- Netherstorm
+(3537,475),  -- Borean Tundra
+(3614,490),  -- Skysong Lake
+(3621,490),  -- Lake Sunspring
+(3690,500),  -- Blackwind Lake
+(3691,500),  -- Lake Ere'Noru
+(3692,500),  -- Lake Jorune
+(3859,500),  -- Silmyr Lake
+(2817,500),  -- Crystalsong Forest
+(3711,525),  -- Sholazar Basin
+(4197,525),  -- Wintergrasp
+(4395,525),  -- Dalaran
+(  67,550),  -- The Storm Peaks
+( 210,550),  -- Icecrown
+(4273,550),  -- Ulduar
+(4742,550),  -- Hrothgar's Landing
+(3979,575),  -- The Frozen Sea
+(4813,575), -- 4813 Pit of Saron
+(4710,575), -- 4710 Isle of Conquest
+(4722,575), -- 4722 Trial of the Crusader
+(4987,575), -- 4987 The Ruby Sanctum
+(4100,575); -- 4100 The Culling of Stratholme