Select or Update Query to Adjust Loot Based on Zone?

[Hateborne]

Evening Ladies and Gents,

I am trying to find a way to edit the drops based on zone, instead of individual mob(s). For example: if I wanted to double the coin drops from lakeofillomen, the only way I can find to do it is manually look up all the mobs in the zone and then hop through a variety of table to get to each mob.

Am I missing something here or is there some table relationship that I am missing?

Currently referencing: http://eqemu.psend.com/schema.html

Thank You in Advance!

-Hate