diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-11-04 21:47:03 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-11-04 21:47:03 +0100 |
| commit | 5c8a058120dcf2c3ff8592886cb842ca889e0411 (patch) | |
| tree | 951397fd3cc69637d4c399510a725b9a3385a80d /sql | |
| parent | 792721ad6450065ec81da6472c1e2a143ad57341 (diff) | |
Core/PacketIO: 9.1.5 updatefields and SMSG_UPDATE_OBJECT structure
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2021_11_04_00_characters.sql | 2 |
2 files changed, 6 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 21d4ff0ae5c..da109df7c71 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1632,6 +1632,7 @@ CREATE TABLE `character_stats` ( `maxpower4` int(10) unsigned NOT NULL DEFAULT '0', `maxpower5` int(10) unsigned NOT NULL DEFAULT '0', `maxpower6` int(10) unsigned NOT NULL DEFAULT '0', + `maxpower7` int(10) unsigned NOT NULL DEFAULT '0', `strength` int(10) unsigned NOT NULL DEFAULT '0', `agility` int(10) unsigned NOT NULL DEFAULT '0', `stamina` int(10) unsigned NOT NULL DEFAULT '0', @@ -1843,6 +1844,7 @@ CREATE TABLE `characters` ( `power4` int(10) unsigned NOT NULL DEFAULT '0', `power5` int(10) unsigned NOT NULL DEFAULT '0', `power6` int(10) unsigned NOT NULL DEFAULT '0', + `power7` int(10) unsigned NOT NULL DEFAULT '0', `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0', `lootSpecId` int(10) unsigned NOT NULL DEFAULT '0', @@ -3670,7 +3672,8 @@ INSERT INTO `updates` VALUES ('2021_10_02_01_characters.sql','F97B956F3B5F909294CA399F75B5795A07C4D8EC','ARCHIVED','2021-10-02 21:47:38',0), ('2021_10_15_00_characters.sql','906FECD65CBA7C406969F45FDF28DDEF8AAF8715','ARCHIVED','2021-10-15 10:11:47',0), ('2021_10_16_00_characters.sql','B5A31BB6FBC34512767475EDF13099DEC948EBB7','RELEASED','2021-10-16 01:12:20',0), -('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','RELEASED','2021-11-02 18:11:13',0); +('2021_11_02_00_characters.sql','A3C0A6DA70CC70803C80685E4E2ED6255156520A','RELEASED','2021-11-02 18:11:13',0), +('2021_11_04_00_characters.sql','ED533235ADAD174F91A6B8E51D1046243B78B46D','RELEASED','2021-11-04 21:53:04',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2021_11_04_00_characters.sql b/sql/updates/characters/master/2021_11_04_00_characters.sql new file mode 100644 index 00000000000..e6db9872f42 --- /dev/null +++ b/sql/updates/characters/master/2021_11_04_00_characters.sql @@ -0,0 +1,2 @@ +ALTER TABLE `characters` ADD `power7` int(10) unsigned NOT NULL DEFAULT '0' AFTER `power6`; +ALTER TABLE `character_stats` ADD `maxpower7` int(10) unsigned NOT NULL DEFAULT '0' AFTER `maxpower6`; |