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

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

--
-- Structure de la table `reference`
--

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

--
-- Contenu de la table `reference`
--

INSERT INTO `reference` (`coderef`, `libelleref`, `codedesign`) VALUES
(1, 'PH LaserJet 1102', 1),
(2, 'LEXMARK E232', 1),
(3, 'HP LASERJET 1505', 1),
(4, 'HP LASERJET 1320', 1),
(5, 'HP DX 2400', 4),
(6, 'HP DX 2401', 4),
(7, 'HP DX 5700', 4),
(8, 'HP PROBOOK 4320', 2),
(9, 'ASTRAL', 8),
(10, 'HP LASER 1706', 1),
(11, 'HP V 185 WS', 1),
(12, 'HP 2300', 1),
(13, 'CDMA', 3),
(14, 'GATEWAY', 4),
(15, 'DELL VESTRO', 9),
(16, 'HP 5100', 4),
(17, 'HP DX 2420', 4),
(18, 'DELL OPTIPLEX', 4),
(19, 'HP DX 2200', 4),
(20, 'HP 2000 MT ', 4),
(21, 'HP 7100', 4),
(22, 'HP EVO 5100', 4),
(23, 'HP PRO 3400', 2),
(24, 'ACER F1', 4),
(25, 'DELL OPTIPLEX 270', 4),
(26, 'ADSL', 3),
(27, 'VSAT HN 7000S', 3),
(28, 'IBM', 10),
(29, 'HP COMPAQ', 10),
(30, 'HP 1320', 1),
(31, 'HP 2035', 1),
(32, 'DELL 5200', 1),
(33, 'HP 4015', 1),
(34, 'HP 4250', 1),
(35, 'HP 1566', 1);

/*!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 */;