Skip to content

Synchronized few database tables options with master x3 attempt #28441

@CraftedRO

Description

@CraftedRO

Description

Synchronized few database tables with master :
Setting default collate and charset utf8 over latin
Setting up default engine innodb for remained tables since myisam is deprecated.

However the base create auth and create characters sql files most likely need to be edited aswell.

SQL fix

-- auth
ALTER TABLE logs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT;
ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT;

-- characters
ALTER TABLE battleground_deserters CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE item_loot_items CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE item_loot_money CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE pvpstats_battlegrounds CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE pvpstats_players CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE quest_tracker CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE updates ENGINE=InnoDB ROW_FORMAT=DEFAULT;
ALTER TABLE updates_include ENGINE=InnoDB ROW_FORMAT=DEFAULT;

Branch

3.3.5

TC rev. hash/commit

69dda64

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions