diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-09-18 22:15:46 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-09-18 23:52:17 +0200 |
| commit | f67cd38312014b13624dcb5fe1d117dac4892b7d (patch) | |
| tree | 3bf01a8798005e8017b672867edb5c8379f76087 /sql | |
| parent | e15898bf560fc8159777a2a29a29d6a91ffdb590 (diff) | |
Core/Player: Extend action button value to uint64 to be able to hold battle pet guids
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2022_09_18_00_characters.sql | 1 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 822e9bcb0e0..743da3345dc 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -459,7 +459,7 @@ CREATE TABLE `character_action` ( `guid` bigint unsigned NOT NULL DEFAULT '0', `spec` tinyint unsigned NOT NULL DEFAULT '0', `button` tinyint unsigned NOT NULL DEFAULT '0', - `action` int unsigned NOT NULL DEFAULT '0', + `action` bigint unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spec`,`button`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3676,7 +3676,8 @@ INSERT INTO `updates` VALUES ('2022_07_14_00_characters.sql','2EAD57D77FC39F6678F2D2A7D9C24046E6B836D8','ARCHIVED','2022-07-14 21:44:35',0), ('2022_07_25_00_characters.sql','3159BB2F3C346A7881920AB2B1F8108247CF13EE','ARCHIVED','2022-07-25 18:44:10',0), ('2022_08_19_00_characters.sql','1C076A24F2B48F32E8EF835C01F8907CA9E86491','ARCHIVED','2022-08-19 23:43:01',0), -('2022_08_21_00_characters.sql','1D75688392FBDA18CD8494F32CF682DCB49642EC','ARCHIVED','2022-08-21 00:02:03',0); +('2022_08_21_00_characters.sql','1D75688392FBDA18CD8494F32CF682DCB49642EC','ARCHIVED','2022-08-21 00:02:03',0), +('2022_09_18_00_characters.sql','A7DF0C1F0E074F3E63A6CDD0AF873A1F3DC33B29','RELEASED','2022-09-18 21:48:42',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2022_09_18_00_characters.sql b/sql/updates/characters/master/2022_09_18_00_characters.sql new file mode 100644 index 00000000000..c87d83fa1f6 --- /dev/null +++ b/sql/updates/characters/master/2022_09_18_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `character_action` MODIFY `action` bigint unsigned NOT NULL DEFAULT 0; |