Cavedude: You may be uniquely suited to help me. Disregard everything that has been done here already.
Here is the situation in the most simple of terms.
I originally installed peq from:
http://www.projecteq.net/downloads.php
The 1110a version and your standard db.
I have since done the following:
Created a couple items
Add them to some loot tables
Modified some loot tables
Modified some factions
Modified some spawn tables
I need to be able to move to the current version of the software while preserving these changes. In other words, I need to get current and instead of replacing these tables, alter them to add the necessary columns while also not harming my characters and their inventories. I have a tool that will alter them for me, as long as I have a good schema to bring the columns in from.
How exactly would you go about doing this? This can't be a unique situation other than that it is coming from such an old version.