aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2018-02-04 00:11:10 +0100
committerShauren <shauren.trinity@gmail.com>2018-02-18 16:33:27 +0100
commitc9465979c6002ae43bb8e536e3ad0f6d1be36b98 (patch)
tree14b8e3b7e728659e4aceea529f74a3a5b904bc24 /sql/updates
parentc0abcc838be68f340f8276e6ba2c430276779b5b (diff)
Core/Entities: Update updatefields to 7.3.5.25928
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/characters/master/2018_02_03_00_characters.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/characters/master/2018_02_03_00_characters.sql b/sql/updates/characters/master/2018_02_03_00_characters.sql
new file mode 100644
index 00000000000..846a5978394
--- /dev/null
+++ b/sql/updates/characters/master/2018_02_03_00_characters.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `characters` ADD `inventorySlots` tinyint(3) unsigned NOT NULL DEFAULT '16' AFTER `customDisplay3`;
+
+UPDATE `character_inventory` SET `slot`=`slot`+8 WHERE `slot`>=39 AND `bag`=0;