Field Name Field Description Field Type Field Default Value
id The ID of the fishing row. int(11) Auto Increment
zoneid The zone ID that the item can be fished for in. Zones int(4) 0
Itemid The item ID of the item that can be fished for. int(11) 0
skill_level The required fishing skill level to fish for this item. smallint(6) 0
chance The chance to catch this item when fishing. smallint(6) 0
npc_id The NPC ID that may spawn when attempting to fish for this item. int(11) 0
npc_chance The chance that the NPC will spawn when fishing for this item. int(11) 0