current peq db, quests, and eq-EMU revisions

[strider51]

thanks for the help. is there anyway to get all the updates in 1 shot? I actually made a vb script to create a sourceAll.sql that list them in numerical order, but I still get some errors like

"Column does not exist".

I'm wondering if there is another preferred order.

Here's what Im doing:
I'm creating a database with the db_dump.sql
then I'm applying all updates in the updates folder of that repository
then I'm applying all of the updates in the server Source SVN repository: trunk\EQEmuServer\utils\sql\svn

I get tons of duplicate entry, column, unknown colum errors; and I'm executing these updates in numerical order.


EDIT: doing this in this order deletes your spells_new table......

[strider51]

FIXED:

All i had to do was listen to the original Directions:

Load the db_dump.sql
Then install updates, but ONLY the updates that are greater than 1900.


I now have a running private local server; pretty cool.

[strider51]

Additional Question here:

Is there any other way to determine what SQL updates are necessary to run?
It seems like the main.sql source file used to have a revision attached to it so you could see what you needed to run.

The new one is just db_dump.sql, but has no revision number, so is anyone supposed to know which updates they need ?

Update: I looked at revision history on the peqDatabase directory. KimmySprite removed the version labeled file on 5/18/2011 and replaced with incremental. I guess I dont understand the idea behind this?