From 5b4b1892b43e6aec3afb32691d743761f77fdba8 Mon Sep 17 00:00:00 2001 From: Keramat Jokar Date: Sat, 30 Sep 2023 18:11:03 +0330 Subject: Core/Players: Implement mastery and versatility in character_stats (#29342) --- sql/base/characters_database.sql | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'sql/base/characters_database.sql') 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; -- cgit v1.2.3