-- 'Just a Fancy Cockroach'

SET @ID := 46129;

DELETE FROM `creature` WHERE  `id`=@ID;
INSERT 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
(301108, @ID, 1, 1, 1, 34908, 0, -9175.61, -1492.59, -172.56, 1.23544, 300, 3, 0, 26840, 110, 0, 1, 0, 0),
(301118, @ID, 1, 1, 1, 34908, 0, -9144.31, -1453.88, -170.91, 0.848595, 300, 0, 0, 26840, 110, 0, 2, 0, 0),
(301119, @ID, 1, 1, 1, 34908, 0, -9118.99, -1474.95, -170.91, 1.7886, 300, 0, 0, 26840, 110, 0, 2, 0, 0),
(301120, @ID, 1, 1, 1, 34908, 0, -9137.9, -1484.15, -170.91, 0.128344, 300, 0, 0, 26840, 110, 0, 2, 0, 0),
(301130, @ID, 1, 1, 1, 34908, 0, -9128.73, -1499.29, -170.91, 1.05119, 300, 0, 0, 26840, 110, 0, 2, 0, 0),
(301131, @ID, 1, 1, 1, 34908, 0, -9147.2, -1474.96, -170.91, 1.96197, 300, 0, 0, 26840, 110, 0, 2, 0, 0),
(301132, @ID, 1, 1, 1, 34908, 0, -9151.84, -1462.45, -170.91, 4.12922, 300, 0, 0, 26840, 110, 0, 2, 0, 0),
(301133, @ID, 1, 1, 1, 34908, 0, -9153.88, -1490.72, -170.91, 2.34725, 300, 0, 0, 26840, 110, 0, 2, 0, 0),
(301134, @ID, 1, 1, 1, 34908, 0, -9170.61, -1474.58, -172.56, 0.853751, 300, 3, 0, 26840, 110, 0, 1, 0, 0),
(301135, @ID, 1, 1, 1, 34908, 0, -9134.92, -1476.27, -170.91, 4.68472, 300, 3, 0, 26840, 110, 0, 1, 0, 0),
(301145, @ID, 1, 1, 1, 34908, 0, -9134.48, -1501.02, -170.91, 5.73487, 300, 3, 0, 26840, 110, 0, 1, 0, 0),
(301154, @ID, 1, 1, 1, 34908, 0, -9124.68, -1486.63, -170.91, 4.73828, 300, 3, 0, 26840, 110, 0, 1, 0, 0),
(301174, @ID, 1, 1, 1, 34908, 0, -9155.64, -1515.72, -170.91, 5.56379, 300, 3, 0, 26840, 110, 0, 1, 0, 0),
(301176, @ID, 1, 1, 1, 34908, 0, -9142.63, -1526.73, -170.91, 1.04295, 300, 3, 0, 26840, 110, 0, 1, 0, 0),
(301177, @ID, 1, 1, 1, 34908, 0, -9136.94, -1524.82, -170.91, 0.634006, 300, 3, 0, 26840, 110, 0, 1, 0, 0);