[sql fix][7938] characters.account column type

[charlie2025]

Format of column in realmd.account is bigint(20) , but in characters.account , but column account is the same value (number, identifier.. what you want) as id in account table and is "only" int(11). So if case, id in account.id will be bigger then character creation and pointing characters to account gets bugged.

Fix to set characters.account as bigint(20)

ALTER TABLE `characters`.`characters` MODIFY `account`
bigint(20) unsigned NOT NULL default '0' COMMENT 'Account Identifier';

or, if you thing that 4294967295 is enough, set account.id as int(11)

ALTER TABLE `realmd`.`account` MODIFY `id`
int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier';

[VladimirMangos]

Second way added in to [7938]. Thank you