 -- http://www.phpmyadmin.net
 --
 -- Serveur: localhost
--- Généré le : Mar 07 Mai 2013 à 02:20
+-- Généré le : Jeu 23 Mai 2013 à 22:27
 -- Version du serveur: 5.1.66
 -- Version de PHP: 5.3.24-1~dotdeb.0
 

  `is_correct` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_DADD4A251E27F6BF` (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Contenu de la table `answer`
--


-- --------------------------------------------------------


-- Contraintes pour la table `quizz_result`
--
ALTER TABLE `quizz_result`
  ADD CONSTRAINT `FK_4995E702A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_4995E702BA934BCD` FOREIGN KEY (`quizz_id`) REFERENCES `quizz` (`id`);

--
-- Contraintes pour la table `user_answer`
--
ALTER TABLE `user_answer`
  ADD CONSTRAINT `FK_BF8F5118A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_BF8F5118AA334807` FOREIGN KEY (`answer_id`) REFERENCES `answer` (`id`) ON DELETE CASCADE;
