diff options
| author | funjoker <funjoker109@gmail.com> | 2021-11-07 19:50:55 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2021-11-07 19:50:55 +0100 |
| commit | 65aee484b90794c06ac84fb3b32aa29aaea9f192 (patch) | |
| tree | 0951213e9734794d04b5078d666695aea002d204 /sql/updates | |
| parent | 732a8ee26199d7f04c692fa64f96955db13cf69d (diff) | |
Misc: Rename db2 fields to official name
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/hotfixes/master/2021_11_07_11_hotfixes.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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`; |