CREATE TABLE IF NOT EXISTS `result` (
  `result_id` int(31) NOT NULL auto_increment,
  `result_student_id` varchar(20) NOT NULL,
  `result_student_name` varchar(255) NOT NULL,
  `result_score` int(11) NOT NULL,
  `result_datetime` datetime NOT NULL,
  `result_date` date NOT NULL,
  `result_hour` int(11) NOT NULL,
  `result_ms` int(11) NOT NULL,
  `result_status` varchar(255) NOT NULL,
  `result_masteryscore` int(11) NOT NULL,
  `result_totaltime` int(31) NOT NULL,
  `result_attempts` int(11) NOT NULL,
  `result_package_name` varchar(255) NOT NULL,
  `result_package_id` int(11) NOT NULL,
  `result_author_name` varchar(255) NOT NULL,
  `result_author_id` int(11) NOT NULL,
  `result_exercise_name` varchar(255) NOT NULL,
  `result_exercise_id` int(11) NOT NULL,
  `result_course_name` varchar(255) NOT NULL,
  `result_course_id` int(11) NOT NULL,
  `result_organization_name` varchar(255) NOT NULL,
  `result_organization_id` int(11) NOT NULL,
  `result_organization_content_name` varchar(255) NOT NULL,
  `result_organization_content_id` int(11) NOT NULL,
  `result_spg_hostname` varchar(255),
  `result_created` int(32) NOT NULL,
  `result_url` varchar(255) NOT NULL,
  PRIMARY KEY (`result_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `transition` (
  `transition_id` int(31) NOT NULL auto_increment,
  `transition_exercise_uniqueid` VARCHAR(80) NOT NULL,
  `transition_resource` VARCHAR(255) NOT NULL,
  `transition_variables` TEXT NOT NULL,
  `transition_answer` TEXT,
  `transition_previous_interaction` INT(11),
  `transition_previous_interaction_name` VARCHAR(80),
  `transition_chosen_answer_map` INT(11),
  `transition_chosen_answer_map_name` VARCHAR(80),
  `transition_datetime` datetime,
  PRIMARY KEY (`transition_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;