
# MySQL dump of database 'materiel' on host 'localhost'
# backup date and time: 26/03/2008 18:55:57
# built by phpMyBackupPro v.2.1
# http://www.phpMyBackupPro.net

CREATE DATABASE IF NOT EXISTS `computers`;

USE `computers`;


### structure of table `baie` ###


CREATE TABLE `baie` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `Class` varchar(20) NOT NULL default '',
  `Baie` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 AUTO_INCREMENT=9;


### data of table `baie` ###

insert into `baie` values ('1', '192.168.', 'I-B1-');
insert into `baie` values ('2', '172.16.', 'I-B2-');
insert into `baie` values ('3', '10.72.', 'I-B3-');


### structure of table `date_mise_service` ###


CREATE TABLE `date_mise_service` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `champ1` varchar(12) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7;


### data of table `date_mise_service` ###

insert into `date_mise_service` values ('1', '01-07-2007');
insert into `date_mise_service` values ('2', '01-09-2006');
insert into `date_mise_service` values ('3', '01-09-2002');
insert into `date_mise_service` values ('6', 'qqqaaa');
insert into `date_mise_service` values ('5', 'wwwwdd');


### structure of table `infor_marque` ###


CREATE TABLE `infor_marque` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `champ1` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1 AUTO_INCREMENT=25;


### data of table `infor_marque` ###

insert into `infor_marque` values ('4', 'Belinea');
insert into `infor_marque` values ('5', 'Brother');
insert into `infor_marque` values ('6', 'Bull');
insert into `infor_marque` values ('7', 'Canon');
insert into `infor_marque` values ('8', 'Compaq');
insert into `infor_marque` values ('9', 'Dell');
insert into `infor_marque` values ('10', 'Epson');
insert into `infor_marque` values ('11', 'HP');
insert into `infor_marque` values ('12', 'Hyundai');
insert into `infor_marque` values ('13', 'IBM');
insert into `infor_marque` values ('14', 'IIama');
insert into `infor_marque` values ('15', 'Logitech');
insert into `infor_marque` values ('16', 'LG');
insert into `infor_marque` values ('17', 'Lexmark');
insert into `infor_marque` values ('18', 'Microsoft');
insert into `infor_marque` values ('19', 'Nec');
insert into `infor_marque` values ('20', 'Oki');
insert into `infor_marque` values ('21', 'Philips');
insert into `infor_marque` values ('22', 'Zenith');
insert into `infor_marque` values ('23', 'Autre');
insert into `infor_marque` values ('24', 'Assembleur');


### structure of table `infor_modele` ###


CREATE TABLE `infor_modele` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `champ1` varchar(25) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=latin1 AUTO_INCREMENT=123;


### data of table `infor_modele` ###

insert into `infor_modele` values ('10', '-------- Ordinateur -----');
insert into `infor_modele` values ('11', 'Tour');
insert into `infor_modele` values ('12', 'Bureau');
insert into `infor_modele` values ('13', 'Portable');
insert into `infor_modele` values ('14', 'Client léger');
insert into `infor_modele` values ('30', '----------- Ecran -------');
insert into `infor_modele` values ('31', '15 pouces tube');
insert into `infor_modele` values ('32', '17 pouces tube');
insert into `infor_modele` values ('33', '19 pouces tube');
insert into `infor_modele` values ('34', '15 pouces plat');
insert into `infor_modele` values ('35', '17 pouces plat');
insert into `infor_modele` values ('36', '19 pouces plat');
insert into `infor_modele` values ('37', '22 pouces plat');
insert into `infor_modele` values ('50', '-------- Imprimante -----');
insert into `infor_modele` values ('51', 'Local');
insert into `infor_modele` values ('52', 'Réseau');
insert into `infor_modele` values ('53', 'Photo copieur');
insert into `infor_modele` values ('80', '---------- Clavier ------');
insert into `infor_modele` values ('81', 'PS2');
insert into `infor_modele` values ('82', 'USB');
insert into `infor_modele` values ('90', '---------- Souris -------');
insert into `infor_modele` values ('91', 'PS2 avec boule');
insert into `infor_modele` values ('92', 'PS2 avec optique');
insert into `infor_modele` values ('93', 'USB avec boule');
insert into `infor_modele` values ('94', 'USB avec optique');
insert into `infor_modele` values ('100', '--------- Scanner -------');
insert into `infor_modele` values ('101', 'SCSI');
insert into `infor_modele` values ('102', 'USB');
insert into `infor_modele` values ('120', '---------- WebCam -------');
insert into `infor_modele` values ('121', 'PS2');
insert into `infor_modele` values ('122', 'USB');


### structure of table `infor_type` ###


CREATE TABLE `infor_type` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `champ1` varchar(31) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=latin1 AUTO_INCREMENT=123;


### data of table `infor_type` ###

insert into `infor_type` values ('10', '-------- Ordinateur --------');
insert into `infor_type` values ('11', 'VL2');
insert into `infor_type` values ('12', 'VL4');
insert into `infor_type` values ('13', 'Assembleur');
insert into `infor_type` values ('30', '----------- Ecran ----------');
insert into `infor_type` values ('31', '15 pouces tube');
insert into `infor_type` values ('32', '17 pouces tube');
insert into `infor_type` values ('33', '19 pouces tube');
insert into `infor_type` values ('34', '15 pouces plat');
insert into `infor_type` values ('35', '17 pouces plat');
insert into `infor_type` values ('36', '19 pouces plat');
insert into `infor_type` values ('37', '22 pouces plat');
insert into `infor_type` values ('50', '-------- Imprimante --------');
insert into `infor_type` values ('51', 'C62');
insert into `infor_type` values ('52', 'C64');
insert into `infor_type` values ('53', '3650');
insert into `infor_type` values ('54', 'Epl-5200');
insert into `infor_type` values ('80', '---------- Clavier ---------');
insert into `infor_type` values ('81', 'PS2');
insert into `infor_type` values ('82', 'USB');
insert into `infor_type` values ('90', '---------- Souris ----------');
insert into `infor_type` values ('91', 'PS2 avec boule');
insert into `infor_type` values ('92', 'PS2 avec optique');
insert into `infor_type` values ('93', 'USB avec boule');
insert into `infor_type` values ('94', 'USB avec optique');
insert into `infor_type` values ('100', '--------- Scanner ---------');
insert into `infor_type` values ('101', 'PS2');
insert into `infor_type` values ('102', 'USB');
insert into `infor_type` values ('120', '---------- WebCam ---------');
insert into `infor_type` values ('121', 'PS2');
insert into `infor_type` values ('122', 'USB');


### structure of 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;


### data of table `informatique` ###

insert into `informatique` 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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('5', 'C12.000005', 'C12', '    ', '18', '', '', '', '', '', '', null, '', '', '', null, '', '', '', '', null, '', '', null, '', '', '', null, '', '', '', null, '', '', '', '', '', '', '.', '', '', '', '', '', '', '', '', '', null, '3700046233055', '3700046233055', '', '', '														', '', '08/07/2007', '0');
insert into `informatique` values ('6', 'C12.000006', 'C12', '    ', '26', '', '', '', '', 'Autre', '', null, '', '', '', null, '', '', '', '', null, '', '', null, '', '', '', null, '', '', '', null, '', '', '', '', '', '', '.', '', '', '', '', '', '', '', '', '', null, '', '', '', '', '						', '', '08/07/2007', '0');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('14', 'C15.000014', 'C15', 'Mr  Roger  Dubray', '', 'Dell', '', '', '', '', '', null, '', '', '', null, '', '', '', '', null, '', '', null, '', '', '', null, '', '', '', null, '', '', '', '', '', '', '', 'I-B3-', '654', '', '', '', '', '', '', '', null, '', '', '', '', '														', '', '11/07/2007', '0');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('24', 'C12.000024', 'C12', '    ', '14', '', '', '', '', '', '', null, '', '', '', null, '', '', '', '', null, '', '', null, '', '', '', null, '', '', '', null, '', '', '', '192.168.', '4', '6', '192.168.4.6', '', '', '', '', '', '', '', '', '', null, '', '', '', '', '						', '', '10/11/2007', '0');
insert into `informatique` values ('25', 'C12.000025', 'C12', '    ', '16', '', '', '', '', '', '', null, '', '', '', null, '', '', '', '', null, '', '', null, '', '', '', null, '', '', '', null, '', '', '', '192.168.', '4', '3', '192.168.4.3', '', '', '', '', '', '', '', '', '', null, '', '', '', '', '				', '', '10/11/2007', '0');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('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');
insert into `informatique` values ('31', 'C15.000031', 'C15', 'Mr  Roger  Dubray', '3', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '192.168.', '4', '8', '192.168.4.8', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '		', '', '24/03/2008', '0');
insert into `informatique` values ('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');
insert into `informatique` values ('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');


### structure of table `matiere` ###


CREATE TABLE `matiere` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `champ1` varchar(25) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 AUTO_INCREMENT=28;


### data of table `matiere` ###

insert into `matiere` values ('10', 'Allemand');
insert into `matiere` values ('11', 'Anglais');
insert into `matiere` values ('12', 'Espagnal');
insert into `matiere` values ('13', 'Francais');
insert into `matiere` values ('14', 'Philo');
insert into `matiere` values ('15', 'Math');
insert into `matiere` values ('16', 'Hist-Geo');
insert into `matiere` values ('17', 'Phys-Chimie');
insert into `matiere` values ('18', 'SVT');
insert into `matiere` values ('19', 'SMS');
insert into `matiere` values ('20', 'STT');
insert into `matiere` values ('21', 'BTS');
insert into `matiere` values ('22', 'Sport');
insert into `matiere` values ('23', 'Etud-Secon');
insert into `matiere` values ('24', 'Etud-Prem');
insert into `matiere` values ('25', 'Etud-Term');
insert into `matiere` values ('26', 'Administratif');
insert into `matiere` values ('27', 'Autre');


### structure of table `os` ###


CREATE TABLE `os` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `champ1` varchar(35) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 AUTO_INCREMENT=9;


### data of table `os` ###

insert into `os` values ('1', 'Windows 98 SE');
insert into `os` values ('2', 'Windows 2000 Pro');
insert into `os` values ('3', 'Win Xp Pro');
insert into `os` values ('4', 'Win Xp Familiale');
insert into `os` values ('5', 'Win 2003 Serveur');
insert into `os` values ('6', 'Vista');
insert into `os` values ('7', 'Linux');
insert into `os` values ('8', 'Novell 5');


### structure of table `salle` ###


CREATE TABLE `salle` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `champ1` varchar(25) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=latin1 AUTO_INCREMENT=88;


### data of table `salle` ###

insert into `salle` values ('19', 'C1_Prof');
insert into `salle` values ('20', 'C2_Admin');
insert into `salle` values ('21', 'C01');
insert into `salle` values ('22', 'C02');
insert into `salle` values ('23', 'C10');
insert into `salle` values ('24', 'C11');
insert into `salle` values ('25', 'C12');
insert into `salle` values ('26', 'C13');
insert into `salle` values ('27', 'C14');
insert into `salle` values ('28', 'C15');
insert into `salle` values ('29', 'C17');
insert into `salle` values ('30', 'E0_Prof');
insert into `salle` values ('31', 'E0_Labo');
insert into `salle` values ('32', 'E01');
insert into `salle` values ('33', 'E02');
insert into `salle` values ('34', 'E03');
insert into `salle` values ('35', 'E04');
insert into `salle` values ('36', 'E05');
insert into `salle` values ('37', 'E06');
insert into `salle` values ('38', 'E10');
insert into `salle` values ('39', 'E11');
insert into `salle` values ('40', 'E12');
insert into `salle` values ('41', 'E13');
insert into `salle` values ('42', 'E14');
insert into `salle` values ('43', 'E15');
insert into `salle` values ('44', 'E16');
insert into `salle` values ('45', 'Salle_CARTES');
insert into `salle` values ('46', 'E17');
insert into `salle` values ('47', 'E18');
insert into `salle` values ('48', 'F0');
insert into `salle` values ('49', 'F10');
insert into `salle` values ('50', 'MPI');
insert into `salle` values ('51', 'G0_Prof');
insert into `salle` values ('52', 'G0_Technicien');
insert into `salle` values ('53', 'G02');
insert into `salle` values ('54', 'G03');
insert into `salle` values ('55', 'G04');
insert into `salle` values ('56', 'G06-08');
insert into `salle` values ('57', 'G11');
insert into `salle` values ('58', 'G101');
insert into `salle` values ('59', 'G102');
insert into `salle` values ('60', 'G103');
insert into `salle` values ('61', 'G104');
insert into `salle` values ('62', 'G121');
insert into `salle` values ('63', 'G122-123');
insert into `salle` values ('64', 'G124');
insert into `salle` values ('65', 'G141');
insert into `salle` values ('66', 'G142-143');
insert into `salle` values ('67', 'G144');
insert into `salle` values ('68', 'I01_Prof');
insert into `salle` values ('69', 'I01');
insert into `salle` values ('70', 'I02');
insert into `salle` values ('71', 'I03');
insert into `salle` values ('72', 'I04');
insert into `salle` values ('73', 'Adjoint');
insert into `salle` values ('74', 'A_Sociale');
insert into `salle` values ('75', 'CDI');
insert into `salle` values ('76', 'CPE');
insert into `salle` values ('77', 'Cuisine');
insert into `salle` values ('78', 'Gestionnaire');
insert into `salle` values ('79', 'Infirmiere');
insert into `salle` values ('80', 'Intendance');
insert into `salle` values ('81', 'Permanence');
insert into `salle` values ('82', 'Proviseur');
insert into `salle` values ('83', 'Secret_Eleve');
insert into `salle` values ('84', 'Secret_Proviseur');
insert into `salle` values ('85', 'Sport');
insert into `salle` values ('86', 'Vie_Scolaire');
insert into `salle` values ('2', 'Toute_les_salles');


### structure of table `status` ###


CREATE TABLE `status` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `Fonction` varchar(20) NOT NULL default '',
  `Status` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 AUTO_INCREMENT=13;


### data of table `status` ###

insert into `status` values ('1', 'Station', 'En Panne');
insert into `status` values ('2', 'Serveur Data', 'En service');
insert into `status` values ('3', 'Proxi', 'HS');
insert into `status` values ('4', 'Par Feu', 'Réformé');
insert into `status` values ('5', 'Serveur Backup', '');
insert into `status` values ('6', 'Serveur Web', '');


### structure of table `vlan` ###


CREATE TABLE `vlan` (
  `id` int(3) NOT NULL,
  `champ1` char(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


### data of table `vlan` ###

insert into `vlan` values ('1', '1');
insert into `vlan` values ('2', '2');
insert into `vlan` values ('3', '3');
insert into `vlan` values ('4', '4');
insert into `vlan` values ('5', '5');
insert into `vlan` values ('6', '6');
insert into `vlan` values ('7', '7');
insert into `vlan` values ('8', '8');
insert into `vlan` values ('9', '9');
insert into `vlan` values ('10', '10');
insert into `vlan` values ('11', '11');
insert into `vlan` values ('12', '12');
insert into `vlan` values ('13', '13');
insert into `vlan` values ('14', '14');
insert into `vlan` values ('15', '15');
insert into `vlan` values ('16', '16');
insert into `vlan` values ('17', '17');
insert into `vlan` values ('18', '18');
insert into `vlan` values ('19', '19');
insert into `vlan` values ('20', '20');
insert into `vlan` values ('21', '21');
insert into `vlan` values ('22', '22');
insert into `vlan` values ('23', '23');
insert into `vlan` values ('24', '24');
insert into `vlan` values ('25', '25');
insert into `vlan` values ('26', '26');
insert into `vlan` values ('27', '27');
insert into `vlan` values ('28', '28');
insert into `vlan` values ('29', '29');
insert into `vlan` values ('30', '30');
insert into `vlan` values ('31', '31');
insert into `vlan` values ('32', '32');
insert into `vlan` values ('33', '33');
insert into `vlan` values ('34', '34');
insert into `vlan` values ('35', '35');
insert into `vlan` values ('36', '36');
insert into `vlan` values ('37', '37');
insert into `vlan` values ('38', '38');
insert into `vlan` values ('39', '39');
insert into `vlan` values ('40', '40');
insert into `vlan` values ('41', '41');
insert into `vlan` values ('42', '42');
insert into `vlan` values ('43', '43');
insert into `vlan` values ('44', '44');
insert into `vlan` values ('45', '45');
insert into `vlan` values ('46', '46');
insert into `vlan` values ('47', '47');
insert into `vlan` values ('48', '48');
insert into `vlan` values ('49', '49');
insert into `vlan` values ('50', '50');
insert into `vlan` values ('51', '51');
insert into `vlan` values ('52', '52');
insert into `vlan` values ('53', '53');
insert into `vlan` values ('54', '54');
insert into `vlan` values ('55', '55');
insert into `vlan` values ('56', '56');
insert into `vlan` values ('57', '57');
insert into `vlan` values ('58', '58');
insert into `vlan` values ('59', '59');
insert into `vlan` values ('60', '60');
insert into `vlan` values ('61', '61');
insert into `vlan` values ('62', '62');
insert into `vlan` values ('63', '63');
insert into `vlan` values ('64', '64');
insert into `vlan` values ('65', '65');
insert into `vlan` values ('66', '66');
insert into `vlan` values ('67', '67');
insert into `vlan` values ('68', '68');
insert into `vlan` values ('69', '69');
insert into `vlan` values ('70', '70');
insert into `vlan` values ('71', '71');
insert into `vlan` values ('72', '72');
insert into `vlan` values ('73', '73');
insert into `vlan` values ('74', '74');
insert into `vlan` values ('75', '75');
insert into `vlan` values ('76', '76');
insert into `vlan` values ('77', '77');
insert into `vlan` values ('78', '78');
insert into `vlan` values ('79', '79');
insert into `vlan` values ('80', '80');
insert into `vlan` values ('81', '81');
insert into `vlan` values ('82', '82');
insert into `vlan` values ('83', '83');
insert into `vlan` values ('84', '84');
insert into `vlan` values ('85', '85');
insert into `vlan` values ('86', '86');
insert into `vlan` values ('87', '87');
insert into `vlan` values ('88', '88');
insert into `vlan` values ('89', '89');
insert into `vlan` values ('90', '90');
insert into `vlan` values ('91', '91');
insert into `vlan` values ('92', '92');
insert into `vlan` values ('93', '93');
insert into `vlan` values ('94', '94');
insert into `vlan` values ('95', '95');
insert into `vlan` values ('96', '96');
insert into `vlan` values ('97', '97');
insert into `vlan` values ('98', '98');
insert into `vlan` values ('99', '99');
insert into `vlan` values ('100', '100');
insert into `vlan` values ('101', '101');
insert into `vlan` values ('102', '102');
insert into `vlan` values ('103', '103');
insert into `vlan` values ('104', '104');
insert into `vlan` values ('105', '105');
insert into `vlan` values ('106', '106');
insert into `vlan` values ('107', '107');
insert into `vlan` values ('108', '108');
insert into `vlan` values ('109', '109');
insert into `vlan` values ('110', '110');
insert into `vlan` values ('111', '111');
insert into `vlan` values ('112', '112');
insert into `vlan` values ('113', '113');
insert into `vlan` values ('114', '114');
insert into `vlan` values ('115', '115');
insert into `vlan` values ('116', '116');
insert into `vlan` values ('117', '117');
insert into `vlan` values ('118', '118');
insert into `vlan` values ('119', '119');
insert into `vlan` values ('120', '120');
insert into `vlan` values ('121', '121');
insert into `vlan` values ('122', '122');
insert into `vlan` values ('123', '123');
insert into `vlan` values ('124', '124');
insert into `vlan` values ('125', '125');
insert into `vlan` values ('126', '126');
insert into `vlan` values ('127', '127');
insert into `vlan` values ('128', '128');
insert into `vlan` values ('129', '129');
insert into `vlan` values ('130', '130');
insert into `vlan` values ('131', '131');
insert into `vlan` values ('132', '132');
insert into `vlan` values ('133', '133');
insert into `vlan` values ('134', '134');
insert into `vlan` values ('135', '135');
insert into `vlan` values ('136', '136');
insert into `vlan` values ('137', '137');
insert into `vlan` values ('138', '138');
insert into `vlan` values ('139', '139');
insert into `vlan` values ('140', '140');
insert into `vlan` values ('141', '141');
insert into `vlan` values ('142', '142');
insert into `vlan` values ('143', '143');
insert into `vlan` values ('144', '144');
insert into `vlan` values ('145', '145');
insert into `vlan` values ('146', '146');
insert into `vlan` values ('147', '147');
insert into `vlan` values ('148', '148');
insert into `vlan` values ('149', '149');
insert into `vlan` values ('150', '150');
insert into `vlan` values ('151', '151');
insert into `vlan` values ('152', '152');
insert into `vlan` values ('153', '153');
insert into `vlan` values ('154', '154');
insert into `vlan` values ('155', '155');
insert into `vlan` values ('156', '156');
insert into `vlan` values ('157', '157');
insert into `vlan` values ('158', '158');
insert into `vlan` values ('159', '159');
insert into `vlan` values ('160', '160');
insert into `vlan` values ('161', '161');
insert into `vlan` values ('162', '162');
insert into `vlan` values ('163', '163');
insert into `vlan` values ('164', '164');
insert into `vlan` values ('165', '165');
insert into `vlan` values ('166', '166');
insert into `vlan` values ('167', '167');
insert into `vlan` values ('168', '168');
insert into `vlan` values ('169', '169');
insert into `vlan` values ('170', '170');
insert into `vlan` values ('171', '171');
insert into `vlan` values ('172', '172');
insert into `vlan` values ('173', '173');
insert into `vlan` values ('174', '174');
insert into `vlan` values ('175', '175');
insert into `vlan` values ('176', '176');
insert into `vlan` values ('177', '177');
insert into `vlan` values ('178', '178');
insert into `vlan` values ('179', '179');
insert into `vlan` values ('180', '180');
insert into `vlan` values ('181', '181');
insert into `vlan` values ('182', '182');
insert into `vlan` values ('183', '183');
insert into `vlan` values ('184', '184');
insert into `vlan` values ('185', '185');
insert into `vlan` values ('186', '186');
insert into `vlan` values ('187', '187');
insert into `vlan` values ('188', '188');
insert into `vlan` values ('189', '189');
insert into `vlan` values ('190', '190');
insert into `vlan` values ('191', '191');
insert into `vlan` values ('192', '192');
insert into `vlan` values ('193', '193');
insert into `vlan` values ('194', '194');
insert into `vlan` values ('195', '195');
insert into `vlan` values ('196', '196');
insert into `vlan` values ('197', '197');
insert into `vlan` values ('198', '198');
insert into `vlan` values ('199', '199');
insert into `vlan` values ('200', '200');
insert into `vlan` values ('201', '201');
insert into `vlan` values ('202', '202');
insert into `vlan` values ('203', '203');
insert into `vlan` values ('204', '204');
insert into `vlan` values ('205', '205');
insert into `vlan` values ('206', '206');
insert into `vlan` values ('207', '207');
insert into `vlan` values ('208', '208');
insert into `vlan` values ('209', '209');
insert into `vlan` values ('210', '210');
insert into `vlan` values ('211', '211');
insert into `vlan` values ('212', '212');
insert into `vlan` values ('213', '213');
insert into `vlan` values ('214', '214');
insert into `vlan` values ('215', '215');
insert into `vlan` values ('216', '216');
insert into `vlan` values ('217', '217');
insert into `vlan` values ('218', '218');
insert into `vlan` values ('219', '219');
insert into `vlan` values ('220', '220');
insert into `vlan` values ('221', '221');
insert into `vlan` values ('222', '222');
insert into `vlan` values ('223', '223');
insert into `vlan` values ('224', '224');
insert into `vlan` values ('225', '225');
insert into `vlan` values ('226', '226');
insert into `vlan` values ('227', '227');
insert into `vlan` values ('228', '228');
insert into `vlan` values ('229', '229');
insert into `vlan` values ('230', '230');
insert into `vlan` values ('231', '231');
insert into `vlan` values ('232', '232');
insert into `vlan` values ('233', '233');
insert into `vlan` values ('234', '234');
insert into `vlan` values ('235', '235');
insert into `vlan` values ('236', '236');
insert into `vlan` values ('237', '237');
insert into `vlan` values ('238', '238');
insert into `vlan` values ('239', '239');
insert into `vlan` values ('240', '240');
insert into `vlan` values ('241', '241');
insert into `vlan` values ('242', '242');
insert into `vlan` values ('243', '243');
insert into `vlan` values ('244', '244');
insert into `vlan` values ('245', '245');
insert into `vlan` values ('246', '246');
insert into `vlan` values ('247', '247');
insert into `vlan` values ('248', '248');
insert into `vlan` values ('249', '249');
insert into `vlan` values ('250', '250');
insert into `vlan` values ('251', '251');
insert into `vlan` values ('252', '252');
insert into `vlan` values ('253', '253');
insert into `vlan` values ('254', '254');
insert into `vlan` values ('255', '255');
