1 ALTER TABLE db_version CHANGE COLUMN required_8749_01_mangos_mail_loot_template required_8769_01_mangos_mail_level_reward bit;
3 DROP TABLE IF EXISTS `mail_level_reward`;
4 CREATE TABLE `mail_level_reward` (
5 `level` tinyint(3) unsigned NOT NULL default '0',
6 `raceMask` mediumint(8) unsigned NOT NULL default '0',
7 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
8 `senderEntry` mediumint(8) unsigned NOT NULL default '0',
9 PRIMARY KEY (`level`,`raceMask`)
10 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Mail System';