The primary key on the `grid` table should be (id,zoneid). The primary key on `grid_entries` should be (gridid,zoneid,number). If the primary key is wrong, this could allow duplicate grids or waypoints within the same zone that have the same id number, and the results are neither predictable nor supported.
I don't know who makes the structure for the barebones database, but they should correct this before the next release.
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
|