* Move sql updates for 0.11 release to sql/updates/0.11

[getmangos.git] / sql / updates / 0.11 / 6326_characters_corpse.sql

ALTER TABLE corpse
  ADD COLUMN corpse_type tinyint(3) unsigned NOT NULL default '0' AFTER bones_flag;

UPDATE corpse
  SET corpse_type = 1 WHERE bones_flag = 0;

ALTER TABLE corpse
  DROP bones_flag;