diff options
| author | Shauren <shauren.trinity@gmail.com> | 2018-02-04 00:11:10 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2018-02-18 16:33:27 +0100 |
| commit | c9465979c6002ae43bb8e536e3ad0f6d1be36b98 (patch) | |
| tree | 14b8e3b7e728659e4aceea529f74a3a5b904bc24 /sql | |
| parent | c0abcc838be68f340f8276e6ba2c430276779b5b (diff) | |
Core/Entities: Update updatefields to 7.3.5.25928
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/characters/master/2018_02_03_00_characters.sql | 3 |
2 files changed, 6 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 26e6da417c0..964dd61d6d0 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1645,6 +1645,7 @@ CREATE TABLE `characters` ( `customDisplay1` tinyint(3) unsigned NOT NULL DEFAULT '0', `customDisplay2` tinyint(3) unsigned NOT NULL DEFAULT '0', `customDisplay3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `inventorySlots` tinyint(3) unsigned NOT NULL DEFAULT '16', `bankSlots` tinyint(3) unsigned NOT NULL DEFAULT '0', `restState` tinyint(3) unsigned NOT NULL DEFAULT '0', `playerFlags` int(10) unsigned NOT NULL DEFAULT '0', @@ -3532,7 +3533,8 @@ INSERT INTO `updates` VALUES ('2017_06_04_00_characters.sql','BC80D2B7515CC6E01701070D2DA466727F36DB5E','ARCHIVED','2017-06-04 14:43:26',0), ('2017_08_20_00_characters.sql','8C5BBF6AEAA6C7DE2F40A7D3878C8187A4729F13','ARCHIVED','2017-08-20 17:00:00',0), ('2017_08_20_01_characters.sql','2F50D5E6BF3888B8C5270D79228A1D0601FAFF1D','ARCHIVED','2017-08-20 17:52:21',0), -('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25); +('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25), +('2018_02_03_00_characters.sql','73E9BFD848D7A22F2A7DD89CF64E30E3A8689512','RELEASED','2018-02-03 23:52:42', 0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; 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; |