-- phpMyAdmin SQL Dump-- version 2.8.0.3-- http://www.phpmyadmin.net-- -- Serveur: waldo.dawsoncollege.qc.ca-- Généré le : Jeudi 08 Février 2007 à 18:19-- Version du serveur: 5.0.18-- Version de PHP: 4.4.4-- -- Base de données: `music0705`-- -- ---------------------------------------------------------- -- Structure de la table `survey_options`-- CREATE TABLE `survey_options` ( `survey_option_id` int(7) NOT NULL auto_increment, `survey_id` int(6) NOT NULL, `selection_number` int(2) NOT NULL default '0', `text` text NOT NULL, PRIMARY KEY (`survey_option_id`), KEY `survey_options_k1` (`survey_id`,`selection_number`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='list of all the options of each survey' AUTO_INCREMENT=2 ;-- -- Contenu de la table `survey_options`-- INSERT INTO `survey_options` (`survey_option_id`, `survey_id`, `selection_number`, `text`) VALUES (1, 1, 1, 'Pop');-- ---------------------------------------------------------- -- Structure de la table `survey_votes`-- CREATE TABLE `survey_votes` ( `user_id` int(11) NOT NULL, `survey_id` int(6) NOT NULL, `selection_number` int(2) NOT NULL, PRIMARY KEY (`user_id`,`survey_id`), KEY `survey_answers_k1` (`survey_id`,`selection_number`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of all the answers made by users for surveys';-- -- Contenu de la table `survey_votes`-- -- ---------------------------------------------------------- -- Structure de la table `surveys`-- CREATE TABLE `surveys` ( `survey_id` int(6) NOT NULL auto_increment, `title` text NOT NULL, PRIMARY KEY (`survey_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='List of all the surveys' AUTO_INCREMENT=3 ;-- -- Contenu de la table `surveys`-- INSERT INTO `surveys` (`survey_id`, `title`) VALUES (1, 'What category of music do you prefer ?'),(2, 'How old are you ?');-- -- Contraintes pour les tables exportées-- -- -- Contraintes pour la table `survey_options`-- ALTER TABLE `survey_options` ADD CONSTRAINT `survey_options_c1` FOREIGN KEY (`survey_id`) REFERENCES `surveys` (`survey_id`);-- -- Contraintes pour la table `survey_votes`-- ALTER TABLE `survey_votes` ADD CONSTRAINT `survey_answers_c1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`), ADD CONSTRAINT `survey_answers_c2` FOREIGN KEY (`survey_id`, `selection_number`) REFERENCES `survey_options` (`survey_id`, `selection_number`);