CREATE TABLE IF NOT EXISTS `rollcalls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creator_uid` varchar(100) NOT NULL,
  `agora_id` smallint NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` varchar(1000),
  `submit_date` datetime,
  `result` varchar(16),
  `bodies_present` varchar(16),
  `votes_in_favour` varchar(16),
  `votes_against` varchar(16),
  `votes_abstention` varchar(16),
  `open` datetime,
  `close` datetime,

  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `proposals_management` 
ADD  `open` datetime,
ADD `close` datetime;
