[Err] 1054 - Unknown column 'faction_A' in 'field list'
[Err] REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (40070, 0, 0, 0, 0, 0, 30453, 0, 30453, 0, 'Lightbringer', 'Paladin Trainer', '', 0, 83, 83, 0, 35, 35, 49, 1, 1.14286, 1, 2, 1000, 2000, 0, 2000, 100, 1500, 1500, 2, 2, 0, 0, 0, 0, 2, 0, 200, 500, 1000, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10000, 10000, '', 0, 3, 10, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2026, 0, 2, '', 1);

REPLACE INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES (9338572, 40070, 0, 1, 1, 0, 2026, -8972.98, 534.087, 95.0579, 0.839159, 300, 0, 0, 46460, 21290, 0, 0, 0, 0);

DELETE FROM `npc_trainer` WHERE (`entry`=40070);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(40070, 465, 10, 0, 0, 0),
(40070, 498, 100, 0, 0, 6),
(40070, 633, 300, 0, 0, 10),
(40070, 639, 100, 0, 0, 6),
(40070, 642, 13000, 0, 0, 34),
(40070, 643, 4000, 0, 0, 20),
(40070, 647, 2000, 0, 0, 14),
(40070, 750, 20000, 0, 0, 40),
(40070, 853, 100, 0, 0, 8),
(40070, 879, 4000, 0, 0, 20),
(40070, 1022, 300, 0, 0, 10),
(40070, 1026, 4000, 0, 0, 22),
(40070, 1032, 20000, 0, 0, 40),
(40070, 1038, 6000, 0, 0, 26),
(40070, 1042, 11000, 0, 0, 30),
(40070, 1044, 3500, 0, 0, 18),
(40070, 1152, 100, 0, 0, 8),
(40070, 2800, 11000, 0, 0, 30),
(40070, 2812, 28000, 0, 0, 50),
(40070, 3127, 100, 0, 0, 8),
(40070, 3472, 16000, 0, 0, 38),
(40070, 4987, 21000, 0, 0, 42),
(40070, 5502, 4000, 0, 0, 20),
(40070, 5588, 5000, 0, 0, 24),
(40070, 5589, 20000, 0, 0, 40),
(40070, 5599, 5000, 0, 0, 24),
(40070, 5614, 9000, 0, 0, 28),
(40070, 5615, 14000, 0, 0, 36),
(40070, 6940, 24000, 0, 0, 46),
(40070, 7294, 3000, 0, 0, 16),
(40070, 7328, 1200, 0, 0, 12),
(40070, 10278, 16000, 0, 0, 38),
(40070, 10290, 300, 0, 0, 10),
(40070, 10291, 11000, 0, 0, 30),
(40070, 10292, 28000, 0, 0, 50),
(40070, 10293, 46000, 0, 0, 60),
(40070, 10298, 6000, 0, 0, 26),
(40070, 10299, 14000, 0, 0, 36),
(40070, 10300, 24000, 0, 0, 46),
(40070, 10301, 42000, 0, 0, 56),
(40070, 10308, 40000, 0, 0, 54),
(40070, 10310, 28000, 0, 0, 50),
(40070, 10312, 22000, 0, 0, 44),
(40070, 10313, 34000, 0, 0, 52),
(40070, 10314, 46000, 0, 0, 60),
(40070, 10318, 46000, 0, 0, 60),
(40070, 10322, 5000, 0, 0, 24),
(40070, 10324, 14000, 0, 0, 36),
(40070, 10326, 5000, 0, 0, 24),
(40070, 10328, 24000, 0, 0, 46),
(40070, 10329, 40000, 0, 0, 54),
(40070, 13820, 10000, 0, 0, 20),
(40070, 19740, 100, 0, 0, 4),
(40070, 19742, 2000, 0, 0, 14),
(40070, 19746, 4000, 0, 0, 22),
(40070, 19750, 4000, 0, 0, 20),
(40070, 19752, 11000, 0, 0, 30),
(40070, 19834, 1000, 0, 0, 12),
(40070, 19835, 4000, 0, 0, 22),
(40070, 19836, 12000, 0, 0, 32),
(40070, 19837, 21000, 0, 0,
[Err] 1054 - Unknown column 'faction_A' in 'field list'
[Err] DELETE FROM `creature` WHERE `id`=200138;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(9339555, 200138, 1, 1, 1, 0, 0, 1557.79, -4202.49, 43.3025, 4.8007, 300, 0, 0, 580800, 0, 0, 0, 0, 0),
(9338530, 200138, 0, 1, 1, 0, 0, -8916.41, 491.89, 93.8577, 2.35358, 300, 0, 0, 580800, 0, 0, 0, 0, 0);

DELETE FROM `npc_vendor` WHERE (`entry`=200138);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(200138, 0, 2589, 0, 0, 0),
(200138, 0, 33470, 0, 0, 0),
(200138, 0, 38426, 0, 0, 0),
(200138, 0, 41510, 0, 0, 0),
(200138, 0, 41511, 0, 0, 0),
(200138, 0, 41593, 0, 0, 0),
(200138, 0, 41594, 0, 0, 0),
(200138, 0, 41595, 0, 0, 0),
(200138, 0, 42253, 0, 0, 0);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (200139, 0, 0, 0, 0, 0, 23156, 0, 0, 0, 'Leather Metal Stone', 'Trade Goods', '', 0, 83, 83, 0, 35, 35, 4224, 1, 1.14286, 1, 2, 50, 150, 0, 1000, 1, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 100, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 1);

DELETE FROM `creature` WHERE `id`=200139;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(9339556, 200139, 1, 1, 1, 0, 0, 1561.28, -4202.13, 43.3923, 4.78735, 300, 0, 0, 580800, 0, 0, 0, 0, 0),
(9338531, 200139, 0, 1, 1, 0, 0, -8913.96, 493.604, 93.8631, 2.3041, 300, 0, 0, 580800, 0, 0, 0, 0, 0);

DELETE FROM `npc_vendor` WHERE (`entry`=200139);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(200139, 0, 2318, 0, 0, 0),
(200139, 0, 2770, 0, 0, 0),
(200139, 0, 2835, 0, 0, 0),
(200139, 0, 2840, 0, 0, 0),
(200139, 0, 33567, 0, 0, 0),
(200139, 0, 33568, 0, 0, 0),
(200139, 0, 36909, 0, 0, 0),
(200139, 0, 36910, 0, 0, 0),
(200139, 0, 36912, 0, 0, 0),
(200139, 0, 36913, 0, 0, 0),
(200139, 0, 36916, 0, 0, 0),
(200139, 0, 37663, 0, 0, 0),
(200139, 0, 38425, 0, 0, 0),
(200139, 0, 38557, 0, 0, 0),
(200139, 0, 38558, 0, 0, 0),
(200139, 0, 38561, 0, 0, 0),
(200139, 0, 41163, 0, 0, 0),
(200139, 0, 44128, 0, 0, 0);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attac
[Err] 1054 - Unknown column 'faction_A' in 'field list'
[Err] DELETE FROM `creature` WHERE `id`=200124;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(9338494, 200124, 0, 1, 1, 0, 547, -8963.66, 520.391, 96.5971, 5.28365, 300, 0, 0, 53420, 0, 0, 0, 0, 0),
(9339545, 200124, 1, 1, 1, 0, 547, 1532.96, -4207.86, 41.903, 4.85396, 300, 0, 0, 53420, 0, 0, 0, 0, 0);

DELETE FROM `npc_vendor` WHERE (`entry`=200124);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(200124, 0, 23775, 0, 0, 0),
(200124, 0, 38347, 0, 0, 0),
(200124, 0, 38399, 0, 0, 0),
(200124, 0, 41597, 0, 0, 0),
(200124, 0, 41598, 0, 0, 0),
(200124, 0, 44446, 0, 0, 0),
(200124, 0, 45773, 0, 0, 0);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (200125, 0, 0, 0, 0, 0, 22209, 0, 22209, 0, 'Ammo quiver', 'Container', '', 0, 80, 80, 0, 35, 35, 4224, 1, 1.14286, 1, 1, 50, 150, 0, 1000, 1, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 10, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 547, 0, 0, '', 1);

DELETE FROM `creature` WHERE `id`=200125;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(9338497, 200125, 0, 1, 1, 0, 547, -8965.35, 519.149, 96.5971, 5.43524, 300, 0, 0, 53420, 0, 0, 0, 0, 0),
(9339546, 200125, 1, 1, 1, 0, 547, 1529.44, -4208.1, 41.6468, 4.88774, 300, 0, 0, 53420, 0, 0, 0, 0, 0);

DELETE FROM `npc_vendor` WHERE (`entry`=200125);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(200125, 0, 41597, 0, 0, 0),
(200125, 0, 44447, 0, 0, 0),
(200125, 0, 44448, 0, 0, 0);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingol
[Err] 1054 - Unknown column 'faction_A' in 'field list'
[Err] REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70013, 0, 0, 0, 0, 0, 14733, 0, 14733, 0, 'Didi the Wrench', 'Goblin Engineering Trainer', '', 0, 83, 83, 2, 35, 35, 81, 1, 1.14286, 1, 2, 340, 510, 0, 127, 1, 2000, 2000, 1, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 100, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 547, 0, 0, '', 1);

DELETE FROM `creature` WHERE `id`=70013;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(9339870, 70013, 1, 1, 1, 0, 547, 1577.8, -4225.28, 46.4429, 0.468022, 300, 0, 0, 1394500, 0, 0, 0, 0, 0),
(9338170, 70013, 0, 1, 1, 0, 547, -8946.71, 497.419, 94.8553, 0.607861, 300, 0, 0, 1394500, 0, 0, 0, 0, 0);

DELETE FROM `npc_trainer` WHERE (`entry`=70013);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70013, 8895, 2200, 202, 130, 0),
(70013, 12715, 1000, 202, 205, 0),
(70013, 12716, 1500, 202, 205, 0),
(70013, 12717, 1500, 202, 205, 0),
(70013, 12718, 1500, 202, 205, 0),
(70013, 12754, 2600, 202, 235, 0),
(70013, 12755, 2400, 202, 230, 0),
(70013, 12758, 3000, 202, 245, 0),
(70013, 12760, 1500, 202, 205, 0),
(70013, 12908, 2800, 202, 240, 0),
(70013, 13240, 1500, 202, 205, 0),
(70013, 30558, 25000, 202, 325, 0),
(70013, 30560, 35000, 202, 340, 0),
(70013, 30563, 50000, 202, 350, 0),
(70013, 30565, 100000, 202, 375, 0),
(70013, 30566, 100000, 202, 375, 0),
(70013, 56514, 150000, 202, 425, 0);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70014, 0, 0, 0, 0, 0,
[Err] 1062 - Duplicate entry '9338567' for key 'PRIMARY'
[Err] INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(9338567, 200073, 0, 1, 1, 0, 0, -8985.37, 482.336, 97.227, 2.37503, 300, 0, 0, 53420, 0, 0, 0, 0, 0),
(9339834, 200073, 1, 1, 1, 0, 0, 1555.27, -4178.44, 41.0083, 3.41039, 300, 0, 0, 53420, 0, 0, 0, 0, 0);

DELETE FROM `npc_vendor` WHERE (`entry`=200073);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(200073, 0, 42041, 0, 0, 0),
(200073, 0, 42042, 0, 0, 0),
(200073, 0, 42043, 0, 0, 0),
(200073, 0, 42044, 0, 0, 0),
(200073, 0, 42045, 0, 0, 0),
(200073, 0, 42046, 0, 0, 0),
(200073, 0, 42047, 0, 0, 0),
(200073, 0, 46374, 0, 0, 0),
(200073, 0, 50609, 0, 0, 0),
(200073, 0, 50627, 0, 0, 0),
(200073, 0, 50633, 0, 0, 0),
(200073, 0, 50647, 0, 0, 0),
(200073, 0, 50658, 0, 0, 0),
(200073, 0, 50682, 0, 0, 0),
(200073, 0, 50700, 0, 0, 0),
(200073, 0, 50724, 0, 0, 0),
(200073, 0, 54581, 0, 0, 0);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (200068, 0, 0, 0, 0, 0, 18637, 0, 18637, 0, 'libram/idol/totem/Sigils', 'Armor relic', '', 0, 80, 80, 0, 35, 35, 4224, 1, 1.14286, 1, 1, 50, 150, 0, 1000, 1, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 10, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 1);

DELETE FROM `creature` WHERE `id`=200068;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(9338568, 200068, 0, 1, 1, 0, 0, -8987.67, 480.388, 97.2618, 2.1402, 300, 0, 0, 53420, 0, 0, 0, 0, 0),
(9339835, 200068, 1, 1, 1, 0, 0, 1554.83, -4175.73, 40.7734, 3.29808, 300, 0, 0, 53420, 0, 0, 0, 0, 0);

DELETE FROM `npc_vendor` WHERE (`entry`=200068);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(200068, 0, 50454, 0, 0, 0),
(200068, 0, 50455, 0, 0, 0),
(200068, 0, 50456, 0, 0, 0),
(200068, 0, 50457, 0, 0, 0),
(200068, 0, 50458, 0, 0, 0),
(200068, 0, 50459, 0, 0, 0),
(200068, 0, 50460, 0, 0, 0),
(200068, 0, 50461, 0, 0, 0),
(200068, 0, 50462, 0, 0, 0),
(200068, 0, 50463, 0, 0, 0),
(200068, 0, 50464, 0, 0, 0),
(200068, 0, 51417, 0, 0, 0),
(200068, 0, 51423, 0, 0, 0),
(200068, 0, 51429, 0, 0, 0),
(200068, 0, 51437, 0, 0, 0),
(200068, 0, 51472, 0, 0, 0),
(200068, 0, 51478, 0, 0, 0),
(200068, 0, 51501, 0, 0, 0),
(200068, 0, 51507, 0, 0, 0),
(200068, 0, 51513, 0, 0, 0);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit
[Err] 1054 - Unknown column 'faction_A' in 'field list'
[Err] DELETE FROM `gameobject` WHERE `id`=2575;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(14531851, 2575, 1, 1, 1, 1609.12, -4234.41, 46.153, 3.48325, 0, 0, 0.985444, -0.17, 300, 0, 1),
(70302, 2575, 309, 1, 1, -14378.8, 379.264, 23.3135, -2.13803, 0, 0, 0.876727, -0.480989, 180, 100, 1);

REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (191004, 8, 166, 'Anvil', '', '', '', 0, 0, 1.29, 0, 0, 0, 0, 0, 0, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340);

DELETE FROM `gameobject` WHERE `id`=191004;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(50036, 191004, 571, 1, 1, 2943.88, -337.584, 114.655, -2.9496, 0, 0, 0, 0, 300, 0, 1),
(14531858, 191004, 1, 1, 1, 1606.2, -4231.12, 45.8529, 4.00078, 0, 0, 0.909135, -0.416502, 300, 0, 1);

REPLACE INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES (201741, 10, 8365, 'Empowering Blood Orb', '', '', '', 0, 0, 1.5, 0, 0, 0, 0, 0, 0, 1634, 0, 0, 0, 0, 0, 0, 0, 0, 0, 70227, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340);

DELETE FROM `gameobject` WHERE `id`=201741;
INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotatio n3`,`spawntimesecs`,`animprogress`,`state`) VALUES
(72060, 201741, 631, 15, 1, 4523.17, 2769.37, 351.102, 3.16508, 0, 0, 0.999931, -0.011744, 604800, 100, 1),
(14531860, 201741, 1, 1, 1, 1554.42, -4199.58, 43.2315, 3.85075, 0, 0, 0.937792, -0.347197, 300, 0, 1);

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (200091, 0, 0, 0, 0, 0, 18593, 0, 18593, 0, 'Reagent Level 70', 'Burning Crusade Reagents', '', 0, 83, 83, 2, 35, 35, 4225, 1, 1.14286, 1, 2,
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Подгоняйте под свою бд, как подозреваю, у вас она примерно такого же вида.
Зы - код не исполнять, это просто сравнение старой структуры с новой, в криачур_темплейт, дальше сами.
ALTER TABLE `creature_template`
DROP COLUMN `faction_H`,
DROP COLUMN `mindmg`,
DROP COLUMN `maxdmg`,
DROP COLUMN `attackpower`,
DROP COLUMN `dmg_multiplier`,
DROP COLUMN `minrangedmg`,
DROP COLUMN `maxrangedmg`,
DROP COLUMN `rangedattackpower`,
DROP COLUMN `equipment_id`,
CHANGE COLUMN `faction_A` `faction` smallint(5) UNSIGNED NOT NULL DEFAULT 0 AFTER `exp`,
CHANGE COLUMN `baseattacktime` `BaseAttackTime` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `dmgschool`,
CHANGE COLUMN `rangeattacktime` `RangeAttackTime` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `BaseAttackTime`,
CHANGE COLUMN `Health_mod` `HealthModifier` float NOT NULL DEFAULT 1 AFTER `InhabitType`,
CHANGE COLUMN `Mana_mod` `ManaModifier` float NOT NULL DEFAULT 1 AFTER `HealthModifier`,
CHANGE COLUMN `Armor_mod` `ArmorModifier` float NOT NULL DEFAULT 1 AFTER `ManaModifier`,
CHANGE COLUMN `WDBVerified` `VerifiedBuild` smallint(5) NULL DEFAULT 1 AFTER `ScriptName`,
ADD COLUMN `BaseVariance` float NOT NULL DEFAULT 1 AFTER `RangeAttackTime`,
ADD COLUMN `RangeVariance` float NOT NULL DEFAULT 1 AFTER `BaseVariance`,
ADD COLUMN `unit_flags2` int(10) NOT NULL AFTER `unit_flags`,
ADD COLUMN `HoverHeight` float NOT NULL AFTER `InhabitType`,
ADD COLUMN `DamageModifier` float NOT NULL DEFAULT 1 AFTER `ArmorModifier`,
ADD COLUMN `ExperienceModifier` float NOT NULL DEFAULT 1 AFTER `DamageModifier`;

REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `faction`, `npcflag`,