ALTER TABLE `rq_foundations` ADD `mode` TINYINT NOT NULL DEFAULT '0' AFTER `uri`;

ALTER TABLE `rq_dictations` ADD `mode` TINYINT NOT NULL DEFAULT '0' AFTER `uri`;


CREATE TABLE `rq_dictations_rocket_state` (
  `dictation_id` int(11) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `rocket_name` varchar(255) NOT NULL,
  `rocket_place` float NOT NULL DEFAULT '0',
  `rocket_ranking` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `rq_foundations_rocket_state` (
  `foundation_id` int(11) DEFAULT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `rocket_name` varchar(255) NOT NULL,
  `rocket_place` float NOT NULL DEFAULT '0',
  `rocket_ranking` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
