aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2024-08-26 15:02:22 +0200
committerOvahlord <dreadkiller@gmx.de>2024-08-27 17:20:43 +0200
commit18ae1540b53072c5fe10eaa80d96fed3a2e2c9a2 (patch)
tree52e3aa4ad56cdbd908fec5c9b4d239eacbf4df9d /sql/updates/characters
parenta3c66fe0b870f9ccb0225d307b2b190a60d5c0ef (diff)
Core/Loot: Implemented currency loot
(cherry picked from commit 3e28ee080a1cf3c7cd332a8d1e0808505b4ea9d4) # Conflicts: # sql/base/characters_database.sql # sql/updates/auth/cata_classic/2024_08_26_00_characters.sql # sql/updates/world/cata_classic/2024_08_26_00_world.sql # src/server/game/Entities/Player/Player.cpp # src/server/game/Loot/Loot.cpp # src/server/scripts/ExilesReach/zone_exiles_reach.cpp
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/cata_classic/2024_08_27_00_characters_2024_08_26_00_characters.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/characters/cata_classic/2024_08_27_00_characters_2024_08_26_00_characters.sql b/sql/updates/characters/cata_classic/2024_08_27_00_characters_2024_08_26_00_characters.sql
new file mode 100644
index 00000000000..dedde7070ec
--- /dev/null
+++ b/sql/updates/characters/cata_classic/2024_08_27_00_characters_2024_08_26_00_characters.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `item_loot_items` ADD `item_type` tinyint NOT NULL DEFAULT 0 COMMENT 'item or currency' AFTER `container_id`;
+ALTER TABLE `item_loot_items` DROP PRIMARY KEY;
+ALTER TABLE `item_loot_items` ADD PRIMARY KEY (`container_id`,`item_type`,`item_id`);