CREATE TABLE `gamme_attr` (
  `game_att_seq` int(16) NOT NULL auto_increment,
  PRIMARY KEY  (`game_att_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gamme_attr`
--



--
-- Definition of table `gamme_frequence`
--

CREATE TABLE `gamme_frequence` (
  `gafr_seq` int(11) NOT NULL auto_increment,
  `gafr_frequence` int(11) default NULL,
  `gafr_game_fk` int(11) NOT NULL default '0',
  `gafr_zus_fk` int(11) NOT NULL default '0',
  PRIMARY KEY  (`gafr_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gamme_frequence`
--



--
-- Definition of table `gamme_mlg`
--

CREATE TABLE `gamme_mlg` (
  `game_mlg_seq` int(11) NOT NULL default '0',
  `game_mlg_libelle` varchar(30) default NULL,
  PRIMARY KEY  (`game_mlg_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gamme_mlg`
--



--
-- Definition of table `gdoc_sous_theme`
--

CREATE TABLE `gdoc_sous_theme` (
  `gdcs_seq` int(11) NOT NULL auto_increment,
  `gdcs_gdct_fk` int(11) default NULL,
  `gdcs_libelle` varchar(20) default NULL,
  `gdcs_ordre` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`gdcs_seq`),
  KEY `gdcs_gdct_fk` (`gdcs_gdct_fk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gdoc_sous_theme`
--



--
-- Definition of table `gdoc_theme`
--

CREATE TABLE `gdoc_theme` (
  `gdct_seq` int(11) NOT NULL auto_increment,
  `gdct_libelle` varchar(50) default NULL,
  `gdct_ordre` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`gdct_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gdoc_theme`
--



--
-- Definition of table `glodeurubope`
--

CREATE TABLE `glodeurubope` (
  `gdro_seq` int(11) NOT NULL auto_increment,
  `gdro_code` varchar(15) NOT NULL,
  PRIMARY KEY  (`gdro_seq`),
  UNIQUE KEY `gdro_seq` (`gdro_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `glodeurubope`
--



--
-- Definition of table `gloprerubope`
--

CREATE TABLE `gloprerubope` (
  `gpro_seq` int(11) NOT NULL auto_increment,
  `gpro_code` varchar(15) NOT NULL,
  PRIMARY KEY  (`gpro_seq`),
  UNIQUE KEY `gpro_seq` (`gpro_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gloprerubope`
--



--
-- Definition of table `glossaire`
--

CREATE TABLE `glossaire` (
  `glos_seq` int(11) NOT NULL auto_increment,
  `glos_libelle` varchar(40) default NULL,
  PRIMARY KEY  (`glos_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `glossaire`
--



--
-- Definition of table `groupe_salle`
--

CREATE TABLE `groupe_salle` (
  `gsal_seq` int(11) NOT NULL auto_increment,
  `gsal_libelle` varchar(15) NOT NULL,
  `gsal_ordre` int(11) NOT NULL default '0',
  PRIMARY KEY  (`gsal_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `groupe_salle`
--



--
-- Definition of table `histo_modif_resa`
--

CREATE TABLE `histo_modif_resa` (
  `himr_seq` int(11) NOT NULL auto_increment,
  `himr_resa_fk` int(11) NOT NULL default '0',
  `himr_zus_fk` int(11) NOT NULL default '0',
  `himr_date` date NOT NULL default '0000-00-00',
  `himr_heure` time NOT NULL default '00:00:00',
  `himr_type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`himr_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `histo_modif_resa`
--



--
-- Definition of table `histo_modif_visites`
--

CREATE TABLE `histo_modif_visites` (
  `himv_seq` int(11) NOT NULL auto_increment,
  `himv_vis_fk` int(11) NOT NULL default '0',
  `himv_zus_fk` int(11) NOT NULL default '0',
  `himv_date` date NOT NULL default '0000-00-00',
  `himv_heure` time NOT NULL default '00:00:00',
  `himv_type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`himv_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `histo_modif_visites`
--



--
-- Definition of table `hlp_article`
--

CREATE TABLE `hlp_article` (
  `hlar_seq` int(11) NOT NULL auto_increment,
  `hlar_hlit_fk` int(11) NOT NULL default '0',
  `hlar_lang_fk` int(11) NOT NULL default '0',
  `hlar_label` varchar(100) NOT NULL default '',
  `hlar_text` text,
  `hlar_is_default` tinyint(4) NOT NULL default '0',
  `hlar_status` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`hlar_seq`)
) ENGINE=MyISAM AUTO_INCREMENT=229 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `hlp_article`
--

INSERT INTO `hlp_article` (`hlar_seq`,`hlar_hlit_fk`,`hlar_lang_fk`,`hlar_label`,`hlar_text`,`hlar_is_default`,`hlar_status`) VALUES 
 (33,29,1,'Formulaires','[BLOB]',1,1),
 (35,31,1,'Enquêtes de satisfaction','[BLOB]',1,1),
 (79,75,1,'Filtres de la liste','[BLOB]',1,1),
 (81,77,1,'Généralités','[BLOB]',1,1),
 (82,78,1,'Autres modules','PGJsb2NrcXVvdGU+PHA+Jm5ic3A7PC9wPjwvYmxvY2txdW90ZT48cD48Zm9udCBzaXplPSIxIj5DZXR0ZSBwYXJ0aWUgcmVncm91cGUgbGVzIHByJmVhY3V0ZTtmJmVhY3V0ZTtyZW5jZXMgcG91ciBsZXMgbW9kdWxlcyA6PC9mb250PjwvcD48YmxvY2txdW90ZT48YmxvY2txdW90ZT48cD48Zm9udCBzaXplPSIxIj48c3Ryb25nPiZkaWFtczsmbmJzcDtJbmZvcm1hdGlvbnM8L3N0cm9uZz48L2ZvbnQ+PC9wPjxwPjxmb250IHNpemU9IjEiPjxzdHJvbmc+JmRpYW1zOzwvc3Ryb25nPjwvZm9udD48Zm9udCBzaXplPSIxIj4mbmJzcDs8c3Ryb25nPkRvYyBvbiBsaW5lPC9zdHJvbmc+PC9mb250PjwvcD48cD48Zm9udCBzaXplPSIxIj48c3Ryb25nPiZkaWFtczs8L3N0cm9uZz48L2ZvbnQ+PGZvbnQgc2l6ZT0iMSI+Jm5ic3A7PHN0cm9uZz5TZXJ2aWNlcyArPC9zdHJvbmc+PC9mb250PjwvcD48cD48Zm9udCBzaXplPSIxIj48c3Ryb25nPiZkaWFtczs8L3N0cm9uZz4gPHN0cm9uZz5SZXN0YXVyYW50PC9zdHJvbmc+Jm5ic3A7PC9mb250PjwvcD48L2Jsb2NrcXVvdGU+PC9ibG9ja3F1b3RlPg==',1,1),
 (83,79,1,'Informations','[BLOB]',1,1),
 (73,69,1,'Généralités','[BLOB]',1,1),
 (40,36,1,'Administration-Gestion des Accès','[BLOB]',1,1),
 (41,37,1,'Accès Général','[BLOB]',1,1),
 (42,38,1,'Profils','[BLOB]',1,1),
 (80,76,1,'Annuaire','PHA+Jm5ic3A7PC9wPjxwPjxmb250IHNpemU9IjEiPkNlcyBwciZlYWN1dGU7ZiZlYWN1dGU7cmVuY2VzIHMmIzM5O2FwcGxpcXVlbnQgYXUgbW9kdWxlIEFubnVhaXJlIDsgQW5udWFpcmUgaW50ZXJuZSBldCBBbm51YWlyZSBlbnRyZXByaXNlLjwvZm9udD48L3A+',1,1);
INSERT INTO `hlp_article` (`hlar_seq`,`hlar_hlit_fk`,`hlar_lang_fk`,`hlar_label`,`hlar_text`,`hlar_is_default`,`hlar_status`) VALUES 
 (91,87,1,'Gestion des indicateurs','[BLOB]',1,1),
 (16,12,1,'Administration-Préférences','[BLOB]',1,1),
 (20,16,1,'Gestion des modes d\'accès','[BLOB]',1,1),
 (132,128,1,'Types de desserte','',1,1),
 (133,129,1,'Filtres de points et mesures','[BLOB]',1,1),
 (134,130,1,'Gestion CRmail','',1,1),
 (135,131,1,'Préférences Interventions - Programme préventif','',1,1),
 (61,57,1,'Gestion des exports','[BLOB]',1,1),
 (18,14,1,'Général','PHA+PGEgbmFtZT0iaGF1dCIgdGl0bGU9ImhhdXQiPjwvYT48L3A+PHA+Jm5ic3A7PC9wPjxwPjxmb250IHNpemU9IjEiPkRhbnMgY2V0dGUgcGFydGllLCBsJiMzOTthZG1pbmlzdHJhdGV1ciBwb3VycmEgcGFyYW0mZWFjdXRlO3RyZXIgbGVzIG9wdGlvbnMgZyZlYWN1dGU7biZlYWN1dGU7cmFsZXMgYXUgbG9naWNpZWwgY29tbWUmbmJzcDtsZXMgZm9ybWF0cyBkJiMzOTthZmZpY2hhZ2UsIGxlcyBub3Rpb25zIGFubmV4ZXMsIGxlcyZuYnNwO21vZGVzIGQmIzM5O2FjYyZlZ3JhdmU7cywgbGVzIGpvdXJzIGYmZWFjdXRlO3JpJmVhY3V0ZTtzLCBsZXMgbm90aW9ucyBkZSBjcml0aWNpdCZlYWN1dGU7LCBkJiMzOTthZ2VuY2Ugb3UgZCYjMzk7YWZmZWN0YXRpb24gZmluYW5jaSZlZ3JhdmU7cmUsIGxlcyZuYnNwO3RoJmVncmF2ZTttZXMgZXQgbG9nb3MgLi4uPC9mb250PjwvcD4=',1,1),
 (30,26,1,'Types d\'opération','[BLOB]',1,1),
 (19,15,1,'Généralités','[BLOB]',1,1),
 (47,43,1,'Gestion horaire','[BLOB]',1,1),
 (99,95,1,' Annuaire interne - Liste annuaire','[BLOB]',1,1),
 (136,132,1,'Généralités','',1,1),
 (137,133,1,'Types de programme','',1,1),
 (138,134,1,'Préférences Interventions - Circuit de validation','',1,1),
 (139,135,1,'Généralités','',1,1),
 (141,137,1,'Formats d\'E-mail','',1,1),
 (142,138,1,'Déclencheurs d\'E-mail','',1,1),
 (143,139,1,'Circuits type','',1,1),
 (144,140,1,'Déclencheurs de circuit','',1,1),
 (147,143,1,'Préférences Interventions - Devis','',1,1),
 (148,144,1,'Généralités','',1,1),
 (149,145,1,'Edition','',1,1),
 (150,146,1,'Bordereau de prix','',1,1),
 (151,147,1,'Modèles de devis','',1,1),
 (152,148,1,'Gestion  validation','',1,1),
 (153,149,1,'Restaurant','',1,1),
 (154,150,1,'Généralités','',1,1),
 (155,151,1,'Gestion de l\'import','',1,1),
 (156,152,1,'Développement durable','',1,1),
 (157,153,1,'Préférences','',1,1),
 (158,154,1,'Types d\'energie','',1,1),
 (159,155,1,'Usages','',1,1),
 (160,156,1,'Les unités d\'étalonnage','',1,1),
 (161,157,1,'Gestion des DJU','',1,1),
 (162,158,1,'Secteurs -  Energie','',1,1),
 (163,159,1,'Secteurs - Eau','',1,1),
 (164,160,1,'Types de déchets','',1,1),
 (165,161,1,'Lieu de collecte déchets','',1,1),
 (166,162,1,'Qualité environnementale','',1,1),
 (167,163,1,'Covoiturage - Attributs','',1,1),
 (168,164,1,'En savoir +  Thèmes','',1,1),
 (169,165,1,'Annuaire Entreprises - Recherche','',1,1),
 (170,166,1,'Technique','',1,1),
 (171,167,1,'Déménagement','',1,1),
 (172,168,1,'Nettoyage','',1,1),
 (173,169,1,'Demande d\'intervention','',1,1),
 (174,170,1,'Compte rendu direct','',1,1),
 (175,171,1,'Appels entrants','',1,1),
 (176,172,1,'Gestion des congés','',1,1),
 (177,173,1,'Gammes','',1,1),
 (178,174,1,'Types de défaut','',1,1),
 (179,175,1,'Plannification du préventif','',1,1),
 (180,176,1,'Données patrimoine','',1,1),
 (181,177,1,'Données géographiques','',1,1),
 (182,178,1,'Site','',1,1),
 (183,179,1,'Bâtiments','',1,1),
 (184,180,1,'Zone','',1,1),
 (185,181,1,'Locaux','',1,1),
 (186,182,1,'Données techniques','',1,1),
 (187,183,1,'Domaines','',1,1),
 (188,184,1,'Famille d\'équipements','',1,1),
 (189,185,1,'Equipements','',1,1),
 (190,186,1,'Consultation intervention','',1,1),
 (32,28,1,'Personnalisation de la liste','[BLOB]',1,1),
 (21,17,1,'Calendrier des jours fériés','[BLOB]',1,1),
 (22,18,1,'Notion de Criticité','[BLOB]',1,1);
INSERT INTO `hlp_article` (`hlar_seq`,`hlar_hlit_fk`,`hlar_lang_fk`,`hlar_label`,`hlar_text`,`hlar_is_default`,`hlar_status`) VALUES 
 (100,96,1,'Annuaire interne - Liste services','[BLOB]',1,1),
 (101,97,1,'Annuaire interne - Recherche','[BLOB]',1,1),
 (102,98,1,'Annuaire Entreprise - Liste contacts','[BLOB]',1,1),
 (103,99,1,'Annuaire Entreprises - Liste entreprises','[BLOB]',1,1),
 (104,100,1,'Sommaire','[BLOB]',1,1),
 (93,89,1,'Log indicateur','[BLOB]',1,1),
 (48,44,1,'Délais par niveau de criticité','[BLOB]',1,1),
 (49,45,1,'Gestion de l\'affectation financière','[BLOB]',1,1),
 (23,19,1,'Affectation Financière','[BLOB]',1,1),
 (24,20,1,'Gestion des thèmes et logos','[BLOB]',1,1),
 (28,24,1,'Préférences Interventions- Préférences générales','[BLOB]',1,1);
INSERT INTO `hlp_article` (`hlar_seq`,`hlar_hlit_fk`,`hlar_lang_fk`,`hlar_label`,`hlar_text`,`hlar_is_default`,`hlar_status`) VALUES 
 (29,25,1,'Généralités','[BLOB]',1,1),
 (31,27,1,'Gestion de la Criticité','[BLOB]',1,1),
 (63,59,1,'Association domaine formulaire','[BLOB]',1,1),
 (64,60,1,'Filtre du planning','[BLOB]',1,1),
 (65,61,1,'Formats d\'E-mail','[BLOB]',1,1),
 (66,62,1,'Déclencheurs d\'E-mail','[BLOB]',1,1),
 (67,63,1,'Règles de gestion','PGEgbmFtZT0iaGF1dCIgdGl0bGU9ImhhdXQiPjwvYT4=',1,1),
 (68,64,1,'Périodes/Interventions','PGEgbmFtZT0iaGF1dCIgdGl0bGU9ImhhdXQiPjwvYT4=',1,1),
 (69,65,1,'Paramétrage des enquêtes','[BLOB]',1,1),
 (44,40,1,'Administration-Administration','[BLOB]',1,1),
 (27,23,1,'Gestion des Données','[BLOB]',1,1),
 (98,94,1,'Annuaire','[BLOB]',1,1),
 (50,46,1,'Gestion des attributs','[BLOB]',1,1),
 (51,47,1,'Données Géographiques','[BLOB]',1,1),
 (52,48,1,'Données Techniques','[BLOB]',1,1),
 (53,49,1,'Statuts des données','[BLOB]',1,1);
INSERT INTO `hlp_article` (`hlar_seq`,`hlar_hlit_fk`,`hlar_lang_fk`,`hlar_label`,`hlar_text`,`hlar_is_default`,`hlar_status`) VALUES 
 (54,50,1,'Etat de Santé','[BLOB]',1,1),
 (55,51,1,'Glossaire','[BLOB]',1,1),
 (56,52,1,'Types de local','[BLOB]',1,1),
 (57,53,1,'Types de projet','[BLOB]',1,1),
 (58,54,1,'Modes d\'astreinte','[BLOB]',1,1),
 (62,58,1,'Gestion du vocabulaire','[BLOB]',1,1),
 (59,55,1,'Etats d\'avancement','[BLOB]',1,1),
 (60,56,1,'Supervision','[BLOB]',1,1),
 (71,67,1,'Préférences Interventions- Compte rendu','[BLOB]',1,1);
INSERT INTO `hlp_article` (`hlar_seq`,`hlar_hlit_fk`,`hlar_lang_fk`,`hlar_label`,`hlar_text`,`hlar_is_default`,`hlar_status`) VALUES 
 (72,68,1,'Préférences Interventions - Demande d\'intervention','[BLOB]',1,1),
 (77,73,1,'Gestion des pop up','[BLOB]',1,1),
 (74,70,1,'Structure des formulaires','[BLOB]',1,1),
 (86,82,1,'Gestion des documents','[BLOB]',1,1),
 (87,83,1,'Gestion des attributs','[BLOB]',1,1),
 (88,84,1,'Services +','PHA+Jm5ic3A7PC9wPjxwPjxmb250IHNpemU9IjIiIGNvbG9yPSIjZmY5OTAwIj48c3Ryb25nPlN0YXRpc3RpcXVlczwvc3Ryb25nPjwvZm9udD48L3A+PGJsb2NrcXVvdGU+PHA+PGZvbnQgc2l6ZT0iMSI+PHN0cm9uZz5BbmFseXNlIHBhciBqb3VyLCBpbnRlcnZhbGxlIGRlIHRlbXBzIDo8L3N0cm9uZz4gSW5kaXF1ZSBsJiMzOTtpbnRlcnZhbGxlIGRlIHRlbXBzIHBlbmRhbnQgbGVxdWVsIGxlcyBhbmFseXNlcyBkZSBjZSBtb2R1bGUgc2Vyb250IGVmZmVjdHUmZWFjdXRlO2VzLjwvZm9udD4gPC9wPjwvYmxvY2txdW90ZT4=',1,1),
 (75,71,1,'Gestion des surdomaines','[BLOB]',1,1),
 (84,80,1,'Doc on line','',1,1),
 (85,81,1,'Généralités','[BLOB]',1,1),
 (78,74,1,'Personnalisation de la liste','[BLOB]',1,1),
 (89,85,1,'Groupe d\'affectation','[BLOB]',1,1),
 (96,92,1,'Gestion des vocables','PHA+Jm5ic3A7PC9wPjxwPjxzcGFuPjxzdHJvbmc+PGZvbnQgc2l6ZT0iMiIgY29sb3I9IiNmZjk5MDAiPkdlc3Rpb24gZGVzIHZvY2FibGVzPC9mb250PiZuYnNwOzwvc3Ryb25nPjwvc3Bhbj48L3A+PHA+PHNwYW4+PGZvbnQgc2l6ZT0iMSI+QWZpbiBkZSBmYWNpbGl0ZXIgbGEgc2Fpc2llIGRlcyBjb21tZW50YWlyZXMgbG9ycyBkJiMzOTt1biBjb21wdGUtcmVuZHUsIGxhIGdlc3Rpb24gZGVzIHZvY2FibGVzIHBlcm1ldCBkZSBjciZlYWN1dGU7ZXIgZGVzJm5ic3A7IGNvbXB0ZXMtcmVuZHVzIHR5cGUmbmJzcDtxdWUgbCYjMzk7b24gcG91cnJhIGlucyZlYWN1dGU7cmVyIGRhbnMgbCYjMzk7b25nbGV0IGNvbW1lbnRhaXJlcy48L2ZvbnQ+Jm5ic3A7PC9zcGFuPjwvcD4=',1,1),
 (92,88,1,'Impression','[BLOB]',1,1),
 (95,91,1,'Généralités','[BLOB]',1,1),
 (94,90,1,'Filtres de la liste','[BLOB]',1,1),
 (125,121,1,'Organisation des interventions','[BLOB]',1,1),
 (105,101,1,'Demande d\'intervention','[BLOB]',1,1),
 (106,102,1,'Gestion des interventions','[BLOB]',1,1),
 (107,103,1,'Rapports d\'activités','',1,1),
 (108,104,1,'Gestion des données','[BLOB]',1,1),
 (109,105,1,'Doc on line','[BLOB]',1,1);
