diff options
| author | Keramat Jokar <keramatjokar8855@gmail.com> | 2023-09-30 18:11:03 +0330 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-09-30 16:41:03 +0200 |
| commit | 5b4b1892b43e6aec3afb32691d743761f77fdba8 (patch) | |
| tree | 5af2c0d924804bfd361f40d6624674188c57912e /sql/base/characters_database.sql | |
| parent | 2de255bc1789b78113dca03004e7acdc8d6983f6 (diff) | |
Core/Players: Implement mastery and versatility in character_stats (#29342)
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index fe1e468a9c1..3a6b0614ae9 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1693,6 +1693,8 @@ CREATE TABLE `character_stats` ( `rangedAttackPower` int unsigned NOT NULL DEFAULT '0', `spellPower` int unsigned NOT NULL DEFAULT '0', `resilience` int unsigned NOT NULL DEFAULT '0', + `mastery` float NOT NULL DEFAULT '0', + `versatility` int NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3711,7 +3713,8 @@ INSERT INTO `updates` VALUES ('2023_05_19_00_characters.sql','5E0C9338554BAA481566EDFF3FE2FCEFF1B67DA9','ARCHIVED','2023-05-19 18:40:42',0), ('2023_07_14_00_characters.sql','BB44A95A9C4B0C16878A5316AC38E702A8AACDE2','ARCHIVED','2023-07-14 08:24:44',0), ('2023_08_26_00_characters.sql','FA50838609AB5E645FB2DCAC970BD5706F9EFAAF','RELEASED','2023-08-26 12:18:22',0), -('2023_09_14_00_characters.sql','DAC56929C724C2971A4476400F2439CBDFAF3C5C','RELEASED','2023-09-13 22:20:22',0); +('2023_09_14_00_characters.sql','DAC56929C724C2971A4476400F2439CBDFAF3C5C','RELEASED','2023-09-13 22:20:22',0), +('2023_09_30_00_characters.sql','4326C642870633873F163085D278DB9B7449D9C3','RELEASED','2023-09-30 16:34:19',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |