1 ALTER TABLE `auctionhouse`
2 ADD `item_template` int(11) unsigned NOT NULL default '0' AFTER `itemguid`;
4 UPDATE `auctionhouse`,`item_instance`
5 SET `item_template` = SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1)
6 WHERE `auctionhouse`.`itemguid` = `item_instance`.`guid`;