[Doodman]

For doors, look for door_update.sql and source it.

For merchant temp list, look for merchant_templist.sql (or something similar).

For NPCS, do:

ALTER TABLE npc_types ADD npc_aggro TINYINT NOT NULL DEFAULT '0';

Enjoy