From 65aee484b90794c06ac84fb3b32aa29aaea9f192 Mon Sep 17 00:00:00 2001 From: funjoker Date: Sun, 7 Nov 2021 19:50:55 +0100 Subject: Misc: Rename db2 fields to official name --- sql/updates/hotfixes/master/2021_11_07_11_hotfixes.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/hotfixes/master/2021_11_07_11_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2021_11_07_11_hotfixes.sql b/sql/updates/hotfixes/master/2021_11_07_11_hotfixes.sql new file mode 100644 index 00000000000..6b45fad9839 --- /dev/null +++ b/sql/updates/hotfixes/master/2021_11_07_11_hotfixes.sql @@ -0,0 +1,3 @@ +ALTER TABLE `chr_races` CHANGE COLUMN `NameS` `LoreName` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `NameFemaleLowercase`, CHANGE COLUMN `NameFemaleS` `LoreNameFemale` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreName`, CHANGE COLUMN `NameLowercaseS` `LoreNameLower` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreNameFemale`, CHANGE COLUMN `NameFemaleLowercaseS` `LoreNameLowerFemale` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreNameLower`, CHANGE COLUMN `RaceFantasyDescription` `LoreDescription` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreNameLowerFemale`, CHANGE COLUMN `NameL` `ShortName` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `LoreDescription`, CHANGE COLUMN `NameFemaleL` `ShortNameFemale` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `ShortName`, CHANGE COLUMN `NameLowercaseL` `ShortNameLower` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `ShortNameFemale`, CHANGE COLUMN `NameFemaleLowercaseL` `ShortNameLowerFemale` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci' AFTER `ShortNameLower`; + +ALTER TABLE `chr_classes` CHANGE COLUMN `ChatColorR` `ClassColorR` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `SpellClassSet`, CHANGE COLUMN `ChatColorG` `ClassColorG` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `ClassColorR`, CHANGE COLUMN `ChatColorB` `ClassColorB` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' AFTER `ClassColorG`; -- cgit v1.2.3