1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
| CREATE TABLE `webradio_fichiers` (
`id` int(11) NOT NULL,
`path` varchar(512) NOT NULL,
`dossier` varchar(255) NOT NULL,
`fichier` varchar(255) NOT NULL,
`titre` varchar(100) NOT NULL,
`artiste` varchar(100) NOT NULL,
`album` varchar(100) NOT NULL,
`annee` int(10) NOT NULL,
`commentaire` varchar(100) NOT NULL,
`genre` varchar(100) NOT NULL,
`piste` int(10) NOT NULL,
`duree` int(10) NOT NULL,
`duree2` varchar(20) NOT NULL,
`coupe` int(11) NOT NULL,
`nbre` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
--
-- Déchargement des données de la table `webradio_fichiers`
--
INSERT INTO `webradio_fichiers` (`id`, `path`, `dossier`, `fichier`, `titre`, `artiste`, `album`, `annee`, `commentaire`, `genre`, `piste`, `duree`, `duree2`, `coupe`, `nbre`) VALUES
(1, '.%2Ffichiers_audio%2Fsingle/Ain%27t%20No%20Sunshine.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(2, '.%2Ffichiers_audio%2Fsingle/Boyfriend.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(3, '.%2Ffichiers_audio%2Fsingle/Breakfast.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(4, '.%2Ffichiers_audio%2Fsingle/City%20of%20Stars.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(5, '.%2Ffichiers_audio%2Fsingle/Comptine%20d%27un%20autre%20%C3%A9t%C3%A9%2C%20l%27apr%C3%A8s-midi.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(6, '.%2Ffichiers_audio%2Fsingle/Cover%20Me%20In%20Sunshine.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(7, '.%2Ffichiers_audio%2Fsingle/DESPECH%C3%81.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(8, '.%2Ffichiers_audio%2Fsingle/Des%20sauvages.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(9, '.%2Ffichiers_audio%2Fsingle/Et%20dans%20150%20Ans.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(10, '.%2Ffichiers_audio%2Fsingle/Hakuna%20Matata.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(11, '.%2Ffichiers_audio%2Fsingle/Hit%20the%20Road%20Jack.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(12, '.%2Ffichiers_audio%2Fsingle/I%20Ain%27t%20Worried.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(13, '.%2Ffichiers_audio%2Fsingle/I%27ve%20never%20been%20there.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(14, '.%2Ffichiers_audio%2Fsingle/Il%20suffirait%20de%20presque%20rien%20%28Isabelle%20Boulay%29.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(15, '.%2Ffichiers_audio%2Fsingle/Il%20suffirait%20de%20presque%20rien.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(16, '.%2Ffichiers_audio%2Fsingle/J%27aime%20les%20gars.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(17, '.%2Ffichiers_audio%2Fsingle/J%27veux%20du%20soleil.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(18, '.%2Ffichiers_audio%2Fsingle/L%27Operap.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(19, '.%2Ffichiers_audio%2Fsingle/La%20valse%20d%27Am%C3%A9lie%20%28version%20orchestre%29.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(20, '.%2Ffichiers_audio%2Fsingle/La%20valse%20d%27Am%C3%A9lie%202.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(21, '.%2Ffichiers_audio%2Fsingle/Laisse%20aller.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(22, '.%2Ffichiers_audio%2Fsingle/Le%20temps%20ne%20fait%20rien%20%C3%A0%20l%27affaire.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(23, '.%2Ffichiers_audio%2Fsingle/Les%20limites.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(24, '.%2Ffichiers_audio%2Fsingle/Ma%20Libert%C3%A9.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(25, '.%2Ffichiers_audio%2Fsingle/Maniac.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(26, '.%2Ffichiers_audio%2Fsingle/Pas%20assez%20de%20toi.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(27, '.%2Ffichiers_audio%2Fsingle/Respect.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(28, '.%2Ffichiers_audio%2Fsingle/Soledad.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(29, '.%2Ffichiers_audio%2Fsingle/Stay.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(30, '.%2Ffichiers_audio%2Fsingle/Stayin%27%20Alive.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(31, '.%2Ffichiers_audio%2Fsingle/Supercalifragilistic.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(32, '.%2Ffichiers_audio%2Fsingle/Sweet%20Dreams%20Seven%20Nation%20Army%20Mashup.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(33, '.%2Ffichiers_audio%2Fsingle/The%20Diva%20Dance.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(34, '.%2Ffichiers_audio%2Fsingle/Theme%20The%20Pink%20Panther.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(35, '.%2Ffichiers_audio%2Fsingle/Un%20homme.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(36, '.%2Ffichiers_audio%2Fsingle/Une%20chanson%20douce.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(37, '.%2Ffichiers_audio%2Fsingle/Une%20petite%20fille.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(38, '.%2Ffichiers_audio%2Fsingle/Une%20%C3%A2me%20de%20po%C3%A8te.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(39, '.%2Ffichiers_audio%2Fsingle/Wellerman.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(40, '.%2Ffichiers_audio%2Fsingle/Where%20are%20you%20now.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(41, '.%2Ffichiers_audio%2Fsingle/Yesterday.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(42, '.%2Ffichiers_audio%2Fsingle/theme%20Game%20of%20Thrones.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(43, '.%2Ffichiers_audio%2Fsingle/theme%20Interstellar.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(44, '.%2Ffichiers_audio%2Fsingle/theme%20Twin%20Peaks.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(45, '.%2Ffichiers_audio%2Fsingle/theme%20Westworld.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(46, '.%2Ffichiers_audio%2Fsingle/%C3%A7a%20balance%20pas%20mal%20%C3%A0%20Paris.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(47, '.%2Ffichiers_audio%2Fsingle/Ton%20visage.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(48, '.%2Ffichiers_audio%2Fsingle/Inspecteur%20Gadget.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(49, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/01%20-%20Downtown%20%28Downtempo%29.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(50, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/01%20-%20J%27aime%20les%20gars.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(51, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/01%20-%20Over%20the%20Rainbow.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(52, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/01%20-%20Somewhere%20Only%20We%20Know.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(53, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/01%20-%20Sweet%20Dreams%20Seven%20Nation%20Army%20Mashup.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(54, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/02%20-%20Allez%20leur%20dire.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(55, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/03%20-%20Cannonball.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(56, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/03%20-%20Comptine%20d%27un%20autre%20%C3%A9t%C3%A9%2C%20l%27apr%C3%A8s-midi.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(57, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/11%20-%20The%20Sound%20of%20Silence.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0),
(58, '.%2Ffichiers_audio%2Fmusiques%20achet%C3%A9es/15%20-%20What%20A%20Wonderful%20World.mp3', '', '', '', '', '', 0, '', '', 0, 0, '', 0, 0); |
Partager