1 CREATE TABLE `pet_levelstats` (
2 `creature_entry` int(11) unsigned NOT NULL,
3 `level` tinyint(3) unsigned NOT NULL,
4 `hp` smallint(5) unsigned NOT NULL,
5 `mana` smallint(5) unsigned NOT NULL,
6 `str` smallint(5) unsigned NOT NULL,
7 `agi` smallint(5) unsigned NOT NULL,
8 `sta` smallint(5) unsigned NOT NULL,
9 `int` smallint(5) unsigned NOT NULL,
10 `spi` smallint(5) unsigned NOT NULL,
11 PRIMARY KEY (`creature_entry`,`level`)
12 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.';