diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/3.4.x/2023_11_16_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 4301dc48420..60b002e6a79 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -460,7 +460,7 @@ CREATE TABLE `character_action` ( `spec` tinyint unsigned NOT NULL DEFAULT '0', `traitConfigId` int NOT NULL DEFAULT '0', `button` tinyint unsigned NOT NULL DEFAULT '0', - `action` bigint unsigned NOT NULL DEFAULT '0', + `action` int unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`spec`,`traitConfigId`,`button`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3722,7 +3722,8 @@ INSERT INTO `updates` VALUES ('2023_09_30_00_characters.sql','4326C642870633873F163085D278DB9B7449D9C3','ARCHIVED','2023-09-30 16:34:19',0), ('2023_10_06_00_characters.sql','FFAFF1F0916BB9DC58345466E0BB1A15A4611836','ARCHIVED','2023-10-06 00:40:46',0), ('2023_11_02_00_characters.sql','1A76A843F204901C8598DA5682029E815477E427','RELEASED','2023-11-02 18:59:41',0), -('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','RELEASED','2023-11-09 00:56:31',0); +('2023_11_09_00_characters.sql','1A3D7CA6890353DA55793FE8D925CC8C54965A69','RELEASED','2023-11-09 00:56:31',0), +('2023_11_16_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2023-11-16 10:29:32',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/3.4.x/2023_11_16_00_characters.sql b/sql/updates/characters/3.4.x/2023_11_16_00_characters.sql new file mode 100644 index 00000000000..f770c867236 --- /dev/null +++ b/sql/updates/characters/3.4.x/2023_11_16_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `character_action` MODIFY `action` int unsigned NOT NULL DEFAULT 0; |