It's a good question that I haven't gotten around to asking as well. table "spells" seems to get created when you setup the PEQEditor web interface (or mine was anyway). I never understood why, because as you said - EQEmu seems to run fine without it before.
Is it one of those "if it's there, I'll use it, otherwise I'm sticking to _____"?
PEQEditors README.TXT file
Code:
Step 5:
Source schema.sql (in the editor's /sql directory) into your database first, then source in allspells.sql.