The way you could do the national spells is simply add more columns to the spell DB, namely something like nation1 and nation2 up until you have enough and then put the first nation to have the spell in the first column and the second to nation2 and so forth. If there was one thing I learned from the Dom2DB, it was that it's a safer bet to put in a few more columns even if they don't get used much than it is to try and squeeze too much information into too few columns. Especially if we're going to turn this into a comprehensive DB.
There should be one column for spell type, which could use categories such as
- global enchantment
- local (province) enchantment (e.g. domes, rain of toads, hurricane)
- ritual summon
- combat summon
- combat offensive (lightning bolt, fire darts etc)
- combat augmentation (quickness, fire shield etc)
- overland movement (teleport, cloud trapeze etc)
- overland attack (earth attack, seeking arrow, ghost riders etc)
In general, we want to keep the categories simple and avoid having too many. Hence the above listing groups things targeting a single province in one category, regardless of effect. Spells that summon usable things, like black hawks, angelic host and so forth that can be dropped on an enemy should be classed as ritual summons because you get to keep the things, while ghost riders would obviously be overland attack since they vanish afterward. That's my two cents on that anyway.
My project is already well on its way as far as the layout is concerned, I've added all the forts to the DB and I'm currently making a brand new magic site database. It's going to be preliminary until I get the unit DB side fleshed out so I can add everything the way I want it done.
This project is also great at unearthing some minor bugs and a lot of in-game typos, so I'm going to add those into a list as I go along.
Edi