Updating Database

[AsmoTiC]

So that I don't derail another thread any further, had a couple questions about updating an existing database which has a couple custom modifications.

I've been running off the old August 2015 PEQ database, and would like to come up with a process to keep it up-to-date with the weekly dump PEQ does. I have a small handful of custom entries that i'd like to preserve, but need a little guidance on creating the SQL.

If I understand the process correctly, from reading the readme.txt file that comes with the weekly dump. After creating a full backup of the database you'd source "drop_system.sql", after which you could then source "peqbeta.sql". I assume login server accounts, characters, and bots/healing rotations are all left intact.

So, I have a single custom item, which is sold from an existing merchant in pok. I have 2 quest npc's in the guild lobby for handing out starting gear (the quest files won't change). Finally, I moved the succor point in Sirens Grotto so you don't end up in the middle of 3 mobs.

My thought is, i'd just create a custom SQL with those changes and source it in after I source "peqbeta.sql". Question is, where in the DB would I look for these changes. I used the peqeditor to make them, so not sure exactly what tables each would be in.

Appreciate any help. In addition, any example of SQL Syntax for the merchant list would be great. Pretty sure once I know what table the new npcs are under and the new item, they would be straight forward, but I believe the syntax for modifying an existing tables value (succor point in SG for example) is different than just creating a new entry.

Thanks again guys!

edit - Quick addition. The two NPC's in the Guild Lobby have spawn group information as well. In addition, if the server rules are set, having a way to quickly change them back to the existing ones would be nice too. Probably obvious, but thought i'd mention it quickly.