-- ------------------------------------------------------- --
-- Differenciate between usernames in sod_legacy_violation
-- ------------------------------------------------------- --
ALTER TABLE `sod_legacy_violation` 
CHARACTER SET = 'utf8mb4', COLLATE = 'utf8mb4_unicode_ci',
CHANGE COLUMN `username` `username` VARCHAR(12) CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_bin' NOT NULL;
