Blog initiated.

Digging in to World of Warcraft spell database files. Figuring out values....seems what I'm looking for is not stored client-side.

Compilation of all information stored here: MMO - Champion: Profession Forums

So far...

Spell.dbc
AG = SpellCastingRequirements.dbc
AH = SpellCategories.dbc
AI = SpellClassOptions.dbc
AN = SpellLevels.dbc
AP = SpellReagents.dbc
AR = SpellTargetRestrictions.dbc

SpellCastingRequirements.dbc
All crafting:
XXXX 0 0 0 0 0 1

SpellCategories.dbc
No freaking clue.

SpellEffect.dbc
K = Result, Item ID
Y = Spell ID

SpellReagents.dbc is very straightforward. Not seeing anything like Profession skill requirements or specialty requirements in the Spell.dbc or sub-files.