-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Dim 30 Mars 2008 à 17:27
-- Version du serveur: 5.0.45
-- Version de PHP: 5.2.5


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

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

--
-- Structure de la table `informatique`
--

CREATE TABLE `informatique` (
  `id` tinyint(5) NOT NULL,
  `Fiche_CB` varchar(30) default NULL,
  `Champ_Salle` varchar(20) default NULL,
  `Intervenant` varchar(40) default NULL,
  `Station_N` varchar(6) default NULL,
  `Ordi_M` varchar(30) default NULL,
  `Ordi_T` varchar(30) default NULL,
  `Ordi_Mo` varchar(25) default NULL,
  `Ordi_CB` varchar(30) default NULL,
  `Ecran_M` varchar(30) default NULL,
  `Ecran_T` varchar(30) default NULL,
  `Ecran_Mo` varchar(25) default NULL,
  `Ecran_CB` varchar(30) default NULL,
  `Clav_M` varchar(30) default NULL,
  `Clav_T` varchar(30) default NULL,
  `Clav_Mo` varchar(25) default NULL,
  `Clav_CB` varchar(30) default NULL,
  `Sour_M` varchar(30) default NULL,
  `Sour_T` varchar(30) default NULL,
  `Sour_Mo` varchar(30) default NULL,
  `Sour_CB` varchar(25) default NULL,
  `Web_Cam_M` varchar(30) default NULL,
  `Web_Cam_T` varchar(30) default NULL,
  `Web_Cam_Mo` varchar(25) default NULL,
  `Web_Cam_CB` varchar(30) default NULL,
  `Imp_M` varchar(30) default NULL,
  `Imp_T` varchar(30) default NULL,
  `Imp_Mo` varchar(25) default NULL,
  `Imp_CB` varchar(30) default NULL,
  `Scanner_M` varchar(30) default NULL,
  `Scanner_T` varchar(30) default NULL,
  `Scanner_Mo` varchar(25) default NULL,
  `Scanner_CB` varchar(30) default NULL,
  `OS` varchar(25) default NULL,
  `N_OS` varchar(30) default NULL,
  `Ip_Classe` varchar(10) default NULL,
  `Ip_VLan` varchar(5) default NULL,
  `Ip_Poste` varchar(6) default NULL,
  `Ip_Station` varchar(20) default NULL,
  `Baie` varchar(12) default NULL,
  `N_Prise_Infor1` varchar(12) default NULL,
  `Capa_Video` varchar(12) default NULL,
  `Capa_HD` varchar(12) default NULL,
  `Capa_Ram` varchar(12) default NULL,
  `Unite_Ram_HD` varchar(12) default NULL,
  `Unite_Ram_Video` varchar(12) default NULL,
  `Unite_Ram_Mem` varchar(12) default NULL,
  `Type_HD` varchar(12) default NULL,
  `Media` varchar(5) default NULL,
  `Region_UC` varchar(30) default NULL,
  `Region_Ecran` varchar(30) default NULL,
  `Fonction` varchar(20) default NULL,
  `Status` varchar(20) default NULL,
  `Observation` text,
  `Date_Mise_Service` varchar(12) default NULL,
  `Date_Mise_Jour` varchar(12) default NULL,
  `hit` int(5) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Contenu de la table `informatique`
--

INSERT INTO `informatique` (`id`, `Fiche_CB`, `Champ_Salle`, `Intervenant`, `Station_N`, `Ordi_M`, `Ordi_T`, `Ordi_Mo`, `Ordi_CB`, `Ecran_M`, `Ecran_T`, `Ecran_Mo`, `Ecran_CB`, `Clav_M`, `Clav_T`, `Clav_Mo`, `Clav_CB`, `Sour_M`, `Sour_T`, `Sour_Mo`, `Sour_CB`, `Web_Cam_M`, `Web_Cam_T`, `Web_Cam_Mo`, `Web_Cam_CB`, `Imp_M`, `Imp_T`, `Imp_Mo`, `Imp_CB`, `Scanner_M`, `Scanner_T`, `Scanner_Mo`, `Scanner_CB`, `OS`, `N_OS`, `Ip_Classe`, `Ip_VLan`, `Ip_Poste`, `Ip_Station`, `Baie`, `N_Prise_Infor1`, `Capa_Video`, `Capa_HD`, `Capa_Ram`, `Unite_Ram_HD`, `Unite_Ram_Video`, `Unite_Ram_Mem`, `Type_HD`, `Media`, `Region_UC`, `Region_Ecran`, `Fonction`, `Status`, `Observation`, `Date_Mise_Service`, `Date_Mise_Jour`, `hit`) VALUES
(1, 'C15.000001', 'C15', 'Mr  Roger  Dubray', '17', 'Nec', 'GX32', '', '3700046231433', 'Nec', '19_pouses_plat', '', '3700046231433', 'Nec', 'En USB', '', '3700046231433', 'Nec', 'PS2 avec optique', '3700046231433', '', 'Nec', '', '', '3700046231433', 'Epson', 'Epl2600N', '', '3700046231433', 'Autre', 'Canon', '', '3700046231433', 'Win 2003 Serveur Standard', '719785529', '192.168.', '8', '200', '192.168.8.200', 'I-B3-', '703', '256', '250', '1024', 'GO', 'MO', 'MO', 'Sata', '', '3700046234274', '3700046231433', 'Serveur Web', 'En service', 'imprimer une page est une fonction.\r\nroger\r\ndubray\r\ntoto\r\ntutu\r\ntonton																																																																		', '25/06/2007', '07/07/2007', 0),
(2, 'C12.000002', 'C12', 'Mr  Roger  Dubray', '24', 'Dell', '', '', '', 'Belinea', '', '', '', 'Dell', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Win 2000 Serveur', '', '192.168.', '27.', '200', '192.168.27..200', '', '', '', '', '', '', '', 'MO', '', '', '', '', 'Station', 'En service', '														', '25/06/2007', '26/03/2008', 0),
(4, 'C12.000004', 'C12', 'Mr  Roger  Dubray', '25', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '28', '28', '192.168.28.28', '', '', '', '', '', '', '', '', '', NULL, '3700046234274', '3700046233055', '', '', '												', '', '08/07/2007', 0),
(5, 'C12.000005', 'C12', '    ', '18', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '', '', '', '.', '', '', '', '', '', '', '', '', '', NULL, '3700046233055', '3700046233055', '', '', '														', '', '08/07/2007', 0),
(6, 'C12.000006', 'C12', '    ', '26', '', '', '', '', 'Autre', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '', '', '', '.', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '						', '', '08/07/2007', 0),
(12, 'C.D.I..000012', 'C.D.I.', 'Mr  Roger  Dubray', '1', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '27', '255', '192.168.27.255', 'I-B3-', '703', '', '', '', '', '', '', '', NULL, '', '', '', '', '						', '', '11/07/2007', 0),
(13, 'C15.000013', 'C15', 'Mr  Roger  Dubray', '15', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '27', '204', '192.168.27.204', 'I-B3-', '702', '', '', '', '', '', '', '', NULL, '', '', '', '', '				', '', '11/07/2007', 0),
(14, 'C15.000014', 'C15', 'Mr  Roger  Dubray', '', 'Dell', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '', '', '', '', 'I-B3-', '654', '', '', '', '', '', '', '', NULL, '', '', '', '', '														', '', '11/07/2007', 0),
(17, 'C10.000017', 'C10', 'Mr  Roger  Dubray', '29', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '28', '27', '192.168.28.27', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '												', '', '11/07/2007', 0),
(18, 'C15.000018', 'C15', 'Mr  Roger  Dubray', '200', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '28', '28', '192.168.28.28', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '										', '25/07/2002', '11/07/2007', 0),
(19, 'C14.000019', 'C14', '    ', '203', 'Dell', 'VL2', '', '719785529', 'Nec', '19_pouses_plat', NULL, '719785529', 'Dell', 'En', NULL, '719785529', 'Dell', 'USB avec optique', '719785529', NULL, 'Dell', '540', NULL, '719785529', 'Dell', 'Epl2600N', NULL, '719785529', 'Dell', '', NULL, '719785529', 'Win 2003 Serveur Standard', '719785529', '192.168.', '255', '255', '192.168.255.255', 'I-B3-', '451', '512', '250', '2048', 'GO', 'MO', 'MO', 'Sata', NULL, '719785529', '719785529', '', '', '719785529\r\n																																				', '25/06/2007', '11/07/2007', 0),
(20, 'Gestionnaire.000020', 'Gestionnaire', '    ', '1', 'Dell', '', '', '719785529', 'Nec', '', NULL, '719785529', '\r\n', '', NULL, '719785529', '\r\n', '', '719785529', NULL, '\r\n', '', NULL, '719785529', '\r\n', '', NULL, '719785529', '\r\n', '', NULL, '719785529', 'Win Xp Pro', '719785529', '10.72.', '13', '255', '10.72.13.255', 'I-B1-', '119', '128', '80', '1024', 'GO', 'MO', 'MO', 'IDE', NULL, '719785529', '719785529', '', '', '719785529\r\nordinateur assemblé.\r\n\r\n																																																						', '25/07/2002', '11/07/2007', 0),
(21, 'Proviseur.000021', 'Proviseur', 'Mr  Roger  Dubray', '27', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '10.72.', '13', '255', '10.72.13.255', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '		', '', '11/07/2007', 0),
(22, 'Proviseur.000022', 'Proviseur', '    ', '255', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '255', '255', '192.168.255.255', '', '', '', '', '', '', '', '', '', NULL, '3700046233055', '3700046233055', '', '', '												', '', '11/07/2007', 0),
(23, 'Gestionnaire.000023', 'Gestionnaire', '    ', '27', 'Dell', '', '', '', 'Dell', '', NULL, '', 'Dell', '', NULL, '', 'Dell\r\n', '', '', NULL, 'Dell', '', NULL, '', 'Epson', '', NULL, '', 'Dell', '', NULL, '', '', '', '192.168.', '28', '26', '192.168.28.26', 'I-B1-', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '				', '', '02/11/2007', 0),
(24, 'C12.000024', 'C12', '    ', '14', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '4', '6', '192.168.4.6', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '						', '', '10/11/2007', 0),
(25, 'C12.000025', 'C12', '    ', '16', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', '', NULL, '', '', '', '192.168.', '4', '3', '192.168.4.3', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '', '				', '', '10/11/2007', 0),
(26, 'Sport.000026', 'Sport', 'Mr  Roger  Dubray', '29', 'Dell', 'VL2', '', '3700046233055', 'Dell', '19 pouces plat', NULL, '3700046233055', 'Dell', 'PS2', NULL, '3700046233055', 'Dell', 'USB avec optique', '3700046233055', NULL, 'Dell', '540', NULL, '3700046233055', 'Epson', 'Epl2600N', NULL, '3700046233055', 'Nec', 'Epl-5200', NULL, '3700046233055', 'Win 2003 Serveur', '3700046233055', '192.168.', '10', '29', '192.168.10.29', 'I-B3-', '701', '1024', '500', '1024', 'GO', 'MO', 'GO', 'Sata', NULL, '3700046233055', '3700046233055', 'Serveur Backup', 'Réformé', 'sssssssssssssssssssss\r\ntoto\r\ntiti\r\nantoine\r\ndubray																															', '2007-11-01', '10/12/2007', 0),
(27, 'I03.000027', 'I03', 'Mr  Roger  Dubray', '29', 'Bull', 'Assembleur', '', '', 'Belinea', '19 pouces plat', '', '', 'Bull', '', '', '', 'Bull', '', '', '', 'Bull', '', '', '', '', '', '', '', '', '', '', '', 'Windows 98 SE', '', '192.168.', '29', '29', '192.168.29.29', 'I-B3-', '450', '', '', '', '', '', '', '', '', '', '', 'Serveur Backup', 'En Panne', '												', '2007-11-01', '25/03/2008', 0),
(28, 'Cuisine.000028', 'Cuisine', 'Mr  Roger  Dubray', '1', 'Compaq', 'Assembleur', 'Tour', '3700046231440', 'Compaq', 'VL2', '19 pouces plat', '3700046231440', 'Compaq', 'PS2', 'PS2', '3700046231440', 'Compaq', 'USB avec optique', 'USB avec optique', '3700046231440', 'Philips', 'Assembleur', 'USB', '3700046231440', 'Epson', 'Epl-5200', 'Réseau', '3700046231440', 'Canon', 'PS2', 'SCSI', '3700046231440', 'Windows 2000 Pro', '3700046231440', '10.72.', '13', '138', '10.72.13.138', 'I-B1-', '125', '128', '260', '1024', 'GO', 'MO', 'MO', 'Sata', 'DVDRW', '3700046231440', '3700046231440', 'Station', 'En service', 'Poste pour le cuisinier\r\nPoste pour le personnel																																														', '2002-09-02', '12/02/2008', 0),
(29, 'C2_Admin.000029', 'C2_Admin', 'Mr  Roger  Dubray', '1', '', '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', NULL, '', '', NULL, '', '', '', NULL, '', '', 'USB', NULL, '', '', '', '192.168.', '2', '18', '192.168.2.18', '', '', '', '', '', '', '', '', '', NULL, '', '', 'Serveur Data', 'En service', '				', '2007-11-01', '09/02/2008', 0),
(30, 'C10.000030', 'C10', 'Mr  Roger  Dubray', '1', 'Dell', 'VL2', 'Tour', '3700046231440', 'Belinea', 'VL2', '15 pouces tube', '3700046231440', 'Dell', 'VL2', 'PS2', '3700046231440', 'Dell', 'VL2', 'USB avec optique', '3700046231440', 'Logitech', 'USB', 'USB', '3700046231440', 'Brother', 'USB', 'Local', '3700046231440', 'Canon', 'USB', 'USB', '3700046231440', 'Win Xp Familiale', '3700046231440', '192.168.', '4', '28', '192.168.4.28', 'I-B2-', '21', '128', '20', '1024', 'GO', 'MO', 'MO', 'IDE', 'CDR', '3700046231440', '3700046231440', 'Station', 'En service', 'Fiche pour test.\r\nSalle C10 																																				', '2007-11-01', '09/02/2008', 0),
(31, 'C15.000031', 'C15', 'Mr  Roger  Dubray', '3', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '192.168.', '4', '8', '192.168.4.8', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '		', '', '24/03/2008', 0),
(32, 'I03.000032', 'I03', 'Mr  Roger  Dubray', '1', 'Dell', 'Assembleur', '', '', 'Belinea', '19 pouces plat', '', '', 'Dell', '', '', '', 'Dell', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '192.168.', '8', '10', '192.168.8.10', 'I-B3-', '', '', '', '', '', '', '', '', '', '', '', 'Station', 'Réformé', '		', '01-07-2007', '25/03/2008', 0),
(33, 'C12.000033', 'C12', 'Mr  Roger  Dubray', '4', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '192.168.', '4', '15', '192.168.4.15', 'I-B2-', '', '', '', '', '', '', '', '', '', '', '', 'Station', 'En service', '		', '01-09-2002', '26/03/2008', 0);
