Code:
REPLACE into `creature_template` (`entry`, `heroic_entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `baseattacktime`, `rangeattacktime`, `flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `class`, `race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `flag1`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `RacialLeader`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) values
('27881','0','23884','0','23884','0','Wintergrasp Catapult','','','80','80','30000','30000','30000','30000','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('28319','0','25301','0','25301','0','Wintergrasp Siege Turret','','','80','80','20000','20000','20000','20000','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('27883','0','26558','0','26559','0','Wintergrasp Shredder','','','80','80','16000','16000','16000','16000','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('27838','0','22878','0','22878','0','Wintergrasp Flying Machine 1','','','70','70','26946','26946','26946','26946','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('27850','0','23365','0','23365','0','Wintergrasp Flying Machine 2 (Bomber)','','','80','80','37800','37800','37800','37800','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('27852','0','24807','0','24807','0','Wintergrasp AA Guns','','','80','80','37800','37800','37800','37800','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('28094','0','25092','0','25092','0','Wintergrasp Demolisher','','','80','80','100000','100000','100000','100000','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('28312','0','25290','0','25290','0','Wintergrasp Siege Engine','','','80','80','200000','200000','200000','200000','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0',''),
('27905','0','26557','0','26557','0','Wintergrasp Bomber Cockpit','','','80','80','37800','37800','37800','37800','0','35','35','16777216','1','1','0','1','1','0','0','0','0','0','0','28','0','0','0','0','1','40','100','9','16777216','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','1','0','1','0','0','0','');
REPLACE INTO `creature_model_info` VALUES
('23884', '1.1', '1.1', '2', '0'),
('25301', '1.1', '1.1', '2', '0'),
('22878', '1.1', '1.1', '2', '0'),
('23365', '1.1', '1.1', '2', '0'),
('24807', '1.1', '1.1', '2', '0'),
('25092', '1.1', '1.1', '2', '0'),
('25290', '1.1', '1.1', '2', '0'),
('26558', '1.1', '1.1', '2', '0'),
('26557', '1.1', '1.1', '2', '0'),
('26884', '1.1', '1.1', '2', '0');
REPLACE INTO `creature_template_addon` (`entry`, `mount`, `bytes0`, `bytes1`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES
(27881, '0', 131584, 1, 0, 0, 0, ''),
(28319, '0', 131584, 1, 0, 0, 0, ''),
(27883, '0', 131584, 1, 0, 0, 0, ''),
(27838, '0', 131584, 1, 0, 0, 0, ''),
(27850, '0', 131584, 1, 0, 0, 0, ''),
(27852, '0', 131584, 1, 0, 0, 0, ''),
(28094, '0', 131584, 1, 0, 0, 0, ''),
(28312, '0', 131584, 1, 0, 0, 0, ''),
(27905, '0', 131584, 1, 0, 0, 0, '');