mirror of
https://github.com/araxiaonline/OneDB.git
synced 2026-06-13 03:02:22 -04:00
74 lines
4.9 KiB
SQL
74 lines
4.9 KiB
SQL
/*
|
|
Update unicode conversion for all tables.
|
|
*/
|
|
|
|
ALTER TABLE `ai_agents` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `ai_threattospellid` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `auctionhouse` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `battlemasters` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_difficulty` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_formations` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_properties` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_quest_finisher` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_quest_starter` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_spawns` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_timed_emotes` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_waypoints` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `creature_waypoints_manual` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `display_bounding_boxes` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `event_scripts` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `fishing` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gameobject_properties` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gameobject_quest_finisher` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gameobject_quest_item_binding` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gameobject_quest_pickup_binding` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gameobject_quest_starter` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gameobject_spawns` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gameobject_teleports` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `gossip_menu_option` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `graveyards` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `instance_bosses` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `item_pages` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `item_quest_association` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `item_randomsuffix_groups` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `locales_gossip_menu_option` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `locales_worldmap_info` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `locales_worldstring_table` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `loot_creatures` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `loot_fishing` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `loot_gameobjects` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `loot_items` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `loot_pickpocketing` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `loot_skinning` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `npc_gossip_textid` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `npc_text` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `petdefaultspells` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `playercreateinfo` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `playercreateinfo_bars` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `playercreateinfo_items` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `playercreateinfo_skills` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `playercreateinfo_spells` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `points_of_interest` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `quest_properties` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `reputation_creature_onkill` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `reputation_faction_onkill` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `reputation_instance_onkill` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `spell_disable` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `spell_disable_trainers` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `spell_effects_override` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `spell_teleport_coords` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `spellclickspells` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `spelloverride` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `spelltargetconstraints` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `vehicle_accessories` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `vendor_restrictions` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `vendors` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `wordfilter_character_names` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `wordfilter_chat` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `world_db_version` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `worldmap_info` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `worldstate_templates` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `zoneguards` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
ALTER TABLE `world_db_version` CHARSET=utf8 COLLATE utf8_unicode_ci;
|
|
|
|
INSERT INTO `world_db_version` VALUES ('33', '20180916-00_update_utf8'); |