-- -----------------------------------------------------
-- Most occuring risks changed from top5 to top20
-- -----------------------------------------------------

ALTER TABLE sod_dashboard_topfiverisks 
CHANGE COLUMN `risk0` `risk0` INT(11) NOT NULL DEFAULT '-1' ,
CHANGE COLUMN `risk1` `risk1` INT(11) NOT NULL DEFAULT '-1' ,
CHANGE COLUMN `risk2` `risk2` INT(11) NOT NULL DEFAULT '-1' ,
CHANGE COLUMN `risk3` `risk3` INT(11) NOT NULL DEFAULT '-1' ,
CHANGE COLUMN `risk4` `risk4` INT(11) NOT NULL DEFAULT '-1' ,
ADD COLUMN `risk5` INT NOT NULL DEFAULT '-1' AFTER `count4`,
ADD COLUMN `count5` INT NOT NULL DEFAULT '0' AFTER `risk5`,
ADD COLUMN `risk6` INT NOT NULL DEFAULT '-1' AFTER `count5`,
ADD COLUMN `count6` INT NOT NULL DEFAULT '0' AFTER `risk6`,
ADD COLUMN `risk7` INT NOT NULL DEFAULT '-1' AFTER `count6`,
ADD COLUMN `count7` INT NOT NULL DEFAULT '0' AFTER `risk7`,
ADD COLUMN `risk8` INT NOT NULL DEFAULT '-1' AFTER `count7`,
ADD COLUMN `count8` INT NOT NULL DEFAULT '0' AFTER `risk8`,
ADD COLUMN `risk9` INT NOT NULL DEFAULT '-1' AFTER `count8`,
ADD COLUMN `count9` INT NOT NULL DEFAULT '0' AFTER `risk9`,
ADD COLUMN `risk10` INT NOT NULL DEFAULT '-1' AFTER `count9`,
ADD COLUMN `count10` INT NOT NULL DEFAULT '0' AFTER `risk10`,
ADD COLUMN `risk11` INT NOT NULL DEFAULT '-1' AFTER `count10`,
ADD COLUMN `count11` INT NOT NULL DEFAULT '0' AFTER `risk11`,
ADD COLUMN `risk12` INT NOT NULL DEFAULT '-1' AFTER `count11`,
ADD COLUMN `count12` INT NOT NULL DEFAULT '0' AFTER `risk12`,
ADD COLUMN `risk13` INT NOT NULL DEFAULT '-1' AFTER `count12`,
ADD COLUMN `count13` INT NOT NULL DEFAULT '0' AFTER `risk13`,
ADD COLUMN `risk14` INT NOT NULL DEFAULT '-1' AFTER `count13`,
ADD COLUMN `count14` INT NOT NULL DEFAULT '0' AFTER `risk14`,
ADD COLUMN `risk15` INT NOT NULL DEFAULT '-1' AFTER `count14`,
ADD COLUMN `count15` INT NOT NULL DEFAULT '0' AFTER `risk15`,
ADD COLUMN `risk16` INT NOT NULL DEFAULT '-1' AFTER `count15`,
ADD COLUMN `count16` INT NOT NULL DEFAULT '0' AFTER `risk16`,
ADD COLUMN `risk17` INT NOT NULL DEFAULT '-1' AFTER `count16`,
ADD COLUMN `count17` INT NOT NULL DEFAULT '0' AFTER `risk17`,
ADD COLUMN `risk18` INT NOT NULL DEFAULT '-1' AFTER `count17`,
ADD COLUMN `count18` INT NOT NULL DEFAULT '0' AFTER `risk18`,
ADD COLUMN `risk19` INT NOT NULL DEFAULT '-1' AFTER `count18`,
ADD COLUMN `count19` INT NOT NULL DEFAULT '0' AFTER `risk19`;