diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-07-30 18:34:39 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-07-30 18:34:39 +0100 |
| commit | 940f655a3c61c80e9823855df1fbc4630a698926 (patch) | |
| tree | 7a74c41d8d05437c13dc5050833516d4ab43961e /sql | |
| parent | 3df10d8273dda4a2cf98f5b300f6c4132730dd7f (diff) | |
Core/VS: Allow to store/retrive random stats items in void storage
Also set items to soulbound on withdraw
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/characters/2012_07_30_01_world_void_storage_434.sql | 2 |
2 files changed, 5 insertions, 1 deletions
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 diff --git a/sql/updates/characters/2012_07_30_01_world_void_storage_434.sql b/sql/updates/characters/2012_07_30_01_world_void_storage_434.sql new file mode 100644 index 00000000000..cd2cb0f0b9e --- /dev/null +++ b/sql/updates/characters/2012_07_30_01_world_void_storage_434.sql @@ -0,0 +1,2 @@ +ALTER TABLE `void_storage` ADD `randomProperty` int(10) unsigned NOT NULL DEFAULT '0'; +ALTER TABLE `void_storage` ADD `suffixFactor` int(10) unsigned NOT NULL DEFAULT '0'; |