1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
--
-- Structure de la table `musique`
--
CREATE TABLE IF NOT EXISTS `musique` (
`idMusique` int(11) NOT NULL auto_increment,
`nomMusique` varchar(100) collate latin1_general_ci NOT NULL,
`nomArtiste` varchar(100) collate latin1_general_ci NOT NULL,
`nomAlbum` varchar(100) collate latin1_general_ci NOT NULL,
`genre` varchar(100) collate latin1_general_ci NOT NULL,
`cheminAcces` varchar(100) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`idMusique`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;
--
-- Contenu de la table `musique`
--
INSERT INTO `musique` (`idMusique`, `nomMusique`, `nomArtiste`, `nomAlbum`, `genre`, `cheminAcces`) VALUES
(1, 'The Hell Song', 'Sum 41', 'Does This Look Infected', 'Alternative & Punk', 'musiques/The Hell Song.mp3'),
(2, 'Dance, Dance', 'Fall Out Boy', 'Believers Never Die', 'Pop Rock', ''),
(3, 'Bad Romance', 'Lady Gaga', 'The Fame Monster', 'Pop', ''); |