Вот кусок из Npc sql
Скрытый текст-- ------------------------------ Table structure for `npc`
-- ----------------------------
DROP TABLE IF EXISTS `npc`;
CREATE TABLE `npc` (
`id` decimal(11,0) NOT NULL DEFAULT '0',
`idTemplate` int(11) NOT NULL DEFAULT '0',
`name` varchar(200) DEFAULT NULL,
`serverSideName` int(1) DEFAULT '0',
`title` varchar(45) DEFAULT '',
`serverSideTitle` int(1) DEFAULT '0',
`class` varchar(200) DEFAULT NULL,
`collision_radius` decimal(5,2) DEFAULT NULL,
`collision_height` decimal(5,2) DEFAULT NULL,
`level` decimal(2,0) DEFAULT NULL,
`sex` varchar(6) DEFAULT NULL,
`type` varchar(20) DEFAULT NULL,
`attackrange` int(11) DEFAULT NULL,
`hp` decimal(8,0) DEFAULT NULL,
`mp` decimal(5,0) DEFAULT NULL,
`hpreg` decimal(8,2) DEFAULT NULL,
`mpreg` decimal(5,2) DEFAULT NULL,
`str` decimal(7,0) DEFAULT NULL,
`con` decimal(7,0) DEFAULT NULL,
`dex` decimal(7,0) DEFAULT NULL,
`int` decimal(7,0) DEFAULT NULL,
`wit` decimal(7,0) DEFAULT NULL,
`men` decimal(7,0) DEFAULT NULL,
`exp` decimal(9,0) DEFAULT NULL,
`sp` decimal(8,0) DEFAULT NULL,
`patk` decimal(5,0) DEFAULT NULL,
`pdef` decimal(5,0) DEFAULT NULL,
`matk` decimal(5,0) DEFAULT NULL,
`mdef` decimal(5,0) DEFAULT NULL,
`atkspd` decimal(3,0) DEFAULT NULL,
`aggro` decimal(6,0) DEFAULT NULL,
`matkspd` decimal(4,0) DEFAULT NULL,
`rhand` decimal(4,0) DEFAULT NULL,
`lhand` decimal(4,0) DEFAULT NULL,
`armor` decimal(1,0) DEFAULT NULL,
`walkspd` decimal(3,0) DEFAULT NULL,
`runspd` decimal(3,0) DEFAULT NULL,
`faction_id` varchar(40) DEFAULT NULL,
`faction_range` decimal(4,0) DEFAULT NULL,
`isUndead` int(11) DEFAULT '0',
`absorb_level` decimal(2,0) DEFAULT '0',
`absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') NOT NULL DEFAULT 'LAST_HIT',
`ss` int(4) DEFAULT '0',
`bss` int(4) DEFAULT '0',
`ss_rate` int(3) DEFAULT '0',
`AI` varchar( DEFAULT 'fighter',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of npc
-- ----------------------------
INSERT INTO npc VALUES ('12077', '12077', 'Wolf', '0', '', '0', 'Monster.pet_wolf', '13.00', '11.50', '15', 'male', 'L2Pet', '40', '195', '164', '3.95', '1.21', '40', '43', '30', '21', '20', '25', '0', '0', '9', '19', '3', '17', '282', '0', '333', '0', '0', '0', '26', '137', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),
('12311', '12311', 'Hatchling of the Wind', '0', '', '0', 'Monster.hatchling', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '282', '0', '333', '0', '0', '0', '88', '154', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),
('12312', '12312', 'Hatchling of the Stars', '0', '', '0', 'Monster.hatchling', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '282', '0', '333', '0', '0', '0', '88', '154', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),
('12313', '12313', 'Hatchling of Twilight', '0', '', '0', 'Monster.hatchling', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '282', '0', '333', '0', '0', '0', '88', '154', null, '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter'),