port over some changes from Trinity version including one possible memory leak fix

[AHbot.git] / sql / updates / 0.6 / 2637_mail.sql

ALTER TABLE `mail`
  ADD `item_template` int(11) unsigned NOT NULL default '0' AFTER `item`;

UPDATE `mail`,`item_instance`
  SET `item_template` = SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1)
  WHERE `mail`.`item` = `item_instance`.`guid`;