CREATE TABLE `an_ResultAttemptSlide` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `attemptId` int(10) unsigned NOT NULL, `slideId` int(10) unsigned NOT NULL, `slideTitle` varchar(255) NOT NULL, `slideScore` decimal(10,2) NOT NULL DEFAULT 0, `added` datetime NOT NULL, PRIMARY KEY (`id`), KEY `attemptId` (`attemptId`), CONSTRAINT `an_ResultAttemptSlide_ibfk_1` FOREIGN KEY (`attemptId`) REFERENCES `an_ResultAttempt` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `an_ResultAttemptQuestion` ADD `attemptSlideId` int(10) unsigned NOT NULL AFTER `attemptId`;