ALTER TABLE `rankedvote` 
ADD `bodies_available` SMALLINT , 
ADD `bodies_voted` SMALLINT, 
ADD `votes_available` SMALLINT, 
ADD `votes_cast` SMALLINT;

ALTER TABLE `polls` 
ADD `bodies_available` SMALLINT , 
ADD `bodies_voted` SMALLINT, 
ADD `votes_available` SMALLINT, 
ADD `votes_cast` SMALLINT;

ALTER TABLE `rankedvoteballots` 
CHANGE `body` `bodyCode` CHAR(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;