ALTER TABLE `character_pet`
ROW_FORMAT=DEFAULT,
CHANGE `id` `id` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `entry` `entry` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `owner` `owner` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `modelid` `modelid` INT(10) UNSIGNED DEFAULT '0' NULL ,
CHANGE `CreatedBySpell` `CreatedBySpell` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `level` `level` SMALLINT(5) UNSIGNED DEFAULT '1' NOT NULL,
CHANGE `exp` `exp` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `Reactstate` `Reactstate` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `name` `name` VARCHAR(21) DEFAULT 'Pet' NOT NULL,
CHANGE `renamed` `renamed` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `slot` `slot` TINYINT(3) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `curhealth` `curhealth` INT(10) UNSIGNED DEFAULT '1' NOT NULL,
CHANGE `curmana` `curmana` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `curhappiness` `curhappiness` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `savetime` `savetime` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `resettalents_cost` `resettalents_cost` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `resettalents_time` `resettalents_time` INT(10) UNSIGNED DEFAULT '0' NOT NULL,
CHANGE `abdata` `abdata` TEXT NULL;