
-- Base de données: `test22`
--

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

--
-- Structure de la table `designation`
--

CREATE TABLE IF NOT EXISTS `designation` (
  `codedesign` int(11) NOT NULL AUTO_INCREMENT,
  `libelledesign` varchar(50) NOT NULL,
  PRIMARY KEY (`codedesign`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Contenu de la table `designation`
--

INSERT INTO `designation` (`codedesign`, `libelledesign`) VALUES
(1, 'Imprimante'),
(2, 'Ordinateur Portable'),
(3, 'Modem'),
(4, 'Unité Centrale'),
(5, 'Ecran'),
(6, 'Clavier'),
(7, 'Souris'),
(8, 'Téléphone'),
(9, 'Station Compléte'),
(10, 'SERVEUR');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
