-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
-- --------------------------------------------------------

--
-- Structure de la table `disques`
--

CREATE TABLE IF NOT EXISTS `disques` (
  `id_disque` int(5) NOT NULL AUTO_INCREMENT,
  `nom_disque` varchar(40) NOT NULL,
  `auteur_disque` varchar(40) NOT NULL,
  `note_disque` int(2) NOT NULL,
  `date_disque` date DEFAULT NULL,
  PRIMARY KEY (`id_disque`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Contenu de la table `disques`
--

INSERT INTO `disques` (`id_disque`, `nom_disque`, `auteur_disque`, `note_disque`, `date_disque`) VALUES
(1, 'Highway to hell', 'ACDC', 5, '1979-05-01'),
(2, 'Back in black', 'ACDC', 5, '1980-04-10'),
(3, 'Stiff Upper Lip', 'ACDC', 4, '2000-03-04'),
(4, 'Black Ice', 'ACDC', 2, '2008-08-05'),
(5, 'Their Satanic Majesties Request', 'Rolling Stones', 4, '1967-01-10'),
(6, 'Beggars Banquet', 'Rolling Stones', 4, '1968-04-12'),
(7, 'Kill ''Em All', 'Metallica', 5, '1986-01-24'),
(8, 'The wall', 'Pink Floyd', 5, '1979-11-30');

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

--
-- Structure de la table `disques_ventes`
--

CREATE TABLE IF NOT EXISTS `disques_ventes` (
  `id_disque_vente` int(5) NOT NULL AUTO_INCREMENT,
  `id_disque_fk` int(5) NOT NULL,
  `ventes` varchar(10) CHARACTER SET latin1 NOT NULL,
  `commentaire` text CHARACTER SET latin1,
  PRIMARY KEY (`id_disque_vente`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `disques_ventes`
--

INSERT INTO `disques_ventes` (`id_disque_vente`, `id_disque_fk`, `ventes`, `commentaire`) VALUES
(1, 1, '1000000', NULL),
(2, 8, '50000000', NULL),
(3, 2000, '4000', 'Pas de disque avec id_disque 2000');

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

--
-- Structure de la table `notes`
--

CREATE TABLE IF NOT EXISTS `notes` (
  `id_note` int(5) NOT NULL AUTO_INCREMENT,
  `id_disque_fk` int(5) NOT NULL,
  `note` int(1) NOT NULL,
  `id_appreciations_fk` text NOT NULL,
  `com` text,
  PRIMARY KEY (`id_note`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


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

--
-- Structure de la table `notes_appreciations`
--

CREATE TABLE IF NOT EXISTS `notes_appreciations` (
  `id_note_appreciation` int(5) NOT NULL AUTO_INCREMENT,
  `appreciation` varchar(80) NOT NULL,
  PRIMARY KEY (`id_note_appreciation`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `notes_appreciations`
--

INSERT INTO `notes_appreciations` (`id_note_appreciation`, `appreciation`) VALUES
(1, 'A REVOLUTIONNE LA MUSIQUE'),
(2, 'DEBUT DIFFICILE'),
(3, 'EST DEVENU UN GROUPE MYTIQUE'),
(4, 'N''A PAS EU UN GRAND SUCCES');
