root/trunk/sql/updates/5664_mangos.sql @ 2

Revision 2, 297 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 npc_vendor
2    ADD ExtendedCost mediumint(8) unsigned NOT NULL default '0';
3UPDATE npc_vendor,item_template SET npc_vendor.ExtendedCost = item_template.ExtendedCost WHERE npc_vendor.item = item_template.entry;
4ALTER TABLE item_template
5    DROP ExtendedCost,
6    DROP CondExtendedCost;
Note: See TracBrowser for help on using the browser.