CREATE TABLE IF NOT EXISTS `votes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(100) NOT NULL,
  `BodyCode` char(4) NOT NULL,
  `proposal_id` int(11) NOT NULL,
  `type` char(16),
  `submit_date` datetime,
  `vote` char(16),
  
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `amendments` ADD `session_type` VARCHAR( 16 ) NULL AFTER `proposer_uid`;

ALTER TABLE `proposals_management` ADD `summary` TEXT NULL;

ALTER TABLE `voting_delegates` CHANGE `BodyCode` `bodyCode` CHAR( 3 )

