CREATE TABLE IF NOT EXISTS `coursemanager_questions_courses_specified` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `questionId` int(11) NOT NULL,
  `courseId` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `coursemanager_courses` MODIFY `objectives` text NOT NULL;
ALTER TABLE `coursemanager_lessons` MODIFY `objectives` text NOT NULL;

ALTER TABLE `coursemanager_questions` 
ADD COLUMN `answersCorrect` INT(11) NOT NULL DEFAULT 0 AFTER `updated`,
ADD COLUMN `answersFailed` INT(11) NOT NULL DEFAULT 0 AFTER `answersCorrect`;

CREATE TABLE IF NOT EXISTS `coursemanager_questions_resources` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `questionId` int(11) NOT NULL,
  `resourceId` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;