1 ALTER TABLE `loot_template`
2 CHANGE `itemid` `item` int(11) unsigned NOT NULL default '0' ,
3 CHANGE `percentchance` `chance` float NOT NULL default '100' ,
4 DROP KEY `i_creature_loot_creatureid` ,
5 DROP KEY `creatureloot_index` ,
6 ADD PRIMARY KEY (`entry`,`item`) ;