-- 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`);