ALTER TABLE creatureloot DROP heroicpercentchance;
ALTER TABLE creatureloot DROP mincount;
ALTER TABLE creatureloot DROP maxcount;

ALTER TABLE fishingloot DROP heroicpercentchance;
ALTER TABLE fishingloot DROP mincount;
ALTER TABLE fishingloot DROP maxcount;

ALTER TABLE itemloot DROP heroicpercentchance;
ALTER TABLE itemloot DROP mincount;
ALTER TABLE itemloot DROP maxcount;

ALTER TABLE objectloot DROP heroicpercentchance;
ALTER TABLE objectloot DROP mincount;
ALTER TABLE objectloot DROP maxcount;

ALTER TABLE pickpocketingloot DROP heroicpercentchance;
ALTER TABLE pickpocketingloot DROP mincount;
ALTER TABLE pickpocketingloot DROP maxcount;

ALTER TABLE prospectingloot DROP heroicpercentchance;
ALTER TABLE prospectingloot DROP mincount;
ALTER TABLE prospectingloot DROP maxcount;

ALTER TABLE skinningloot DROP heroicpercentchance;
ALTER TABLE skinningloot DROP mincount;
ALTER TABLE skinningloot DROP maxcount;


ALTER TABLE creatureloot MODIFY column percentchance float(0) NOT NULL default 0;

ALTER TABLE fishingloot MODIFY column percentchance float(0) NOT NULL default 0;

ALTER TABLE itemloot MODIFY column percentchance float(0) NOT NULL default 0;

ALTER TABLE objectloot MODIFY column percentchance float(0) NOT NULL default 0;

ALTER TABLE pickpocketingloot MODIFY column percentchance float(0) NOT NULL default 0;

ALTER TABLE prospectingloot MODIFY column percentchance float(0) NOT NULL default 0;

ALTER TABLE skinningloot MODIFY column percentchance float(0) NOT NULL default 0;

alter table creatureloot add column heroicpercentchance float(0) default 0;
alter table creatureloot add column mincount int(30) default 1;
alter table creatureloot add column maxcount int(30) default 1;

alter table fishingloot add column heroicpercentchance float(0) default 0;
alter table fishingloot add column mincount int(30) default 1;
alter table fishingloot add column maxcount int(30) default 1;

alter table objectloot add column heroicpercentchance float(0) default 0;
alter table objectloot add column mincount int(30) default 1;
alter table objectloot add column maxcount int(30) default 1;

alter table itemloot add column heroicpercentchance float(0) default 0;
alter table itemloot add column mincount int(30) default 1;
alter table itemloot add column maxcount int(30) default 1;

alter table prospectingloot add column heroicpercentchance float(0) default 0;
alter table prospectingloot add column mincount int(30) default 1;
alter table prospectingloot add column maxcount int(30) default 1;

alter table pickpocketingloot add column heroicpercentchance float(0) default 0;
alter table pickpocketingloot add column mincount int(30) default 1;
alter table pickpocketingloot add column maxcount int(30) default 1;

alter table skinningloot add column heroicpercentchance float(0) default 0;
alter table skinningloot add column mincount int(30) default 1;
alter table skinningloot add column maxcount int(30) default 1;