Spells Table

[trevius]

Does anyone know what the Spells table in the database is for, or if it is even used at all? As far as I can tell from my testing, the only important spell information is in the spells_us.txt on the server (host eqemu directory) and the client (Everquest directory).

Can the spells table just be removed or does it actually have a purpose? Which leads me to my next question; is there a way to source the spells_us.txt file into the Spells table? The only thing I can think of is using notepad to replace all ^ with a TAB instead in the spells_us.txt file and then deleting all rows in the spell table and pasting the text from notepad directly into the table via Navicat. I think that would work, but if someone has a better way I would like to hear. Again, if the spells table isn't even used at all, I guess there isn't much of a point at bothering with this. I am mainly just curious if it would help fix any spell bugs or issues.