1 ALTER TABLE `playercreateinfo_reputation`
2 ADD `race` tinyint(3) unsigned NOT NULL default '0' FIRST,
3 ADD `class` tinyint(3) unsigned NOT NULL default '0' AFTER `race`;
5 UPDATE `playercreateinfo_reputation`,`playercreateinfo`
6 SET `playercreateinfo_reputation`.`race` = `playercreateinfo`.`race`,
7 `playercreateinfo_reputation`.`class` = `playercreateinfo`.`class`
8 WHERE `playercreateinfo_reputation`.`createid` = `playercreateinfo`.`createid`;
10 ALTER TABLE `playercreateinfo_reputation`
11 DROP KEY `playercreateinfo_reputation_index`,
13 ADD KEY `playercreateinfo_race_class_index` (`race`,`class`);