[Sarepean]

Try this:

ALTER TABLE npc_faction_entries ADD npc_value TINYINT UNSIGNED DEFAULT '0' NOT NULL;

UPDATE npc_faction_entries SET npc_value=1 WHERE value<0;

-Sarepean