[Xothin]

Actually, the syntax that finally worked for me was...

ALTER TABLE items CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT "0" NOT NULL;