Initial Patch of Auction House bot rev. 135

[auctionmangos.git] / sql / updates / 0.8 / 4224_pet_aura.sql

ALTER TABLE `pet_aura`
  ADD `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier' AFTER `guid`,
  ADD `amount`     int(11) NOT NULL default '0' AFTER `effect_index`;

UPDATE `pet_aura`
  SET `caster_guid` = `guid`;