root/trunk/sql/updates/0.6/2637_auctionhouse.sql @ 2

Revision 2, 282 bytes (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00
Line 
1ALTER TABLE `auctionhouse`
2  ADD `item_template` int(11) unsigned NOT NULL default '0' AFTER `itemguid`;
3
4UPDATE `auctionhouse`,`item_instance`
5  SET `item_template` = SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1)
6  WHERE `auctionhouse`.`itemguid` = `item_instance`.`guid`;
Note: See TracBrowser for help on using the browser.