UPDATE
ALTER TABLE realmcharacters DROP INDEX acctid;
ALTER TABLE realmcharacters ADD KEY (acctid);


UPDATE
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `mail_external`;

CREATE TABLE `mail_external` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `receiver` BIGINT(20) UNSIGNED NOT NULL,
  `subject` VARCHAR(200) DEFAULT 'Support Message',
  `message` VARCHAR(500) DEFAULT 'Support Message',
  `money` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `item` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  `item_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


SET FOREIGN_KEY_CHECKS = 1;


UPDATE
ALTER TABLE realmlist
  ADD COLUMN realmbuilds VARCHAR(64) NOT NULL DEFAULT '' AFTER population;


ALTER TABLE realmlist
  CHANGE COLUMN color realmflags tinyint(3) UNSIGNED NOT NULL DEFAULT '2'
  COMMENT 'Supported masks: 0x1 (invalid, not show in realm list), 0x2 (offline, set by mangosd), 0x4 (show version and build), 0x20 (new players), 0x40 (recommended)';

UPDATE realmlist
  SET realmflags = realmflags & ~(0x01 | 0x04 | 0x20 | 0x40) ;

UPDATE realmlist
  SET realmflags = realmflags | 0x02;