217 lines
16 KiB
SQL
217 lines
16 KiB
SQL
-- 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_catch`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `fishing_catch`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8 */;
|
|
CREATE TABLE `fishing_catch` (
|
|
`zoneid` smallint(5) unsigned NOT NULL,
|
|
`areaid` tinyint(3) unsigned NOT NULL,
|
|
`groupid` smallint(5) unsigned NOT NULL,
|
|
PRIMARY KEY (`zoneid`,`areaid`,`groupid`)
|
|
) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AVG_ROW_LENGTH=27;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `fishing_catch`
|
|
--
|
|
|
|
LOCK TABLES `fishing_catch` WRITE;
|
|
/*!40000 ALTER TABLE `fishing_catch` DISABLE KEYS */;
|
|
INSERT INTO `fishing_catch` VALUES (1,1,139); -- Phanauet Channel, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (2,1,28); -- Carpenters' Landing, South Landing
|
|
INSERT INTO `fishing_catch` VALUES (2,2,29); -- Carpenters' Landing, Other Waterside South
|
|
INSERT INTO `fishing_catch` VALUES (2,3,29); -- Carpenters' Landing, Other Waterside Center
|
|
INSERT INTO `fishing_catch` VALUES (2,4,29); -- Carpenters' Landing, Other Waterside North
|
|
INSERT INTO `fishing_catch` VALUES (2,5,30); -- Carpenters' Landing, Central Landing
|
|
INSERT INTO `fishing_catch` VALUES (2,6,28); -- Carpenters' Landing, North Landing
|
|
INSERT INTO `fishing_catch` VALUES (3,1,68); -- Manaclipper, Dhalmel Rock
|
|
INSERT INTO `fishing_catch` VALUES (4,1,61); -- Bibiki Bay, PI - South Beach
|
|
INSERT INTO `fishing_catch` VALUES (4,2,62); -- Bibiki Bay, PI - North Beach
|
|
INSERT INTO `fishing_catch` VALUES (4,3,63); -- Bibiki Bay, PI - West Beach
|
|
INSERT INTO `fishing_catch` VALUES (4,4,63); -- Bibiki Bay, PI - East Beach
|
|
INSERT INTO `fishing_catch` VALUES (4,5,64); -- Bibiki Bay, BB - South Seaside
|
|
INSERT INTO `fishing_catch` VALUES (4,6,65); -- Bibiki Bay, BB - Other Seaside
|
|
INSERT INTO `fishing_catch` VALUES (11,1,119); -- Oldton Movalpolos, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (24,1,120); -- Lufaise Meadows, Leremieu Lagoon
|
|
INSERT INTO `fishing_catch` VALUES (24,2,121); -- Lufaise Meadows, Seaside
|
|
INSERT INTO `fishing_catch` VALUES (24,3,122); -- Lufaise Meadows, Rafeloux River
|
|
INSERT INTO `fishing_catch` VALUES (25,1,123); -- Misareaux Coast, Cascade Edellaine
|
|
INSERT INTO `fishing_catch` VALUES (25,2,121); -- Misareaux Coast, Seaside
|
|
INSERT INTO `fishing_catch` VALUES (25,3,122); -- Misareaux Coast, Rafeloux River
|
|
INSERT INTO `fishing_catch` VALUES (26,1,40); -- Tavnazian Safehold, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (27,1,72); -- Phomiuna Aqueducts, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (46,1,135); -- Open sea route to Al Zahbi, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (47,1,135); -- Open sea route to Mhaura, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (48,1,125); -- Al Zahbi, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (50,1,124); -- Aht Urhgan Whitegate, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (51,1,129); -- Wajaom Woodlands, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (52,1,126); -- Bhaflau Thickets, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (53,1,133); -- Nashmau, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (54,1,131); -- Arrapago Reef, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (57,1,134); -- Talacca Cove, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (58,1,138); -- Silver Sea route to Nashmau, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (59,1,138); -- Silver Sea route to Al Zahbi, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (61,1,130); -- Mount Zhayolm, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (65,1,128); -- Mamook, Pond
|
|
INSERT INTO `fishing_catch` VALUES (65,2,40); -- Mamook, Other Waterside
|
|
INSERT INTO `fishing_catch` VALUES (68,1,127); -- Aydeewa Subterrane, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (79,1,132); -- Caedarva Mire, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (100,1,17); -- West Ronfaure, Knightwell
|
|
INSERT INTO `fishing_catch` VALUES (101,1,16); -- East Ronfaure, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (102,1,23); -- La Theine Plateau, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (103,1,26); -- Valkurm Dunes, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (103,2,140); -- Valkurm Dunes, Pirate's Chart Quest
|
|
INSERT INTO `fishing_catch` VALUES (104,1,35); -- Jugner Forest, Crystalwater Spring
|
|
INSERT INTO `fishing_catch` VALUES (104,2,36); -- Jugner Forest, Lake Mechieume - Mouth
|
|
INSERT INTO `fishing_catch` VALUES (104,3,37); -- Jugner Forest, Lake Mechieume - Main
|
|
INSERT INTO `fishing_catch` VALUES (104,4,38); -- Jugner Forest, Maidens Spring
|
|
INSERT INTO `fishing_catch` VALUES (104,5,39); -- Jugner Forest, River
|
|
INSERT INTO `fishing_catch` VALUES (105,1,27); -- Batallia Downs, North Seaside
|
|
INSERT INTO `fishing_catch` VALUES (105,2,27); -- Batallia Downs, South Seaside
|
|
INSERT INTO `fishing_catch` VALUES (106,1,43); -- North Gustaberg, Basin of Waterfall
|
|
INSERT INTO `fishing_catch` VALUES (106,2,44); -- North Gustaberg, River
|
|
INSERT INTO `fishing_catch` VALUES (107,1,46); -- South Gustaberg, Hot Springs
|
|
INSERT INTO `fishing_catch` VALUES (107,2,47); -- South Gustaberg, Seaside
|
|
INSERT INTO `fishing_catch` VALUES (109,1,50); -- Pashhow Marshlands, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (110,1,51); -- Rolanberry Fields, Small Fountain 1
|
|
INSERT INTO `fishing_catch` VALUES (110,2,52); -- Rolanberry Fields, Fountain of Promises
|
|
INSERT INTO `fishing_catch` VALUES (110,3,53); -- Rolanberry Fields, Fountain of Partings
|
|
INSERT INTO `fishing_catch` VALUES (110,4,54); -- Rolanberry Fields, Small Fountain 2
|
|
INSERT INTO `fishing_catch` VALUES (111,1,74); -- Beaucedine Glacier, Seaside
|
|
INSERT INTO `fishing_catch` VALUES (111,2,75); -- Beaucedine Glacier, Ponds
|
|
INSERT INTO `fishing_catch` VALUES (113,1,92); -- Cape Teriggan, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (114,1,87); -- Eastern Altepa Desert, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (115,1,59); -- West Sarutabaruta, Pond
|
|
INSERT INTO `fishing_catch` VALUES (115,2,60); -- West Sarutabaruta, Seaside
|
|
INSERT INTO `fishing_catch` VALUES (116,1,2); -- East Sarutabaruta, Seaside
|
|
INSERT INTO `fishing_catch` VALUES (116,2,3); -- East Sarutabaruta, Other Waterside (south)
|
|
INSERT INTO `fishing_catch` VALUES (116,3,3); -- East Sarutabaruta, Other Waterside (west)
|
|
INSERT INTO `fishing_catch` VALUES (116,4,3); -- East Sarutabaruta, Other Waterside (rivers)
|
|
INSERT INTO `fishing_catch` VALUES (116,5,1); -- East Sarutabaruta, Lake Tepokalipuka
|
|
INSERT INTO `fishing_catch` VALUES (118,1,66); -- Buburimu Peninsula, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (120,1,73); -- Sauromugue Champaign, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (121,1,86); -- The Sanctuary of Zi'Tah, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (122,1,85); -- Ro'Maeve, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (123,1,101); -- Yuhtunga Jungle, Northeast Pond
|
|
INSERT INTO `fishing_catch` VALUES (123,2,102); -- Yuhtunga Jungle, Gremini Falls
|
|
INSERT INTO `fishing_catch` VALUES (123,3,103); -- Yuhtunga Jungle, Southwest Pond
|
|
INSERT INTO `fishing_catch` VALUES (123,4,104); -- Yuhtunga Jungle, Southwest Waterfall - South
|
|
INSERT INTO `fishing_catch` VALUES (123,5,105); -- Yuhtunga Jungle, Southwest Waterfall - North
|
|
INSERT INTO `fishing_catch` VALUES (123,6,106); -- Yuhtunga Jungle, Other Waterside
|
|
INSERT INTO `fishing_catch` VALUES (124,1,111); -- Yhoator Jungle, Front of Temple - East Side
|
|
INSERT INTO `fishing_catch` VALUES (124,2,112); -- Yhoator Jungle, Front of Temple - West Side
|
|
INSERT INTO `fishing_catch` VALUES (124,3,113); -- Yhoator Jungle, Teardrop Spring
|
|
INSERT INTO `fishing_catch` VALUES (124,4,114); -- Yhoator Jungle, Underground Pool 1
|
|
INSERT INTO `fishing_catch` VALUES (124,5,115); -- Yhoator Jungle, Bloodlet Spring
|
|
INSERT INTO `fishing_catch` VALUES (124,6,116); -- Yhoator Jungle, Underground Pool 3
|
|
INSERT INTO `fishing_catch` VALUES (124,7,117); -- Yhoator Jungle, Underground Pool 2
|
|
INSERT INTO `fishing_catch` VALUES (125,1,90); -- Western Altepa Desert, Oasis of Hubol
|
|
INSERT INTO `fishing_catch` VALUES (125,2,91); -- Western Altepa Desert, Central Spring
|
|
INSERT INTO `fishing_catch` VALUES (126,1,78); -- Qufim Island, Northwest Seaside
|
|
INSERT INTO `fishing_catch` VALUES (126,2,79); -- Qufim Island, Southwest Seaside
|
|
INSERT INTO `fishing_catch` VALUES (126,3,80); -- Qufim Island, Other Seaside
|
|
INSERT INTO `fishing_catch` VALUES (130,1,118); -- Ru'Aun Gardens, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (140,1,18); -- Ghelsba Outpost, Pond North
|
|
INSERT INTO `fishing_catch` VALUES (140,2,18); -- Ghelsba Outpost, Pond South
|
|
INSERT INTO `fishing_catch` VALUES (140,3,19); -- Ghelsba Outpost, River
|
|
INSERT INTO `fishing_catch` VALUES (142,1,20); -- Yughott Grotto, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (143,1,45); -- Palborough Mines, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (145,1,55); -- Giddeus, Giddeus Spring
|
|
INSERT INTO `fishing_catch` VALUES (145,2,56); -- Giddeus, Pond - West
|
|
INSERT INTO `fishing_catch` VALUES (145,3,57); -- Giddeus, Pond - North
|
|
INSERT INTO `fishing_catch` VALUES (145,4,58); -- Giddeus, Misc Puddles
|
|
INSERT INTO `fishing_catch` VALUES (149,1,31); -- Davoi, Basin of a Waterfall
|
|
INSERT INTO `fishing_catch` VALUES (149,2,32); -- Davoi, Wailing Pond
|
|
INSERT INTO `fishing_catch` VALUES (149,3,33); -- Davoi, Pond
|
|
INSERT INTO `fishing_catch` VALUES (149,4,34); -- Davoi, Other Waterside
|
|
INSERT INTO `fishing_catch` VALUES (151,1,0); -- Castle Oztroja, PLD AF Fishing Spot
|
|
INSERT INTO `fishing_catch` VALUES (151,2,72); -- Castle Oztroja, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (153,1,81); -- The Boyahda Tree, Waterfall Basin
|
|
INSERT INTO `fishing_catch` VALUES (153,2,82); -- The Boyahda Tree, Waterfall Basin - Hidden
|
|
INSERT INTO `fishing_catch` VALUES (153,3,83); -- The Boyahda Tree, Other Waterside
|
|
INSERT INTO `fishing_catch` VALUES (154,1,84); -- Dragon's Aery, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (157,1,77); -- Middle Delkfutt's Tower, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (158,1,77); -- Upper Delkfutt's Tower, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (159,1,110); -- Temple of Uggalepih, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (160,1,107); -- Den of Rancor, Pool E-8
|
|
INSERT INTO `fishing_catch` VALUES (160,2,108); -- Den of Rancor, Pool F-11
|
|
INSERT INTO `fishing_catch` VALUES (160,3,109); -- Den of Rancor, Misc Water
|
|
INSERT INTO `fishing_catch` VALUES (166,1,72); -- Ranguemont Pass, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (167,1,15); -- Bostaunieux Oubliette, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (172,1,48); -- Zeruhn Mines, River
|
|
INSERT INTO `fishing_catch` VALUES (172,2,49); -- Zeruhn Mines, Pool
|
|
INSERT INTO `fishing_catch` VALUES (173,1,41); -- Korroloka Tunnel, Salt Water
|
|
INSERT INTO `fishing_catch` VALUES (173,2,42); -- Korroloka Tunnel, Fresh Water
|
|
INSERT INTO `fishing_catch` VALUES (174,1,93); -- Kuftal Tunnel, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (176,1,96); -- Sea Serpent Grotto, Other Seaside
|
|
INSERT INTO `fishing_catch` VALUES (176,2,97); -- Sea Serpent Grotto, Pond Under a Bridge
|
|
INSERT INTO `fishing_catch` VALUES (176,3,98); -- Sea Serpent Grotto, Interior of Hidden Door - Mythril
|
|
INSERT INTO `fishing_catch` VALUES (176,4,99); -- Sea Serpent Grotto, Interior of Hidden Door - Gold
|
|
INSERT INTO `fishing_catch` VALUES (176,5,100); -- Sea Serpent Grotto, Misc Puddles
|
|
INSERT INTO `fishing_catch` VALUES (178,1,118); -- The Shrine of Ru'Avitau, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (184,1,77); -- Lower Delkfutt's Tower, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (191,1,40); -- Dangruf Wadi, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (193,1,24); -- Ordelle's Caves, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (196,1,22); -- Gusgen Mines, Pool Upper West
|
|
INSERT INTO `fishing_catch` VALUES (196,2,22); -- Gusgen Mines, Pool Upper East
|
|
INSERT INTO `fishing_catch` VALUES (196,3,22); -- Gusgen Mines, Pool Lower East
|
|
INSERT INTO `fishing_catch` VALUES (196,4,21); -- Gusgen Mines, Interior Pool West
|
|
INSERT INTO `fishing_catch` VALUES (196,5,21); -- Gusgen Mines, Interior Pool Center
|
|
INSERT INTO `fishing_catch` VALUES (196,6,21); -- Gusgen Mines, Interior Pool East
|
|
INSERT INTO `fishing_catch` VALUES (204,1,76); -- Fei'Yin, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (208,1,88); -- Quicksand Caves, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (213,1,67); -- Labyrinth of Onzozo, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (220,1,136); -- Ship bound for Selbina, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (221,1,136); -- Ship bound for Mhaura, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (227,1,137); -- Ship bound for Selbina (with Pirates), Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (228,1,137); -- Ship bound for Mhaura (with Pirates), Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (231,1,9); -- Northern San d'Oria, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (232,1,10); -- Port San d'Oria, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (234,1,8); -- Bastok Mines, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (235,1,5); -- Bastok Markets, North Side
|
|
INSERT INTO `fishing_catch` VALUES (235,2,6); -- Bastok Markets, South Side
|
|
INSERT INTO `fishing_catch` VALUES (236,1,7); -- Port Bastok, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (238,1,11); -- Windurst Waters, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (239,1,11); -- Windurst Walls, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (240,1,4); -- Port Windurst, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (241,1,11); -- Windurst Woods, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (242,1,12); -- Heavens Tower, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (245,1,13); -- Lower Jeuno, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (246,1,14); -- Port Jeuno, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (247,1,89); -- Rabao, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (248,1,25); -- Selbina, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (249,1,71); -- Mhaura, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (250,1,94); -- Kazham, Whole Zone
|
|
INSERT INTO `fishing_catch` VALUES (252,1,95); -- Norg, Whole Zone
|
|
/*!40000 ALTER TABLE `fishing_catch` 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-01-01 5:11:33
|