DROP TABLE IF EXISTS `character_pet`;
CREATE TABLE `character_pet` (
`id` int(11) unsigned NOT NULL default '0',
`entry` int(11) unsigned NOT NULL default '0',
`owner` int(11) unsigned NOT NULL default '0',
`modelid` int(11) unsigned default '0',
`level` int(11) unsigned NOT NULL default '1',
`exp` int(11) unsigned NOT NULL default '0',
`nextlvlexp` int(11) unsigned NOT NULL default '100',
`spell1` int(11) unsigned NOT NULL default '0',
`spell2` int(11) unsigned NOT NULL default '0',
`spell3` int(11) unsigned NOT NULL default '0',
`spell4` int(11) unsigned NOT NULL default '0',
`action` int(11) unsigned NOT NULL default '0',
`fealty` int(11) unsigned NOT NULL default '0',
`loyalty` int(11) unsigned NOT NULL default '1',
`trainpoint` int(11) unsigned NOT NULL default '0',
`name` varchar(100) default 'Pet',
`renamed` tinyint(1) unsigned NOT NULL default '0',
`slot` int(11) unsigned NOT NULL default '0',
`curhealth` int(11) unsigned NOT NULL default '1',
`curmana` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `owner` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
--
-- Dumping data for table `character_pet`
--
LOCK TABLES `character_pet` WRITE;
/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
UNLOCK TABLES;