diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/characters/master/2023_09_14_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 5e75e1c5b69..fe1e468a9c1 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2286,7 +2286,7 @@ CREATE TABLE `groups` ( `icon6` binary(16) NOT NULL, `icon7` binary(16) NOT NULL, `icon8` binary(16) NOT NULL, - `groupType` tinyint unsigned NOT NULL, + `groupType` smallint unsigned NOT NULL, `difficulty` tinyint unsigned NOT NULL DEFAULT '1', `raidDifficulty` tinyint unsigned NOT NULL DEFAULT '14', `legacyRaidDifficulty` tinyint unsigned NOT NULL DEFAULT '3', @@ -3710,7 +3710,8 @@ INSERT INTO `updates` VALUES ('2023_05_04_00_characters.sql','9AC370E51507F5BD368707E90D8F6BF0FF16CA09','ARCHIVED','2023-05-04 16:17:31',0), ('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_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); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/master/2023_09_14_00_characters.sql b/sql/updates/characters/master/2023_09_14_00_characters.sql new file mode 100644 index 00000000000..9c8709cbb1d --- /dev/null +++ b/sql/updates/characters/master/2023_09_14_00_characters.sql @@ -0,0 +1 @@ +ALTER TABLE `groups` MODIFY `groupType` smallint unsigned NOT NULL AFTER `icon8`; |