-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Lun 10 Novembre 2008 à 23:49
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Base de données: `gen-appli`
--

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

--
-- Structure de la table `colonnes-appli`
--

DROP TABLE IF EXISTS `colonnes-appli`;
CREATE TABLE `colonnes-appli` (
  `Application` varchar(24) collate utf8_bin NOT NULL default '',
  `Panneau` varchar(24) collate utf8_bin NOT NULL default '',
  `Colonne` varchar(32) collate utf8_bin NOT NULL default '',
  `Affichage` varchar(3) collate utf8_bin NOT NULL default 'C&D',
  `TitreColonne` varchar(64) collate utf8_bin default NULL,
  `Rang` int(4) NOT NULL default '9999',
  `Libelle` varchar(64) collate utf8_bin NOT NULL default '',
  `LargeurColonne` varchar(12) collate utf8_bin NOT NULL default '0',
  `Hauteur` int(11) default '0',
  `Position` enum('G','C','D','L','R') collate utf8_bin default NULL,
  `LargeurSaisie` int(11) NOT NULL default '0',
  `Clef` varchar(2) collate utf8_bin default NULL,
  `Substitut` varchar(24) collate utf8_bin default NULL,
  `TriDonnees` varchar(2) collate utf8_bin default NULL,
  `TypeDonnees` varchar(2) collate utf8_bin NOT NULL default 'C',
  `Obligatoire` tinyint(1) NOT NULL default '0',
  `Format` varchar(24) collate utf8_bin default NULL,
  `Complement` varchar(128) collate utf8_bin default NULL,
  PRIMARY KEY  (`Application`,`Panneau`,`Colonne`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table des colonnes des panneaux';

--
-- Contenu de la table `colonnes-appli`
--

INSERT INTO `colonnes-appli` (`Application`, `Panneau`, `Colonne`, `Affichage`, `TitreColonne`, `Rang`, `Libelle`, `LargeurColonne`, `Hauteur`, `Position`, `LargeurSaisie`, `Clef`, `Substitut`, `TriDonnees`, `TypeDonnees`, `Obligatoire`, `Format`, `Complement`) VALUES
('HeadHunter', 'Candidats', 'NoDossier', 'C&D', 'N° Dos.', 10, 'Numéro de dossier', '8%', 0, 'G', 6, '1', '', '', 'N', 0, NULL, ''),
('HeadHunter', 'Candidats', 'Nom', 'C&D', 'Nom', 21, 'Nom', '0', 0, 'G', 32, '', '', '1', 'C', 0, NULL, ''),
('HeadHunter', 'Candidats', 'Prenom', 'C&D', 'Prénom', 20, 'Prénom', '25%', 0, 'G', 32, '', '', '2', 'C', 0, '', ''),
('HeadHunter', 'Candidats', 'Naissance', 'C&D', 'Naissance', 50, 'Date de naissance', '12%', 0, 'D', 10, '', '', '', 'D', 0, 'j;m;A & J;M;A', '-60;-20'),
('HeadHunter', 'Candidats', 'NomMarital', 'C&D', 'Nom marital', 22, 'Nom marital', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Candidats', 'Disponibilite', 'C&D', 'Disponibilité', 100, 'Date de disponibilité', '12%', 0, 'D', 10, '', '', '', 'D', 0, 'j;m;A & J;M;A', '0;1'),
('HeadHunter', 'Candidats', 'Situation', 'DET', '', 80, 'Situation de famille', '0', 0, 'C', 1, '', '', '', 'S', 0, NULL, 'C=Célibataire;M=Marié(e);V=Veuf(ve);D=Divorcé(e);P=Pacsé(e)'),
('HeadHunter', 'Candidats', 'Sexe', 'C&D', 'Sexe', 70, 'Sexe', '8%', 0, 'C', 1, '', '', '', 'S', 0, NULL, 'M;F'),
('HeadHunter', 'Candidats', 'Nationalite2', 'DET', '', 65, 'Nationalité', '0', 0, 'G', 3, '', '', '', 'TB', 0, '', 'Table=Nations; Code=Code; Valeur=Nationalite'),
('TablesHunter', 'Metiers', 'Code_Metier', 'C&D', 'Code', 9999, 'Code métier', '15%', 0, '', 8, '1', '', '', 'C', 0, '', ''),
('TablesHunter', 'Metiers', 'Libelle', 'C&D', 'Libellé', 9999, 'Libellé', '75%', 0, '', 48, '', '', '', 'C', 0, NULL, ''),
('TablesHunter', 'Diplomes', 'Code', 'C&D', 'Code', 9999, 'Code diplome', '15%', 0, '', 8, '1', '', '', 'C', 0, '', ''),
('TablesHunter', 'Diplomes', 'Libelle', 'C&D', 'Libellé', 9999, 'Libellé', '75%', 0, '', 48, '', '', '1', 'C', 0, NULL, ''),
('HeadHunter', 'Formation', 'RangFormation', 'C&D', 'Rang', 20, 'Formation N°', '5%', 0, 'D', 2, '2', '', '2', '2', 1, NULL, ''),
('HeadHunter', 'Formation', 'NoDossier', 'C&D', 'Dossier', 10, 'N° de dossier', '12%', 0, 'G', 11, '1', 'MiniCandidats', '1', 'N', 0, NULL, ''),
('HeadHunter', 'Formation', 'Etablissement', 'C&D', 'Etablissement', 30, 'Etablissement', '30%', 0, 'G', 64, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Formation', 'Specialite', 'C&D', 'Spécialité', 40, 'Spécialité', '20%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Formation', 'AnneeSortie', 'C&D', 'Fin', 70, 'Année de Sortie', '10%', 0, 'C', 10, '', '', '', 'N', 0, NULL, ''),
('HeadHunter', 'MiniCandidats', 'NoDossier', 'DET', '', 1, 'Dossier N°', '0', 0, 'G', 0, '1', '', '', 'C', 0, NULL, 'NoDossier'),
('HeadHunter', 'MiniCandidats', 'Nom', 'DET', '', 2, 'Nom', '0', 0, 'G', 0, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'MiniCandidats', 'Prenom', 'DET', '', 3, 'Prenom', '0', 0, 'G', 0, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Application', 'Application', 'C&D', 'Code application', 10, 'Code application', '25%', 0, 'G', 24, '1', '', '2', 'C', 0, NULL, ''),
('GenApplication', 'Application', 'LargeurEcran', 'DET', '', 70, 'Largeur de l''écran', '0', 0, 'G', 6, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'CouleurFond', 'DET', '', 80, 'Couleur du fond', '0', 0, 'G', 16, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'CouleurTexte', 'DET', '', 120, 'Couleur du texte', '0', 0, 'C', 16, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'CouleurTitre', 'DET', '', 140, 'Couleur du Titre', '0', 0, '', 16, '', '', '', 'C', 1, '', ''),
('GenApplication', 'Application', 'CouleurMessage', 'DET', '', 160, 'Couleur des messages', '0', 0, '', 16, '', '', '', 'C', 1, '', ''),
('GenApplication', 'Application', 'Bandeau', 'DET', '', 170, 'Image du bandeau', '0', 0, 'G', 48, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'BoutonActif', 'DET', '', 180, 'Image du bouton actif', '0', 0, 'G', 32, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'BoutonInactif', 'DET', '', 190, 'Image du bouton inactif', '0', 0, 'G', 32, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'Filler', 'DET', '', 200, 'Image du filler', '0', 0, 'G', 32, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'NomApplication', 'C&D', 'Nom de l''application', 20, 'Nom de l''application', '65%', 0, 'G', 64, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Panneau', 'Application', 'C&D', 'Application', 10, 'Nom de l''application', '10%', 0, 'G', 24, '1', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Panneau', 'Panneau', 'C&D', 'Panneau', 20, 'Panneau', '10%', 0, 'G', 24, '2', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Panneau', 'TitrePanneau', 'C&D', 'Titre du Panneau', 40, 'Titre du Panneau', '30%', 0, 'G', 64, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Panneau', 'TypePanneau', 'C&D', 'Type', 50, 'Type de Panneau', '5%', 0, 'C', 1, '', '', '', 'S', 1, '', 'P=Panneau;T=Table;S=Substitut;C=Caché;V=Vide'),
('GenApplication', 'Application', 'BaseDonnees', 'DET', 'Base de données', 30, 'Nom de la base de données', '0', 0, 'G', 24, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Panneau', 'TableDonnees', 'C&D', 'Table', 60, 'Nom de la table', '10%', 0, 'G', 24, '', '', '', 'Y', 0, '', 'Code=NomTable;Valeur=NomTable'),
('GenApplication', 'Panneau', 'Intitule', 'DET', '', 80, 'Intitulé du bouton', '0', 0, '', 32, '', '', '', 'C', 1, '', ''),
('GenApplication', 'Panneau', 'BordureListe', 'DET', '', 100, 'Bordure de liste', '0', 0, 'G', 2, '', '', '', 'B', 1, '', ''),
('GenApplication', 'Panneau', 'Actions', 'DET', '', 120, 'Actions possibles (D,C,M,E,S,T)', '0', 0, '', 6, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Panneau', 'LargeurLibelle', 'DET', '', 140, 'Largeur du libellé', '0', 0, '', 6, '', '', '', 'C', 1, '', ''),
('GenApplication', 'Panneau', 'ConserveSelection', 'DET', '', 160, 'Maintien de la sélection courante', '0', 0, 'C', 3, '', '', '', 'B', 1, '', ''),
('GenApplication', 'Panneau', 'Routine', 'DET', '', 180, 'Nom du fichier de routines', '0', 0, 'G', 48, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Colonne', 'Application', 'C&D', 'Application', 10, 'Application', '0', 0, 'G', 24, '1', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Colonne', 'Panneau', 'C&D', 'Panneau', 20, 'Panneau', '0', 0, 'G', 24, '2', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Colonne', 'Colonne', 'C&D', 'Colonne', 30, 'Nom de la colonne (Rubrique)', '12%', 0, 'G', 32, '3', '', '', 'Y', 0, NULL, 'Code=NomColonne;Valeur=NomColonne'),
('GenApplication', 'Colonne', 'TitreColonne', 'C&D', 'En-tête', 40, 'Titre de la colonne', '16%', 0, 'G', 64, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Colonne', 'Rang', 'C&D', 'Rang', 60, 'Rang de la rubrique', '5%', 0, 'D', 4, '', '', '1', 'N', 0, NULL, ''),
('GenApplication', 'Colonne', 'Libelle', 'C&D', 'Libellé rubrique', 50, 'Libellé de la rubrique', '25%', 0, 'G', 64, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Colonne', 'LargeurColonne', 'C&D', 'Largeur', 70, 'Largeur de la colonne', '8%', 0, 'D', 12, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Colonne', 'Hauteur', 'DET', '', 80, 'Nombre de lignes (texte)', '0', 0, 'G', 3, '', '', '', 'N', 0, NULL, ''),
('GenApplication', 'Colonne', 'Position', 'DET', '', 90, 'Position (Gauche/Centre/Droite)', '0', 0, 'G', 1, '', '', '', 'S', 0, NULL, 'G;C;D'),
('GenApplication', 'Colonne', 'LargeurSaisie', 'DET', '', 100, 'Nombre maximum de caractères', '0', 0, '', 3, '', '', '', 'C', 1, NULL, ''),
('GenApplication', 'Colonne', 'Clef', 'C&D', 'Clef', 110, 'Clef N°', '5%', 0, 'D', 2, '', '', '', 'N', 0, NULL, ''),
('GenApplication', 'Colonne', 'Substitut', 'DET', '', 120, 'Panneau à substituter', '0', 0, 'G', 24, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Colonne', 'TriDonnees', 'C&D', 'Tri', 130, 'N° d''ordre de tri par défaut', '5%', 0, 'D', 2, '', '', '', 'N', 0, NULL, ''),
('GenApplication', 'Colonne', 'TypeDonnees', 'DET', '', 140, 'Type de donnée', '0', 0, 'G', 1, '', '', '', 'TB', 1, NULL, 'Table=controle-appli; Code=CodeControle; Valeur=Libelle'),
('GenApplication', 'Colonne', 'Obligatoire', 'DET', '', 150, 'Rubrique obligatoire', '0', 0, 'G', 1, '', '', '', 'B', 1, NULL, ''),
('GenApplication', 'Colonne', 'Complement', 'DET', '', 170, 'Complément', '0', 0, 'G', 80, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'CodeControle', 'Libelle', 'C&D', 'Libellé', 20, 'Libellé', '68%', 0, 'G', 64, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'CodeControle', 'CodeControle', 'C&D', 'Code', 10, 'Code', '12%', 0, 'G', 2, '1', '', '1', 'C', 0, '', ''),
('HeadHunter', 'Candidats', 'SalaireActuel', 'DET', '', 120, 'Rénumération actuelle', '0', 0, 'D', 8, '', '', '', 'N', 0, '0;'','';'' '';'' €''', ''),
('HeadHunter', 'Candidats', 'SalaireDemande', 'DET', '', 150, 'Rénumération désirée', '0', 0, 'D', 8, '', '', '', 'N', 0, '0;'','';'' '';'' €''', ''),
('HeadHunter', 'Candidats', 'Photo', 'DET', '', 90, 'Photo d''identité', '0', 0, 'G', 72, '', '', '', 'I', 0, NULL, ''),
('HeadHunter', 'Candidats', 'Metier', 'C&D', 'Metier', 110, 'Métier', '24%', 0, 'G', 20, '', '', '', 'TC', 0, '', 'Table=Metiers; Code=Code_Metier; Valeur=Libelle'),
('HeadHunter', 'Candidats', 'Nationalite1', 'DET', '', 60, 'Nationalité', '0', 0, 'G', 3, '', '', '', 'TB', 1, '', 'Table=Nations; Code=Code; Valeur=Nationalite'),
('TablesHunter', 'Pays', 'Code', 'C&D', 'Code pays', 10, 'Code du pays', '8%', 0, 'C', 3, '1', '', '1', 'C', 0, NULL, ''),
('TablesHunter', 'Pays', 'Libelle', 'C&D', 'Libellé', 20, 'Libellé', '25%', 0, 'G', 32, '1', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Adresses', 'NoDossier', 'C&D', 'N° Dossier', 10, 'Numéro de dossier', '8%', 0, 'G', 8, '1', 'MiniCandidats', '', 'N', 0, NULL, ''),
('HeadHunter', 'Adresses', 'RangAdresse', 'C&D', 'Rang', 20, 'Rang', '5%', 0, 'D', 2, '2', '', '1', '2', 0, NULL, ''),
('HeadHunter', 'Adresses', 'Adresse', 'C&D', 'Adresse', 30, 'Adresse', '36%', 4, 'G', 64, '', '', '', 'L', 0, NULL, ''),
('HeadHunter', 'Adresses', 'CodePostal', 'C&D', 'Code postal', 40, 'Code postal', '5%', 0, 'C', 10, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Adresses', 'Ville', 'C&D', 'Ville', 50, 'Ville', '15%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Adresses', 'Pays', 'C&D', 'Pays', 50, 'Pays', '20%', 0, 'G', 3, '', '', '', 'TC', 0, NULL, 'Table=Nations; Code=Code; Valeur=Libelle'),
('GenApplication', 'Panneau', 'Rang', 'C&D', 'Rang', 30, 'Rang du Bouton', '3%', 0, 'D', 3, '', '', '1', 'N', 0, '', ''),
('HeadHunter', 'Employeur', 'NoDossier', 'C&D', 'N° Dossier', 10, 'Numéro de dossier', '8%', 0, 'D', 8, '1', 'MiniCandidats', '1', 'N', 1, NULL, ''),
('HeadHunter', 'Employeur', 'RangEmployeur', 'C&D', 'Rang', 20, 'Numéro d''ordre', '8%', 0, 'D', 3, '2', '', '2', '2', 0, NULL, ''),
('HeadHunter', 'Employeur', 'Societe', 'C&D', 'Employeur', 30, 'Nom de l''employeur', '25%', 0, 'G', 48, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Employeur', 'Secteur', 'C&D', 'Secteur', 40, 'Secteur d''activité', '8%', 0, 'G', 12, '', '', '', 'TB', 0, NULL, 'Table=Secteurs; Code=Code; Valeur=Libelle'),
('HeadHunter', 'Employeur', 'Debut', 'C&D', 'Début', 80, 'Date de début', '10%', 0, 'C', 10, '', '', '', 'D', 0, NULL, '-20;0'),
('HeadHunter', 'Employeur', 'Fin', 'C&D', 'Fin', 90, 'Date de fin', '10%', 0, 'C', 10, '', '', '', 'D', 0, NULL, '-20;0'),
('TablesHunter', 'Secteurs', 'Code', 'C&D', 'Code', 10, 'Code du secteur', '15%', 0, 'G', 12, '1', '', '', 'C', 0, NULL, ''),
('TablesHunter', 'Secteurs', 'Libelle', 'C&D', 'Libellé', 20, 'Libellé du secteur', '75%', 0, 'G', 48, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Panneau', 'BordureDetail', 'DET', '', 110, 'Bordure de détail', '0', 0, 'G', 1, '', '', '', 'B', 0, '', ''),
('HeadHunter', 'Langues', 'NoDossier', 'C&D', 'N° Dossier', 10, 'Numéro de dossier', '20%', 0, 'D', 8, '1', 'MiniCandidats', '1', 'N', 1, NULL, ''),
('HeadHunter', 'Langues', 'RangLangue', 'C&D', 'Rang', 20, 'Numéro d''ordre', '10%', 0, 'D', 3, '2', '', '', '2', 1, NULL, ''),
('HeadHunter', 'Langues', 'Langue', 'C&D', 'Langue', 30, 'Langue', '40%', 0, 'G', 3, '', '', '', 'TC', 1, NULL, 'Table=Nations; Code=Code; Valeur=Langue'),
('HeadHunter', 'Langues', 'Niveau', 'C&D', 'Niveau', 40, 'Niveau', '40%', 0, 'G', 12, '', '', '', 'S', 1, NULL, 'Basic;Ecrit;Ecrit+Parlé;Courant;Bilingue'),
('TablesHunter', 'Languages', 'Code', 'C&D', 'Code', 10, 'Code language', '20%', 0, 'G', 3, '1', '', '', 'C', 1, NULL, ''),
('TablesHunter', 'Languages', 'Libelle', 'C&D', 'Libellé', 20, 'Libellé du language', '70%', 0, 'G', 16, '', '', '', 'C', 1, NULL, ''),
('HeadHunter', 'Contacts', 'NoDossier', 'C&D', 'N° Dossier', 10, 'Numéro de dossier', '8%', 0, 'D', 8, '1', 'MiniCandidats', '1', 'N', 1, NULL, ''),
('HeadHunter', 'Contacts', 'RangContact', 'C&D', 'Rang', 20, 'Numéro d''ordre', '5%', 0, 'D', 3, '2', '', '2', '2', 0, NULL, ''),
('HeadHunter', 'Contacts', 'Date', 'C&D', 'Date', 30, 'Date du contact', '8%', 0, 'C', 10, '', '', '', 'D', 1, NULL, '-10;0'),
('HeadHunter', 'Contacts', 'Type', 'C&D', 'Type', 31, 'Type de contact', '0', 0, 'C', 12, '', '', '', 'S', 1, NULL, 'Réunion;Téléphone;Email;Courrier'),
('HeadHunter', 'Contacts', 'Commentaires', 'C&D', 'Commentaires', 50, 'Commentaires', '75%', 200, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('GenApplication', 'Application', 'Police', 'DET', '', 100, 'Police', '0', 0, 'G', 16, '', '', '', 'S', 1, '', 'Arial;Comic Sans MS;Courier;Garamond;Times New Roman;Trebuchet MS;Verdana'),
('GenApplication', 'Application', 'TailleTexte', 'DET', '', 110, 'Taille du texte', '0', 0, 'G', 16, '', '', '', 'C', 1, '', ''),
('GenApplication', 'Application', 'TailleTitre', 'DET', '', 130, 'Taille du titre', '0', 0, 'G', 16, '', '', '', 'C', 0, '', ''),
('GenApplication', 'Application', 'TailleMessage', 'DET', '', 150, 'Taille des messages', '0', 0, 'G', 16, '', '', '', 'C', 0, '', ''),
('HeadHunter', 'Documents', 'NoDossier', 'C&D', 'N° Dossier', 10, 'Numéro de Dossier', '7%', 0, 'D', 8, '1', 'MiniCandidats', '', 'N', 1, '', ''),
('HeadHunter', 'Documents', 'RangDocument', 'C&D', 'Rang', 20, 'Numéro d''ordre', '5%', 0, 'D', 3, '2', '', '1', '2', 1, '', ''),
('HeadHunter', 'Documents', 'DateDocument', 'C&D', 'Date document', 30, 'Date du document', '8%', 0, 'C', 10, '', '', '', 'D', 1, '', '-10;0'),
('HeadHunter', 'Documents', 'Type', 'C&D', 'Type', 60, 'Type de document', '12%', 0, 'G', 12, '', '', '', 'S', 1, '', 'CV=C.V.;LI=Lettre d''intention;LC=Lettre et C.V.;LE=Lettre;AD=Autre document'),
('HeadHunter', 'Documents', 'Document', 'C&D', 'Document', 70, 'Fichier du document', '24%', 0, 'G', 90, '', '', '', 'O', 0, '', ''),
('HeadHunter', 'Tel-Email', 'NoDossier', 'C&D', 'N° Dossier', 10, 'Numéro de dossier', '12%', 0, 'D', 8, '1', 'MiniCandidats', '', 'N', 1, NULL, ''),
('HeadHunter', 'Tel-Email', 'RangTel', 'C&D', 'Rang', 20, 'Rang', '8%', 0, 'D', 3, '2', '', '1', '2', 1, NULL, ''),
('GenApplication', 'Panneau', 'EnTeteInverse', 'DET', '', 90, 'En-tête inversée', '0', 0, 'G', 1, '', '', '', 'B', 1, '', ''),
('ClientHunter', 'Client', 'CodeClient', 'C&D', 'Code', 10, 'Code Client', '8%', 0, 'G', 8, '1', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Client', 'RaisonSociale', 'C&D', 'Raison sociale', 20, 'Raison sociale', '20%', 0, 'G', 32, '', '', '1', 'C', 0, NULL, ''),
('ClientHunter', 'Client', 'CodeGroupe', 'C&D', 'Groupe', 30, 'Groupe', '16%', 0, 'G', 8, '', '', '', 'TC', 0, NULL, 'Table=Groupes; Code=Code; Valeur=Libelle'),
('ClientHunter', 'Client', 'CodeSecteur', 'DET', '', 40, 'Secteur d''activité', '8%', 0, 'G', 8, '', '', '', 'TA', 0, NULL, 'Table=Secteurs; Code=Code; Valeur=Libelle'),
('ClientHunter', 'Client', 'Adresse', 'DET', '', 50, 'Adresse', '0', 4, 'G', 64, '', '', '', 'L', 0, NULL, ''),
('ClientHunter', 'Client', 'CodePostal', 'DET', '', 60, 'Code postal', '0', 0, 'G', 10, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Client', 'Ville', 'C&D', 'Ville', 70, 'Ville', '15%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Client', 'Telephone', 'C&D', 'Téléphone', 80, 'N° de téléphone', '12%', 0, 'G', 16, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Client', 'Fax', 'C&D', 'Fax', 90, 'N° de fax', '12%', 0, 'G', 16, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Client', 'SiteWeb', 'DET', '', 100, 'Site Web', '0', 0, 'G', 64, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Responsable', 'CodeClient', 'DET', '', 10, 'Code client', '0', 0, 'G', 8, '1', 'SubstitutClient', '', 'C', 1, NULL, ''),
('ClientHunter', 'Responsable', 'CodeResp', 'C&D', 'Code', 20, 'Code du responsable', '8%', 0, 'G', 8, '2', '', '1', 'C', 1, NULL, ''),
('ClientHunter', 'Responsable', 'NomResp', 'C&D', 'Nom', 30, 'Nom du responsable', '30%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Responsable', 'PrenomResp', 'C&D', 'Prénom', 31, 'Prénom du responsable', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Responsable', 'Telephone', 'C&D', 'Téléphone', 40, 'Numéro de téléphone', '16%', 0, 'G', 16, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Responsable', 'Email', 'C&D', 'E-mail', 50, 'Adresse e-mail', '32%', 0, 'G', 48, '', '', '', 'M', 0, NULL, ''),
('ClientHunter', 'Responsable', 'Commentaires', 'DET', '', 60, 'Commentaires', '0', 150, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('ClientHunter', 'Mission', 'CodeClient', 'DET', '', 10, 'Société', '0', 0, 'G', 8, '1', 'SubstitutClient', '', 'C', 0, NULL, ''),
('ClientHunter', 'Mission', 'CodeResp', 'DET', '', 20, 'Responsable', '0', 0, 'G', 8, '2', 'SubstitutResponsable', '', 'C', 0, NULL, ''),
('ClientHunter', 'Mission', 'Numero', 'C&D', 'N°', 30, 'Numéro de mision', '8%', 0, 'D', 3, '3', '', '1', '2', 0, NULL, ''),
('ClientHunter', 'Mission', 'Libelle', 'C&D', 'Libellé', 40, 'Libellé', '32%', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Mission', 'Metier', 'C&D', 'Métier', 50, 'Métier demandé', '16%', 0, 'G', 8, '', '', '', 'TC', 0, NULL, 'Table=Metiers; Code=Code; Valeur=Libelle'),
('ClientHunter', 'Mission', 'DateDebut', 'C&D', 'Début', 60, 'Date de début', '12%', 0, 'C', 10, '', '', '', 'D', 1, NULL, '0;1'),
('ClientHunter', 'Mission', 'DateFin', 'C&D', 'Fin', 70, 'Date de fin', '12%', 0, 'C', 10, '', '', '', 'D', 0, NULL, '0;1'),
('ClientHunter', 'Mission', 'Etat', 'C&D', 'Etat', 100, 'Etat de la mission', '8%', 0, 'C', 3, '', '', '', 'S', 1, NULL, 'E-C;TER'),
('ClientHunter', 'Mission', 'Description', 'DET', '', 110, 'Description de la mission', '0', 120, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('ClientHunter', 'Postulants', 'CodeClient', 'DET', '', 10, 'Code client', '0', 0, 'G', 8, '1', 'SubstitutClient', '', 'C', 0, NULL, ''),
('ClientHunter', 'Postulants', 'CodeResp', 'DET', '', 20, 'Code responsable', '0', 0, 'G', 8, '2', 'SubstitutResponsable', '', 'C', 0, NULL, ''),
('ClientHunter', 'Postulants', 'Numero', 'DET', '', 30, 'Numéro de mission', '0', 0, 'G', 3, '3', 'SubstitutMission', '', 'N', 1, NULL, ''),
('ClientHunter', 'Postulants', 'NoDossier', 'C&D', 'N° dossier', 40, 'Numéro de dossier du candidat', '16%', 0, 'D', 11, '4', 'SubstitutCandidat', '1', 'J', 0, NULL, 'ClientHunter;NoDossier'),
('ClientHunter', 'Postulants', 'Statut', 'C&D', 'Statut', 70, 'Statut de la candidature', '5%', 0, 'C', 3, '', '', '', 'S', 1, NULL, 'CAN;S-L;OK'),
('ClientHunter', 'SubstitutCandidat', 'NoDossier', 'C&D', 'Dossier', 10, 'Numéro de dossier', '10%', 0, 'D', 8, '1', '', '1', 'C', 0, NULL, 'NoDossier'),
('ClientHunter', 'SubstitutCandidat', 'Nom', 'C&D', 'Nom', 20, 'Nom du postulant', '24%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'SubstitutCandidat', 'Prenom', 'C&D', 'Prénom', 21, 'Prénom du postulant', '0', 0, 'G', 32, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'SubstitutClient', 'CodeClient', '', '', 10, '', '30%', 0, 'G', 48, '1', '', '', 'C', 1, NULL, 'CodeClient'),
('ClientHunter', 'SubstitutResponsable', 'CodeClient', '', '', 10, '', '0', 0, 'G', 8, '1', '', '', 'C', 1, NULL, 'CodeClient'),
('ClientHunter', 'SubstitutResponsable', 'CodeResp', '', '', 20, '', '0', 0, 'G', 8, '2', '', '', 'C', 0, NULL, 'CodeResp'),
('ClientHunter', 'SubstitutResponsable', 'NomResp', 'DET', '', 30, 'Nom du responsable', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'SubstitutClient', 'RaisonSociale', 'DET', '', 20, 'Société', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'SubstitutResponsable', 'PrenomResp', 'DET', '', 40, 'Prénom du responsable', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Postulants', 'Remarques', 'C&D', 'Remarques', 80, 'Remarques', '70%', 150, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('ClientHunter', 'Candidats', 'NoDossier', 'C&D', 'N° Dos.', 10, 'Numéro de dossier', '8%', 0, 'G', 6, '1', '', '', 'N', 0, NULL, ''),
('ClientHunter', 'Candidats', 'Nom', 'DET', 'Nom', 21, 'Nom', '', 0, 'G', 32, '', '', '1', 'C', 0, NULL, ''),
('ClientHunter', 'Candidats', 'PrenomNom', 'COL', 'Nom', 19, 'Prénom, nom, nom marital', '36%', 0, 'G', 32, '', '', '', 'ZC', 0, NULL, 'IF(`NomMarital`<>'''',CONCAT(`Prenom`,'' '',`Nom`,''-'',`NomMarital`),CONCAT(`Prenom`,'' '',`Nom`))'),
('ClientHunter', 'Candidats', 'Naissance', 'C&D', 'Naissance', 50, 'Date de naissance', '12%', 0, 'C', 10, '', '', '', 'D', 0, NULL, ''),
('ClientHunter', 'Candidats', 'NomMarital', 'DET', 'Nom marital', 22, 'Nom marital', '', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('ClientHunter', 'Candidats', 'Disponibilite', 'C&D', 'Disponibilité', 100, 'Date de disponibilité', '12%', 0, 'C', 10, '', '', '', 'D', 0, NULL, ''),
('ClientHunter', 'Candidats', 'Situation', 'DET', '', 80, 'Situation de famille', '', 1, 'C', 1, '', '', '', 'S', 0, NULL, 'C;M;V;D;P'),
('ClientHunter', 'Candidats', 'Sexe', 'C&D', 'Sexe', 70, 'Sexe', '8%', 1, 'C', 1, '', '', '', 'S', 0, NULL, 'M;F'),
('ClientHunter', 'Candidats', 'Nationalite1', 'C&D', 'Nat.', 65, 'Nationalité', '5%', 0, 'G', 3, '', '', '', 'TB', 0, '', 'Table=Nations; Code=Code; Valeur=Libelle'),
('GenApplication', 'Panneau', 'LignesParPage', 'DET', '', 150, 'Nb de lignes par page', '0', 0, 'D', 3, '', '', '', 'N', 0, '', ''),
('GenApplication', 'Application', 'TableRequetes', 'DET', '', 210, 'Table des requêtes', '0', 0, 'G', 24, '', '', '', 'C', 0, '', ''),
('TablesHunter', 'Requetes', 'Application', 'C&D', 'Application', 10, 'Application', '18%', 0, 'G', 24, '', '', '1', 'C', 1, NULL, ''),
('TablesHunter', 'Requetes', 'Panneau', 'C&D', 'Panneau', 20, 'Panneau', '18%', 0, 'G', 24, '', '', '2', 'C', 1, NULL, ''),
('TablesHunter', 'Requetes', 'Auteur', 'C&D', 'Auteur', 30, 'Auteur', '18%', 0, 'G', 24, '', '', '3', 'C', 1, NULL, ''),
('TablesHunter', 'Requetes', 'NomRequete', 'C&D', 'Requête', 40, 'Nom de la requête', '20%', 0, 'G', 24, '', '', '4', 'C', 1, NULL, ''),
('TablesHunter', 'Requetes', 'Commun', 'C&D', 'Com.', 40, 'Requete commune', '5%', 0, 'C', 3, '', '', '', 'B', 0, NULL, ''),
('TablesHunter', 'Requetes', 'Modifiable', 'C&D', 'Modi.', 60, 'Requête modifiable', '5%', 0, 'C', 3, '', '', '', 'B', 0, NULL, ''),
('TablesHunter', 'Requetes', 'Where', 'DET', '', 70, 'Libellé de la requête', '0', 4, 'G', 72, '', '', '', 'L', 1, NULL, ''),
('TablesHunter', 'Requetes', 'AvecOrder', 'DET', '', 80, 'Clause ORDER incluse', '0', 0, 'G', 3, '', '', '', 'B', 1, NULL, ''),
('TablesHunter', 'Requetes', 'Order', 'DET', '', 90, 'Clause ORDER', '0', 3, 'G', 72, '', '', '', 'L', 0, NULL, ''),
('TablesHunter', 'Requetes', 'Numero', '', '', 1, '', '4%', 0, 'D', 6, '1', '', '', '1', 1, NULL, ''),
('HeadHunter', 'Tel-Email', 'Mode', 'C&D', 'Mode', 30, 'Mode de communication', '10%', 0, 'G', 8, '', '', '', 'S', 1, NULL, 'Tel-Priv;Tel-Prof;Fax;Mobile;E-mail'),
('HeadHunter', 'Tel-Email', 'Numero', 'C&D', 'Numéro/Adresse', 40, 'Numéro ou adresse', '70%', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('TestAppli', 'Securite', 'Application', 'C&D', 'Application', 9999, 'Code Application', '25%', 1, NULL, 8, 'K', NULL, NULL, 'S', 0, NULL, '/A/C/E/F/'),
('GenApplication', 'Application', 'Securite', 'DET', '', 40, 'Application sécurisée', '0', 0, 'G', 1, '', '', '', 'B', 0, '', ''),
('GenEspace', 'Espace', 'Espace', 'C&D', 'Nom espace', 10, 'Nom de l''espace', '25%', 0, 'G', 24, '1', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Espace', 'NomEspace', 'C&D', 'Titre de l''espace', 20, 'Titre de l''espace', '65%', 0, 'G', 90, '', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Espace', 'LargeurVolet', 'DET', '', 30, 'Largeur du volet gauche', '0', 0, 'D', 6, '', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Espace', 'LargeurAppli', 'DET', '', 40, 'Largeur de la partie applicative', '0', 0, 'D', 6, '', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Espace', 'CouleurFond', 'DET', '', 50, 'Couleur du volet gauche', '0', 0, 'G', 16, '', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Espace', 'Police', 'DET', '', 60, 'Police de caractères', '0', 0, 'G', 16, '', '', '', 'S', 1, NULL, 'Arial;Comic Sans MS;Courier;Garamond;Times New Roman;Trebuchet MS;Verdana'),
('GenEspace', 'Espace', 'TailleTexte', 'DET', '', 70, 'Taille de la police de caractères', '0', 0, 'G', 16, '', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Espace', 'CouleurTexte', 'DET', '', 80, 'Couleur du texte', '0', 0, 'G', 16, '', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Espace', 'Bandeau', 'DET', '', 90, 'Fichier bandeau', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('GenEspace', 'Espace', 'BoutonActif', 'DET', '', 100, 'Fichier bouton actif', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('GenEspace', 'Espace', 'BoutonInactif', 'DET', '', 110, 'Fichier bouton inactif', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('GenEspace', 'Espace', 'MotDePasse', 'DET', '', 120, 'Application protégée par mot de passe', '0', 0, 'G', 1, '', '', '', 'B', 1, NULL, ''),
('GenEspace', 'Espace', 'TexteAccueil', 'DET', '', 140, 'Texte d''accueil', '0', 120, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('GenEspace', 'Applications', 'Espace', 'DET', '', 10, 'Espace de travail', '0', 0, 'G', 32, '1', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Applications', 'ModeAppli', 'C&D', 'Application générée', 40, 'Application générée', '15%', 0, 'C', 1, '', '', '', 'B', 1, NULL, ''),
('GenEspace', 'Applications', 'NomFrame', 'C&D', 'Application ou page', 20, 'Application ou page', '40%', 0, 'G', 64, '2', '', '', 'C', 1, NULL, ''),
('GenEspace', 'Applications', 'Rang', 'C&D', 'Rang', 50, 'Rang du bouton', '10%', 0, 'D', 3, '', '', '1', 'N', 1, NULL, ''),
('GenEspace', 'Applications', 'IntituleBouton', 'C&D', 'Intitulé', 30, 'Intitulé du bouton', '20%', 0, 'G', 24, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Client', 'Pays', 'DET', '', 75, 'Pays', '0', 0, 'G', 3, '', '', '', 'TC', 1, NULL, 'Table=Nations; Code=Code; Valeur=Libelle'),
('ClientHunter', 'Action', 'CodeClient', 'DET', '', 10, 'Client', '0', 0, 'G', 8, '1', 'SubstitutClient', '', 'C', 1, NULL, ''),
('ClientHunter', 'Action', 'CodeResp', 'DET', '', 20, 'Responsable', '0', 0, 'G', 8, '2', 'SubstitutResponsable', '', 'C', 1, NULL, ''),
('ClientHunter', 'Action', 'Numero', 'DET', '', 30, 'Numéro de mission', '0', 0, 'G', 6, '3', 'SubstitutMission', '', '2', 1, NULL, ''),
('ClientHunter', 'Action', 'Rang', 'C&D', 'Rang', 40, 'Rang de l''action', '3%', 0, 'D', 6, '4', '', '1', '2', 0, NULL, ''),
('ClientHunter', 'Action', 'DateAction', 'C&D', 'Date prévue', 50, 'Date', '8%', 0, 'C', 10, '', '', '', 'D', 0, NULL, '0;1'),
('ClientHunter', 'Action', 'DateLimite', 'C&D', 'Date limite', 60, 'Date limite', '8%', 0, 'C', 10, '', '', '', 'D', 0, NULL, '0;1'),
('ClientHunter', 'Action', 'Statut', 'C&D', 'Statut', 70, 'Statut', '10%', 0, 'C', 8, '', '', '', 'S', 1, NULL, 'A FAIRE;EN COURS;FAIT'),
('ClientHunter', 'Action', 'Action', 'C&D', 'Action', 80, 'Action', '30%', 120, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('ClientHunter', 'SubstitutMission', 'CodeClient', '', '', 10, '', '0', 0, 'G', 0, '1', '', '', 'C', 1, NULL, 'CodeClient'),
('ClientHunter', 'SubstitutMission', 'CodeResp', '', '', 20, '', '0', 0, 'G', 0, '2', '', '', 'C', 1, NULL, 'CodeResp'),
('ClientHunter', 'SubstitutMission', 'Numero', '', '', 30, '', '0', 0, 'G', 0, '3', '', '', 'N', 1, NULL, 'Numero'),
('ClientHunter', 'SubstitutMission', 'Libelle', 'DET', '', 40, 'Mission', '0', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Postulants', 'DateProposition', 'DET', '', 50, 'Date de la proposition au client', '0', 0, 'G', 10, '', '', '', 'D', 1, NULL, '-1;1'),
('ClientHunter', 'Postulants', 'DateAccord', 'DET', '', 60, 'Date de l''accord du client', '0', 0, 'G', 10, '', '', '', 'D', 0, NULL, '-1;1'),
('HeadHunter', 'Formation', 'Diplome', 'C&D', 'Diplome', 50, 'Diplome', '10%', 0, 'G', 8, '', '', '', 'TB', 0, NULL, 'Table=Diplomes; Code=Code; Valeur=Libelle'),
('HeadHunter', 'Formation', 'AnneeEntree', 'C&D', 'Debut', 60, 'Année d''entrée', '10%', 0, 'C', 4, '', '', '', 'N', 1, NULL, ''),
('HeadHunter', 'Employeur', 'Cadre', 'C&D', 'Cadre', 50, 'Position de cadre', '5%', 1, 'C', 3, '', '', '', 'B', 1, NULL, ''),
('HeadHunter', 'Employeur', 'Position', 'C&D', 'Position', 60, 'Position dans la société', '16%', 1, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Employeur', 'Specialite', 'DET', '', 70, 'Spécialité', '0', 1, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('TablesHunter', 'Pays', 'Nationalite', 'C&D', 'Nationalité', 30, 'Nationalité', '25%', 0, 'G', 32, '', '', '', 'C', 1, NULL, ''),
('TablesHunter', 'Pays', 'Langue', 'C&D', 'Langue', 40, 'Langue', '25%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('GenApplication', 'Panneau', 'Filtre', 'DET', '', 170, 'Filtre appliqué à la table', '0', 3, 'G', 60, '', '', '', 'L', 0, '', ''),
('ClientHunter', 'Action', 'TypeAction', 'C&D', 'Type', 45, 'Type d''action', '20%', 0, 'G', 8, '', '', '', 'S', 1, NULL, 'Appel;Courrier;E-mail;RdV;Réunion'),
('ClientHunter', 'Action', 'HeureAction', 'C&D', 'Heure', 51, 'Heure prévue', '6%', 0, 'C', 5, '', '', '', 'H', 0, NULL, '09:00;20:00;15'),
('ClientHunter', 'Candidatures', 'NoDossier', 'DET', '', 10, 'Numero de dossier', '0', 0, 'G', 8, '1', 'SubstitutNoDossier', '', 'N', 0, NULL, ''),
('ClientHunter', 'Candidatures', 'Rang', '', '', 20, '', '0', 0, 'G', 6, '2', '', '', '1', 1, NULL, ''),
('ClientHunter', 'Candidatures', 'CodeClient', 'C&D', 'Client', 30, 'Client', '30%', 0, 'G', 32, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Candidatures', 'Numero', 'C&D', 'Mission', 35, 'Mission', '30%', 0, 'G', 32, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Candidatures', 'CodeResp', 'C&D', 'Responsable', 31, 'Responsable', '30%', 0, 'G', 8, '', '', '', 'TA', 1, NULL, 'Table=Responsables; Code=CodeResp;Valeur=NomResp'),
('ClientHunter', 'Candidatures', 'DateProposition', 'C&D', 'Date Propos.', 40, 'Date de la proposition', '10%', 0, 'C', 10, '', '', '', 'D', 1, NULL, ''),
('ClientHunter', 'Candidatures', 'DateAccord', 'C&D', 'Date Accord', 50, 'Date de la proposition', '10%', 0, 'C', 10, '', '', '', 'D', 1, NULL, ''),
('ClientHunter', 'Candidatures', 'Statut', 'C&D', 'Statut', 60, 'Statut de la proposition', '10%', 0, 'C', 3, '', '', '', 'S', 1, NULL, 'CAN;S-L;OK'),
('ClientHunter', 'Candidatures', 'Remarques', 'DET', '', 70, 'Remarques', '0', 150, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('ClientHunter', 'SubstitutNoDossier', 'NoDossier', 'DET', '', 10, 'Numéro de dossier', '0', 0, 'G', 8, '1', '', '', 'N', 1, NULL, 'NoDossier'),
('ClientHunter', 'SubstitutNoDossier', 'Nom', 'DET', '', 20, 'Nom', '0', 0, 'G', 32, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'SubstitutNoDossier', 'Prenom', 'DET', '', 30, 'Prénom', '0', 0, 'G', 32, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Action', 'DateCreation', 'DET', '', 42, 'Crée le', '0', 1, 'G', 20, '', '', '', '3', 0, NULL, ''),
('AgendaHunter', 'Rendez-vous', 'CodeClient', 'C&D', 'Client', 10, 'Client', '30%', 0, 'G', 8, '1', '', '', 'TC', 0, NULL, 'Table=Clients; Code=CodeClient; Valeur=RaisonSociale'),
('AgendaHunter', 'Rendez-vous', 'CodeResp', 'C&D', 'Responsable', 11, 'Responsable', '30%', 0, 'G', 8, '', '', '', 'TA', 0, NULL, 'Table=Responsables; Code=CodeResp;Valeur=NomResp'),
('AgendaHunter', 'Rendez-vous', 'TypeAction', 'C&D', 'Activité', 20, 'Activité', '20%', 0, 'G', 8, '', '', '', 'C', 1, NULL, ''),
('AgendaHunter', 'Rendez-vous', 'DateAction', 'C&D', 'Date', 30, 'Date', '8%', 0, 'C', 10, '', '', '1', 'D', 1, NULL, ''),
('AgendaHunter', 'Rendez-vous', 'HeureAction', 'C&D', 'Heure', 40, 'Heure', '6%', 0, 'C', 5, '', '', '2', 'H', 1, NULL, ''),
('AgendaHunter', 'Rendez-vous', 'Action', 'C&D', 'Motif', 50, 'Motif', '50%', 100, 'G', 480, '', '', '', 'E', 1, NULL, ''),
('AgendaHunter', 'Rendez-vous', 'Numero', 'C&D', 'Mission', 12, 'Mission', '30%', 0, 'G', 40, '', '', '', 'C', 1, NULL, ''),
('ClientHunter', 'Action', 'Interlocuteur', 'C&D', 'Personne', 46, 'Personne', '20%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('AgendaHunter', 'Rendez-vous', 'Interlocuteur', 'C&D', 'Personne', 21, 'Personne', '20%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('AgendaHunter', 'A-Faire', 'CodeClient', 'C&D', 'Client', 10, 'Client', '30%', 0, 'G', 32, '1', '', '', 'TC', 0, NULL, 'Table=Clients; Code=CodeClient; Valeur=RaisonSociale'),
('AgendaHunter', 'A-Faire', 'CodeResp', 'C&D', 'Responsable', 11, 'Responsable', '30%', 0, 'G', 32, '', '', '', 'TA', 0, NULL, 'Table=Responsables; Code=CodeResp;Valeur=NomResp'),
('AgendaHunter', 'A-Faire', 'Numero', 'C&D', 'Mission', 12, 'Mission', '30%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('AgendaHunter', 'A-Faire', 'TypeAction', 'C&D', 'Action', 20, 'Action', '20%', 0, 'G', 8, '', '', '', 'C', 0, NULL, ''),
('AgendaHunter', 'A-Faire', 'Interlocuteur', 'C&D', 'Personne', 21, 'Personne', '20%', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('AgendaHunter', 'A-Faire', 'DateLimite', 'C&D', 'Date limite', 30, 'Date limite', '8%', 0, 'C', 10, '', '', '1', 'D', 1, NULL, ''),
('AgendaHunter', 'A-Faire', 'Action', 'C&D', 'Action', 40, 'Action', '40%', 100, 'G', 480, '', '', '', 'E', 0, NULL, ''),
('AgendaHunter', 'A-Faire', 'Alerte', 'C&D', 'Alerte', 1, 'Alerte', '6%', 0, 'C', 8, '', '', '', 'ZC', 1, '', ''''''),
('ClientHunter', 'Action', 'Utilisateur', '', '', 90, 'Consultant', '0', 0, 'G', 32, '', '', '', '0', 0, NULL, ''),
('GenApplication', 'Panneau', 'TableParent', 'C&D', 'Table Parent', 70, 'Table parent', '10%', 0, 'G', 49, '', '', '', 'Y', 0, '', 'Code=NomTable;Valeur=NomTable'),
('ClientHunter', 'Candidats', 'Metier', 'C&D', 'Métier', 90, 'Métier souhaité', '15%', 0, 'G', 32, '', '', '', 'TC', 0, '', 'Table=Metiers; Code=Code_Metier; Valeur=Libelle'),
('DocHunter', 'Demarrage', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Demarrage', 'Chapitre', '', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, NULL, 'DEM'),
('DocHunter', 'Demarrage', 'Rang', '', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, '', ''),
('DocHunter', 'Demarrage', 'Sujet', 'COL', 'Sujet', 40, '', '75%', 0, 'G', 64, '', '', '', 'C', 1, '', ''),
('DocHunter', 'Demarrage', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, '', ''),
('DocHunter', 'Demarrage', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, '', ''),
('DocHunter', 'Demarrage', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, '', ''),
('GenApplication', 'Application', 'CouleurMenu', 'DET', '', 90, 'Couleur des menus', '0', 0, 'G', 16, '', '', '', 'C', 1, '', ''),
('DocHunter', 'Navigation', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Navigation', 'Chapitre', 'COL', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, '', 'NAV'),
('DocHunter', 'Navigation', 'Rang', '', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, '', ''),
('DocHunter', 'Navigation', 'Sujet', 'COL', 'Sujet', 40, '', '75%', 0, 'G', 64, '', '', '', 'C', 1, '', ''),
('DocHunter', 'Navigation', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, '', ''),
('DocHunter', 'Navigation', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, '', ''),
('DocHunter', 'Navigation', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, '', ''),
('DocHunter', 'Selection', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Selection', 'Chapitre', '', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, NULL, 'SEL'),
('DocHunter', 'Selection', 'Rang', 'COL', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, NULL, ''),
('DocHunter', 'Selection', 'Sujet', 'C&D', 'Sujet', 40, '', '75%', 0, 'G', 64, '', '', '', 'C', 1, '', ''),
('DocHunter', 'Selection', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, '', ''),
('DocHunter', 'Selection', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, '', ''),
('DocHunter', 'Selection', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, '', ''),
('DocHunter', 'Mise à jour', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Mise à jour', 'Chapitre', '', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, NULL, 'CAN'),
('DocHunter', 'Mise à jour', 'Rang', 'COL', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, NULL, ''),
('DocHunter', 'Mise à jour', 'Sujet', 'C&D', 'Sujet', 40, ' &nbsp;', '75%', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('DocHunter', 'Mise à jour', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Mise à jour', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, NULL, ''),
('DocHunter', 'Mise à jour', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Candidats', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Candidats', 'Chapitre', '', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, NULL, 'CLI'),
('DocHunter', 'Candidats', 'Rang', 'COL', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, NULL, ''),
('DocHunter', 'Candidats', 'Sujet', 'C&D', 'Sujet', 40, '', '75%', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('DocHunter', 'Candidats', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Candidats', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, NULL, ''),
('DocHunter', 'Candidats', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Clients', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Clients', 'Chapitre', '', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, NULL, 'AGE'),
('DocHunter', 'Clients', 'Rang', 'COL', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, NULL, ''),
('DocHunter', 'Clients', 'Sujet', 'C&D', 'Sujet', 40, '', '75%', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('DocHunter', 'Clients', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Clients', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, NULL, ''),
('DocHunter', 'Clients', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Agenda', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Agenda', 'Chapitre', '', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, NULL, 'FIC'),
('DocHunter', 'Agenda', 'Rang', 'COL', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, NULL, ''),
('DocHunter', 'Agenda', 'Sujet', 'C&D', 'Sujet', 40, '', '75%', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('DocHunter', 'Agenda', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Agenda', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, NULL, ''),
('DocHunter', 'Agenda', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Tables', 'Page', '', '', 10, '', '0', 0, 'G', 3, '1', '', '', '1', 1, NULL, ''),
('DocHunter', 'Tables', 'Chapitre', '', '', 20, '', '0', 0, 'G', 3, '', '', '', 'A', 1, NULL, 'TAB'),
('DocHunter', 'Tables', 'Rang', 'COL', 'Rang', 30, '', '10%', 0, 'D', 6, '1', '', '1', 'C', 1, NULL, ''),
('DocHunter', 'Tables', 'Sujet', 'C&D', 'Sujet', 40, ' &nbsp;', '75%', 0, 'G', 64, '', '', '', 'C', 1, NULL, ''),
('DocHunter', 'Tables', 'TexteHaut', 'DET', '', 50, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('DocHunter', 'Tables', 'Image', 'DET', '', 60, '', '0', 0, 'G', 64, '', '', '', 'I', 0, NULL, ''),
('DocHunter', 'Tables', 'TexteBas', 'DET', '', 70, '', '0', 240, 'G', 760, '', '', '', 'E', 0, NULL, ''),
('TablesHunter', 'Groupes', 'Code', 'C&D', 'Code', 10, 'Code', '10%', 0, 'G', 8, '1', '', '', 'C', 1, NULL, ''),
('TablesHunter', 'Groupes', 'Libelle', 'C&D', 'Nom du Groupe', 20, 'Nom du Groupe', '80%', 0, 'G', 32, '', '', '1', 'C', 0, NULL, ''),
('GenApplication', 'Application', 'MiseAJour', 'DET', '', 50, 'Application de mise à jour', '0', 0, 'G', 1, '', '', '', 'B', 1, '', ''),
('GenEspace', 'Espace', 'BaseSecurite', 'DET', '', 125, 'Base de données de sécurité', '0', 0, 'G', 24, '', '', '', 'C', 0, NULL, ''),
('GenEspace', 'Espace', 'TableSecurite', 'DET', '', 130, 'Table de données de sécurité', '0', 0, 'G', 24, '', '', '', 'C', 0, NULL, ''),
('CollabHunter', 'Consultants', 'Identification', 'C&D', 'Identification', 10, 'Identification', '15%', 1, 'G', 32, '1', '', '', 'C', 1, NULL, ''),
('CollabHunter', 'Consultants', 'Titre', 'C&D', 'Titre', 20, 'Titre', '3%', 1, 'G', 8, '', '', '', 'S', 0, NULL, 'M;Mme;Mle'),
('CollabHunter', 'Consultants', 'Nom', 'C&D', 'Nom', 30, 'Nom', '30%', 1, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('CollabHunter', 'Consultants', 'Prenom', 'C&D', 'Prénom', 40, 'Prénom', '35%', 1, 'G', 24, '', '', '', 'C', 0, NULL, ''),
('CollabHunter', 'Consultants', 'Niveau', 'C&D', 'Niveau', 50, 'Niveau de sécurité', '5%', 1, 'D', 3, '', '', '', 'N', 1, NULL, ''),
('CollabHunter', 'Consultants', 'PassWord', 'DET', '', 60, 'Mot de Passe', '0', 1, 'G', 12, '', '', '', 'K', 1, NULL, ''),
('ClientHunter', 'Mission', 'Identification', 'DET', '', 80, 'Consultant en charge', '0', 1, 'G', 32, '', '', '', 'TC', 1, NULL, 'Table=Collaborateurs;Code=Identification; Valeur=Identification'),
('ClientHunter', 'Mission', 'Honoraires', 'DET', '', 90, 'Montant des honoraires', '0', 1, 'D', 8, '', '', '', 'N', 0, NULL, '0;'','';'' '''),
('CollabHunter', 'En-Cours', 'Identification', 'COL', 'Consultant', 10, 'Consultant', '10%', 1, 'G', 32, '1', '', '', 'C', 0, '', ''),
('CollabHunter', 'En-Cours', 'DateDebut', 'C&D', 'Date début', 40, '', '10%', 1, 'C', 10, '', '', '', 'D', 1, '', '-5;0'),
('CollabHunter', 'En-Cours', 'CodeClient', 'C&D', 'Client', 20, 'Total', '16%', 1, 'G', 32, '', '', '1', 'TC', 1, '', 'Table=Clients;Code=CodeClient;Valeur=RaisonSociale'),
('CollabHunter', 'En-Cours', 'Libelle', 'C&D', 'Mission', 30, '', '40%', 1, 'G', 64, '2', '', '', 'A', 1, '', ''),
('CollabHunter', 'En-Cours', 'DateFin', 'C&D', 'Date fin', 50, 'Date de fin de la mission', '10%', 1, 'C', 10, '', '', '', 'D', 1, NULL, '-5;1'),
('CollabHunter', 'En-Cours', 'Honoraires', 'COL', 'Montant', 60, '', '8%', 1, 'D', 8, '', '', '', 'N', 1, '0;'','';'' ''', ''),
('CollabHunter', 'Terminee', 'Identification', 'C&D', 'Consultant', 10, 'Consultant', '10%', 1, 'G', 32, '1', '', '1', 'C', 0, NULL, ''),
('CollabHunter', 'Terminee', 'DateDebut', 'C&D', 'Date début', 40, 'Date de début de la mission', '10%', 1, 'C', 10, '2', '', '1', 'D', 1, NULL, '-5;0'),
('CollabHunter', 'Terminee', 'CodeClient', 'C&D', 'Client', 20, 'Client', '20%', 1, 'G', 32, '', '', '', 'TC', 1, NULL, 'Table=Clients;Code=CodeClient;Valeur=RaisonSociale'),
('CollabHunter', 'Terminee', 'Libelle', 'C&D', 'Mission', 30, 'Mission', '40%', 1, 'G', 64, '', '', '', 'A', 1, NULL, ''),
('CollabHunter', 'Terminee', 'DateFin', 'C&D', 'Date de fin', 50, 'Date de fin de la mission', '10%', 1, 'C', 10, '', '', '', 'D', 1, NULL, '-5;0'),
('CollabHunter', 'Terminee', 'Honoraires', 'C&D', 'Honoraires', 60, 'Honoraires', '10%', 1, 'D', 8, '', '', '', 'N', 1, NULL, '0;'','';'' '''),
('CollabHunter', 'En-Cours', 'Alerte', 'C&D', 'Alerte', 80, 'Alerte', '6%', 1, 'D', 6, '', '', '', 'ZC', 0, '', ''' '''),
('HeadHunter', 'Candidats', 'Honoraires', 'DET', '', 130, 'Honoraires annuels', '0', 1, 'D', 8, '', '', '', 'N', 0, '0;'','';'' '';'' €''', ''),
('HeadHunter', 'Candidats', 'Voiture', 'DET', '', 140, 'Voiture de fonction', '0', 1, 'G', 1, '', '', '', 'B', 1, NULL, ''),
('ClientHunter', 'Candidats', 'Prenom', 'DET', 'Prénom', 20, 'Prénom', '36%', 1, 'G', 32, '', '', '2', 'C', 1, NULL, ''),
('GenApplication', 'Colonne', 'Affichage', 'C&D', 'Affich.', 35, 'Mode d''affichage', '0', 1, 'G', 3, '', '', '', 'R', 0, NULL, 'C&D=Colonne & Détail;DET=Détail seul;COL=Colonne seule'),
('GenApplication', 'Colonne', 'Format', 'DET', '', 160, 'Format', '0', 1, 'G', 24, '', '', '', 'C', 0, NULL, ''),
('HeadHunter', 'Candidats', 'Augmentation', 'DET', '', 180, 'Augmentation', '0', 1, 'D', 6, '', '', '', 'ZN', 0, '2;'','';''.'';''%''', '`SalaireDemande` *100 / (`SalaireActuel` + `Honoraires` / 2)-100'),
('GenApplication', 'Panneau', 'Regroupement', 'DET', '', 130, 'Liste/regroupement', '', 0, '', 3, '', '', '', 'R', 0, '', 'GRP=Regroupement;G&T=Regroupement avec cumuls'),
('CollabHunter', 'ChiffreAffaires', 'Annee', 'COL', 'Années', 10, 'CA Total', '20%', 0, 'G', 4, '1', '', '1', 'ZD', 1, '', 'YEAR(`DateFin`)'),
('CollabHunter', 'ChiffreAffaires', 'Identification', 'COL', 'Consultant', 20, 'CA annuel', '40%', 0, 'G', 32, '', '', '2', 'C', 1, '', ''),
('CollabHunter', 'ChiffreAffaires', 'CA', 'COL', 'Chiffre d''affaires', 30, '', '20%', 0, 'D', 8, '', '', '', 'ZN', 1, '0;'','';'' ''', 'SUM(`Honoraires`)'),
('CollabHunter', 'En-Cours', 'Numero', '', '', 90, '', '0', 0, '', 3, '', '', '2', 'N', 0, '', ''),
('HeadHunter', 'Candidats', 'DebutMetier', 'DET', '', 115, 'Débuté en', '0', 0, 'G', 4, '', '', '', 'X', 0, '', 'Code=AnneeDebut;Valeur=AnneeDebut;'),
('GenApplication', 'Application', 'Globale', 'DET', '', 60, 'Clefs globales', '0', 0, 'G', 1, '', '', '', 'B', 0, '', ''),
('TablesHunter', 'Specialite', 'Code_Metier', 'C&D', 'Métier', 10, 'Code Métier', '12%', 0, 'G', 8, '1', 'MiniMetier', '1', 'C', 1, '', ''),
('TablesHunter', 'Specialite', 'Code_Specialite', 'C&D', 'Spécialité', 20, 'Code Spécialité', '12%', 0, 'G', 8, '2', '', '', 'C', 1, '', ''),
('TablesHunter', 'Specialite', 'Denomination', 'C&D', 'Libellé', 30, 'Libellé', '76%', 0, 'G', 64, '', '', '2', 'C', 1, '', ''),
('TablesHunter', 'MiniMetier', 'Code_Metier', 'DET', '', 1, 'Code Métier', '0', 0, 'G', 8, '1', '', '', 'C', 0, '', 'Code_Metier'),
('TablesHunter', 'MiniMetier', 'Libelle', 'DET', 'Métier', 2, 'Métier', '90%', 0, 'G', 64, '', '', '', 'C', 0, '', ''),
('HeadHunter', 'Candidats', 'Specialite', 'C&D', '', 111, 'Spécialité', '0', 0, 'G', 8, '', '', '', 'TC', 0, '', 'Table=Specialite;Code=Code_Specialite;Valeur=Denomination;Parent=Metier'),
('SasHunter', 'CV_Lettres', 'Nom', 'C&D', 'Nom', 10, 'Nom', '12%', 0, 'G', 32, '', '', '', 'C', 1, '', ''),
('SasHunter', 'CV_Lettres', 'Prenom', 'C&D', 'Prénom', 20, 'Prénom', '12%', 0, 'G', 32, '', '', '', 'C', 1, '', ''),
('SasHunter', 'CV_Lettres', 'Langue', 'C&D', 'Langue', 30, 'Langue', '8%', 0, 'G', 32, '', '', '', 'S', 1, '', 'Français=Français;English=English'),
('SasHunter', 'CV_Lettres', 'CV', 'C&D', 'CV', 40, 'CV', '24%', 0, 'G', 72, '', '', '', 'O', 0, '', ''),
('SasHunter', 'CV_Lettres', 'Lettre', 'C&D', 'Lettre', 50, 'Lettre', '24%', 0, 'G', 72, '', '', '', 'O', 0, '', ''),
('SasHunter', 'CV_Lettres', 'DatePoste', 'C&D', 'Posté le', 70, 'Posté le', '6%', 0, 'C', 10, '', '', '', 'D', 1, '', ''),
('SasHunter', 'CV_Lettres', 'Traite', 'C&D', 'Traité', 80, 'Traité', '6%', 0, 'C', 1, '', '', '', 'B', 1, '', ''),
('SasHunter', 'Candidats', 'NoDossier', 'C&D', 'N° Dos.', 10, 'Numéro de dossier', '8%', 0, 'G', 6, '1', '', '', 'N', 0, NULL, ''),
('SasHunter', 'Candidats', 'Nom', 'C&D', 'Nom', 21, 'Nom', '0', 0, 'G', 32, '', '', '1', 'C', 0, NULL, ''),
('SasHunter', 'Candidats', 'Prenom', 'C&D', 'Prénom', 20, 'Prénom', '25%', 0, 'G', 32, '', '', '2', 'C', 0, '', ''),
('SasHunter', 'Candidats', 'Naissance', 'C&D', 'Naissance', 50, 'Date de naissance', '12%', 0, 'D', 10, '', '', '', 'D', 0, 'j;m;A & J;M;A', '-60;-20'),
('SasHunter', 'Candidats', 'NomMarital', 'C&D', 'Nom marital', 22, 'Nom marital', '0', 0, 'G', 32, '', '', '', 'C', 0, NULL, ''),
('SasHunter', 'Candidats', 'Disponibilite', 'C&D', 'Disponibilité', 100, 'Date de disponibilité', '12%', 0, 'D', 10, '', '', '', 'D', 0, 'j;m;A & J;M;A', '0;1'),
('SasHunter', 'Candidats', 'Situation', 'DET', '', 80, 'Situation de famille', '0', 0, 'C', 1, '', '', '', 'S', 0, NULL, 'C=Célibataire;M=Marié(e);V=Veuf(ve);D=Divorcé(e);P=Pacsé(e)'),
('SasHunter', 'Candidats', 'Sexe', 'C&D', 'Sexe', 70, 'Sexe', '8%', 0, 'C', 1, '', '', '', 'S', 0, NULL, 'M;F'),
('SasHunter', 'Candidats', 'Nationalite2', 'DET', '', 65, 'Nationalité', '0', 0, 'G', 3, '', '', '', 'TB', 0, '', 'Table=Nations; Code=Code; Valeur=Nationalite'),
('SasHunter', 'Candidats', 'SalaireActuel', 'DET', '', 120, 'Rénumération actuelle', '0', 0, 'D', 8, '', '', '', 'N', 0, '0;'','';'' '';'' €''', ''),
('SasHunter', 'Candidats', 'SalaireDemande', 'DET', '', 150, 'Rénumération désirée', '0', 0, 'D', 8, '', '', '', 'N', 0, '0;'','';'' '';'' €''', ''),
('SasHunter', 'Candidats', 'Photo', 'DET', '', 90, 'Photo d''identité', '0', 0, 'G', 72, '', '', '', 'I', 0, NULL, ''),
('SasHunter', 'Candidats', 'Metier', 'C&D', 'Metier', 110, 'Métier', '24%', 0, 'G', 20, '', '', '', 'TC', 0, '', 'Table=Metiers; Code=Code_Metier; Valeur=Libelle'),
('SasHunter', 'Candidats', 'Nationalite1', 'DET', '', 60, 'Nationalité', '0', 0, 'G', 3, '', '', '', 'TB', 1, '', 'Table=Nations; Code=Code; Valeur=Nationalite'),
('SasHunter', 'Candidats', 'Voiture', 'DET', '', 140, 'Voiture de fonction', '0', 1, 'G', 1, '', '', '', 'B', 1, NULL, ''),
('SasHunter', 'Candidats', 'DebutMetier', 'DET', '', 115, 'Débuté en', '0', 0, 'G', 4, '', '', '', 'X', 0, '', 'Code=AnneeDebut;Valeur=AnneeDebut;'),
('SasHunter', 'Candidats', 'Specialite', 'C&D', '', 111, 'Spécialité', '0', 0, 'G', 8, '', '', '', 'TC', 0, '', 'Table=Specialite;Code=Code_Specialite;Valeur=Denomination;Parent=Metier'),
('SasHunter', 'Candidats', 'Honoraires', 'DET', '', 130, 'Honoraires annuels', '0', 1, 'D', 8, '', '', '', 'N', 0, '0;'','';'' '';'' €''', '');
INSERT INTO `colonnes-appli` (`Application`, `Panneau`, `Colonne`, `Affichage`, `TitreColonne`, `Rang`, `Libelle`, `LargeurColonne`, `Hauteur`, `Position`, `LargeurSaisie`, `Clef`, `Substitut`, `TriDonnees`, `TypeDonnees`, `Obligatoire`, `Format`, `Complement`) VALUES
('SasHunter', 'Candidats', 'Augmentation', 'DET', '', 180, 'Augmentation', '0', 1, 'D', 6, '', '', '', 'ZN', 0, '2;'','';''.'';''%''', '`SalaireDemande` *100 / (`SalaireActuel` + `Honoraires` / 2)-100'),
('SasHunter', 'CV_Lettres', 'Rang', 'COL', 'N°', 1, '', '5%', 0, 'D', 5, '1', '', '1', 'N', 0, '', ''),
('HeadHunter', 'Documents', 'DateReception', 'C&D', 'Date reception', 40, 'Date de reception', '8%', 0, 'C', 10, '', '', '', 'D', 0, '', '-10;0'),
('HeadHunter', 'Documents', 'Mode', 'C&D', 'Mode', 50, 'Mode', '10%', 0, 'G', 2, '', '', '', 'S', 1, '', 'R=Reception;D=Dépot;E=Envoi'),
('HeadHunter', 'Documents', 'PJ', 'C&D', 'Pièce jointe', 80, 'Pièce jointe', '24%', 0, 'G', 90, '', '', '', 'O', 0, '', ''),
('SasHunter', 'Documents', 'NoDossier', 'C&D', 'N° Dossier', 10, 'Numéro de Dossier', '7%', 0, 'D', 8, '1', 'MiniCandidats', '', 'N', 1, '', ''),
('SasHunter', 'Documents', 'RangDocument', 'C&D', 'Rang', 20, 'Numéro d''ordre', '5%', 0, 'D', 3, '2', '', '1', '2', 1, '', ''),
('SasHunter', 'Documents', 'DateDocument', 'C&D', 'Date document', 30, 'Date du document', '8%', 0, 'C', 10, '', '', '', 'D', 1, '', '-10;0'),
('SasHunter', 'Documents', 'Type', 'C&D', 'Type', 60, 'Type de document', '12%', 0, 'G', 12, '', '', '', 'S', 1, '', 'CV=C.V.;LI=Lettre d''intention;LC=Lettre et C.V.;LE=Lettre;AD=Autre document'),
('SasHunter', 'Documents', 'Document', 'C&D', 'Document', 70, 'Fichier du document', '24%', 0, 'G', 90, '', '', '', 'O', 0, '', ''),
('SasHunter', 'Documents', 'DateReception', 'C&D', 'Date reception', 40, 'Date de reception', '8%', 0, 'C', 10, '', '', '', 'D', 0, '', '-10;0'),
('SasHunter', 'Documents', 'Mode', 'C&D', 'Mode', 50, 'Mode', '10%', 0, 'G', 2, '', '', '', 'S', 1, '', 'R=Reception;D=Dépot;E=Envoi'),
('SasHunter', 'Documents', 'PJ', 'C&D', 'Pièce jointe', 80, 'Pièce jointe', '24%', 0, 'G', 90, '', '', '', 'O', 0, '', ''),
('SasHunter', 'MiniCandidats', 'NoDossier', 'DET', '', 1, 'Dossier N°', '0', 0, 'G', 0, '1', '', '', 'C', 0, NULL, 'NoDossier'),
('SasHunter', 'MiniCandidats', 'Nom', 'DET', '', 2, 'Nom', '0', 0, 'G', 0, '', '', '', 'C', 0, NULL, ''),
('SasHunter', 'MiniCandidats', 'Prenom', 'DET', '', 3, 'Prenom', '0', 0, 'G', 0, '', '', '', 'C', 0, NULL, '');

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

--
-- Structure de la table `controle-appli`
--

DROP TABLE IF EXISTS `controle-appli`;
CREATE TABLE `controle-appli` (
  `CodeControle` varchar(2) collate utf8_bin NOT NULL default '',
  `Libelle` varchar(64) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`CodeControle`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `controle-appli`
--

INSERT INTO `controle-appli` (`CodeControle`, `Libelle`) VALUES
('C', 'Chaîne de caractères'),
('L', 'Texte long'),
('N', 'Numérique'),
('F', 'Numérique avec décimales'),
('D', 'Date (européenne)'),
('B', 'Booléen (OUI/NON)'),
('TA', 'Table (code en colonne et en détail)'),
('TB', 'Table (code en colonne et libellé en détail)'),
('TC', 'Table (libellé en colonne et en détail)'),
('S', 'Ensemble de codes (libellé en colonne et détail)'),
('P', 'Référence à une autre table'),
('X', 'Table crée par une routine'),
('I', 'Image (photo,...)'),
('O', 'Document Open Office'),
('1', 'Incrémentation automatique complète'),
('K', 'Mot de passe'),
('J', 'Insertion automatique à partir d''un panneau pré-sélectionné'),
('U', 'Table mixte  (code en colonne et en détail)'),
('Y', 'Table mixte crée par une routine'),
('ZC', 'Rubrique fictive caractères'),
('M', 'Adresse e-mail'),
('E', 'Texte édité'),
('H', 'Heure et minutes (hh:mm)'),
('2', 'Incrémentation automatique dépendante'),
('3', 'Date de création Automatique'),
('5', 'Date et heure de création automatique'),
('4', 'Date de modification automatique'),
('6', 'Date et heure de modification automatique'),
('0', 'Nom de l''utilisateur'),
('A', 'Constante'),
('R', 'Ensemble de codes (code en colonne et libellé en détail)'),
('ZN', 'Rubrique fictive numérique'),
('ZD', 'Rubrique fictive date');

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

--
-- Structure de la table `espace`
--

DROP TABLE IF EXISTS `espace`;
CREATE TABLE `espace` (
  `Espace` varchar(24) collate utf8_bin NOT NULL default '',
  `NomEspace` varchar(128) collate utf8_bin NOT NULL default '',
  `LargeurVolet` varchar(6) collate utf8_bin NOT NULL default '',
  `LargeurAppli` varchar(6) collate utf8_bin NOT NULL default '',
  `CouleurFond` varchar(16) collate utf8_bin NOT NULL default '',
  `Police` varchar(16) collate utf8_bin NOT NULL default 'Serif',
  `TailleTexte` varchar(16) collate utf8_bin NOT NULL default 'x-large',
  `CouleurTexte` varchar(16) collate utf8_bin NOT NULL default 'red',
  `Bandeau` varchar(32) collate utf8_bin NOT NULL default '',
  `BoutonActif` varchar(32) collate utf8_bin NOT NULL default '',
  `BoutonInactif` varchar(32) collate utf8_bin NOT NULL default '',
  `MotDePasse` tinyint(1) NOT NULL default '0',
  `BaseSecurite` varchar(24) collate utf8_bin NOT NULL default '',
  `TableSecurite` varchar(24) collate utf8_bin NOT NULL default '',
  `TexteAccueil` blob,
  PRIMARY KEY  (`Espace`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `espace`
--

INSERT INTO `espace` (`Espace`, `NomEspace`, `LargeurVolet`, `LargeurAppli`, `CouleurFond`, `Police`, `TailleTexte`, `CouleurTexte`, `Bandeau`, `BoutonActif`, `BoutonInactif`, `MotDePasse`, `BaseSecurite`, `TableSecurite`, `TexteAccueil`) VALUES
('HeadHunter', 'La chasse de tête', '120px', '800px', 'rgb(70,96,146)', 'Times New Roman', 'x-large', 'red', 'Bridge-Consulting.jpg', '', '', 1, 'headhunter', 'Collaborateurs', 0x3c70207374796c653d22746578742d616c69676e3a2063656e7465723b223e3c666f6e7420636f6c6f723d2223666666666666222073697a653d22372220666163653d22417269616c223e47657374696f6e20646573204d697373696f6e73203c2f666f6e743e3c2f703e3c70207374796c653d22746578742d616c69676e3a2063656e7465723b223e3c666f6e7420636f6c6f723d2223666666666666222073697a653d22372220666163653d22417269616c223e65743c2f666f6e743e3c2f703e3c70207374796c653d22746578742d616c69676e3a2063656e7465723b223e3c666f6e7420636f6c6f723d2223666666666666222073697a653d22372220666163653d22417269616c223e6465732043616e6469646174757265733c2f666f6e743e3c2f703e),
('GenEspace', 'Générateur d''applications', '120px', '800px', 'rgb(255,215,120)', 'Times New Roman', 'xx-large', 'red', 'Espace-GenApplication.jpg', 'Bouton-Jaune-Clair.jpg', 'Bouton-Jaune.jpg', 1, 'gen-appli', 'securite', 0x4f7574696c732064652067e96ee9726174696f6e3c42523e65742064653c42523e67657374696f6e20646573206170706c69636174696f6e73);

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

--
-- Structure de la table `espace-appli`
--

DROP TABLE IF EXISTS `espace-appli`;
CREATE TABLE `espace-appli` (
  `Espace` varchar(24) collate utf8_bin NOT NULL default '',
  `ModeAppli` tinyint(1) NOT NULL default '0',
  `NomFrame` varchar(64) collate utf8_bin NOT NULL default '',
  `IntituleBouton` varchar(24) collate utf8_bin NOT NULL default '',
  `Rang` int(3) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `espace-appli`
--

INSERT INTO `espace-appli` (`Espace`, `ModeAppli`, `NomFrame`, `IntituleBouton`, `Rang`) VALUES
('GenEspace', 1, 'GenApplication', 'Applications', 20),
('GenEspace', 1, 'GenEspace', 'Espaces', 10),
('HeadHunter', 1, 'HeadHunter', 'Candidats', 10),
('HeadHunter', 1, 'ClientHunter', 'Clients', 20),
('HeadHunter', 1, 'TablesHunter', 'Tables', 60),
('HeadHunter', 0, 'Fiche-individuelle.php', 'Fiche', 30),
('HeadHunter', 1, 'AgendaHunter', 'Agenda', 40),
('HeadHunter', 1, 'DocHunter', 'Manuel', 80),
('HeadHunter', 1, 'CollabHunter', 'Consultants', 50),
('HeadHunter', 1, 'MaintHunter', 'Maintenance', 70),
('HeadHunter', 1, 'SasHunter', 'CV & Lettres', 75);

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

--
-- Structure de la table `global-appli`
--

DROP TABLE IF EXISTS `global-appli`;
CREATE TABLE `global-appli` (
  `Application` varchar(24) collate utf8_bin NOT NULL default '',
  `NomApplication` varchar(128) collate utf8_bin NOT NULL default '',
  `BaseDonnees` varchar(24) collate utf8_bin NOT NULL default '',
  `Securite` tinyint(1) NOT NULL default '0',
  `MiseAJour` tinyint(1) NOT NULL default '1',
  `Globale` tinyint(1) NOT NULL default '1',
  `LargeurEcran` varchar(8) collate utf8_bin NOT NULL default '',
  `CouleurFond` varchar(16) collate utf8_bin NOT NULL default '',
  `CouleurMenu` varchar(16) collate utf8_bin NOT NULL default '',
  `Police` varchar(16) collate utf8_bin NOT NULL default 'Sans-Serif',
  `TailleTexte` varchar(16) collate utf8_bin NOT NULL default 'small',
  `CouleurTexte` varchar(16) collate utf8_bin NOT NULL default 'black',
  `TailleTitre` varchar(16) collate utf8_bin NOT NULL default 'x-large',
  `CouleurTitre` varchar(16) collate utf8_bin NOT NULL default 'red',
  `TailleMessage` varchar(16) collate utf8_bin NOT NULL default 'x-large',
  `CouleurMessage` varchar(16) collate utf8_bin NOT NULL default 'red',
  `Bandeau` varchar(32) collate utf8_bin NOT NULL default '',
  `TextSurBandeau` tinyint(1) NOT NULL default '0',
  `BoutonActif` varchar(32) collate utf8_bin NOT NULL default '',
  `BoutonInactif` varchar(32) collate utf8_bin NOT NULL default '',
  `Filler` varchar(32) collate utf8_bin NOT NULL default '',
  `TableRequetes` varchar(24) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Application`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `global-appli`
--

INSERT INTO `global-appli` (`Application`, `NomApplication`, `BaseDonnees`, `Securite`, `MiseAJour`, `Globale`, `LargeurEcran`, `CouleurFond`, `CouleurMenu`, `Police`, `TailleTexte`, `CouleurTexte`, `TailleTitre`, `CouleurTitre`, `TailleMessage`, `CouleurMessage`, `Bandeau`, `TextSurBandeau`, `BoutonActif`, `BoutonInactif`, `Filler`, `TableRequetes`) VALUES
('HeadHunter', 'Chasse de tête', 'headhunter', 0, 1, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '12px', 'black', '26px', 'black', '18px', 'red', '', 0, 'Bouton-Rose-Clair.jpg', 'Bouton-Rose.jpg', 'Filler-Rose.jpg', 'Requetes'),
('GenApplication', 'Générateur d''application', 'gen-appli', 0, 1, 1, '800px', 'rgb(255,245,220)', 'rgb(255,215,120)', 'Times New Roman', '14px', 'black', '32px', 'red', 'x-large', 'red', '', 0, 'Bouton-GenAppli-Clair-160.jpg', 'Bouton-GenAppli-160.jpg', 'Filler-GenApplication-160.jpg', 'requetes-appli'),
('TablesHunter', 'Tables de la chasse de têtes', 'headhunter', 1, 1, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '12px', 'black', '26px', 'black', '18px', 'red', '', 0, 'Bouton-Outremer-Clair.jpg', 'Bouton-Outremer.jpg', 'Filler-Outremer.jpg', 'Requetes'),
('ClientHunter', 'Gestion des clients', 'headhunter', 1, 1, 0, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '12px', 'black', '24px', 'black', 'large', 'red', '', 0, 'Bouton-Orange-Clair.jpg', 'Bouton-Orange.jpg', 'Filler-Orange.jpg', 'Requetes'),
('GenEspace', 'Gestion des Espaces de Travail', 'gen-appli', 0, 1, 1, '800px', 'rgb(255,245,220)', 'rgb(255,215,120)', 'Times New Roman', '14px', 'black', '32px', 'red', 'x-large', 'red', '', 0, 'Bouton-GenAppli-Clair-160.jpg', 'Bouton-GenAppli-160.jpg', 'Filler-GenApplication-160.jpg', ''),
('AgendaHunter', 'Gestion de l''agenda du chasseur de têtes', 'headhunter', 1, 1, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '12px', 'black', '26px', 'black', '18px', 'red', '', 0, 'Bouton-Amande-Clair.jpg', 'Bouton-Amande.jpg', 'Filler-Amande.jpg', 'Requetes'),
('Fiche-individuelle.php', 'Fiche individuelle', 'headhunter', 1, 1, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '12px', 'black', '30px', 'blue', '20px', 'blue', '', 0, 'Bouton-Jaune-Clair.jpg', 'Bouton-Jaune.jpg', 'Filler-Jaune.jpg', ''),
('DocHunter', 'Documentation', 'headhunter', 0, 0, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Times New Roman', '12px', 'black', '28px', 'black', '20px', 'red', '', 0, 'Bouton-Gris-Clair.jpg', 'Bouton-Gris.jpg', 'Filler-Gris.jpg', 'Requetes'),
('CollabHunter', 'Gestions des consultants', 'headhunter', 1, 0, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '12px', 'black', '26px', 'black', '18px', 'red', '', 0, 'Bouton-Vert-Clair.jpg', 'Bouton-Vert.jpg', 'Filler-Vert.jpg', 'Requetes'),
('MaintHunter', 'Maintenance', 'gen-appli', 1, 0, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '16px', 'black', '26px', 'black', '20px', 'red', '', 0, 'Bouton-Bleu-Clair.jpg', 'Bouton-Bleu.jpg', 'Filler-Bleu.jpg', 'Requetes'),
('SasHunter', 'Introduction des CVs et des lettres', 'headhunter', 1, 1, 1, '800px', 'rgb(220,230,240)', 'rgb(160,180,200)', 'Arial', '12px', 'black', '26px', 'black', '18px', 'red', '', 0, 'Bouton-Bordeau-Clair.jpg', 'Bouton-Bordeau.jpg', 'Filler-Bordeau.jpg', 'Requetes');

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

--
-- Structure de la table `requetes-appli`
--

DROP TABLE IF EXISTS `requetes-appli`;
CREATE TABLE `requetes-appli` (
  `Application` varchar(24) collate utf8_bin NOT NULL default '',
  `Panneau` varchar(24) collate utf8_bin NOT NULL default '',
  `Auteur` varchar(32) collate utf8_bin NOT NULL default '',
  `NomRequete` varchar(24) collate utf8_bin NOT NULL default '',
  `Commun` tinyint(1) NOT NULL default '0',
  `Modifiable` tinyint(1) NOT NULL default '0',
  `Where` varchar(255) collate utf8_bin NOT NULL default '',
  `AvecOrder` tinyint(1) NOT NULL default '0',
  `Order` varchar(255) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Application`,`Panneau`,`Auteur`,`NomRequete`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table des requêtes SQL';

--
-- Contenu de la table `requetes-appli`
--


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

--
-- Structure de la table `securite`
--

DROP TABLE IF EXISTS `securite`;
CREATE TABLE `securite` (
  `Identification` varchar(32) collate utf8_bin NOT NULL default '',
  `PassWord` varchar(32) collate utf8_bin NOT NULL default '',
  `Titre` varchar(8) collate utf8_bin default NULL,
  `Nom` varchar(32) collate utf8_bin default NULL,
  `Prenom` varchar(24) collate utf8_bin default NULL,
  `Niveau` int(3) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `securite`
--

INSERT INTO `securite` (`Identification`, `PassWord`, `Titre`, `Nom`, `Prenom`, `Niveau`) VALUES
('Matthieu', 'baaf5fc7a70663426c03afe5ab4e0526', NULL, NULL, NULL, NULL),
('François', '07d941bb0fb41b7db4788b04650d2693', NULL, NULL, NULL, NULL);

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

--
-- Structure de la table `table-appli`
--

DROP TABLE IF EXISTS `table-appli`;
CREATE TABLE `table-appli` (
  `Application` varchar(24) collate utf8_bin NOT NULL default '',
  `Panneau` varchar(24) collate utf8_bin NOT NULL default '',
  `Rang` int(11) NOT NULL default '0',
  `TypePanneau` enum('P','T','S','C','V') collate utf8_bin NOT NULL default 'P',
  `TableDonnees` varchar(24) collate utf8_bin NOT NULL default '',
  `TableParent` varchar(24) collate utf8_bin NOT NULL default '',
  `Intitule` varchar(32) collate utf8_bin NOT NULL default '',
  `TitrePanneau` varchar(64) collate utf8_bin NOT NULL default '',
  `EnTeteInverse` tinyint(1) NOT NULL default '0',
  `BordureListe` tinyint(1) NOT NULL default '0',
  `BordureDetail` tinyint(1) NOT NULL default '0',
  `Actions` varchar(6) collate utf8_bin NOT NULL default '',
  `Regroupement` varchar(3) collate utf8_bin default NULL,
  `LargeurLibelle` varchar(6) collate utf8_bin NOT NULL default '',
  `LignesParPage` int(5) NOT NULL default '0',
  `ConserveSelection` tinyint(1) NOT NULL default '1',
  `Imprimable` tinyint(1) NOT NULL default '0',
  `Filtre` varchar(255) collate utf8_bin default NULL,
  `Routine` varchar(48) collate utf8_bin default NULL,
  PRIMARY KEY  (`Application`,`Panneau`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table des applications/panneaux de gestion des tables';

--
-- Contenu de la table `table-appli`
--

INSERT INTO `table-appli` (`Application`, `Panneau`, `Rang`, `TypePanneau`, `TableDonnees`, `TableParent`, `Intitule`, `TitrePanneau`, `EnTeteInverse`, `BordureListe`, `BordureDetail`, `Actions`, `Regroupement`, `LargeurLibelle`, `LignesParPage`, `ConserveSelection`, `Imprimable`, `Filtre`, `Routine`) VALUES
('HeadHunter', 'Candidats', 10, 'P', 'Candidats', '', 'Candidats', 'Curricullum vitae', 0, 0, 0, 'DCMEST', '', '30%', 10, 0, 0, '', 'Candidats.inc'),
('TablesHunter', 'Diplomes', 10, 'T', 'Diplomes', '', 'Diplomes', 'Table des diplomes', 1, 1, 0, 'DCMEST', '', '20%', 0, 0, 0, '', ''),
('TablesHunter', 'Metiers', 20, 'T', 'Metiers', '', 'Métiers', 'Table des métiers', 1, 1, 0, 'DCMEST', '', '20%', 0, 0, 0, '', ''),
('HeadHunter', 'Formation', 30, 'P', 'Cursus', 'Candidats', 'Formations', 'Cursus de Formation', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('HeadHunter', 'MiniCandidats', 0, 'S', 'Candidats', '', 'MiniCandidats', '', 0, 0, 0, '', '', '30%', 0, 0, 0, NULL, ''),
('GenApplication', 'Application', 10, 'P', 'global-appli', '', 'Application', 'Informations globales de l''application', 0, 0, 0, 'DCME', '', '30%', 0, 0, 0, '', ''),
('GenApplication', 'Panneau', 20, 'P', 'table-appli', 'global-appli', 'Panneau', 'Gestion des panneaux', 0, 0, 0, 'DCMET', '', '30%', 0, 0, 0, '', 'GenApplication.inc'),
('GenApplication', 'Colonne', 30, 'P', 'colonnes-appli', 'table-appli', 'Colonnes', 'Gestion des colonnes (Rubriques)', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', 'GenApplication.inc'),
('GenApplication', 'CodeControle', 40, 'P', 'controle-appli', '', 'Codes', 'Codes utilisé par le contrôle de données', 1, 1, 1, 'DCMET', '', '30%', 0, 0, 0, NULL, ''),
('TablesHunter', 'Pays', 50, 'T', 'Nations', '', 'Pays', 'Table des pays', 1, 1, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('HeadHunter', 'Adresses', 20, 'P', 'Adresses', 'Candidats', 'Adresses', 'Adresses du candidat', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('HeadHunter', 'Employeur', 50, 'P', 'Employeurs', 'Candidats', 'Employeurs', 'Employeurs précédents', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('TablesHunter', 'Secteurs', 30, 'T', 'Secteurs', '', 'Secteurs', 'Table des secteurs', 1, 1, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('HeadHunter', 'Langues', 40, 'P', 'Langues', 'Candidats', 'Langues', 'Langues', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('HeadHunter', 'Contacts', 60, 'P', 'Contacts', 'Candidats', 'Contacts', 'Contacts avec le candidats', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('HeadHunter', 'Documents', 70, 'P', 'Documents', 'Candidats', 'Documents', 'Documents envoyés et reçus', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('HeadHunter', 'Tel-Email', 25, 'P', 'Tel-Emails', 'Candidats', 'Tel./Email', 'Télephone et email', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', 'HeadHunterEmail.inc'),
('ClientHunter', 'Client', 10, 'P', 'Clients', '', 'Clients', 'Gestion des clients', 0, 0, 0, 'DCMEST', '', '30%', 10, 0, 0, '', ''),
('ClientHunter', 'Responsable', 20, 'P', 'Responsables', 'Clients', 'Respons.', 'Gestion des responsables', 0, 0, 0, 'DCME', '', '30%', 0, 0, 0, '', ''),
('ClientHunter', 'Mission', 30, 'P', 'Missions', 'Responsables', 'Missions', 'Gestion des missions', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('ClientHunter', 'Postulants', 40, 'P', 'Postulants', 'Missions', 'Propositions', 'Gestion des postulants', 0, 0, 0, 'DCME', '', '30%', 0, 0, 0, '', ''),
('ClientHunter', 'SubstitutCandidat', 0, 'S', 'Candidats', '', 'Candidats', 'Substitut du Candidat', 0, 0, 0, '', '', '30%', 0, 0, 0, NULL, ''),
('ClientHunter', 'SubstitutClient', 1, 'S', 'Clients', '', 'Clients', 'Substitut du Client', 0, 0, 0, '', '', '30%', 0, 0, 0, NULL, ''),
('ClientHunter', 'SubstitutResponsable', 2, 'S', 'Responsables', '', 'Responsable', 'Substitut du Responsable', 0, 0, 0, '', '', '30%', 0, 0, 0, NULL, ''),
('ClientHunter', 'Candidats', 80, 'P', 'Candidats', '', 'Candidats', 'Liste de candidats', 0, 0, 0, 'DST', '', '30%', 10, 0, 0, '', ''),
('GenEspace', 'Espace', 10, 'P', 'espace', '', 'Espace', 'Gestion des espaces de travail', 0, 0, 0, 'DCME', '', '30%', 0, 0, 0, NULL, ''),
('GenEspace', 'Applications', 20, 'P', 'espace-appli', '', 'Applications', 'Gestion des applications de l''espace de travail', 0, 0, 0, 'DCME', '', '30%', 0, 0, 0, NULL, ''),
('TablesHunter', 'Requetes', 100, 'P', 'Requetes', '', 'Requêtes', 'Gestion des Requêtes', 1, 1, 0, 'DCMEST', '', '30%', 0, 0, 0, '`Auteur`= ''Administrateur'' OR `Auteur` = ''$NomUtilisateur''', ''),
('ClientHunter', 'Action', 50, 'P', 'Actions', 'Missions', 'Actions', 'Actions à faire', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('ClientHunter', 'SubstitutMission', 3, 'S', 'Missions', '', 'Mission', 'Substitut de la mission', 0, 0, 0, '', '', '30%', 0, 0, 0, '', ''),
('ClientHunter', 'Candidatures', 90, 'P', 'Postulants', 'Candidats', 'Candidatures', 'Candidatures proposées aux clients', 0, 0, 0, 'DST', '', '30%', 0, 0, 0, '', 'Candidatures.inc'),
('ClientHunter', 'SubstitutNoDossier', 0, 'S', 'Candidats', '', 'Candidats', 'substitut  du numéro de dossier', 0, 0, 0, '', '', '30%', 0, 0, 0, '', ''),
('AgendaHunter', 'Rendez-vous', 10, 'P', 'Actions', '', 'Rendez-vous', 'Agenda des rendez-vous', 0, 0, 0, 'ST', '', '30%', 0, 0, 0, '`Utilisateur` = ''$NomUtilisateur'' AND `DateAction` >= CURRENT_DATE AND `TypeAction` IN (''Réunion'',''RdV'')', 'Agenda.inc'),
('AgendaHunter', 'A-Faire', 20, 'P', 'Actions', '', 'A faire', 'Liste des actions à faire', 0, 0, 0, 'ST', '', '30%', 0, 0, 0, '`Utilisateur` = ''$NomUtilisateur'' AND `TypeAction` NOT IN (''Réunion'',''RdV'') AND `Statut` != ''FAIT''', 'Agenda.inc'),
('DocHunter', 'Demarrage', 10, 'P', 'Documentation', '', 'Démarrage', 'Comment débuter', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''DEM''', ''),
('DocHunter', 'Navigation', 20, 'P', 'Documentation', '', 'Navigation', 'Comment naviguer dans la base de données', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''NAV''', ''),
('DocHunter', 'Selection', 30, 'P', 'Documentation', '', 'Sélection', 'Comment Sélectionner des fiches', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''SEL''', ''),
('DocHunter', 'Mise à jour', 40, 'P', 'Documentation', '', 'Mise à jour', 'Comment gérer les candidats', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''CAN''', ''),
('DocHunter', 'Candidats', 50, 'P', 'Documentation', '', 'Candidats', 'Comment gérer les clients et les missions', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''CLI''', ''),
('DocHunter', 'Clients', 60, 'P', 'Documentation', '', 'Clients', 'Comment accéder à votre agenda', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''AGE''', ''),
('DocHunter', 'Agenda', 70, 'P', 'Documentation', '', 'Agenda', 'Comment accéder à une fiche individuelle', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''FIC''', ''),
('DocHunter', 'Tables', 80, 'P', 'Documentation', '', 'tables', 'Comment gérer les tables auxilliaires', 0, 0, 0, 'DCME', '', '1%', 0, 0, 0, '`Chapitre` = ''TAB''', ''),
('TablesHunter', 'Groupes', 60, 'P', 'Groupes', '', 'Groupes', 'Gestion des groupes industriels, financiers,...', 1, 1, 0, 'DCME', '', '30%', 0, 0, 0, '', ''),
('CollabHunter', 'Consultants', 10, 'P', 'Collaborateurs', '', 'Consultants', 'Gestion des consultants', 0, 0, 0, 'DCME', '', '30%', 0, 0, 0, '', ''),
('CollabHunter', 'En-Cours', 20, 'P', 'Missions', '', 'Missions E-C', 'Missions en cours', 0, 0, 0, '', '', '30%', 0, 0, 0, '`Missions`.`Etat`= ''E-C''', 'ChiffreAffaires.inc'),
('CollabHunter', 'Terminee', 30, 'P', 'Missions', '', 'Missions Ter.', 'Missions terminées', 0, 0, 0, 'S', '', '30%', 0, 0, 0, '`Missions`.`Etat`= ''TER''', 'ChiffreAffaires.inc'),
('CollabHunter', 'ChiffreAffaires', 40, 'P', 'Missions', '', 'CA annuel', 'Chiffre d''affaires', 1, 1, 0, '', 'G&T', '30%', 0, 0, 0, '', ''),
('MaintHunter', 'Sauvegarde', 10, 'V', '', '', 'Sauvegarde', 'Sauvegarde de la base de données', 0, 0, 0, '', '', '30%', 0, 0, 0, '', 'Backup.inc'),
('MaintHunter', 'Restauration', 20, 'V', '', '', 'Restauration', 'Restauration de la base de données', 0, 0, 0, '', '', '30%', 0, 0, 0, '', 'Backup.inc'),
('TablesHunter', 'Specialite', 25, 'T', 'Specialite', 'Metiers', 'Spécialité', 'Spécialité', 1, 1, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('TablesHunter', 'MiniMetier', 0, 'S', 'metiers', '', 'Metier', '', 0, 0, 0, '', '', '30%', 0, 0, 0, '', ''),
('SasHunter', 'CV_Lettres', 10, 'P', 'lettres_cv', '', 'CV & Lettres', 'CVs et Lettres déposés sur le site', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', ''),
('SasHunter', 'Candidats', 20, 'P', 'Candidats', '', 'Candidats', 'Curricullum vitae', 0, 0, 0, 'DCMEST', '', '30%', 10, 0, 0, '', 'Sas.inc'),
('SasHunter', 'Documents', 30, 'P', 'Documents', 'Candidats', 'Documents', 'Documents envoyés et reçus', 0, 0, 0, 'DCMEST', '', '30%', 0, 0, 0, '', 'Sas.inc'),
('SasHunter', 'MiniCandidats', 0, 'S', 'Candidats', '', 'MiniCandidats', '', 0, 0, 0, '', '', '30%', 0, 0, 0, NULL, '');



-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Lun 10 Novembre 2008 à 23:48
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- Structure de la table `actions`
--

DROP TABLE IF EXISTS `actions`;
CREATE TABLE `actions` (
  `CodeClient` varchar(8) collate utf8_bin NOT NULL default '',
  `CodeResp` varchar(8) collate utf8_bin NOT NULL default '',
  `Numero` int(6) NOT NULL default '0',
  `Rang` int(4) NOT NULL default '0',
  `DateCreation` date NOT NULL default '0000-00-00',
  `Utilisateur` varchar(32) collate utf8_bin NOT NULL default '',
  `TypeAction` varchar(8) collate utf8_bin NOT NULL default '',
  `Interlocuteur` varchar(32) collate utf8_bin default NULL,
  `DateAction` date default '0000-00-00',
  `HeureAction` varchar(5) collate utf8_bin default NULL,
  `DateLimite` date NOT NULL default '0000-00-00',
  `Statut` varchar(8) collate utf8_bin NOT NULL default '0',
  `Action` blob,
  PRIMARY KEY  (`CodeClient`,`CodeResp`,`Numero`,`Rang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `actions`
--

INSERT INTO `actions` (`CodeClient`, `CodeResp`, `Numero`, `Rang`, `DateCreation`, `Utilisateur`, `TypeAction`, `Interlocuteur`, `DateAction`, `HeureAction`, `DateLimite`, `Statut`, `Action`) VALUES
('Landwell', 'PL.M', 2, 1, '2008-01-20', 'François', 'Appel', 'Pierre Lemaire', '0000-00-00', '09:00', '2008-07-11', 'A FAIRE', 0x436f6e746163746572206c65203c666f6e7420636f6c6f723d2223666630303030223e436162696e6574203c2f666f6e743e3c7370616e207374796c653d22434f4c4f523a20726762283235352c302c3029223e3c7370616e207374796c653d22434f4c4f523a2072676228302c302c3029223e3c666f6e7420636f6c6f723d2223666630303030223e447576616c203c2f666f6e743e3c2f7370616e3e3c666f6e7420636f6c6f723d2223303030303030223e617520746f75742064266561637574653b62757420323030382e3c2f666f6e743e3c2f7370616e3e20),
('Landwell', 'PL.M', 3, 1, '2008-01-19', 'François', 'Appel', 'Stéphane Ledoux', '0000-00-00', '', '2008-07-23', 'A FAIRE', 0x5072697365206465205264562e),
('Landwell', 'PL.M', 1, 1, '2008-01-25', 'François', 'Réunion', 'Jean-Yves Moulin', '2008-06-06', '11:45', '2008-06-06', 'FAIT', 0x4661697265206c6520706f696e742064652073657320616d626974696f6e73206465206361727269e872652e),
('Landwell', 'PL.M', 1, 2, '2008-01-21', 'François', 'Courrier', 'P.L. Morin/J.J Ledoit', '0000-00-00', '09:00', '2008-06-29', 'FAIT', 0x456e766f79657220756e20636f75727269657220646520636f6e6669726d6174696f6e20e020502d4c204d6f72696e206176656320636f70696520e0204a2e4a204c65646f69742e),
('Landwell', 'PL.M', 1, 3, '2008-01-21', 'François', 'Réunion', 'P.Y. Moulin', '2008-06-21', '11:30', '0000-00-00', 'A FAIRE', 0x3c646976207374796c653d22746578742d616c69676e3a206c6566743b223e56e97269666965722073692063262333393b657374206269656e206c262333393b6f697365617520726172652e3c2f6469763e),
('Landwell', 'PL.M', 1, 4, '2008-01-24', 'François', 'Appel', 'Robert Dubois', '0000-00-00', '', '2008-06-10', 'A FAIRE', 0x417070656c657220526f62657274204475626f69732c206c262333393b616e6369656e20706174726f6e206465204a2e592e204d6f756c696e2e),
('Landwell', 'PL.M', 1, 5, '2008-01-25', 'François', 'Réunion', 'P.L. Morin et J.J. Ledoit', '2008-06-17', '13:00', '0000-00-00', 'A FAIRE', 0x4661697265206c6520706f696e7420737572206c65732066757475727320726563727574656d656e74732e),
('Landwell', 'PL.M', 1, 6, '2008-01-25', 'François', 'RdV', 'M. Galian', '2008-06-21', '12:00', '0000-00-00', 'A FAIRE', 0x44697363757373696f6e2067e96ee972616c6520),
('Landwell', 'PL.M', 1, 7, '2008-01-26', 'François', 'E-mail', 'Marie Lemaire', '0000-00-00', '', '2008-06-25', 'A FAIRE', 0x3c7370616e20636c6173733d2254657874654e6f726d616c223e50726576656e6972206c612063616e6469646174652064752072656a657420646520736f6e20646f73736965723c7370616e207374796c653d22636f6c6f723a2072676228302c20302c2030293b223e20706172206c6520636c69656e742e3c2f7370616e3e3c2f7370616e3e),
('Landwell', 'PL.M', 1, 8, '2008-03-01', 'François', 'Appel', 'Jean-Marie Ledoigt', '0000-00-00', '', '2008-06-25', 'A FAIRE', 0x266e6273703b44656d616e64657220e0204a65616e2d4d6172696520736f6e20617669732e3c62723e),
('RNUR', 'A-LEMA', 1, 1, '2008-02-06', '1', 'Appel', 'A. Lemarchand', '0000-00-00', '', '2008-06-20', 'A FAIRE', 0x4661697265207072266561637574653b636973657220266167726176653b20412e204c656d61726368616e64206c65206e69766561752065786163746520646520636f6d70266561637574653b74656e63652072657175697320706f7572206c6520706f7374652e3c6272202f3e5072656e64726520756e205264562064652072266561637574653b756e696f6e2e3c6272202f3e),
('RNUR', 'A-LEMA', 1, 2, '2008-02-06', '2', 'Réunion', 'Albert Mansard', '2008-06-24', '13:30', '0000-00-00', 'A FAIRE', 0x44697363757373696f6e20647520706f737465206368657a2052656e61756c742e2044266561637574653b7465726d696e6572206c6573206465736964657261746120656e206d617469266567726176653b72652064652072266561637574653b6e756d266561637574653b726174696f6e2e),
('RNUR', 'A-LEMA', 1, 3, '2008-02-06', '3', 'Appel', 'Antoine Lebras', '0000-00-00', '', '2008-06-24', 'A FAIRE', 0x4573736179657220646520636f6e6e612669636972633b74726520756e20706575206d6965757820736f6e2070726f66696c2e),
('Landwell', 'A.T', 2, 1, '2008-02-18', 'François', 'Appel', 'Alain Trichet', '0000-00-00', '', '2008-06-22', 'A FAIRE', 0x4c7569207061726c65722064752063616e6469646174204c6562726173206574206c756920656e766f79657220756e2043562e);

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

--
-- Structure de la table `adresses`
--

DROP TABLE IF EXISTS `adresses`;
CREATE TABLE `adresses` (
  `NoDossier` int(11) NOT NULL default '0',
  `RangAdresse` int(2) NOT NULL default '0',
  `Adresse` varchar(64) collate utf8_bin NOT NULL default '',
  `CodePostal` varchar(10) collate utf8_bin NOT NULL default '',
  `Ville` varchar(32) collate utf8_bin NOT NULL default '',
  `Pays` varchar(3) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`NoDossier`,`RangAdresse`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `adresses`
--

INSERT INTO `adresses` (`NoDossier`, `RangAdresse`, `Adresse`, `CodePostal`, `Ville`, `Pays`) VALUES
(20001, 1, '142, rue de Vaugirard', '75007', 'Paris', 'F'),
(20001, 2, '27, avenue de la Plage', '44500', 'La Baule', 'F'),
(20017, 1, '84, rue Lauriston', '75116', 'Paris', 'F'),
(20007, 1, '22, rue verte', '28100', 'Dreux', 'F'),
(20002, 1, '85, av. Paul Doumer', '75116', 'Paris', 'F'),
(20002, 2, '6, quai du Port', '44100', 'Saint-Nazaire', 'F'),
(20003, 1, '26, place saint-Sulpice', '75006', 'Paris', 'F'),
(20005, 1, '27, rue Vineuse', '75116', 'Paris', 'F'),
(20010, 1, 'Friedrichstrasse, 22', '56890', 'München', 'D'),
(20009, 1, '25, rue du Havre', '75009', 'Paris', 'F'),
(20009, 2, '65, Corso Garibaldi', '40000', 'Milano', 'I'),
(20004, 1, '127, rue de Carouge', '1205', 'Genève', 'CH'),
(20018, 1, '53, rue Michel-Ange', '75016', 'Paris', 'F'),
(20006, 1, '58, Bd Berthier', '75020', 'Paris', 'F'),
(20016, 1, '58, rue Edouard Choquet', '92200', 'Boulogne', 'F');

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

--
-- Structure de la table `candidats`
--

DROP TABLE IF EXISTS `candidats`;
CREATE TABLE `candidats` (
  `NoDossier` int(6) NOT NULL default '0',
  `Nom` varchar(32) collate utf8_bin NOT NULL default '',
  `Prenom` varchar(32) collate utf8_bin NOT NULL default '',
  `NomMarital` varchar(32) collate utf8_bin default NULL,
  `Naissance` date NOT NULL default '0000-00-00',
  `Nationalite1` varchar(3) collate utf8_bin NOT NULL,
  `Nationalite2` varchar(3) collate utf8_bin default NULL,
  `Disponibilite` date default NULL,
  `Situation` set('C','M','D','V','P') collate utf8_bin NOT NULL default '',
  `Sexe` set('M','F') collate utf8_bin NOT NULL default '',
  `Photo` varchar(72) collate utf8_bin default NULL,
  `Metier` varchar(8) collate utf8_bin default NULL,
  `DebutMetier` int(11) default NULL,
  `Specialite` varchar(8) collate utf8_bin NOT NULL,
  `SalaireActuel` int(8) default '0',
  `Honoraires` int(8) default '0',
  `Voiture` tinyint(1) NOT NULL default '0',
  `SalaireDemande` int(8) default '0',
  PRIMARY KEY  (`NoDossier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `candidats`
--

INSERT INTO `candidats` (`NoDossier`, `Nom`, `Prenom`, `NomMarital`, `Naissance`, `Nationalite1`, `Nationalite2`, `Disponibilite`, `Situation`, `Sexe`, `Photo`, `Metier`, `DebutMetier`, `Specialite`, `SalaireActuel`, `Honoraires`, `Voiture`, `SalaireDemande`) VALUES
(20001, 'Moulin', 'Jean-Yves', '', '1958-11-10', 'F', '', '2007-05-02', 'M', 'M', './Photos/20001_Photo_Gibson.jpg|Gibson.jpg', 'AVO', NULL, '', 70000, 25000, 1, 90000),
(20002, 'Mirabelle', 'Marie-Louise', 'Prunier', '1965-03-18', 'F', '', '2007-08-01', 'M', 'F', './Photos/20002_Photo_Marilyn.jpg|Marilyn.jpg', 'AVO', 1963, '', 40000, 0, 0, 45000),
(20003, 'Lebief', 'Théodore', '', '1965-10-15', 'F', '', '2008-03-03', 'M', 'M', './Photos/20003_Photo_DiCaprio.jpg|DiCaprio.jpg', 'CONS', NULL, '', 36000, 0, 1, 40000),
(20005, 'Lebras', 'Antoine', '', '1955-08-25', 'F', '', '2007-07-01', 'C', 'M', './Photos/20005_Photo_1001_Photo_Matthieu_Id_1.jpg|1001_Photo_Matthieu_Id', '', NULL, '', 32000, 0, 1, 35000),
(20004, 'Lefevre', 'Jean-Yves', '', '1971-10-23', 'CH', 'D', '2007-06-05', 'M', 'M', './Photos/20004_Photo_Gibson.jpg|Gibson.jpg', 'INGE', 1963, '', 50000, 15000, 1, 60000),
(20006, 'Lerouge', 'Bertrand', '', '1980-08-20', 'F', '', '2007-04-15', 'M', 'M', './Photos/20006_Photo_Pitt.jpg|Pitt.jpg', 'INGE', 1963, 'SOFTW', 40000, 0, 0, 45000),
(20007, 'Mansard', 'Albert', '', '1970-02-24', 'F', '', '2007-05-15', 'P', 'M', './Photos/20007_Photo_Kutcher.jpg|Kutcher.jpg', 'CONS', NULL, '', 45000, 0, 1, 50000),
(20010, 'Von Ratenau', 'Gertrud', '', '1959-09-18', 'D', '', '2007-09-10', 'C', 'F', './Photos/20010_Photo_McPherson.jpg|McPherson.jpg', 'COM', 1963, '', 45000, 0, 0, 50000),
(20009, 'Buzzatti', 'Mirella', 'Lumière', '1972-05-25', 'I', 'F', '2008-11-30', 'M', 'F', './Photos/20009_Photo_Fabian.jpg|Fabian.jpg', 'AVO', 1998, 'AFFAIRES', 40000, 12000, 0, 50000),
(20017, 'Hirondelle', 'Jean-Marc', '', '1968-09-30', 'F', '', '2008-04-01', 'M', 'M', './Photos/20017_Photo_Russel.jpg|Russel.jpg', 'AVO', 1963, 'AFFAIRES', 32000, 0, 1, 35000),
(20018, 'Lamentin', 'Edouard', '', '1982-10-20', 'CH', '', '2007-05-10', 'C', 'M', './Photos/20020_Photo_Seth_Green.jpg|Seth_Green.jpg', 'COM', NULL, '', 50000, 0, 0, 55000),
(20016, 'Loiseau', 'Arthur', '', '1974-10-30', 'F', '', '2008-05-01', 'M', 'M', './Photos/20016_Photo_Del_Toro.jpg|Del_Toro.jpg', 'CONS', NULL, '', 50000, 0, 1, 54000),
(20024, 'Morollon', 'Bernard', '', '1980-11-25', 'F', 'CH', '2009-01-26', 'C', 'M', './Photos/20024_Photo_Del_Toro.jpg|Del_Toro.jpg', 'INGE', 2000, 'ELECTR', 30000, 0, 0, 30000);

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

--
-- Structure de la table `clients`
--

DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
  `CodeClient` varchar(8) collate utf8_bin NOT NULL default '',
  `RaisonSociale` varchar(32) collate utf8_bin NOT NULL default '',
  `CodeGroupe` varchar(8) collate utf8_bin NOT NULL default '',
  `CodeSecteur` varchar(8) collate utf8_bin NOT NULL default '',
  `Adresse` varchar(128) collate utf8_bin default NULL,
  `CodePostal` varchar(10) collate utf8_bin default NULL,
  `Ville` varchar(32) collate utf8_bin default NULL,
  `Pays` varchar(3) collate utf8_bin NOT NULL default 'F',
  `Telephone` varchar(16) collate utf8_bin default NULL,
  `Fax` varchar(16) collate utf8_bin default NULL,
  `SiteWeb` varchar(64) collate utf8_bin default NULL,
  PRIMARY KEY  (`CodeClient`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `clients`
--

INSERT INTO `clients` (`CodeClient`, `RaisonSociale`, `CodeGroupe`, `CodeSecteur`, `Adresse`, `CodePostal`, `Ville`, `Pays`, `Telephone`, `Fax`, `SiteWeb`) VALUES
('Landwell', 'Landwell and Co.', '', 'CAB-A', '12, rue Guersant', '75017', 'Paris', 'F', '01 04 25 50', '01 04 25 25', 'info.landwell.com'),
('Total', 'Total-Elf', '', 'PME-I', 'Tour Elf\r\nLa Défense', '92300', 'Courbevoie', 'F', '01 45 02 03 04', '01 45 26 22 05', 'www.elftotalfina.com'),
('RNUR', 'Renault SA', 'REN-NIS', 'GR-I', '13-15 Quai Le Gallo', '92100', 'Boulogne-Billancourt', 'F', '01 41 04 64 85', '', 'www.renault.com');

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

--
-- Structure de la table `collaborateurs`
--

DROP TABLE IF EXISTS `collaborateurs`;
CREATE TABLE `collaborateurs` (
  `Identification` varchar(32) collate utf8_bin NOT NULL default '',
  `PassWord` varchar(32) collate utf8_bin NOT NULL default '',
  `Titre` varchar(8) collate utf8_bin NOT NULL default '',
  `Nom` varchar(32) collate utf8_bin NOT NULL default '',
  `Prenom` varchar(24) collate utf8_bin NOT NULL default '',
  `Niveau` int(3) NOT NULL default '0',
  PRIMARY KEY  (`Identification`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `collaborateurs`
--

INSERT INTO `collaborateurs` (`Identification`, `PassWord`, `Titre`, `Nom`, `Prenom`, `Niveau`) VALUES
('François', '07d941bb0fb41b7db4788b04650d2693', 'M', 'Galian', 'François', 10),
('Matthieu', 'baaf5fc7a70663426c03afe5ab4e0526', 'M', 'Galian', 'Matthieu', 5),
('Mirella', '75ae464ee64b63a85ae221a07604f7d7', 'Mle', 'Rossi', 'Mirella', 10);

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

--
-- Structure de la table `contacts`
--

DROP TABLE IF EXISTS `contacts`;
CREATE TABLE `contacts` (
  `NoDossier` int(11) NOT NULL default '0',
  `RangContact` int(3) NOT NULL default '0',
  `Date` date NOT NULL default '0000-00-00',
  `Type` varchar(12) collate utf8_bin NOT NULL default '',
  `Commentaires` blob,
  PRIMARY KEY  (`NoDossier`,`RangContact`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `contacts`
--

INSERT INTO `contacts` (`NoDossier`, `RangContact`, `Date`, `Type`, `Commentaires`) VALUES
(20001, 0, '2006-11-17', 'Téléphone', 0x417070656c2064752063616e64696461742e20496c206d652066616974207061727420646520736f6e2064e9736972206465206d652072656e636f6e7472657220706f7572207061726c6572206465207365732070726f6a6574732e204e6f7573206669786f6e7320756e6520646174652c206c652031302f31322f323030362e4a65206c75692064656d616e646520e967616c656d656e74206465206d262333393b656e766f79657220756e65206c6574747265206465206d6f7469766174696f6e20657420736f6e2043562e3c42523e3c454d3e496c206d652070617261ee7420746f7574206465206dea6d6520756e207065752068e9736974616e74206574206a65206d652064656d616e646520636f6d6d656e7420696c20736520636f6d706f727465726120646576616e74206c6520636c69656e742e3c2f454d3e20446520706c75732c20696c2073656d626c652068e9736974616e742c207175616e7420e020736120646174652064652064e9706172742e),
(20001, 2, '2006-12-10', 'Réunion', 0x4a652072652663636564696c3b6f6973206c652063616e64696461742e20496c206d652073656d626c652061766f6972207175656c717565732070726f626c266567726176653b6d6573206176656320736f6e20656d706c6f796575722061637475656c20657420636865726368657220756e6520617574726520766f69652e3c6272202f3e4a65206c75692064656d616e64652064652073652070722665636972633b74657220266167726176653b20756e203c7370616e207374796c653d22666f6e742d7374796c653a206974616c69633b223e656e7472657469656e2064262333393b266561637574653b76616c756174696f6e3c2f7370616e3e20657420646573203c7370616e207374796c653d22666f6e742d7374796c653a206974616c69633b223e74657374733c2f7370616e3e2e3c6272202f3e),
(20002, 1, '2007-05-20', 'Téléphone', 0x4c612063616e6469646174652073656d626c652070657574207361746973666169746520646520736f6e207472617661696c2e20456c6c6520736572616974206c6962726520696d6de964696174656d656e742073616e73207072e9617669732028e0206ee9676f63696572292e203c62723e3c7370616e207374796c653d22666f6e742d7374796c653a206974616c69633b20636f6c6f723a207267622835312c2035312c20323535293b223e4c6520646f73736965722065737420e020636f6e73657276657220736f7573206c6520636f7564652e3c2f7370616e3e3c62723e),
(20003, 1, '2007-12-15', 'Courrier', 0x4c65747472652064652063616e64696461747572652066616973616e7420737569746520266167726176653b206c262333393b616e6e6f6e63652070617373266561637574653b652064616e73206c65203c7370616e207374796c653d22666f6e742d7374796c653a206974616c69633b20666f6e742d7765696768743a20626f6c643b223e46696761726f3c2f7370616e3e),
(20003, 2, '2008-01-16', 'Téléphone', 0x4c652063616e646964617420636f6e74696e756520266167726176653b20736520706f7365722062656175636f7570206465207175657374696f6e732073757220736f6e206176656e69722e),
(20005, 1, '2007-12-24', 'Courrier', 0x4c65747472652064652063616e6469646174757265207375697420e0206c262333393b616e6e6f6e63652070617275652064616e73206c65203c5350414e207374796c653d22464f4e542d5745494748543a20626f6c643b20464f4e542d5354594c453a206974616c6963223e46696761726f2e3c2f5350414e3e),
(20009, 1, '2008-01-14', 'Courrier', 0x4c65747472652073706f6e74616ee9652e204d657420656e206176616e7420736f6e2070726f66696c6520696e7465726e6174696f6e616c20617373657a206f726967696e616c2065742073657320636f6e6e61697373616e636573206c696e677569737469717565732072656d6172717561626c65732e203c666f6e7420636f6c6f723d2223666630303030223e3c693e43616e646964617465207472e87320696e746572657373616e74652e3c2f693e3c2f666f6e743e),
(20017, 1, '2008-01-16', 'Courrier', 0x4c65747472652073706f6e74616ee9652064656d616e64616e7420e020636f6e6e61ee747265206c6573206f70706f7274756e6974e9732e203c7370616e207374796c653d22666f6e742d7374796c653a206974616c69633b223e4d616e717565206465207072e9636973696f6e207175616e7420e02073657320656d706c6f6973207072e963e964656e74732e3c2f7370616e3e3c62723e),
(20017, 2, '2008-02-04', 'Réunion', 0x4c652063616e64696461742073656d626c6520706575206865757265757820646520736f6e20706f7374652061637475656c2c2073616e7320726170706f727420617665632073657320636f6d70e974656e6365732c20657374696d652d74262333393b696c2e3c42523e496c206368657263686520756e207365636f6e6420736f7566666c652e3c42523e),
(20018, 1, '2008-02-04', 'Téléphone', 0x52656368657263686520756e20706f73746520656e204672616e63652c206465207072e966e972656e636520e0205061726973206f7520656e2072e967696f6e205268f46e652d416c7065732e3c62723e),
(20006, 1, '2008-01-24', 'Email', 0x412064266561637574653b6d6973696f6e6e266561637574653b20646520736f6e20706f73746520656e20726169736f6e2064262333393b756e20636f6e666c6974206176656320736f6e2061646d696e697374726174696f6e2e3c6272202f3e3c7370616e207374796c653d22666f6e742d7374796c653a206974616c69633b223e4120656e766f79266561637574653b206c65206d2665636972633b6d6520656d61696c20266167726176653b206465206e6f6d627265757820636162696e6574213c6272202f3e3c2f7370616e3e3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b223e43616e64696461742073266561637574653b72696575783f3f3f3c2f7370616e3e3c7370616e207374796c653d22666f6e742d7374796c653a206974616c69633b223e3c6272202f3e3c2f7370616e3e),
(20016, 1, '2007-12-12', 'Courrier', 0x456e766f6920646520736f6e2043562e),
(20016, 2, '2008-01-03', 'Réunion', 0x4c652070726f66696c652065737420617373657a207370e96369616c6973e920286de963616e69717565292c206d616973206176656320756e6520696e64e96e6961626c6520636f6d70e974656e63652e20436563692070657574206661697265206c612064696666e972656e63652e3c62723e),
(20007, 1, '2008-01-30', 'Courrier', 0x4e6f757320266561637574653b6372697420737572207265636f6d6d616e646174696f6e206465204a50204d6172746561752e20496c20766f756472616974206368616e67657220646520736f6369266561637574653b74266561637574653b20746f757420656e2072657374616e742064616e73206c262333393b617373757272616e63652e),
(20007, 2, '2008-02-05', 'Réunion', 0x456e20636f757273206465206c612072266561637574653b756e696f6e2c206c652063616e646964617420636f6e6669726d6520736f6e2064266561637574653b736972206465206368616e67656d656e742c20266167726176653b206c612072656368657263686520646520706c757320646520726573706f6e736162696c6974266561637574653b732e),
(20010, 1, '2008-02-04', 'Email', 0x72266561637574653b706f6e736520266167726176653b206c262333393b616e6e6f6e63652070617373266561637574653b20737572203c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b20666f6e742d7374796c653a206974616c69633b223e43616472656d706c6f69203c2f7370616e3e6c652032352f312f323030382e),
(20001, 3, '2008-02-15', 'Réunion', 0x4a65207265766f6973206c652063616e64696461742c20646f6e74206c6120706f736974696f6e2073656d626c652073262333393b6173736f75706c69722c20656e20706172746963756c69657220647520636f74e92073616c616972652e3c62723e496c2066617574207072e9766f697220756e206e6f7576656c20656e7472657469656e2e3c62723e);

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

--
-- Structure de la table `cursus`
--

DROP TABLE IF EXISTS `cursus`;
CREATE TABLE `cursus` (
  `NoDossier` int(11) NOT NULL default '0',
  `RangFormation` int(2) NOT NULL default '0',
  `Etablissement` varchar(64) collate utf8_bin NOT NULL default '',
  `Specialite` varchar(32) collate utf8_bin default NULL,
  `Diplome` varchar(8) collate utf8_bin default NULL,
  `AnneeEntree` year(4) NOT NULL default '0000',
  `AnneeSortie` year(4) NOT NULL default '0000',
  PRIMARY KEY  (`NoDossier`,`RangFormation`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `cursus`
--

INSERT INTO `cursus` (`NoDossier`, `RangFormation`, `Etablissement`, `Specialite`, `Diplome`, `AnneeEntree`, `AnneeSortie`) VALUES
(20001, 1, 'Stanislas', 'Scientifique', 'BAC-S', 1960, 1964),
(20001, 2, 'Ecole polytechnique', '', 'D-E', 1968, 1970),
(20001, 3, 'Ecole Supérieure de l''aéronautique', 'Moteur', 'D-E', 1971, 1972),
(20002, 1, 'Sainte-Marie', 'Scientifique', 'BAC-S', 1982, 1985),
(20002, 2, 'Stanislas', 'PREP-HEC', '', 1986, 1987),
(20017, 1, 'Henri-IV', 'Section Math', 'BAC-S', 1988, 1994),
(20002, 3, 'HEC', 'Commerce International', 'D-E', 1988, 1991),
(20007, 1, 'Saint-Pierre de Dreux', 'Scientifique', 'BAC-S', 1976, 1982),
(20007, 2, 'Université de Droit de Malakoff', 'DESS-DR', 'M-DROIT', 1982, 1987),
(20007, 3, 'HEC', 'Marketing', 'D-E', 1988, 1991),
(20003, 1, 'Lycée Ampère', 'Lettres', 'BAC-C', 1991, 1996),
(20003, 2, 'Lycée Ampère', 'PREP-HEC', '', 1996, 1998),
(20003, 3, 'ESSEC', 'Droit commercial', '', 1998, 2000),
(20005, 1, 'Lycée Ampère', 'Scientifique', 'BAC-S', 1992, 1997),
(20005, 2, 'Lycée Ampère', 'PREP-HEC', '', 1998, 1999),
(20005, 3, 'Université de Rouen', 'Expertise-comptable', 'EX-COMPT', 2000, 2003),
(20004, 1, 'Lycée Janson de Sailly', 'BAC-S', '', 1992, 1996),
(20004, 2, 'Polytechnique', 'X', '', 1998, 2000),
(20010, 1, 'Lycée Janson de Sailly', 'BAC-T', '', 1990, 1996),
(20009, 1, 'Scuola Santa Maria', 'Lettres italiennes', 'BAC-S', 1990, 1996),
(20009, 2, 'HEC', 'Commerce International', 'D-E', 2000, 2003),
(20017, 2, 'Henri IV', 'Math Sup./Spé', '', 1994, 1996),
(20017, 3, 'Ecole des Mines', 'Maîtrise d''oeuvre', 'D-E', 1996, 1999),
(20018, 1, 'Lycée communal de Neufchatel', 'Economique', 'BAC-S', 1988, 1996),
(20018, 2, 'Université de Fribourg', 'Sciences économiques', '', 1994, 1998),
(20006, 1, 'Lycée communal d''Evry', 'Technologies', 'BAC-T', 1988, 1995),
(20006, 2, 'IUT d''Orsay', 'Informatique', 'IUT-Mec', 1995, 1999),
(20016, 1, 'Lycée de Fontainebleau', 'Scientifique', 'BAC-S', 1982, 1986),
(20016, 2, 'Lycée Louis-le-Grand', 'Math. Sup./Spé.', '', 1986, 1989),
(20016, 3, 'Ecole centrale de Paris', 'Mécanique des fluides', 'X-CH', 1989, 1992),
(20010, 2, 'HEC', 'Commerce international', 'D-E', 1996, 1999),
(20009, 3, 'Insead', 'Fiscalité internationale', 'D-E', 2004, 2006);

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

--
-- Structure de la table `diplomes`
--

DROP TABLE IF EXISTS `diplomes`;
CREATE TABLE `diplomes` (
  `Code` varchar(8) collate utf8_bin NOT NULL default '',
  `Libelle` varchar(64) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `diplomes`
--

INSERT INTO `diplomes` (`Code`, `Libelle`) VALUES
('HEC', 'Hautes Etudes Commerciales'),
('DESS-DR', 'DESS de droit'),
('X', 'Polytechnique'),
('SUPAERO', 'Ecole supérieure de l''aéronautique'),
('IUT-Inf', 'DUT d''informatique'),
('P-M-C', 'Université Pierre et Marie Curie'),
('BAC-C', 'Baccalauréat C'),
('BAC-S', 'Baccalauréat S'),
('BAC-T', 'Baccalauréat Technique'),
('IUT-Comp', 'DUTde Comptabilité'),
('PREP-HEC', 'Préparation HEC'),
('ESSEC', 'ESSEC (Pontoise)'),
('SUPDECO', 'Ecole Supérieure de Commerce de Paris'),
('A-E', 'Ancien élève'),
('D-E', 'Diplôme de l''école'),
('X-CH', 'Ecole polytechnique de Lausanne'),
('M-DROIT', 'Maîtrise de Droit'),
('IUT-Mec', 'DUT de mécanique'),
('EX-COMPT', 'Expert-comptable');

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

--
-- Structure de la table `documentation`
--

DROP TABLE IF EXISTS `documentation`;
CREATE TABLE `documentation` (
  `Page` int(3) NOT NULL auto_increment,
  `Chapitre` varchar(3) collate utf8_bin NOT NULL default '',
  `Rang` varchar(6) collate utf8_bin NOT NULL default '0',
  `Sujet` varchar(64) collate utf8_bin NOT NULL default '',
  `TexteHaut` text collate utf8_bin,
  `Image` varchar(64) collate utf8_bin default NULL,
  `TexteBas` text collate utf8_bin,
  PRIMARY KEY  (`Page`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=11 ;

--
-- Contenu de la table `documentation`
--

INSERT INTO `documentation` (`Page`, `Chapitre`, `Rang`, `Sujet`, `TexteHaut`, `Image`, `TexteBas`) VALUES
(1, 'DEM', 'DEM-10', 'Identifiez-vous', 0x3c7370616e20636c6173733d224170706c652d7374796c652d7370616e22207374796c653d22626f726465722d636f6c6c617073653a20636f6c6c617073653b20636f6c6f723a2072676228302c20302c2030293b20666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b20666f6e742d73697a653a20313670783b20666f6e742d7374796c653a206e6f726d616c3b20666f6e742d76617269616e743a206e6f726d616c3b20666f6e742d7765696768743a206e6f726d616c3b206c65747465722d73706163696e673a206e6f726d616c3b206c696e652d6865696768743a206e6f726d616c3b206f727068616e733a20323b20746578742d616c69676e3a206c6566743b20746578742d696e64656e743a203070783b20746578742d7472616e73666f726d3a206e6f6e653b2077686974652d73706163653a206e6f726d616c3b207769646f77733a20323b20776f72642d73706163696e673a203070783b223e3c7370616e2074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d2222207374796c653d22666f6e742d73697a653a20313270743b20666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b223e3c666f6e74207374796c653d22636f6c6f723a207267622835312c2035312c20323535293b222073697a653d2235223e4964656e74696669657a2d766f7573213c2f666f6e743e3c62723e3c62723e4c6f727371756520766f757320766f756c657a2064c3a96d6172726572206c262333393b6170706c69636174696f6e20224368617373652064652074c3aa7465222c206c61207072656d69c3a872652063686f73652071756520766f757320646576657a2066616972652065737420646520766f7573206964656e7469666965722c20656e20696e74726f64756973616e743a3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c756c207374796c653d22666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b2220747970653d2264697363223e3c6c6920636c6173733d224d736f4e6f726d616c22207374796c653d226c696e652d6865696768743a206e6f726d616c3b223e3c7370616e2074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d2222207374796c653d22666f6e742d73697a653a20313270743b223e766f747265206e6f6d2c3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f6c693e3c6c6920636c6173733d224d736f4e6f726d616c22207374796c653d226c696e652d6865696768743a206e6f726d616c3b223e3c7370616e2074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d2222207374796c653d22666f6e742d73697a653a20313270743b223e766f747265206d6f742064652070617373652c3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f6c693e3c2f756c3e3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e2074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d2222207374796c653d22666f6e742d73697a653a20313270743b206c696e652d6865696768743a20313135253b223e3c7370616e207374796c653d22666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b223e74656c73207175262333393b696c73206f6e7420c3a974c3a92064c3a966696e697320706f757220766f757320706172206c6520526573706f6e7361626c65206465206c262333393b6170706c69636174696f6e2e3c2f7370616e3e3c6272207374796c653d22666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b223e3c6272207374796c653d22666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b223e3c62207374796c653d22666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b223e3c7370616e207374796c653d22636f6c6f723a207265643b223e417474656e74696f6e3a3c2f7370616e3e3c2f623e3c7370616e207374796c653d22666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b223e3c7370616e20636c6173733d224170706c652d636f6e7665727465642d7370616365223e203c2f7370616e3e52657370656374657a206269656e206c6573206d616a757363756c6573206574206c6573206d696e757363756c65732c2074656c6c6573207175262333393b656c6c6573206f6e7420c3a974c3a920656e72656769737472c3a9657320706f757220766f75732064616e73206c6520736572766575722e3c2f7370616e3e3c2f7370616e3e3c2f703e3c2f7370616e3e3c7370616e207374796c653d22223e3c2f7370616e3e, './Photos/DEM-10_Image_DEM-10.jpg|DEM-10.jpg', 0x3c7370616e20636c6173733d224170706c652d7374796c652d7370616e22207374796c653d22626f726465722d636f6c6c617073653a20636f6c6c617073653b20636f6c6f723a2072676228302c20302c2030293b20666f6e742d66616d696c793a20262333393b54696d6573204e657720526f6d616e262333393b3b20666f6e742d73697a653a20313670783b20666f6e742d7374796c653a206e6f726d616c3b20666f6e742d76617269616e743a206e6f726d616c3b20666f6e742d7765696768743a206e6f726d616c3b206c65747465722d73706163696e673a206e6f726d616c3b206c696e652d6865696768743a206e6f726d616c3b206f727068616e733a20323b20746578742d616c69676e3a206c6566743b20746578742d696e64656e743a203070783b20746578742d7472616e73666f726d3a206e6f6e653b2077686974652d73706163653a206e6f726d616c3b207769646f77733a20323b20776f72642d73706163696e673a203070783b223e506f7572206368616e67657220766f747265206d6f742064652070617373652c20696c206661757420666169726520617070656c20617520526573706f6e7361626c65206465206c262333393b6170706c69636174696f6e2e3c2f7370616e3e),
(2, 'DEM', 'DEM-20', 'Choisissez une application', 0x3c666f6e742073697a653d2235223e3c7370616e207374796c653d22636f6c6f723a207267622835312c2035312c20323535293b223e43686f6973697373657a20756e65206170706c69636174696f6e3c2f7370616e3e3c2f666f6e743e3c62723e3c62723e3c666f6e742073697a653d2233223e43686163756e206465732063696e71207072656d6965727320626f75746f6e732073697475c3a97320c3a02064726f69746520766f7573207065726d65742064262333393b616363c3a964657220c3a020756e65206170706c69636174696f6e2064696666c3a972656e74652e204c652073697869c3a86d6520766f757320646f6e6e6520616363c3a87320c3a0206365206d616e75656c20656e2d6c69676e652e203c2f666f6e743e3c62723e, './Photos/DEM-20.jpg|DEM-20.jpg', 0x3c666f6e742073697a653d2233223e204c65732063696e71206170706c69636174696f6e7320766f7573207065726d657474656e742064653c62723e3c2f666f6e743e3c6f6c3e3c6c693e3c666f6e742073697a653d2233223e436f6e73756c746572206c61206c69737465206465732063616e64696461747320706f74656e7469656c732c206c65732073c3a96c656374696f6e6e6572206574206c65732074726965722c20636f6e6e61c3ae74726520746f75746573206c657320696e666f726d6174696f6e2072656c61746976657320c3a020756e2063616e646964617473206574206c6573206d6f646966696572207369206ec3a963657373616972652c2061696e7369207175652064652064262333393b696e74726f6475697265206465206e6f7576656175782063616e6469646174732e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e47c3a9726572206c262333393b656e73656d626c652064657320636c69656e7473206574206465206c6575727320726573706f6e7361626c657320647520726563727574656d656e742c2067c3a9726572206c6573206d697373696f6e73207175262333393b696c7320766f757320636f6e6669656e74206574206c6575722070726f706f736572206465732063616e6469646174732e20456c6c6520766f7573207065726d6574206175737369206465207375697672652063686171756520726563727574656d656e742c20656e206e6f74616e74206c65732072656e64657a2d766f7573206574206c657320616374696f6e7320c3a02066616972652e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e436f6e73756c74657220657420696d7072696d6572206c6120666963686520636f6d706cc3a874652064262333393b756e2063616e64696461742e2043262333393b657374206c652070656e73652d62c3aa7465206964c3a9616c20706f757220756e652072c3a9756e696f6e2061766563206c652063616e6469646174206f752061766563206c6520636c69656e742e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e436f6e73756c74657220766f747265206167656e64612064652072656e64657a2d766f757320657420766f747265206c697374652064657320616374696f6e7320c3a02066616972652c20746f75746573206d697373696f6e7320636f6e666f6e647565732e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4372c3a96572206574206d657474726520c3a0206a6f757220746f75746573206c6573207461626c657320616e6e657865732c20636f6d6d756e65732061757820617574726573206170706c69636174696f6e732c2074656c6c6573206c657320262333393b50617973262333393b2c206c657320262333393b4469706cc3b46d6573262333393b2c206c657320262333393b4dc3a97469657273262333393b206574632e3c2f666f6e743e3c62723e3c2f6c693e3c2f6f6c3e),
(3, 'DEM', 'DEM-30', 'Utilisez une application', 0x3c666f6e74207374796c653d22636f6c6f723a207267622835312c2035312c20323535293b222073697a653d2235223e5574696c6973657a20756e65206170706c69636174696f6e3c2f666f6e743e3c62723e3c62723e3c666f6e742073697a653d2233223e417072c3a8732061766f69722063686f69736920766f747265207072656d69c3a87265206170706c69636174696f6e2c206c652070616e6e65617520636f72726573706f6e64616e742061707061726169742e20456e20686175742064652063652070616e6e6561752c20756e652073c3a972696520646520626f75746f6e73207065726d657420646520262333393b6e61766967756572262333393b2064616e73206c61206261736520646520646f6e6ec3a965732e3c62723e3c62723e43657320626f75746f6e732064c3a970656e64656e7420646520636861717565206170706c69636174696f6e20657420736f6e742064c3a97461696c6cc3a9732064616e73206c65732063686170697472657320636f72726573706f6e64616e74733c2f666f6e743e3c62723e, './Photos/DEM-30_Image_DEM-30.jpg|DEM-30.jpg', 0x3c62723e3c666f6e742073697a653d2233223e4c6573207072696e6369706573206465206c61206e617669676174696f6e2064616e73206c61206261736520646520646f6e6ec3a9657320736f6e74206578706c697175c3a9732064616e73206c652063686170697472652073756976616e743a20262333393b3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b223e4e617669676174696f6e3c2f7370616e3e262333393b2e3c2f666f6e743e3c62723e),
(4, 'NAV', 'NAV-10', 'Principes d’une base de données', 0x3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e207374796c653d22666f6e742d73697a653a20313870743b206c696e652d6865696768743a20313135253b20636f6c6f723a207267622835312c2035312c20323535293b222074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d222220636f6c6f723a3d2222207267622835312c3d22222035312c3d222220323535293b3d22223e5072696e63697065732064e28099756e65206261736520646520646f6e6ec3a965733c2f7370616e3e3c7370616e207374796c653d22666f6e742d73697a653a20313270743b206c696e652d6865696768743a20313135253b222074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d22223e3c62723e3c62723e436f6d6d6520746f75746573206c657320626173657320646520646f6e6ec3a965732072656c6174696f6e6e656c6c65732c2063656c6c652d63692065737420666f726dc3a9652064e28099756e20656e73656d626c6520646520262333393b5461626c6573262333393b2e20436861717565207461626c652065737420756e20656e73656d626c6520646520262333393b466963686573262333393b2c206179616e7420746f75746573206c6573206dc3aa6d657320747970657320646520646f6e6ec3a965732e20506172206578656d706c652c206368617175652063616e646964617420706f7373c3a8646520756e65206669636865206574206ce28099656e73656d626c6520646520746f75746573206365732066696368657320666f726d65206c61207461626c652064657320262333393b43616e646964617473262333393b2e3c2f7370616e3e3c2f703e3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e207374796c653d22666f6e742d73697a653a20313270743b206c696e652d6865696768743a20313135253b222074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d22223e456e2072c3a9616c6974c3a92c20706f75722072617373656d626c657220746f75746573206c657320696e666f726d6174696f6e7320636f6e6365726e616e7420756e2063616e64696461742c20756e65207365756c65206669636865206e6520737566666974207061732c20636172206365727461696e657320646f6e6ec3a9657320736f6e74206d756c7469706c65732e20506172206578656d706c652c20756e2063616e646964617420706575742061766f697220706c757369657572732061647265737365732c20706c75736965757273206e756dc3a9726f732064652074c3a96cc3a970686f6e6573206f7520706c75736965757273206469706cc3b46d65732e20506f7572206c65732072657072c3a973656e7465722c20696c206661757420616c6f72732072c3a9706172746972206c657320696e666f726d6174696f6e732073757220706c75736965757273206669636865732c2073616368616e74207175e28099756e206dc3aa6d652063616e6469646174206175726120706c757369657572732066696368657320262333393b4164726573736573262333393b2c20706c757369657572732066696368657320262333393b4e756dc3a9726f2064652074c3a96cc3a970686f6e6573262333393b206574632e20417520746f74616c2c206c657320696e666f726d6174696f6e7320636f6e6365726e616e74206c65732063616e646964617473207365726f6e742072c3a9706172746965732064616e7320706c75736965757273207461626c65732e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e, './Photos/NAV-10.jpg|NAV-10.jpg', 0x3c7370616e207374796c653d22666f6e742d73697a653a20313270743b206c696e652d6865696768743a20313135253b222074696d65733d2222206e65773d222220726f6d616e3d2222202c3d22222073657269663d2222203b3d22223e4c6573207461626c657320736f6e742072656c69c3a9657320656e74726520656c6c6573207061722064657320262333393b436c656673262333393b20636f6d6d756e65732e2041696e73692c2063686171756520666963686520262333393b43616e6469646174262333393b20706f7373c3a8646520756e20262333393b4e756dc3a9726f20646520646f7373696572262333393b20636f6d6d6520636c65662065742063686171756520666963686520262333393b41647265737365262333393b20706f7373c3a86465206c65206dc3aa6d65206e756dc3a9726f20646520646f73736965722c206166696e206465206c6573206d657474726520656e2072656c6174696f6e2e20496c20656e20657374206465206dc3aa6d6520706f75722063686171756520666963686520262333393b4e756dc3a9726f2064652074c3a96cc3a970686f6e65262333393b206574632e3c2f7370616e3e203c62723e3c62723e3c666f6e742073697a653d2233223e3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b20636f6c6f723a20726762283235352c20302c2030293b223e4365207175262333393b696c206661757420726574656e6972206176616e7420746f757420646520636574746520646973706f736974696f6e2c2063262333393b65737420717565206c262333393b6f6e20646f697420746f756a6f7572732073c3a96c656374696f6e6e657220756e65206669636865206465206c61207461626c6520737570c3a97269657572652028262333393b43616e646964617473262333393b2920706f757220706f75766f697220616363c3a9646572206175782066696368657320646573207461626c65732071756920656e2064c3a970656e64656e742028262333393b4164726573736573262333393b2c20262333393b4e756dc3a9726f732064652074c3a96cc3a970686f6e65262333393b2c206574632e2e292e3c2f7370616e3e3c2f666f6e743e3c62723e),
(5, 'NAV', 'NAV-20', 'Liste d''une table', 0x3c666f6e74207374796c653d22636f6c6f723a207267622835312c203130322c20323535293b222073697a653d2235223e4c697374652064262333393b756e65207461626c653c2f666f6e743e3c62723e3c666f6e742073697a653d2233223e3c62723e4c6f7273717565206c262333393b6f6e206f7576726520756e65206170706c69636174696f6e2c206c652070616e6e656175207175692073262333393b6166666963686520636f6d706f72746520656e206861757420756e652073c3a972696520646520626f75746f6e73206d61726272c3a9732e2043686171756520626f75746f6e20636f72726573706f6e6420c3a020756e20262333393b50616e6e656175262333393b2e2041206c262333393b657863657074696f6e20646520646575782063617320706172746963756c6965727320286c65732063616e6469646174732c206574206c6120646f63756d656e746174696f6e292c20756e2070616e6e65617520636f72726573706f6e6420c3a020756e65207461626c6520657420766963652d76657273612e3c62723e3c62723e4c6f72737175262333393b756e2070616e6e6561752065737420616666696368c3a92c206c6520626f75746f6e20636f72726573706f6e64616e742065737420706c757320636c61697220657420736f6e20746578746520617070617261697420656e206e6f69722e204c65732061757472657320626f75746f6e7320736f6e7420706c757320666f6e63c3a973206574206c657572732074657874657320617070617261697373656e7420656e20626c616e632e204c6f7273717565206c262333393b6f6e206166666963686520756e2070616e6e65617520706f7572206c61207072656d69c3a8726520666f69732c20696c2061666669636865206c61206c6973746520646520746f75746573206c657320666963686573206465206c61207461626c6520636f72726573706f6e64616e74652c206d6169732c2067c3a96ec3a972616c656d656e742c207365756c6520756e65207061727469652064657320696e666f726d6174696f6e732064652063686171756520666963686520617070617261c3ae742e2043657320696e666f726d6174696f6e7320736f6e7420746f757465666f697320737566666973616e74657320706f75722073c3a96c656374696f6e6e657220756e652066696368652e3c62723e3c2f666f6e743e, './Photos/NAV-20.jpg|NAV-20.jpg', 0x3c666f6e742073697a653d2233223e4c61206c69737465206465732066696368657320657374206163636f6d7061676ec3a96520646520706c7573696575727320262333393b4261727265732064262333393b6f7574696c73262333393b2c2071756920766f7573207065726d657474726f6e7320646520706f757273756976726520766f7320726563686572636865733a3c2f666f6e743e3c62723e3c6f6c3e3c6c693e3c666f6e742073697a653d2233223e556e6520426172726520646520262333393b53c3a96c656374696f6e2f547269262333393b2c20717569207065726d65742064652072c3a96475697265206c61206c6973746520656e20666f6e6374696f6e2064652063726974c3a87265732071756520766f757320617572657a2063686f69736973206574206465206c612074726965722064616e73206c262333393b6f726472652071756520766f757320736f7568616974657a2e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e556e6520426172726520646520262333393b506172636f75727320646573207061676573262333393b2c20717569207065726d65742c206c6f72737175262333393b756e65206c697374652074726f70206c6f6e677565206120c3a974c3a92064c3a9636f7570c3a96520656e2070616765732c206465206e617669677565722064616e73206365732070616765732e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e556e6520262333393b4261727265206465204372c3a96174696f6e262333393b2c20717569207065726d6574206465206372c3a9657220756e65206e6f7576656c6c652066696368652064616e73206c61207461626c652e3c62723e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e556e6520262333393b42617272652064262333393b696d7072657373696f6e262333393b2c20717569207065726d65742064262333393b696d7072696d6572206c652070616e6e65617520616666696368c3a92c20656e206d61737175616e7420746f7573206c657320626f75746f6e732e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e556e6520626172726520c3a020636861717565206c69676e65206465206c61206c697374652c20717569207065726d65742064262333393b6166666963686572206c652064c3a97461696c2064262333393b756e6520666963686520706172746963756c69c3a87265206f752064262333393b656e206d6f646966696572206c6520636f6e74656e752e3c2f666f6e743e3c2f6c693e3c2f6f6c3e3c666f6e742073697a653d2233223e3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b20636f6c6f723a20726762283235352c20302c2030293b223e53656c6f6e206c65732070616e6e656175782c206365732064696666c3a972656e746573206261727265732064262333393b6f7574696c732070657576656e7420c3aa747265207072c3a973656e746573206f75206e6f6e2c20656e20666f6e6374696f6e20646573206f70c3a9726174696f6e732071756520766f757320c3aa746573206175746f726973c3a97320c3a02066616972652e3c2f7370616e3e3c2f666f6e743e3c62723e),
(6, 'NAV', 'NAV-30', 'Navigation dans les pages', 0x3c666f6e74207374796c653d22636f6c6f723a207267622835312c2035312c20323535293b222073697a653d2235223e4e617669676174696f6e2064616e73206c65732070616765733c2f666f6e743e3c62723e3c666f6e742073697a653d2233223e3c62723e4365727461696e6573207461626c657320706f7373c3a864656e74206465207472c3a873206e6f6d6272657573657320666963686573202843616e6469646174732c20436c69656e742920657420696c2065737420706c757320636f6d6d6f6465206465206c65732064c3a9636f6d706f73657220656e20262333393b5061676573262333393b2c206179616e742063686163756e6520756e206e6f6d6272652066697865206465206c69676e65732e3c62723e3c62723e44616e73206365206361732c206368617175652070616765207072c3a973656e746520756e206d656e7520656e206861757420657420c3a02064726f6974652c207065726d657474616e74206465206e617669677565722064616e73206c65732070616765732e3c2f666f6e743e3c62723e, './Photos/NAV-30_Image_NAV-30.jpg|NAV-30.jpg', 0x3c666f6e742073697a653d2233223e4365206d656e75207072c3a973656e7465206175206d696c696575206c65206e756dc3a9726f206465206c61207061676520636f7572616e74652c20656e746f7572c3a92064652063696e7120626f75746f6e732c206465206c61206761756368652076657273206c612064726f6974653a3c62723e3c2f666f6e743e3c6f6c3e3c6c693e3c666f6e742073697a653d2233223e4c65207072656d69657220626f75746f6e20766f7573206469726967652076657273206c61207072656d69c3a8726520706167652e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4c65207365636f6e6420626f75746f6e20766f7573206469726967652076657273206c612070616765207072c3a963c3a964656e746520286e2d31292e3c62723e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e496d6dc3a964696174656d656e7420c3a0206c6120676175636865206475206e756dc3a9726f206465207061676520636f7572616e74652c20756e20626f75746f6e20766f7573207065726d657420646520766f75732064697269676572207665727320756e652061757472652070616765207175656c636f6e7175652e20506f75722063656c613b20766f75732072656d706c61636572206c65206e756dc3a9726f206465206c61207061676520636f7572616e7465207061722063656c7569206465206c612070616765206fc3b920766f75732064c3a9736972657220766f75732072656e6472652c207075697320766f757320636c697175657a2073757220636520626f75746f6e2e203c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b223e417474656e74696f6e21206368616e676572206c65206e756dc3a9726f2064652070616765206e6520737566666974207061732c20696c206661757420636c697175657220656e737569746520737572206c6520626f75746f6e20262333393b50262333393b3c2f7370616e3e2e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4c6520717561747269c3a86d6520626f75746f6e20766f7573206469726967652076657273206c6120706167652073756976616e746520286e2b31292e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4c652063696e717569c3a86d6520626f75746f6e20766f7573206469726967652076657273206c61206465726e69c3a8726520706167652e3c2f666f6e743e3c62723e3c2f6c693e3c2f6f6c3e3c62723e),
(7, 'NAV', 'NAV-40', 'Sélection d''une fiche', 0x3c666f6e74207374796c653d22636f6c6f723a207267622835312c2035312c20323535293b222073697a653d2235223e53c3a96c656374696f6e2064262333393b756e652066696368653c2f666f6e743e3c62723e3c62723e3c666f6e742073697a653d2233223e4120636861717565206c69676e6520636f72726573706f6e6420756e206d656e7520706c6163c3a920c3a02073612064726f6974652e204365206d656e75207065726d65742064262333393b616363c3a964657220c3a0206c6120666963686520636f72726573706f6e64616e746520c3a0206c61206c69676e652c206c61206d6f646966696572206f75206c61207375707072696d65722e2053656c6f6e206c6573207461626c6573206574206c65732064726f6974732071756920766f7573206f6e7420c3a974c3a920636f6e66c3a972c3a9732073757220636573207461626c65732c20756e6520706172746965207365756c656d656e742064657320626f75746f6e73206170706172616974206574206dc3aa6d652c2064616e73206365727461696e73206361732c206365206d656e752064697370617261697420746f74616c656d656e742028636173206465206c262333393b6167656e64612c20706172206578656d706c65292e3c2f666f6e743e, './Photos/NAV-40_Image_NAV-40.jpg|NAV-40.jpg', 0x3c666f6e742073697a653d2233223e436c697175657220737572206c6520626f75746f6e2064652073c3a96c656374696f6e20706f7373c3a8646520756e20646f75626c652065666665743a3c62723e3c2f666f6e743e3c6f6c3e3c6c693e3c666f6e742073697a653d2233223e4c65732064c3a97461696c73206465206c6120666963686520617070617261697373656e742c20636f6d706f7274616e742067c3a96ec3a972616c656d656e742062656175636f757020706c757320646520646f6e6ec3a9657320717565206e262333393b656e207072c3a973656e7465206c61206c697374652e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4c612066696368652065737420616c6f727320262333393b3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b223e73c3a96c656374696f6e6ec3a9653c2f7370616e3e262333393b2065742064657669656e74206c6120262333393b3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b223e666963686520636f7572616e74653c2f7370616e3e262333393b206465207361207461626c652e3c2f666f6e743e3c2f6c693e3c2f6f6c3e3c666f6e742073697a653d2233223e3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b20636f6c6f723a20726762283235352c20302c2030293b223e43657474652073c3a96c656374696f6e20657374206162736f6c756d656e74206ec3a9636573736169726520706f757220706f75766f697220616363c3a96465722061757820646f6e6ec3a9657320636f6e6365726e616e74206365747465206dc3aa6d65206669636865207175692073652074726f7576656e742064616e732064262333393b617574726573207461626c65732e3c62723e3c62723e3c2f7370616e3e41696e73692c20696c2066617574206162736f6c756d656e742073c3a96c656374696f6e6e657220756e2043616e646964617420706172746963756c69657220706f757220706f75766f697220616363c3a964657220c3a020736573204164726573736573206f7520c3a02073657320456d706c6f7965757273207072c3a963c3a964656e74732e3c62723e3c2f666f6e743e),
(8, 'NAV', 'NAV-50', 'Affichage d''une fiche', 0x3c666f6e74207374796c653d22636f6c6f723a207267622835312c203130322c20323535293b222073697a653d2235223e4166666963686167652064262333393b756e652066696368653c2f666f6e743e3c62723e3c62723e3c666f6e742073697a653d2233223e4c6f72737175262333393b756e65206669636865206120c3a974c3a92073c3a96c656374696f6e6ec3a9652c206c652064c3a97461696c2064657320646f6e6ec3a9657320616666c3a972656e7465732065737420616666696368c3a9206574206c657320626f75746f6e73206465207461626c65732028706c6163c3a97320656e2068617574292c20636f72726573706f6e64616e7420c3a02064657320646f6e6ec3a965732064657669656e6e656e74206566666563746966732e2044616e73206c65206361732063692d646573736f75732c20746f75746573206c6573207461626c65732064c3a970656e64656e7420646972656374656d656e742064262333393b756e6520666963686520262333393b43616e6469646174262333393b20657420646f6e6320746f7573206c657320626f75746f6e732064657669656e6e656e74206566666563746966732e3c2f666f6e743e3c62723e, './Photos/NAV-50_Image_NAV-50.jpg|NAV-50.jpg', 0x3c666f6e742073697a653d2233223e3c666f6e74207374796c653d22636f6c6f723a20726762283235352c20302c2030293b222073697a653d2233223e3c7370616e207374796c653d22636f6c6f723a2072676228302c20302c2030293b223e3c62723e41207061727469722064262333393b756e65206669636865206f6e207065757420656e74616d65723a3c62723e3c2f7370616e3e3c2f666f6e743e3c2f666f6e743e3c6f6c3e3c6c693e3c666f6e742073697a653d2233223e736f697420756e20706172636f75727320262333393b766572746963616c262333393b2c20656e20262333393b64657363656e64616e74262333393b2076657273206c657320696e666f726d6174696f6e732064c3a970656e64616e7465732064652063657474652066696368652c3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e736f697420756e20706172636f75727320262333393b686f72697a6f6e74616c262333393b20656e20706172636f7572616e74206c65732061757472657320666963686573206465206c61206dc3aa6d65206c697374652e3c2f666f6e743e3c62723e3c2f6c693e3c2f6f6c3e3c666f6e742073697a653d2233223e3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b223e3c2f7370616e3e3c2f666f6e743e),
(9, 'NAV', 'NAV-60', 'Navigation verticale', 0x3c666f6e74207374796c653d22636f6c6f723a207267622835312c2035312c20323535293b222073697a653d2235223e4e617669676174696f6e20766572746963616c653c2f666f6e743e3c62723e3c666f6e742073697a653d2233223e3c6272207374796c653d22666f6e742d7765696768743a20626f6c643b223e3c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b20636f6c6f723a20726762283235352c20302c2030293b223e4c652070726f6365737375732064652073c3a96c656374696f6e207065757420c3aa74726520656d706c6f79c3a9206465206661c3a76f6e206974c3a97261746976652e3c2f7370616e3e2041696e73692c2064616e73206c262333393b6170706c69636174696f6e20262333393b436c69656e7473262333393b2c20766f757320706f7576657a3a3c62723e3c2f666f6e743e3c756c3e3c6c693e3c666f6e742073697a653d2233223e73c3a96c656374696f6e6e6572206c612066696368652064262333393b756e20636c69656e7420c3a020706172746972206465206c61206c697374652c3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e636c697175657220737572206c6520626f75746f6e20262333393b526573706f6e7361626c6573262333393b20657420666169726520617070617261c3ae747265206c61206c697374652064657320726573706f6e7361626c657320646520726563727574656d656e7420646520636520636c69656e742e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e73c3a96c656374696f6e6e657220656e7375697465206c612066696368652064262333393b756e20726573706f6e7361626c652e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e636c697175657220737572206c6520626f75746f6e20262333393b4d697373696f6e73262333393b20657420666169726520617070617261c3ae747265206c61206c6973746520646520746f75746573206c6573206d697373696f6e7320636f6e6669c3a965732070617220636520726573706f6e7361626c652e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e73c3a96c656374696f6e6e657220656e7375697465206c612066696368652064262333393b756e65206d697373696f6e2e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e636c697175657220737572206c6520626f75746f6e20262333393b506f7374756c616e7473262333393b20657420666169726520617070617261c3ae747265206c61206c69737465206465732063616e646964617473207175692070657576656e7420706f7374756c657220c3a0206365747465206d697373696f6e2e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e73c3a96c656374696f6e6e657220656e66696e206c6120666963686520646520636520706f7374756c616e742e3c2f666f6e743e3c2f6c693e3c2f756c3e, './Photos/NAV-60_Image_NAV-60.jpg|NAV-60.jpg', 0x266e6273703b),
(10, 'NAV', 'NAV-70', 'Navigation ''horizontale''', 0x3c666f6e74207374796c653d22636f6c6f723a207267622835312c2035312c20323535293b222073697a653d2235223e4e617669676174696f6e20262333393b686f72697a6f6e74616c65262333393b3c2f666f6e743e3c62723e3c62723e3c666f6e742073697a653d2233223e5375722063686171756520666963686520617070617261697420756e206d656e752c20656e206861757420657420c3a02064726f6974652c207065726d657474616e74206465206e6176696775657220656e7472653c7370616e207374796c653d22666f6e742d7765696768743a20626f6c643b223e206c6573206669636865732064262333393b756e65206dc3aa6d65206c697374653c2f7370616e3e3a3c62723e3c2f666f6e743e3c6f6c3e3c6c693e3c666f6e742073697a653d2233223e4c65207072656d69657220626f75746f6e20766f7573206469726967652076657273206c61207072656d69c3a87265206669636865206465206c61206c697374652e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4c65207365636f6e6420626f75746f6e20766f7573206469726967652076657273206c61206669636865207072c3a963c3a964656e74652e3c62723e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4c652074726f697369c3a86d6520626f75746f6e20766f7573206469726967652076657273206c612066696368652073756976616e74652e3c2f666f6e743e3c2f6c693e3c6c693e3c666f6e742073697a653d2233223e4c6520717561747269c3a86d6520626f75746f6e20766f7573206469726967652076657273206c61206465726e69c3a87265206669636865206465206c61206c697374652e3c2f666f6e743e3c62723e3c2f6c693e3c2f6f6c3e, './Photos/NAV-70_Image_NAV-70.jpg|NAV-70.jpg', 0x266e6273703b);

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

--
-- Structure de la table `documents`
--

DROP TABLE IF EXISTS `documents`;
CREATE TABLE `documents` (
  `NoDossier` int(11) NOT NULL default '0',
  `RangDocument` int(3) NOT NULL default '0',
  `DateDocument` date default '0000-00-00',
  `DateReception` date default NULL,
  `Mode` varchar(2) collate utf8_bin NOT NULL,
  `Type` varchar(2) collate utf8_bin NOT NULL,
  `Document` varchar(90) collate utf8_bin default NULL,
  `PJ` varchar(90) collate utf8_bin default NULL,
  PRIMARY KEY  (`NoDossier`,`RangDocument`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `documents`
--

INSERT INTO `documents` (`NoDossier`, `RangDocument`, `DateDocument`, `DateReception`, `Mode`, `Type`, `Document`, `PJ`) VALUES
(20001, 1, '2008-11-03', '2008-11-05', 'R', 'LC', './Documents/20001_1_Document_Lettre-Francois.doc|Lettre-Francois.doc', './Documents/20001_1_PJ_CV-Francois.doc|CV-Francois.doc'),
(20001, 2, '2008-11-03', '2008-11-06', 'D', 'LC', '20001_2_Document_Lettre-Francois.doc|Lettre-Francois.doc', '20001_2_PJ_CV-Francois.doc|CV-Francois.doc'),
(20001, 3, '2008-11-10', '2008-11-12', 'R', 'AD', './Documents/20001__Document_Lettre-Francois.doc|Lettre-Francois.doc', ''),
(20001, 4, '2008-11-21', '2008-11-22', 'R', 'CV', './Documents/20001__Document_CV-Francois.doc|CV-Francois.doc', ''),
(20005, 1, '2008-10-09', '2008-10-24', 'R', 'LC', './Documents/20005__Document_Lettre-Francois.doc|Lettre-Francois.doc', './Documents/20005__PJ_CV-Francois.doc|CV-Francois.doc'),
(20009, 1, '0000-00-00', '2008-10-04', 'D', 'LC', '20009_1_Document_Lettre-Francois.doc|Lettre-Francois.doc', '20009_1_PJ_CV-Francois .doc|CV-Francois .doc'),
(20024, 1, '2008-11-03', '2008-11-10', 'R', 'LC', './Documents/20024__Document_Lettre-Francois.doc|Lettre-Francois.doc', './Documents/20024__PJ_CV-Francois_.doc|CV-Francois .doc');

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

--
-- Structure de la table `employeurs`
--

DROP TABLE IF EXISTS `employeurs`;
CREATE TABLE `employeurs` (
  `NoDossier` int(11) NOT NULL default '0',
  `RangEmployeur` int(3) NOT NULL default '0',
  `Societe` varchar(48) collate utf8_bin NOT NULL default '',
  `Secteur` varchar(12) collate utf8_bin default NULL,
  `Cadre` tinyint(1) NOT NULL default '0',
  `Position` varchar(32) collate utf8_bin default NULL,
  `Specialite` varchar(32) collate utf8_bin default NULL,
  `Debut` date default NULL,
  `Fin` date default NULL,
  PRIMARY KEY  (`NoDossier`,`RangEmployeur`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `employeurs`
--

INSERT INTO `employeurs` (`NoDossier`, `RangEmployeur`, `Societe`, `Secteur`, `Cadre`, `Position`, `Specialite`, `Debut`, `Fin`) VALUES
(20001, 1, 'Atos Origin', 'SSII', 1, 'Ingénieur débutant', 'Informatique', '1995-04-01', '2002-06-30'),
(20001, 2, 'Société Générale d''optique', 'PME-I', 1, 'Ingénieur 2B', 'Informatique', '2002-07-01', '2004-07-30'),
(20001, 3, 'Optic 2000', 'PME-I', 1, 'Ingénieur 3A', 'Informatique', '2004-11-19', '0000-00-00'),
(20002, 1, 'Forges du Sud-Est', 'PME-I', 0, 'Secrétaire', '', '1991-01-02', '0000-00-00'),
(867, 3, 'Stasi et Associés', 'CAB-A', 0, NULL, NULL, '2000-01-01', '2007-06-30'),
(20003, 1, 'EADS', 'GR-I', 1, 'Cadre position 2', 'Controleur de gestion', '2001-03-01', '2005-04-29'),
(20005, 1, 'PSA', 'GR-I', 1, 'Ingénieur 3A', 'Marketing', '2001-06-15', '0000-00-00'),
(20004, 1, 'AEDS', 'GR-I', 0, 'Ingénieur commercial', 'Commerce international', '2002-07-01', '0000-00-00'),
(20009, 1, 'Ambassade d''Italie', 'ADMIN', 0, 'Attachée commerciale', 'Pâtes alimentaires', '2003-10-01', '2005-06-17'),
(20003, 2, 'PAS', 'GR-I', 1, 'Cadre position 2', 'Contrleur de gestion', '2005-07-04', '0000-00-00'),
(20017, 1, 'Renault SA', 'GR-I', 1, 'Ingénieur position 2', 'Resistance des matériaux', '2000-01-03', '0000-00-00'),
(20018, 1, 'Swisscom', 'ADMIN', 1, 'Chef de projet', 'Marketing', '2000-09-01', '0000-00-00'),
(20006, 1, 'Conseil Général de l''Essonne', 'ADMIN', 1, 'Chef de Projet', 'Informatique', '2000-01-03', '2004-01-31'),
(20016, 1, 'La mécanique de précision', 'PME-I', 1, 'Ingénieur débutant', 'Mécanique', '1992-10-01', '1995-10-31'),
(20016, 2, 'Matra - Romainville', 'GR-I', 1, 'Ingénieur 2B', 'Mécanique', '1995-11-01', '2003-07-31'),
(20016, 3, 'Renault SA', 'GR-I', 1, 'Ingénieur 3A', 'mécanique', '2003-09-01', '0000-00-00'),
(20007, 1, 'Essilor', 'GR-I', 1, 'Ingénieur débutant', 'Marketing', '1992-05-01', '2003-02-28'),
(20007, 2, 'AXA', 'GR-I', 1, 'Directeur adjoint du marketing', 'Marketing', '2008-03-03', '0000-00-00'),
(20010, 1, 'BMW', 'GR-I', 1, 'Ingénieur commercial', 'International', '1999-11-01', '0000-00-00'),
(20006, 2, 'Vallourec', 'GR-I', 1, 'Ingénieur 2B', 'Mécanique', '2004-02-02', '0000-00-00');

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

--
-- Structure de la table `groupes`
--

DROP TABLE IF EXISTS `groupes`;
CREATE TABLE `groupes` (
  `Code` varchar(8) collate utf8_bin NOT NULL default '',
  `Libelle` varchar(32) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `groupes`
--

INSERT INTO `groupes` (`Code`, `Libelle`) VALUES
('REN-NIS', 'Renault-Nissan'),
('CALYON', 'Crédit Agricole - LCL');

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

--
-- Structure de la table `langues`
--

DROP TABLE IF EXISTS `langues`;
CREATE TABLE `langues` (
  `NoDossier` int(11) NOT NULL default '0',
  `RangLangue` int(3) NOT NULL default '0',
  `Langue` varchar(3) collate utf8_bin NOT NULL default '',
  `Niveau` varchar(12) collate utf8_bin default NULL,
  PRIMARY KEY  (`NoDossier`,`RangLangue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `langues`
--

INSERT INTO `langues` (`NoDossier`, `RangLangue`, `Langue`, `Niveau`) VALUES
(1001, 1, 'GB', 'Courant'),
(20002, 1, 'GB', 'Courant'),
(20001, 1, 'GB', 'Courant'),
(20001, 2, 'D', 'Ecrit+Parlé'),
(20003, 1, 'D', 'Bilingue'),
(20003, 2, 'GB', 'Ecrit+Parlé'),
(20005, 1, 'GB', 'Courant'),
(20005, 2, 'I', 'Bilingue'),
(20004, 1, 'GB', 'Bilingue'),
(20004, 2, 'I', 'Bilingue'),
(20004, 3, 'D', 'Bilingue'),
(20010, 1, 'D', 'Bilingue'),
(20010, 2, 'GB', 'Courant'),
(20010, 3, 'I', 'Courant'),
(20009, 1, 'I', 'Bilingue'),
(20009, 2, 'D', 'Courant'),
(20017, 1, 'S', 'Courant'),
(20017, 2, 'GB', 'Ecrit+Parlé'),
(20018, 1, 'D', 'Bilingue'),
(20018, 2, 'I', 'Courant'),
(20006, 1, 'GB', 'Ecrit+Parlé'),
(20016, 1, 'GB', 'Ecrit+Parlé'),
(20007, 1, 'S', 'Courant'),
(20007, 2, 'GB', 'Ecrit+Parlé'),
(20016, 2, 'NL', 'Ecrit+Parlé');

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

--
-- Structure de la table `lettres_cv`
--

DROP TABLE IF EXISTS `lettres_cv`;
CREATE TABLE `lettres_cv` (
  `Rang` int(11) NOT NULL auto_increment,
  `Nom` varchar(32) collate utf8_bin NOT NULL,
  `Prenom` varchar(32) collate utf8_bin NOT NULL,
  `CV` varchar(72) collate utf8_bin default NULL,
  `Lettre` varchar(72) collate utf8_bin default NULL,
  `Langue` varchar(8) collate utf8_bin NOT NULL,
  `DatePoste` date NOT NULL,
  `Traite` tinyint(1) NOT NULL,
  PRIMARY KEY  (`Rang`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=9 ;

--
-- Contenu de la table `lettres_cv`
--

INSERT INTO `lettres_cv` (`Rang`, `Nom`, `Prenom`, `CV`, `Lettre`, `Langue`, `DatePoste`, `Traite`) VALUES
(3, 'Lenoir', 'Marcel', './Documents/Galian_François_Francois.doc|Francois.doc', './Documents/Galian_François_LOULOUCHE.rtf|LOULOUCHE.rtf', 'Français', '2008-11-06', 0),
(4, 'Mondel', 'René', './Documents/Galian_François_Francois.doc|Francois.doc', './Documents/Galian_François_LOULOUCHE.rtf|LOULOUCHE.rtf', 'Français', '2008-11-06', 0),
(5, 'Berlingot', 'Marie-Pierre', './Documents/Berlingot_Marie-Pierre_Francois.doc|Francois.doc', './Documents/Berlingot_Marie-Pierre_LOULOUCHE.rtf|LOULOUCHE.rtf', 'Français', '2008-11-06', 0),
(6, 'Moulin', 'Jean-Yves', './Documents/6_CV_CV-Francois.doc|CV-Francois.doc', './Documents/6_Lettre_Lettre-Francois.doc|Lettre-Francois.doc', 'Français', '2008-11-06', 1),
(7, 'Assin', 'Victor', './Documents/Moulin_Laurent_Francois.doc|Francois.doc', './Documents/Moulin_Laurent_LOULOUCHE.rtf|LOULOUCHE.rtf', 'Français', '2008-11-06', 0),
(8, 'BUZZATTI', 'Mirella', './Documents/8_CV_CV-Francois_.doc|CV-Francois .doc', './Documents/8_Lettre_Lettre-Francois.doc|Lettre-Francois.doc', 'Français', '2008-10-04', 1);

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

--
-- Structure de la table `metiers`
--

DROP TABLE IF EXISTS `metiers`;
CREATE TABLE `metiers` (
  `Code_Metier` varchar(8) collate utf8_bin NOT NULL,
  `Libelle` varchar(64) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Code_Metier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `metiers`
--

INSERT INTO `metiers` (`Code_Metier`, `Libelle`) VALUES
('CONS', 'Consultant'),
('HUIS', 'Huissier de justice'),
('COM', 'Commercial'),
('AVO', 'Avocat'),
('JUR-AFF', 'Juriste d''affaire'),
('JUR-BANQ', 'Juriste bancaire'),
('INGE', 'Ingénieur'),
('FISC', 'Fiscaliste'),
('COMPT', 'Expert-comptable'),
('R-H', 'Gestionnaire des ressources humaines'),
('AID-CPT', 'Aide comptable'),
('ACHET', 'Acheteur'),
('RESP-COM', 'Responsable commercial'),
('MARK', 'Responsable marketing'),
('D-MARK', 'Débutant marketing'),
('JUR-ENTR', 'Juriste d''entreprise');

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

--
-- Structure de la table `missions`
--

DROP TABLE IF EXISTS `missions`;
CREATE TABLE `missions` (
  `CodeClient` varchar(8) collate utf8_bin NOT NULL default '',
  `CodeResp` varchar(8) collate utf8_bin NOT NULL default '',
  `Numero` int(6) NOT NULL default '0',
  `Libelle` varchar(64) collate utf8_bin NOT NULL default '',
  `Metier` varchar(8) collate utf8_bin NOT NULL default '',
  `DateDebut` date NOT NULL default '0000-00-00',
  `DateFin` date default NULL,
  `Identification` varchar(32) collate utf8_bin NOT NULL default '',
  `Honoraires` int(8) default NULL,
  `Etat` varchar(3) collate utf8_bin NOT NULL default '',
  `Description` blob,
  KEY `Societe` (`CodeClient`,`CodeResp`,`Numero`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `missions`
--

INSERT INTO `missions` (`CodeClient`, `CodeResp`, `Numero`, `Libelle`, `Metier`, `DateDebut`, `DateFin`, `Identification`, `Honoraires`, `Etat`, `Description`) VALUES
('Landwell', 'PL.M', 1, 'Avocat débutant 2/3 années', 'CONS', '2008-03-17', '2008-05-16', 'François', 200000, 'E-C', 0x496c2073262333393b616769742064652074726f7576657220756e206a65756e652061766f6361742c20697373752064262333393b756e206772616e6420636162696e65742c20617665632032206f75203320616e6ee9657320646520666f726d6174696f6e2e2c2071756920736f6974203c7370616e207374796c653d22636f6c6f723a2072676228302c20302c2030293b223e646973706f6e69626c6520736f75732032206d6f69732e3c2f7370616e3e3c62723e),
('Landwell', 'PL.M', 2, 'Trouver un débutant', 'CONS', '2008-03-17', '2008-05-30', 'François', 80000, 'E-C', 0x496c20666175742074726f7576657220756e206a75726973746520736f7274616e74206465206c6120666163756c74e92c206179616e742066616974207175656c71756573207374616765732e3c62723e),
('Landwell', 'A.T', 1, 'Commercial débutant', 'COM', '2008-01-01', '2008-06-30', 'Matthieu', 100000, 'E-C', 0x496c20666175742074726f7576657220756e20636f6d6d65726369616c20697373752064262333393b756e65206772616e646520e9636f6c653a204845432c2045535345432c205355504445434f205061726965732c2e2e2e),
('RNUR', 'A-LEMA', 1, 'Recherche d''un spécialiste confirmé du marketing', '', '2008-02-04', '2008-03-10', 'Matthieu', 100000, 'E-C', 0x4c652063616e64696461742064657672612070617274696369706572206175206d61726b6574696e67206f70e9726174696f6e6e656c20646573206e6f757665617578206d6f64e86c6573206465206c61206d61727175652e20556e20657870e97269656e6365206465206c262333393b6175746f6d6f62696c65207365726169742061707072e96369e9652c206d616973206e6f6e206f626c696761746f6972652e),
('RNUR', 'A-LEMA', 2, 'Recherche d''un ingénieur mécanicien confirmé', 'INGE', '2008-02-04', '2008-04-30', 'Matthieu', 150000, 'E-C', 0x4c6520706f73746520657374206120706f7572766f697220e0205374205175656e74696e2e204c652063616e6469646174207072656e647261206c6120726573706f6e7361626c6974e92064752064e976656c6f7070656d656e742064657320626fee7465732064652076697465737365206175746f6d617469717565732c2061766563206c6120646972656374696f6e20646520313520706572736f6e6e65732e),
('Total', 'L-CHAR', 1, 'Recherche d''un juriste d''entreprise 4/6 ans d''expérience.', 'JUR-ENTR', '2008-02-11', '2008-05-02', 'Matthieu', 300000, 'E-C', 0x4c652063616e6469646174207365726120656e2063686172676520647520736572766963652064657320636f6e7472617420647520666f75726e69747572652064652067617a20656e204575726f7065206475204e6f72642c20e0206c612074ea74652064262333393b756e6520e9717569706520646520323020706572736f6e6e65732e),
('Total', 'L-CHAR', 2, 'Recherche d''un commercial 2/3 ans d''expérience', 'COM', '2008-01-21', '2008-03-28', 'François', 220000, 'TER', 0x4c652063616e6469646174206175726120706f75722072f46c652064262333393be9746f66666572206c262333393be9717569706520656e20636861726765206465206c6120646973747269627574696f6e20656e204974616c69652e3c62723e4c652062696c696e677569736d65206573742065786967e92e3c62723e),
('Landwell', 'A.T', 2, 'Comptable confirmé', 'COMPT', '2008-03-03', '2008-03-31', 'Matthieu', 180000, 'TER', 0x4c652063616e646964617420646f697420706f75766f6972207072656e647265206c6120726573706f6e736162696c6974e92064262333393b756e20736572766963652e),
('RNUR', 'D-SU', 1, 'Spécialiste electronique embarquée', 'INGE', '2008-03-17', '2008-04-30', 'François', 100000, 'E-C', '');

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

--
-- Structure de la table `nations`
--

DROP TABLE IF EXISTS `nations`;
CREATE TABLE `nations` (
  `Code` varchar(3) collate utf8_bin NOT NULL default '',
  `Libelle` varchar(32) collate utf8_bin NOT NULL default '',
  `Nationalite` varchar(32) collate utf8_bin NOT NULL default '',
  `Langue` varchar(32) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `nations`
--

INSERT INTO `nations` (`Code`, `Libelle`, `Nationalite`, `Langue`) VALUES
('F', 'France', 'Française', 'Français'),
('D', 'Allemagne', 'Allemande', 'Allemand'),
('S', 'Espagne', 'Espagnole', 'Espagnol'),
('I', 'Italie', 'Italienne', 'Italien'),
('CH', 'Suisse', 'Suisse', ''),
('NL', 'Pays-Bas', 'Neerlandaise', 'Neerlandais'),
('GB', 'Royaume-Uni', 'Britannique', 'Anglais'),
('USA', 'Etats-Unis', 'Nord-Americaine', ''),
('EIR', 'Irlande', 'Irlandaise', ''),
('P', 'Portugal', 'Portugaise', 'Portugaise'),
('PL', 'Pologne', 'Polonaise', 'Polonais');

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

--
-- Structure de la table `postulants`
--

DROP TABLE IF EXISTS `postulants`;
CREATE TABLE `postulants` (
  `CodeClient` varchar(8) collate utf8_bin NOT NULL default '',
  `CodeResp` varchar(8) collate utf8_bin NOT NULL default '',
  `Numero` int(6) NOT NULL default '0',
  `NoDossier` int(11) NOT NULL default '0',
  `Rang` int(11) NOT NULL auto_increment,
  `DateProposition` date default NULL,
  `DateAccord` date default NULL,
  `Statut` varchar(3) collate utf8_bin NOT NULL default '',
  `Remarques` varchar(255) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Rang`),
  KEY `CodeClient` (`CodeClient`,`CodeResp`,`Numero`,`NoDossier`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ;

--
-- Contenu de la table `postulants`
--

INSERT INTO `postulants` (`CodeClient`, `CodeResp`, `Numero`, `NoDossier`, `Rang`, `DateProposition`, `DateAccord`, `Statut`, `Remarques`) VALUES
('Landwell', 'PL.M', 1, 20002, 1, '2008-02-04', '0000-00-00', 'CAN', '&nbsp;Marie-Mouise Mirabelle n&#39;est peut-être pas la candidate idéale, mais on peut tout de même la présenter au client, faute de mieux!<br>'),
('Landwell', 'PL.M', 2, 20002, 2, '2008-01-15', '0000-00-00', 'CAN', 'Le candidat n&#39;est pas completement d&eacute;butant.'),
('Landwell', 'PL.M', 1, 20001, 3, '2008-01-25', '0000-00-00', 'S-L', 'C&#39;est probablement le meilleur profile que nous puissions présenter, malheureusement, nous l&#39;avons déjà&nbsp; présenté ailleurs.<br>'),
('Landwell', 'PL.M', 1, 20007, 4, '2008-02-04', '0000-00-00', 'CAN', 'Peut-être? A voir.'),
('RNUR', 'A-LEMA', 1, 20007, 6, '2008-02-06', '0000-00-00', 'CAN', 'Le postulant a une bonne connaissanse du marketing, mais dans des domaines tr&egrave;s diff&eacute;rents de celui du client.'),
('RNUR', 'A-LEMA', 1, 20005, 7, '2008-02-06', '0000-00-00', 'CAN', 'Exp&eacute;rience peut-&ecirc;tre un peu l&eacute;g&egrave;re pour la demande du client.'),
('RNUR', 'A-LEMA', 2, 20006, 8, '2008-02-11', '0000-00-00', 'CAN', '<span style="color: rgb(255, 0, 0);">Bertrand Lerouge</span> semble avoir l&#39;exp&eacute;rience n&eacute;cessaire au client.&n'),
('Total', 'L-CHAR', 1, 20010, 9, '2008-02-11', '0000-00-00', 'CAN', 'L&#39;exp&eacute;rience de Gertrud Von Ratenau et sa ma&icirc;trise des langues devrait convenir parfaitement. A-t&#39;elle l&#39;exp&eacute;rience d&#39;endradrement n&eacute;cessaire? <span style="font-weight: bold;">A V&eacute;rifier</span>.'),
('Total', 'L-CHAR', 2, 20009, 10, '2008-01-30', '0000-00-00', 'CAN', 'De langue maternelle italienne, avec une tr&egrave;s bonne formation commerciale, la Mirella Buzatti devrait parfaitement convenir. Dossier &agrave; pousser aupr&egrave;s du client.'),
('Landwell', 'A.T', 2, 20005, 11, '2008-02-18', '0000-00-00', 'CAN', 'Le profile du candidat devrait convenir.');

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

--
-- Structure de la table `requetes`
--

DROP TABLE IF EXISTS `requetes`;
CREATE TABLE `requetes` (
  `Numero` int(6) NOT NULL auto_increment,
  `Application` varchar(24) collate utf8_bin NOT NULL default '',
  `Panneau` varchar(24) collate utf8_bin NOT NULL default '',
  `Auteur` varchar(32) collate utf8_bin NOT NULL default '',
  `NomRequete` varchar(24) collate utf8_bin NOT NULL default '',
  `Commun` tinyint(1) NOT NULL default '0',
  `Modifiable` tinyint(1) NOT NULL default '0',
  `Where` varchar(255) collate utf8_bin NOT NULL default '',
  `AvecOrder` tinyint(1) NOT NULL default '0',
  `Order` varchar(255) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Numero`),
  KEY `Application` (`Application`,`Panneau`,`Auteur`,`NomRequete`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Table des requêtes SQL' AUTO_INCREMENT=18 ;

--
-- Contenu de la table `requetes`
--

INSERT INTO `requetes` (`Numero`, `Application`, `Panneau`, `Auteur`, `NomRequete`, `Commun`, `Modifiable`, `Where`, `AvecOrder`, `Order`) VALUES
(14, 'HeadHunter', 'Candidats', 'François', 'Anglophone', 0, 1, '1/*Langues|Anglophone*/ AND `Langues`.`Langue` = ''GB'' AND `Langues`.`Niveau` IN (''Courant'',''Bilingue'') AND `Candidats`.`NoDossier` = `Langues`.`NoDossier`', 0, ''),
(3, 'HeadHunter', 'Candidats', 'François', 'Hommes', 0, 1, '`Candidats`.`Sexe` = ''M''', 0, ''),
(4, 'HeadHunter', 'Candidats', 'François', 'Femmes', 0, 1, '`Candidats`.`Sexe` = ''F''', 0, ''),
(16, 'ClientHunter', 'Client', 'François', 'CABINETS', 0, 1, '`Clients`.`CodeSecteur` = ''CAB-A''', 0, ''),
(6, 'HeadHunter', 'Langues', 'François', 'Anglophone', 0, 1, '`Langues`.`Langue` = ''GB'' AND `Langues`.`Niveau` IN (''Courant'',''Bilingue'')', 0, ''),
(7, 'HeadHunter', 'Langues', 'François', 'Italophone', 0, 1, '`Langues`.`Langue` = ''I'' AND `Langues`.`Niveau` IN (''Courant'',''Bilingue'')', 0, ''),
(8, 'HeadHunter', 'Langues', 'François', 'Germanophone', 0, 1, '`Langues`.`Langue` = ''D'' AND `Langues`.`Niveau` IN (''Courant'',''Bilingue'')', 0, ''),
(9, 'HeadHunter', 'Langues', 'François', 'Hispanophone', 0, 1, '`Langues`.`Langue` = ''SP'' AND `Langues`.`Niveau` IN (''Courant'',''Bilingue'')', 0, ''),
(11, 'HeadHunter', 'Formation', 'François', 'Marketing', 0, 1, '`Cursus`.`Specialite` = ''Marketing''', 0, ''),
(15, 'HeadHunter', 'Candidats', 'François', 'Italophone', 0, 1, '1/*Langues|Italophone*/ AND `Langues`.`Langue` = ''I'' AND `Langues`.`Niveau` IN (''Courant'',''Bilingue'') AND `Candidats`.`NoDossier` = `Langues`.`NoDossier`', 0, ''),
(17, 'ClientHunter', 'Client', 'François', 'INDUSTRIE', 0, 1, '`Clients`.`CodeSecteur` IN (''GR-I'',''PME-I'')', 0, '');

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

--
-- Structure de la table `responsables`
--

DROP TABLE IF EXISTS `responsables`;
CREATE TABLE `responsables` (
  `CodeClient` varchar(8) collate utf8_bin NOT NULL default '',
  `CodeResp` varchar(6) collate utf8_bin NOT NULL default '',
  `NomResp` varchar(32) collate utf8_bin NOT NULL default '',
  `PrenomResp` varchar(32) collate utf8_bin NOT NULL default '',
  `Telephone` varchar(16) collate utf8_bin default NULL,
  `Email` varchar(48) collate utf8_bin default NULL,
  `Commentaires` blob,
  PRIMARY KEY  (`CodeClient`,`CodeResp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `responsables`
--

INSERT INTO `responsables` (`CodeClient`, `CodeResp`, `NomResp`, `PrenomResp`, `Telephone`, `Email`, `Commentaires`) VALUES
('Landwell', 'PL.M', 'Morin', 'Pierre-Louis', '01 04 25 50', 'plmorin@landwell.fr', 0x502e4c204d6f72696e2065737420756e20616e6369656e20646520416e64657273656e20436f6e73756c74696e672c2061766563206c657175656c206e6f7573206176696f6e732064266561637574653b6a266167726176653b207472617661696c6c266561637574653b2064616e73206c657320616e6e266561637574653b65732039302e496c2061766169742067617264266561637574653b20756e20626f6e20736f7576656e6972206465206e6f732070726573746174696f6e732e),
('Landwell', 'A.T', 'Trichet', 'Alain', '01 04 25 50', 'alain.trichet@free.fr', 0x506572736f6e6e616765207472266567726176653b732073796d70617468697175652e),
('RNUR', 'A-LEMA', 'Lemarchand', 'André', '01 41 04 64 85', 'alemarchand@renault.com', 0x4661697420706172746965206465206c61204452482064752047726f7570652c206176656320756e2072f46c6520646520636f6e7365696c2028e0737569767265292061757072e8732064657320445248206465206272616e6368652e),
('Total', 'L-CHAR', 'Charpentier', 'Louis', '01 45 02 03 04', 'l.charpentier@total-elf.com', 0x416e6369656e2044524820646520415a462e20556e652070726575766520646520736f6c69646974266561637574653b20646573206e65726673213c6272202f3e496c20666169742070617274696520647520636f6d6974266561637574653b2063656e7472616c206465732052482064752047726f7570652e3c6272202f3e),
('RNUR', 'D-SU', 'Suarez', 'Diego', '01 52 60 80 92', 'dsuarez@renault.fr', 0x442e2053756172657a2065737420706c7573207370e9636966697175656d656e74206368617267657220647520726563727574656d656e7420646573206361647265732061646d696e6973747261746966732e3c62723e);

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

--
-- Structure de la table `secteurs`
--

DROP TABLE IF EXISTS `secteurs`;
CREATE TABLE `secteurs` (
  `Code` varchar(8) collate utf8_bin NOT NULL default '',
  `Libelle` varchar(48) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `secteurs`
--

INSERT INTO `secteurs` (`Code`, `Libelle`) VALUES
('PME-I', 'Petites et Moyennes Entreprises Industrielles'),
('GR-I', 'Grand Groupe Industriel'),
('SSII', 'Société de Services Informatiques'),
('ADMIN', 'Administration'),
('CAB-A', 'Cabinet d''avocats');

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

--
-- Structure de la table `specialite`
--

DROP TABLE IF EXISTS `specialite`;
CREATE TABLE `specialite` (
  `Code_Metier` varchar(8) collate utf8_bin NOT NULL default '',
  `Code_Specialite` varchar(8) collate utf8_bin NOT NULL default '',
  `Denomination` varchar(64) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`Code_Metier`,`Code_Specialite`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `specialite`
--

INSERT INTO `specialite` (`Code_Metier`, `Code_Specialite`, `Denomination`) VALUES
('JUR-ENTR', 'ACHATS', 'Contrats d''achats'),
('JUR-ENTR', 'VENTE', 'Contrats de vente'),
('JUR-ENTR', 'HR', 'Droit social'),
('JUR-ENTR', 'FISCAL', 'Droit fiscal'),
('AVO', 'AFFAIRES', 'Droit des affaires'),
('AVO', 'SOCIAL', 'Droit social'),
('AVO', 'PRATIQUE', 'Droit pratique'),
('INGE', 'ELECTR', 'Electronicien'),
('INGE', 'HYDRO', 'Hydrolicien'),
('INGE', 'SOFTW', 'Informaticien'),
('INGE', 'THERMO', 'Thermodynamicien');

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

--
-- Structure de la table `tel-emails`
--

DROP TABLE IF EXISTS `tel-emails`;
CREATE TABLE `tel-emails` (
  `NoDossier` int(11) NOT NULL default '0',
  `RangTel` int(3) NOT NULL default '0',
  `Mode` varchar(8) collate utf8_bin NOT NULL default '',
  `Numero` varchar(64) collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`NoDossier`,`RangTel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Contenu de la table `tel-emails`
--

INSERT INTO `tel-emails` (`NoDossier`, `RangTel`, `Mode`, `Numero`) VALUES
(20001, 1, 'Tel-Priv', '01 54 65 01 88'),
(20001, 2, 'Tel-Priv', '01 52 23 14 00 poste 235'),
(20002, 1, 'Tel-Priv', '0148 49 23 10'),
(20002, 2, 'Mobile', '06 60 52 57 23'),
(20002, 3, 'E-mail', 'ml.mirabelle@wanadoo.fr'),
(20017, 1, 'Tel-Priv', '01 45 04 26 89'),
(20001, 3, 'E-mail', 'jy.moulin@free.fr'),
(20003, 1, 'Tel-Priv', '01 46 45 86 00'),
(20005, 1, 'Tel-Prof', '01 45 63 21 00'),
(20005, 2, 'E-mail', 'alebras@noos.fr'),
(20010, 1, 'Tel-Priv', '49 056 254 231'),
(20010, 2, 'E-mail', 'gertrud@dt.de'),
(20009, 1, 'Tel-Priv', '01 56 65 20 33'),
(20009, 2, 'E-mail', 'mirella.buzzatti@alice.fr'),
(20003, 2, 'Mobile', '06 07 08 12 56'),
(20003, 3, 'E-mail', 'th.lebief@wanadoo.fr'),
(20004, 1, 'Tel-Priv', '+41 22 56 20 142'),
(20017, 2, 'Mobile', '06 08 56 23 14'),
(20017, 3, 'E-mail', 'jmhirondelle@free.fr'),
(20018, 1, 'Tel-Priv', '01 45 05 60 22'),
(20018, 2, 'Mobile', '06 60 69 22 35'),
(20018, 3, 'E-mail', 'ed.lamentin@neuf.fr'),
(20006, 1, 'Tel-Prof', '01 56 23 58 59'),
(20006, 2, 'E-mail', 'bertrand.lerouge@noos.fr'),
(20016, 1, 'Tel-Priv', '0825 36 22 53'),
(20016, 2, 'Mobile', '06 60 52 68 99'),
(20016, 3, 'E-mail', 'a.loiseau@free.fr'),
(20007, 1, 'Tel-Priv', '02 37 56 28 03'),
(20007, 2, 'E-mail', 'a.mansard@wanadoo.fr');