diff options
| author | Shauren <none@none> | 2010-09-21 21:55:16 +0200 |
|---|---|---|
| committer | Shauren <none@none> | 2010-09-21 21:55:16 +0200 |
| commit | d8ddf38453cb988645244d0f10da10f1d1665c93 (patch) | |
| tree | f15bd1a980aec13570fa0f49b1a148fb3702c36b /sql/updates | |
| parent | 5eb0fd80acfb0fe93b6e0e1af09d8129534120c2 (diff) | |
Core/Items: Implemented trading soulbound loot items
Core/DBLayer: Converted more more player-related queries into prepared statements
Core/Items: Fixed loading of enchantments
Closes issue #4130.
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/10030_characters_item_soulbound_trade_data.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/10030_characters_item_soulbound_trade_data.sql b/sql/updates/10030_characters_item_soulbound_trade_data.sql new file mode 100644 index 00000000000..e6f43debb9b --- /dev/null +++ b/sql/updates/10030_characters_item_soulbound_trade_data.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `item_soulbound_trade_data`; +CREATE TABLE `item_soulbound_trade_data` ( + `itemGuid` int(11) unsigned NOT NULL COMMENT 'Item GUID', + `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade', + PRIMARY KEY (`itemGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item Refund System'; |