-- MySQL dump 10.13  Distrib 8.0.12, for Win64 (x86_64)
--
-- Host: localhost    Database: bdodae_new
-- ------------------------------------------------------
-- Server version	8.0.12

/*!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 */;
 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 `city`
--

DROP TABLE IF EXISTS `city`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `city` (
  `city_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(50) NOT NULL,
  PRIMARY KEY (`city_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `city`
--

LOCK TABLES `city` WRITE;
/*!40000 ALTER TABLE `city` DISABLE KEYS */;
INSERT INTO `city` VALUES (1,'Altinova'),(2,'Tarif'),(3,'Heidel'),(4,'Sand Grain Bazaar'),(5,'Valencia'),(6,'Ancado'),(7,'Old Wisdom Tree'),(8,'Duvencrune'),(9,'Grana'),(10,'Trent'),(11,'Port Epheria'),(12,'Olvia'),(13,'Calpheon'),(14,'Velia'),(15,'Glish'),(16,'Arehaza'),(17,'Shakatu'),(18,'Keplan'),(19,'Iliya Island');
/*!40000 ALTER TABLE `city` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `distance`
--

DROP TABLE IF EXISTS `distance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `distance` (
  `distance_id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` int(11) DEFAULT NULL,
  `city_id` int(11) NOT NULL,
  `subnode_id` int(11) NOT NULL,
  PRIMARY KEY (`distance_id`),
  KEY `city_id` (`city_id`),
  KEY `subnode_id` (`subnode_id`),
  CONSTRAINT `distance_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`),
  CONSTRAINT `distance_ibfk_2` FOREIGN KEY (`subnode_id`) REFERENCES `subnode` (`subnode_id`)
) ENGINE=InnoDB AUTO_INCREMENT=679 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `distance`
--

LOCK TABLES `distance` WRITE;
/*!40000 ALTER TABLE `distance` DISABLE KEYS */;
INSERT INTO `distance` VALUES (1,1113,1,1),(2,2063,2,1),(3,1113,1,2),(4,2063,2,2),(5,702,2,3),(6,2000,3,3),(7,2325,1,3),(8,750,2,4),(9,2014,3,4),(10,2404,1,4),(11,4507,4,5),(12,5664,5,5),(13,7415,6,5),(14,1826,7,6),(15,2585,8,6),(16,3916,9,6),(17,4807,10,6),(18,1844,7,7),(19,2338,8,7),(20,3934,9,7),(21,4825,10,7),(22,4626,11,8),(23,3264,12,8),(24,4000,13,8),(25,653,3,9),(26,1712,14,9),(27,1793,15,9),(28,652,3,10),(29,1711,14,10),(30,1792,15,10),(31,382,6,11),(32,1915,5,11),(33,5394,16,11),(34,365,6,12),(35,1898,5,12),(36,5376,16,12),(37,1857,3,13),(38,1879,2,13),(39,3634,1,13),(40,1909,2,14),(41,1887,3,14),(42,3664,1,14),(43,1688,2,15),(44,2951,3,15),(45,3341,1,15),(46,1171,14,16),(47,1907,12,16),(48,2357,3,16),(49,2375,15,16),(50,1293,12,17),(51,2620,14,17),(52,3706,11,17),(53,1797,12,18),(54,2888,14,18),(55,4370,11,18),(56,4377,3,18),(57,682,16,19),(58,2947,5,19),(59,4980,6,19),(60,786,16,20),(61,2748,5,20),(62,4781,6,20),(63,1462,11,21),(64,3294,13,21),(65,522,14,22),(66,1385,3,22),(67,2530,12,22),(68,517,14,23),(69,1379,3,23),(70,2525,12,23),(71,2094,17,24),(72,5876,5,24),(73,1660,11,25),(74,3493,13,25),(75,3534,12,25),(76,1901,11,26),(77,3136,12,26),(78,3734,13,26),(79,505,14,27),(80,1555,3,27),(81,2316,12,27),(82,468,14,28),(83,1464,3,28),(84,2279,12,28),(85,2326,1,29),(86,2340,4,29),(87,806,4,30),(88,3684,1,30),(89,5078,17,30),(90,786,4,31),(91,3663,1,31),(92,5058,17,31),(93,1785,13,32),(94,1965,10,32),(95,2059,18,32),(96,2265,19,33),(97,4354,14,33),(98,4403,12,33),(99,1462,13,34),(100,2341,12,34),(101,2548,18,34),(102,1459,13,35),(103,2227,11,35),(104,2338,12,35),(105,2546,18,35),(106,1459,13,36),(107,2227,11,36),(108,2338,12,36),(109,2546,18,36),(110,468,4,37),(111,2663,1,37),(112,4057,17,37),(113,423,4,38),(114,2694,1,38),(115,4089,17,38),(116,220,12,39),(117,2070,14,39),(118,1101,3,40),(119,1639,15,40),(120,674,14,41),(121,1840,12,41),(122,2201,3,41),(123,669,14,42),(124,1835,12,42),(125,2196,3,42),(126,877,14,43),(127,1453,12,43),(128,2434,3,43),(129,874,14,44),(130,1451,12,44),(131,2431,3,44),(132,406,3,45),(133,1169,15,45),(134,430,3,46),(135,1239,15,46),(136,441,3,47),(137,1204,15,47),(138,3814,4,48),(139,6680,5,48),(140,6846,1,48),(141,3812,4,49),(142,6678,5,49),(143,6843,1,49),(144,3875,4,50),(145,6906,1,50),(146,7223,5,50),(147,3807,4,51),(148,6838,1,51),(149,7154,5,51),(150,888,14,52),(151,2199,3,52),(152,2913,11,53),(153,4746,13,53),(154,6376,12,53),(155,1398,19,54),(156,4084,1,54),(157,4340,2,54),(158,4952,14,54),(159,1775,19,55),(160,3964,1,55),(161,4220,2,55),(162,5346,14,55),(163,2118,18,56),(164,2634,15,56),(165,3825,3,56),(166,4380,8,56),(167,4510,10,56),(168,2071,18,57),(169,2587,15,57),(170,3778,3,57),(171,4333,8,57),(172,4463,10,57),(173,476,8,58),(174,3916,7,58),(175,6006,9,58),(176,536,8,59),(177,4011,7,59),(178,6102,9,59),(179,674,14,60),(180,1798,3,60),(181,2684,12,60),(182,668,14,61),(183,1791,3,61),(184,2678,12,61),(185,1862,2,62),(186,3125,3,62),(187,3391,1,62),(188,1820,2,63),(189,3083,3,63),(190,3349,1,63),(191,2258,14,64),(192,2818,12,64),(193,3748,3,64),(194,4049,19,64),(195,583,5,65),(196,1788,6,65),(197,4062,16,65),(198,636,5,66),(199,1841,6,66),(200,4051,16,66),(201,594,5,67),(202,1798,6,67),(203,4073,16,67),(204,445,14,68),(205,1606,3,68),(206,2454,12,68),(207,404,14,69),(208,1621,3,69),(209,2414,12,69),(210,630,5,70),(211,2463,6,70),(212,4028,16,70),(213,699,5,71),(214,2532,6,71),(215,4098,16,71),(216,407,14,72),(217,1423,3,72),(218,2554,12,72),(219,1080,14,73),(220,1672,12,73),(221,2421,3,73),(222,1076,14,74),(223,1668,12,74),(224,2416,3,74),(225,2278,8,75),(226,3862,7,75),(227,5952,9,75),(228,6843,10,75),(229,5302,5,76),(230,5594,6,76),(231,8781,16,76),(232,5168,5,77),(233,5459,6,77),(234,8647,16,77),(235,4427,5,78),(236,4718,6,78),(237,7906,16,78),(238,4747,5,79),(239,5038,6,79),(240,8225,16,79),(241,4615,5,80),(242,4906,6,80),(243,8093,16,80),(244,3176,18,81),(245,3405,8,81),(246,3692,15,81),(247,4883,3,81),(248,3279,18,82),(249,3507,8,82),(250,3794,15,82),(251,4985,3,82),(252,799,15,83),(253,1071,3,83),(254,427,15,84),(255,1413,3,84),(256,1823,18,84),(257,431,15,85),(258,1416,3,85),(259,1826,18,85),(260,1172,18,86),(261,1334,13,86),(262,2943,15,86),(263,3069,10,86),(264,1333,18,87),(265,1494,13,87),(266,3104,15,87),(267,3229,10,87),(268,687,14,88),(269,1194,3,88),(270,2748,12,88),(271,682,14,89),(272,1189,3,89),(273,2744,12,89),(274,1550,1,90),(275,2682,4,90),(276,3410,2,90),(277,3658,17,90),(278,1744,1,91),(279,2721,4,91),(280,3492,17,91),(281,3604,2,91),(282,1419,18,92),(283,2783,13,92),(284,2984,10,92),(285,3190,15,92),(286,1956,9,93),(287,1998,7,93),(288,4242,10,93),(289,548,14,94),(290,1700,12,94),(291,2064,3,94),(292,549,14,95),(293,1701,12,95),(294,2065,3,95),(295,2421,12,96),(296,3522,14,96),(297,4049,19,96),(298,2771,12,97),(299,3635,14,97),(300,3877,19,97),(301,2817,17,98),(302,5418,5,98),(303,6883,6,98),(304,2807,17,99),(305,5408,5,99),(306,6872,6,99),(307,4957,5,100),(308,5249,6,100),(309,8436,16,100),(310,1226,2,101),(311,1447,3,101),(312,2955,14,101),(313,2981,1,101),(314,1215,2,102),(315,1436,3,102),(316,2944,14,102),(317,2970,1,102),(318,2194,13,103),(319,2952,18,103),(320,3415,12,103),(321,3540,3,103),(322,3996,14,103),(323,285,2,104),(324,1801,1,104),(325,2703,3,104),(326,292,2,105),(327,1808,1,105),(328,2710,3,105),(329,317,18,106),(330,1337,13,106),(331,1939,15,106),(332,3267,10,106),(333,2309,7,107),(334,2400,8,107),(335,4399,9,107),(336,5290,10,107),(337,2191,7,108),(338,2282,8,108),(339,4281,9,108),(340,5172,10,108),(341,3824,8,109),(342,4051,18,109),(343,4081,2,109),(344,4382,3,109),(345,4567,15,109),(346,3763,8,110),(347,3990,18,110),(348,4043,2,110),(349,4344,3,110),(350,4505,15,110),(351,1238,13,111),(352,2032,18,111),(353,2458,12,111),(354,2858,17,112),(355,5130,5,112),(356,6595,6,112),(357,2854,17,113),(358,5127,5,113),(359,6591,6,113),(360,2200,1,114),(361,3014,4,114),(362,3714,17,114),(363,1298,9,115),(364,1980,7,115),(365,4960,10,115),(366,2303,1,116),(367,3043,17,116),(368,3117,4,116),(369,2559,12,117),(370,3054,11,117),(371,3960,14,117),(372,2868,12,118),(373,3363,11,118),(374,4195,14,118),(375,535,14,119),(376,1934,12,119),(377,2066,3,119),(378,1024,10,120),(379,2571,18,120),(380,2747,13,120),(381,441,10,121),(382,2605,18,121),(383,2781,13,121),(384,1671,9,122),(385,2945,7,122),(386,6560,10,122),(387,3620,9,123),(388,4525,7,123),(389,4528,10,123),(390,1809,12,124),(391,3190,11,124),(392,3210,14,124),(393,1618,14,125),(394,1686,12,125),(395,3107,3,125),(396,3648,19,125),(397,352,10,126),(398,3171,13,126),(399,3360,18,126),(400,786,3,127),(401,1215,15,127),(402,2317,14,127),(403,3103,12,127),(404,777,3,128),(405,1207,15,128),(406,2309,14,128),(407,3095,12,128),(408,1359,3,129),(409,1960,15,129),(410,2428,14,129),(411,1326,10,130),(412,2117,13,130),(413,3074,11,130),(414,3431,18,130),(415,1265,10,131),(416,2210,13,131),(417,3167,11,131),(418,3524,18,131),(419,1183,8,132),(420,5304,7,132),(421,5627,18,132),(422,1324,8,133),(423,5445,7,133),(424,5608,18,133),(425,2054,18,134),(426,2954,10,134),(427,3306,13,134),(428,1926,18,135),(429,2826,10,135),(430,3177,13,135),(431,2330,19,136),(432,2403,14,136),(433,2526,12,136),(434,2165,14,137),(435,2375,12,137),(436,2779,19,137),(437,1104,1,138),(438,2583,2,138),(439,2502,2,139),(440,2418,3,139),(441,3888,1,139),(442,4178,19,139),(443,2498,2,140),(444,2414,3,140),(445,3884,1,140),(446,4174,19,140),(447,1727,2,141),(448,2429,1,141),(449,3329,3,141),(450,1750,11,142),(451,3582,13,142),(452,679,3,143),(453,1374,15,143),(454,686,3,144),(455,1381,15,144),(456,21497,12,145),(457,22312,19,145),(458,22371,14,145),(459,23804,11,145),(460,21453,12,146),(461,22269,19,146),(462,22327,14,146),(463,23760,11,146),(464,612,3,147),(465,1006,15,147),(466,2235,14,147),(467,546,3,148),(468,1535,14,148),(469,547,3,149),(470,1536,14,149),(471,1345,3,150),(472,1530,15,150),(473,2363,14,150),(474,1334,3,151),(475,1519,15,151),(476,2352,14,151),(477,2128,16,152),(478,4226,5,152),(479,6258,6,152),(480,742,13,153),(481,1697,18,153),(482,900,13,154),(483,1879,18,154),(484,818,13,155),(485,1760,18,155),(486,3036,11,156),(487,4129,12,156),(488,4869,13,156),(489,2666,11,157),(490,3713,12,157),(491,4499,13,157),(492,1219,13,158),(493,1974,18,158),(494,1011,2,159),(495,2320,1,159),(496,2613,3,159),(497,1042,2,160),(498,2320,1,160),(499,2613,3,160),(500,2283,12,161),(501,2926,14,161),(502,3068,19,161),(503,2446,19,162),(504,2935,12,162),(505,3086,14,162),(506,942,18,163),(507,1599,13,163),(508,2178,15,163),(509,1742,19,164),(510,4203,14,164),(511,4252,12,164),(512,1655,13,165),(513,2178,18,165),(514,2345,10,165),(515,2351,19,166),(516,3487,1,166),(517,3743,2,166),(518,2523,19,167),(519,3279,1,167),(520,3535,2,167),(521,2496,4,168),(522,3817,5,168),(523,5284,1,168),(524,2502,4,169),(525,3822,5,169),(526,5290,1,169),(527,5107,5,170),(528,5406,4,170),(529,6857,6,170),(530,7693,16,170),(531,1698,9,171),(532,2972,7,171),(533,6587,10,171),(534,696,18,172),(535,2060,13,172),(536,3088,10,172),(537,3029,19,173),(538,4894,1,173),(539,5150,2,173),(540,2545,19,174),(541,4058,1,174),(542,4314,2,174),(543,1674,4,175),(544,1905,1,175),(545,1031,11,176),(546,1348,13,176),(547,1028,11,177),(548,1345,13,177),(549,1479,11,178),(550,3312,13,178),(551,4319,12,178),(552,1493,11,179),(553,3326,13,179),(554,4053,12,179),(555,1679,10,180),(556,1803,18,180),(557,2012,13,180),(558,1687,10,181),(559,1811,18,181),(560,2020,13,181),(561,1863,13,182),(562,1941,10,182),(563,2894,11,182),(564,3177,18,182),(565,3058,5,183),(566,3350,6,183),(567,6537,16,183),(568,901,11,184),(569,2734,13,184),(570,4101,12,184),(571,1124,15,185),(572,1747,3,185),(573,2346,18,185),(574,600,7,186),(575,1780,9,186),(576,4256,10,186),(577,537,17,187),(578,4674,4,187),(579,589,17,188),(580,4725,4,188),(581,591,17,189),(582,4728,4,189),(583,1965,8,190),(584,2942,7,190),(585,5032,9,190),(586,5923,10,190),(587,1269,2,191),(588,2533,3,191),(589,2923,1,191),(590,513,15,192),(591,1376,3,192),(592,2167,18,192),(593,513,15,193),(594,1376,3,193),(595,2166,18,193),(596,1024,9,194),(597,1924,7,194),(598,5580,10,194),(599,2469,12,195),(600,2646,11,195),(601,3831,14,195),(602,2637,12,196),(603,2705,11,196),(604,3999,14,196),(605,1765,2,197),(606,3029,3,197),(607,3295,1,197),(608,1692,19,198),(609,4537,1,198),(610,4792,2,198),(611,5021,14,198),(612,1922,19,199),(613,4805,1,199),(614,4952,14,199),(615,5060,2,199),(616,2356,11,200),(617,4188,13,200),(618,2172,11,201),(619,4005,13,201),(620,603,12,202),(621,2727,14,202),(622,3258,13,202),(623,6943,5,203),(624,7188,4,203),(625,7921,16,203),(626,7025,5,204),(627,7271,4,204),(628,8004,16,204),(629,6873,5,205),(630,7119,4,205),(631,7852,16,205),(632,2171,9,206),(633,3260,7,206),(634,4338,10,206),(635,812,14,207),(636,1839,12,207),(637,2174,3,207),(638,812,14,208),(639,1840,12,208),(640,2175,3,208),(641,742,10,209),(642,2979,13,209),(643,2996,8,210),(644,3851,18,210),(645,4367,15,210),(646,4679,2,210),(647,4980,3,210),(648,2956,8,211),(649,3792,18,211),(650,4307,15,211),(651,4760,2,211),(652,5061,3,211),(653,530,5,212),(654,2097,6,212),(655,3928,16,212),(656,522,5,213),(657,2089,6,213),(658,3920,16,213),(659,526,5,214),(660,2094,6,214),(661,3925,16,214),(662,1961,1,215),(663,2353,4,215),(664,3382,17,215),(665,1943,7,216),(666,3000,10,216),(667,3555,9,216),(668,257,12,217),(669,2483,14,217),(670,3088,13,217),(671,1608,9,218),(672,3025,7,218),(673,6005,10,218),(674,1620,19,219),(675,3291,14,219),(676,3340,12,219),(677,340,12,220),(678,1902,14,220);
/*!40000 ALTER TABLE `distance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item`
--

DROP TABLE IF EXISTS `item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `item` (
  `item_id` int(11) NOT NULL,
  `name` char(50) NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item`
--

LOCK TABLES `item` WRITE;
/*!40000 ALTER TABLE `item` DISABLE KEYS */;
INSERT INTO `item` VALUES (0,'Acacia Sap'),(1,'Acacia Timber'),(2,'Aloe'),(3,'Altar Imp\'s Broken Trumpet'),(4,'Ancient Artifact Fragment'),(5,'Ancient Civilization Follower\'s Seal'),(6,'Arrow Mushroom'),(7,'Ash Sap'),(8,'Ash Timber'),(9,'Bag Of Muddy Water'),(10,'Barley'),(11,'Big Arrow Mushroom'),(12,'Big Cloud Mushroom'),(13,'Big Dwarf Mushroom'),(14,'Big Emperor Mushroom'),(15,'Big Fortune Teller Mushroom'),(16,'Big Ghost Mushroom'),(17,'Big Sky Mushroom'),(18,'Big Tiger Mushroom'),(19,'Birch Plank'),(20,'Birch Sap'),(21,'Birch Timber'),(22,'Black Dirt'),(23,'Bloody Tree Knot'),(24,'Blue Umbrella Mushroom'),(25,'Bracken'),(26,'Bunch Of Silk Honey Grass'),(27,'Bunch Of Silver Azaleas'),(28,'Cactus Rind'),(29,'Cactus Sap'),(30,'Cactus Thorn'),(31,'Cedar Sap'),(32,'Cedar Timber'),(33,'Chicken Meat'),(34,'Cinnamon'),(35,'Cloth From The Altar Imp Barracks'),(36,'Cloud Mushroom'),(37,'Coal'),(38,'Coconut'),(39,'Contaminated Tooth'),(40,'Cooking Honey'),(41,'Copper Ore'),(42,'Corn'),(43,'Cotton'),(44,'Cotton Yarn'),(45,'Cracked Fang'),(46,'Cursed Quartz Fragment'),(47,'Date Palm'),(48,'Desert Fogan\'s Helmet Shard'),(49,'Dried Angler'),(50,'Dried Bigeye'),(51,'Dried Blue Tang'),(52,'Dried Bluefish'),(53,'Dried Cero'),(54,'Dried Checkerboard Wrasse'),(55,'Dried Clownfish'),(56,'Dried Dolphinfish'),(57,'Dried Filefish'),(58,'Dried Flatfish'),(59,'Dried Flying Fish'),(60,'Dried Golden-Thread'),(61,'Dried Grouper'),(62,'Dried Grunt'),(63,'Dried Gurnard'),(64,'Dried John Dory'),(65,'Dried Maomao'),(66,'Dried Mullet'),(67,'Dried Nibbler'),(68,'Dried Octopus'),(69,'Dried Pintado'),(70,'Dried Porgy'),(71,'Dried Ray'),(72,'Dried Rockfish'),(73,'Dried Rosefish'),(74,'Dried Round Herring'),(75,'Dried Saurel'),(76,'Dried Scorpion Fish'),(77,'Dried Sea Bass'),(78,'Dried Siganid'),(79,'Dried Skipjack'),(80,'Dried Striped Catfish'),(81,'Dried Surfperch'),(82,'Dried Swellfish'),(83,'Dried Swordfish'),(84,'Dried Tapertail Anchovy'),(85,'Dried Tuna'),(86,'Dried Whiting'),(87,'Dry Mane Grass'),(88,'Dry Rock Fragment'),(89,'Dull Bone Fragment'),(90,'Dull Club Piece'),(91,'Dwarf Mushroom'),(92,'Egg'),(93,'Elder Tree Plank'),(94,'Elder Tree Sap'),(95,'Elder Tree Timber'),(96,'Emperor Mushroom'),(97,'Faded Magic Powder'),(98,'Fig'),(99,'Fir Plank'),(100,'Fir Sap'),(101,'Fir Timber'),(102,'Flax'),(103,'Flax Thread'),(104,'Fleece'),(105,'Fortune Teller Mushroom'),(106,'Freekeh'),(107,'Ghost Mushroom'),(108,'Grape'),(109,'Green Pendulous Mushroom'),(110,'Helmet Ornament'),(111,'High-Quality Arrow Mushroom'),(112,'High-Quality Strawberry'),(113,'High-Quality Sweet Potato'),(114,'Iron Ore'),(115,'Knitting Yarn'),(116,'Lead Ore'),(117,'Loopy Tree Plank'),(118,'Loopy Tree Sap'),(119,'Loopy Tree Timber'),(120,'Magic Stone Fragment'),(121,'Maple Sap'),(122,'Maple Timber'),(123,'Monk\'s Branch'),(124,'Moss Tree Plank'),(125,'Moss Tree Sap'),(126,'Moss Tree Timber'),(127,'Mythril'),(128,'Noc Ore'),(129,'Nutmeg'),(130,'Obscuring Golem Fragment'),(131,'Old Tree Bark'),(132,'Olive'),(133,'Oyster'),(134,'Palm Plank'),(135,'Palm Sap'),(136,'Palm Timber'),(137,'Paprika'),(138,'Pile Of Sunrise Herbs'),(139,'Pine Plank'),(140,'Pine Sap'),(141,'Pine Timber'),(142,'Pink Trumpet Mushroom'),(143,'Pistachio'),(144,'Platinum Ore'),(145,'Potato'),(146,'Powder Of Crevice'),(147,'Powder Of Darkness'),(148,'Powder Of Earth'),(149,'Powder Of Flame'),(150,'Powder Of Time'),(151,'Pumpkin'),(152,'Purified Water'),(153,'Red Tree Lump'),(154,'Rough Black Crystal'),(155,'Rough Blue Crystal'),(156,'Rough Diamond'),(157,'Rough Green Crystal'),(158,'Rough Lapis Lazuli'),(159,'Rough Mud Crystal'),(160,'Rough Opal'),(161,'Rough Red Crystal'),(162,'Rough Ruby'),(163,'Rough Translucent Crystal'),(164,'Rough Violet Crystal'),(165,'Sharp Helmet Fragment'),(166,'Shrimp'),(167,'Silk Honey Grass'),(168,'Silk Thread'),(169,'Silkworm Cocoon'),(170,'Silver Azalea'),(171,'Sky Mushroom'),(172,'Special Arrow Mushroom'),(173,'Special Sweet Potato'),(174,'Spirit\'s Leaf'),(175,'Star Anise'),(176,'Strawberry'),(177,'Sulfur'),(178,'Sunrise Herb'),(179,'Sweet Potato'),(180,'Teff'),(181,'Thuja Plank'),(182,'Thuja Sap'),(183,'Thuja Timber'),(184,'Tiger Mushroom'),(185,'Tin Ore'),(186,'Titanium Ore'),(187,'Token Of Crescent'),(188,'Tough Bear Hide'),(189,'Trace Of Ascension'),(190,'Trace Of Battle'),(191,'Trace Of Chaos'),(192,'Trace Of Despair'),(193,'Trace Of Forest'),(194,'Trace Of Hunting'),(195,'Trace Of Memory'),(196,'Trace Of Origin'),(197,'Trace Of Savagery'),(198,'Trace Of The Earth'),(199,'Trace Of Violence'),(200,'Vanadium Ore'),(201,'Vedelona'),(202,'Volcanic Umbrella Mushroom'),(203,'Wagon Wheel'),(204,'Weathered Cursed Fang'),(205,'Weathered Rock Fragment From Ruins Site'),(206,'Wheat'),(207,'White Cedar Sap'),(208,'White Cedar Timber'),(209,'White Flower Mushroom'),(210,'White Umbrella Mushroom'),(211,'Withered Leaf'),(212,'Zinc Ore');
/*!40000 ALTER TABLE `item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `node`
--

DROP TABLE IF EXISTS `node`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `node` (
  `node_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(50) NOT NULL,
  `cp` int(11) DEFAULT '0',
  `area` char(50) DEFAULT NULL,
  `type` char(50) DEFAULT NULL,
  `region_mod_percent` float DEFAULT NULL,
  `connections` char(255) DEFAULT NULL,
  PRIMARY KEY (`node_id`)
) ENGINE=InnoDB AUTO_INCREMENT=381 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `node`
--

LOCK TABLES `node` WRITE;
/*!40000 ALTER TABLE `node` DISABLE KEYS */;
INSERT INTO `node` VALUES (1,'Abandoned Iron Mine',2,'Mediah','Worker Node',0,'Abandoned Iron Mine Saunil District, Abandoned Iron Mine Rhutum District, Altinova Entrance'),(2,'Abandoned Iron Mine Entrance',1,'Mediah','Connection Node',NULL,'Highland Junction, Alumn Rock Valley'),(3,'Abandoned Iron Mine Rhutum District',1,'Mediah','Connection Node',NULL,'Abandoned Iron Mine, Abun'),(4,'Abandoned Iron Mine Saunil District',1,'Mediah','Connection Node',NULL,'Alumn Rock Valley, Abandoned Iron Mine, Marni\'s 2nd Lab'),(5,'Abandoned Land',1,'Calpheon','Connection Node',NULL,'Isolated Sentry Post, Cohen Farm, Calpheon'),(6,'Abandoned Monastery',3,'Calpheon','Connection Node',NULL,'Treant Forest, Lumberjack\'s Rest Area, Tobare\'s Cabin'),(7,'Abandoned Quarry',2,'Calpheon','Connection Node',NULL,'Tarte Rock Fork, Gehaku Plain'),(8,'Abun',1,'Mediah','Connection Node',NULL,'Marni\'s 2nd Lab, Abandoned Iron Mine Rhutum District, Altinova'),(9,'Acher Guard Post',3,'Kamasylvia','Connection Node',NULL,'Western Valtarra Mountains, Loopy Tree Forest'),(10,'Acher Southern Camp',1,'Kamasylvia','Connection Node',NULL,'Grana'),(11,'Acher Western Camp',2,'Kamasylvia','Connection Node',NULL,'Loopy Tree Forest'),(12,'Ahib Conflict Zone',2,'Drieghan','Connection Node',NULL,'Akum Rocky Mountain, Lemoria Guard Post, Khalk Canyon'),(13,'Ahto Farm',2,'Mediah','Worker Node',0,'Stonetail Horse Ranch, Manes Hideout, Kamasylve Temple'),(14,'Ajir Island',1,'Balenos','Connection Node',NULL,'Al-Naha Island, Baremi Island'),(15,'Akman',5,'Valencia','Worker Node',1,'Crescent Mountains, Pilgrim\'s Sanctum: Humility, Pilgrim\'s Sanctum: Sincerity'),(16,'Akum Rocky Mountain',1,'Drieghan','Worker Node',1,'Ahib Conflict Zone'),(17,'Al-Naha Island',1,'Balenos','Connection Node',NULL,'Racid Island, Ajir Island'),(18,'Albresser Island',1,'Calpheon','Worker Node',1,'Eberdeen Island, Barater Island, Padix Island, Staren Island'),(19,'Alejandro Farm',2,'Serendia','Worker Node',0,'Northern Guard Camp, Lynch Farm Ruins'),(20,'Almai Island',1,'Calpheon','Connection Node',NULL,'Kuit Islands'),(21,'Altar Of Agris',1,'Balenos','Connection Node',NULL,'Imp Cave'),(22,'Altas Farmland',2,'Valencia','Worker Node',1,'Ancado, Ivory Wasteland'),(23,'Altinova',0,'Mediah','Town Node',NULL,'Altinova Gateway, Abun, Altinova Entrance'),(24,'Altinova Entrance',1,'Mediah','Connection Node',NULL,'Altinova, Stonebeak Shore, Awakening Bell, Highland Junction, Abandoned Iron Mine'),(25,'Altinova Gateway',3,'Valencia','Connection Node',NULL,'Altinova, Rock Post'),(26,'Alumn Rock Valley',1,'Mediah','Connection Node',NULL,'Splashing Point, Abandoned Iron Mine Saunil District, Wandering Rogue Den, Abandoned Iron Mine Entrance'),(27,'Ancado',1,'Valencia','Town Node',NULL,'Rakshan Observatory, Altas Farmland, Ancado Coast, Derko Island'),(28,'Ancado Coast',1,'Valencia','Connection Node',NULL,'Kmach Canyon, Pilgrim\'s Sanctum: Obedience, Ancado'),(29,'Ancient Fissure',2,'Mediah','Worker Node',0,'Rumbling Land, Ancient Ruins Excavation Site, Helms Post'),(30,'Ancient Ruins Excavation Site',1,'Mediah','Worker Node',0,'Kamasylve Temple, Canyon Of Corruption, Ancient Fissure'),(31,'Ancient Stone Chamber',1,'Balenos','Worker Node',0,'Forest Of Seclusion'),(32,'Angie Island',1,'Balenos','Worker Node',0,'Balvege Island, Marka Island'),(33,'Anti-Troll Fortification',3,'Calpheon','Connection Node',NULL,'Elder\'s Bridge Post, Isolated Sentry Post, Bernianto Farm, Contaminated Farm'),(34,'Arakil Island',1,'Balenos','Connection Node',NULL,'Kanvera Island, Iliya Island'),(35,'Areha Palm Forest',1,'Valencia','Worker Node',1,'Valencia, Arehaza'),(36,'Arehaza',0,'Valencia','Town Node',NULL,'Areha Palm Forest, Northern Sand Dune, Central Cantusa'),(37,'Arita Island',1,'Calpheon','Connection Node',NULL,'Padix Island, Lisz Island, Narvo Island, Tashu Island'),(38,'Ash Forest',3,'Kamasylvia','Connection Node',NULL,'Loopy Tree Forest'),(39,'Asula Highland',1,'Mediah','Connection Node',NULL,'Omar Lava Cave, Stonetail Horse Ranch, Kasula Farm, Highland Junction'),(40,'Atanis Pond',1,'Kamasylvia','Connection Node',NULL,'Lemoria Guard Post, Caduil Forest, Viv Foretta\'s Cabin'),(41,'Awakening Bell',1,'Mediah','Connection Node',NULL,'Omar Lava Cave, Altinova Entrance'),(42,'Baeza Island',1,'Calpheon','Worker Node',1,'Randis Island, Modric Island'),(43,'Bain Farmland',2,'Calpheon','Connection Node',NULL,'Oberen Farm, Phoniel\'s Cabin Entrance'),(44,'Balenos Forest',2,'Balenos','Worker Node',0,'Bartali Farm, Heidel Pass'),(45,'Balenos River Mouth',1,'Balenos','Connection Node',NULL,'Coastal Cliff, Olvia Coast, Wolf Hills'),(46,'Balvege Island',1,'Balenos','Connection Node',NULL,'Marlene Island, Angie Island, Eveto Island'),(47,'Bambu Valley',1,'Valencia','Worker Node',1,'Gahaz Bandit\'s Lair, Iris Canyon'),(48,'Bandit\'s Den Byway',3,'Serendia','Connection Node',NULL,'Biraghi Den, Forest Of Seclusion, Western Guard Camp'),(49,'Barater Island',1,'Calpheon','Worker Node',1,'Randis Island, Albresser Island'),(50,'Baremi Island',1,'Balenos','Connection Node',NULL,'Ajir Island, Weita Island, Orffs Island'),(51,'Barhan Gateway',3,'Valencia','Connection Node',NULL,'Capotia, Taphtar Plain'),(52,'Bartali Farm',2,'Balenos','Worker Node',0,'Balenos Forest, Marino Farm, Velia, Toscani Farm'),(53,'Bashim Base',1,'Valencia','Worker Node',1,'Waragon Nest, Pujiya Canyon'),(54,'Basilisk Den',4,'Valencia','Connection Node',NULL,'Gorgo Rock Belt, Leical Falls'),(55,'Bazaar Farmland',2,'Valencia','Worker Node',7,'Sand Grain Bazaar, Western Plateau Of Valencia'),(56,'Beacon Entrance Post',3,'Calpheon','Connection Node',NULL,'Trina Beacon Mounds, Oberen Farm, Marni Cave Path'),(57,'Behr',1,'Calpheon','Connection Node',NULL,'Longleaf Tree Forest, Behr Downstream'),(58,'Behr Downstream',3,'Calpheon','Connection Node',NULL,'Behr Riverhead, Phoniel\'s Cabin Entrance, Behr, Rhua Tree Stub, Saunil Battlefield'),(59,'Behr Riverhead',1,'Calpheon','Worker Node',0,'Phoniel\'s Cabin, Behr Downstream'),(60,'Beiruwa Island',1,'Mediah','Worker Node',1,'Taramura Island, Paratama Island'),(61,'Bernianto Farm',2,'Calpheon','Worker Node',0,'Anti-Troll Fortification, Bree Tree Ruins, Northern Wheat Plantation'),(62,'Biraghi Den',3,'Serendia','Connection Node',NULL,'Northern Plain Of Serendia, Bandit\'s Den Byway, Delphe Knights Castle'),(63,'Blood Wolf Town',3,'Drieghan','Connection Node',NULL,'Night Crow Post'),(64,'Bloody Monastery',1,'Serendia','Connection Node',NULL,'Southwestern Gateway'),(65,'Boa Island',1,'Valencia','Connection Node',NULL,'Orisha Island, Rosevan Island'),(66,'Bradie Fortress',1,'Serendia','Connection Node',NULL,'Orc Camp, Northern Plain Of Serendia, Oze Pass'),(67,'Bree Tree Ruins',1,'Calpheon','Worker Node',0,'Caphras Cave, Bernianto Farm'),(68,'Cadry Ruins',1,'Valencia','Connection Node',NULL,'Kunid\'s Vacation Spot, Veteran\'s Canyon, Deserted City of Runn'),(69,'Caduil Forest',1,'Kamasylvia','Connection Node',NULL,'Old Wisdom Tree, Manshaum Forest, Atanis Pond'),(70,'Calpheon',0,'Calpheon','Town Node',NULL,'Oberen Farm, Falres Dirt Farm, Dias Farm, Contaminated Farm, Abandoned Land, Gabino Farm'),(71,'Calpheon Castle',3,'Calpheon','Connection Node',NULL,'Calpheon Castle Site'),(72,'Calpheon Castle Site',1,'Calpheon','Connection Node',NULL,'North Kaia Ferry, Catfishman Camp, Gabino Farm, Calpheon Castle'),(73,'Calpheon Castle Western Forest',1,'Calpheon','Connection Node',NULL,'Catfishman Camp, Mansha Forest'),(74,'Cantusa Desert',2,'Valencia','Connection Node',NULL,'Muiquun, Pila Ku Jail, Dona Rocky Mountain, Central Cantusa'),(75,'Canyon Of Corruption',1,'Mediah','Connection Node',NULL,'Elric Shrine, Shuri Farm, Ancient Ruins Excavation Site, Stonetail Wasteland'),(76,'Caphras Cave',1,'Calpheon','Connection Node',NULL,'Florin, Bree Tree Ruins'),(77,'Capotia',1,'Valencia','Worker Node',7,'Sand Grain Bazaar, Barhan Gateway'),(78,'Casta Farm',1,'Balenos','Worker Node',0,'Olvia, Olvia Coast, Wolf Hills'),(79,'Castle Ruins',1,'Serendia','Worker Node',0,'Eastern Gateway, Kamasylve Temple, Soldier\'s Grave'),(80,'Catfishman Camp',1,'Calpheon','Connection Node',NULL,'Calpheon Castle Western Forest, Mansha Forest, Lake Kaia, Calpheon Castle Site'),(81,'Central Cantusa',1,'Valencia','Connection Node',NULL,'Arehaza, Cantusa Desert'),(82,'Central Guard Camp',3,'Serendia','Connection Node',NULL,'Glish, Costa Farm, Northern Cienaga, Glish Ruins'),(83,'Central Lemoria Camp',1,'Kamasylvia','Connection Node',NULL,'Manshaum Forest, Holo Forest, White Wood Forest, Navarn Steppe'),(84,'Closed Western Gateway',3,'Calpheon','Connection Node',NULL,'Gianin Farm, Southern Neutral Zone'),(85,'Coastal Cave',1,'Balenos','Worker Node',0,'Velia, Coastal Cliff'),(86,'Coastal Cliff',1,'Balenos','Worker Node',0,'Balenos River Mouth, Coastal Cave, Western Gateway'),(87,'Cohen Farm',2,'Calpheon','Connection Node',NULL,'Abandoned Land, Isolated Sentry Post'),(88,'Contaminated Farm',2,'Calpheon','Connection Node',NULL,'Calpheon, Anti-Troll Fortification'),(89,'Costa Farm',2,'Serendia','Worker Node',0,'Central Guard Camp, Heidel'),(90,'Crescent Mountains',3,'Valencia','Worker Node',1,'Western Plateau Of Valencia, Akman, Crescent Shrine'),(91,'Crescent Shrine',1,'Valencia','Worker Node',1,'Crescent Mountains'),(92,'Crioville',2,'Calpheon','Connection Node',NULL,'Longleaf Tree Forest, Longleaf Tree Sentry Post'),(93,'Cron Castle',2,'Balenos','Connection Node',NULL,'Cron Castle Site'),(94,'Cron Castle Site',1,'Balenos','Worker Node',0,'Cron Castle, Ehwaz Hill, Mediah Northern Gateway'),(95,'Dane Canyon',2,'Calpheon','Connection Node',NULL,'Gehaku Plain, Saunil Camp'),(96,'Daton Island',1,'Calpheon','Worker Node',1,'Oben Island, Ginburrey Island, Teste Island'),(97,'Delinghart Island',1,'Mediah','Worker Node',1,'Pujara Island, Pilava Island'),(98,'Delphe Knights Castle',3,'Calpheon','Connection Node',NULL,'Oze Pass, Biraghi Den, Delphe Outpost, Dias Farm'),(99,'Delphe Outpost',3,'Calpheon','Connection Node',NULL,'Karanda Ridge, Delphe Knights Castle, Old Dandelion'),(100,'Derko Island',5,'Valencia','Connection Node',NULL,'Kashuma Island, Ancado'),(101,'Desert Naga Temple',3,'Valencia','Connection Node',NULL,'Sand Grain Bazaar'),(102,'Dias Farm',2,'Calpheon','Connection Node',NULL,'Delphe Knights Castle, Northern Wheat Plantation, Calpheon, Falres Dirt Farm'),(103,'Dona Rocky Mountain',1,'Valencia','Connection Node',NULL,'Cantusa Desert'),(104,'Dormann Lumber Camp',2,'Drieghan','Worker Node',1,'Gervish Mountains'),(105,'Duch Island',1,'Balenos','Connection Node',NULL,'Eveto Island, Luivano Island'),(106,'Dunde Island',1,'Calpheon','Connection Node',NULL,'Eberdeen Island'),(107,'Duvencrune',0,'Drieghan','Town Node',NULL,'Duvencrune Farmland, Marak Farm, Night Crow Post, Morning Fog Post'),(108,'Duvencrune Farmland',1,'Drieghan','Worker Node',1,'Duvencrune'),(109,'Eastern Border',3,'Serendia','Connection Node',NULL,'Heidel, Kamasylve Temple, Rumbling Land'),(110,'Eastern Gateway',3,'Serendia','Connection Node',NULL,'Moretti Plantation, Northern Cienaga, Southern Guard Camp, Castle Ruins'),(111,'Eberdeen Island',1,'Calpheon','Connection Node',NULL,'Dunde Island, Oben Island, Albresser Island'),(112,'Ehwaz Hill',1,'Balenos','Worker Node',0,'Finto Farm, Cron Castle Site, Forest Of Plunder'),(113,'Elders Bridge',1,'Balenos','Connection Node',NULL,'Foot Of Thermian Mountain, Epheria Ridge, Elder\'s Bridge Post, Florin Gateway'),(114,'Elder\'s Bridge Post',3,'Balenos','Connection Node',NULL,'Elders Bridge, Anti-Troll Fortification'),(115,'Elric Shrine',1,'Mediah','Worker Node',0,'Mediah Northern Highlands, Canyon Of Corruption'),(116,'Ephde Rune Island',1,'Balenos','Worker Node',0,'Luivano Island'),(117,'Epheria Ridge',1,'Balenos','Connection Node',NULL,'Port Epheria, Elders Bridge'),(118,'Epheria Sentry Post',3,'Calpheon','Connection Node',NULL,'Port Epheria, Epheria Valley'),(119,'Epheria Valley',1,'Calpheon','Connection Node',NULL,'Epheria Sentry Post, Isolated Sentry Post'),(120,'Erdal Farm',2,'Valencia','Worker Node',1,'Valencia Plantation'),(121,'Esfah Island',1,'Valencia','Connection Node',NULL,'Tigris Island, Riyed Island'),(122,'Eveto Island',1,'Balenos','Connection Node',NULL,'Balvege Island, Duch Island'),(123,'Falres Dirt Farm',2,'Calpheon','Connection Node',NULL,'Calpheon, Marni Farm Ruins, Marni Cave Path, Dias Farm'),(124,'Finto Farm',2,'Balenos','Worker Node',0,'Ehwaz Hill, Velia'),(125,'Florin',1,'Calpheon','Connection Node',NULL,'Caphras Cave, Mask Owl\'s Forest, Khuruto Cave'),(126,'Florin Gateway',3,'Balenos','Connection Node',NULL,'Mask Owl\'s Forest, Elders Bridge, Thermian Cliff'),(127,'Fohalam Farm',2,'Valencia','Worker Node',1,'Valencia Plantation'),(128,'Foot Of Thermian Mountain',1,'Balenos','Connection Node',NULL,'Elders Bridge'),(129,'Forest Of Plunder',1,'Balenos','Worker Node',0,'Velia, Ehwaz Hill, Goblin Cave, Heidel Pass'),(130,'Forest Of Seclusion',2,'Balenos','Worker Node',0,'Ancient Stone Chamber, Toscani Farm, Bandit\'s Den Byway'),(131,'Forgotten Gateway',1,'Drieghan','Connection Node',NULL,'Khimut Lumber Camp'),(132,'Fountain Of Origin',2,'Drieghan','Worker Node',1,'Witch\'s Chapel, Sherekhan Necropolis'),(133,'Gabino Farm',2,'Calpheon','Connection Node',NULL,'North Kaia Mountaintop, North Kaia Ferry, Calpheon'),(134,'Gahaz Bandit\'s Lair',1,'Valencia','Connection Node',NULL,'Bambu Valley, Yalt Canyon'),(135,'Garmoth\'s Nest',2,'Drieghan','Connection Node',NULL,'Night Crow Post, Gervish Mountains, Windy Peak'),(136,'Gavinya Coastal Cliff',1,'Valencia','Worker Node',1,'Gavinya Great Crator, Hakoven Island'),(137,'Gavinya Great Crator',2,'Valencia','Worker Node',1,'Ivory Wasteland, Roud Sulfur Works, Gavinya Volcano Zone, Gavinya Coastal Cliff'),(138,'Gavinya Volcano Zone',3,'Valencia','Worker Node',1,'Gavinya Great Crator, Northern Sand Dune'),(139,'Gayak Altar',1,'Drieghan','Connection Node',NULL,'Marcha Outpost, Morning Fog Post'),(140,'Gehaku Plain',1,'Calpheon','Connection Node',NULL,'Primal Giant Post, Abandoned Quarry, Gianin Farm, Dane Canyon'),(141,'Gervish Mountains',1,'Drieghan','Worker Node',1,'Garmoth\'s Nest, Dormann Lumber Camp'),(142,'Gianin Farm',2,'Calpheon','Connection Node',NULL,'Closed Western Gateway, Keplan Hill, Gehaku Plain'),(143,'Ginburrey Island',1,'Calpheon','Connection Node',NULL,'Daton Island, Modric Island'),(144,'Glish',0,'Serendia','Town Node',NULL,'Northwestern Gateway, Southwestern Gateway, Southern Cienaga, Central Guard Camp, Glish Swamp'),(145,'Glish Ruins',1,'Serendia','Worker Node',0,'Southern Guard Camp, Central Guard Camp'),(146,'Glish Swamp',1,'Serendia','Worker Node',0,'Glish'),(147,'Glutoni Cave',1,'Calpheon','Worker Node',1,'Marni\'s Lab'),(148,'Goblin Cave',2,'Balenos','Worker Node',0,'Forest Of Plunder'),(149,'Gorgo Rock Belt',1,'Valencia','Worker Node',1,'Rock Post, Basilisk Den'),(150,'Grana',0,'Kamasylvia','Town Node',NULL,'Lake Flondor, Okiara River, Southern Kamasylvia, Acher Southern Camp, Polly\'s Forest'),(151,'Gyfin Rhasia Temple',3,'Kamasylvia','Connection Node',NULL,'Southern Kamasylvia'),(152,'Hakoven Island',1,'Valencia','Connection Node',NULL,'Gavinya Coastal Cliff'),(153,'Halmad Island',1,'Valencia','Connection Node',NULL,'Shirna Island, Orisha Island, Kashuma Island'),(154,'Haraks Shelter',1,'Drieghan','Connection Node',NULL,'Morning Fog Post, Sherekhan Necropolis'),(155,'Hasrah Cliff',1,'Mediah','Connection Node',NULL,'Tungrad Forest, Khimut Lumber Camp'),(156,'Heidel',0,'Serendia','Town Node',NULL,'Northern Guard Camp, Lynch Farm Ruins, Costa Farm, Moretti Plantation, Eastern Border'),(157,'Heidel Pass',3,'Balenos','Connection Node',NULL,'Balenos Forest, Forest Of Plunder, Northern Guard Camp'),(158,'Helms Post',1,'Mediah','Connection Node',NULL,'Ancient Fissure, Mediah Northern Highlands'),(159,'Hexe Sanctuary',2,'Calpheon','Connection Node',NULL,'Witch\'s Chapel, Rhua Tree Stub'),(160,'Hexe Stone Wall',1,'Calpheon','Worker Node',1,'Primal Giant Post, Marie Cave'),(161,'Highland Junction',1,'Mediah','Connection Node',NULL,'Asula Highland, Altinova Entrance, Abandoned Iron Mine Entrance'),(162,'Holo Forest',2,'Kamasylvia','Worker Node',1,'Mirumok Ruins, Central Lemoria Camp, White Wood Forest'),(163,'Hope Pier',1,'Valencia','Connection Node',NULL,'Shakatu'),(164,'Ibellab Oasis',3,'Valencia','Connection Node',NULL,'Pilgrim\'s Haven'),(165,'Iliya Island',0,'Balenos','Town Node',NULL,'Pujara Island, Ostra Island, Arakil Island, Shasha Island'),(166,'Imp Cave',1,'Balenos','Worker Node',0,'Loggia Farm, Altar Of Agris, Western Guard Camp'),(167,'Invernen Island',1,'Balenos','Worker Node',0,'Tulu Island, Narvo Island'),(168,'Iris Canyon',1,'Valencia','Worker Node',1,'Bambu Valley, Kmach Canyon'),(169,'Isolated Sentry Post',3,'Calpheon','Connection Node',NULL,'Epheria Valley, Quint Hill, Anti-Troll Fortification, Abandoned Land, Cohen Farm'),(170,'Ivero Cliff',1,'Valencia','Worker Node',1,'Ivory Wasteland'),(171,'Ivory Wasteland',1,'Valencia','Connection Node',NULL,'Ivero Cliff, Altas Farmland, Gavinya Great Crator'),(172,'Kamasylve Temple',2,'Mediah','Worker Node',0,'Eastern Border, Ancient Ruins Excavation Site, Ahto Farm, Castle Ruins'),(173,'Kamasylvia Vicinity',2,'Kamasylvia','Connection Node',NULL,'Longleaf Tree Forest, Lemoria Guard Post'),(174,'Kanvera Island',1,'Balenos','Connection Node',NULL,'Arakil Island, Weita Island'),(175,'Karanda Ridge',1,'Calpheon','Worker Node',0,'Delphe Outpost'),(176,'Kashuma Island',1,'Valencia','Connection Node',NULL,'Halmad Island, Derko Island'),(177,'Kasula Farm',2,'Mediah','Worker Node',0,'Tarif, Wandering Rogue Den, Asula Highland'),(178,'Keplan',0,'Calpheon','Town Node',NULL,'Keplan Hill, Keplan Quarry, Tarte Rock Fork, Keplan Vicinity'),(179,'Keplan Hill',1,'Calpheon','Connection Node',NULL,'Keplan, Gianin Farm'),(180,'Keplan Quarry',1,'Calpheon','Worker Node',0,'Keplan, North Abandoned Quarry'),(181,'Keplan Vicinity',1,'Calpheon','Connection Node',NULL,'Southern Neutral Zone, Keplan, Quarry Byway'),(182,'Khalk Canyon',1,'Drieghan','Worker Node',1,'Marcha Outpost, Ahib Conflict Zone, Sherekhan Necropolis'),(183,'Khimut Lumber Camp',2,'Drieghan','Worker Node',1,'Serendia Shrine, Tshira Ruins, Forgotten Gateway, Hasrah Cliff'),(184,'Khuruto Cave',1,'Calpheon','Worker Node',0,'Old Dandelion, Florin'),(185,'Kisleev Crag',1,'Valencia','Connection Node',NULL,'Leical Falls'),(186,'Kmach Canyon',1,'Valencia','Worker Node',1,'Ancado Coast, Iris Canyon'),(187,'Krogdalo Trace',2,'Kamasylvia','Connection Node',NULL,'Looney Cabin, Polly\'s Forest, Weenie Cabin'),(188,'Kuit Islands',3,'Calpheon','Connection Node',NULL,'Almai Island, Padix Island'),(189,'Kunid\'s Vacation Spot',1,'Valencia','Worker Node',1,'Cadry Ruins'),(190,'Kusha',1,'Mediah','Connection Node',NULL,'Stonetail Wasteland, Sarma Outpost, Mediah Shore'),(191,'Lake Flondor',3,'Kamasylvia','Worker Node',1,'White Wood Forest, Grana'),(192,'Lake Kaia',1,'Calpheon','Connection Node',NULL,'Catfishman Camp'),(193,'Leical Falls',1,'Valencia','Worker Node',1,'Kisleev Crag, Basilisk Den, Sokota Island'),(194,'Lema Island',1,'Balenos','Connection Node',NULL,'Orffs Island, Tashu Island, Port Ratt'),(195,'Lemoria Beacon Mounds',1,'Kamasylvia','Connection Node',NULL,'Shady Tree Forest'),(196,'Lemoria Guard Post',2,'Kamasylvia','Connection Node',NULL,'Kamasylvia Vicinity, Atanis Pond, Ahib Conflict Zone'),(197,'Lerao Island',1,'Balenos','Connection Node',NULL,'Tinberra Island, Portanen Island'),(198,'Lisz Island',1,'Balenos','Worker Node',0,'Louruve Island, Arita Island'),(199,'Loggia Farm',2,'Balenos','Worker Node',0,'Imp Cave, Velia'),(200,'Longleaf Tree Forest',1,'Calpheon','Worker Node',0,'Crioville, Behr, Kamasylvia Vicinity'),(201,'Longleaf Tree Sentry Post',2,'Calpheon','Worker Node',0,'Crioville, Trent'),(202,'Looney Cabin',1,'Kamasylvia','Worker Node',1,'Krogdalo Trace'),(203,'Loopy Tree Forest',2,'Kamasylvia','Worker Node',1,'Acher Western Camp, Tooth Fairy Forest, Acher Guard Post, Ash Forest'),(204,'Louruve Island',1,'Balenos','Worker Node',0,'Staren Island, Lisz Island, Marka Island'),(205,'Luivano Island',1,'Balenos','Worker Node',0,'Duch Island, Mariveno Island, Ephde Rune Island, Velia, Paratama Island'),(206,'Lumberjack\'s Rest Area',1,'Calpheon','Worker Node',0,'Trent, Abandoned Monastery'),(207,'Lynch Farm Ruins',1,'Serendia','Worker Node',0,'Northern Plain Of Serendia, Northwestern Gateway, Heidel, Alejandro Farm'),(208,'Lynch Ranch',2,'Serendia','Worker Node',0,'Northern Plain Of Serendia'),(209,'Manes Hideout',1,'Mediah','Connection Node',NULL,'Ahto Farm, Tarif'),(210,'Mansha Forest',2,'Calpheon','Worker Node',0,'Tobare\'s Cabin, Catfishman Camp, Calpheon Castle Western Forest'),(211,'Manshaum Forest',3,'Kamasylvia','Connection Node',NULL,'Caduil Forest, Central Lemoria Camp'),(212,'Marak Farm',2,'Drieghan','Worker Node',1,'Duvencrune'),(213,'Marcha Outpost',3,'Drieghan','Connection Node',NULL,'Khalk Canyon, Gayak Altar'),(214,'Marie Cave',1,'Calpheon','Worker Node',1,'Witch\'s Chapel, Hexe Stone Wall'),(215,'Marino Farm',2,'Balenos','Connection Node',NULL,'Bartali Farm'),(216,'Mariul Island',1,'Margoria','Connection Node',NULL,'Port Ratt, Nada Island'),(217,'Mariveno Island',1,'Balenos','Worker Node',0,'Luivano Island'),(218,'Marka Island',1,'Balenos','Connection Node',NULL,'Louruve Island, Angie Island'),(219,'Marlene Island',1,'Balenos','Connection Node',NULL,'Balvege Island'),(220,'Marni Cave Path',3,'Calpheon','Connection Node',NULL,'Beacon Entrance Post, Marni\'s Lab, North Abandoned Quarry, Marni Farm Ruins, Falres Dirt Farm'),(221,'Marni Farm Ruins',1,'Calpheon','Connection Node',NULL,'Oze Pass, Marni Cave Path, Falres Dirt Farm'),(222,'Marni\'s 2nd Lab',2,'Mediah','Worker Node',1,'Abun, Abandoned Iron Mine Saunil District'),(223,'Marni\'s Lab',1,'Calpheon','Connection Node',NULL,'Marni Cave Path, Glutoni Cave'),(224,'Mask Owl\'s Forest',1,'Balenos','Connection Node',NULL,'Florin Gateway, Florin'),(225,'Mediah Castle',1,'Mediah','Connection Node',NULL,'Sarma Outpost'),(226,'Mediah Northern Gateway',3,'Mediah','Connection Node',NULL,'The Mausoleum, Cron Castle Site'),(227,'Mediah Northern Highlands',2,'Mediah','Worker Node',0,'The Mausoleum, Sausan Garrison, Elric Shrine, Helms Post'),(228,'Mediah Shore',1,'Mediah','Worker Node',0,'Shuri Farm, Kusha, Omar Lava Cave'),(229,'Mirumok Ruins',3,'Kamasylvia','Connection Node',NULL,'Western Valtarra Mountains, Holo Forest'),(230,'Modric Island',1,'Calpheon','Worker Node',1,'Baeza Island, Theonil Island, Ginburrey Island'),(231,'Moretti Plantation',2,'Serendia','Worker Node',0,'Heidel, Northern Cienaga, Eastern Gateway'),(232,'Morning Fog Post',1,'Drieghan','Connection Node',NULL,'Windy Peak, Haraks Shelter, Duvencrune, Gayak Altar'),(233,'Muiquun',0,'Valencia','Town Node',NULL,'Cantusa Desert, Titium Valley'),(234,'Nada Island',3,'Margoria','Worker Node',1,'Mariul Island, Zagam Island'),(235,'Narvo Island',1,'Balenos','Connection Node',NULL,'Arita Island, Invernen Island'),(236,'Navarn Steppe',3,'Kamasylvia','Connection Node',NULL,'Shady Tree Forest, Central Lemoria Camp'),(237,'Netnume Island',1,'Calpheon','Connection Node',NULL,'Oben Island'),(238,'Night Crow Post',2,'Drieghan','Connection Node',NULL,'Garmoth\'s Nest, Blood Wolf Town, Tshira Ruins, Duvencrune'),(239,'North Abandoned Quarry',1,'Calpheon','Connection Node',NULL,'Oze\'s House, Keplan Quarry, Marni Cave Path'),(240,'North Kaia Ferry',3,'Calpheon','Connection Node',NULL,'Calpheon Castle Site, Gabino Farm, South Kaia Ferry'),(241,'North Kaia Mountaintop',1,'Calpheon','Connection Node',NULL,'Phoniel\'s Cabin, Gabino Farm'),(242,'Northern Cienaga',2,'Serendia','Worker Node',0,'Eastern Gateway, Moretti Plantation, Central Guard Camp'),(243,'Northern Guard Camp',3,'Serendia','Connection Node',NULL,'Heidel, Heidel Pass, Alejandro Farm, Northern Heidel Quarry'),(244,'Northern Heidel Quarry',1,'Serendia','Worker Node',0,'Northern Guard Camp'),(245,'Northern Plain Of Serendia',1,'Serendia','Worker Node',0,'Lynch Ranch, Lynch Farm Ruins, Bradie Fortress, Biraghi Den'),(246,'Northern Sand Dune',1,'Valencia','Worker Node',1,'Arehaza, Gavinya Volcano Zone'),(247,'Northern Wheat Plantation',2,'Calpheon','Worker Node',0,'Dias Farm, Old Dandelion, Bernianto Farm'),(248,'Northwestern Gateway',3,'Serendia','Connection Node',NULL,'Glish, Southwestern Gateway, Orc Camp, Lynch Farm Ruins'),(249,'Oben Island',1,'Calpheon','Worker Node',1,'Daton Island, Netnume Island, Eberdeen Island'),(250,'Oberen Farm',2,'Calpheon','Connection Node',NULL,'Beacon Entrance Post, Calpheon, Bain Farmland'),(251,'Okiara River',1,'Kamasylvia','Connection Node',NULL,'Grana'),(252,'Old Dandelion',1,'Calpheon','Worker Node',0,'Northern Wheat Plantation, Khuruto Cave, Delphe Outpost'),(253,'Old Wisdom Tree',0,'Kamasylvia','Town Node',NULL,'Shady Tree Forest, Caduil Forest'),(254,'Olvia',0,'Balenos','Town Node',NULL,'Wale Farm, Casta Farm'),(255,'Olvia Coast',1,'Balenos','Connection Node',NULL,'Balenos River Mouth, Casta Farm'),(256,'Omar Lava Cave',2,'Mediah','Worker Node',0,'Asula Highland, Awakening Bell, Stonebeak Shore, Mediah Shore'),(257,'Orc Camp',3,'Serendia','Connection Node',NULL,'Watchtower, Quarry Byway, Bradie Fortress, Northwestern Gateway'),(258,'Orffs Island',1,'Balenos','Worker Node',0,'Lema Island, Tulu Island, Baremi Island'),(259,'Orisha Island',1,'Valencia','Connection Node',NULL,'Boa Island, Shirna Island, Halmad Island'),(260,'Ostra Island',1,'Mediah','Connection Node',NULL,'Taramura Island, Iliya Island'),(261,'Oze Pass',1,'Calpheon','Worker Node',0,'Oze\'s House, Bradie Fortress, Marni Farm Ruins, Delphe Knights Castle, Quarry Byway'),(262,'Oze\'s House',1,'Calpheon','Connection Node',NULL,'North Abandoned Quarry, Oze Pass'),(263,'Padix Island',1,'Calpheon','Connection Node',NULL,'Albresser Island, Teste Island, Arita Island, Kuit Islands'),(264,'Paratama Island',1,'Balenos','Worker Node',0,'Weita Island, Luivano Island, Beiruwa Island'),(265,'Phoniel\'s Cabin',2,'Calpheon','Worker Node',0,'Rhutum Sentry Post, Behr Riverhead, Phoniel\'s Cabin Entrance, North Kaia Mountaintop'),(266,'Phoniel\'s Cabin Entrance',1,'Calpheon','Connection Node',NULL,'Behr Downstream, Phoniel\'s Cabin, Bain Farmland'),(267,'Pila Fe',1,'Valencia','Connection Node',NULL,'Taphtar Plain'),(268,'Pila Ku Jail',3,'Valencia','Connection Node',NULL,'Cantusa Desert'),(269,'Pilava Island',1,'Mediah','Worker Node',1,'Sausan Garrison Wharf, Delinghart Island'),(270,'Pilgrim\'s Haven',3,'Valencia','Worker Node',7,'Sand Grain Bazaar, Ibellab Oasis'),(271,'Pilgrim\'s Sanctum: Abstinence',3,'Valencia','Connection Node',NULL,'Pilgrim\'s Sanctum: Sharing, Pilgrim\'s Sanctum: Obedience'),(272,'Pilgrim\'s Sanctum: Fast',3,'Valencia','Connection Node',NULL,'Pilgrim\'s Sanctum: Purity'),(273,'Pilgrim\'s Sanctum: Humility',3,'Valencia','Worker Node',1,'Pilgrim\'s Sanctum: Sincerity, Akman, Pilgrim\'s Sanctum: Purity, Titium Valley'),(274,'Pilgrim\'s Sanctum: Obedience',3,'Valencia','Connection Node',NULL,'Pilgrim\'s Sanctum: Abstinence, Ancado Coast'),(275,'Pilgrim\'s Sanctum: Purity',3,'Valencia','Connection Node',NULL,'Pilgrim\'s Sanctum: Fast, Pilgrim\'s Sanctum: Humility, Titium Valley'),(276,'Pilgrim\'s Sanctum: Sharing',3,'Valencia','Connection Node',NULL,'Pilgrim\'s Sanctum: Sincerity, Pilgrim\'s Sanctum: Abstinence'),(277,'Pilgrim\'s Sanctum: Sincerity',3,'Valencia','Connection Node',NULL,'Akman, Pilgrim\'s Sanctum: Humility, Pilgrim\'s Sanctum: Sharing'),(278,'Polly\'s Forest',2,'Kamasylvia','Worker Node',1,'Grana, Krogdalo Trace'),(279,'Port Epheria',0,'Calpheon','Town Node',NULL,'Epheria Sentry Post, Epheria Ridge, Serca Island'),(280,'Port Ratt',0,'Margoria','Town Node',NULL,'Lema Island, Mariul Island'),(281,'Portanen Island',1,'Balenos','Connection Node',NULL,'Lerao Island, Rosevan Island'),(282,'Primal Giant Post',1,'Calpheon','Worker Node',1,'Gehaku Plain, Hexe Stone Wall'),(283,'Pujara Island',1,'Balenos','Worker Node',0,'Iliya Island, Delinghart Island'),(284,'Pujiya Canyon',3,'Valencia','Worker Node',1,'Taphtar Plain, Bashim Base'),(285,'Quarry Byway',2,'Calpheon','Connection Node',NULL,'Oze Pass, Keplan Vicinity, Orc Camp'),(286,'Quint Hill',1,'Calpheon','Worker Node',0,'Isolated Sentry Post'),(287,'Racid Island',1,'Balenos','Connection Node',NULL,'Al-Naha Island, Tinberra Island'),(288,'Rakshan Observatory',3,'Valencia','Connection Node',NULL,'Ancado, Valencia'),(289,'Rameda Island',1,'Calpheon','Connection Node',NULL,'Theonil Island'),(290,'Randis Island',1,'Calpheon','Worker Node',1,'Serca Island, Baeza Island, Barater Island'),(291,'Rhua Tree Stub',1,'Calpheon','Worker Node',1,'Behr Downstream, Saunil Battlefield, Hexe Sanctuary'),(292,'Rhutum Outstation',1,'Calpheon','Worker Node',0,'Rhutum Sentry Post, Tobare\'s Cabin'),(293,'Rhutum Sentry Post',3,'Calpheon','Connection Node',NULL,'South Kaia Ferry, Phoniel\'s Cabin, Rhutum Outstation'),(294,'Riyed Island',1,'Valencia','Connection Node',NULL,'Esfah Island, Sokota Island'),(295,'Rock Post',3,'Valencia','Connection Node',NULL,'Altinova Gateway, Gorgo Rock Belt, Veteran\'s Canyon'),(296,'Rosevan Island',1,'Balenos','Connection Node',NULL,'Shasha Island, Portanen Island, Boa Island'),(297,'Roud Sulfur Works',2,'Valencia','Worker Node',1,'Gavinya Great Crator'),(298,'Deserted City of Runn',1,'Valencia','Connection Node',NULL,'Runn Gateway Intersection, Cadry Ruins'),(299,'Rumbling Land',1,'Mediah','Connection Node',NULL,'Ancient Fissure, Eastern Border'),(300,'Runn Gateway Intersection',3,'Valencia','Connection Node',NULL,'Deserted City of Runn, Shakatu'),(301,'Sand Grain Bazaar',0,'Valencia','Town Node',NULL,'Bazaar Farmland, Capotia, Desert Naga Temple, Pilgrim\'s Haven'),(302,'Sarma Outpost',1,'Mediah','Connection Node',NULL,'Mediah Castle, Kusha, Sausan Garrison'),(303,'Saunil Battlefield',1,'Calpheon','Connection Node',NULL,'Behr Downstream, Rhua Tree Stub, Saunil Camp, Trina Fort'),(304,'Saunil Camp',1,'Calpheon','Connection Node',NULL,'Saunil Battlefield, Dane Canyon'),(305,'Sausan Garrison',1,'Mediah','Connection Node',NULL,'Sausan Garrison Wharf, Sarma Outpost, Stonetail Wasteland, Mediah Northern Highlands'),(306,'Sausan Garrison Wharf',1,'Mediah','Connection Node',NULL,'Sausan Garrison, Pilava Island'),(307,'Scarlet Sand Chamber',1,'Valencia','Connection Node',NULL,'Taphtar Plain'),(308,'Serca Island',1,'Calpheon','Worker Node',1,'Port Epheria, Randis Island'),(309,'Serendia Shrine',1,'Serendia','Worker Node',0,'Southern Guard Camp, Khimut Lumber Camp'),(310,'Shady Tree Forest',1,'Kamasylvia','Worker Node',1,'Old Wisdom Tree, Navarn Steppe, Lemoria Beacon Mounds'),(311,'Shakatu',0,'Valencia','Town Node',NULL,'Shakatu Farmland, Hope Pier, Shakatu Abandoned Pier, Yalt Canyon, Runn Gateway Intersection'),(312,'Shakatu Abandoned Pier',2,'Valencia','Connection Node',NULL,'Shakatu'),(313,'Shakatu Farmland',2,'Valencia','Worker Node',1,'Shakatu'),(314,'Shasha Island',1,'Balenos','Connection Node',NULL,'Rosevan Island, Iliya Island'),(315,'Sherekhan Necropolis',3,'Drieghan','Worker Node',1,'Fountain Of Origin, Khalk Canyon, Haraks Shelter'),(316,'Shirna Island',1,'Valencia','Connection Node',NULL,'Halmad Island, Orisha Island, Tigris Island'),(317,'Shuri Farm',2,'Mediah','Worker Node',0,'Canyon Of Corruption, Mediah Shore, Stonetail Horse Ranch'),(318,'Sokota Island',1,'Valencia','Connection Node',NULL,'Leical Falls, Riyed Island'),(319,'Soldier\'s Grave',1,'Mediah','Connection Node',NULL,'Tungrad Forest, Castle Ruins, Tarif'),(320,'South Kaia Ferry',3,'Calpheon','Connection Node',NULL,'North Kaia Ferry, Rhutum Sentry Post'),(321,'Southern Cienaga',1,'Serendia','Worker Node',0,'Southern Guard Camp, Glish'),(322,'Southern Guard Camp',3,'Serendia','Connection Node',NULL,'Glish Ruins, Southern Cienaga, Eastern Gateway, Serendia Shrine'),(323,'Southern Kamasylvia',2,'Kamasylvia','Worker Node',1,'Gyfin Rhasia Temple, Grana'),(324,'Southern Neutral Zone',3,'Serendia','Connection Node',NULL,'Keplan Vicinity, Closed Western Gateway, Southwestern Gateway, Watchtower'),(325,'Southwestern Gateway',3,'Serendia','Connection Node',NULL,'Glish, Bloody Monastery, Southern Neutral Zone, Northwestern Gateway'),(326,'Splashing Point',1,'Mediah','Connection Node',NULL,'Alumn Rock Valley'),(327,'Staren Island',1,'Balenos','Worker Node',0,'Albresser Island, Louruve Island'),(328,'Stonebeak Shore',1,'Mediah','Connection Node',NULL,'Omar Lava Cave, Altinova Entrance'),(329,'Stonetail Horse Ranch',1,'Mediah','Connection Node',NULL,'Shuri Farm, Ahto Farm, Asula Highland'),(330,'Stonetail Wasteland',1,'Mediah','Worker Node',0,'Kusha, Sausan Garrison, Canyon Of Corruption'),(331,'Taphtar Plain',1,'Valencia','Connection Node',NULL,'Veteran\'s Canyon, Pila Fe, Barhan Gateway, Pujiya Canyon, Scarlet Sand Chamber'),(332,'Taramura Island',1,'Mediah','Worker Node',1,'Ostra Island, Beiruwa Island'),(333,'Tarif',0,'Mediah','Town Node',NULL,'Kasula Farm, Manes Hideout, Soldier\'s Grave'),(334,'Tarte Rock Fork',1,'Calpheon','Connection Node',NULL,'Trina Fort, Abandoned Quarry, Keplan'),(335,'Tashu Island',1,'Balenos','Connection Node',NULL,'Lema Island, Arita Island'),(336,'Teste Island',1,'Calpheon','Connection Node',NULL,'Daton Island, Padix Island'),(337,'Teyamal Island',1,'Calpheon','Worker Node',1,'Theonil Island'),(338,'The Mausoleum',1,'Mediah','Connection Node',NULL,'Mediah Northern Gateway, Mediah Northern Highlands'),(339,'Theonil Island',1,'Calpheon','Connection Node',NULL,'Modric Island, Teyamal Island, Rameda Island'),(340,'Thermian Cliff',1,'Balenos','Worker Node',1,'Florin Gateway, Wale Farm'),(341,'Tigris Island',1,'Valencia','Connection Node',NULL,'Shirna Island, Esfah Island'),(342,'Tinberra Island',1,'Balenos','Connection Node',NULL,'Racid Island, Lerao Island'),(343,'Titium Valley',3,'Valencia','Worker Node',1,'Muiquun, Pilgrim\'s Sanctum: Humility, Pilgrim\'s Sanctum: Purity'),(344,'Tobare\'s Cabin',2,'Calpheon','Connection Node',NULL,'Rhutum Outstation, Mansha Forest, Abandoned Monastery'),(345,'Tooth Fairy Cabin',2,'Kamasylvia','Connection Node',NULL,'Tooth Fairy Forest'),(346,'Tooth Fairy Forest',3,'Kamasylvia','Worker Node',1,'Loopy Tree Forest, Tooth Fairy Cabin, White Wood Forest'),(347,'Toscani Farm',2,'Balenos','Worker Node',0,'Forest Of Seclusion, Western Guard Camp, Bartali Farm'),(348,'Treant Forest',1,'Calpheon','Worker Node',0,'Abandoned Monastery'),(349,'Trent',0,'Calpheon','Town Node',NULL,'Lumberjack\'s Rest Area, Longleaf Tree Sentry Post'),(350,'Trina Beacon Mounds',3,'Calpheon','Connection Node',NULL,'Beacon Entrance Post, Trina Fort'),(351,'Trina Fort',3,'Calpheon','Connection Node',NULL,'Tarte Rock Fork, Trina Beacon Mounds, Saunil Battlefield'),(352,'Tshira Ruins',2,'Drieghan','Worker Node',1,'Khimut Lumber Camp, Night Crow Post'),(353,'Tulu Island',1,'Balenos','Connection Node',NULL,'Invernen Island, Orffs Island'),(354,'Tungrad Forest',1,'Mediah','Connection Node',NULL,'Soldier\'s Grave, Hasrah Cliff'),(355,'Valencia',0,'Valencia','Town Node',NULL,'Areha Palm Forest, Valencia Castle Site, Rakshan Observatory, Valencia Plantation'),(356,'Valencia Castle',1,'Valencia','Connection Node',NULL,'Valencia Castle Site'),(357,'Valencia Castle Site',1,'Valencia','Connection Node',NULL,'Valencia Castle, Valencia'),(358,'Valencia Plantation',2,'Valencia','Worker Node',1,'Fohalam Farm, Erdal Farm, Valencia'),(359,'Valtarra - Altar of Training',2,'Kamasylvia','Connection Node',NULL,'Western Valtarra Mountains, Valtarra Mountains'),(360,'Valtarra Mountains',1,'Kamasylvia','Connection Node',NULL,'Valtarra - Altar of Training, Viv Foretta\'s Cabin'),(361,'Velia',0,'Balenos','Town Node',NULL,'Coastal Cave, Finto Farm, Forest Of Plunder, Bartali Farm, Loggia Farm, Luivano Island'),(362,'Veteran\'s Canyon',1,'Valencia','Worker Node',1,'Rock Post, Cadry Ruins, Taphtar Plain'),(363,'Viv Foretta\'s Cabin',2,'Kamasylvia','Worker Node',1,'Valtarra Mountains, Atanis Pond'),(364,'Wale Farm',1,'Balenos','Worker Node',0,'Olvia, Thermian Cliff'),(365,'Wandering Rogue Den',1,'Mediah','Connection Node',NULL,'Kasula Farm, Alumn Rock Valley'),(366,'Waragon Nest',1,'Valencia','Connection Node',NULL,'Bashim Base'),(367,'Watchtower',1,'Serendia','Connection Node',NULL,'Orc Camp, Southern Neutral Zone'),(368,'Weenie Cabin',1,'Kamasylvia','Worker Node',1,'Krogdalo Trace'),(369,'Weita Island',1,'Balenos','Worker Node',0,'Kanvera Island, Paratama Island, Baremi Island'),(370,'Western Gateway',3,'Balenos','Connection Node',NULL,'Western Guard Camp, Coastal Cliff, Wolf Hills'),(371,'Western Guard Camp',1,'Balenos','Connection Node',NULL,'Western Gateway, Imp Cave, Toscani Farm, Bandit\'s Den Byway'),(372,'Western Plateau Of Valencia',1,'Valencia','Connection Node',NULL,'Bazaar Farmland, Crescent Mountains'),(373,'Western Valtarra Mountains',2,'Kamasylvia','Connection Node',NULL,'Acher Guard Post, Yianaros\'s Field, Valtarra - Altar of Training, Mirumok Ruins'),(374,'White Wood Forest',1,'Kamasylvia','Connection Node',NULL,'Tooth Fairy Forest, Central Lemoria Camp, Holo Forest, Lake Flondor'),(375,'Windy Peak',1,'Drieghan','Connection Node',NULL,'Morning Fog Post, Garmoth\'s Nest'),(376,'Witch\'s Chapel',1,'Calpheon','Connection Node',NULL,'Hexe Sanctuary, Marie Cave, Fountain Of Origin'),(377,'Wolf Hills',1,'Balenos','Worker Node',5,'Casta Farm, Balenos River Mouth, Western Gateway'),(378,'Yalt Canyon',1,'Valencia','Connection Node',NULL,'Shakatu, Gahaz Bandit\'s Lair'),(379,'Yianaros\'s Field',1,'Kamasylvia','Connection Node',NULL,'Western Valtarra Mountains'),(380,'Zagam Island',1,'Margoria','Connection Node',NULL,'Nada Island');
/*!40000 ALTER TABLE `node` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prices`
--

DROP TABLE IF EXISTS `prices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `prices` (
  `item_id` int(11) NOT NULL,
  `user_average` int(11) DEFAULT NULL,
  `recent_value` int(11) DEFAULT NULL,
  `vendor_sell` int(11) DEFAULT NULL,
  `vendor_buy` int(11) DEFAULT NULL,
  KEY `item_id` (`item_id`),
  CONSTRAINT `prices_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `item` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `prices`
--

LOCK TABLES `prices` WRITE;
/*!40000 ALTER TABLE `prices` DISABLE KEYS */;
INSERT INTO `prices` VALUES (0,435,660,70,NULL),(1,958,975,105,NULL),(2,257,378,40,NULL),(3,300,300,300,NULL),(4,150,150,150,NULL),(5,1439,1440,1440,NULL),(6,649,670,40,1000),(7,2909,6600,70,NULL),(8,441,302,70,NULL),(9,663,1110,100,NULL),(10,357,484,18,NULL),(11,1097,1800,108,NULL),(12,682,1070,114,NULL),(13,975,1130,120,NULL),(14,725,1070,114,NULL),(15,557,735,78,NULL),(16,801,1140,108,NULL),(17,1097,1700,120,NULL),(18,744,1300,114,NULL),(19,2165,3080,320,8000),(20,1330,6000,90,NULL),(21,607,905,80,NULL),(22,100,100,100,NULL),(23,4332,7050,720,NULL),(24,1683,5950,48,NULL),(25,3422,3060,48,NULL),(26,360,565,60,NULL),(27,552,650,69,NULL),(28,200,335,85,NULL),(29,597,1630,70,NULL),(30,340,560,105,NULL),(31,3051,9650,105,NULL),(32,748,975,95,NULL),(33,756,945,100,NULL),(34,378,391,40,NULL),(35,25,25,25,NULL),(36,388,446,40,1000),(37,908,935,100,NULL),(38,1721,1680,40,NULL),(39,65,65,65,NULL),(40,1372,1770,100,NULL),(41,535,580,70,NULL),(42,363,935,19,NULL),(43,740,1210,80,NULL),(44,2104,2110,320,NULL),(45,120,120,120,NULL),(46,382,382,382,NULL),(47,651,2440,34,NULL),(48,1040,1040,1040,NULL),(49,3537,4380,688,NULL),(50,2247,1500,230,NULL),(51,1817,1580,229,NULL),(52,1976,1440,205,NULL),(53,3723,3840,627,NULL),(54,3763,3570,670,NULL),(55,1649,1350,157,NULL),(56,1278,1400,115,NULL),(57,1289,1380,106,NULL),(58,1152,1210,109,NULL),(59,2047,1600,202,NULL),(60,3740,3770,704,NULL),(61,3215,3310,608,NULL),(62,10751,12800,2400,NULL),(63,1117,1080,109,NULL),(64,4231,3570,666,NULL),(65,4278,3340,618,NULL),(66,1306,1740,106,NULL),(67,12039,14100,2640,NULL),(68,7780,13600,608,NULL),(69,2084,1340,189,NULL),(70,11221,13500,2520,NULL),(71,2364,1440,226,NULL),(72,1820,2170,192,NULL),(73,1000,1360,88,NULL),(74,1114,1160,90,NULL),(75,1239,1500,85,NULL),(76,1254,1670,93,NULL),(77,10394,13100,2448,NULL),(78,3512,3200,598,NULL),(79,2169,1440,234,NULL),(80,1222,1340,102,NULL),(81,1043,1280,77,NULL),(82,4032,3400,624,NULL),(83,4003,3650,640,NULL),(84,3278,3270,611,NULL),(85,11212,14100,2640,NULL),(86,1022,1230,85,NULL),(87,523,431,21,525),(88,620,620,620,NULL),(89,262,262,262,NULL),(90,150,150,150,NULL),(91,576,441,38,950),(92,1220,1101,30,NULL),(93,1565,1980,440,NULL),(94,741,1030,109,NULL),(95,502,472,110,NULL),(96,427,488,36,900),(97,300,300,300,NULL),(98,505,2350,41,NULL),(99,2922,4470,340,8500),(100,3024,5850,95,NULL),(101,854,2040,85,NULL),(102,831,870,85,NULL),(103,1757,2400,340,NULL),(104,983,1550,85,NULL),(105,446,900,36,900),(106,286,201,20,NULL),(107,566,950,40,1000),(108,731,635,36,NULL),(109,351,453,48,NULL),(110,840,840,840,NULL),(111,3780,4100,200,NULL),(112,3538,4200,240,NULL),(113,1419,1100,80,NULL),(114,483,453,80,NULL),(115,2490,5555,340,NULL),(116,416,426,85,NULL),(117,1769,1850,456,NULL),(118,1559,7350,104,NULL),(119,589,448,114,NULL),(120,760,760,760,NULL),(121,1991,7650,85,NULL),(122,515,484,75,NULL),(123,2124,2250,600,NULL),(124,1585,2000,432,NULL),(125,1788,1436,97,NULL),(126,370,425,108,NULL),(127,22761,40000,490,NULL),(128,496,525,125,NULL),(129,497,415,44,NULL),(130,896,900,900,NULL),(131,2424,2250,600,NULL),(132,303,360,38,NULL),(133,11138,16500,1600,NULL),(134,1489,3900,404,NULL),(135,2510,2130,104,NULL),(136,540,423,101,NULL),(137,344,320,34,850),(138,425,565,60,NULL),(139,2382,2000,360,9000),(140,4279,6000,100,NULL),(141,650,1000,90,NULL),(142,267,425,45,NULL),(143,244,350,37,NULL),(144,3997,19000,450,NULL),(145,397,840,16,NULL),(146,1835,1880,502,NULL),(147,1519,1870,500,NULL),(148,5627,9900,503,NULL),(149,1644,1870,501,NULL),(150,1631,3150,504,NULL),(151,302,291,30,NULL),(152,2511,2990,100,5000),(153,2108,2700,720,NULL),(154,3239,2550,385,NULL),(155,1115,1530,410,NULL),(156,5631,10800,1000,NULL),(157,1416,1680,375,NULL),(158,11011,21000,875,NULL),(159,1538,2200,390,NULL),(160,2601,2000,350,NULL),(161,1380,1390,370,NULL),(162,3538,33400,900,NULL),(163,1444,3060,360,NULL),(164,1193,1590,425,NULL),(165,125,125,125,NULL),(166,9140,12300,1500,NULL),(167,328,189,20,500),(168,3404,3400,360,NULL),(169,744,850,90,NULL),(170,255,315,23,575),(171,690,790,38,950),(172,6890,7050,680,NULL),(173,4362,4490,272,NULL),(174,1910,2250,600,NULL),(175,525,520,55,NULL),(176,613,585,28,700),(177,917,750,140,NULL),(178,295,414,20,500),(179,331,885,16,NULL),(180,260,201,19,NULL),(181,2561,4500,400,NULL),(182,12391,15000,97,NULL),(183,604,1500,108,NULL),(184,451,790,38,950),(185,790,353,80,NULL),(186,3276,6100,120,NULL),(187,1074,1080,1080,NULL),(188,16,16,16,NULL),(189,15589,50000,500,NULL),(190,13921,66000,500,NULL),(191,19411,39000,500,NULL),(192,4039,6600,500,NULL),(193,15805,45000,500,NULL),(194,5484,6600,500,NULL),(195,20293,50344,500,NULL),(196,37840,63000,500,NULL),(197,11379,35000,500,NULL),(198,14978,15000,500,NULL),(199,35361,66000,500,NULL),(200,1905,5500,110,NULL),(201,525,1022,59,NULL),(202,2943,3440,47,NULL),(203,19,19,19,NULL),(204,149,150,150,NULL),(205,410,412,412,NULL),(206,354,850,18,NULL),(207,496,660,70,NULL),(208,726,1200,100,NULL),(209,292,435,46,NULL),(210,312,435,46,NULL),(211,109,110,110,NULL),(212,949,2070,90,NULL);
/*!40000 ALTER TABLE `prices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subnode`
--

DROP TABLE IF EXISTS `subnode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `subnode` (
  `subnode_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(50) NOT NULL,
  `cp` int(11) DEFAULT '0',
  `base_workload` int(11) DEFAULT NULL,
  `current_workload` int(11) DEFAULT NULL,
  `node_id` int(11) NOT NULL,
  PRIMARY KEY (`subnode_id`),
  KEY `node_id` (`node_id`),
  CONSTRAINT `subnode_ibfk_1` FOREIGN KEY (`node_id`) REFERENCES `node` (`node_id`)
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subnode`
--

LOCK TABLES `subnode` WRITE;
/*!40000 ALTER TABLE `subnode` DISABLE KEYS */;
INSERT INTO `subnode` VALUES (1,'Abandoned Iron Mine - Mining.1',3,250,500,1),(2,'Abandoned Iron Mine - Mining.2',3,100,200,1),(3,'Ahto Farm - Farming.1',2,100,200,13),(4,'Ahto Farm - Farming.2',2,100,200,13),(5,'Akman - Gathering.1',3,75,75,15),(6,'Akum Rocky Mountain - Mining.1',5,140,140,16),(7,'Akum Rocky Mountain - Mining.2',5,140,140,16),(8,'Albresser Island - Fish Drying Yard.1',1,1200,1200,18),(9,'Alejandro Farm - Farming.1',1,100,200,19),(10,'Alejandro Farm - Farming.2',1,100,200,19),(11,'Altas Farmland - Farming.1',3,100,100,22),(12,'Altas Farmland - Farming.2',3,100,100,22),(13,'Ancient Fissure - Mining.1',3,100,200,29),(14,'Ancient Fissure - Gathering.2',3,75,150,29),(15,'Ancient Ruins Excavation Site - Excavation.1',3,600,1200,30),(16,'Ancient Stone Chamber - Excavation.1',1,600,1200,31),(17,'Angie Island - Fish Drying Yard.1',1,1200,2400,32),(18,'Angie Island - Fish Drying Yard.2',1,1200,2400,32),(19,'Areha Palm Forest - Lumbering.1',3,100,100,35),(20,'Areha Palm Forest - Lumbering.2',3,100,100,35),(21,'Baeza Island - Fish Drying Yard.1',1,1200,1200,42),(22,'Balenos Forest - Lumbering.1',1,100,200,44),(23,'Balenos Forest - Gathering.2',1,75,150,44),(24,'Bambu Valley - Gathering.1',3,75,75,47),(25,'Barater Island - Fish Drying Yard.1',1,1200,1200,49),(26,'Barater Island - Fish Drying Yard.2',1,1200,1200,49),(27,'Bartali Farm - Farming.1',1,100,200,52),(28,'Bartali Farm - Farming.2',1,100,200,52),(29,'Bashim Base - Mining.1',3,100,100,53),(30,'Bazaar Farmland - Farming.1',3,100,125,55),(31,'Bazaar Farmland - Farming.2',3,100,125,55),(32,'Behr Riverhead - Mining.1',1,100,200,59),(33,'Beiruwa Island - Fish Drying Yard.1',1,1200,1200,60),(34,'Bernianto Farm - Excavation.1',1,600,1200,61),(35,'Bree Tree Ruins - Gathering.1',1,75,150,67),(36,'Bree Tree Ruins - Lumbering.2',1,75,150,67),(37,'Capotia - Gathering.1',3,75,93,77),(38,'Capotia - Mining.2',3,100,125,77),(39,'Casta Farm - Farming.1',1,100,200,78),(40,'Castle Ruins - Lumbering.1',1,75,150,79),(41,'Coastal Cave - Mining.1',1,75,150,85),(42,'Coastal Cave - Mining.2',1,75,150,85),(43,'Coastal Cliff - Gathering.1',1,75,150,86),(44,'Coastal Cliff - Mining.2',1,75,150,86),(45,'Costa Farm - Farming.1',1,100,200,89),(46,'Costa Farm - Farming.2',1,100,200,89),(47,'Costa Farm - Farming.3',1,100,200,89),(48,'Crescent Mountains - Mining.1',3,100,100,90),(49,'Crescent Mountains - Mining.2',3,100,100,90),(50,'Crescent Shrine - Gathering.1',3,75,75,91),(51,'Crescent Shrine - Mining.2',3,100,100,91),(52,'Cron Castle Site - Gathering.1',1,75,150,94),(53,'Daton Island - Fish Drying Yard.1',1,1200,1200,96),(54,'Delinghart Island - Fish Drying Yard.1',1,1200,1200,97),(55,'Delinghart Island - Fish Drying Yard.2',1,1200,1200,97),(56,'Dormann Lumber Camp - Lumbering.1',5,140,140,104),(57,'Dormann Lumber Camp - Lumbering.2',5,140,140,104),(58,'Duvencrune Farmland - Farming.1',3,140,140,108),(59,'Duvencrune Farmland - Farming.2',3,140,140,108),(60,'Ehwaz Hill - Gathering.1',1,75,150,112),(61,'Ehwaz Hill - Lumbering.2',1,75,150,112),(62,'Elric Shrine - Gathering.1',3,75,150,115),(63,'Elric Shrine - Lumbering.2',3,250,500,115),(64,'Ephde Rune Island - Fish Drying Yard.1',1,1200,2400,116),(65,'Erdal Farm - Farming.1',3,100,100,120),(66,'Erdal Farm - Farming.2',3,100,100,120),(67,'Erdal Farm - Farming.3',3,100,100,120),(68,'Finto Farm - Farming.1',1,100,200,124),(69,'Finto Farm - Farming.2',1,100,200,124),(70,'Fohalam Farm - Farming.1',3,100,100,127),(71,'Fohalam Farm - Farming.2',3,100,100,127),(72,'Forest Of Plunder - Gathering.1',1,75,150,129),(73,'Forest Of Seclusion - Lumbering.1',1,75,150,130),(74,'Forest Of Seclusion - Mining.2',1,75,150,130),(75,'Fountain Of Origin - Excavation.1',3,600,600,132),(76,'Gavinya Coastal Cliff - Mining.1',2,100,100,136),(77,'Gavinya Coastal Cliff - Gathering.2',2,75,75,136),(78,'Gavinya Great Crator - Mining.1',2,100,100,137),(79,'Gavinya Volcano Zone - Mining.1',2,100,100,138),(80,'Gavinya Volcano Zone - Mining.2',2,100,100,138),(81,'Gervish Mountains - Gathering.1',2,140,140,141),(82,'Gervish Mountains - Gathering.2',2,140,140,141),(83,'Glish Ruins - Excavation.1',1,600,1200,145),(84,'Glish Swamp - Gathering.1',1,75,150,146),(85,'Glish Swamp - Mining.2',1,100,200,146),(86,'Glutoni Cave - Mining.1',1,100,100,147),(87,'Glutoni Cave - Gathering.2',1,75,75,147),(88,'Goblin Cave - Mining.1',1,100,200,148),(89,'Goblin Cave - Lumbering.2',1,100,200,148),(90,'Gorgo Rock Belt - Gathering.1',1,75,75,149),(91,'Gorgo Rock Belt - Lumbering.2',1,100,100,149),(92,'Hexe Stone Wall - Mining.1',1,250,250,160),(93,'Holo Forest - Mining.1',2,140,140,162),(94,'Imp Cave - Mining.1',1,100,200,166),(95,'Imp Cave - Mining.2',1,100,200,166),(96,'Invernen Island - Fish Drying Yard.1',1,1200,2400,167),(97,'Invernen Island - Fish Drying Yard.2',1,1200,2400,167),(98,'Iris Canyon - Gathering.1',3,75,75,168),(99,'Iris Canyon - Lumbering.2',3,100,100,168),(100,'Ivero Cliff - Gathering.1',2,75,75,170),(101,'Kamasylve Temple - Gathering.1',2,75,150,172),(102,'Kamasylve Temple - Farming.2',2,100,200,172),(103,'Karanda Ridge - Gathering.1',1,75,150,175),(104,'Kasula Farm - Farming.1',2,100,200,177),(105,'Kasula Farm - Farming.2',2,100,200,177),(106,'Keplan Quarry - Mining.1',1,100,200,180),(107,'Khalk Canyon - Mining.1',5,140,140,182),(108,'Khalk Canyon - Mining.2',5,140,140,182),(109,'Khimut Lumber Camp - Lumbering.1',5,140,140,183),(110,'Khimut Lumber Camp - Lumbering.2',5,140,140,183),(111,'Khuruto Cave - Mining.1',1,250,500,184),(112,'Kmach Canyon - Mining.1',3,100,100,186),(113,'Kmach Canyon - Gathering.2',3,75,75,186),(114,'Kunid\'s Vacation Spot - Gathering.1',3,75,75,189),(115,'Lake Flondor - Mining.1',2,140,140,191),(116,'Leical Falls - Gathering.1',3,75,75,193),(117,'Lisz Island - Fish Drying Yard.1',1,1200,2400,198),(118,'Lisz Island - Fish Drying Yard.2',1,1200,2400,198),(119,'Loggia Farm - Farming.1',1,100,200,199),(120,'Longleaf Tree Forest - Lumbering.1',1,75,150,200),(121,'Longleaf Tree Sentry Post - Gathering.1',1,75,150,201),(122,'Looney Cabin - Gathering.1',2,140,140,202),(123,'Loopy Tree Forest - Lumbering.1',2,140,140,203),(124,'Louruve Island - Fish Drying Yard.1',1,1200,2400,204),(125,'Luivano Island - Fish Drying Yard.1',1,1200,2400,205),(126,'Lumberjack\'s Rest Area - Lumbering.1',1,75,150,206),(127,'Lynch Farm Ruins - Gathering.1',1,75,150,207),(128,'Lynch Farm Ruins - Excavation.2',1,600,1200,207),(129,'Lynch Ranch - Farming.1',1,100,200,208),(130,'Mansha Forest - Lumbering.1',1,75,150,210),(131,'Mansha Forest - Excavation.2',1,600,1200,210),(132,'Marak Farm - Farming.1',3,140,140,212),(133,'Marak Farm - Farming.2',3,140,140,212),(134,'Marie Cave - Gathering.1',1,75,75,214),(135,'Marie Cave - Lumbering.2',1,75,75,214),(136,'Mariveno Island - Fish Drying Yard.1',1,1200,2400,217),(137,'Mariveno Island - Fish Drying Yard.2',1,1200,2400,217),(138,'Marni\'s 2nd Lab - Gathering.1',2,75,75,222),(139,'Mediah Northern Highlands - Lumbering.1',3,100,200,227),(140,'Mediah Northern Highlands - Lumbering.2',3,100,200,227),(141,'Mediah Shore - Mining.1',3,100,200,228),(142,'Modric Island - Fish Drying Yard.1',1,1200,1200,230),(143,'Moretti Plantation - Farming.1',1,100,200,231),(144,'Moretti Plantation - Farming.2',1,100,200,231),(145,'Nada Island - Fish Drying Yard.1',2,1200,1200,234),(146,'Nada Island - Fish Drying Yard.2',2,1200,1200,234),(147,'Northern Cienaga - Gathering.1',1,75,150,242),(148,'Northern Heidel Quarry - Mining.1',1,100,200,244),(149,'Northern Heidel Quarry - Mining.2',1,75,150,244),(150,'Northern Plain Of Serendia - Gathering.1',1,75,150,245),(151,'Northern Plain Of Serendia - Lumbering.2',1,100,200,245),(152,'Northern Sand Dune - Gathering.1',2,100,100,246),(153,'Northern Wheat Plantation - Farming.1',1,100,200,247),(154,'Northern Wheat Plantation - Farming.2',1,100,200,247),(155,'Northern Wheat Plantation - Farming.3',1,100,200,247),(156,'Oben Island - Fish Drying Yard.1',1,1200,1200,249),(157,'Oben Island - Fish Drying Yard.2',1,1200,1200,249),(158,'Old Dandelion - Lumbering.1',1,75,150,252),(159,'Omar Lava Cave - Mining.1',3,250,500,256),(160,'Omar Lava Cave - Mining.2',3,100,200,256),(161,'Orffs Island - Fish Drying Yard.1',1,1200,2400,258),(162,'Orffs Island - Fish Drying Yard.2',1,1200,2400,258),(163,'Oze Pass - Lumbering.1',1,75,150,261),(164,'Paratama Island - Fish Drying Yard.1',1,1200,2400,264),(165,'Phoniel\'s Cabin - Lumbering.1',1,75,150,265),(166,'Pilava Island - Fish Drying Yard.1',1,1200,1200,269),(167,'Pilava Island - Fish Drying Yard.2',1,1200,1200,269),(168,'Pilgrim\'s Haven - Lumbering.1',3,100,125,270),(169,'Pilgrim\'s Haven - Mining.2',3,100,125,270),(170,'Pilgrim\'s Sanctum: Humility - Excavation.1',1,600,600,273),(171,'Polly\'s Forest - Gathering.1',2,140,140,278),(172,'Primal Giant Post - Mining.1',1,100,100,282),(173,'Pujara Island - Fish Drying Yard.1',1,1200,2400,283),(174,'Pujara Island - Fish Drying Yard.2',1,1200,2400,283),(175,'Pujiya Canyon - Mining.1',3,100,100,284),(176,'Quint Hill - Mining.1',1,100,200,286),(177,'Quint Hill - Lumbering.2',1,75,150,286),(178,'Randis Island - Fish Drying Yard.1',1,1200,1200,290),(179,'Randis Island - Fish Drying Yard.2',1,1200,1200,290),(180,'Rhua Tree Stub - Gathering.1',1,75,75,291),(181,'Rhua Tree Stub - Excavation.2',1,600,600,291),(182,'Rhutum Outstation - Mining.1',1,100,200,292),(183,'Roud Sulfur Works - Mining.1',5,600,600,297),(184,'Serca Island - Fish Drying Yard.1',1,1200,1200,308),(185,'Serendia Shrine - Lumbering.1',1,75,150,309),(186,'Shady Tree Forest - Lumbering.1',3,140,140,310),(187,'Shakatu Farmland - Farming.1',3,100,100,313),(188,'Shakatu Farmland - Farming.2',3,100,100,313),(189,'Shakatu Farmland - Farming.3',3,100,100,313),(190,'Sherekhan Necropolis - Excavation.1',3,600,600,315),(191,'Shuri Farm - Farming.1',2,100,200,317),(192,'Southern Cienaga - Gathering.1',1,75,150,321),(193,'Southern Cienaga - Mining.2',1,75,150,321),(194,'Southern Kamasylvia - Mining.1',2,140,140,323),(195,'Staren Island - Fish Drying Yard.1',1,1200,2400,327),(196,'Staren Island - Fish Drying Yard.2',1,1200,2400,327),(197,'Stonetail Wasteland - Lumbering.1',3,100,200,330),(198,'Taramura Island - Fish Drying Yard.1',1,1200,1200,332),(199,'Taramura Island - Fish Drying Yard.2',1,1200,1200,332),(200,'Teyamal Island - Fish Drying Yard.1',1,1200,1200,337),(201,'Teyamal Island - Fish Drying Yard.2',1,1200,1200,337),(202,'Thermian Cliff - Mining.1',1,100,100,340),(203,'Titium Valley - Gathering.1',3,75,75,343),(204,'Titium Valley - Gathering.2',3,75,75,343),(205,'Titium Valley - Lumbering.3',3,100,100,343),(206,'Tooth Fairy Forest - Excavation.1',2,600,600,346),(207,'Toscani Farm - Farming.1',1,100,200,347),(208,'Toscani Farm - Farming.2',1,100,200,347),(209,'Treant Forest - Lumbering.1',1,75,150,348),(210,'Tshira Ruins - Gathering.1',2,140,140,352),(211,'Tshira Ruins - Gathering.2',2,140,140,352),(212,'Valencia Plantation - Farming.1',3,100,100,358),(213,'Valencia Plantation - Farming.2',3,100,100,358),(214,'Valencia Plantation - Farming.3',3,100,100,358),(215,'Veteran\'s Canyon - Lumbering.1',3,100,100,362),(216,'Viv Foretta\'s Cabin - Farming.1',1,140,140,363),(217,'Wale Farm - Farming.1',1,100,200,364),(218,'Weenie Cabin - Gathering.1',2,140,140,368),(219,'Weita Island - Fish Drying Yard.1',1,1200,2400,369),(220,'Wolf Hills - Lumbering.1',1,100,150,377);
/*!40000 ALTER TABLE `subnode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subnode_city`
--

DROP TABLE IF EXISTS `subnode_city`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `subnode_city` (
  `subnode_id` int(11) NOT NULL,
  `city_id` int(11) NOT NULL,
  KEY `subnode_id` (`subnode_id`),
  KEY `city_id` (`city_id`),
  CONSTRAINT `subnode_city_ibfk_1` FOREIGN KEY (`subnode_id`) REFERENCES `subnode` (`subnode_id`),
  CONSTRAINT `subnode_city_ibfk_2` FOREIGN KEY (`city_id`) REFERENCES `city` (`city_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subnode_city`
--

LOCK TABLES `subnode_city` WRITE;
/*!40000 ALTER TABLE `subnode_city` DISABLE KEYS */;
INSERT INTO `subnode_city` VALUES (1,1),(1,2),(2,1),(2,2),(3,2),(3,3),(3,1),(4,2),(4,3),(4,1),(5,4),(5,5),(5,6),(6,7),(6,8),(6,9),(6,10),(7,7),(7,8),(7,9),(7,10),(8,11),(8,12),(8,13),(9,3),(9,14),(9,15),(10,3),(10,14),(10,15),(11,6),(11,5),(11,16),(12,6),(12,5),(12,16),(13,3),(13,2),(13,1),(14,2),(14,3),(14,1),(15,2),(15,3),(15,1),(16,14),(16,12),(16,3),(16,15),(17,12),(17,14),(17,11),(18,12),(18,14),(18,11),(18,3),(19,16),(19,5),(19,6),(20,16),(20,5),(20,6),(21,11),(21,13),(22,14),(22,3),(22,12),(23,14),(23,3),(23,12),(24,17),(24,5),(25,11),(25,13),(25,12),(26,11),(26,12),(26,13),(27,14),(27,3),(27,12),(28,14),(28,3),(28,12),(29,1),(29,4),(30,4),(30,1),(30,17),(31,4),(31,1),(31,17),(32,13),(32,10),(32,18),(33,19),(33,14),(33,12),(34,13),(34,12),(34,18),(35,13),(35,11),(35,12),(35,18),(36,13),(36,11),(36,12),(36,18),(37,4),(37,1),(37,17),(38,4),(38,1),(38,17),(39,12),(39,14),(40,3),(40,15),(41,14),(41,12),(41,3),(42,14),(42,12),(42,3),(43,14),(43,12),(43,3),(44,14),(44,12),(44,3),(45,3),(45,15),(46,3),(46,15),(47,3),(47,15),(48,4),(48,5),(48,1),(49,4),(49,5),(49,1),(50,4),(50,1),(50,5),(51,4),(51,1),(51,5),(52,14),(52,3),(53,11),(53,13),(53,12),(54,19),(54,1),(54,2),(54,14),(55,19),(55,1),(55,2),(55,14),(56,18),(56,15),(56,3),(56,8),(56,10),(57,18),(57,15),(57,3),(57,8),(57,10),(58,8),(58,7),(58,9),(59,8),(59,7),(59,9),(60,14),(60,3),(60,12),(61,14),(61,3),(61,12),(62,2),(62,3),(62,1),(63,2),(63,3),(63,1),(64,14),(64,12),(64,3),(64,19),(65,5),(65,6),(65,16),(66,5),(66,6),(66,16),(67,5),(67,6),(67,16),(68,14),(68,3),(68,12),(69,14),(69,3),(69,12),(70,5),(70,6),(70,16),(71,5),(71,6),(71,16),(72,14),(72,3),(72,12),(73,14),(73,12),(73,3),(74,14),(74,12),(74,3),(75,8),(75,7),(75,9),(75,10),(76,5),(76,6),(76,16),(77,5),(77,6),(77,16),(78,5),(78,6),(78,16),(79,5),(79,6),(79,16),(80,5),(80,6),(80,16),(81,18),(81,8),(81,15),(81,3),(82,18),(82,8),(82,15),(82,3),(83,15),(83,3),(84,15),(84,3),(84,18),(85,15),(85,3),(85,18),(86,18),(86,13),(86,15),(86,10),(87,18),(87,13),(87,15),(87,10),(88,14),(88,3),(88,12),(89,14),(89,3),(89,12),(90,1),(90,4),(90,2),(90,17),(91,1),(91,4),(91,17),(91,2),(92,18),(92,13),(92,10),(92,15),(93,9),(93,7),(93,10),(94,14),(94,12),(94,3),(95,14),(95,12),(95,3),(96,12),(96,14),(96,19),(97,12),(97,14),(97,19),(98,17),(98,5),(98,6),(99,17),(99,5),(99,6),(100,5),(100,6),(100,16),(101,2),(101,3),(101,14),(101,1),(102,2),(102,3),(102,14),(102,1),(103,13),(103,18),(103,12),(103,3),(103,14),(104,2),(104,1),(104,3),(105,2),(105,1),(105,3),(106,18),(106,13),(106,15),(106,10),(107,7),(107,8),(107,9),(107,10),(108,7),(108,8),(108,9),(108,10),(109,8),(109,18),(109,2),(109,3),(109,15),(110,8),(110,18),(110,2),(110,3),(110,15),(111,13),(111,18),(111,12),(112,17),(112,5),(112,6),(113,17),(113,5),(113,6),(114,1),(114,4),(114,17),(115,9),(115,7),(115,10),(116,1),(116,17),(116,4),(117,12),(117,11),(117,14),(118,12),(118,11),(118,14),(119,14),(119,12),(119,3),(120,10),(120,18),(120,13),(121,10),(121,18),(121,13),(122,9),(122,7),(122,10),(123,9),(123,7),(123,10),(124,12),(124,11),(124,14),(125,14),(125,12),(125,3),(125,19),(126,10),(126,13),(126,18),(127,3),(127,15),(127,14),(127,12),(128,3),(128,15),(128,14),(128,12),(129,3),(129,15),(129,14),(130,10),(130,13),(130,11),(130,18),(131,10),(131,13),(131,11),(131,18),(132,8),(132,7),(132,18),(133,8),(133,7),(133,18),(134,18),(134,10),(134,13),(135,18),(135,10),(135,13),(136,19),(136,14),(136,12),(137,14),(137,12),(137,19),(138,1),(138,2),(139,2),(139,3),(139,1),(139,19),(140,2),(140,3),(140,1),(140,19),(141,2),(141,1),(141,3),(142,11),(142,13),(143,3),(143,15),(144,3),(144,15),(145,12),(145,19),(145,14),(145,11),(146,12),(146,19),(146,14),(146,11),(147,3),(147,15),(147,14),(148,3),(148,14),(149,3),(149,14),(150,3),(150,15),(150,14),(151,3),(151,15),(151,14),(152,16),(152,5),(152,6),(153,13),(153,18),(154,13),(154,18),(155,13),(155,18),(156,11),(156,12),(156,13),(157,11),(157,12),(157,13),(158,13),(158,18),(159,2),(159,1),(159,3),(160,2),(160,1),(160,3),(161,12),(161,14),(161,19),(162,19),(162,12),(162,14),(163,18),(163,13),(163,15),(164,19),(164,14),(164,12),(165,13),(165,18),(165,10),(166,19),(166,1),(166,2),(167,19),(167,1),(167,2),(168,4),(168,5),(168,1),(169,4),(169,5),(169,1),(170,5),(170,4),(170,6),(170,16),(171,9),(171,7),(171,10),(172,18),(172,13),(172,10),(173,19),(173,1),(173,2),(174,19),(174,1),(174,2),(175,4),(175,1),(176,11),(176,13),(177,11),(177,13),(178,11),(178,13),(178,12),(179,11),(179,13),(179,12),(180,10),(180,18),(180,13),(181,10),(181,18),(181,13),(182,13),(182,10),(182,11),(182,18),(183,5),(183,6),(183,16),(184,11),(184,13),(184,12),(185,15),(185,3),(185,18),(186,7),(186,9),(186,10),(187,17),(187,4),(188,17),(188,4),(189,17),(189,4),(190,8),(190,7),(190,9),(190,10),(191,2),(191,3),(191,1),(192,15),(192,3),(192,18),(193,15),(193,3),(193,18),(194,9),(194,7),(194,10),(195,12),(195,11),(195,14),(196,12),(196,11),(196,14),(197,2),(197,3),(197,1),(198,19),(198,1),(198,2),(198,14),(199,19),(199,1),(199,14),(199,2),(200,11),(200,13),(201,11),(201,13),(202,12),(202,14),(202,13),(203,5),(203,4),(203,16),(204,5),(204,4),(204,16),(205,5),(205,4),(205,16),(206,9),(206,7),(206,10),(207,14),(207,12),(207,3),(208,14),(208,12),(208,3),(209,10),(209,13),(210,8),(210,18),(210,15),(210,2),(210,3),(211,8),(211,18),(211,15),(211,2),(211,3),(212,5),(212,6),(212,16),(213,5),(213,6),(213,16),(214,5),(214,6),(214,16),(215,1),(215,4),(215,17),(216,7),(216,10),(216,9),(217,12),(217,14),(217,13),(218,9),(218,7),(218,10),(219,19),(219,14),(219,12),(220,12),(220,14);
/*!40000 ALTER TABLE `subnode_city` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subnode_item`
--

DROP TABLE IF EXISTS `subnode_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `subnode_item` (
  `subnode_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  KEY `subnode_id` (`subnode_id`),
  KEY `item_id` (`item_id`),
  CONSTRAINT `subnode_item_ibfk_1` FOREIGN KEY (`subnode_id`) REFERENCES `subnode` (`subnode_id`),
  CONSTRAINT `subnode_item_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `item` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subnode_item`
--

LOCK TABLES `subnode_item` WRITE;
/*!40000 ALTER TABLE `subnode_item` DISABLE KEYS */;
INSERT INTO `subnode_item` VALUES (1,212),(1,150),(1,144),(2,114),(2,147),(2,154),(3,43),(3,44),(4,2),(5,98),(6,128),(6,158),(7,114),(7,158),(8,66),(8,71),(8,69),(8,68),(9,151),(10,40),(11,180),(12,180),(13,212),(13,150),(13,161),(14,167),(14,26),(15,198),(15,191),(15,110),(15,130),(16,198),(16,189),(16,211),(16,45),(17,80),(17,57),(17,79),(17,52),(18,56),(18,80),(18,52),(18,55),(19,136),(19,38),(19,134),(20,136),(20,38),(20,134),(21,66),(21,75),(21,68),(21,67),(22,8),(22,174),(23,178),(23,138),(24,106),(25,81),(25,66),(25,71),(25,69),(26,66),(26,75),(26,59),(26,50),(27,145),(28,33),(28,92),(29,114),(29,147),(29,154),(30,129),(31,180),(32,185),(32,148),(33,58),(33,81),(33,86),(33,51),(34,190),(34,193),(34,39),(34,205),(34,4),(35,184),(35,18),(36,21),(36,20),(37,180),(38,41),(38,149),(38,160),(39,108),(40,122),(40,121),(41,114),(41,147),(42,41),(42,149),(43,105),(43,15),(44,114),(44,147),(45,206),(46,102),(46,103),(47,151),(48,114),(48,147),(48,154),(49,114),(49,147),(49,154),(50,47),(51,186),(51,149),(51,164),(52,178),(52,138),(53,75),(53,59),(53,50),(53,77),(54,58),(54,86),(54,51),(54,82),(55,74),(55,81),(55,51),(55,72),(56,183),(56,181),(56,182),(57,101),(57,99),(57,100),(58,10),(59,42),(60,105),(60,15),(61,8),(61,7),(62,171),(62,17),(63,208),(63,207),(63,23),(64,56),(64,80),(64,57),(64,79),(65,143),(66,47),(67,169),(67,168),(68,145),(69,33),(69,92),(70,180),(71,180),(72,6),(72,11),(73,122),(73,123),(74,41),(74,149),(75,196),(75,120),(76,200),(76,147),(76,160),(77,178),(77,138),(78,186),(78,149),(78,164),(79,200),(79,146),(79,155),(80,186),(80,149),(80,164),(81,178),(82,25),(83,196),(83,194),(83,22),(83,165),(83,90),(84,36),(84,12),(85,116),(85,150),(86,37),(86,146),(87,96),(87,14),(88,41),(88,163),(89,8),(89,174),(90,143),(91,95),(91,94),(91,93),(92,114),(92,147),(93,128),(93,150),(94,41),(94,149),(95,41),(95,149),(96,80),(96,75),(96,56),(96,49),(97,75),(97,56),(97,80),(97,79),(98,129),(99,95),(99,94),(99,93),(100,6),(100,111),(100,172),(101,184),(101,18),(102,102),(102,103),(103,167),(103,26),(104,43),(104,44),(105,34),(106,37),(106,146),(107,212),(107,127),(108,128),(108,127),(109,21),(109,19),(109,20),(110,141),(110,139),(110,140),(111,185),(111,161),(112,200),(112,146),(112,155),(113,175),(114,152),(114,9),(115,128),(115,148),(116,9),(116,152),(117,80),(117,52),(117,54),(117,85),(118,56),(118,57),(118,79),(118,84),(119,145),(120,32),(120,31),(121,167),(121,26),(122,209),(122,210),(123,119),(123,117),(123,118),(124,80),(124,55),(124,54),(124,85),(125,56),(125,81),(125,80),(125,79),(126,32),(126,174),(127,170),(127,27),(128,197),(128,194),(128,3),(128,203),(128,35),(129,104),(129,115),(130,101),(130,100),(131,199),(131,192),(131,46),(131,204),(131,188),(132,10),(133,42),(134,107),(134,16),(135,141),(135,140),(136,80),(136,52),(136,55),(136,78),(137,80),(137,57),(137,79),(137,78),(138,167),(138,26),(139,208),(139,207),(139,131),(140,122),(140,121),(140,131),(141,41),(141,149),(141,160),(142,81),(142,75),(142,50),(142,53),(143,206),(144,102),(144,103),(145,59),(145,83),(145,73),(145,133),(145,77),(146,59),(146,83),(146,73),(146,166),(146,77),(147,91),(147,13),(148,114),(148,147),(149,41),(149,149),(150,170),(150,27),(151,122),(151,153),(152,28),(152,30),(152,29),(153,206),(154,10),(155,137),(156,81),(156,66),(156,69),(156,82),(157,75),(157,50),(157,59),(157,82),(158,21),(158,153),(159,212),(159,150),(159,144),(160,37),(160,146),(160,162),(161,75),(161,80),(161,56),(161,62),(162,57),(162,81),(162,55),(162,62),(163,32),(163,123),(164,80),(164,81),(164,82),(164,67),(165,101),(165,100),(166,86),(166,58),(166,51),(166,62),(167,74),(167,72),(167,51),(167,61),(168,28),(168,30),(168,29),(169,114),(169,147),(169,154),(170,195),(170,48),(170,187),(170,5),(171,24),(171,142),(172,116),(172,146),(173,57),(173,79),(173,55),(173,83),(174,80),(174,56),(174,79),(174,60),(175,41),(175,149),(175,160),(176,116),(176,150),(177,21),(177,153),(178,75),(178,50),(178,65),(178,68),(179,76),(179,50),(179,69),(179,64),(180,96),(180,14),(181,192),(181,193),(181,97),(181,89),(181,204),(182,185),(182,157),(183,177),(183,146),(183,156),(184,66),(184,76),(184,59),(184,70),(185,141),(185,123),(186,126),(186,124),(186,125),(187,98),(188,175),(189,98),(190,195),(190,88),(191,179),(191,113),(191,173),(192,36),(192,12),(193,114),(193,159),(194,128),(194,146),(195,80),(195,76),(195,54),(195,85),(196,56),(196,57),(196,72),(196,84),(197,1),(197,23),(197,0),(198,58),(198,86),(198,51),(199,74),(199,81),(199,86),(199,72),(200,75),(200,69),(200,53),(200,68),(201,81),(201,63),(201,75),(201,59),(202,41),(203,143),(204,180),(205,136),(205,135),(205,134),(206,193),(206,201),(206,89),(207,42),(208,42),(209,101),(209,23),(210,25),(211,87),(212,143),(213,47),(214,106),(215,95),(215,94),(215,93),(216,176),(216,112),(217,132),(218,202),(218,109),(219,81),(219,52),(219,65),(219,67),(220,8);
/*!40000 ALTER TABLE `subnode_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yield`
--

DROP TABLE IF EXISTS `yield`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
 SET character_set_client = utf8mb4 ;
CREATE TABLE `yield` (
  `yield_id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` float DEFAULT NULL,
  `item_id` int(11) NOT NULL,
  `subnode_id` int(11) NOT NULL,
  PRIMARY KEY (`yield_id`),
  KEY `item_id` (`item_id`),
  KEY `subnode_id` (`subnode_id`),
  CONSTRAINT `yield_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `item` (`item_id`),
  CONSTRAINT `yield_ibfk_2` FOREIGN KEY (`subnode_id`) REFERENCES `subnode` (`subnode_id`)
) ENGINE=InnoDB AUTO_INCREMENT=535 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yield`
--

LOCK TABLES `yield` WRITE;
/*!40000 ALTER TABLE `yield` DISABLE KEYS */;
INSERT INTO `yield` VALUES (1,7.86,212,1),(2,1.86,150,1),(3,0.95,144,1),(4,10.53,114,2),(5,1.8,147,2),(6,1.08,154,2),(7,12.53,43,3),(8,0.85,44,3),(9,14.62,2,4),(10,22.25,98,5),(11,8.5,128,6),(12,0.4,158,6),(13,8.5,114,7),(14,0.4,158,7),(15,3.6,66,8),(16,1.8,71,8),(17,1.8,69,8),(18,0.9,68,8),(19,10.53,151,9),(20,11.45,40,10),(21,20.85,180,11),(22,20.32,180,12),(23,10.39,212,13),(24,1.96,150,13),(25,1.14,161,13),(26,12.26,167,14),(27,0.26,26,14),(28,1.11,198,15),(29,1.01,191,15),(30,9.19,110,15),(31,8.42,130,15),(32,1.07,198,16),(33,0.83,189,16),(34,12.36,211,16),(35,13.4,45,16),(36,3.6,80,17),(37,3.6,57,17),(38,1.8,79,17),(39,1.8,52,17),(40,3.6,56,18),(41,3.6,80,18),(42,1.8,52,18),(43,1.8,55,18),(44,18.36,136,19),(45,2.73,38,19),(46,0.99,134,19),(47,16.33,136,20),(48,2.98,38,20),(49,1.28,134,20),(50,3.6,66,21),(51,3.6,75,21),(52,0.9,68,21),(53,0.08,67,21),(54,9.38,8,22),(55,0.55,174,22),(56,8.8,178,23),(57,0.63,138,23),(58,21.69,106,24),(59,3.6,81,25),(60,3.6,66,25),(61,1.8,71,25),(62,1.8,69,25),(63,3.6,66,26),(64,3.6,75,26),(65,1.8,59,26),(66,1.8,50,26),(67,9.49,145,27),(68,10.12,33,28),(69,3.27,92,28),(70,14.78,114,29),(71,2.41,147,29),(72,1.32,154,29),(73,21.58,129,30),(74,20.86,180,31),(75,13.39,185,32),(76,1.01,148,32),(77,3.6,58,33),(78,3.6,81,33),(79,3.6,86,33),(80,1.8,51,33),(81,1.04,190,34),(82,0.86,193,34),(83,8.7,39,34),(84,8.6,205,34),(85,8.58,4,34),(86,9.94,184,35),(87,0.63,18,35),(88,8.93,21,36),(89,1.17,20,36),(90,21.19,180,37),(91,18.13,41,38),(92,2.53,149,38),(93,1.34,160,38),(94,4.58,108,39),(95,8.52,122,40),(96,1.04,121,40),(97,8.94,114,41),(98,0.76,147,41),(99,9.19,41,42),(100,1.12,149,42),(101,7.69,105,43),(102,0.62,15,43),(103,11.62,114,44),(104,1.25,147,44),(105,9.97,206,45),(106,10.61,102,46),(107,0.64,103,46),(108,10.56,151,47),(109,14.81,114,48),(110,2.16,147,48),(111,0.97,154,48),(112,14.87,114,49),(113,2.48,147,49),(114,1.44,154,49),(115,22.7,47,50),(116,5.26,186,51),(117,2.57,149,51),(118,0.55,164,51),(119,9.03,178,52),(120,0.7,138,52),(121,3.6,75,53),(122,1.8,59,53),(123,1.8,50,53),(124,0.08,77,53),(125,3.6,58,54),(126,3.6,86,54),(127,1.8,51,54),(128,0.9,82,54),(129,3.6,74,55),(130,3.6,81,55),(131,1.8,51,55),(132,1.8,72,55),(133,18,183,56),(134,1.3,181,56),(135,1.15,182,56),(136,18,101,57),(137,1.3,99,57),(138,1.15,100,57),(139,9,10,58),(140,9,42,59),(141,6.98,105,60),(142,0.5,15,60),(143,7.48,8,61),(144,0.89,7,61),(145,9.29,171,62),(146,0.71,17,62),(147,10.63,208,63),(148,1.01,207,63),(149,1.16,23,63),(150,3.6,56,64),(151,3.6,80,64),(152,3.6,57,64),(153,1.8,79,64),(154,22.83,143,65),(155,21.08,47,66),(156,17.79,169,67),(157,0.48,168,67),(158,10.09,145,68),(159,9.62,33,69),(160,2.95,92,69),(161,21.17,180,70),(162,21.09,180,71),(163,7.26,6,72),(164,0.51,11,72),(165,9.73,122,73),(166,0.7,123,73),(167,9.69,41,74),(168,0.91,149,74),(169,1.6,196,75),(170,13.65,120,75),(171,6.85,200,76),(172,2.55,147,76),(173,0.53,160,76),(174,10.91,178,77),(175,0.72,138,77),(176,5.36,186,78),(177,2.28,149,78),(178,0.52,164,78),(179,5.85,200,79),(180,2.7,146,79),(181,0.56,155,79),(182,5.34,186,80),(183,1.85,149,80),(184,0.64,164,80),(185,3,178,81),(186,1.65,25,82),(187,1.26,196,83),(188,1.18,194,83),(189,9.25,22,83),(190,8.68,165,83),(191,9.45,90,83),(192,7.2,36,84),(193,0.47,12,84),(194,10,116,85),(195,0.66,150,85),(196,12.02,37,86),(197,0.96,146,86),(198,8.42,96,87),(199,0.66,14,87),(200,7.25,41,88),(201,0.79,163,88),(202,9.62,8,89),(203,0.61,174,89),(204,21.34,143,90),(205,17.72,95,91),(206,1.27,94,91),(207,1.55,93,91),(208,9.93,114,92),(209,0.74,147,92),(210,4.65,128,93),(211,1.65,150,93),(212,8.97,41,94),(213,0.67,149,94),(214,9.65,41,95),(215,0.71,149,95),(216,3.6,80,96),(217,3.6,75,96),(218,3.6,56,96),(219,0.9,49,96),(220,3.6,75,97),(221,3.6,56,97),(222,3.6,80,97),(223,1.8,79,97),(224,22,129,98),(225,18.37,95,99),(226,0.97,94,99),(227,1.09,93,99),(228,5.28,6,100),(229,0.26,111,100),(230,0.18,172,100),(231,9.79,184,101),(232,0.66,18,101),(233,10.26,102,102),(234,0.54,103,102),(235,12.16,167,103),(236,0.27,26,103),(237,12.63,43,104),(238,0.75,44,104),(239,13.29,34,105),(240,11.34,37,106),(241,0.69,146,106),(242,8.5,212,107),(243,0.01,127,107),(244,8.5,128,108),(245,0.01,127,108),(246,18,21,109),(247,1.3,19,109),(248,1.15,20,109),(249,18,141,110),(250,1.3,139,110),(251,1.15,140,110),(252,8.98,185,111),(253,0.82,161,111),(254,6.25,200,112),(255,2.61,146,112),(256,0.53,155,112),(257,21.77,175,113),(258,1.42,152,114),(259,15.6,9,114),(260,4.78,128,115),(261,1.5,148,115),(262,9.2,9,116),(263,1.97,152,116),(264,3.6,80,117),(265,1.8,52,117),(266,0.9,54,117),(267,0.08,85,117),(268,3.6,56,118),(269,3.6,57,118),(270,1.8,79,118),(271,0.9,84,118),(272,8.77,145,119),(273,9.42,32,120),(274,1.27,31,120),(275,11.34,167,121),(276,0.11,26,121),(277,7.3,209,122),(278,5.2,210,122),(279,17.95,119,123),(280,1.07,117,123),(281,3.09,118,123),(282,3.6,80,124),(283,1.8,55,124),(284,0.9,54,124),(285,0.08,85,124),(286,3.6,56,125),(287,3.6,81,125),(288,3.6,80,125),(289,1.8,79,125),(290,10.75,32,126),(291,0.62,174,126),(292,10.4,170,127),(293,0.16,27,127),(294,0.85,197,128),(295,1.28,194,128),(296,9.44,3,128),(297,10.11,203,128),(298,9.9,35,128),(299,10.94,104,129),(300,0.59,115,129),(301,9.09,101,130),(302,1.09,100,130),(303,1.21,199,131),(304,1.06,192,131),(305,8.96,46,131),(306,9.59,204,131),(307,9.17,188,131),(308,9,10,132),(309,9,42,133),(310,9.74,107,134),(311,0.58,16,134),(312,9.45,141,135),(313,1.31,140,135),(314,3.6,80,136),(315,1.8,52,136),(316,1.8,55,136),(317,0.9,78,136),(318,3.6,80,137),(319,3.6,57,137),(320,1.8,79,137),(321,0.9,78,137),(322,11.79,167,138),(323,0.07,26,138),(324,13.07,208,139),(325,0.78,207,139),(326,0.68,131,139),(327,10.41,122,140),(328,1.18,121,140),(329,1.02,131,140),(330,10.2,41,141),(331,1.79,149,141),(332,0.92,160,141),(333,3.6,81,142),(334,3.6,75,142),(335,1.8,50,142),(336,0.9,53,142),(337,11.2,206,143),(338,10.47,102,144),(339,0.62,103,144),(340,2.1,59,145),(341,1.44,83,145),(342,1.49,73,145),(343,0.94,133,145),(344,0.08,77,145),(345,2.1,59,146),(346,1.44,83,146),(347,1.49,73,146),(348,0.94,166,146),(349,0.08,77,146),(350,7.6,91,147),(351,0.46,13,147),(352,9.73,114,148),(353,0.64,147,148),(354,9.64,41,149),(355,0.59,149,149),(356,10.35,170,150),(357,0.34,27,150),(358,9.55,122,151),(359,0.6,153,151),(360,18.23,28,152),(361,1.3,30,152),(362,1.35,29,152),(363,11.65,206,153),(364,12.27,10,154),(365,11.17,137,155),(366,3.6,81,156),(367,3.6,66,156),(368,1.8,69,156),(369,0.9,82,156),(370,3.6,75,157),(371,1.8,50,157),(372,1.8,59,157),(373,0.9,82,157),(374,11.83,21,158),(375,0.79,153,158),(376,8.38,212,159),(377,2.01,150,159),(378,0.8,144,159),(379,9.67,37,160),(380,1.71,146,160),(381,0.98,162,160),(382,3.6,75,161),(383,3.6,80,161),(384,3.6,56,161),(385,0.08,62,161),(386,3.6,57,162),(387,3.6,81,162),(388,1.8,55,162),(389,0.08,62,162),(390,11.69,32,163),(391,0.86,123,163),(392,3.6,80,164),(393,3.6,81,164),(394,0.9,82,164),(395,0.08,67,164),(396,8.01,101,165),(397,0.96,100,165),(398,3.6,86,166),(399,3.6,58,166),(400,1.8,51,166),(401,0.08,62,166),(402,3.6,74,167),(403,1.8,72,167),(404,1.8,51,167),(405,0.9,61,167),(406,18.62,28,168),(407,1.15,30,168),(408,1.04,29,168),(409,15.11,114,169),(410,2.5,147,169),(411,1.13,154,169),(412,0.42,195,170),(413,5.26,48,170),(414,5.8,187,170),(415,2.13,5,170),(416,6.7,24,171),(417,6.6,142,171),(418,8.96,116,172),(419,0.98,146,172),(420,3.6,57,173),(421,1.8,79,173),(422,1.8,55,173),(423,0.9,83,173),(424,3.6,80,174),(425,3.6,56,174),(426,1.8,79,174),(427,0.9,60,174),(428,15.66,41,175),(429,2.39,149,175),(430,1.43,160,175),(431,11.05,116,176),(432,0.82,150,176),(433,11.48,21,177),(434,0.82,153,177),(435,3.6,75,178),(436,1.8,50,178),(437,0.9,65,178),(438,0.9,68,178),(439,3.6,76,179),(440,1.8,50,179),(441,1.8,69,179),(442,0.9,64,179),(443,8.71,96,180),(444,0.59,14,180),(445,0.95,192,181),(446,0.92,193,181),(447,8.25,97,181),(448,8.18,89,181),(449,8.82,204,181),(450,9.03,185,182),(451,0.69,157,182),(452,5.14,177,183),(453,1.7,146,183),(454,0.1,156,183),(455,3.6,66,184),(456,3.6,76,184),(457,1.8,59,184),(458,0.08,70,184),(459,10.01,141,185),(460,0.73,123,185),(461,18.43,126,186),(462,1.3,124,186),(463,1.08,125,186),(464,20.81,98,187),(465,20.97,175,188),(466,20.68,98,189),(467,1.6,195,190),(468,13.65,88,190),(469,10.65,179,191),(470,1.39,113,191),(471,0.69,173,191),(472,7.27,36,192),(473,0.5,12,192),(474,7.84,114,193),(475,0.58,159,193),(476,4.96,128,194),(477,1.42,146,194),(478,3.6,80,195),(479,3.6,76,195),(480,0.9,54,195),(481,0.08,85,195),(482,3.6,56,196),(483,3.6,57,196),(484,1.8,72,196),(485,0.9,84,196),(486,13.83,1,197),(487,0.71,23,197),(488,0.76,0,197),(489,3.6,58,198),(490,3.6,86,198),(491,1.8,51,198),(492,3.61,74,199),(493,3.6,81,199),(494,3.6,86,199),(495,1.8,72,199),(496,3.6,75,200),(497,1.8,69,200),(498,0.9,53,200),(499,0.9,68,200),(500,3.6,81,201),(501,3.6,63,201),(502,3.6,75,201),(503,1.8,59,201),(504,4.3,41,202),(505,21.76,143,203),(506,21.75,180,204),(507,17.43,136,205),(508,1.22,135,205),(509,1.05,134,205),(510,1.82,193,206),(511,0.05,201,206),(512,14.64,89,206),(513,9.42,42,207),(514,8.64,42,208),(515,11.06,101,209),(516,0.9,23,209),(517,1.65,25,210),(518,3,87,211),(519,21.28,143,212),(520,21.19,47,213),(521,24.21,106,214),(522,17.92,95,215),(523,1.01,94,215),(524,1.17,93,215),(525,9.1,176,216),(526,0.28,112,216),(527,4.51,132,217),(528,7.7,202,218),(529,6.9,109,218),(530,3.6,81,219),(531,1.8,52,219),(532,0.9,65,219),(533,0.08,67,219),(534,4.43,8,220);
/*!40000 ALTER TABLE `yield` 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 2019-07-25 19:19:47
