--
-- mise à jour base de données1.5  to 1.6 
--
--  cette mise à j our inclut la description  de la norme ISO 19119 (IS 2006 + amendements of january 2008), un profil MDweb de web service, un exemple de fiche de métadonnées de service et la mise à jour des libellés des interfaces
--

--
-- mis à jour des libellés  pour la version MDweb 16 
--

--
-- update of 02-10-2007
--
delete from label_stand where id_foreign_table='processor' and table_name='elmnt_code_list' ;
delete from label_stand where id_foreign_table='dataset' and table_name='elmnt_code_list' ;
delete from label_stand where id_foreign_table='series' and table_name='elmnt_code_list' ;
delete from label_stand where id_foreign_table='distributor' and table_name='elmnt_code_list' ;
delete from label_stand where id_foreign_table='pointOfContact' and table_name='elmnt_code_list' ;
--
-- insertion des libellés des codes listes manquants
--
INSERT INTO label_stand VALUES ('processor', 'elmnt_code_list', 'eng', 'Processor', 'In translation', 'liste');
INSERT INTO label_stand VALUES ('processor', 'elmnt_code_list', 'fra', 'Producteur', '', 'liste');
INSERT INTO label_stand VALUES ('dataset', 'elmnt_code_list', 'eng', 'Dataset', 'In translation', 'liste');
INSERT INTO label_stand VALUES ('dataset', 'elmnt_code_list', 'fra', 'Jeu de données', '', 'liste');
INSERT INTO label_stand VALUES ('series', 'elmnt_code_list', 'eng', 'Collection de données', 'In translation', 'liste');
INSERT INTO label_stand VALUES ('series', 'elmnt_code_list', 'fra', 'Data series', '', 'liste');
INSERT INTO label_stand VALUES ('distributor', 'elmnt_code_list', 'eng', 'Distributor', 'In translation', 'liste');
INSERT INTO label_stand VALUES ('distributor', 'elmnt_code_list', 'fra', 'Distributeur', '', 'liste');
INSERT INTO label_stand VALUES ('pointOfContact', 'elmnt_code_list', 'eng', 'Point of Contact', 'In translation', 'liste');
INSERT INTO label_stand VALUES ('pointOfContact', 'elmnt_code_list', 'fra', 'Point de contact', '', 'liste');
--
-- erreur sur un élément de métadonnées
--
update elmnt_mtd set elmnt_name='gco:UomLength' where elmnt_mtd_id='axisUnits_520';

--
-- update of 2007-09-20
--

--
-- modification des libéllés du menu import / export
--
delete from label where id_foreign_table='menu_gest_import_19115' ;
delete from label where id_foreign_table='menu_gest_import_19139';
delete from label where id_foreign_table='menu_gest_import_19139g';
delete from label where id_foreign_table='menu_gest_import_19139a';
delete from label where id_foreign_table='menu_gest_export_19115';
delete from label where id_foreign_table='menu_gest_export_19139';
INSERT INTO label VALUES ('menu_gest_import_19115', 'message_interface', 'fra', 'libellé menu gestion', 'menu', 'de ArcCatalog 8.x');
INSERT INTO label VALUES ('menu_gest_import_19139g', 'message_interface', 'fra', 'libellé menu gestion', 'menu', 'de Géosource 1.0');
INSERT INTO label VALUES ('menu_gest_import_19139a', 'message_interface', 'fra', 'libellé menu gestion', 'menu', 'de ArcCatalog 9.x');
INSERT INTO label VALUES ('menu_gest_export_19115', 'message_interface', 'fra', 'libellé menu gestion', 'menu', 'vers ArcCatalog 8.x');
INSERT INTO label VALUES ('menu_gest_export_19139', 'message_interface', 'fra', 'libellé menu gestion', 'menu', 'vers Géosource 1.0');

INSERT INTO label VALUES ('menu_gest_import_19115', 'message_interface', 'eng', 'libellé menu gestion', 'menu', 'from ArcCatalog 8.x');
INSERT INTO label VALUES ('menu_gest_import_19139g', 'message_interface', 'eng', 'libellé menu gestion', 'menu', 'from Geonetwork 2.x');
INSERT INTO label VALUES ('menu_gest_import_19139a', 'message_interface', 'eng', 'libellé menu gestion', 'menu', 'from ArcCatalog 9.x');
INSERT INTO label VALUES ('menu_gest_export_19115', 'message_interface', 'eng', 'libellé menu gestion', 'menu', 'to ArcCatalog 8.x');
INSERT INTO label VALUES ('menu_gest_export_19139', 'message_interface', 'eng', 'libellé menu gestion', 'menu', 'to Geonetwork 2.x');

--
-- met à jour le dump de la base de données mdweb-demo15 (dump-MDweb-demo15-fra.sql et dump-MDweb-demo15.sql) de ce répertoire pour ajouter les libellés correspondant au module de migration
--
--
--------------------------------------------------------------------------- mis à jour du 24/07/07 ------------------------------------------------------
--
-- Migration BD 1.4 vers BD 1.5
--
DELETE FROM label WHERE id_foreign_table = 'menu_admin_migration_bd';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('menu_admin_migration_bd', 'message_interface', 'fra', 'Migration BD 1.4 vers BD 1.5', 'message', 'Migration BD 1.5');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('menu_admin_migration_bd', 'message_interface', 'eng', 'Migration from DB 1.4 to DB 1.5', 'message', 'Migration to DB 1.5');
DELETE FROM label WHERE id_foreign_table = 'titre_migration';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('titre_migration', 'message_interface', 'fra', 'Migration BD 1.4 vers BD 1.5', 'message', 'Migration BD 1.4 vers BD 1.5');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('titre_migration', 'message_interface', 'eng', 'Migration from DB 1.4 to DB 1.5', 'message', 'Migration from DB 1.4 to DB 1.5');
DELETE FROM label WHERE id_foreign_table = 'db_name' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_name', 'message_interface', 'fra', 'Nom de la base de données MDweb', 'message', 'Nom de la base de données MDweb');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_name', 'message_interface', 'eng', 'MDweb database name', 'message', 'Name of MDweb database');
DELETE FROM label WHERE id_foreign_table = 'db_host' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_host', 'message_interface', 'fra', 'Adresse IP de la base de données MDweb', 'message', 'Adresse IP du SGBD');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_host', 'message_interface', 'eng', 'IP address of MDweb database', 'message', 'IP address of DBMS');
DELETE FROM label WHERE id_foreign_table = 'db_user' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_user', 'message_interface', 'fra', 'Nom du compte utilisateur pour la BD MDweb', 'message', 'Compte utilisateur');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_user', 'message_interface', 'eng', 'User login for MDweb database', 'message', 'User login');
DELETE FROM label WHERE id_foreign_table = 'db_pwd' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_pwd', 'message_interface', 'fra', 'Mot de passe pour la BD MDweb', 'message', 'Mot de passe');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('db_pwd', 'message_interface', 'eng', 'Password for MDweb database', 'message', 'Password');
DELETE FROM label WHERE id_foreign_table = 'comm_db_host' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_host', 'message_interface', 'fra', 'Adresse IP de la base de données MDweb', 'message', 'Adresse IP ou nom du serveur sur lequel est hébergé la base de données MDweb');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_host', 'message_interface', 'eng', 'IP address of MDweb database', 'message', 'IP address or server name where MDweb database is located');
DELETE FROM label WHERE id_foreign_table = 'comm_db_name' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_name', 'message_interface', 'fra', 'Nom de la base de données MDweb', 'message', 'Nom de la base de données MDweb');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_name', 'message_interface', 'eng', 'MDweb database name', 'message', 'Nom de la base de données MDweb');
DELETE FROM label WHERE id_foreign_table = 'comm_db_user' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_user', 'message_interface', 'fra', 'Nom du compte utilisateur pour la BD MDweb', 'message', E'Nom de l\\''utilisateur PostgreSQL qui permet de se connecter à la base de  données MDweb');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_user', 'message_interface', 'eng', 'User login for MDweb database', 'message', 'PostgreSQL username that allows to connect to MDweb database');
DELETE FROM label WHERE id_foreign_table = 'comm_db_pwd' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_pwd', 'message_interface', 'fra', 'Mot de passe pour la BD MDweb', 'message', E'Mot de passe de l\\''utilisateur PostgreSQL pour se connecter à la base de données MDweb');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('comm_db_pwd', 'message_interface', 'eng', 'Password for MDweb database', 'message', 'PostgreSQL user password PostgreSQL to connect to the MDWeb database');
DELETE FROM label WHERE id_foreign_table = 'migration_labels_int' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('migration_labels_int', 'message_interface', 'fra', 'Migration des labels des interfaces', 'message', 'Libellés des interfaces utilisateurs');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('migration_labels_int', 'message_interface', 'eng', 'Migration of user interfaces labels', 'message', 'Labels of user interfaces');
DELETE FROM label WHERE id_foreign_table = 'migration_labels_stand' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('migration_labels_stand', 'message_interface', 'fra', 'Migration des labels des éléments de la norme', 'message', 'Libellés des éléments de la norme');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('migration_labels_stand', 'message_interface', 'eng', 'Migration of standard labels', 'message', 'Labels of standard elements');
DELETE FROM label WHERE id_foreign_table = 'migration_gabarits' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('migration_gabarits', 'message_interface', 'fra', 'Migration des gabarits modifiés ou ajoutés', 'message', 'Gabarits modifiés / Gabarits ajoutés');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('migration_gabarits', 'message_interface', 'eng', 'Migration of profiles', 'message', 'Updated profiles / Added profiles');
DELETE FROM label WHERE id_foreign_table = 'bt_generer_xml' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('bt_generer_xml', 'message_interface', 'fra', 'Génération des XML des fiches de métadonnées', 'message', 'Générer les XML des fiches de métadonnées');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('bt_generer_xml', 'message_interface', 'eng', 'Generate XML for metadata sheets', 'message', 'Generate XML for metadata sheets');
DELETE FROM label WHERE id_foreign_table = 'param_connection_bd' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('param_connection_bd', 'message_interface', 'fra', 'Paramètres de connexion à la BD 1.4', 'message', 'Veuillez entrer les paramètres de connexion de votre BD 1.4');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('param_connection_bd', 'message_interface', 'eng', 'Connection parameters for DB 1.4', 'message', 'Please input connection parameters for DB 1.4');
DELETE FROM label WHERE id_foreign_table = 'maj_option_bd' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('maj_option_bd', 'message_interface', 'fra', 'Mises à jour optionnelles de la BD', 'message', 'Choisissez les mises à jour supplémentaires à effectuer');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('maj_option_bd', 'message_interface', 'eng', 'Optional updatings', 'message', 'Select optional updatings');
DELETE FROM label WHERE id_foreign_table = 'mess_migration_bd' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('mess_migration_bd', 'message_interface', 'fra', 'Avertissement pour la migration de la BD 1.4', 'message', 'Attention, suivant la taille de la BD 1.4 le processus peut s''avérer assez long.');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('mess_migration_bd', 'message_interface', 'eng', 'Warning for migration of DB 1.4', 'message', 'Warning ! This process can be very long according to the size of DB 1.4');
DELETE FROM label WHERE id_foreign_table = 'confirm_migration_bd' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('confirm_migration_bd', 'message_interface', 'fra', 'Message de confirmation de la migration de la BD 1.4', 'message', 'La migration de votre base de données s''est déroulée avec succès. <br/>Vous pouvez maintenant générer les XML de vos fiches de métadonnées pour en permettre la consultation.');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('confirm_migration_bd', 'message_interface', 'eng', 'Confirmation for migration of DB 1.4', 'message', 'Migration of your DB 1.4 successed. <br/>You can generate XML metadata sheets to allow search.');
DELETE FROM label WHERE id_foreign_table = 'confirm_generation_xml' AND table_name='message_interface';
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('confirm_generation_xml', 'message_interface', 'fra', 'Message de confirmation pour la génération des XML', 'message', 'Les XML ont été générés, la migration vers la BD 1.5 est terminée.');
INSERT INTO label(id_foreign_table,table_name,iso_lang_code,defn,type_label,label) VALUES ('confirm_generation_xml', 'message_interface', 'eng', 'Confirmation for generate XML', 'message', 'XML were generated. Migration to DB 1.5 is finished.');

--
--------------------------------------------------------------------------- mis à jour du 3/07/07 ------------------------------------------------------
--
delete from label where id_foreign_table='menu_gest_impexp_aper' and iso_lang_code='eng';
delete from label_stand where id_foreign_table='codeSpace' and defn='codeSpace';
--
-- update of 2008-01-15
--
delete from label where id_foreign_table='menu_admin_impexp_aper' and iso_lang_code='eng';
INSERT INTO label VALUES ('menu_admin_impexp_aper', 'message_interface', 'eng', 'label admin menu', 'menu', 'Attach thumbnails');

------------------------------------------------------------------------------- fin mise à jour de la 1.5 ------------------------------------------------------

--
-- modification des libellés de la page de configuration des catalogues distants
--
delete from label where id_foreign_table ='com_config_z3950';
delete from label where id_foreign_table ='com2_config_z3950';
delete from label where id_foreign_table ='com3_config_z3950';
delete from label where id_foreign_table ='com4_config_z3950';
delete from label where id_foreign_table ='com5_config_z3950';
delete from label where id_foreign_table ='com6_config_z3950';
delete from label where id_foreign_table ='nom_serveur_catalog';
delete from label where id_foreign_table ='label_serveur';
delete from label where id_foreign_table ='ip_serveur';
delete from label where id_foreign_table ='bd_serveur';
delete from label where id_foreign_table ='norme_serveur';
delete from label where id_foreign_table ='config_z3950';
delete from label where id_foreign_table ='port_serveur';
delete from label where id_foreign_table ='menu_admin_cat_distant';
--
-- français
--
INSERT INTO label VALUES ('com_config_z3950', 'message_interface', 'fra', 'libellé pour la page de configuration du module de connexion aux catalogues distants', 'message', '<center><p class=text_bleu>Cette page vous permet d''ajouter, de modifier ou de supprimer la mise en ligne d''un catalogue distant accessible via un port PostgreSQL (catalogue MDweb), un service Z39.50 (OGC) ou le web service CSW 2.0.</p></center>');
INSERT INTO label VALUES ('com2_config_z3950', 'message_interface', 'fra', 'libellé page de configuration module de connexion aux catalogues distants', 'message', '<p class=titre4_bleu>Notes sur les champs de formulaire  : </p><ul><li><strong>Type de service</strong> : correspond au nom du service d''accès au catalogue distant. Trois valeurs possibles : sgbd, z3950 ou csw<li><strong>Nom du Catalogue</strong> : Libellé du catalogue distant qui apparaît dans les pages de recherche de MDweb.');
INSERT INTO label VALUES ('com3_config_z3950', 'message_interface', 'fra', 'libellé page de configuration du module de connexion aux catalogues distants', 'message', '<li><strong>Adresse serveur </strong> : IP ou adresse du serveur sur lequel le service de catalogage est invoqué<li><strong>Port</strong> : Port sur lequel les requêtes au serveur distant seront réalisées (ex : 5432 for sgbd, 2100 pour z3950 ; 80 ou 8080 pour csw)');
INSERT INTO label VALUES ('com4_config_z3950', 'message_interface', 'fra', 'libelle page de configuration du module de connexion aux catalogues distants', 'message', '<li><strong>Adresse du service de catalogage distant (non utilisé pour sgbd et z3950)</strong> :  chemin du service de catalogage distant qui complète l''adresse du serveur (ex : /geonetwork/srv/en/csw pour le service csw geonetwork) <li><strong>Profil de métadonnées servis</strong> : Profil de métadonnées servis par le service de catalogage distant invoqué. Les valeurs peuvent être : iso19115, iso191139, iso19139fra, dublincore, fgdc.');
INSERT INTO label VALUES ('com6_config_z3950', 'message_interface', 'fra', 'libelle page de configuration du module de connexion aux catalogues distants', 'message', '<li><strong>Compte </strong> : : compte utilisateur pour accéder au service (activé sur la connexion sgbd) <li><strong>Mot de passe</strong> : mot de passe du compte utilsateur.</ul>');

INSERT INTO label VALUES ('nom_serveur_catalog', 'message_interface', 'fra', 'libellé nom du catalogue', 'message', 'Type de service');
INSERT INTO label VALUES ('label_serveur', 'message_interface', 'fra', 'libellé nom du catalogue', 'message', 'Nom du catalogue');
INSERT INTO label VALUES ('ip_serveur', 'message_interface', 'fra', 'libellé IP machine', 'message', 'Nom du serveur');
INSERT INTO label VALUES ('bd_serveur', 'message_interface', 'fra', 'libelle nom BD', 'message', 'adresse du service');
INSERT INTO label VALUES ('port_serveur', 'message_interface', 'fra', 'libellé IP machine', 'message', 'Port');
INSERT INTO label VALUES ('norme_serveur', 'message_interface', 'fra', 'libelle nom BD', 'message', 'Profil métadonnées');
INSERT INTO label VALUES ('config_z3950', 'message_interface', 'fra', 'libelle utilitaires de configuration du module de connexion aux catalogues distants', 'message', 'Gestion de catalogues distants - (PostgreSQL, Z39.50 OGC, CSW 2.0)');
INSERT INTO label VALUES ('com5_config_z3950', 'message_interface', 'fra', 'libelle', 'message','<p> <font size=1 color=red >Attention, Les modifications, ajout ou suppression doivent &ecirc;tre faites en ayant tous les &eacute;l&eacute;ments n&eacute;cessaires &agrave; la configuration. Ce script modifie les fichiers config.inc.z3950.php et config.inc.csw.php. </font></p>');
-- ajout dans le menu admin
INSERT INTO label VALUES ('menu_admin_cat_distant','message_interface','fra','menu administration','menu','Catalogues distants');

--
-- anglais
--
INSERT INTO label VALUES ('com_config_z3950', 'message_interface', 'eng', 'libellé pour la page de configuration du module de connexion aux catalogues distants', 'message', '<center><p class=text_bleu>This page provides to add, update or delete remote catalog declaration via PostgreSQL port(MDweb catalog) via Z39.50 service connection (OGC) or the web service CSW 2.0.</p></center>');
INSERT INTO label VALUES ('com2_config_z3950', 'message_interface', 'eng', 'libellé page de configuration module de connexion aux catalogues distants', 'message', '<p class=titre4_bleu>Details on form fields  : </p><ul><li><strong>Service type</strong> : is a name of remote catalog service used to access to the catalog. Three values are used : sgbd, z3950 or csw<li><strong>Catalog name</strong> : Label of remote catalog which appears on search results pages of MDweb.');
INSERT INTO label VALUES ('com3_config_z3950', 'message_interface', 'eng', 'libellé page de configuration du module de connexion aux catalogues distants', 'message', '<li><strong>Server address </strong> : IP or address of server on which the catalog service is invoked<li><strong>Port</strong> : Port on which the catalog service is accessible(ex : 5432 for sgbd, 2100 for z3950 ; 80 or 8080 for csw)');
INSERT INTO label VALUES ('com4_config_z3950', 'message_interface', 'eng', 'libelle page de configuration du module de connexion aux catalogues distants', 'message', '<li><strong>Address of remote catalog service (not used for sgbd and z3950 service)</strong> :  path to catalog. Its completes the IP or address of server given before(ex : /geonetwork/srv/en/csw for csw service of geonetwork) <li><strong>Metadata profile used</strong> : Profile of metadata used by the remote catalog service invoked. The values can be: iso19115, iso191139, iso19139fra, dublincore, fgdc.');
INSERT INTO label VALUES ('com6_config_z3950', 'message_interface', 'eng', 'libelle page de configuration du module de connexion aux catalogues distants', 'message', '<li><strong>User account </strong> : :user account to access to the service (only activate on SGBD connection) <li><strong>Password</strong> : password for user account.</ul>');
INSERT INTO label VALUES ('nom_serveur_catalog', 'message_interface', 'eng', 'libellé nom du catalogue', 'message', 'Service Type');
INSERT INTO label VALUES ('label_serveur', 'message_interface', 'eng', 'libellé nom du catalogue', 'message', 'Catalog Name');
INSERT INTO label VALUES ('ip_serveur', 'message_interface', 'eng', 'libellé IP machine', 'message', 'Server name');
INSERT INTO label VALUES ('bd_serveur', 'message_interface', 'eng', 'libelle nom BD', 'message', 'Service address');
INSERT INTO label VALUES ('port_serveur', 'message_interface', 'eng', 'libellé IP machine', 'message', 'Port');
INSERT INTO label VALUES ('norme_serveur', 'message_interface', 'eng', 'libelle nom BD', 'message', 'Metadata profile');
INSERT INTO label VALUES ('config_z3950', 'message_interface', 'eng', 'libelle utilitaires de configuration du module de connexion aux catalogues distants', 'message', 'Remote catalogs management - (PostgreSQL, Z39.50 OGC, CSW 2.0)');
INSERT INTO label VALUES ('com5_config_z3950', 'message_interface', 'eng', 'libelle', 'message','<p> <font size=1 color=red >Warning, the modifications on remote catalog configuration must be made with complete informations on catalog service. This script modifies the config.inc.z3950.php and config.inc.csw.php files. </font></p>');
-- ajout dans le menu admin
INSERT INTO label VALUES ('menu_admin_cat_distant','message_interface','eng','menu administration','menu','Remote catalogs');

--
-- maj de la liste des types de libellés
--
--
-- anglais
--
delete from label where id_foreign_table ='type_label'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_message'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_code'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_element'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_liste'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_gabarit'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_aide'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_catalog'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_mail'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_menu'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_bulle'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_thesaurus'and iso_lang_code='eng';
delete from label where id_foreign_table ='type_label_accueil'and iso_lang_code='eng';

INSERT INTO label VALUES ('type_label', 'liste_interface', 'eng', 'Label ''label type''', 'code', 'Label type');
INSERT INTO label VALUES ('type_label_message', 'elmnt_liste_interface', 'eng', 'Label ''interface messages''', 'code', ' Messages of web pages');
INSERT INTO label VALUES ('type_label_code', 'elmnt_liste_interface', 'eng', 'Label ''preset lists of interface''', 'code', 'Preset lists of web page');
INSERT INTO label VALUES ('type_label_element', 'elmnt_liste_interface', 'eng', 'Label ''standard elements''', 'code', 'Standard elements');
INSERT INTO label VALUES ('type_label_liste', 'elmnt_liste_interface', 'eng', 'Label ''preset lists of standard''', 'code', 'Preset lists of standard');
INSERT INTO label VALUES ('type_label_gabarit', 'elmnt_liste_interface', 'eng', 'Label ''profile name''', 'code', 'Profile name');
INSERT INTO label VALUES ('type_label_thesaurus', 'elmnt_liste_interface', 'eng', 'Label Thesaurus elements', 'code', 'Thesaurus elements');
INSERT INTO label VALUES ('type_label_aide', 'elmnt_liste_interface', 'eng', NULL, 'code', 'Help message');
INSERT INTO label VALUES ('type_label_catalog', 'elmnt_liste_interface', 'eng', '', 'code', 'Catalog name');
INSERT INTO label VALUES ('type_label_mail', 'elmnt_liste_interface', 'eng', '', 'code', 'Mail message');
INSERT INTO label VALUES ('type_label_accueil', 'elmnt_liste_interface', 'eng', NULL, 'code', 'Main page');
INSERT INTO label VALUES ('type_label_menu', 'elmnt_liste_interface', 'eng', NULL, 'code', 'Menu bar');
INSERT INTO label VALUES ('type_label_bulle', 'elmnt_liste_interface', 'eng', '', 'code', 'Bull message');

--- mis à j our du 22/01/08 ---------------------------------

update label set label='Attach a thumbnail to metadata sheet' where id_foreign_table='import_image' and iso_lang_code='eng';

--
-- mise à jour des libellés des éléments 27/2/08
--
delete from label_stand where id_foreign_table='identificationInfo_36';
delete from label_stand where id_foreign_table='distributionInfo_41';
delete from label_stand where id_foreign_table='transferOptions_136';
delete from label_stand where id_foreign_table='onLine_291';
delete from label_stand where id_foreign_table='linkage_300';
delete from label_stand where id_foreign_table='offLine_342';
delete from label_stand where id_foreign_table='transferOptions_340';
delete from label_stand where id_foreign_table='distributorTransferOptions_279';
delete from label_stand where id_foreign_table='distributorFormat_278';
delete from label_stand where id_foreign_table='orderingInstructions_284';
delete from label_stand where id_foreign_table='distributorOrderProcess_277';
delete from label_stand where id_foreign_table='distributorContact_276';
delete from label_stand where id_foreign_table='distributor_135';
delete from label_stand where id_foreign_table='distributionFormat_134';
delete from label_stand where id_foreign_table='name_119';
INSERT INTO label_stand VALUES ('identificationInfo_36', 'elmnt_mtd', 'eng', 'Resource identification', 'Basic information about the resource(s) to which the metadata applies', 'element');
INSERT INTO label_stand  VALUES ('identificationInfo_36', 'elmnt_mtd', 'fra', 'Identification de la ressource', 'Informations de base sur la ressource sur laquelle porte les métadonnées', 'element');
INSERT INTO label_stand VALUES ('identificationInfo_36', 'elmnt_mtd', 'por', 'Identificação do servicio', 'Informations de base sur la ressource sur laquelle porte les métadonnées', 'element');
INSERT INTO label_stand VALUES ('distributionInfo_41', 'elmnt_mtd', 'eng', 'Resource distribution', 'Provides information about the distributor of and options for obtaining the resource(s)', 'element');
INSERT INTO label_stand VALUES ('distributionInfo_41', 'elmnt_mtd', 'fra', 'Distribution du jeu de la ressource', 'Fournit les informations sur le distributeur de la ressource et les options/possibilités de l''obtenir', 'element');
INSERT INTO label_stand VALUES ('distributionInfo_41', 'elmnt_mtd', 'por', 'Distribuição do recurso', 'Fournit les informations sur le distributeur de la ressource et les options/possibilités de l''obtenir', 'element');
INSERT INTO label_stand VALUES ('transferOptions_136', 'elmnt_mtd', 'eng', 'Transfer options', 'Provide information about technical means and media by which a resource is obtained from a distributor', 'element');
INSERT INTO label_stand VALUES ('transferOptions_136', 'elmnt_mtd', 'fra', 'Informations pour le transfert de la ressource', 'Moyens techniques et support par lesquels une ressource est obtenue du distributeur', 'element');
INSERT INTO label_stand VALUES ('transferOptions_136', 'elmnt_mtd', 'por', 'Informações para a transferência do recurso', 'Moyens techniques et support par lesquels une ressource est obtenue du distributeur', 'element');
INSERT INTO label_stand VALUES ('onLine_291', 'elmnt_mtd', 'eng', 'Informations about the online resource', 'Information about the online sources from which the resource can be obtained', 'element');
INSERT INTO label_stand VALUES ('onLine_291', 'elmnt_mtd', 'fra', 'Informations sur la ressource en ligne (On line)', 'Informations sur les sources en ligne à partir desquelles la ressource peut être obtenue', 'element');
INSERT INTO label_stand VALUES ('onLine_291', 'elmnt_mtd', 'por', 'Informações sobre o recurso on line', 'Informations sur les sources en ligne à partir desquelles la ressource peut être obtenue', 'element');
INSERT INTO label_stand VALUES ('linkage_300', 'elmnt_mtd', 'eng', 'Address for resource access', 'location (address) for on-line access using a Uniform Resource Locator or a similar addressing scheme such as http://www.statkart.no/isotc211', 'element');
INSERT INTO label_stand VALUES ('linkage_300', 'elmnt_mtd', 'fra', 'Adresse de téléchargement de la ressource', 'Adresse pour l''accès en ligne utilisant une adresse URL ou un procédé d''adressage similaire (ex : http://www.roselt-oss.teledetection.fr)', 'element');
INSERT INTO label_stand VALUES ('linkage_300', 'elmnt_mtd', 'por', 'Endereço para cargar o recurso', 'Adresse pour l''accès en ligne utilisant une adresse URL ou un procédé d''adressage similaire (ex : http://www.roselt-oss.teledetection.fr)', 'element');
INSERT INTO label_stand VALUES ('offLine_342', 'elmnt_mtd', 'fra', 'Informations sur le support de la ressource (Off Line)', 'Informations sur les sources hors ligne à partir desquelles la ressource peut être obtenue', 'element');
INSERT INTO label_stand VALUES ('offLine_342', 'elmnt_mtd', 'eng', 'Informations about the offline media', 'Information about the offline media on which the resource can be obtained', 'element');
INSERT INTO label_stand VALUES ('offLine_342', 'elmnt_mtd', 'por', 'Informações sobre o suporte do recurso (off line)', 'Informations sur les sources hors ligne à partir desquelles la ressource peut être obtenue', 'element');
INSERT INTO label_stand VALUES ('transferOptions_340', 'elmnt_mtd', 'eng', 'Transfer options', 'Provide information about technical means and media by which a resource is obtained from a distributor', 'element');
INSERT INTO label_stand VALUES ('transferOptions_340', 'elmnt_mtd', 'fra', 'Informations pour le transfert de la ressource', 'Moyens techniques et support par lesquels une ressource est obtenue du distributeur', 'element');
INSERT INTO label_stand VALUES ('transferOptions_340', 'elmnt_mtd', 'por', 'Informações para a transferência do recurso', 'Moyens techniques et support par lesquels une ressource est obtenue du distributeur', 'element');
INSERT INTO label_stand VALUES ('distributorFormat_278', 'elmnt_mtd', 'eng', 'Distributor format', 'Provides information about the format used by the distributor', 'element');
INSERT INTO label_stand VALUES ('distributorFormat_278', 'elmnt_mtd', 'fra', 'Format de distribution de la ressource', 'Format de distribution de la ressource', 'element');
INSERT INTO label_stand VALUES ('distributorTransferOptions_279', 'elmnt_mtd', 'eng', 'Informations about the distributor transfer options', 'Provides informations about the technical means and media used by the distributor', 'element');
INSERT INTO label_stand VALUES ('distributorTransferOptions_279', 'elmnt_mtd', 'fra', 'Modes de transfert de la ressource', 'Modes de transfert de la ressource', 'element');
INSERT INTO label_stand VALUES ('orderingInstructions_284', 'elmnt_mtd', 'fra', 'Formalités d''acquisition de la ressource', 'Formalités d''acquisition de la ressource', 'element');
INSERT INTO label_stand VALUES ('orderingInstructions_284', 'elmnt_mtd', 'eng', 'Generals instructions to provide the resource', 'General instructions, terms and services provided by the distributor', 'element');
INSERT INTO label_stand VALUES ('distributorOrderProcess_277', 'elmnt_mtd', 'eng', 'Distribution order process', 'Provides information about how the resource may be obtained, and related instructions and fee information', 'element');
INSERT INTO label_stand VALUES ('distributorOrderProcess_277', 'elmnt_mtd', 'fra', 'Modalités d''obtention de la ressource', 'Modalités d''obtention de la ressource', 'element');
INSERT INTO label_stand VALUES ('distributorContact_276', 'elmnt_mtd', 'eng', 'Informations tabout  the distributor of the resource', 'Party from whom the resource may be obtained. This list need not be exhaustive', 'element');
INSERT INTO label_stand VALUES ('distributorContact_276', 'elmnt_mtd', 'fra', 'Coordonnées du distributeur de la ressource', 'Correspondant auprès duquel la donnée peut être obtenue, cette liste n''a pas besoin d''être exhaustive', 'element');
INSERT INTO label_stand VALUES ('distributorContact_276', 'elmnt_mtd', 'por', 'Coordenadas do distribuidor do recurso', 'Correspondant auprès duquel la donnée peut être obtenue, cette liste n''a pas besoin d''être exhaustive', 'element');
INSERT INTO label_stand VALUES ('distributor_135', 'elmnt_mtd', 'eng', 'Informations about the distributor of the resource', 'Provides information about the distributor', 'element');
INSERT INTO label_stand VALUES ('distributor_135', 'elmnt_mtd', 'fra', 'Informations sur le distributeur de la ressource', 'Fournit des informations sur le distributeur de la ressource', 'element');
INSERT INTO label_stand VALUES ('distributor_135', 'elmnt_mtd', 'por', 'Informações sobre o distribuidor do recurso', 'Fournit des informations sur le distributeur de la ressource', 'element');
INSERT INTO label_stand VALUES ('distributionFormat_134', 'elmnt_mtd', 'eng', 'Informations about distribution format', 'Provides a description of the format of the data to be distributed', 'element');
INSERT INTO label_stand VALUES ('distributionFormat_134', 'elmnt_mtd', 'fra', 'Informations sur le format de distribution de la ressource', 'Fournit les informations sur le format de la ressource à distribuer', 'element');
INSERT INTO label_stand VALUES ('distributionFormat_134', 'elmnt_mtd', 'por', 'Informações sobre o formato de distribuição do recurso', 'Fournit les informations sur le format de la ressource à distribuer', 'element');
INSERT INTO label_stand VALUES ('name_119', 'elmnt_mtd', 'eng', 'Dataset format', 'Name of the data transfer format(s)', 'element');
INSERT INTO label_stand VALUES ('name_119', 'elmnt_mtd', 'fra', 'Format de la ressource', 'Nom du format de transfert de la ressource', 'element');
INSERT INTO label_stand VALUES ('name_119', 'elmnt_mtd', 'por', 'Formato do recurso', 'Nom du format de transfert de la ressource', 'element');
--
-- ajout des commentaires sur l'élément role
--
delete from label where id_foreign_table='com_role_14';
delete from label where id_foreign_table='com_role_167';
delete from label where id_foreign_table='com_role_196';
delete from label where id_foreign_table='com_role_315';
delete from label where id_foreign_table='com_role_951';
delete from label where id_foreign_table='com_role_979';
delete from label where id_foreign_table='com_role_1031';
delete from label where id_foreign_table='com_role_1360';
delete from label where id_foreign_table='com_role_2202';
delete from label where id_foreign_table='com_role_2062';
delete from label where id_foreign_table='com_role_2254';
delete from label where id_foreign_table='com_role_2330';
delete from label where id_foreign_table='com_role_2358';
delete from label where id_foreign_table='com_role_2410';
delete from label where id_foreign_table='com_role_2510';
delete from label where id_foreign_table='com_role_2586';
delete from label where id_foreign_table='com_role_2966';
delete from label where id_foreign_table='com_role_3042';
delete from label where id_foreign_table='com_role_3118';
delete from label where id_foreign_table='com_role_3194';
delete from label where id_foreign_table='com_role_3270';
delete from label where id_foreign_table='com_role_3346';
delete from label where id_foreign_table='com_role_3422';
delete from label where id_foreign_table='com_role_3574';
delete from label where id_foreign_table='com_role_3498';
delete from label where id_foreign_table='com_role_2002';
insert into label values('com_role_14','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_14','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_167','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_167','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_196','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_196','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_315','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_315','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_951','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_951','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_979','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_979','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_1031','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_1031','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_1360','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_1360','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2202','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2202','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2062','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2062','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2254','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2254','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2330','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2330','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2358','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2358','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2410','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2410','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2510','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2510','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2586','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2586','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2966','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2966','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3042','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3042','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3118','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3118','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3194','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3194','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3270','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3270','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3346','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3346','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3422','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3422','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3498','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3498','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3574','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_3574','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2002','message_interface','fra','Commentaires élément de métadonnées','aide','Liste de valeurs prédéfinies - ISO19115 (CI_RoleCode)');
insert into label values('com_role_2002','message_interface','eng','Metadata element comment','aide','Code list - ISO19115 (CI_RoleCode)');

--
-- message d'erreur supplémentaire sur config bd geo
--
delete from label where id_foreign_table='pas_de_geodb_modifier';
delete from label where id_foreign_table='pas_de_geodb_supprimer';
delete from label where id_foreign_table='pas_de_geodb_creer_config';
delete from label where id_foreign_table='delete_db_ok';
delete from label where id_foreign_table='delete_db_failed';
INSERT INTO label VALUES ('pas_de_geodb_modifier', 'message_interface_geodb', 'eng', '', 'message', 'Find the databases of the current user');
INSERT INTO label VALUES ('pas_de_geodb_modifier', 'message_interface_geodb', 'fra', '', 'message', 'Cherchez les BD de l''utilisateur');
INSERT INTO label VALUES ('pas_de_geodb_supprimer', 'message_interface_geodb', 'eng', '', 'message', 'Find the databases of the current user');
INSERT INTO label VALUES ('pas_de_geodb_supprimer', 'message_interface_geodb', 'fra', '', 'message', 'Cherchez les BD de l''utilisateur');
INSERT INTO label VALUES ('pas_de_geodb_creer_config', 'message_interface_geodb', 'eng', '', 'message', 'Find the databases of the current user');
INSERT INTO label VALUES ('pas_de_geodb_creer_config', 'message_interface_geodb', 'fra', '', 'message', 'Cherchez les BD de l''utilisateur');
INSERT INTO label VALUES ('delete_db_ok', 'message_interface_geodb', 'eng', '', 'message', 'The database has been deleted');
INSERT INTO label VALUES ('delete_db_ok', 'message_interface_geodb', 'fra', '', 'message', 'La base de données a bien été supprimée');
INSERT INTO label VALUES ('delete_db_failed', 'message_interface_geodb', 'eng', '', 'message', 'The database has not been deleted');
INSERT INTO label VALUES ('delete_db_failed', 'message_interface_geodb', 'fra', '', 'message', 'La base de données n''a pu être supprimée');
--
-- message pour la rénitialisation de la configuration de l'éditeur
--
delete from label where id_foreign_table='reinit_carto';
delete from label where id_foreign_table='com_reinit_carto';
INSERT INTO label VALUES ('reinit_carto', 'message_interface_geodb', 'eng', '', 'message', '>> Re initiate the MapBuilder editor');
INSERT INTO label VALUES ('reinit_carto', 'message_interface_geodb', 'fra', '', 'message', '>> Réinitialiser l''éditeur');
INSERT INTO label VALUES ('com_reinit_carto', 'message_interface_geodb', 'eng', '', 'message', 'The re-initialization delete carto.map file, context.xml and also the legend files (sld/*.xml)and run the script which create them using the current parameters of your geodatabase connexion config/config.inc.carto.php </br>Use this action if you have change yours parameters to geodatabase connexion or if you have change the IP or domain name of your web site or for any other problems of configurations');
INSERT INTO label VALUES ('com_reinit_carto', 'message_interface_geodb', 'fra', '', 'message', 'La réinitialisation efface les fichiers carto.map, context.xml ainsi que les fichiers de légendes (sld/*.xml)et les recrée en utilisant les paramètres courants de votre configuration contenus dans le fichier config/config.inc.carto.php</br>Utilisez cette action lorsque vos paramètres de connexion à la base de données géographiques ont été changées, l''adresse de votre site est modifiée ou lorsque vous avez rencontré des problèmes de configuration du client cartographique');

--
-- mdweb-cirad vers mdweb1.6
--
delete from label where id_foreign_table='lien_rech_avancee';
delete from label where id_foreign_table='lien_rech_simple';
delete from label where id_foreign_table='type_rech_keyword_and';
delete from label where id_foreign_table='type_rech_keyword_or';
delete from label where id_foreign_table='type_rech_keyword_not';
delete from label where id_foreign_table='doc_keywords';
delete from label where id_foreign_table='onglet_keywords';
delete from label where id_foreign_table='lien_modif_rech';
delete from label where id_foreign_table='label_form_trie_result';
delete from label where id_foreign_table='label_form_type_trie_titre';
delete from label where id_foreign_table='label_form_type_trie_date';
delete from label where id_foreign_table='label_form_type_trie_ress';
delete from label where id_foreign_table='retour_liste';
delete from label where id_foreign_table='button_voir_resume';
delete from label where id_foreign_table='lien_obtenir_data';

insert into label values ('lien_rech_avancee', 'message_interface', 'fra', '', 'message', 'Recherche avancée');
insert into label values ('lien_rech_avancee', 'message_interface', 'eng', '', 'message', 'Advanced search');

insert into label values ('lien_rech_simple', 'message_interface', 'fra', '', 'message', 'Recherche simple');
insert into label values ('lien_rech_simple', 'message_interface', 'eng', '', 'message', 'Simple search');

insert into label values ('type_rech_keyword_and', 'message_interface', 'fra', 'Recherche tous les mots', 'message', 'Tous les mots suivants');
insert into label values ('type_rech_keyword_and', 'message_interface', 'eng', 'Search all words', 'message', 'Search all of this words');

insert into label values ('type_rech_keyword_or', 'message_interface', 'fra', 'Recherche un des mots', 'message', 'Au moins un des mots suivants');
insert into label values ('type_rech_keyword_or', 'message_interface', 'eng', 'Search one of this words', 'message', 'Search one of this words');

insert into label values ('type_rech_keyword_not', 'message_interface', 'fra', 'Recherche aucun des mots', 'message', 'Aucun des mots suivants');
insert into label values ('type_rech_keyword_not', 'message_interface', 'eng', 'Search any of this words', 'message', 'Search any of this words');

insert into label values ('doc_keywords', 'message_interface', 'fra', 'Message pour aider à  la recherche', 'message', 'Séparer les termes par un espace');
insert into label values ('doc_keywords', 'message_interface', 'eng', '', 'message', 'The search is made using the title, summary, keywords, general themes, autors, date.');

insert into label values ('onglet_keywords', 'message_interface', 'fra', 'quoi', 'message', 'Sur quoi ?');
insert into label values ('onglet_keywords', 'message_interface', 'eng', 'what', 'message', 'Which content ?');

insert into label values ('lien_modif_rech', 'message_interface','fra', '', 'message', 'Modifier votre requête');
insert into label values ('lien_modif_rech', 'message_interface','eng', '', 'message', 'Change search');

insert into label values ('label_form_trie_result', 'message_interface', 'fra', '', 'message', 'Trier les résultats par');
insert into label values ('label_form_trie_result', 'message_interface', 'eng', '', 'message', 'Sort results by');


insert into label values ('label_form_type_trie_titre', 'message_interface', 'fra', '', 'message', 'Titre');
insert into label values ('label_form_type_trie_titre', 'message_interface', 'eng', '', 'message', 'Title');

insert into label values ('label_form_type_trie_date', 'message_interface', 'fra', '', 'message', 'Date');
insert into label values ('label_form_type_trie_date', 'message_interface', 'eng', '', 'message', 'Date');

insert into label values ('label_form_type_trie_ress', 'message_interface', 'fra', '', 'message', 'Type de ressource');
insert into label values ('label_form_type_trie_ress', 'message_interface', 'eng', '', 'message', 'Profile name');

insert into label values ('retour_liste', 'message_interface', 'eng', 'Etiquette retour liste', 'message', 'Back to list');
insert into label values ('retour_liste', 'message_interface', 'fra', 'Etiquette retour liste', 'message', 'Retour à  la liste');

insert into label values ('button_voir_resume', 'message_interface', 'fra', '', 'message', 'Voir le résumé');
insert into label values ('button_voir_resume', 'message_interface', 'eng', '', 'message', 'Show abstract sheet');
insert into label values ('lien_obtenir_data', 'message_interface', 'fra', '', 'message', 'Obtenir cette donnée');
insert into label values ('lien_obtenir_data', 'message_interface', 'eng', '', 'message', 'Obtain this data'); 
--
-- modification de la gestion cirad > mdweb 
--
delete from label where id_foreign_table='modif_tri_titre';
delete from label where id_foreign_table='modif_tri_date';
delete from label where id_foreign_table='modif_tri_id';
delete from label where id_foreign_table='modif_tri_valid_all';
delete from label where id_foreign_table='modif_tri_valid_yes';
delete from label where id_foreign_table='modif_tri_valid_no';
delete from label where id_foreign_table='modif_tri_valid';
delete from label where id_foreign_table='modif_trier';
delete from label where id_foreign_table='apercu';

insert into label values ('modif_tri_titre', 'message_interface','fra', '', 'message', 'Titre');
insert into label values ('modif_tri_titre', 'message_interface','eng', '', 'message', 'Title');

insert into label values ('modif_tri_date', 'message_interface','fra', '', 'message', 'Date');
insert into label values ('modif_tri_date', 'message_interface','eng', '', 'message', 'Date');

insert into label values ('modif_tri_id', 'message_interface','fra', '', 'message', 'Id fiche');
insert into label values ('modif_tri_id', 'message_interface','eng', '', 'message', 'Id sheet');

insert into label values ('modif_tri_valid_all', 'message_interface','fra', '', 'message', 'Oui/Non');
insert into label values ('modif_tri_valid_all', 'message_interface','eng', '', 'message', 'Yes/No');

insert into label values ('modif_tri_valid_yes', 'message_interface','fra', '', 'message', 'Oui');
insert into label values ('modif_tri_valid_yes', 'message_interface','eng', '', 'message', 'Yes');

insert into label values ('modif_tri_valid_no', 'message_interface','fra', '', 'message', 'Non');
insert into label values ('modif_tri_valid_no', 'message_interface','eng', '', 'message', 'No');

insert into label values ('modif_tri_valid', 'message_interface','fra', '', 'message', 'Validée');
insert into label values ('modif_tri_valid', 'message_interface','eng', '', 'message', 'Validated');

insert into label values ('modif_trier', 'message_interface','fra', '', 'message', 'Trier par');
insert into label values ('modif_trier', 'message_interface','eng', '', 'message', 'Sort by');

insert into label values ('apercu', 'message_interface','fra', '', 'message', 'Aperçu');
insert into label values ('apercu', 'message_interface','eng', '', 'message', 'Quicklook');
--
-- ajout libellé pour la gestion de catalogues distants
--
delete from label where id_foreign_table='pass';
delete from label where id_foreign_table='user';

insert into label values ('pass', 'message_interface','fra', '', 'message', 'Mot de passe');
insert into label values ('pass', 'message_interface','eng', '', 'message', 'Password');

insert into label values ('user', 'message_interface','fra', '', 'message', 'Compte');
insert into label values ('user', 'message_interface','eng', '', 'message', 'User account');

--
-- modification de l'aide à la consultation 
--

delete from label where id_foreign_table='aide_consult';
INSERT INTO label VALUES ('aide_consult', 'message_interface', 'fra', '', 'message', 'Réalisez votre recherche multi-critères en utilisant les quatres formulaires accessibles par les onglets Sur Quoi ? Quand ? Où ? et Quelle type de ressource. Les critères choisis doivent être validés par le bouton Envoyer.&nbsp;<a class=normal href=../aide/mdweb-manuel-recherche-fr.html#_Toc170136357  target=_blank>En savoir plus ...</a>');
INSERT INTO label VALUES ('aide_consult', 'message_interface', 'eng', '', 'message', 'Compose your multi-criteria request using the four forms through When ? Where ? Data type ? form. The chosen criteria must be validated by the submit button.&nbsp;<a class=normal href=../aide/mdweb-manuel-recherche-fr.html#_Toc170136357  target=_blank>More... </a>');
INSERT INTO label VALUES ('aide_consult', 'message_interface', 'por', 'label message', 'message', 'efectue a sua pesquisa multi-critérios utilisando os quatro formulários acessíveis por as folhas Qual conteúdo ? Quando ? Onde ? e Que tipo de dados ? Os critériso escolhidos deverão ser validados pelo botão enviar.&nbsp;<a class=normal href=../aide/mdweb-manuel-recherche-fr.html#_Toc170136357  target=_blank>Mais informaçoes... </a>');

--
-- modification id et label dans le navigateur de thésaurus
--
delete from label where id_foreign_table='liens_thes';
INSERT INTO label VALUES ('liens_thes', 'message_interface_thesaurus', 'eng', '', 'message', 'See also related terms');
INSERT INTO label VALUES ('liens_thes', 'message_interface_thesaurus', 'fra', '', 'message', 'Voir aussi les termes liés');

--
-- modifications de libellés des contacts
--
delete from label where id_foreign_table='contact_M';
delete from label where id_foreign_table='contact_R';
delete from label where id_foreign_table='contact_D';
INSERT INTO label  VALUES ('contact_M', 'message_interface', 'eng', '', 'message', 'Catalog contact');
INSERT INTO label  VALUES ('contact_R', 'message_interface', 'eng', '', 'message', 'Resource contact');
INSERT INTO label VALUES ('contact_M', 'message_interface', 'fra', 'label', 'message', 'Contact Catalogue');
INSERT INTO label VALUES ('contact_R', 'message_interface', 'fra', 'label', 'message', 'Contact ressource');
INSERT INTO label  VALUES ('contact_D', 'message_interface', 'fra', 'label', 'message', 'Contact Distribution');
INSERT INTO label  VALUES ('contact_D', 'message_interface', 'eng', 'label', 'message', 'Distribution Contact');
--
--
--
delete from label where id_foreign_table='mdweb-demo16-fra';
delete from label where id_foreign_table='mdweb-demo16';
INSERT INTO label VALUES ('mdweb-demo16', 'elmnt_liste_interface', 'eng', 'catalogue', 'message', 'MDweb demo v1.6 data catalog');
INSERT INTO label VALUES ('mdweb-demo16-fra', 'elmnt_liste_interface', 'fra', 'catalogue', 'message', 'Catalogue de démonstration MDweb v1.6');

--
-- description de l'ISO 19115 pour MDweb
--
--
-- code_list iso 19119
--
insert into code_list values('DCPList','DCPList','true','srv:DCPList');
--
-- elemnt_code_list iso 19119
--
insert into elmnt_code_list values('DCPList_1','DCPList','XML','001','true');
insert into elmnt_code_list values('DCPList_2','DCPList','CORBA','002','true');
insert into elmnt_code_list values('DCPList_3','DCPList','JAVA','003','true');
insert into elmnt_code_list values('DCPList_4','DCPList','COM','004','true');
insert into elmnt_code_list values('DCPList_5','DCPList','SQL','005','true');
insert into elmnt_code_list values('DCPList_6','DCPList','WebServices','006','true');
--
-- standard iso 19119
--
insert into standard values('ISO 19119','Geographic information - Services','IS 2006');
--
--  maj iso 19115 sur l'élément MD_ServiceIdentification_69
--
update elmnt_mtd set elmnt_name='fra:FRA_ServiceIdentification' where elmnt_mtd_id='MD_ServiceIdentification_69';
update elmnt_mtd set stan_name='ISO 19115 FRA 1.0' where elmnt_mtd_id='MD_ServiceIdentification_69';


--
--  elmnt_mtd iso 19119
--
--insert into elmnt_mtd values('MD_ServiceIdentification_69','srv:SV_ServiceIdentification','SerIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('citation_936','gmd:citation','idCitation','ISO 19115',NULL,'rubrique','M','1','true','true',NULL);
insert into elmnt_mtd values('abstract_963','gmd:abstract','idAbs','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('CI_Citation_949','gmd:CI_Citation','Citation','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('title_924','gmd:title','resTitle','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('alternateTitle_925','gmd:alternateTitle','resAltTitle','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('datec_926','gmd:date','resRefDate','ISO 19115',NULL,'rubrique','M','N','true','true',NULL);
insert into elmnt_mtd values('CI_Date_927','gmd:CI_Date','Date','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('date_928','gmd:date','refDate','ISO 19115',NULL,'date','M','1','false','true','gco:Date');
insert into elmnt_mtd values('dateType_929','gmd:dateType','refDateType','ISO 19115','DateTypCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('edition_930','gmd:edition','resEd','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('editionDate_931','gmd:editionDate','resEdDate','ISO 19115',NULL,'date','O','1','false','true','gco:Date');
insert into elmnt_mtd values('identifier_932','gmd:identifier','citId','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('MD_Identifier_933','gmd:MD_Identifier','MdIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('authority_934','gmd:authority','identAuth','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('code_935','gmd:code','identCode','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('citedResponsibleParty_936','gmd:citedResponsibleParty','citRespParty','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('CI_ResponsibleParty_937','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('presentationForm_938','gmd:presentationForm','presForm','ISO 19115','PresFormCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('series_939','gmd:series','datasetSeries','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Series_940','gmd:CI_Series','DatasetSeries','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('name_941','gmd:name','seriesName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('issueIdentification_942','gmd:issueIdentification','issId','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('page_943','gmd:page','artPage','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('otherCitationDetails_944','gmd:otherCitationDetails','otherCitDet','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('collectiveTitle_945','gmd:collectiveTitle','collTitle','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISBN_946','gmd:ISBN','isbn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISSN_947','gmd:ISSN','issn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('purpose_937','gmd:purpose','purpose','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('credit_938','gmd:credit','idCredit','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('status_940','gmd:status','idStatus','ISO 19115','ProgCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('pointOfContact_941','gmd:pointOfContact','idPoC','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('CI_ResponsibleParty_950','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('individualName_948','gmd:individualName','rpIndName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('organisationName_949','gmd:organisationName','rpOrgName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('positionName_950','gmd:positionName','rpPosName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('contactInfo_951','gmd:contactInfo','rpCntInfo','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Contact_952','gmd:CI_Contact','Contact','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('phone_953','gmd:phone','cntPhone','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Telephone_954','gmd:CI_Telephone','Telephone','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('voice_955','gmd:voice','voiceNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('facsimile_956','gmd:facsimile','faxNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('address_957','gmd:address','cntAddress','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Address_958','gmd:CI_Address','Address','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('deliveryPoint_959','gmd:deliveryPoint','delPoint','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('city_960','gmd:city','city','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('administrativeArea_961','gmd:administrativeArea','adminArea','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('postalCode_962','gmd:postalCode','postCode','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('country_963','gmd:country','country','ISO 19115','CountryCd','list_ext','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('electronicMailAddress_964','gmd:electronicMailAddress','eMailAdd','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('onlineRessource_965','gmd:onlineRessource','cntOnlineRes','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_OnlineResource_966','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('linkage_967','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('protocol_968','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('applicationProfile_969','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('name_970','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('description_971','gmd:description','orDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('function_972','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('hoursOfService_973','gmd:hoursOfService','cntHours','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('contactInstructions_974','gmd:contactInstructions','cntInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('role_975','gmd:role','role','ISO 19115','RoleCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('descriptiveKeywords_942','gmd:descriptiveKeywords','descKeys','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('MD_Keywords_951','gmd:MD_Keywords','Keywords','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('keyword_952','gmd:keyword','keyword','ISO 19115',NULL,'thesaurus','M','N','true','true','gco:CharacterString');
insert into elmnt_mtd values('Type_953','gmd:Type','keyTyp','ISO 19115','KeyTypCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ThesaurusName_954','gmd:ThesaurusName','thesaName','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Citation_957','gmd:CI_Citation','Citation','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('title_976','gmd:title','resTitle','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('alternateTitle_977','gmd:alternateTitle','resAltTitle','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('datec_978','gmd:date','resRefDate','ISO 19115',NULL,'rubrique','M','N','true','true',NULL);
insert into elmnt_mtd values('CI_Date_979','gmd:CI_Date','Date','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('date_980','gmd:date','refDate','ISO 19115',NULL,'date','M','1','false','true','gco:Date');
insert into elmnt_mtd values('dateType_981','gmd:dateType','refDateType','ISO 19115','DateTypCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('edition_982','gmd:edition','resEd','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('editionDate_983','gmd:editionDate','resEdDate','ISO 19115',NULL,'date','O','1','false','true','gco:Date');
insert into elmnt_mtd values('identifier_984','gmd:identifier','citId','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('MD_Identifier_985','gmd:MD_Identifier','MdIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('authority_986','gmd:authority','identAuth','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('code_987','gmd:code','identCode','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('citedResponsibleParty_988','gmd:citedResponsibleParty','citRespParty','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('CI_ResponsibleParty_989','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('presentationForm_990','gmd:presentationForm','presForm','ISO 19115','PresFormCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('series_991','gmd:series','datasetSeries','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Series_992','gmd:CI_Series','DatasetSeries','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('name_993','gmd:name','seriesName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('issueIdentification_994','gmd:issueIdentification','issId','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('page_995','gmd:page','artPage','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('otherCitationDetails_996','gmd:otherCitationDetails','otherCitDet','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('collectiveTitle_997','gmd:collectiveTitle','collTitle','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISBN_998','gmd:ISBN','isbn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISSN_999','gmd:ISSN','issn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('serviceType_925','srv:serviceType','serviceType','ISO 19119',NULL,'text','M','1','false','true','gco:LocalName');
insert into elmnt_mtd values('serviceTypeVersion_926','srv:serviceTypeVersion','serviceTypeVersion','ISO 19119',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('accessProperties_930','srv:accessProperties','accessProperties','ISO 19119',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('MD_StandardOrderProcess_931','gmd:MD_StandardOrderProcess','StanOrdProc','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('fees_964','gmd:fees','resfees','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('plannedAvailableDateTime_965','gmd:plannedAvailableDateTime','planAvDtTm','ISO 19115',NULL,'datetime','O','1','false','true','gco:DateTime');
insert into elmnt_mtd values('orderingInstructions_966','gmd:orderingInstructions','ordInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('turnaround_967','gmd:turnaround','ordTurn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('restrictions_932','restrictions','srv:restrictions','ISO 19119',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('MD_Constraints_933','fra:FRA_Constraints','Conts','ISO 19115 FRA 1.0',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('useLimitation_968','gmd:useLimitation','useLimit','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('CI_Citation_980','gmd:CI_Citation','Citation','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('title_1000','gmd:title','resTitle','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('alternateTitle_1001','gmd:alternateTitle','resAltTitle','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('datec_1002','gmd:date','resRefDate','ISO 19115',NULL,'rubrique','M','N','true','true',NULL);
insert into elmnt_mtd values('CI_Date_1003','gmd:CI_Date','Date','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('date_1004','gmd:date','refDate','ISO 19115',NULL,'date','M','1','false','true','gco:Date');
insert into elmnt_mtd values('dateType_1005','gmd:dateType','refDateType','ISO 19115','DateTypCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('edition_1006','gmd:edition','resEd','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('editionDate_1007','gmd:editionDate','resEdDate','ISO 19115',NULL,'date','O','1','false','true','gco:Date');
insert into elmnt_mtd values('identifier_1008','gmd:identifier','citId','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('MD_Identifier_1009','gmd:MD_Identifier','MdIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('authority_1010','gmd:authority','identAuth','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('code_1011','gmd:code','identCode','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('citedResponsibleParty_1012','gmd:citedResponsibleParty','citRespParty','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('CI_ResponsibleParty_1013','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('presentationForm_1014','gmd:presentationForm','presForm','ISO 19115','PresFormCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('series_1015','gmd:series','datasetSeries','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Series_1016','gmd:CI_Series','DatasetSeries','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('name_1017','gmd:name','seriesName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('issueIdentification_1018','gmd:issueIdentification','issId','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('page_1019','gmd:page','artPage','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('otherCitationDetails_1020','gmd:otherCitationDetails','otherCitDet','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('collectiveTitle_1021','gmd:collectiveTitle','collTitle','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISBN_1022','gmd:ISBN','isbn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISSN_1023','gmd:ISSN','issn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('MD_LegalConstraints_955','fra:FRA_LegalConstraints','LegConsts','ISO 19115 FRA 1.0',NULL,'class','ind','N','false','true',NULL);
insert into elmnt_mtd values('useLimitation_969','gmd:useLimitation','useLimit','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('accessConstraints_970','gmd:accessConstraints','accessConsts','ISO 19115','RestrictCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('useConstraints_971','gmd:useConstraints','useConsts','ISO 19115','RestrictCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('otherConstraints_972','gmd:otherConstraints','othConsts','ISO 19115',NULL,'text','C','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('CI_Citation_979','gmd:CI_Citation','Citation','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('title_1024','gmd:title','resTitle','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('alternateTitle_1025','gmd:alternateTitle','resAltTitle','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('datec_1026','gmd:date','resRefDate','ISO 19115',NULL,'rubrique','M','N','true','true',NULL);
insert into elmnt_mtd values('CI_Date_1027','gmd:CI_Date','Date','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('date_1028','gmd:date','refDate','ISO 19115',NULL,'date','M','1','false','true','gco:Date');
insert into elmnt_mtd values('dateType_1029','gmd:dateType','refDateType','ISO 19115','DateTypCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('edition_1030','gmd:edition','resEd','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('editionDate_1031','gmd:editionDate','resEdDate','ISO 19115',NULL,'date','O','1','false','true','gco:Date');
insert into elmnt_mtd values('identifier_1032','gmd:identifier','citId','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('MD_Identifier_1033','gmd:MD_Identifier','MdIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('authority_1034','gmd:authority','identAuth','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('code_1035','gmd:code','identCode','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('citedResponsibleParty_1036','gmd:citedResponsibleParty','citRespParty','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('CI_ResponsibleParty_1037','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('presentationForm_1038','gmd:presentationForm','presForm','ISO 19115','PresFormCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('series_1039','gmd:series','datasetSeries','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Series_1040','gmd:CI_Series','DatasetSeries','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('name_1041','gmd:name','seriesName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('issueIdentification_1042','gmd:issueIdentification','issId','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('page_1043','gmd:page','artPage','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('otherCitationDetails_1044','gmd:otherCitationDetails','otherCitDet','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('collectiveTitle_1045','gmd:collectiveTitle','collTitle','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISBN_1046','gmd:ISBN','isbn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISSN_1047','gmd:ISSN','issn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('MD_SecurityConstraints_956','fra:FRA_SecurityConstraints','SecConsts','ISO 19115 FRA 1.0',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('useLimitation_973','gmd:useLimitation','useLimit','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('classification_974','gmd:classification','class','ISO 19115','ClassificationCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('userNote_975','gmd:userNote','userNote','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('classificationSystem_976','gmd:classificationSystem','classSys','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('handlingDescription_977','gmd:handlingDescription','handDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('CI_Citation_978','gmd:CI_Citation','Citation','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('title_1048','gmd:title','resTitle','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('alternateTitle_1049','gmd:alternateTitle','resAltTitle','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('datec_1050','gmd:date','resRefDate','ISO 19115',NULL,'rubrique','M','N','true','true',NULL);
insert into elmnt_mtd values('CI_Date_1051','gmd:CI_Date','Date','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('date_1052','gmd:date','refDate','ISO 19115',NULL,'date','M','1','false','true','gco:Date');
insert into elmnt_mtd values('dateType_1053','gmd:dateType','refDateType','ISO 19115','DateTypCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('edition_1054','gmd:edition','resEd','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('editionDate_1055','gmd:editionDate','resEdDate','ISO 19115',NULL,'date','O','1','false','true','gco:Date');
insert into elmnt_mtd values('identifier_1056','gmd:identifier','citId','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('MD_Identifier_1057','gmd:MD_Identifier','MdIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('authority_1058','gmd:authority','identAuth','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('code_1059','gmd:code','identCode','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('citedResponsibleParty_1060','gmd:citedResponsibleParty','citRespParty','ISO 19115',NULL,'rubrique','O','N','false','true',NULL);
insert into elmnt_mtd values('CI_ResponsibleParty_1061','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('presentationForm_1062','gmd:presentationForm','presForm','ISO 19115','PresFormCd','list','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('series_1063','gmd:series','datasetSeries','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Series_1064','gmd:CI_Series','DatasetSeries','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('name_1065','gmd:name','seriesName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('issueIdentification_1066','gmd:issueIdentification','issId','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('page_1067','gmd:page','artPage','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('otherCitationDetails_1068','gmd:otherCitationDetails','otherCitDet','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('collectiveTitle_1069','gmd:collectiveTitle','collTitle','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISBN_1070','gmd:ISBN','isbn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('ISSN_1071','gmd:ISSN','issn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('containsOperations_934','srv:containsOperations','containsOperations','ISO 19119',NULL,'rubrique','M','N','fase','true',NULL);
insert into elmnt_mtd values('SV_OperationMetadata_935','srv:SV_OperationMetadata','SV_OperationMetadata','ISO 19119',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('operationName_943','srv:operationName','operationName','ISO 19119',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('DCP_944','srv:DCP','DCP','ISO 19119','DCPList','list','M','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('operationDescription_945','srv:operationDescription','operationDescription','ISO 19119',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('invocationName_946','srv:invocationName','invocationName','ISO 19119',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('connectPoint_947','srv:connectPoint','connectPoint','ISO 19119',NULL,'rubrique','M','N','fase','true',NULL);
insert into elmnt_mtd values('CI_OnlineResource_948','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('linkage_958','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gmd:URL');
insert into elmnt_mtd values('protocol_959','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('applicationProfile_960','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('name_961','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('description_962','gmd:description','exDesc','ISO 19115',NULL,'text','C','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('function_963','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('individualName_1072','gmd:individualName','rpIndName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('organisationName_1073','gmd:organisationName','rpOrgName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('positionName_1074','gmd:positionName','rpPosName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('contactInfo_1075','gmd:contactInfo','rpCntInfo','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Contact_1076','gmd:CI_Contact','Contact','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('phone_1077','gmd:phone','cntPhone','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Telephone_1078','gmd:CI_Telephone','Telephone','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('voice_1079','gmd:voice','voiceNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('facsimile_1080','gmd:facsimile','faxNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('address_1081','gmd:address','cntAddress','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Address_1082','gmd:CI_Address','Address','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('deliveryPoint_1083','gmd:deliveryPoint','delPoint','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('city_1084','gmd:city','city','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('administrativeArea_1085','gmd:administrativeArea','adminArea','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('postalCode_1086','gmd:postalCode','postCode','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('country_1087','gmd:country','country','ISO 19115','CountryCd','list_ext','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('electronicMailAddress_1088','gmd:electronicMailAddress','eMailAdd','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('onlineRessource_1089','gmd:onlineRessource','cntOnlineRes','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_OnlineResource_1090','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('linkage_1091','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('protocol_1092','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('applicationProfile_1093','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('name_1094','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('description_1095','gmd:description','orDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('function_1096','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('hoursOfService_1097','gmd:hoursOfService','cntHours','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('contactInstructions_1098','gmd:contactInstructions','cntInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('role_1099','gmd:role','role','ISO 19115','RoleCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('individualName_1100','gmd:individualName','rpIndName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('organisationName_1101','gmd:organisationName','rpOrgName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('positionName_1102','gmd:positionName','rpPosName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('contactInfo_1103','gmd:contactInfo','rpCntInfo','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Contact_1104','gmd:CI_Contact','Contact','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('phone_1105','gmd:phone','cntPhone','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Telephone_1106','gmd:CI_Telephone','Telephone','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('voice_1107','gmd:voice','voiceNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('facsimile_1108','gmd:facsimile','faxNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('address_1109','gmd:address','cntAddress','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Address_1110','gmd:CI_Address','Address','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('deliveryPoint_1111','gmd:deliveryPoint','delPoint','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('city_1112','gmd:city','city','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('administrativeArea_1113','gmd:administrativeArea','adminArea','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('postalCode_1114','gmd:postalCode','postCode','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('country_1115','gmd:country','country','ISO 19115','CountryCd','list_ext','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('electronicMailAddress_1116','gmd:electronicMailAddress','eMailAdd','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('onlineRessource_1117','gmd:onlineRessource','cntOnlineRes','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_OnlineResource_1118','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('linkage_1119','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('protocol_1120','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('applicationProfile_1121','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('name_1122','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('description_1123','gmd:description','orDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('function_1124','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('hoursOfService_1125','gmd:hoursOfService','cntHours','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('contactInstructions_1126','gmd:contactInstructions','cntInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('role_1127','gmd:role','role','ISO 19115','RoleCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('individualName_1128','gmd:individualName','rpIndName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('organisationName_1129','gmd:organisationName','rpOrgName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('positionName_1130','gmd:positionName','rpPosName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('contactInfo_1131','gmd:contactInfo','rpCntInfo','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Contact_1132','gmd:CI_Contact','Contact','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('phone_1133','gmd:phone','cntPhone','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Telephone_1134','gmd:CI_Telephone','Telephone','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('voice_1135','gmd:voice','voiceNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('facsimile_1136','gmd:facsimile','faxNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('address_1137','gmd:address','cntAddress','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Address_1138','gmd:CI_Address','Address','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('deliveryPoint_1139','gmd:deliveryPoint','delPoint','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('city_1140','gmd:city','city','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('administrativeArea_1141','gmd:administrativeArea','adminArea','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('postalCode_1142','gmd:postalCode','postCode','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('country_1143','gmd:country','country','ISO 19115','CountryCd','list_ext','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('electronicMailAddress_1144','gmd:electronicMailAddress','eMailAdd','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('onlineRessource_1145','gmd:onlineRessource','cntOnlineRes','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_OnlineResource_1146','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('linkage_1147','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('protocol_1148','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('applicationProfile_1149','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('name_1150','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('description_1151','gmd:description','orDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('function_1152','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('hoursOfService_1153','gmd:hoursOfService','cntHours','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('contactInstructions_1154','gmd:contactInstructions','cntInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('role_1155','gmd:role','role','ISO 19115','RoleCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('individualName_1156','gmd:individualName','rpIndName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('organisationName_1157','gmd:organisationName','rpOrgName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('positionName_1158','gmd:positionName','rpPosName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('contactInfo_1159','gmd:contactInfo','rpCntInfo','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Contact_1160','gmd:CI_Contact','Contact','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('phone_1161','gmd:phone','cntPhone','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Telephone_1162','gmd:CI_Telephone','Telephone','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('voice_1163','gmd:voice','voiceNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('facsimile_1164','gmd:facsimile','faxNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('address_1165','gmd:address','cntAddress','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Address_1166','gmd:CI_Address','Address','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('deliveryPoint_1167','gmd:deliveryPoint','delPoint','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('city_1168','gmd:city','city','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('administrativeArea_1169','gmd:administrativeArea','adminArea','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('postalCode_1170','gmd:postalCode','postCode','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('country_1171','gmd:country','country','ISO 19115','CountryCd','list_ext','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('electronicMailAddress_1172','gmd:electronicMailAddress','eMailAdd','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('onlineRessource_1173','gmd:onlineRessource','cntOnlineRes','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_OnlineResource_1174','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('linkage_1175','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('protocol_1176','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('applicationProfile_1177','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('name_1178','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('description_1179','gmd:description','orDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('function_1180','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('hoursOfService_1181','gmd:hoursOfService','cntHours','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('contactInstructions_1182','gmd:contactInstructions','cntInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('role_1183','gmd:role','role','ISO 19115','RoleCd','list','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('individualName_1184','gmd:individualName','rpIndName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('organisationName_1185','gmd:organisationName','rpOrgName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('positionName_1186','gmd:positionName','rpPosName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString');
insert into elmnt_mtd values('contactInfo_1187','gmd:contactInfo','rpCntInfo','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Contact_1188','gmd:CI_Contact','Contact','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('phone_1189','gmd:phone','cntPhone','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Telephone_1190','gmd:CI_Telephone','Telephone','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('voice_1191','gmd:voice','voiceNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('facsimile_1192','gmd:facsimile','faxNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('address_1193','gmd:address','cntAddress','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_Address_1194','gmd:CI_Address','Address','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('deliveryPoint_1195','gmd:deliveryPoint','delPoint','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('city_1196','gmd:city','city','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('administrativeArea_1197','gmd:administrativeArea','adminArea','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('postalCode_1198','gmd:postalCode','postCode','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('country_1199','gmd:country','country','ISO 19115','CountryCd','list_ext','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('electronicMailAddress_1200','gmd:electronicMailAddress','eMailAdd','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString');
insert into elmnt_mtd values('onlineRessource_1201','gmd:onlineRessource','cntOnlineRes','ISO 19115',NULL,'rubrique','O','1','false','true',NULL);
insert into elmnt_mtd values('CI_OnlineResource_1202','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL);
insert into elmnt_mtd values('linkage_1203','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('protocol_1204','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('applicationProfile_1205','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('name_1206','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('description_1207','gmd:description','orDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('function_1208','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('hoursOfService_1209','gmd:hoursOfService','cntHours','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('contactInstructions_1210','gmd:contactInstructions','cntInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString');
insert into elmnt_mtd values('role_1211','gmd:role','role','ISO 19115','RoleCd','list','M','1','false','true','gco:CharacterString');
--
-- est_inclus iso 19119
--

insert into est_inclus values('citation_936','MD_ServiceIdentification_69',1);
insert into est_inclus values('abstract_963','MD_ServiceIdentification_69',2);
insert into est_inclus values('CI_Citation_949','citation_936',0);
insert into est_inclus values('title_924','CI_Citation_949',1);
insert into est_inclus values('alternateTitle_925','CI_Citation_949',2);
insert into est_inclus values('datec_926','CI_Citation_949',3);
insert into est_inclus values('CI_Date_927','datec_926',0);
insert into est_inclus values('date_928','CI_Date_927',1);
insert into est_inclus values('dateType_929','CI_Date_927',2);
insert into est_inclus values('edition_930','CI_Citation_949',4);
insert into est_inclus values('editionDate_931','CI_Citation_949',5);
insert into est_inclus values('identifier_932','CI_Citation_949',6);
insert into est_inclus values('MD_Identifier_933','identifier_932',0);
insert into est_inclus values('authority_934','MD_Identifier_933',1);
insert into est_inclus values('code_935','MD_Identifier_933',2);
insert into est_inclus values('citedResponsibleParty_936','CI_Citation_949',7);
insert into est_inclus values('CI_ResponsibleParty_937','citedResponsibleParty_936',0);
insert into est_inclus values('presentationForm_938','CI_Citation_949',8);
insert into est_inclus values('series_939','CI_Citation_949',9);
insert into est_inclus values('CI_Series_940','series_939',0);
insert into est_inclus values('name_941','CI_Series_940',1);
insert into est_inclus values('issueIdentification_942','CI_Series_940',2);
insert into est_inclus values('page_943','CI_Series_940',3);
insert into est_inclus values('otherCitationDetails_944','CI_Citation_949',10);
insert into est_inclus values('collectiveTitle_945','CI_Citation_949',11);
insert into est_inclus values('ISBN_946','CI_Citation_949',12);
insert into est_inclus values('ISSN_947','CI_Citation_949',13);
insert into est_inclus values('purpose_937','MD_ServiceIdentification_69',3);
insert into est_inclus values('credit_938','MD_ServiceIdentification_69',4);
insert into est_inclus values('status_940','MD_ServiceIdentification_69',5);
insert into est_inclus values('pointOfContact_941','MD_ServiceIdentification_69',6);
insert into est_inclus values('CI_ResponsibleParty_950','pointOfContact_941',0);
insert into est_inclus values('individualName_948','CI_ResponsibleParty_950',1);
insert into est_inclus values('organisationName_949','CI_ResponsibleParty_950',2);
insert into est_inclus values('positionName_950','CI_ResponsibleParty_950',3);
insert into est_inclus values('contactInfo_951','CI_ResponsibleParty_950',4);
insert into est_inclus values('CI_Contact_952','contactInfo_951',0);
insert into est_inclus values('phone_953','CI_Contact_952',1);
insert into est_inclus values('CI_Telephone_954','phone_953',0);
insert into est_inclus values('voice_955','CI_Telephone_954',1);
insert into est_inclus values('facsimile_956','CI_Telephone_954',2);
insert into est_inclus values('address_957','CI_Contact_952',2);
insert into est_inclus values('CI_Address_958','address_957',0);
insert into est_inclus values('deliveryPoint_959','CI_Address_958',1);
insert into est_inclus values('city_960','CI_Address_958',2);
insert into est_inclus values('administrativeArea_961','CI_Address_958',3);
insert into est_inclus values('postalCode_962','CI_Address_958',4);
insert into est_inclus values('country_963','CI_Address_958',5);
insert into est_inclus values('electronicMailAddress_964','CI_Address_958',6);
insert into est_inclus values('onlineRessource_965','CI_Contact_952',3);
insert into est_inclus values('CI_OnlineResource_966','onlineRessource_965',0);
insert into est_inclus values('linkage_967','CI_OnlineResource_966',1);
insert into est_inclus values('protocol_968','CI_OnlineResource_966',2);
insert into est_inclus values('applicationProfile_969','CI_OnlineResource_966',3);
insert into est_inclus values('name_970','CI_OnlineResource_966',4);
insert into est_inclus values('description_971','CI_OnlineResource_966',5);
insert into est_inclus values('function_972','CI_OnlineResource_966',6);
insert into est_inclus values('hoursOfService_973','CI_Contact_952',4);
insert into est_inclus values('contactInstructions_974','CI_Contact_952',5);
insert into est_inclus values('role_975','CI_ResponsibleParty_950',5);
insert into est_inclus values('descriptiveKeywords_942','MD_ServiceIdentification_69',7);
insert into est_inclus values('MD_Keywords_951','descriptiveKeywords_942',0);
insert into est_inclus values('keyword_952','MD_Keywords_951',1);
insert into est_inclus values('Type_953','MD_Keywords_951',2);
insert into est_inclus values('ThesaurusName_954','MD_Keywords_951',3);
insert into est_inclus values('CI_Citation_957','ThesaurusName_954',0);
insert into est_inclus values('title_976','CI_Citation_957',1);
insert into est_inclus values('alternateTitle_977','CI_Citation_957',2);
insert into est_inclus values('datec_978','CI_Citation_957',3);
insert into est_inclus values('CI_Date_979','datec_978',0);
insert into est_inclus values('date_980','CI_Date_979',1);
insert into est_inclus values('dateType_981','CI_Date_979',2);
insert into est_inclus values('edition_982','CI_Citation_957',4);
insert into est_inclus values('editionDate_983','CI_Citation_957',5);
insert into est_inclus values('identifier_984','CI_Citation_957',6);
insert into est_inclus values('MD_Identifier_985','identifier_984',0);
insert into est_inclus values('authority_986','MD_Identifier_985',1);
insert into est_inclus values('code_987','MD_Identifier_985',2);
insert into est_inclus values('citedResponsibleParty_988','CI_Citation_957',7);
insert into est_inclus values('CI_ResponsibleParty_989','citedResponsibleParty_988',0);
insert into est_inclus values('presentationForm_990','CI_Citation_957',8);
insert into est_inclus values('series_991','CI_Citation_957',9);
insert into est_inclus values('CI_Series_992','series_991',0);
insert into est_inclus values('name_993','CI_Series_992',1);
insert into est_inclus values('issueIdentification_994','CI_Series_992',2);
insert into est_inclus values('page_995','CI_Series_992',3);
insert into est_inclus values('otherCitationDetails_996','CI_Citation_957',10);
insert into est_inclus values('collectiveTitle_997','CI_Citation_957',11);
insert into est_inclus values('ISBN_998','CI_Citation_957',12);
insert into est_inclus values('ISSN_999','CI_Citation_957',13);
insert into est_inclus values('serviceType_925','MD_ServiceIdentification_69',8);
insert into est_inclus values('serviceTypeVersion_926','MD_ServiceIdentification_69',9);
insert into est_inclus values('accessProperties_930','MD_ServiceIdentification_69',10);
insert into est_inclus values('MD_StandardOrderProcess_931','accessProperties_930',0);
insert into est_inclus values('fees_964','MD_StandardOrderProcess_931',1);
insert into est_inclus values('plannedAvailableDateTime_965','MD_StandardOrderProcess_931',2);
insert into est_inclus values('orderingInstructions_966','MD_StandardOrderProcess_931',3);
insert into est_inclus values('turnaround_967','MD_StandardOrderProcess_931',4);
insert into est_inclus values('restrictions_932','MD_ServiceIdentification_69',11);
insert into est_inclus values('MD_Constraints_933','restrictions_932',0);
insert into est_inclus values('useLimitation_968','MD_Constraints_933',1);
insert into est_inclus values('CI_Citation_980','MD_Constraints_933',2);
insert into est_inclus values('title_1000','CI_Citation_980',1);
insert into est_inclus values('alternateTitle_1001','CI_Citation_980',2);
insert into est_inclus values('datec_1002','CI_Citation_980',3);
insert into est_inclus values('CI_Date_1003','datec_1002',0);
insert into est_inclus values('date_1004','CI_Date_1003',1);
insert into est_inclus values('dateType_1005','CI_Date_1003',2);
insert into est_inclus values('edition_1006','CI_Citation_980',4);
insert into est_inclus values('editionDate_1007','CI_Citation_980',5);
insert into est_inclus values('identifier_1008','CI_Citation_980',6);
insert into est_inclus values('MD_Identifier_1009','identifier_1008',0);
insert into est_inclus values('authority_1010','MD_Identifier_1009',1);
insert into est_inclus values('code_1011','MD_Identifier_1009',2);
insert into est_inclus values('citedResponsibleParty_1012','CI_Citation_980',7);
insert into est_inclus values('CI_ResponsibleParty_1013','citedResponsibleParty_1012',0);
insert into est_inclus values('presentationForm_1014','CI_Citation_980',8);
insert into est_inclus values('series_1015','CI_Citation_980',9);
insert into est_inclus values('CI_Series_1016','series_1015',0);
insert into est_inclus values('name_1017','CI_Series_1016',1);
insert into est_inclus values('issueIdentification_1018','CI_Series_1016',2);
insert into est_inclus values('page_1019','CI_Series_1016',3);
insert into est_inclus values('otherCitationDetails_1020','CI_Citation_980',10);
insert into est_inclus values('collectiveTitle_1021','CI_Citation_980',11);
insert into est_inclus values('ISBN_1022','CI_Citation_980',12);
insert into est_inclus values('ISSN_1023','CI_Citation_980',13);
insert into est_inclus values('useLimitation_969','MD_LegalConstraints_955',1);
insert into est_inclus values('accessConstraints_970','MD_LegalConstraints_955',2);
insert into est_inclus values('useConstraints_971','MD_LegalConstraints_955',3);
insert into est_inclus values('otherConstraints_972','MD_LegalConstraints_955',4);
insert into est_inclus values('CI_Citation_979','MD_LegalConstraints_955',5);
insert into est_inclus values('title_1024','CI_Citation_979',1);
insert into est_inclus values('alternateTitle_1025','CI_Citation_979',2);
insert into est_inclus values('datec_1026','CI_Citation_979',3);
insert into est_inclus values('CI_Date_1027','datec_1026',0);
insert into est_inclus values('date_1028','CI_Date_1027',1);
insert into est_inclus values('dateType_1029','CI_Date_1027',2);
insert into est_inclus values('edition_1030','CI_Citation_979',4);
insert into est_inclus values('editionDate_1031','CI_Citation_979',5);
insert into est_inclus values('identifier_1032','CI_Citation_979',6);
insert into est_inclus values('MD_Identifier_1033','identifier_1032',0);
insert into est_inclus values('authority_1034','MD_Identifier_1033',1);
insert into est_inclus values('code_1035','MD_Identifier_1033',2);
insert into est_inclus values('citedResponsibleParty_1036','CI_Citation_979',7);
insert into est_inclus values('CI_ResponsibleParty_1037','citedResponsibleParty_1036',0);
insert into est_inclus values('presentationForm_1038','CI_Citation_979',8);
insert into est_inclus values('series_1039','CI_Citation_979',9);
insert into est_inclus values('CI_Series_1040','series_1039',0);
insert into est_inclus values('name_1041','CI_Series_1040',1);
insert into est_inclus values('issueIdentification_1042','CI_Series_1040',2);
insert into est_inclus values('page_1043','CI_Series_1040',3);
insert into est_inclus values('otherCitationDetails_1044','CI_Citation_979',10);
insert into est_inclus values('collectiveTitle_1045','CI_Citation_979',11);
insert into est_inclus values('ISBN_1046','CI_Citation_979',12);
insert into est_inclus values('ISSN_1047','CI_Citation_979',13);
insert into est_inclus values('MD_LegalConstraints_955','restrictions_932',0);
insert into est_inclus values('MD_SecurityConstraints_956','restrictions_932',0);
insert into est_inclus values('useLimitation_973','MD_SecurityConstraints_956',1);
insert into est_inclus values('classification_974','MD_SecurityConstraints_956',2);
insert into est_inclus values('userNote_975','MD_SecurityConstraints_956',3);
insert into est_inclus values('classificationSystem_976','MD_SecurityConstraints_956',4);
insert into est_inclus values('handlingDescription_977','MD_SecurityConstraints_956',5);
insert into est_inclus values('CI_Citation_978','MD_SecurityConstraints_956',6);
insert into est_inclus values('title_1048','CI_Citation_978',1);
insert into est_inclus values('alternateTitle_1049','CI_Citation_978',2);
insert into est_inclus values('datec_1050','CI_Citation_978',3);
insert into est_inclus values('CI_Date_1051','datec_1050',0);
insert into est_inclus values('date_1052','CI_Date_1051',1);
insert into est_inclus values('dateType_1053','CI_Date_1051',2);
insert into est_inclus values('edition_1054','CI_Citation_978',4);
insert into est_inclus values('editionDate_1055','CI_Citation_978',5);
insert into est_inclus values('identifier_1056','CI_Citation_978',6);
insert into est_inclus values('MD_Identifier_1057','identifier_1056',0);
insert into est_inclus values('authority_1058','MD_Identifier_1057',1);
insert into est_inclus values('code_1059','MD_Identifier_1057',2);
insert into est_inclus values('citedResponsibleParty_1060','CI_Citation_978',7);
insert into est_inclus values('CI_ResponsibleParty_1061','citedResponsibleParty_1060',0);
insert into est_inclus values('presentationForm_1062','CI_Citation_978',8);
insert into est_inclus values('series_1063','CI_Citation_978',9);
insert into est_inclus values('CI_Series_1064','series_1063',0);
insert into est_inclus values('name_1065','CI_Series_1064',1);
insert into est_inclus values('issueIdentification_1066','CI_Series_1064',2);
insert into est_inclus values('page_1067','CI_Series_1064',3);
insert into est_inclus values('otherCitationDetails_1068','CI_Citation_978',10);
insert into est_inclus values('collectiveTitle_1069','CI_Citation_978',11);
insert into est_inclus values('ISBN_1070','CI_Citation_978',12);
insert into est_inclus values('ISSN_1071','CI_Citation_978',13);
insert into est_inclus values('containsOperations_934','MD_ServiceIdentification_69',11);
insert into est_inclus values('SV_OperationMetadata_935','containsOperations_934',0);
insert into est_inclus values('operationName_943','SV_OperationMetadata_935',1);
insert into est_inclus values('DCP_944','SV_OperationMetadata_935',2);
insert into est_inclus values('operationDescription_945','SV_OperationMetadata_935',3);
insert into est_inclus values('invocationName_946','SV_OperationMetadata_935',4);
insert into est_inclus values('connectPoint_947','SV_OperationMetadata_935',5);
insert into est_inclus values('CI_OnlineResource_948','connectPoint_947',0);
insert into est_inclus values('linkage_958','CI_OnlineResource_948',1);
insert into est_inclus values('protocol_959','CI_OnlineResource_948',2);
insert into est_inclus values('applicationProfile_960','CI_OnlineResource_948',3);
insert into est_inclus values('name_961','CI_OnlineResource_948',4);
insert into est_inclus values('description_962','CI_OnlineResource_948',5);
insert into est_inclus values('function_963','CI_OnlineResource_948',6);
insert into est_inclus values('individualName_1072','CI_ResponsibleParty_937',1);
insert into est_inclus values('organisationName_1073','CI_ResponsibleParty_937',2);
insert into est_inclus values('positionName_1074','CI_ResponsibleParty_937',3);
insert into est_inclus values('contactInfo_1075','CI_ResponsibleParty_937',4);
insert into est_inclus values('CI_Contact_1076','contactInfo_1075',0);
insert into est_inclus values('phone_1077','CI_Contact_1076',1);
insert into est_inclus values('CI_Telephone_1078','phone_1077',0);
insert into est_inclus values('voice_1079','CI_Telephone_1078',1);
insert into est_inclus values('facsimile_1080','CI_Telephone_1078',2);
insert into est_inclus values('address_1081','CI_Contact_1076',2);
insert into est_inclus values('CI_Address_1082','address_1081',0);
insert into est_inclus values('deliveryPoint_1083','CI_Address_1082',1);
insert into est_inclus values('city_1084','CI_Address_1082',2);
insert into est_inclus values('administrativeArea_1085','CI_Address_1082',3);
insert into est_inclus values('postalCode_1086','CI_Address_1082',4);
insert into est_inclus values('country_1087','CI_Address_1082',5);
insert into est_inclus values('electronicMailAddress_1088','CI_Address_1082',6);
insert into est_inclus values('onlineRessource_1089','CI_Contact_1076',3);
insert into est_inclus values('CI_OnlineResource_1090','onlineRessource_1089',0);
insert into est_inclus values('linkage_1091','CI_OnlineResource_1090',1);
insert into est_inclus values('protocol_1092','CI_OnlineResource_1090',2);
insert into est_inclus values('applicationProfile_1093','CI_OnlineResource_1090',3);
insert into est_inclus values('name_1094','CI_OnlineResource_1090',4);
insert into est_inclus values('description_1095','CI_OnlineResource_1090',5);
insert into est_inclus values('function_1096','CI_OnlineResource_1090',6);
insert into est_inclus values('hoursOfService_1097','CI_Contact_1076',4);
insert into est_inclus values('contactInstructions_1098','CI_Contact_1076',5);
insert into est_inclus values('role_1099','CI_ResponsibleParty_937',5);
insert into est_inclus values('individualName_1100','CI_ResponsibleParty_989',1);
insert into est_inclus values('organisationName_1101','CI_ResponsibleParty_989',2);
insert into est_inclus values('positionName_1102','CI_ResponsibleParty_989',3);
insert into est_inclus values('contactInfo_1103','CI_ResponsibleParty_989',4);
insert into est_inclus values('CI_Contact_1104','contactInfo_1103',0);
insert into est_inclus values('phone_1105','CI_Contact_1104',1);
insert into est_inclus values('CI_Telephone_1106','phone_1105',0);
insert into est_inclus values('voice_1107','CI_Telephone_1106',1);
insert into est_inclus values('facsimile_1108','CI_Telephone_1106',2);
insert into est_inclus values('address_1109','CI_Contact_1104',2);
insert into est_inclus values('CI_Address_1110','address_1109',0);
insert into est_inclus values('deliveryPoint_1111','CI_Address_1110',1);
insert into est_inclus values('city_1112','CI_Address_1110',2);
insert into est_inclus values('administrativeArea_1113','CI_Address_1110',3);
insert into est_inclus values('postalCode_1114','CI_Address_1110',4);
insert into est_inclus values('country_1115','CI_Address_1110',5);
insert into est_inclus values('electronicMailAddress_1116','CI_Address_1110',6);
insert into est_inclus values('onlineRessource_1117','CI_Contact_1104',3);
insert into est_inclus values('CI_OnlineResource_1118','onlineRessource_1117',0);
insert into est_inclus values('linkage_1119','CI_OnlineResource_1118',1);
insert into est_inclus values('protocol_1120','CI_OnlineResource_1118',2);
insert into est_inclus values('applicationProfile_1121','CI_OnlineResource_1118',3);
insert into est_inclus values('name_1122','CI_OnlineResource_1118',4);
insert into est_inclus values('description_1123','CI_OnlineResource_1118',5);
insert into est_inclus values('function_1124','CI_OnlineResource_1118',6);
insert into est_inclus values('hoursOfService_1125','CI_Contact_1104',4);
insert into est_inclus values('contactInstructions_1126','CI_Contact_1104',5);
insert into est_inclus values('role_1127','CI_ResponsibleParty_989',5);
insert into est_inclus values('individualName_1128','CI_ResponsibleParty_1013',1);
insert into est_inclus values('organisationName