pet_stats.sql

ALTER TABLE `pet_levelstats` ADD `mindmg` SMALLINT UNSIGNED NOT NULL AFTER `armor` ,
ADD `maxdmg` SMALLINT UNSIGNED NOT NULL AFTER `mindmg` ;

UPDATE `pet_levelstats`
	SET mindmg = level - (level/4),	maxdmg = level + (level/4);

/* Hunter Pet Stats*/
DELETE FROM `pet_levelstats` WHERE 
	`creature_entry` = 1 AND 
	(`level` BETWEEN '5' AND '20' OR
	 `level` IN ('23','24', '25', '27', '46', '47', '48', '49', '51') OR
	 `level`BETWEEN '71' AND '76');


INSERT INTO `pet_levelstats` (`creature_entry`, `level`, `hp`, `mana`, `armor`, `mindmg`, `maxdmg`, `str`, `agi`, `sta`, `inte`, `spi`) VALUES
('1', '5', '101', '1', '103', '3', '5', '26', '8', '25', '20', '21'),
('1', '6', '119', '1', '156', '3', '5', '27', '9', '26', '21', '21'),
('1', '7', '136', '1', '221', '4', '7', '27', '9', '26', '21', '21'),
('1', '8', '155', '1', '297', '4', '8', '29', '9', '28', '21', '22'),
('1', '9', '175', '1', '386', '5', '9', '30', '9', '29', '21', '22'),
('1', '10', '197', '1', '492', '5', '9', '31', '9', '30', '21', '23'),
('1', '11', '221', '1', '518', '6', '10', '32', '10', '34', '21', '23'),
('1', '12', '246', '1', '552', '6', '10', '33', '10', '38', '21', '24'),
('1', '13', '272', '1', '585', '6', '11', '34', '11', '42', '21', '26'),
('1', '14', '299', '1', '619', '7', '12', '35', '11', '46', '22', '26'),
('1', '15', '327', '1', '653', '8', '12', '37', '12', '51', '22', '27'),
('1', '16', '355', '1', '688', '8', '13', '38', '12', '55', '22', '28'),
('1', '17', '385', '1', '722', '8', '14', '40', '12', '59', '22', '29'),
('1', '18', '409', '1', '755', '9', '15', '42', '13', '63', '22', '29'),
('1', '19', '448', '1', '789', '9', '16', '44', '13', '67', '22', '31'),
('1', '20', '483', '1', '822', '11', '16', '45', '14', '72', '22', '32'),
('1', '23', '604', '1', '928', '11', '18', '50', '15', '84', '23', '34'),
('1', '24', '650', '1', '962', '11', '19', '52', '16', '88', '23', '34'),
('1', '25', '698', '1', '992', '12', '19', '53', '16', '94', '23', '37'),
('1', '27', '799', '1', '1061', '11', '19', '56', '17', '102', '23', '39'),
('1', '46', '1917', '1', '2723', '30', '45', '104', '27', '188', '27', '58'),
('1', '47', '1989', '1', '2776', '30', '46', '106', '28', '193', '27', '60'),
('1', '48', '2061', '1', '2828', '31', '47', '108', '29', '197', '27', '60'),
('1', '49', '2136', '1', '2883', '32', '48', '110', '29', '202', '28', '62'),
('1', '51', '2290', '1', '2988', '33', '50', '115', '30', '212', '28', '64'),
('1', '71', '4240', '1', '6960', '44', '67', '164', '58', '312', '33', '102'),
('1', '72', '4427', '1', '7255', '45', '68', '167', '63', '317', '34', '105'),
('1', '73', '4620', '1', '7550', '45', '69', '170', '68', '322', '34', '108'),
('1', '74', '4818', '1', '7845', '47', '70', '187', '73', '328', '59', '99'),
('1', '75', '5018', '1', '8141', '47', '72', '206', '78', '334', '61', '101'),
('1', '76', '5219', '1', '8436', '48', '73', '226', '84', '339', '62', '102');