-- This script fix username length in system tables allowing use User field > 16 chars.
-- Written by Konstantin A. Lepikhov <lakostis@altlinux.org>

-- On unix, you should use the mysql_fix_username_length script to execute
-- this sql script.
-- On windows you should do 'mysql --force mysql < mysql_fix_username_length.sql'

ALTER TABLE db MODIFY User char(@USERNAME_LENGTH@) binary DEFAULT '' NOT NULL;
ALTER TABLE user MODIFY User char(@USERNAME_LENGTH@) binary DEFAULT '' NOT NULL;
ALTER TABLE tables_priv MODIFY User char(@USERNAME_LENGTH@) binary DEFAULT '' NOT NULL;
ALTER TABLE columns_priv MODIFY User char(@USERNAME_LENGTH@) binary DEFAULT '' NOT NULL;
ALTER TABLE procs_priv MODIFY User char(@USERNAME_LENGTH@) binary DEFAULT '' NOT NULL;