-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------





--
-- Create schema grr
--

CREATE DATABASE IF NOT EXISTS grr;
USE grr;

--
-- Definition of table `grr`.`grr_area`
--

CREATE TABLE  `grr`.`grr_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `area_name` varchar(50) DEFAULT NULL,
  `access` char(1) NOT NULL DEFAULT '',
  `order_display` smallint(6) NOT NULL DEFAULT '0',
  `responsable` varchar(400) DEFAULT NULL,
  `ip_adr` varchar(15) NOT NULL,
  `morningstarts_area` smallint(6) NOT NULL,
  `eveningends_area` smallint(6) NOT NULL,
  `resolution_area` int(11) NOT NULL DEFAULT '0',
  `eveningends_minutes_area` smallint(6) NOT NULL,
  `weekstarts_area` smallint(6) NOT NULL,
  `twentyfourhour_format_area` smallint(6) NOT NULL,
  `calendar_default_values` varchar(1) NOT NULL DEFAULT 'y',
  `enable_periods` varchar(1) NOT NULL DEFAULT 'n',
  `display_days` varchar(7) NOT NULL DEFAULT 'yyyyyyy',
  `id_type_par_defaut` int(11) NOT NULL DEFAULT '-1',
  `duree_max_resa_area` int(11) NOT NULL DEFAULT '-1',
  `duree_par_defaut_reservation_area` int(11) NOT NULL DEFAULT '0',
  `max_booking` smallint(6) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_area`
--

INSERT INTO `grr`.`grr_area` VALUES  (1,'CRBM-Optique (7h-19h, Lu-Ve)','a',0,'Virginie Georget - 0467612254 - stephanie.vaudescal@mri.cnrs.fr<BR>Sylvain De Rossi - 0698318594 - stephanie.vaudescal@mri.cnrs.fr','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (2,'PHIV-Optique (8h-20h, Lu-Ve)','a',3,'Jean-Luc Verdeil - volker.baecker@mri.cnrs.fr','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (5,'INM-Optique (7h30-19h, Lu-Ve)','a',3,'Hassan Boukhaddaoui - 0499636071 - volker.baecker@mri.cnrs.fr<BR> or for Slide Scanner : Chamroeun SAR - 0499636079 - volker.baecker@mri.cnrs.fr ','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (6,'IGH-Optique (8h-18h30, Lu-Ve)','a',0,'Julien Cau - 0499619990 / 0650192749 - volker.baecker@mri.cnrs.fr','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (13,'LA_GAILLARDE-Optique (7h-20h, Lu-Ve)','a',3,'Elodie Jublanc - 04 99 61 28 23 - volker.baecker@mri.cnrs.fr','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (16,'IGH-CytoMétrie (8h-18h30, Lu-Ve)','a',0,'Philippe Coulombe - 0499619919 - volker.baecker@mri.cnrs.fr','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (14,'IGMM-CytoMétrie (8h-19h, Lu-Ve)','a',2,'Cédric Mongellaz - 0467613629 / 30 - volker.baecker@mri.cnrs.fr<BR> or for FacsAria : Myriam Boyer-Clavel - 0467613628 - volker.baecker@mri.cnrs.fr@igmm.cnrs.fr <BR> <A HREF=http://www.mri.cnrs.fr/reservation/files/DEMANDE_DE_TRI.doc> Télécharger le formulaire de demande de tri</A> ','',7,23,1800,0,1,1,'n','n','nyyyyyn',-1,-1,1800,-1),
 (15,'DBS-UM2-Optique (7h-19h, Lu-Ve)','a',0,'Vicky Diakou -  0467149202 - volker.baecker@mri.cnrs.fr','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (17,'IRB-CytoMétrie (8h-18h, Lu-Ve)','a',3,'Christophe Duperray - 0623960096 - volker.baecker@mri.cnrs.fr <BR> <A HREF=http://www.mri.cnrs.fr/reservation/files/DEMANDE_DE_TRI_IRB.doc> Télécharger le formulaire de demande de tri </A>','',0,0,0,0,0,0,'y','n','yyyyyyy',-1,-1,0,-1),
 (18,'test','a',0,'Volker Baecker - 0463635698 - volker.baecker@mri.cnrs.fr <BR> Volker Baecker - 0463635698 - volker.baecker@mri.cnrs.fr','',7,23,1800,0,1,1,'n','n','yyyyyyy',-1,-1,1800,-1);


--
-- Definition of table `grr`.`grr_area_periodes`
--

CREATE TABLE  `grr`.`grr_area_periodes` (
  `id_area` int(11) NOT NULL,
  `num_periode` smallint(6) NOT NULL,
  `nom_periode` varchar(100) NOT NULL,
  PRIMARY KEY (`id_area`,`num_periode`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_area_periodes`
--



--
-- Definition of table `grr`.`grr_calendar`
--

CREATE TABLE  `grr`.`grr_calendar` (
  `DAY` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_calendar`
--



--
-- Definition of table `grr`.`grr_calendrier_jours_cycle`
--

CREATE TABLE  `grr`.`grr_calendrier_jours_cycle` (
  `DAY` int(11) NOT NULL DEFAULT '0',
  `Jours` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_calendrier_jours_cycle`
--



--
-- Definition of table `grr`.`grr_correspondance_statut`
--

CREATE TABLE  `grr`.`grr_correspondance_statut` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code_fonction` varchar(30) NOT NULL,
  `libelle_fonction` varchar(200) NOT NULL,
  `statut_grr` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_correspondance_statut`
--



--
-- Definition of table `grr`.`grr_entry`
--

CREATE TABLE  `grr`.`grr_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_time` int(11) NOT NULL DEFAULT '0',
  `end_time` int(11) NOT NULL DEFAULT '0',
  `entry_type` int(11) NOT NULL DEFAULT '0',
  `repeat_id` int(11) NOT NULL DEFAULT '0',
  `room_id` int(11) NOT NULL DEFAULT '1',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_by` varchar(100) NOT NULL DEFAULT '',
  `beneficiaire_ext` varchar(200) NOT NULL,
  `beneficiaire` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(80) NOT NULL DEFAULT '',
  `type` char(2) DEFAULT NULL,
  `description` text,
  `statut_entry` char(1) NOT NULL DEFAULT '-',
  `option_reservation` int(11) NOT NULL DEFAULT '0',
  `overload_desc` text,
  `moderate` tinyint(1) DEFAULT '0',
  `jours` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idxStartTime` (`start_time`),
  KEY `idxEndTime` (`end_time`)
) ENGINE=MyISAM AUTO_INCREMENT=48011 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_entry`
--

INSERT INTO `grr`.`grr_entry` VALUES  (48010,1335081600,1335082500,0,0,1,'2012-04-19 10:16:07','VAUDESCAL','','vaudescal','test','B','','-',-1,'',0,0),
 (48009,1335081600,1335082500,0,0,5,'2012-04-19 10:15:09','VAUDESCAL','','vaudescal','info','C','','-',-1,'',0,0),
 (48008,1334995200,1334996100,0,0,4,'2012-04-19 10:14:11','FORMATION1','','FORMATION1','info','C','','-',-1,'',0,0),
 (48007,1334995200,1334996100,0,0,6,'2012-04-19 10:12:10','VAUDESCAL','','vaudescal','test résa','B','','-',-1,'',0,0),
 (48006,1334764800,1334765700,0,0,48,'2012-04-18 15:18:14','FORMATION1','','FORMATION1','test','A','','-',-1,'',0,0),
 (48005,1334926800,1334927700,0,0,1,'2012-04-18 15:07:47','VAUDESCAL','','vaudescal','test Type','B','test Type','-',-1,'',0,0),
 (48004,1334912400,1334913300,0,0,7,'2012-04-18 11:34:07','FORMATION2','','FORMATION2','resa formation2','A','','-',-1,'',0,0),
 (48003,1334818800,1334819700,0,0,40,'2012-04-18 09:20:10','VAUDESCAL','','vaudescal','resa 1','A','','-',-1,'',0,0),
 (48002,1334736000,1334736900,0,0,5,'2012-04-17 10:54:45','VAUDESCAL','','vaudescal','test résa','A','','-',-1,'',0,0),
 (48001,1334649600,1334650500,0,0,4,'2012-04-17 10:54:11','VAUDESCAL','','vaudescal','test résa','A','','-',-1,'',0,0),
 (48000,1334646000,1334646900,0,0,48,'2012-04-16 11:13:27','FORMATION1','','FORMATION1','test resume','A','','-',-1,'',0,0),
 (47999,1333638000,1333638900,0,0,2,'2012-04-04 17:21:27','FORMATION1','','FORMATION1','test resume','A','','-',-1,'',0,0),
 (47998,1333108800,1333112400,0,0,41,'2012-03-28 14:10:20','FORMATION1','','FORMATION1','test resa formation','A','','-',-1,'',0,0),
 (47997,1333003500,1333007100,0,0,7,'2012-03-28 14:08:30','VAUDESCAL','','VAUDESCAL','test resa vaudescal','A','','-',-1,'',0,0),
 (47996,1333093500,1333100700,0,0,1,'2012-03-28 14:05:32','FORMATION1','','FORMATION1','test resa formation','A','','-',-1,'',0,0),
 (47995,1333270800,1333271700,0,0,7,'2012-03-28 11:54:10','FORMATION1','','FORMATION1','dfgd','A','dfg','-',-1,'',0,0),
 (47994,1333267200,1333268100,0,0,1,'2012-03-28 10:35:09','FORMATION1','','FORMATION1','fdf','A','dfgd','-',-1,'',0,0),
 (47993,1333180800,1333181700,0,0,1,'2012-03-28 10:34:33','BAECKER','','BAECKER','dgh','A','fghfg','-',-1,'',0,0),
 (47992,1333089000,1333089900,0,0,1,'2012-03-27 16:07:44','ABES','','ABES','test abes','A','','-',-1,'',0,0),
 (47990,1333270800,1333271700,0,0,40,'2012-03-27 11:54:45','TEST','','TEST','fth','A','rthhr','-',-1,'',0,0),
 (47991,1332919800,1332920700,0,0,4,'2012-03-27 13:52:26','ABES','','ABES','test abes','A','','-',-1,'',0,0),
 (47989,1333184400,1333185300,0,0,1,'2012-03-27 11:42:57','TEST','','TEST','767856','A','dfgsfg','-',-1,'',0,0),
 (47988,1333004400,1333005300,0,0,48,'2012-03-27 11:18:31','VAUDESCAL','','VAUDESCAL','test 2','A','dqffsd','-',-1,'',0,0),
 (47987,1333016100,1333017000,0,0,48,'2012-03-27 11:15:51','VAUDESCAL','','VAUDESCAL','test','A','sfgxgds','-',-1,'',0,0),
 (47986,1332939600,1332943200,0,0,48,'2012-03-27 11:10:26','VAUDESCAL','','VAUDESCAL','test resa 13','A','','-',-1,'',0,0),
 (47985,1332928800,1332932400,0,0,48,'2012-03-27 10:02:13','VAUDESCAL','','VAUDESCAL','test resa 12','A','','-',-1,'',0,0),
 (47984,1332914400,1332921600,0,0,41,'2012-03-27 10:01:10','VAUDESCAL','','VAUDESCAL','test resa 11','A','','-',-1,'',0,0),
 (47983,1332583200,1332586800,0,0,48,'2012-03-23 15:58:15','VAUDESCAL','','VAUDESCAL','test resa 5','A','','-',-1,'',0,0),
 (47982,1332660600,1332667800,0,0,41,'2012-03-23 15:22:57','VAUDESCAL','','VAUDESCAL','test resa 4','A','','-',-1,'',0,0),
 (47981,1332603000,1332606600,0,0,7,'2012-03-23 15:19:59','VAUDESCAL','','VAUDESCAL','test resa 2','A','','-',-1,'',0,0),
 (47980,1332583200,1332590400,0,0,2,'2012-03-23 11:18:03','VAUDESCAL','','VAUDESCAL','test resa','A','','-',-1,'',0,0);


--
-- Definition of table `grr`.`grr_entry_moderate`
--

CREATE TABLE  `grr`.`grr_entry_moderate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_moderateur` varchar(40) NOT NULL DEFAULT '',
  `motivation_moderation` text NOT NULL,
  `start_time` int(11) NOT NULL DEFAULT '0',
  `end_time` int(11) NOT NULL DEFAULT '0',
  `entry_type` int(11) NOT NULL DEFAULT '0',
  `repeat_id` int(11) NOT NULL DEFAULT '0',
  `room_id` int(11) NOT NULL DEFAULT '1',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_by` varchar(100) NOT NULL DEFAULT '',
  `beneficiaire_ext` varchar(200) NOT NULL,
  `beneficiaire` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(80) NOT NULL DEFAULT '',
  `type` char(2) DEFAULT NULL,
  `description` text,
  `statut_entry` char(1) NOT NULL DEFAULT '-',
  `option_reservation` int(11) NOT NULL DEFAULT '0',
  `overload_desc` text,
  `moderate` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idxStartTime` (`start_time`),
  KEY `idxEndTime` (`end_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_entry_moderate`
--



--
-- Definition of table `grr`.`grr_j_mailuser_room`
--

CREATE TABLE  `grr`.`grr_j_mailuser_room` (
  `login` varchar(40) NOT NULL,
  `id_room` int(11) NOT NULL DEFAULT '0',
  `id_area` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`login`,`id_room`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_j_mailuser_room`
--

INSERT INTO `grr`.`grr_j_mailuser_room` VALUES  ('lautredou',21,0),
 ('lautredou',20,0),
 ('lautredou',18,0),
 ('lautredou',19,0),
 ('cau',48,0),
 ('boukhaddaoui',30,0),
 ('mboyer',53,0),
 ('mogellaz',53,0),
 ('duperray',54,0),
 ('duperray',55,0),
 ('duperray',56,0),
 ('sar',58,0),
 ('ejublanc',42,0);


--
-- Definition of table `grr`.`grr_j_site_area`
--

CREATE TABLE  `grr`.`grr_j_site_area` (
  `id_site` int(11) NOT NULL DEFAULT '0',
  `id_area` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_site`,`id_area`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_j_site_area`
--



--
-- Definition of table `grr`.`grr_j_type_area`
--

CREATE TABLE  `grr`.`grr_j_type_area` (
  `id_type` int(11) NOT NULL DEFAULT '0',
  `id_area` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_j_type_area`
--



--
-- Definition of table `grr`.`grr_j_user_area`
--

CREATE TABLE  `grr`.`grr_j_user_area` (
  `login` varchar(40) NOT NULL,
  `id_area` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`login`,`id_area`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_j_user_area`
--



--
-- Definition of table `grr`.`grr_j_user_room`
--

CREATE TABLE  `grr`.`grr_j_user_room` (
  `login` varchar(40) NOT NULL,
  `id_room` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`login`,`id_room`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_j_user_room`
--

INSERT INTO `grr`.`grr_j_user_room` VALUES  ('bertrand',34),
 ('boukhaddaoui',28),
 ('boukhaddaoui',29),
 ('boukhaddaoui',30),
 ('boukhaddaoui',31),
 ('boukhaddaoui',32),
 ('boukhaddaoui',58),
 ('conejero',9),
 ('conejero',37),
 ('conejero',47),
 ('diakou',44),
 ('diakou',45),
 ('diakou',57),
 ('duperray',54),
 ('duperray',55),
 ('duperray',56),
 ('ejublanc',42),
 ('escoute',9),
 ('escoute',37),
 ('escoute',47),
 ('lartaud',9),
 ('lartaud',37),
 ('lartaud',47),
 ('lautredou',18),
 ('lautredou',19),
 ('lautredou',20),
 ('lautredou',21),
 ('lin',51),
 ('mboyer',43),
 ('mboyer',46),
 ('mboyer',50),
 ('mboyer',53),
 ('mogellaz',43),
 ('mogellaz',46),
 ('mogellaz',50),
 ('mogellaz',53),
 ('ripetti',9),
 ('ripetti',37),
 ('ripetti',47),
 ('sar',28),
 ('sar',29),
 ('sar',30),
 ('sar',31),
 ('sar',32),
 ('sar',58),
 ('tranaupiais',34),
 ('verdeil',9),
 ('verdeil',37),
 ('verdeil',47);


--
-- Definition of table `grr`.`grr_j_useradmin_area`
--

CREATE TABLE  `grr`.`grr_j_useradmin_area` (
  `login` varchar(40) NOT NULL,
  `id_area` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`login`,`id_area`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_j_useradmin_area`
--



--
-- Definition of table `grr`.`grr_j_useradmin_site`
--

CREATE TABLE  `grr`.`grr_j_useradmin_site` (
  `login` varchar(40) NOT NULL DEFAULT '',
  `id_site` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`login`,`id_site`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_j_useradmin_site`
--



--
-- Definition of table `grr`.`grr_overload`
--

CREATE TABLE  `grr`.`grr_overload` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_area` int(11) NOT NULL,
  `fieldname` varchar(25) NOT NULL DEFAULT '',
  `fieldtype` varchar(25) NOT NULL DEFAULT '',
  `fieldlist` text NOT NULL,
  `obligatoire` char(1) NOT NULL DEFAULT 'n',
  `affichage` char(1) NOT NULL DEFAULT 'n',
  `overload_mail` char(1) NOT NULL DEFAULT 'n',
  `confidentiel` char(1) NOT NULL DEFAULT 'n',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_overload`
--



--
-- Definition of table `grr`.`grr_repeat`
--

CREATE TABLE  `grr`.`grr_repeat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_time` int(11) NOT NULL DEFAULT '0',
  `end_time` int(11) NOT NULL DEFAULT '0',
  `rep_type` int(11) NOT NULL DEFAULT '0',
  `end_date` int(11) NOT NULL DEFAULT '0',
  `rep_opt` varchar(32) NOT NULL DEFAULT '',
  `room_id` int(11) NOT NULL DEFAULT '1',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `create_by` varchar(100) NOT NULL DEFAULT '',
  `beneficiaire_ext` varchar(200) NOT NULL,
  `beneficiaire` varchar(100) NOT NULL DEFAULT '',
  `name` varchar(80) NOT NULL DEFAULT '',
  `type` char(2) DEFAULT NULL,
  `description` text,
  `rep_num_weeks` tinyint(4) DEFAULT '0',
  `overload_desc` text,
  `jours` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_repeat`
--



--
-- Definition of table `grr`.`grr_room`
--

CREATE TABLE  `grr`.`grr_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `area_id` int(11) NOT NULL DEFAULT '0',
  `room_name` varchar(25) NOT NULL DEFAULT '',
  `description` varchar(60) NOT NULL,
  `capacity` int(11) NOT NULL DEFAULT '0',
  `max_booking` smallint(6) NOT NULL DEFAULT '-1',
  `statut_room` char(1) NOT NULL DEFAULT '1',
  `show_fic_room` char(1) NOT NULL DEFAULT 'n',
  `picture_room` varchar(50) NOT NULL,
  `comment_room` text NOT NULL,
  `show_comment` char(1) NOT NULL DEFAULT 'n',
  `delais_max_resa_room` smallint(6) NOT NULL DEFAULT '-1',
  `delais_min_resa_room` smallint(6) NOT NULL DEFAULT '0',
  `order_display` smallint(6) NOT NULL DEFAULT '0',
  `allow_action_in_past` varchar(1) NOT NULL DEFAULT 'n',
  `delais_option_reservation` smallint(6) NOT NULL DEFAULT '0',
  `dont_allow_modify` varchar(1) NOT NULL DEFAULT 'n',
  `type_affichage_reser` smallint(6) NOT NULL DEFAULT '0',
  `moderate` tinyint(1) DEFAULT '0',
  `qui_peut_reserver_pour` varchar(1) NOT NULL DEFAULT '5',
  `active_ressource_empruntee` char(1) NOT NULL DEFAULT 'y',
  `who_can_see` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_room`
--

INSERT INTO `grr`.`grr_room` VALUES  (1,1,'Microscope Inverted 1','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (2,1,'Microscope Inverted 2','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (28,5,'Microscope Upright 1','Leica DMRB',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (4,1,'Microscope Inverted 3','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (5,1,'Microscope Upright 1','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (6,1,'Microscope Upright 3','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (7,1,'Microscope Upright 2','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (43,14,'FACSCANTO II','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (9,2,'LEICA DM6000B','upright 1',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (18,6,'BIORAD Confocal','8h-17h monday to friday',4,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (19,6,'ZEISS LSM510 META confoca','8h-17h Monday to friday',4,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (20,6,'Widefield/Zeiss SV11 M2 B','8h-17h Monday to friday',2,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (21,6,'LEICA confocal SP2','8h-17h Monday to friday',4,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (23,1,'Microscope Upright 5','LSM 24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (29,5,'Microscope Upright 2','Zeiss AxioImager (Apotome)',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (30,5,'Microscope Inverted 1','Zeiss 5 Live Duo',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (31,5,'Microscope Inverted 2','Zeiss Axiovert 200',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (32,5,'Microscope Inverted 3','Zeiss Axiovert 200 M',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (47,2,'Biphoton','Zeiss LSM 510 Meta NLO',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (46,14,'FACSCALIBUR 1','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (37,2,'RTM','Real Time Microscope',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (50,14,'FACSCALIBUR 2','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (40,1,'Microscope Inverted 4','24h/24, IGMM',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (41,1,'Microscope Upright 6','24h/24, IGMM',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (42,13,'Inversé 1 LSM 510 META','8h-17h',4,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (44,15,'Zeiss Inversé','24h/24h',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (45,15,'Leica Droit','24h/24h',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (48,1,'High Content Screening 1','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (51,16,'FacsCalibur II','',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (53,14,'FACSARIA','10H/17H',0,-1,'1','n','','','n',21,0,0,'n',0,'n',0,1,'5','y',0),
 (54,17,'FACScan 1','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (55,17,'FACScan 2','24h/24',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (56,17,'FACSAria','8h30/15h',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (57,15,'Olympus MVX10','24h/24h',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (58,5,'Slide Scanner 1','Hamamatsu NANOZOOMER)',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (59,18,'resource test','description of the resource',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0),
 (60,18,'resource test 2','description 2',0,-1,'1','n','','','n',-1,0,0,'n',0,'n',0,0,'6','y',0);


--
-- Definition of table `grr`.`grr_setting`
--

CREATE TABLE  `grr`.`grr_setting` (
  `NAME` varchar(32) NOT NULL DEFAULT '',
  `VALUE` text NOT NULL,
  PRIMARY KEY (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Registre des options de GRR';

--
-- Dumping data for table `grr`.`grr_setting`
--

INSERT INTO `grr`.`grr_setting` VALUES  ('sessionMaxLength','30'),
 ('automatic_mail','yes'),
 ('company','Montpellier RIO Imaging'),
 ('webmaster_name','Olivier Miquel'),
 ('webmaster_email','olivier.miquel@mri.cnrs.fr'),
 ('technical_support_email','olivier.miquel@mri.cnrs.fr'),
 ('grr_url','localhost'),
 ('disable_login','no'),
 ('begin_bookings',' 1330556400'),
 ('end_bookings',' 1341007200'),
 ('title_home_page','Connection to MRI'),
 ('message_home_page','This site has restricted access. To access the booking site, please insert your login and your password. If you would like to susbcribe to book, please come back to the first home page.'),
 ('version','1.9.7'),
 ('default_css','default'),
 ('default_area','-1'),
 ('default_room','-2'),
 ('area_list_format','select'),
 ('mri_email','mri-booking@mri.cnrs.fr'),
 ('default_language','fr'),
 ('url_disconnect',''),
 ('allow_users_modify_profil','2'),
 ('allow_users_modify_mdp','2'),
 ('display_info_bulle','1'),
 ('display_full_description','1'),
 ('pview_new_windows','1'),
 ('default_report_days','30'),
 ('use_fckeditor','1'),
 ('authentification_obli','0'),
 ('visu_fiche_description','0'),
 ('allow_search_level','1'),
 ('allow_user_delete_after_begin','0'),
 ('allow_gestionnaire_modify_del','1'),
 ('javascript_info_disabled','1'),
 ('javascript_info_admin_disabled','1'),
 ('pass_leng','6'),
 ('allow_users_modify_email','2'),
 ('jour_debut_Jours/Cycles','1'),
 ('nombre_jours_Jours/Cycles','1'),
 ('UserAllRoomsMaxBooking','-1'),
 ('jours_cycles_actif','Non'),
 ('grr_mail_Password',''),
 ('grr_mail_method','mail'),
 ('grr_mail_smtp',''),
 ('grr_mail_Bcc','n'),
 ('grr_mail_Username',''),
 ('verif_reservation_auto','0'),
 ('ConvertLdapUtf8toIso','y'),
 ('ActiveModeDiagnostic','y'),
 ('ldap_champ_nom','sn'),
 ('ldap_champ_prenom','givenname'),
 ('ldap_champ_email','mail'),
 ('gestion_lien_aide','ext'),
 ('lien_aide',''),
 ('display_short_description','1'),
 ('remplissage_description_breve','1'),
 ('ldap_champ_recherche','uid'),
 ('maj195_champ_rep_type_grr_repeat','1'),
 ('longueur_liste_ressources_max','20'),
 ('acces_fiche_reservation','0'),
 ('display_level_email','0'),
 ('nb_calendar','3'),
 ('default_site','-1'),
 ('envoyer_email_avec_formulaire','no'),
 ('maj194_champs_additionnels','1'),
 ('maj196_qui_peut_reserver_pour','1'),
 ('versionRC',''),
 ('message_accueil',''),
 ('use_grr_url','n'),
 ('date_verify_reservation','1336082400'),
 ('date_verify_reservation2','1336082400'),
 ('logo','logo.jpg'),
 ('ldap_statut','utilisateur'),
 ('se3_liste_groupes_autorises','');


--
-- Definition of table `grr`.`grr_site`
--

CREATE TABLE  `grr`.`grr_site` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sitecode` varchar(10) DEFAULT NULL,
  `sitename` varchar(50) NOT NULL DEFAULT '',
  `adresse_ligne1` varchar(38) DEFAULT NULL,
  `adresse_ligne2` varchar(38) DEFAULT NULL,
  `adresse_ligne3` varchar(38) DEFAULT NULL,
  `cp` varchar(5) DEFAULT NULL,
  `ville` varchar(50) DEFAULT NULL,
  `pays` varchar(50) DEFAULT NULL,
  `tel` varchar(25) DEFAULT NULL,
  `fax` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_site`
--



--
-- Definition of table `grr`.`grr_type_area`
--

CREATE TABLE  `grr`.`grr_type_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(30) NOT NULL DEFAULT '',
  `order_display` smallint(6) NOT NULL DEFAULT '0',
  `couleur` smallint(6) NOT NULL DEFAULT '0',
  `type_letter` char(2) NOT NULL DEFAULT '',
  `disponible` varchar(1) NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`grr_type_area`
--

INSERT INTO `grr`.`grr_type_area` VALUES  (1,'Users',0,2,'A','2'),
 (2,'MRI Staff',1,13,'B','2'),
 (3,'Info',2,19,'C','2');


--
-- Definition of table `grr`.`material`
--

CREATE TABLE  `grr`.`material` (
  `Running_Name` text,
  `Manufacturer` text,
  `Make` text,
  `Date` date DEFAULT NULL,
  `Main_Use` text,
  `Secondary_use` text NOT NULL,
  `Motorizations` text,
  `Stand_transmitted_light_shutter` text,
  `Stand_fluorescence_excitation_shutter` text,
  `Stand_fluorescence_cube_filter_wheel` text,
  `Stand_objective_wheel` text,
  `Stand_Z_stage` text NOT NULL,
  `Z_piezo` text NOT NULL,
  `Z_piezo_manufacturer` text NOT NULL,
  `Z_piezo_make` text NOT NULL,
  `Z_piezo_retailer` text NOT NULL,
  `Shutter_external` text NOT NULL,
  `Shutter_transmitted_light` text NOT NULL,
  `Shutter_tl_manufacturer` text NOT NULL,
  `Shutter_tl_retailer` text NOT NULL,
  `Shutter_fluorescence_excitation` text NOT NULL,
  `Shutter_fe_manufacturer` text NOT NULL,
  `Shuter_fe_make` text NOT NULL,
  `Shutter_fe_retailer` text NOT NULL,
  `Filter_Wheels_external_excitation_emission` text NOT NULL,
  `Filter_Wheels_manufacturer` text NOT NULL,
  `Filter_Wheels_make` text NOT NULL,
  `Filter_Wheels_retailer` text NOT NULL,
  `fast_wavelength_control` text NOT NULL,
  `FWC_manufacturer` text NOT NULL,
  `FWC_make` text NOT NULL,
  `Stage` text NOT NULL,
  `Stage_manufacturer` text NOT NULL,
  `Stage_make` text NOT NULL,
  `Stage_retailer` text NOT NULL,
  `Mosaic_Images` text NOT NULL,
  `Transmitted_light_normarski` text NOT NULL,
  `TL_Phase` text NOT NULL,
  `TL_Darkfield` text NOT NULL,
  `TL_Polarization` text NOT NULL,
  `CCD_Captor` int(2) NOT NULL DEFAULT '0',
  `Captor1_manufacturer` text NOT NULL,
  `Captor1_make` text NOT NULL,
  `Captor1_retailer` text NOT NULL,
  `Captor2_manufacturer` text NOT NULL,
  `Captor2_make` text NOT NULL,
  `Captor2_retailer` text NOT NULL,
  `captor3_manufacturer` text NOT NULL,
  `Captor3_make` text NOT NULL,
  `Captor3_retailer` text NOT NULL,
  `Photographic_attachment_digital` text NOT NULL,
  `PAD_manufacturer` text NOT NULL,
  `PAD_make` text NOT NULL,
  `PAD_retailer` text NOT NULL,
  `photographic_attachement_analogic` text NOT NULL,
  `PAA_manufacturer` text NOT NULL,
  `PAA_make` text NOT NULL,
  `PAA_retailer` text NOT NULL,
  `HBO_100W` text NOT NULL,
  `HBO_50W` text NOT NULL,
  `Halogen` text NOT NULL,
  `Xenon` text NOT NULL,
  `Wheels wavelength_change` text NOT NULL,
  `Fast_wavelength_change` text NOT NULL,
  `lasers_sources` text NOT NULL,
  `Laser1` text NOT NULL,
  `Laser2` text NOT NULL,
  `Laser3` text NOT NULL,
  `Laser4` text NOT NULL,
  `Laser5` text NOT NULL,
  `Confocal_module` text NOT NULL,
  `CM_type` text NOT NULL,
  `CM_manufacturer` text NOT NULL,
  `CM_make` text NOT NULL,
  `CM_additionnal_photometric_system` text NOT NULL,
  `CM_retailer` text NOT NULL,
  `CM_wavelength_control` text NOT NULL,
  `CM_fast_wavelength_change` text NOT NULL,
  `CM_additionnal_photometric_module` text NOT NULL,
  `CM_apm_manufacturer` text NOT NULL,
  `CM_apm_make` text NOT NULL,
  `CM_apm_retailer` text NOT NULL,
  `Available_objectives` text NOT NULL,
  `air` text NOT NULL,
  `imm oil` text NOT NULL,
  `imm W` text NOT NULL,
  `dipping` text NOT NULL,
  `iMicroinjection` text NOT NULL,
  `iM_manufacturer` text NOT NULL,
  `iM_make` text NOT NULL,
  `iM_retailer` text NOT NULL,
  `Environmental_control` text NOT NULL,
  `Temperature_control` text NOT NULL,
  `TC_manufacturer` text NOT NULL,
  `TC_make` text NOT NULL,
  `TC_available_insert` text NOT NULL,
  `TC_retailer` text NOT NULL,
  `CO2_control` text NOT NULL,
  `CO2_manufacturer` text NOT NULL,
  `CO2_make` text NOT NULL,
  `CO2_retailer` text NOT NULL,
  `Humidity_control` text NOT NULL,
  `HC_manufacturer` text NOT NULL,
  `HC_make` text NOT NULL,
  `HC_retailer` text NOT NULL,
  `Medium_change_modification` text NOT NULL,
  `MCM_manufacturer` text NOT NULL,
  `MCM_make` text NOT NULL,
  `MCM_retailer` text NOT NULL,
  `MCM_computer_controlled` text NOT NULL,
  `MCM_operator_controlled` text NOT NULL,
  `Driving_software_manufacturer` text NOT NULL,
  `DS_name` text NOT NULL,
  `DS_retailer` text NOT NULL,
  `Hardware` text NOT NULL,
  `H_manufacturer` text NOT NULL,
  `H_make` text NOT NULL,
  `H_monitor` text NOT NULL,
  `H_CPU` text NOT NULL,
  `H_ram` text NOT NULL,
  `H_HDU` text NOT NULL,
  `H_USB` text NOT NULL,
  `connected_internet` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grr`.`material`
--

INSERT INTO `grr`.`material` VALUES  ('Upright Microscope 1','LEICA DMRB\r\n1997\r\nNot motorized','fixed, Manual XY imaging','0000-00-00','GFP, Rhodamine + Transmitted light','yes','no','MetaMorph 5','no',NULL,NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright Microscope 3','LEICA DMR A\r\n1999\r\nMotorized','fixed, Manual XY imaging','0000-00-00','Hoechst, CFP, GFP, Cy 3, Rhodamine, Cy 5 + Transmitted light','No','Yes','MetaMorph 5.0r7','No','Melles Griot triple band (GFP, Rhod, Cy 5)','Real Time (Ultraview PE) motorized','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright Microscope 2','LEICA DMR A\r\n1999\r\nMotorized','fixed, Manual XY imaging','0000-00-00','Hoechst, CFP, GFP, Cy 3, Rhodamine, Cy 5\r\n+\r\nTransmitted light','Yes','Yes','MetaMorph 5','No',NULL,NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright Microscope 4','LEICA DMR B\r\n2001\r\nNot motorized','fixed, Manual XY imaging','0000-00-00','Hoechst\r\nGFP\r\nRhodamine\r\n+\r\nTransmitted light','No','Yes','MetaMorph 4.6r9','No','Melles Griot triple band (Hoechst-GFP-Rhod)','Real Time (ULTRAVIEW PE) motorized','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright Microscope 5','ZEISS LSM 510 meta','FRET, FRAP, Autofluorescence, GFP photoactivable ...',NULL,NULL,'Yes','Yes','ZEISS LSM','Yes','Diode (405 nm), Argon (458-477-488-514 nm), HeNe (543-633 nm)','Yes','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Inverted Microscope 1','LEICA DM IRB - 1998 No motorised + cell incubator set up in the laboratory','Phase contrast - Time lapse for long time periods for cultured cells - 100 mm diam dish - ','0000-00-00','Dapi, Rhodamine','No','No','MetaVue 6.1r5','No',NULL,NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Inverted Microscope 2','LEICA DM IRBE - 2004 Motorized + cell Incubator','Nomarski - Phase contrast - Time lapse for long periods for cultured cells - 100 mm diam dish - ','0000-00-00','GFP, Rhodamine','Yes','No','Metamorph 6.1','Yes',NULL,NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Inverted Microscope 3','LEICA DM IRBE - 2002 Motorized','Phase contrast - Time lapse for long periods for cultured cells - 6 well dish - ','0000-00-00','GFP','No','No','MetaMorph 6.1','Yes',NULL,NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright Biorad','Biorad 1024','upright statif Nikon Optiphot-2',NULL,NULL,'','yes','biorad software','yes','Krypton-argon : 488-568-647nm',NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright and Inverted SP2','Leica SP2 UV','2 upright statif DMLSF and DMIRB\r\n',NULL,NULL,'',NULL,NULL,NULL,'UV 405nm, argon 4 lines : 458-477-488-514, He-Ne : 543 and 633nm',NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright Zeiss LSM','Zeiss LSM510 META','upright statif Axioplan 2\r\n',NULL,NULL,'',NULL,NULL,NULL,'Argon\r\nHe-Ne',NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Upright Leica','LEICA DMR',NULL,'0000-00-00',NULL,'',NULL,'Metamorph 6.1',NULL,NULL,NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''),
 ('Stereomicroscope','ZEISS SV11',NULL,'0000-00-00',NULL,'',NULL,NULL,NULL,'UV, rouge proche (bande GFP-Dsred)',NULL,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','');




