--
-- Structure de la table `instrument`
--

CREATE TABLE IF NOT EXISTS `instrument` (
  `codeInstrument` int(10) NOT NULL,
  `designation` varchar(20) NOT NULL,
  `codeCat` varchar(20) NOT NULL,
  `codeStudio` varchar(20) NOT NULL,
  PRIMARY KEY (`codeInstrument`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `instrument`
--

INSERT INTO `instrument` (`codeInstrument`, `designation`, `codeCat`, `codeStudio`) VALUES
(1, 'ampli Fender combo', 'A', 'B6'),
(2, 'Peavey 100W', 'B', 'B6'),
(3, 'Ampli Basse', 'A', 'A1');

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

--
-- Structure de la table `resa`
--

CREATE TABLE IF NOT EXISTS `resa` (
  `codeStudio` varchar(10) NOT NULL,
  `Date` date NOT NULL,
  `nbJours` int(10) NOT NULL,
  PRIMARY KEY (`codeStudio`,`Date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `resa`
--


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

--
-- Structure de la table `studio`
--

CREATE TABLE IF NOT EXISTS `studio` (
  `codeStudio` varchar(20) NOT NULL,
  `nomStudio` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`codeStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `studio`
--

INSERT INTO `studio` (`codeStudio`, `nomStudio`, `description`) VALUES
('B5', 'La scene', 'Pour preparation tournée'),
('B6', 'Stud3', '30m², Marshall, Bat Pearl'),
('A1', 'Grand', 'Standard + cuivres ou choeurs');

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

--
-- Structure de la table `tarif`
--

CREATE TABLE IF NOT EXISTS `tarif` (
  `codeCat` varchar(20) NOT NULL,
  `libCat` varchar(20) NOT NULL,
  `tarifJour` int(10) NOT NULL,
  PRIMARY KEY (`codeCat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `tarif`
--

INSERT INTO `tarif` (`codeCat`, `libCat`, `tarifJour`) VALUES
('A', 'Standard', 25),
('B', 'Indermediaire', 20),
('C', 'economique', 15);
