Sql Structure Update

[kounelos]

Hello guys i am using Julianx's Repack V3 wich is a great pack btw and i wanna update my sql structure so i can use the latest ascent core..is there any sql patch to do this? I am using MySQL 5 + navicat and i found a sql fix

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;

but i cant get this to work for me...

[MentaL]

[kounelos]

Sorry guys i finaly did this and this is the fixes file for the rest with the same problem

fixes.sql