From 940f655a3c61c80e9823855df1fbc4630a698926 Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 30 Jul 2012 18:34:39 +0100 Subject: Core/VS: Allow to store/retrive random stats items in void storage Also set items to soulbound on withdraw --- sql/base/characters_database.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'sql/base') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index f42c8f2e6ad..fdddd8c982b 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2278,6 +2278,8 @@ CREATE TABLE `void_storage` ( `itemEntry` mediumint(8) unsigned NOT NULL, `slot` tinyint(3) unsigned NOT NULL, `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0', + `randomProperty` int(10) unsigned NOT NULL DEFAULT '0', + `suffixFactor` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`itemId`), UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`), KEY `idx_player` (`playerGuid`) @@ -2350,4 +2352,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-07-30 16:34:12 +-- Dump completed on 2012-07-30 17:01:47 -- cgit v1.2.3