-- MySQL dump 10.16  Distrib 10.1.38-MariaDB, for Win32 (AMD64)
--
-- Host: localhost    Database: dspdb
-- ------------------------------------------------------
-- Server version    10.1.38-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `fishing_group`
--

DROP TABLE IF EXISTS `fishing_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fishing_group` (
  `groupid` int(10) unsigned NOT NULL,
  `fishid` int(10) unsigned NOT NULL,
  `rarity` smallint(5) unsigned NOT NULL DEFAULT '0',
  `pool_size` smallint(5) unsigned NOT NULL DEFAULT '0',
  `restock_rate` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`groupid`,`fishid`)
) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fishing_group`
--

LOCK TABLES `fishing_group` WRITE;
/*!40000 ALTER TABLE `fishing_group` DISABLE KEYS */;

-- East Sarutabaruta, Lake Tepokalipuka

INSERT INTO `fishing_group` VALUES (1,90,900,300,9);       -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (1,4401,1000,1000,36);  -- Moat Carp
INSERT INTO `fishing_group` VALUES (1,4462,550,160,5);     -- Monke Onke
INSERT INTO `fishing_group` VALUES (1,4464,1000,500,15);   -- Pipira
INSERT INTO `fishing_group` VALUES (1,4472,1000,500,15);   -- Crayfish
INSERT INTO `fishing_group` VALUES (1,4473,450,245,5);     -- Crescent Fish
INSERT INTO `fishing_group` VALUES (1,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (1,14242,500,300,9);    -- Rusty Subligar

-- East Sarutabaruta, Seaside

INSERT INTO `fishing_group` VALUES (2,90,900,300,9);       -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (2,624,1000,300,9);     -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (2,4360,1000,500,15);   -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (2,4383,800,290,7);     -- Gold Lobster
INSERT INTO `fishing_group` VALUES (2,4399,650,275,6);     -- Bluetail
INSERT INTO `fishing_group` VALUES (2,4461,250,230,6);     -- Bastore Bream
INSERT INTO `fishing_group` VALUES (2,4471,750,145,4);     -- Bladefish
INSERT INTO `fishing_group` VALUES (2,4481,1000,500,15);   -- Ogre Eel
INSERT INTO `fishing_group` VALUES (2,4514,1000,500,15);   -- Quus
INSERT INTO `fishing_group` VALUES (2,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (2,14242,500,300,9);    -- Rusty Subligar

-- East Sarutabaruta, Other Waterside (south) / East Sarutabaruta, Other Waterside (west) / East Sarutabaruta, Other Waterside (rivers)

INSERT INTO `fishing_group` VALUES (3,4472,1000,500,15);   -- Crayfish
INSERT INTO `fishing_group` VALUES (3,14242,500,300,9);    -- Rusty Subligar

-- Port Windurst, Whole Zone

INSERT INTO `fishing_group` VALUES (4,591,1000,300,9);     -- Ripped Cap
INSERT INTO `fishing_group` VALUES (4,624,1000,300,9);     -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (4,4360,1000,500,15);   -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (4,4461,250,230,6);     -- Bastore Bream
INSERT INTO `fishing_group` VALUES (4,4514,1000,500,15);   -- Quus
INSERT INTO `fishing_group` VALUES (4,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (4,14242,500,300,9);    -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (4,65535,1000,300,9);   -- Gil

-- Bastok Markets, North Side

INSERT INTO `fishing_group` VALUES (5,90,900,300,9);       -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (5,4401,1000,1000,36);  -- Moat Carp
INSERT INTO `fishing_group` VALUES (5,4426,1000,500,15);   -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (5,4427,750,275,6);     -- Gold Carp
INSERT INTO `fishing_group` VALUES (5,4429,800,290,7);     -- Black Eel
INSERT INTO `fishing_group` VALUES (5,4472,1000,500,15);   -- Crayfish
INSERT INTO `fishing_group` VALUES (5,13454,800,300,9);    -- Copper Ring
INSERT INTO `fishing_group` VALUES (5,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (5,14242,500,300,9);    -- Rusty Subligar

-- Bastok Markets, South Side

INSERT INTO `fishing_group` VALUES (6,90,900,300,9);       -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (6,4401,1000,1000,36);  -- Moat Carp
INSERT INTO `fishing_group` VALUES (6,4428,1000,500,15);   -- Dark Bass
INSERT INTO `fishing_group` VALUES (6,4429,800,290,7);     -- Black Eel
INSERT INTO `fishing_group` VALUES (6,4469,900,190,6);     -- Giant Catfish
INSERT INTO `fishing_group` VALUES (6,13454,800,300,9);    -- Copper Ring
INSERT INTO `fishing_group` VALUES (6,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (6,14242,500,300,9);    -- Rusty Subligar

-- Port Bastok, Whole Zone

INSERT INTO `fishing_group` VALUES (7,90,900,300,9);       -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (7,4360,1000,500,15);   -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (7,4385,1000,500,15);   -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (7,4443,1000,500,15);   -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (7,4461,250,230,6);     -- Bastore Bream
INSERT INTO `fishing_group` VALUES (7,4514,1000,500,15);   -- Quus
INSERT INTO `fishing_group` VALUES (7,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (7,14242,500,300,9);    -- Rusty Subligar

-- Bastok Mines, Whole Zone

INSERT INTO `fishing_group` VALUES (8,90,900,300,9);       -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (8,4472,1000,500,15);   -- Crayfish
INSERT INTO `fishing_group` VALUES (8,4515,1000,500,15);   -- Copper Frog
INSERT INTO `fishing_group` VALUES (8,13454,800,300,9);    -- Copper Ring
INSERT INTO `fishing_group` VALUES (8,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (8,14242,500,300,9);    -- Rusty Subligar

-- Northern San d'Oria, Whole Zone

INSERT INTO `fishing_group` VALUES (9,4401,1000,1000,36);  -- Moat Carp
INSERT INTO `fishing_group` VALUES (9,4426,1000,500,15);   -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (9,4427,750,275,6);     -- Gold Carp
INSERT INTO `fishing_group` VALUES (9,4472,1000,500,15);   -- Crayfish
INSERT INTO `fishing_group` VALUES (9,13454,800,300,9);    -- Copper Ring
INSERT INTO `fishing_group` VALUES (9,14117,500,300,9);    -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (9,14242,500,300,9);    -- Rusty Subligar

-- Port San d'Oria, Whole Zone

INSERT INTO `fishing_group` VALUES (10,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (10,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (10,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (10,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (10,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (10,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (10,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (10,14242,500,300,9);   -- Rusty Subligar

-- Windurst Waters, Whole Zone / Windurst Walls, Whole Zone / Windurst Woods, Whole Zone

INSERT INTO `fishing_group` VALUES (11,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (11,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (11,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (11,4464,1000,500,15);  -- Pipira
INSERT INTO `fishing_group` VALUES (11,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (11,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (11,14242,500,300,9);   -- Rusty Subligar

-- Heavens Tower, Whole Zone

INSERT INTO `fishing_group` VALUES (12,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (12,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (12,14242,500,300,9);   -- Rusty Subligar

-- Lower Jeuno, Whole Zone

INSERT INTO `fishing_group` VALUES (13,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (13,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (13,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (13,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (13,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (13,4482,950,500,15);   -- Nosteau Herring
INSERT INTO `fishing_group` VALUES (13,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (13,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (13,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (13,14242,500,300,9);   -- Rusty Subligar

-- Port Jeuno, Whole Zone

INSERT INTO `fishing_group` VALUES (14,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (14,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (14,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (14,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (14,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (14,4482,950,500,15);   -- Nosteau Herring
INSERT INTO `fishing_group` VALUES (14,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (14,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (14,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (14,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (14,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (14,16451,80,10,2);     -- Mythril Dagger

-- Bostaunieux Oubliette, Whole Zone

INSERT INTO `fishing_group` VALUES (15,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (15,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (15,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (15,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (15,16537,60,10,2);     -- Mythril Sword

-- East Ronfaure, Whole Zone

INSERT INTO `fishing_group` VALUES (16,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (16,4354,1000,500,15);  -- Shining Trout
INSERT INTO `fishing_group` VALUES (16,4379,1000,500,15);  -- Cheval Salmon
INSERT INTO `fishing_group` VALUES (16,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (16,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (16,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (16,13454,800,300,9);   -- Copper Ring

-- West Ronfaure, Knightwell

INSERT INTO `fishing_group` VALUES (17,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (17,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (17,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (17,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (17,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (17,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (17,14117,500,300,9);   -- Rusty Leggings

-- Ghelsba Outpost, Pond North / Ghelsba Outpost, Pond South

INSERT INTO `fishing_group` VALUES (18,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (18,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (18,4472,1000,500,15);  -- Crayfish

-- Ghelsba Outpost, River

INSERT INTO `fishing_group` VALUES (19,4354,1000,500,15);  -- Shining Trout
INSERT INTO `fishing_group` VALUES (19,4379,1000,500,15);  -- Cheval Salmon
INSERT INTO `fishing_group` VALUES (19,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (19,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (19,4472,1000,500,15);  -- Crayfish

-- Yughott Grotto, Whole Zone

INSERT INTO `fishing_group` VALUES (20,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (20,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (20,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (20,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (20,16655,400,290,7);   -- Rusty Pick

-- Gusgen Mines, Interior Pool West / Gusgen Mines, Interior Pool Center / Gusgen Mines, Interior Pool East

INSERT INTO `fishing_group` VALUES (21,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (21,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (21,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (21,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (21,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (21,4477,550,145,4);    -- Gavial Fish
INSERT INTO `fishing_group` VALUES (21,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (21,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (21,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (21,16537,60,10,2);     -- Mythril Sword
INSERT INTO `fishing_group` VALUES (21,16655,400,290,7);   -- Rusty Pick

-- Gusgen Mines, Pool Upper West / Gusgen Mines, Pool Upper East / Gusgen Mines, Pool Lower East

INSERT INTO `fishing_group` VALUES (22,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (22,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (22,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (22,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (22,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (22,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (22,16537,60,10,2);     -- Mythril Sword
INSERT INTO `fishing_group` VALUES (22,16655,400,290,7);   -- Rusty Pick

-- La Theine Plateau, Whole Zone

INSERT INTO `fishing_group` VALUES (23,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (23,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (23,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (23,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (23,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (23,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (23,12522,200,10,1);    -- Rusty Cap

-- Ordelle's Caves, Whole Zone

INSERT INTO `fishing_group` VALUES (24,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (24,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (24,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (24,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (24,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (24,14242,500,300,9);   -- Rusty Subligar

-- Selbina, Whole Zone

INSERT INTO `fishing_group` VALUES (25,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (25,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (25,4385,1000,500,15);  -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (25,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (25,4500,1000,500,15);  -- Greedie
INSERT INTO `fishing_group` VALUES (25,4501,1000,500,15);  -- Fat Greedie
INSERT INTO `fishing_group` VALUES (25,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (25,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (25,14242,500,300,9);   -- Rusty Subligar

-- Valkurm Dunes, Whole Zone

INSERT INTO `fishing_group` VALUES (26,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (26,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (26,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (26,4385,1000,500,15);  -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (26,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (26,4484,600,275,6);    -- Shall Shell
INSERT INTO `fishing_group` VALUES (26,4500,1000,500,15);  -- Greedie
INSERT INTO `fishing_group` VALUES (26,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (26,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (26,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (26,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (26,14242,500,300,9);   -- Rusty Subligar

-- Valkurm Dunes, Pirate's Chart mini-quest
INSERT INTO `fishing_group` VALUES (140,5329,500,300,9);   -- Tarutaru Snare
INSERT INTO `fishing_group` VALUES (140,5330,500,300,9);   -- Mithra Snare

-- Batallia Downs, North Seaside / Batallia Downs, South Seaside

INSERT INTO `fishing_group` VALUES (27,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (27,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (27,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (27,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (27,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (27,4451,500,245,5);    -- Silver Shark
INSERT INTO `fishing_group` VALUES (27,4482,950,500,15);   -- Nosteau Herring
INSERT INTO `fishing_group` VALUES (27,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (27,5128,850,290,7);    -- Cone Calamary
INSERT INTO `fishing_group` VALUES (27,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (27,16537,60,10,2);     -- Mythril Sword
INSERT INTO `fishing_group` VALUES (27,16606,400,300,9);   -- Rusty Greatsword
INSERT INTO `fishing_group` VALUES (27,16655,400,290,7);   -- Rusty Pick

-- Carpenters' Landing, South Landing / Carpenters' Landing, North Landing

INSERT INTO `fishing_group` VALUES (28,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (28,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (28,4354,1000,500,15);  -- Shining Trout
INSERT INTO `fishing_group` VALUES (28,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (28,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (28,5126,1000,500,15);  -- Muddy Siredont
INSERT INTO `fishing_group` VALUES (28,14117,500,300,9);   -- Rusty Leggings

-- Carpenters' Landing, Other Waterside South / Carpenters' Landing, Other Waterside Center / Carpenters' Landing, Other Waterside North

INSERT INTO `fishing_group` VALUES (29,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (29,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (29,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (29,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (29,5125,1000,500,15);  -- Phanauet Newt
INSERT INTO `fishing_group` VALUES (29,5126,1000,500,15);  -- Muddy Siredont

-- Carpenters' Landing, Central Landing

INSERT INTO `fishing_group` VALUES (30,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (30,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (30,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (30,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (30,5126,1000,500,15);  -- Muddy Siredont

-- Davoi, Basin of a Waterfall

INSERT INTO `fishing_group` VALUES (31,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (31,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (31,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (31,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (31,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (31,4463,500,50,6);     -- Takitaro
INSERT INTO `fishing_group` VALUES (31,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (31,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (31,16655,400,290,7);   -- Rusty Pick

-- Davoi, Wailing Pond

INSERT INTO `fishing_group` VALUES (32,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (32,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (32,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (32,16606,400,300,9);   -- Rusty Greatsword
INSERT INTO `fishing_group` VALUES (32,16655,400,290,7);   -- Rusty Pick

-- Davoi, Pond

INSERT INTO `fishing_group` VALUES (33,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (33,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (33,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (33,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (33,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (33,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (33,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (33,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (33,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (33,16655,400,290,7);   -- Rusty Pick

-- Davoi, Other Waterside

INSERT INTO `fishing_group` VALUES (34,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (34,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (34,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (34,14117,500,300,9);   -- Rusty Leggings

-- Jugner Forest, Crystalwater Spring

INSERT INTO `fishing_group` VALUES (35,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (35,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (35,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (35,4528,1000,500,15);  -- Crystal Bass
INSERT INTO `fishing_group` VALUES (35,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (35,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (35,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (35,16655,400,290,7);   -- Rusty Pick

-- Jugner Forest, Lake Mechieume - Mouth

INSERT INTO `fishing_group` VALUES (36,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (36,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (36,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (36,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (36,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (36,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (36,4454,200,115,3);    -- Emperor Fish
INSERT INTO `fishing_group` VALUES (36,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (36,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (36,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (36,14117,500,300,9);   -- Rusty Leggings

-- Jugner Forest, Lake Mechieume - Main

INSERT INTO `fishing_group` VALUES (37,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (37,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (37,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (37,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (37,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (37,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (37,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (37,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (37,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (37,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (37,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (37,14117,500,300,9);   -- Rusty Leggings

-- Jugner Forest, Maidens Spring

INSERT INTO `fishing_group` VALUES (38,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (38,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (38,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (38,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (38,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (38,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (38,16655,400,290,7);   -- Rusty Pick

-- Jugner Forest, River

INSERT INTO `fishing_group` VALUES (39,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (39,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (39,4354,1000,500,15);  -- Shining Trout
INSERT INTO `fishing_group` VALUES (39,4379,1000,500,15);  -- Cheval Salmon
INSERT INTO `fishing_group` VALUES (39,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (39,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (39,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (39,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (39,14117,500,300,9);   -- Rusty Leggings

-- Tavnazian Safehold, Whole Zone / Mamook, Other Waterside / Dangruf Wadi, Whole Zone

INSERT INTO `fishing_group` VALUES (40,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (40,4472,1000,500,15);  -- Crayfish

-- Korroloka Tunnel, Salt Water

INSERT INTO `fishing_group` VALUES (41,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (41,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (41,4291,1000,500,15);  -- Sandfish
INSERT INTO `fishing_group` VALUES (41,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (41,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (41,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (41,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (41,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (41,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (41,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (41,16606,400,300,9);   -- Rusty Greatsword
INSERT INTO `fishing_group` VALUES (41,16655,400,290,7);   -- Rusty Pick

-- Korroloka Tunnel, Fresh Water

INSERT INTO `fishing_group` VALUES (42,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (42,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (42,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (42,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (42,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (42,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (42,16606,400,300,9);   -- Rusty Greatsword

-- North Gustaberg, Basin of Waterfall

INSERT INTO `fishing_group` VALUES (43,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (43,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (43,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (43,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (43,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (43,4477,550,145,4);    -- Gavial Fish
INSERT INTO `fishing_group` VALUES (43,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (43,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (43,14242,500,300,9);   -- Rusty Subligar

-- North Gustaberg, River

INSERT INTO `fishing_group` VALUES (44,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (44,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (44,4427,750,275,6);    -- Gold Carp
INSERT INTO `fishing_group` VALUES (44,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (44,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (44,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (44,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (44,14242,500,300,9);   -- Rusty Subligar

-- Palborough Mines, Whole Zone

INSERT INTO `fishing_group` VALUES (45,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (45,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (45,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (45,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (45,4515,1000,500,15);  -- Copper Frog

-- South Gustaberg, Hot Springs

INSERT INTO `fishing_group` VALUES (46,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (46,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (46,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (46,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (46,14242,500,300,9);   -- Rusty Subligar

-- South Gustaberg, Seaside

INSERT INTO `fishing_group` VALUES (47,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (47,4383,800,290,7);    -- Gold Lobster
INSERT INTO `fishing_group` VALUES (47,4385,1000,500,15);  -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (47,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (47,4461,250,230,6);    -- Bastore Bream
INSERT INTO `fishing_group` VALUES (47,4471,750,145,4);    -- Bladefish
INSERT INTO `fishing_group` VALUES (47,4481,1000,500,15);  -- Ogre Eel
INSERT INTO `fishing_group` VALUES (47,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (47,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (47,14242,500,300,9);   -- Rusty Subligar

-- Zeruhn Mines, River

INSERT INTO `fishing_group` VALUES (48,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (48,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (48,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (48,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (48,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (48,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (48,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (48,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (48,14242,500,300,9);   -- Rusty Subligar

-- Zeruhn Mines, Pool

INSERT INTO `fishing_group` VALUES (49,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (49,4429,800,290,7);    -- Black Eel
INSERT INTO `fishing_group` VALUES (49,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (49,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (49,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (49,14242,500,300,9);   -- Rusty Subligar

-- Pashhow Marshlands, Whole Zone

INSERT INTO `fishing_group` VALUES (50,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (50,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (50,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (50,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (50,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (50,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (50,16655,400,290,7);   -- Rusty Pick

-- Rolanberry Fields, Small Fountain 1

INSERT INTO `fishing_group` VALUES (51,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (51,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (51,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (51,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (51,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (51,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (51,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (51,16655,400,290,7);   -- Rusty Pick

-- Rolanberry Fields, Fountain of Promises

INSERT INTO `fishing_group` VALUES (52,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (52,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (52,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (52,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (52,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (52,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (52,12316,500,260,5);   -- Fish Scale Shield
INSERT INTO `fishing_group` VALUES (52,16537,60,10,2);     -- Mythril Sword

-- Rolanberry Fields, Fountain of Partings

INSERT INTO `fishing_group` VALUES (53,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (53,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (53,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (53,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (53,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (53,4472,1000,500,15);  -- Crayfish

-- Rolanberry Fields, Small Fountain 2

INSERT INTO `fishing_group` VALUES (54,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (54,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (54,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (54,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (54,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (54,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (54,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (54,16655,400,290,7);   -- Rusty Pick

-- Giddeus, Giddeus Spring

INSERT INTO `fishing_group` VALUES (55,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (55,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (55,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (55,4462,550,160,5);    -- Monke Onke
INSERT INTO `fishing_group` VALUES (55,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (55,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (55,14117,500,300,9);   -- Rusty Leggings

-- Giddeus, Pond - West

INSERT INTO `fishing_group` VALUES (56,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (56,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (56,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (56,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (56,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (56,14117,500,300,9);   -- Rusty Leggings

-- Giddeus, Pond - North

INSERT INTO `fishing_group` VALUES (57,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (57,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (57,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (57,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (57,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (57,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (57,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (57,14117,500,300,9);   -- Rusty Leggings

-- Giddeus, Misc Puddles

INSERT INTO `fishing_group` VALUES (58,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (58,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (58,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (58,14117,500,300,9);   -- Rusty Leggings

-- West Sarutabaruta, Pond

INSERT INTO `fishing_group` VALUES (59,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (59,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (59,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (59,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (59,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (59,14242,500,300,9);   -- Rusty Subligar

-- West Sarutabaruta, Seaside

INSERT INTO `fishing_group` VALUES (60,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (60,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (60,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (60,4383,800,290,7);    -- Gold Lobster
INSERT INTO `fishing_group` VALUES (60,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (60,4461,250,230,6);    -- Bastore Bream
INSERT INTO `fishing_group` VALUES (60,4471,750,145,4);    -- Bladefish
INSERT INTO `fishing_group` VALUES (60,4481,1000,500,15);  -- Ogre Eel
INSERT INTO `fishing_group` VALUES (60,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (60,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (60,14242,500,300,9);   -- Rusty Subligar

-- Bibiki Bay, PI - South Beach

INSERT INTO `fishing_group` VALUES (61,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (61,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (61,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (61,4314,850,500,15);   -- Bibikibo
INSERT INTO `fishing_group` VALUES (61,4317,1000,500,15);  -- Trilobite
INSERT INTO `fishing_group` VALUES (61,4318,100,50,6);     -- Bibiki Urchin
INSERT INTO `fishing_group` VALUES (61,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (61,4484,600,275,6);    -- Shall Shell
INSERT INTO `fishing_group` VALUES (61,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (61,5121,700,275,6);    -- Moorish Idol
INSERT INTO `fishing_group` VALUES (61,5131,900,290,7);    -- Vongola Clam
INSERT INTO `fishing_group` VALUES (61,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (61,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (61,14242,500,300,9);   -- Rusty Subligar

-- Bibiki Bay, PI - North Beach

INSERT INTO `fishing_group` VALUES (62,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (62,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (62,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (62,4317,1000,500,15);  -- Trilobite
INSERT INTO `fishing_group` VALUES (62,4318,100,50,6);     -- Bibiki Urchin
INSERT INTO `fishing_group` VALUES (62,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (62,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (62,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (62,4484,600,275,6);    -- Shall Shell
INSERT INTO `fishing_group` VALUES (62,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (62,5121,700,275,6);    -- Moorish Idol
INSERT INTO `fishing_group` VALUES (62,5131,900,290,7);    -- Vongola Clam
INSERT INTO `fishing_group` VALUES (62,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (62,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (62,14242,500,300,9);   -- Rusty Subligar

-- Bibiki Bay, PI - West Beach / Bibiki Bay, PI - East Beach

INSERT INTO `fishing_group` VALUES (63,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (63,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (63,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (63,4318,100,50,6);     -- Bibiki Urchin
INSERT INTO `fishing_group` VALUES (63,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (63,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (63,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (63,4484,600,275,6);    -- Shall Shell
INSERT INTO `fishing_group` VALUES (63,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (63,5121,700,275,6);    -- Moorish Idol
INSERT INTO `fishing_group` VALUES (63,5131,900,290,7);    -- Vongola Clam
INSERT INTO `fishing_group` VALUES (63,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (63,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (63,14242,500,300,9);   -- Rusty Subligar

-- Bibiki Bay, BB - South Seaside

INSERT INTO `fishing_group` VALUES (64,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (64,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (64,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (64,4385,1000,500,15);  -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (64,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (64,4471,750,145,4);    -- Bladefish
INSERT INTO `fishing_group` VALUES (64,5128,850,290,7);    -- Cone Calamary
INSERT INTO `fishing_group` VALUES (64,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (64,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (64,14242,500,300,9);   -- Rusty Subligar

-- Bibiki Bay, BB - Other Seaside

INSERT INTO `fishing_group` VALUES (65,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (65,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (65,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (65,4385,1000,500,15);  -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (65,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (65,5128,850,290,7);    -- Cone Calamary
INSERT INTO `fishing_group` VALUES (65,12316,500,260,5);   -- Fish Scale Shield
INSERT INTO `fishing_group` VALUES (65,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (65,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (65,14242,500,300,9);   -- Rusty Subligar

-- Buburimu Peninsula, Whole Zone

INSERT INTO `fishing_group` VALUES (66,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (66,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (66,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (66,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (66,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (66,4484,600,275,6);    -- Shall Shell
INSERT INTO `fishing_group` VALUES (66,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (66,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (66,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (66,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (66,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (66,16655,400,290,7);   -- Rusty Pick

-- Labyrinth of Onzozo, Whole Zone

INSERT INTO `fishing_group` VALUES (67,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (67,14117,500,300,9);   -- Rusty Leggings

-- Manaclipper, Dhalmel Rock

INSERT INTO `fishing_group` VALUES (68,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (68,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (68,4305,700,50,6);     -- Ryugu Titan
INSERT INTO `fishing_group` VALUES (68,4314,850,500,15);   -- Bibikibo
INSERT INTO `fishing_group` VALUES (68,4317,1000,500,15);  -- Trilobite
INSERT INTO `fishing_group` VALUES (68,4318,100,50,6);     -- Bibiki Urchin
INSERT INTO `fishing_group` VALUES (68,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (68,4385,1000,500,15);  -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (68,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (68,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (68,4471,750,145,4);    -- Bladefish
INSERT INTO `fishing_group` VALUES (68,4476,500,50,6);     -- Titanictus
INSERT INTO `fishing_group` VALUES (68,4480,900,400,12);   -- Gugru Tuna
INSERT INTO `fishing_group` VALUES (68,4485,700,260,5);    -- Noble Lady
INSERT INTO `fishing_group` VALUES (68,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (68,5120,700,20,2);     -- Titanic Sawfish
INSERT INTO `fishing_group` VALUES (68,5121,700,275,6);    -- Moorish Idol
INSERT INTO `fishing_group` VALUES (68,5127,700,50,6);     -- Gugrusaurus
INSERT INTO `fishing_group` VALUES (68,5128,850,290,7);    -- Cone Calamary
INSERT INTO `fishing_group` VALUES (68,5131,900,290,7);    -- Vongola Clam

-- Mhaura, Whole Zone

INSERT INTO `fishing_group` VALUES (71,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (71,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (71,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (71,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (71,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (71,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (71,14117,500,300,9);   -- Rusty Leggings

-- Phomiuna Aqueducts, Whole Zone / Castle Oztroja, Whole Zone / Ranguemont Pass, Whole Zone

INSERT INTO `fishing_group` VALUES (72,4472,1000,500,15);  -- Crayfish

-- Sauromugue Champaign, Whole Zone

INSERT INTO `fishing_group` VALUES (73,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (73,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (73,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (73,4451,500,245,5);    -- Silver Shark
INSERT INTO `fishing_group` VALUES (73,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (73,5128,850,290,7);    -- Cone Calamary
INSERT INTO `fishing_group` VALUES (73,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (73,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (73,16537,60,10,2);     -- Mythril Sword

-- Beaucedine Glacier, Seaside

INSERT INTO `fishing_group` VALUES (74,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (74,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (74,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (74,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (74,4474,100,115,3);    -- Gigant Squid
INSERT INTO `fishing_group` VALUES (74,4482,950,500,15);   -- Nosteau Herring
INSERT INTO `fishing_group` VALUES (74,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (74,5128,850,290,7);    -- Cone Calamary
INSERT INTO `fishing_group` VALUES (74,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (74,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (74,16537,60,10,2);     -- Mythril Sword

-- Beaucedine Glacier, Ponds

INSERT INTO `fishing_group` VALUES (75,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (75,4454,200,115,3);    -- Emperor Fish
INSERT INTO `fishing_group` VALUES (75,4470,900,290,7);    -- Icefish
INSERT INTO `fishing_group` VALUES (75,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (75,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (75,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (75,16451,80,10,2);     -- Mythril Dagger

-- Fei'Yin, Whole Zone

INSERT INTO `fishing_group` VALUES (76,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (76,13456,300,275,6);   -- Silver Ring

-- Middle Delkfutt's Tower, Whole Zone / Upper Delkfutt's Tower, Whole Zone / Lower Delkfutt's Tower, Whole Zone

INSERT INTO `fishing_group` VALUES (77,14117,500,300,9);   -- Rusty Leggings

-- Qufim Island, Northwest Seaside

INSERT INTO `fishing_group` VALUES (78,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (78,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (78,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (78,4474,100,115,3);    -- Gigant Squid
INSERT INTO `fishing_group` VALUES (78,4482,950,500,15);   -- Nosteau Herring
INSERT INTO `fishing_group` VALUES (78,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (78,5128,850,290,7);    -- Cone Calamary
INSERT INTO `fishing_group` VALUES (78,12316,500,260,5);   -- Fish Scale Shield
INSERT INTO `fishing_group` VALUES (78,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (78,13456,300,275,6);   -- Silver Ring
INSERT INTO `fishing_group` VALUES (78,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (78,14242,500,300,9);   -- Rusty Subligar

-- Qufim Island, Southwest Seaside

INSERT INTO `fishing_group` VALUES (79,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (79,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (79,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (79,4478,500,130,3);    -- Three Eyed Fish
INSERT INTO `fishing_group` VALUES (79,4482,950,500,15);   -- Nosteau Herring
INSERT INTO `fishing_group` VALUES (79,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (79,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (79,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (79,14242,500,300,9);   -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (79,16537,60,10,2);     -- Mythril Sword

-- Qufim Island, Other Seaside

INSERT INTO `fishing_group` VALUES (80,4384,750,215,6);    -- Black Sole
INSERT INTO `fishing_group` VALUES (80,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (80,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (80,4482,950,500,15);   -- Nosteau Herring
INSERT INTO `fishing_group` VALUES (80,4483,1000,500,15);  -- Tiger Cod
INSERT INTO `fishing_group` VALUES (80,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (80,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (80,14242,500,300,9);   -- Rusty Subligar

-- The Boyahda Tree, Waterfall Basin

INSERT INTO `fishing_group` VALUES (81,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (81,4308,500,50,6);     -- Giant Chirai
INSERT INTO `fishing_group` VALUES (81,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (81,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (81,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (81,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (81,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (81,14117,500,300,9);   -- Rusty Leggings

-- The Boyahda Tree, Waterfall Basin - Hidden

INSERT INTO `fishing_group` VALUES (82,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (82,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (82,4426,1000,500,15);  -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (82,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (82,4454,200,115,3);    -- Emperor Fish
INSERT INTO `fishing_group` VALUES (82,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (82,14117,500,300,9);   -- Rusty Leggings

-- The Boyahda Tree, Other Waterside

INSERT INTO `fishing_group` VALUES (83,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (83,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (83,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (83,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (83,14117,500,300,9);   -- Rusty Leggings

-- Dragon's Aery, Whole Zone

INSERT INTO `fishing_group` VALUES (84,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (84,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (84,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (84,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (84,4473,450,245,5);    -- Crescent Fish
INSERT INTO `fishing_group` VALUES (84,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (84,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (84,16451,80,10,2);     -- Mythril Dagger
INSERT INTO `fishing_group` VALUES (84,16537,60,10,2);     -- Mythril Sword

-- Ro'Maeve, Whole Zone

INSERT INTO `fishing_group` VALUES (85,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (85,13456,300,275,6);   -- Silver Ring

-- The Sanctuary of Zi'Tah, Whole Zone

INSERT INTO `fishing_group` VALUES (86,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (86,4402,750,260,5);    -- Red Terrapin
INSERT INTO `fishing_group` VALUES (86,4428,1000,500,15);  -- Dark Bass
INSERT INTO `fishing_group` VALUES (86,4528,1000,500,15);  -- Crystal Bass

-- Eastern Altepa Desert, Whole Zone

INSERT INTO `fishing_group` VALUES (87,4291,1000,500,15);  -- Sandfish
INSERT INTO `fishing_group` VALUES (87,4306,900,190,6);    -- Giant Donko
INSERT INTO `fishing_group` VALUES (87,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (87,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (87,4515,1000,500,15);  -- Copper Frog
INSERT INTO `fishing_group` VALUES (87,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (87,16606,400,300,9);   -- Rusty Greatsword

-- Quicksand Caves, Whole Zone

INSERT INTO `fishing_group` VALUES (88,4309,500,50,6);     -- Cave Cherax
INSERT INTO `fishing_group` VALUES (88,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (88,14242,500,300,9);   -- Rusty Subligar

-- Rabao, Whole Zone

INSERT INTO `fishing_group` VALUES (89,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (89,4291,1000,500,15);  -- Sandfish
INSERT INTO `fishing_group` VALUES (89,4306,900,190,6);    -- Giant Donko
INSERT INTO `fishing_group` VALUES (89,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (89,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (89,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (89,14117,500,300,9);   -- Rusty Leggings

-- Western Altepa Desert, Oasis of Hubol

INSERT INTO `fishing_group` VALUES (90,4291,1000,500,15);  -- Sandfish
INSERT INTO `fishing_group` VALUES (90,4306,900,190,6);    -- Giant Donko
INSERT INTO `fishing_group` VALUES (90,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (90,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (90,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (90,4477,550,145,4);    -- Gavial Fish
INSERT INTO `fishing_group` VALUES (90,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (90,14117,500,300,9);   -- Rusty Leggings

-- Western Altepa Desert, Central Spring

INSERT INTO `fishing_group` VALUES (91,4291,1000,500,15);  -- Sandfish
INSERT INTO `fishing_group` VALUES (91,4306,900,190,6);    -- Giant Donko
INSERT INTO `fishing_group` VALUES (91,4401,1000,1000,36); -- Moat Carp
INSERT INTO `fishing_group` VALUES (91,4469,900,190,6);    -- Giant Catfish
INSERT INTO `fishing_group` VALUES (91,4472,1000,500,15);  -- Crayfish
INSERT INTO `fishing_group` VALUES (91,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (91,14117,500,300,9);   -- Rusty Leggings

-- Cape Teriggan, Whole Zone

INSERT INTO `fishing_group` VALUES (92,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (92,4385,1000,500,15);  -- Zafmlug Bass
INSERT INTO `fishing_group` VALUES (92,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (92,4484,600,275,6);    -- Shall Shell
INSERT INTO `fishing_group` VALUES (92,4500,1000,500,15);  -- Greedie
INSERT INTO `fishing_group` VALUES (92,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (92,14117,500,300,9);   -- Rusty Leggings

-- Kuftal Tunnel, Whole Zone

INSERT INTO `fishing_group` VALUES (93,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (93,4291,1000,500,15);  -- Sandfish
INSERT INTO `fishing_group` VALUES (93,4306,900,190,6);    -- Giant Donko
INSERT INTO `fishing_group` VALUES (93,4309,500,50,6);     -- Cave Cherax
INSERT INTO `fishing_group` VALUES (93,12522,200,10,1);    -- Rusty Cap
INSERT INTO `fishing_group` VALUES (93,14242,500,300,9);   -- Rusty Subligar

-- Kazham, Whole Zone

INSERT INTO `fishing_group` VALUES (94,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (94,591,1000,300,9);    -- Ripped Cap
INSERT INTO `fishing_group` VALUES (94,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (94,688,500,200,6);     -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (94,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (94,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (94,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (94,4580,900,290,7);    -- Coral Butterfly
INSERT INTO `fishing_group` VALUES (94,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (94,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (94,14242,500,300,9);   -- Rusty Subligar

-- Norg, Whole Zone

INSERT INTO `fishing_group` VALUES (95,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (95,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (95,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (95,4403,1000,500,15);  -- Yellow Globe
INSERT INTO `fishing_group` VALUES (95,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (95,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (95,4580,900,290,7);    -- Coral Butterfly
INSERT INTO `fishing_group` VALUES (95,13454,800,300,9);   -- Copper Ring
INSERT INTO `fishing_group` VALUES (95,14117,500,300,9);   -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (95,14242,500,300,9);   -- Rusty Subligar

-- Sea Serpent Grotto, Other Seaside

INSERT INTO `fishing_group` VALUES (96,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (96,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (96,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (96,1135,600,50,6);     -- Norg Shell
INSERT INTO `fishing_group` VALUES (96,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (96,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (96,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (96,4580,900,290,7);    -- Coral Butterfly

-- Sea Serpent Grotto, Pond Under a Bridge

INSERT INTO `fishing_group` VALUES (97,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (97,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (97,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (97,1135,600,50,6);     -- Norg Shell
INSERT INTO `fishing_group` VALUES (97,1210,1000,300,9);   -- Damp Scroll
INSERT INTO `fishing_group` VALUES (97,4304,450,100,4);    -- Grimmonite
INSERT INTO `fishing_group` VALUES (97,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (97,4361,1000,500,15);  -- Nebimonite
INSERT INTO `fishing_group` VALUES (97,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (97,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (97,4461,250,230,6);    -- Bastore Bream
INSERT INTO `fishing_group` VALUES (97,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (97,4580,900,290,7);    -- Coral Butterfly
INSERT INTO `fishing_group` VALUES (97,16606,400,300,9);   -- Rusty Greatsword

-- Sea Serpent Grotto, Interior of Hidden Door - Mythril

INSERT INTO `fishing_group` VALUES (98,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (98,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (98,887,200,50,6);      -- Coral Fragment
INSERT INTO `fishing_group` VALUES (98,1135,600,50,6);     -- Norg Shell
INSERT INTO `fishing_group` VALUES (98,4304,450,100,4);    -- Grimmonite
INSERT INTO `fishing_group` VALUES (98,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (98,4361,1000,500,15);  -- Nebimonite
INSERT INTO `fishing_group` VALUES (98,4399,650,275,6);    -- Bluetail
INSERT INTO `fishing_group` VALUES (98,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (98,4451,500,245,5);    -- Silver Shark
INSERT INTO `fishing_group` VALUES (98,4461,250,230,6);    -- Bastore Bream
INSERT INTO `fishing_group` VALUES (98,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (98,4580,900,290,7);    -- Coral Butterfly
INSERT INTO `fishing_group` VALUES (98,16606,400,300,9);   -- Rusty Greatsword

-- Sea Serpent Grotto, Interior of Hidden Door - Gold

INSERT INTO `fishing_group` VALUES (99,90,900,300,9);      -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (99,624,1000,300,9);    -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (99,4360,1000,500,15);  -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (99,4443,1000,500,15);  -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (99,4514,1000,500,15);  -- Quus
INSERT INTO `fishing_group` VALUES (99,4580,900,290,7);    -- Coral Butterfly

-- Sea Serpent Grotto, Misc Puddles

INSERT INTO `fishing_group` VALUES (100,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (100,624,1000,300,9);   -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (100,4360,1000,500,15); -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (100,4443,1000,500,15); -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (100,4514,1000,500,15); -- Quus

-- Yuhtunga Jungle, Northeast Pond

INSERT INTO `fishing_group` VALUES (101,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (101,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (101,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (101,4290,1000,500,15); -- Elshimo Frog
INSERT INTO `fishing_group` VALUES (101,4307,500,115,3);   -- Jungle Catfish
INSERT INTO `fishing_group` VALUES (101,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (101,4462,550,160,5);   -- Monke Onke
INSERT INTO `fishing_group` VALUES (101,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (101,4473,450,245,5);   -- Crescent Fish
INSERT INTO `fishing_group` VALUES (101,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (101,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (101,14242,500,300,9);  -- Rusty Subligar

-- Yuhtunga Jungle, Gremini Falls

INSERT INTO `fishing_group` VALUES (102,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (102,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (102,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (102,4290,1000,500,15); -- Elshimo Frog
INSERT INTO `fishing_group` VALUES (102,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (102,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (102,4473,450,245,5);   -- Crescent Fish
INSERT INTO `fishing_group` VALUES (102,4579,900,290,7);   -- Elshimo Newt
INSERT INTO `fishing_group` VALUES (102,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (102,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (102,14242,500,300,9);  -- Rusty Subligar

-- Yuhtunga Jungle, Southwest Pond

INSERT INTO `fishing_group` VALUES (103,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (103,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (103,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (103,4307,500,115,3);   -- Jungle Catfish
INSERT INTO `fishing_group` VALUES (103,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (103,4464,1000,500,15); -- Pipira
INSERT INTO `fishing_group` VALUES (103,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (103,4579,900,290,7);   -- Elshimo Newt
INSERT INTO `fishing_group` VALUES (103,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (103,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (103,14242,500,300,9);  -- Rusty Subligar

-- Yuhtunga Jungle, Southwest Waterfall - South

INSERT INTO `fishing_group` VALUES (104,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (104,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (104,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (104,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (104,4464,1000,500,15); -- Pipira
INSERT INTO `fishing_group` VALUES (104,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (104,4579,900,290,7);   -- Elshimo Newt
INSERT INTO `fishing_group` VALUES (104,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (104,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (104,14242,500,300,9);  -- Rusty Subligar

-- Yuhtunga Jungle, Southwest Waterfall - North

INSERT INTO `fishing_group` VALUES (105,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (105,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (105,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (105,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (105,4464,1000,500,15); -- Pipira
INSERT INTO `fishing_group` VALUES (105,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (105,4579,900,290,7);   -- Elshimo Newt
INSERT INTO `fishing_group` VALUES (105,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (105,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (105,14242,500,300,9);  -- Rusty Subligar

-- Yuhtunga Jungle, Other Waterside

INSERT INTO `fishing_group` VALUES (106,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (106,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (106,4290,1000,500,15); -- Elshimo Frog
INSERT INTO `fishing_group` VALUES (106,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (106,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (106,4579,900,290,7);   -- Elshimo Newt
INSERT INTO `fishing_group` VALUES (106,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (106,14117,500,300,9);  -- Rusty Leggings

-- Den of Rancor, Pool E-8

INSERT INTO `fishing_group` VALUES (107,624,1000,300,9);   -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (107,887,200,50,6);     -- Coral Fragment
INSERT INTO `fishing_group` VALUES (107,4288,800,260,5);   -- Zebra Eel
INSERT INTO `fishing_group` VALUES (107,4383,800,290,7);   -- Gold Lobster
INSERT INTO `fishing_group` VALUES (107,4399,650,275,6);   -- Bluetail
INSERT INTO `fishing_group` VALUES (107,4443,1000,500,15); -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (107,4514,1000,500,15); -- Quus
INSERT INTO `fishing_group` VALUES (107,4580,900,290,7);   -- Coral Butterfly
INSERT INTO `fishing_group` VALUES (107,12522,200,10,1);   -- Rusty Cap
INSERT INTO `fishing_group` VALUES (107,14242,500,300,9);  -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (107,16606,400,300,9);  -- Rusty Greatsword

-- Den of Rancor, Pool F-11

INSERT INTO `fishing_group` VALUES (108,624,1000,300,9);   -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (108,887,200,50,6);     -- Coral Fragment
INSERT INTO `fishing_group` VALUES (108,4305,700,50,6);    -- Ryugu Titan
INSERT INTO `fishing_group` VALUES (108,4399,650,275,6);   -- Bluetail
INSERT INTO `fishing_group` VALUES (108,4443,1000,500,15); -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (108,4514,1000,500,15); -- Quus
INSERT INTO `fishing_group` VALUES (108,4580,900,290,7);   -- Coral Butterfly
INSERT INTO `fishing_group` VALUES (108,12316,500,260,5);  -- Fish Scale Shield
INSERT INTO `fishing_group` VALUES (108,14242,500,300,9);  -- Rusty Subligar
INSERT INTO `fishing_group` VALUES (108,16606,400,300,9);  -- Rusty Greatsword

-- Den of Rancor, Misc Water

INSERT INTO `fishing_group` VALUES (109,624,1000,300,9);   -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (109,4443,1000,500,15); -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (109,12522,200,10,1);   -- Rusty Cap

-- Temple of Uggalepih, Whole Zone

INSERT INTO `fishing_group` VALUES (110,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (110,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (110,13454,800,300,9);  -- Copper Ring

-- Yhoator Jungle, Front of Temple - East Side

INSERT INTO `fishing_group` VALUES (111,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (111,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (111,4290,1000,500,15); -- Elshimo Frog
INSERT INTO `fishing_group` VALUES (111,4307,500,115,3);   -- Jungle Catfish
INSERT INTO `fishing_group` VALUES (111,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (111,4464,1000,500,15); -- Pipira
INSERT INTO `fishing_group` VALUES (111,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (111,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (111,14242,500,300,9);  -- Rusty Subligar

-- Yhoator Jungle, Front of Temple - West Side

INSERT INTO `fishing_group` VALUES (112,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (112,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (112,4290,1000,500,15); -- Elshimo Frog
INSERT INTO `fishing_group` VALUES (112,4307,500,115,3);   -- Jungle Catfish
INSERT INTO `fishing_group` VALUES (112,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (112,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (112,4579,900,290,7);   -- Elshimo Newt
INSERT INTO `fishing_group` VALUES (112,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (112,14242,500,300,9);  -- Rusty Subligar

-- Yhoator Jungle, Teardrop Spring

INSERT INTO `fishing_group` VALUES (113,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (113,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (113,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (113,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (113,13456,300,275,6);  -- Silver Ring
INSERT INTO `fishing_group` VALUES (113,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (113,14242,500,300,9);  -- Rusty Subligar

-- Yhoator Jungle, Underground Pool 1

INSERT INTO `fishing_group` VALUES (114,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (114,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (114,4307,500,115,3);   -- Jungle Catfish
INSERT INTO `fishing_group` VALUES (114,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (114,4462,550,160,5);   -- Monke Onke
INSERT INTO `fishing_group` VALUES (114,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (114,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (114,14242,500,300,9);  -- Rusty Subligar

-- Yhoator Jungle, Bloodlet Spring

INSERT INTO `fishing_group` VALUES (115,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (115,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (115,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (115,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (115,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (115,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (115,14242,500,300,9);  -- Rusty Subligar

-- Yhoator Jungle, Underground Pool 3

INSERT INTO `fishing_group` VALUES (116,4290,1000,500,15); -- Elshimo Frog
INSERT INTO `fishing_group` VALUES (116,4579,900,290,7);   -- Elshimo Newt

-- Yhoator Jungle, Underground Pool 2

INSERT INTO `fishing_group` VALUES (117,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (117,4289,1000,500,15); -- Forest Carp
INSERT INTO `fishing_group` VALUES (117,4290,1000,500,15); -- Elshimo Frog
INSERT INTO `fishing_group` VALUES (117,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (117,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (117,4579,900,290,7);   -- Elshimo Newt
INSERT INTO `fishing_group` VALUES (117,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (117,14242,500,300,9);  -- Rusty Subligar

-- Ru'Aun Gardens, Whole Zone / The Shrine of Ru'Avitau, Whole Zone

INSERT INTO `fishing_group` VALUES (118,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (118,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (118,13456,300,275,6);  -- Silver Ring

-- Oldton Movalpolos, Whole Zone

INSERT INTO `fishing_group` VALUES (119,1624,700,300,9);   -- Bugbear Mask
INSERT INTO `fishing_group` VALUES (119,1638,800,300,9);   -- Moblin Mask
INSERT INTO `fishing_group` VALUES (119,4313,750,275,6);   -- Blindfish
INSERT INTO `fishing_group` VALUES (119,4316,500,100,4);   -- Armored Pisces
INSERT INTO `fishing_group` VALUES (119,4429,800,290,7);   -- Black Eel
INSERT INTO `fishing_group` VALUES (119,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (119,4515,1000,500,15); -- Copper Frog
INSERT INTO `fishing_group` VALUES (119,13454,800,300,9);  -- Copper Ring
INSERT INTO `fishing_group` VALUES (119,16606,400,300,9);  -- Rusty Greatsword
INSERT INTO `fishing_group` VALUES (119,16655,400,290,7);  -- Rusty Pick

-- Lufaise Meadows, Leremieu Lagoon

INSERT INTO `fishing_group` VALUES (120,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (120,4428,1000,500,15); -- Dark Bass
INSERT INTO `fishing_group` VALUES (120,4454,200,115,3);   -- Emperor Fish
INSERT INTO `fishing_group` VALUES (120,5129,850,50,6);    -- Lik
INSERT INTO `fishing_group` VALUES (120,5130,850,260,5);   -- Tavnazian Goby

-- Lufaise Meadows, Seaside / Misareaux Coast, Seaside

INSERT INTO `fishing_group` VALUES (121,4443,1000,500,15); -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (121,4500,1000,500,15); -- Greedie
INSERT INTO `fishing_group` VALUES (121,4514,1000,500,15); -- Quus

-- Lufaise Meadows, Rafeloux River / Misareaux Coast, Rafeloux River

INSERT INTO `fishing_group` VALUES (122,688,500,200,6);    -- Arrowwood Log
INSERT INTO `fishing_group` VALUES (122,4427,750,275,6);   -- Gold Carp
INSERT INTO `fishing_group` VALUES (122,5130,850,260,5);   -- Tavnazian Goby

-- Misareaux Coast, Cascade Edellaine

INSERT INTO `fishing_group` VALUES (123,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (123,4427,750,275,6);   -- Gold Carp
INSERT INTO `fishing_group` VALUES (123,4428,1000,500,15); -- Dark Bass
INSERT INTO `fishing_group` VALUES (123,4463,500,50,6);    -- Takitaro
INSERT INTO `fishing_group` VALUES (123,5130,850,260,5);   -- Tavnazian Goby
INSERT INTO `fishing_group` VALUES (123,13456,300,275,6);  -- Silver Ring

-- Aht Urhgan Whitegate, Whole Zone

INSERT INTO `fishing_group` VALUES (124,2341,1000,300,9);  -- Hydrogauge
INSERT INTO `fishing_group` VALUES (124,5447,1000,500,15); -- Denizanasi
INSERT INTO `fishing_group` VALUES (124,5448,850,290,7);   -- Kalamar
INSERT INTO `fishing_group` VALUES (124,5449,1000,500,15); -- Hamsi
INSERT INTO `fishing_group` VALUES (124,14242,500,300,9);  -- Rusty Subligar

-- Al Zahbi, Whole Zone

INSERT INTO `fishing_group` VALUES (125,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (125,2341,1000,300,9);  -- Hydrogauge
INSERT INTO `fishing_group` VALUES (125,4310,1000,500,15); -- Tiny Goldfish
INSERT INTO `fishing_group` VALUES (125,4401,1000,1000,36);-- Moat Carp
INSERT INTO `fishing_group` VALUES (125,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (125,5458,800,290,7);   -- Yilanbaligi
INSERT INTO `fishing_group` VALUES (125,5459,650,275,6);   -- Sazanbaligi
INSERT INTO `fishing_group` VALUES (125,5460,650,260,5);   -- Kayabaligi
INSERT INTO `fishing_group` VALUES (125,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (125,14242,500,300,9);  -- Rusty Subligar

-- Bhaflau Thickets, Whole Zone

INSERT INTO `fishing_group` VALUES (126,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (126,4428,1000,500,15); -- Dark Bass
INSERT INTO `fishing_group` VALUES (126,5137,450,115,3);   -- Turnabaligi
INSERT INTO `fishing_group` VALUES (126,5458,800,290,7);   -- Yilanbaligi
INSERT INTO `fishing_group` VALUES (126,5459,650,275,6);   -- Sazanbaligi
INSERT INTO `fishing_group` VALUES (126,5460,650,260,5);   -- Kayabaligi
INSERT INTO `fishing_group` VALUES (126,5461,1000,200,6);  -- Alabaligi
INSERT INTO `fishing_group` VALUES (126,5462,450,230,6);   -- Morinabaligi
INSERT INTO `fishing_group` VALUES (126,14242,500,300,9);  -- Rusty Subligar

-- Aydeewa Subterrane, Whole Zone

INSERT INTO `fishing_group` VALUES (127,2216,1000,200,6);  -- Lamp Marimo
INSERT INTO `fishing_group` VALUES (127,4309,500,50,6);    -- Cave Cherax
INSERT INTO `fishing_group` VALUES (127,4313,750,275,6);   -- Blindfish
INSERT INTO `fishing_group` VALUES (127,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (127,14242,500,300,9);  -- Rusty Subligar

-- Mamook, Pond

INSERT INTO `fishing_group` VALUES (128,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (128,5139,600,290,7);   -- Betta
INSERT INTO `fishing_group` VALUES (128,5458,800,290,7);   -- Yilanbaligi
INSERT INTO `fishing_group` VALUES (128,5459,650,275,6);   -- Sazanbaligi
INSERT INTO `fishing_group` VALUES (128,5460,650,260,5);   -- Kayabaligi
INSERT INTO `fishing_group` VALUES (128,5461,1000,200,6);  -- Alabaligi
INSERT INTO `fishing_group` VALUES (128,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (128,14242,500,300,9);  -- Rusty Subligar

-- Wajaom Woodlands, Whole Zone

INSERT INTO `fishing_group` VALUES (129,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (129,4428,1000,500,15); -- Dark Bass
INSERT INTO `fishing_group` VALUES (129,5137,450,115,3);   -- Turnabaligi
INSERT INTO `fishing_group` VALUES (129,5458,800,290,7);   -- Yilanbaligi
INSERT INTO `fishing_group` VALUES (129,5459,650,275,6);   -- Sazanbaligi
INSERT INTO `fishing_group` VALUES (129,5460,650,260,5);   -- Kayabaligi
INSERT INTO `fishing_group` VALUES (129,5461,1000,200,6);  -- Alabaligi
INSERT INTO `fishing_group` VALUES (129,5462,450,230,6);   -- Morinabaligi
INSERT INTO `fishing_group` VALUES (129,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (129,14242,500,300,9);  -- Rusty Subligar

-- Mount Zhayolm, Whole Zone

INSERT INTO `fishing_group` VALUES (130,5447,1000,500,15); -- Denizanasi
INSERT INTO `fishing_group` VALUES (130,5448,850,290,7);   -- Kalamar
INSERT INTO `fishing_group` VALUES (130,5449,1000,500,15); -- Hamsi
INSERT INTO `fishing_group` VALUES (130,14242,500,300,9);  -- Rusty Subligar

-- Arrapago Reef, Whole Zone

INSERT INTO `fishing_group` VALUES (131,5135,450,115,3);   -- Rhinochimera
INSERT INTO `fishing_group` VALUES (131,5453,1000,290,7);  -- Istakoz
INSERT INTO `fishing_group` VALUES (131,5454,400,230,6);   -- Mercanbaligi
INSERT INTO `fishing_group` VALUES (131,5455,500,115,3);   -- Ahtapot
INSERT INTO `fishing_group` VALUES (131,5456,850,275,6);   -- Istiridye
INSERT INTO `fishing_group` VALUES (131,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (131,14242,500,300,9);  -- Rusty Subligar

-- Caedarva Mire, Whole Zone

INSERT INTO `fishing_group` VALUES (132,4428,1000,500,15); -- Dark Bass
INSERT INTO `fishing_group` VALUES (132,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (132,5138,450,260,5);   -- Black Ghost
INSERT INTO `fishing_group` VALUES (132,5463,900,175,5);   -- Yayinbaligi
INSERT INTO `fishing_group` VALUES (132,5464,800,200,6);   -- Kaplumbaga
INSERT INTO `fishing_group` VALUES (132,5465,1000,500,15); -- Caedarva Frog
INSERT INTO `fishing_group` VALUES (132,14117,500,300,9);  -- Rusty Leggings

-- Nashmau, Whole Zone

INSERT INTO `fishing_group` VALUES (133,2341,1000,300,9);  -- Hydrogauge
INSERT INTO `fishing_group` VALUES (133,5133,400,100,4);   -- Pterygotus
INSERT INTO `fishing_group` VALUES (133,5453,1000,290,7);  -- Istakoz
INSERT INTO `fishing_group` VALUES (133,5454,400,230,6);   -- Mercanbaligi
INSERT INTO `fishing_group` VALUES (133,5455,500,115,3);   -- Ahtapot
INSERT INTO `fishing_group` VALUES (133,5456,850,275,6);   -- Istiridye
INSERT INTO `fishing_group` VALUES (133,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (133,14242,500,300,9);  -- Rusty Subligar

-- Talacca Cove, Whole Zone

INSERT INTO `fishing_group` VALUES (134,5136,1000,400,12); -- Istavrit
INSERT INTO `fishing_group` VALUES (134,5453,1000,290,7);  -- Istakoz
INSERT INTO `fishing_group` VALUES (134,5454,400,230,6);   -- Mercanbaligi
INSERT INTO `fishing_group` VALUES (134,5455,500,115,3);   -- Ahtapot
INSERT INTO `fishing_group` VALUES (134,5457,750,215,6);   -- Dil
INSERT INTO `fishing_group` VALUES (134,14117,500,300,9);  -- Rusty Leggings
INSERT INTO `fishing_group` VALUES (134,14242,500,300,9);  -- Rusty Subligar

-- Open sea route to Al Zahbi, Whole Zone / Open sea route to Mhaura, Whole Zone

INSERT INTO `fishing_group` VALUES (135,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (135,624,1000,300,9);   -- Clump Of Pamtam Kelp
INSERT INTO `fishing_group` VALUES (135,4403,1000,500,15); -- Yellow Globe
INSERT INTO `fishing_group` VALUES (135,4443,1000,500,15); -- Cobalt Jellyfish
INSERT INTO `fishing_group` VALUES (135,4480,900,400,12);  -- Gugru Tuna
INSERT INTO `fishing_group` VALUES (135,4485,700,260,5);   -- Noble Lady
INSERT INTO `fishing_group` VALUES (135,5127,700,50,6);    -- Gugrusaurus
INSERT INTO `fishing_group` VALUES (135,5132,550,245,5);   -- Gurnard
INSERT INTO `fishing_group` VALUES (135,5134,500,50,6);    -- Mola Mola
INSERT INTO `fishing_group` VALUES (135,5141,400,145,4);   -- Veydal Wrasse
INSERT INTO `fishing_group` VALUES (135,14117,500,300,9);  -- Rusty Leggings

-- Ship bound for Selbina, Whole Zone / Ship bound for Mhaura, Whole Zone

INSERT INTO `fishing_group` VALUES (136,4305,700,50,6);    -- Ryugu Titan
INSERT INTO `fishing_group` VALUES (136,4360,1000,500,15); -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (136,4361,1000,500,15); -- Nebimonite
INSERT INTO `fishing_group` VALUES (136,4399,650,275,6);   -- Bluetail
INSERT INTO `fishing_group` VALUES (136,4451,500,245,5);   -- Silver Shark
INSERT INTO `fishing_group` VALUES (136,4476,500,50,6);    -- Titanictus
INSERT INTO `fishing_group` VALUES (136,4479,700,160,5);   -- Bhefhel Marlin
INSERT INTO `fishing_group` VALUES (136,4480,900,400,12);  -- Gugru Tuna
INSERT INTO `fishing_group` VALUES (136,4485,700,260,5);   -- Noble Lady
INSERT INTO `fishing_group` VALUES (136,4514,1000,500,15); -- Quus
INSERT INTO `fishing_group` VALUES (136,5128,850,290,7);   -- Cone Calamary
INSERT INTO `fishing_group` VALUES (136,14242,500,300,9);  -- Rusty Subligar

-- Ship bound for Selbina (with Pirates), Whole Zone / Ship bound for Mhaura (with Pirates), Whole Zone

INSERT INTO `fishing_group` VALUES (137,4305,700,50,6);    -- Ryugu Titan
INSERT INTO `fishing_group` VALUES (137,4360,1000,500,15); -- Bastore Sardine
INSERT INTO `fishing_group` VALUES (137,4361,1000,500,15); -- Nebimonite
INSERT INTO `fishing_group` VALUES (137,4399,650,275,6);   -- Bluetail
INSERT INTO `fishing_group` VALUES (137,4451,500,245,5);   -- Silver Shark
INSERT INTO `fishing_group` VALUES (137,4475,700,50,6);    -- Sea Zombie
INSERT INTO `fishing_group` VALUES (137,4476,500,50,6);    -- Titanictus
INSERT INTO `fishing_group` VALUES (137,4479,700,160,5);   -- Bhefhel Marlin
INSERT INTO `fishing_group` VALUES (137,4480,900,400,12);  -- Gugru Tuna
INSERT INTO `fishing_group` VALUES (137,4485,700,260,5);   -- Noble Lady
INSERT INTO `fishing_group` VALUES (137,4514,1000,500,15); -- Quus
INSERT INTO `fishing_group` VALUES (137,5127,700,50,6);    -- Gugrusaurus
INSERT INTO `fishing_group` VALUES (137,5128,850,290,7);   -- Cone Calamary
INSERT INTO `fishing_group` VALUES (137,14242,500,300,9);  -- Rusty Subligar

-- Silver Sea route to Nashmau, Whole Zone / Silver Sea route to Al Zahbi, Whole Zone

INSERT INTO `fishing_group` VALUES (138,2341,1000,300,9);  -- Hydrogauge
INSERT INTO `fishing_group` VALUES (138,5140,500,50,6);    -- Kalkanbaligi
INSERT INTO `fishing_group` VALUES (138,5448,850,290,7);   -- Kalamar
INSERT INTO `fishing_group` VALUES (138,5449,1000,500,15); -- Hamsi
INSERT INTO `fishing_group` VALUES (138,5450,900,190,6);   -- Lakerda
INSERT INTO `fishing_group` VALUES (138,5451,800,245,5);   -- Kilicbaligi
INSERT INTO `fishing_group` VALUES (138,5452,550,275,6);   -- Uskumru

-- Phanauet Channel, Whole Zone

INSERT INTO `fishing_group` VALUES (139,90,900,300,9);     -- Rusty Bucket
INSERT INTO `fishing_group` VALUES (139,4315,450,50,8);    -- Lungfish
INSERT INTO `fishing_group` VALUES (139,4319,650,50,8);    -- Tricorn
INSERT INTO `fishing_group` VALUES (139,4354,1000,500,15); -- Shining Trout
INSERT INTO `fishing_group` VALUES (139,4402,750,260,5);   -- Red Terrapin
INSERT INTO `fishing_group` VALUES (139,4426,1000,500,15); -- Tricolored Carp
INSERT INTO `fishing_group` VALUES (139,4427,750,275,6);   -- Gold Carp
INSERT INTO `fishing_group` VALUES (139,4428,1000,500,15); -- Dark Bass
INSERT INTO `fishing_group` VALUES (139,4469,900,190,6);   -- Giant Catfish
INSERT INTO `fishing_group` VALUES (139,4472,1000,500,15); -- Crayfish
INSERT INTO `fishing_group` VALUES (139,5125,1000,500,15); -- Phanauet Newt
INSERT INTO `fishing_group` VALUES (139,5126,1000,500,15); -- Muddy Siredont

/*!40000 ALTER TABLE `fishing_group` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-05-02 13:25:28
