sql/updates/0.6/2842_character_pet.sql

   1 ALTER TABLE `character_pet`
   2   ADD COLUMN `modelid` int(11) unsigned default '0' after `owner`;
   3
   4 UPDATE `character_pet`,`creature_template`
   5   SET `character_pet`.`modelid` = `creature_template`.`modelid_m`
   6   WHERE `character_pet`.`modelid` = 0 AND `character_pet`.`entry` = `creature_template`.`entry`;
   7
   8 UPDATE `character_pet`,`creature_template`
   9   SET `character_pet`.`modelid` = `creature_template`.`modelid_f`
  10   WHERE `character_pet`.`modelid` = 0 AND `character_pet`.`entry` = `creature_template`.`entry`;