-- -- update database 1.5 to 1.6 -- -- this update includes the description of ISO 19119 (IS 2006 + amendements of january 2008), a MDweb profile of web service, a sample metadata sheet of web service and update of label of GUI MDweb -- - -- 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.
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.
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', '

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.

'); INSERT INTO label VALUES ('com2_config_z3950', 'message_interface', 'fra', 'libellé page de configuration module de connexion aux catalogues distants', 'message', '

Notes sur les champs de formulaire :

'); 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','

Attention, Les modifications, ajout ou suppression doivent être faites en ayant tous les éléments nécessaires à la configuration. Ce script modifie les fichiers config.inc.z3950.php et config.inc.csw.php.

'); -- 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', '

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.

'); INSERT INTO label VALUES ('com2_config_z3950', 'message_interface', 'eng', 'libellé page de configuration module de connexion aux catalogues distants', 'message', '

Details on form fields :

'); 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','

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.

'); -- 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
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
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. En savoir plus ...'); 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. More... '); 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. Mais informaçoes... '); -- -- 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 of ISO 19115 for MDweb schema -- -- -- 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, amend. 2008'); -- -- maj iso 19115 sur l'élément MD_ServiceIdentification_69 -- update elmnt_mtd set elmnt_name='srv:SV_ServiceIdentification' where elmnt_mtd_id='MD_ServiceIdentification_69'; -- -- elmnt_mtd iso 19119 -- 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_1951','gmd:title','resTitle','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString'); insert into elmnt_mtd values('alternateTitle_1952','gmd:alternateTitle','resAltTitle','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('datec_1953','gmd:date','resRefDate','ISO 19115',NULL,'rubrique','M','N','true','true',NULL); insert into elmnt_mtd values('CI_Date_1954','gmd:CI_Date','Date','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('date_1955','gmd:date','refDate','ISO 19115',NULL,'date','M','1','false','true','gco:Date'); insert into elmnt_mtd values('dateType_1956','gmd:dateType','refDateType','ISO 19115','DateTypCd','list','M','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('edition_1957','gmd:edition','resEd','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('editionDate_1958','gmd:editionDate','resEdDate','ISO 19115',NULL,'date','O','1','false','true','gco:Date'); insert into elmnt_mtd values('identifier_1959','gmd:identifier','citId','ISO 19115',NULL,'rubrique','O','N','false','true',NULL); insert into elmnt_mtd values('MD_Identifier_1960','gmd:MD_Identifier','MdIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('authority_1961','gmd:authority','identAuth','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('code_1962','gmd:code','identCode','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('citedResponsibleParty_1963','gmd:citedResponsibleParty','citRespParty','ISO 19115',NULL,'rubrique','O','N','false','true',NULL); insert into elmnt_mtd values('CI_ResponsibleParty_1964','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('presentationForm_1965','gmd:presentationForm','presForm','ISO 19115','PresFormCd','list','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('series_1966','gmd:series','datasetSeries','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('CI_Series_1967','gmd:CI_Series','DatasetSeries','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('name_1968','gmd:name','seriesName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('issueIdentification_1969','gmd:issueIdentification','issId','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('page_1970','gmd:page','artPage','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('otherCitationDetails_1971','gmd:otherCitationDetails','otherCitDet','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('collectiveTitle_1972','gmd:collectiveTitle','collTitle','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('ISBN_1973','gmd:ISBN','isbn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('ISSN_1974','gmd:ISSN','issn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('purpose_937','gmd:protocol','protocol','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_1975','gmd:individualName','rpIndName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString'); insert into elmnt_mtd values('organisationName_1976','gmd:organisationName','rpOrgName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString'); insert into elmnt_mtd values('positionName_1977','gmd:positionName','rpPosName','ISO 19115',NULL,'text','O','1','true','true','gco:CharacterString'); insert into elmnt_mtd values('contactInfo_1978','gmd:contactInfo','rpCntInfo','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('CI_Contact_1979','gmd:CI_Contact','Contact','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('phone_1980','gmd:phone','cntPhone','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('CI_Telephone_1981','gmd:CI_Telephone','Telephone','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('voice_1982','gmd:voice','voiceNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('facsimile_1983','gmd:facsimile','faxNum','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('address_1984','gmd:address','cntAddress','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('CI_Address_1985','gmd:CI_Address','Address','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('deliveryPoint_1986','gmd:deliveryPoint','delPoint','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('city_1987','gmd:city','city','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('administrativeArea_1988','gmd:administrativeArea','adminArea','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('postalCode_1989','gmd:postalCode','postCode','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('country_1990','gmd:country','country','ISO 19115','CountryCd','list_ext','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('electronicMailAddress_1991','gmd:electronicMailAddress','eMailAdd','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('onlineRessource_1992','gmd:onlineRessource','cntOnlineRes','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('CI_OnlineResource_1993','gmd:CI_OnlineResource','OnLineRes','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('linkage_1994','gmd:linkage','linkage','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('protocol_1995','gmd:protocol','protocol','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('applicationProfile_1996','gmd:applicationProfile','appProfile','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('name_1997','gmd:name','orName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('description_1998','gmd:description','orDesc','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('function_1999','gmd:function','orFunct','ISO 19115','OnFunctCd','list','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('hoursOfService_2000','gmd:hoursOfService','cntHours','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('contactInstructions_2001','gmd:contactInstructions','cntInstr','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('role_2002','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_2003','gmd:title','resTitle','ISO 19115',NULL,'text','M','1','true','true','gco:CharacterString'); insert into elmnt_mtd values('alternateTitle_2004','gmd:alternateTitle','resAltTitle','ISO 19115',NULL,'text','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('datec_2005','gmd:date','resRefDate','ISO 19115',NULL,'rubrique','M','N','true','true',NULL); insert into elmnt_mtd values('CI_Date_2006','gmd:CI_Date','Date','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('date_2007','gmd:date','refDate','ISO 19115',NULL,'date','M','1','false','true','gco:Date'); insert into elmnt_mtd values('dateType_2008','gmd:dateType','refDateType','ISO 19115','DateTypCd','list','M','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('edition_2009','gmd:edition','resEd','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('editionDate_2010','gmd:editionDate','resEdDate','ISO 19115',NULL,'date','O','1','false','true','gco:Date'); insert into elmnt_mtd values('identifier_2011','gmd:identifier','citId','ISO 19115',NULL,'rubrique','O','N','false','true',NULL); insert into elmnt_mtd values('MD_Identifier_2012','gmd:MD_Identifier','MdIdent','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('authority_2013','gmd:authority','identAuth','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('code_2014','gmd:code','identCode','ISO 19115',NULL,'text','M','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('citedResponsibleParty_2015','gmd:citedResponsibleParty','citRespParty','ISO 19115',NULL,'rubrique','O','N','false','true',NULL); insert into elmnt_mtd values('CI_ResponsibleParty_2016','gmd:CI_ResponsibleParty','RespParty','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('presentationForm_2017','gmd:presentationForm','presForm','ISO 19115','PresFormCd','list','O','N','false','true','gco:CharacterString'); insert into elmnt_mtd values('series_2018','gmd:series','datasetSeries','ISO 19115',NULL,'rubrique','O','1','false','true',NULL); insert into elmnt_mtd values('CI_Series_2019','gmd:CI_Series','DatasetSeries','ISO 19115',NULL,'class','ind','ind','false','true',NULL); insert into elmnt_mtd values('name_2020','gmd:name','seriesName','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('issueIdentification_2021','gmd:issueIdentification','issId','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('page_2022','gmd:page','artPage','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('otherCitationDetails_2023','gmd:otherCitationDetails','otherCitDet','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('collectiveTitle_2024','gmd:collectiveTitle','collTitle','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('ISBN_2025','gmd:ISBN','isbn','ISO 19115',NULL,'text','O','1','false','true','gco:CharacterString'); insert into elmnt_mtd values('ISSN_2026','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','gmd:MD_Constraints','Conts','ISO 19115',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('MD_LegalConstraints_955','gmd:MD_LegalConstraints','LegConsts','ISO 19115',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('MD_SecurityConstraints_956','gmd:MD_SecurityConstraints','SecConsts','ISO 19115',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('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'); -- -- 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_1951','CI_Citation_949',1); insert into est_inclus values('alternateTitle_1952','CI_Citation_949',2); insert into est_inclus values('datec_1953','CI_Citation_949',3); insert into est_inclus values('CI_Date_1954','datec_1953',0); insert into est_inclus values('date_1955','CI_Date_1954',1); insert into est_inclus values('dateType_1956','CI_Date_1954',2); insert into est_inclus values('edition_1957','CI_Citation_949',4); insert into est_inclus values('editionDate_1958','CI_Citation_949',5); insert into est_inclus values('identifier_1959','CI_Citation_949',6); insert into est_inclus values('MD_Identifier_1960','identifier_1959',0); insert into est_inclus values('authority_1961','MD_Identifier_1960',1); insert into est_inclus values('code_1962','MD_Identifier_1960',2); insert into est_inclus values('citedResponsibleParty_1963','CI_Citation_949',7); insert into est_inclus values('CI_ResponsibleParty_1964','citedResponsibleParty_1963',0); insert into est_inclus values('presentationForm_1965','CI_Citation_949',8); insert into est_inclus values('series_1966','CI_Citation_949',9); insert into est_inclus values('CI_Series_1967','series_1966',0); insert into est_inclus values('name_1968','CI_Series_1967',1); insert into est_inclus values('issueIdentification_1969','CI_Series_1967',2); insert into est_inclus values('page_1970','CI_Series_1967',3); insert into est_inclus values('otherCitationDetails_1971','CI_Citation_949',10); insert into est_inclus values('collectiveTitle_1972','CI_Citation_949',11); insert into est_inclus values('ISBN_1973','CI_Citation_949',12); insert into est_inclus values('ISSN_1974','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_1975','CI_ResponsibleParty_950',1); insert into est_inclus values('organisationName_1976','CI_ResponsibleParty_950',2); insert into est_inclus values('positionName_1977','CI_ResponsibleParty_950',3); insert into est_inclus values('contactInfo_1978','CI_ResponsibleParty_950',4); insert into est_inclus values('CI_Contact_1979','contactInfo_1978',0); insert into est_inclus values('phone_1980','CI_Contact_1979',1); insert into est_inclus values('CI_Telephone_1981','phone_1980',0); insert into est_inclus values('voice_1982','CI_Telephone_1981',1); insert into est_inclus values('facsimile_1983','CI_Telephone_1981',2); insert into est_inclus values('address_1984','CI_Contact_1979',2); insert into est_inclus values('CI_Address_1985','address_1984',0); insert into est_inclus values('deliveryPoint_1986','CI_Address_1985',1); insert into est_inclus values('city_1987','CI_Address_1985',2); insert into est_inclus values('administrativeArea_1988','CI_Address_1985',3); insert into est_inclus values('postalCode_1989','CI_Address_1985',4); insert into est_inclus values('country_1990','CI_Address_1985',5); insert into est_inclus values('electronicMailAddress_1991','CI_Address_1985',6); insert into est_inclus values('onlineRessource_1992','CI_Contact_1979',3); insert into est_inclus values('CI_OnlineResource_1993','onlineRessource_1992',0); insert into est_inclus values('linkage_1994','CI_OnlineResource_1993',1); insert into est_inclus values('protocol_1995','CI_OnlineResource_1993',2); insert into est_inclus values('applicationProfile_1996','CI_OnlineResource_1993',3); insert into est_inclus values('name_1997','CI_OnlineResource_1993',4); insert into est_inclus values('description_1998','CI_OnlineResource_1993',5); insert into est_inclus values('function_1999','CI_OnlineResource_1993',6); insert into est_inclus values('hoursOfService_2000','CI_Contact_1979',4); insert into est_inclus values('contactInstructions_2001','CI_Contact_1979',5); insert into est_inclus values('role_2002','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_2003','CI_Citation_957',1); insert into est_inclus values('alternateTitle_2004','CI_Citation_957',2); insert into est_inclus values('datec_2005','CI_Citation_957',3); insert into est_inclus values('CI_Date_2006','datec_2005',0); insert into est_inclus values('date_2007','CI_Date_2006',1); insert into est_inclus values('dateType_2008','CI_Date_2006',2); insert into est_inclus values('edition_2009','CI_Citation_957',4); insert into est_inclus values('editionDate_2010','CI_Citation_957',5); insert into est_inclus values('identifier_2011','CI_Citation_957',6); insert into est_inclus values('MD_Identifier_2012','identifier_2011',0); insert into est_inclus values('authority_2013','MD_Identifier_2012',1); insert into est_inclus values('code_2014','MD_Identifier_2012',2); insert into est_inclus values('citedResponsibleParty_2015','CI_Citation_957',7); insert into est_inclus values('CI_ResponsibleParty_2016','citedResponsibleParty_2015',0); insert into est_inclus values('presentationForm_2017','CI_Citation_957',8); insert into est_inclus values('series_2018','CI_Citation_957',9); insert into est_inclus values('CI_Series_2019','series_2018',0); insert into est_inclus values('name_2020','CI_Series_2019',1); insert into est_inclus values('issueIdentification_2021','CI_Series_2019',2); insert into est_inclus values('page_2022','CI_Series_2019',3); insert into est_inclus values('otherCitationDetails_2023','CI_Citation_957',10); insert into est_inclus values('collectiveTitle_2024','CI_Citation_957',11); insert into est_inclus values('ISBN_2025','CI_Citation_957',12); insert into est_inclus values('ISSN_2026','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',10); 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('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('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('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); -- -- label stand pour iso 19119 -- insert into label_stand values('citation_936','elmnt_mtd','fra','Informations générales sur le service','Référence standardisée de la ressource','element'); insert into label_stand values('citation_936','elmnt_mtd','eng','Citation of documents or information source','Citation data of the resource(s)','element'); insert into label_stand values('abstract_963','elmnt_mtd','fra','Résumé','Bref résumé décrivant le contenu de la donnée','element'); insert into label_stand values('abstract_963','elmnt_mtd','eng','Summary','Brief narrative summary of the content of the resource(s)','element'); insert into label_stand values('CI_Citation_949','elmnt_mtd','fra','CI_Citation','Classe CI_Citation','element'); insert into label_stand values('CI_Citation_949','elmnt_mtd','eng','CI_Citation','Class CI_Citation','element'); insert into label_stand values('title_1951','elmnt_mtd','fra','Titre','Libellé de la ressource (titre)','element'); insert into label_stand values('title_1951','elmnt_mtd','eng','Title','Title of the resource','element'); insert into label_stand values('alternateTitle_1952','elmnt_mtd','fra','Nom court par lequel est appelé la ressource citée','Titre de secondaire complétant le titre principal','element'); insert into label_stand values('alternateTitle_1952','elmnt_mtd','eng','Alternate title of the resource','Short name or other language name by which the cited information is known. Example : DCW as an alternate title for Digital Chart of the World','element'); insert into label_stand values('datec_1953','elmnt_mtd','fra','Date de Référence','Date de référence pour la ressource citée','element'); insert into label_stand values('datec_1953','elmnt_mtd','eng','Reference date','Reference date for the cited resource','element'); insert into label_stand values('CI_Date_1954','elmnt_mtd','fra','CI_Date','Classe CI_Date','element'); insert into label_stand values('CI_Date_1954','elmnt_mtd','eng','CI_Date','Class CI_Date','element'); insert into label_stand values('date_1955','elmnt_mtd','fra','Date de création du jeu de données','Date de référence pour la ressource citée','element'); insert into label_stand values('date_1955','elmnt_mtd','eng','Date of dataset creation','Reference date for the cited resource','element'); insert into label_stand values('dateType_1956','elmnt_mtd','fra','Type de date','Evénement utilisé pour la date de référence','element'); insert into label_stand values('dateType_1956','elmnt_mtd','eng','Event used for reference date','Event used for reference date','element'); insert into label_stand values('edition_1957','elmnt_mtd','fra','Version du jeu de données référencé','Version du document référéncé','element'); insert into label_stand values('edition_1957','elmnt_mtd','eng','Dataset Version','Version of the cited resource','element'); insert into label_stand values('editionDate_1958','elmnt_mtd','fra','Date d''édition du jeu de données','Date d''édition du jeu de données','element'); insert into label_stand values('editionDate_1958','elmnt_mtd','eng','Date of edition','Date of edition','element'); insert into label_stand values('identifier_1959','elmnt_mtd','fra','Identifiant de la ressource','Unique valeur identifiant la ressource citée','element'); insert into label_stand values('identifier_1959','elmnt_mtd','eng','Identifier of the cited resource','Value uniquely identifying an object within a namespace','element'); insert into label_stand values('MD_Identifier_1960','elmnt_mtd','fra','MD_Identifier','Classe MD_Identifier','element'); insert into label_stand values('MD_Identifier_1960','elmnt_mtd','eng','MD_Identifier','Class MD_Identifier','element'); insert into label_stand values('authority_1961','elmnt_mtd','fra','Identifiant de l''autorité responsable de l''espace de nommage','Personne ou organisme responsable de l''espace de nommage','element'); insert into label_stand values('authority_1961','elmnt_mtd','eng','Identifier authority','Person or party responsible for maintenance of the namespace','element'); insert into label_stand values('code_1962','elmnt_mtd','fra','Identifiant de l''espace de nommage','Identifiant de l''espace de nommage','element'); insert into label_stand values('code_1962','elmnt_mtd','eng','Namespace identifier','Namespace identifier','element'); insert into label_stand values('citedResponsibleParty_1963','elmnt_mtd','fra','Informations sur l''organisme de gestion du jeu de données','Informations sur l''organisme qui est gestionnaire de la ressource','element'); insert into label_stand values('citedResponsibleParty_1963','elmnt_mtd','eng','Cited responsible party for the dataset','Name and position information for an individual or oraganisation that is responsible for the resource','element'); insert into label_stand values('CI_ResponsibleParty_1964','elmnt_mtd','fra','CI_ResponsibleParty','Class CI_ResponsibleParty','element'); insert into label_stand values('CI_ResponsibleParty_1964','elmnt_mtd','eng','CI_ResponsibleParty','Classe CI_ResponsibleParty','element'); insert into label_stand values('presentationForm_1965','elmnt_mtd','fra','Type de jeu de données','Manière dont la ressource est représentée','element'); insert into label_stand values('presentationForm_1965','elmnt_mtd','eng','Presentation form of the dataset','Mode in which the resource is represented','element'); insert into label_stand values('series_1966','elmnt_mtd','fra','Informations sur la collection','Informations sur la collection','element'); insert into label_stand values('series_1966','elmnt_mtd','eng','Series information','Information about the series, or aggregate dataset, to which a dataset belongs','element'); insert into label_stand values('CI_Series_1967','elmnt_mtd','fra','CI_Series','Classe CI_Series','element'); insert into label_stand values('CI_Series_1967','elmnt_mtd','eng','CI_Series','Class CI_Series','element'); insert into label_stand values('name_1968','elmnt_mtd','fra','Nom de la collection','Nom de la collection','element'); insert into label_stand values('name_1968','elmnt_mtd','eng','Series name','Name of the series, or aggregate dataset, of which the dataset is a part','element'); insert into label_stand values('issueIdentification_1969','elmnt_mtd','fra','Identification du numéro de la série','Information permettant d''identifier le numéro de la série','element'); insert into label_stand values('issueIdentification_1969','elmnt_mtd','eng','Issue identification','Information identifying the issue of the series','element'); insert into label_stand values('page_1970','elmnt_mtd','fra','Numéro des pages','Numéros des pages dans la collection citée','element'); insert into label_stand values('page_1970','elmnt_mtd','eng','Number of page','Details on which pages of the publication the article was published','element'); insert into label_stand values('otherCitationDetails_1971','elmnt_mtd','fra','Autres détails sur la citation','Autre informations nécessaire sur la citation qui n''a pas été mises par ailleurs','element'); insert into label_stand values('otherCitationDetails_1971','elmnt_mtd','eng','Other citation details','Other information required to complete the citation that is not recorded elsewhere','element'); insert into label_stand values('collectiveTitle_1972','elmnt_mtd','fra','Titre dans la collection','Titre de la ressource dans la collection auquelle elle appartient','element'); insert into label_stand values('collectiveTitle_1972','elmnt_mtd','eng','Collective title of the cited resource','Common title with holdings note. Note : title identifies elements of a series collectively, combined with information about what volumes are available at the source cited','element'); insert into label_stand values('ISBN_1973','elmnt_mtd','fra','ISBN','Identifiant international de la ressource (ISBN : International Standard Book Number)','element'); insert into label_stand values('ISBN_1973','elmnt_mtd','eng','ISBN','International Standard Book Number','element'); insert into label_stand values('ISSN_1974','elmnt_mtd','fra','ISSN','Identifiant international de la collection (ISSN : International Standard Series Number)','element'); insert into label_stand values('ISSN_1974','elmnt_mtd','eng','ISSN','International Standard Series Number','element'); insert into label_stand values('purpose_937','elmnt_mtd','fra','Objectifs','Objectifs','element'); insert into label_stand values('purpose_937','elmnt_mtd','eng','Purpose of the resource(s)','Summary of the intentions with which the resource(s) was developed','element'); insert into label_stand values('credit_938','elmnt_mtd','fra','Auteur(s)','Identification de ceux qui ont contribué à produire la ressource','element'); insert into label_stand values('credit_938','elmnt_mtd','eng','Author(s)','Recognation of those who contributed to the resource(s)','element'); insert into label_stand values('status_940','elmnt_mtd','fra','Statut du service','Statut de la ressource (mise à jour, obsolète,…)','element'); insert into label_stand values('status_940','elmnt_mtd','eng','Status of service','Status of service','element'); insert into label_stand values('pointOfContact_941','elmnt_mtd','fra','Organisme/Personne de contact','Organisme/Personne de contact','element'); insert into label_stand values('pointOfContact_941','elmnt_mtd','eng','Point of contact','Identification of, and means of communication with, person(s) and organization associated with the resource(s)','element'); insert into label_stand values('CI_ResponsibleParty_950','elmnt_mtd','fra','CI_ResponsibleParty','Classe CI_ResponsibleParty','element'); insert into label_stand values('CI_ResponsibleParty_950','elmnt_mtd','eng','CI_ResponsibleParty','Class CI_ResponsibleParty','element'); insert into label_stand values('individualName_1975','elmnt_mtd','fra','Nom de la personne responsable','Nom et prénom de la personne responsable','element'); insert into label_stand values('individualName_1975','elmnt_mtd','eng','Name of responsible person','Name of the responsible person surname, given name, title separated by a delimiter','element'); insert into label_stand values('organisationName_1976','elmnt_mtd','fra','Nom de l''organisme','Nom de l''organisme','element'); insert into label_stand values('organisationName_1976','elmnt_mtd','eng','Name of the responsible organisation','Name of the responsible organisation','element'); insert into label_stand values('positionName_1977','elmnt_mtd','fra','Rôle ou fonction de la personne responsable','Rôle de la personne responsable des métadonnées','element'); insert into label_stand values('positionName_1977','elmnt_mtd','eng','Role or function of responsible person','Position or role of the responsible party','element'); insert into label_stand values('contactInfo_1978','elmnt_mtd','fra','Coordonnées de l''organisme responsable','Coordonnées de l''organisme de gestion des métadonnées','element'); insert into label_stand values('contactInfo_1978','elmnt_mtd','eng','Address about responsible party','Informations about the custodian party of metadata','element'); insert into label_stand values('CI_Contact_1979','elmnt_mtd','fra','CI_Contact','Classe CI_Contact','element'); insert into label_stand values('CI_Contact_1979','elmnt_mtd','eng','CI_Contact','Class CI_Contact','element'); insert into label_stand values('phone_1980','elmnt_mtd','fra','Coordonnées téléphoniques','Numéros de téléphones auquelles l''organisme ou la personne peuvent être contactés','element'); insert into label_stand values('phone_1980','elmnt_mtd','eng','Phone numbers','Telephone numbers at which the organisation or individual may be contacted','element'); insert into label_stand values('CI_Telephone_1981','elmnt_mtd','fra','CI_Telephone','Classe CI_Telephone','element'); insert into label_stand values('CI_Telephone_1981','elmnt_mtd','eng','CI_Telephone','Class CI_Telephone','element'); insert into label_stand values('voice_1982','elmnt_mtd','fra','Numéro de téléphone','Numéro de téléphone du gestionnaire des métadonnées','element'); insert into label_stand values('voice_1982','elmnt_mtd','eng','Voice telephone','Telephone numbers by which individuals can speak to the responsible organisation or individual','element'); insert into label_stand values('facsimile_1983','elmnt_mtd','fra','Numéro de Télécopie','Numéro de Télécopie du gestionnaire des métadonnées','element'); insert into label_stand values('facsimile_1983','elmnt_mtd','eng','Facsimile','Telephone numbers of a facsimile machine for the responsible organisation or individual','element'); insert into label_stand values('address_1984','elmnt_mtd','fra','Adresse de l''organisme','Adresse physique et electronique de l''organisme','element'); insert into label_stand values('address_1984','elmnt_mtd','eng','Address of the responsible party','Physical and email address at which the organisation or individual can be contacted','element'); insert into label_stand values('CI_Address_1985','elmnt_mtd','fra','CI_Address','Classe CI_Address','element'); insert into label_stand values('CI_Address_1985','elmnt_mtd','eng','CI_Address','Class CI_Address','element'); insert into label_stand values('deliveryPoint_1986','elmnt_mtd','fra','Adresse postale','Adresse postale de l''organisme','element'); insert into label_stand values('deliveryPoint_1986','elmnt_mtd','eng','Delivery point','Address line for the location (as described in ISO 11180, annex A)','element'); insert into label_stand values('city_1987','elmnt_mtd','fra','Ville','Ville de l''adresse postale','element'); insert into label_stand values('city_1987','elmnt_mtd','eng','City','City of the location','element'); insert into label_stand values('administrativeArea_1988','elmnt_mtd','fra','Département, Province','Etat, région de l’adresse physique','element'); insert into label_stand values('administrativeArea_1988','elmnt_mtd','eng','Administrative area','State, province of the location','element'); insert into label_stand values('postalCode_1989','elmnt_mtd','fra','Code postal','Code postal de l''adresse postale','element'); insert into label_stand values('postalCode_1989','elmnt_mtd','eng','Postal code','ZIP or other postal code','element'); insert into label_stand values('country_1990','elmnt_mtd','fra','Pays','Pays de l''adresse postale','element'); insert into label_stand values('country_1990','elmnt_mtd','eng','Country','Country of the physical address','element'); insert into label_stand values('electronicMailAddress_1991','elmnt_mtd','fra','Adresse électronique','Adresse électronique de l''organisme responsable','element'); insert into label_stand values('electronicMailAddress_1991','elmnt_mtd','eng','Email','Address of electronic mailbox of the responsible orgnasiation or individual','element'); insert into label_stand values('onlineRessource_1992','elmnt_mtd','fra','Site web donnant des informations sur l''organisme','Informations sur la ressource en ligne donnant des informations sur l''organisme','element'); insert into label_stand values('onlineRessource_1992','elmnt_mtd','eng','On line resource to provide informations about responsible party','On-line information that can be used to contact the individual or organisation','element'); insert into label_stand values('CI_OnlineResource_1993','elmnt_mtd','fra','CI_OnlineResource','Classe CI_OnlineResource','element'); insert into label_stand values('CI_OnlineResource_1993','elmnt_mtd','eng','CI_OnlineResource','Class CI_OnlineResource','element'); insert into label_stand values('linkage_1994','elmnt_mtd','fra','Adresse web (URL)','Adresse pour l''accès en ligne utilisant une adresse URL ou un procédé d''adressage similaire','element'); insert into label_stand values('linkage_1994','elmnt_mtd','eng','Access for on-line address','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('protocol_1995','elmnt_mtd','fra','Protocole de connection','Protocole de connexion à utiliser','element'); insert into label_stand values('protocol_1995','elmnt_mtd','eng','Connection protocol','Connection protocol to be used','element'); insert into label_stand values('applicationProfile_1996','elmnt_mtd','fra','Nom du profil d''application','Nom d’un profil d’application qui peut être utilisé avec la ressource en ligne','element'); insert into label_stand values('applicationProfile_1996','elmnt_mtd','eng','Name of an application profile','Name of an application profile that can be used with the online resource','element'); insert into label_stand values('name_1997','elmnt_mtd','fra','Nom de la ressource en ligne','Nom de la ressource en ligne','element'); insert into label_stand values('name_1997','elmnt_mtd','eng','Name of the online resource','Name of the online resource','element'); insert into label_stand values('description_1998','elmnt_mtd','fra','Description de la ressource en ligne','Description de la ressource en ligne','element'); insert into label_stand values('description_1998','elmnt_mtd','eng','Online resource description','Online resource description','element'); insert into label_stand values('function_1999','elmnt_mtd','fra','Fonctionnalités disponibles','Code pour la fonction exécutée par la ressource en ligne','element'); insert into label_stand values('function_1999','elmnt_mtd','eng','Function performed by the on-line resource','Code or function performed by the on-line resource','element'); insert into label_stand values('hoursOfService_2000','elmnt_mtd','fra','Heures de service','Période pendant laquelle les personnes peuvent contacter la personne ou l’organisation responsable (incluant le fuseau horaire)','element'); insert into label_stand values('hoursOfService_2000','elmnt_mtd','eng','Hours of service','Time period (including time zone) when the individuals can be contact the organisation or individual','element'); insert into label_stand values('contactInstructions_2001','elmnt_mtd','fra','Autres instructions de contacts','Instructions supplémentaires sur comment et quand contacter la personne ou l’organisation','element'); insert into label_stand values('contactInstructions_2001','elmnt_mtd','eng','Contact instructions','Supplemental instructions on how or when to contact the individual or organisation','element'); insert into label_stand values('role_2002','elmnt_mtd','fra','Rôle de l''organisme','Fonction occupée par l''organisme','element'); insert into label_stand values('role_2002','elmnt_mtd','eng','Role of the responsible party','Function performed by the responsible party','element'); insert into label_stand values('descriptiveKeywords_942','elmnt_mtd','fra','Mots clés','Donne les mots clés dans des catégories/thématiques, leur type et la source de référence','element'); insert into label_stand values('descriptiveKeywords_942','elmnt_mtd','eng','Keywords','Provides category keywords, their type and reference source','element'); insert into label_stand values('MD_Keywords_951','elmnt_mtd','fra','MD_Keywords','Classe MD_Keywords','element'); insert into label_stand values('MD_Keywords_951','elmnt_mtd','eng','MD_Keywords','MD_Keywords class','element'); insert into label_stand values('keyword_952','elmnt_mtd','fra','Mots clés','Donne les mots clés dans des catégories/thématiques, leur type et la source de référence','element'); insert into label_stand values('keyword_952','elmnt_mtd','eng','Keywords','Provides category keywords, their type and reference source','element'); insert into label_stand values('Type_953','elmnt_mtd','fra','Type de mot-clés','Sujet utilisé pour grouper des mots-clés similaires','element'); insert into label_stand values('Type_953','elmnt_mtd','eng','Type of keyword','Subject matter used to group similar keywords','element'); insert into label_stand values('ThesaurusName_954','elmnt_mtd','fra','Nom du Thésaurus','Nom du Thésaurus','element'); insert into label_stand values('ThesaurusName_954','elmnt_mtd','eng','Thesaurus name','Name of the formally registered thesaurus or a similar authoritative source of keywords','element'); insert into label_stand values('CI_Citation_957','elmnt_mtd','fra','CI_Citation','Classe CI_Citation','element'); insert into label_stand values('CI_Citation_957','elmnt_mtd','eng','CI_Citation','Class CI_Citation','element'); insert into label_stand values('title_2003','elmnt_mtd','fra','Titre','Libellé de la ressource (titre)','element'); insert into label_stand values('title_2003','elmnt_mtd','eng','Title','Title of the resource','element'); insert into label_stand values('alternateTitle_2004','elmnt_mtd','fra','Nom court par lequel est appelé la ressource citée','Titre de secondaire complétant le titre principal','element'); insert into label_stand values('alternateTitle_2004','elmnt_mtd','eng','Alternate title of the resource','Short name or other language name by which the cited information is known. Example : DCW as an alternate title for Digital Chart of the World','element'); insert into label_stand values('datec_2005','elmnt_mtd','fra','Date de Référence','Date de référence pour la ressource citée','element'); insert into label_stand values('datec_2005','elmnt_mtd','eng','Reference date','Reference date for the cited resource','element'); insert into label_stand values('CI_Date_2006','elmnt_mtd','fra','CI_Date','Classe CI_Date','element'); insert into label_stand values('CI_Date_2006','elmnt_mtd','eng','CI_Date','Class CI_Date','element'); insert into label_stand values('date_2007','elmnt_mtd','fra','Date de création du jeu de données','Date de référence pour la ressource citée','element'); insert into label_stand values('date_2007','elmnt_mtd','eng','Date of dataset creation','Reference date for the cited resource','element'); insert into label_stand values('dateType_2008','elmnt_mtd','fra','Type de date','Evénement utilisé pour la date de référence','element'); insert into label_stand values('dateType_2008','elmnt_mtd','eng','Event used for reference date','Event used for reference date','element'); insert into label_stand values('edition_2009','elmnt_mtd','fra','Version du jeu de données référencé','Version du document référéncé','element'); insert into label_stand values('edition_2009','elmnt_mtd','eng','Dataset Version','Version of the cited resource','element'); insert into label_stand values('editionDate_2010','elmnt_mtd','fra','Date d''édition du jeu de données','Date d''édition du jeu de données','element'); insert into label_stand values('editionDate_2010','elmnt_mtd','eng','Date of edition','Date of edition','element'); insert into label_stand values('identifier_2011','elmnt_mtd','fra','Identifiant de la ressource','Unique valeur identifiant la ressource citée','element'); insert into label_stand values('identifier_2011','elmnt_mtd','eng','Identifier of the cited resource','Value uniquely identifying an object within a namespace','element'); insert into label_stand values('MD_Identifier_2012','elmnt_mtd','fra','MD_Identifier','Classe MD_Identifier','element'); insert into label_stand values('MD_Identifier_2012','elmnt_mtd','eng','MD_Identifier','Class MD_Identifier','element'); insert into label_stand values('authority_2013','elmnt_mtd','fra','Identifiant de l''autorité responsable de l''espace de nommage','Personne ou organisme responsable de l''espace de nommage','element'); insert into label_stand values('authority_2013','elmnt_mtd','eng','Identifier authority','Person or party responsible for maintenance of the namespace','element'); insert into label_stand values('code_2014','elmnt_mtd','fra','Identifiant de l''espace de nommage','Identifiant de l''espace de nommage','element'); insert into label_stand values('code_2014','elmnt_mtd','eng','Namespace identifier','Namespace identifier','element'); insert into label_stand values('citedResponsibleParty_2015','elmnt_mtd','fra','Informations sur l''organisme de gestion du jeu de données','Informations sur l''organisme qui est gestionnaire de la ressource','element'); insert into label_stand values('citedResponsibleParty_2015','elmnt_mtd','eng','Cited responsible party for the dataset','Name and position information for an individual or oraganisation that is responsible for the resource','element'); insert into label_stand values('CI_ResponsibleParty_2016','elmnt_mtd','fra','CI_ResponsibleParty','Class CI_ResponsibleParty','element'); insert into label_stand values('CI_ResponsibleParty_2016','elmnt_mtd','eng','CI_ResponsibleParty','Classe CI_ResponsibleParty','element'); insert into label_stand values('presentationForm_2017','elmnt_mtd','fra','Type de jeu de données','Manière dont la ressource est représentée','element'); insert into label_stand values('presentationForm_2017','elmnt_mtd','eng','Presentation form of the dataset','Mode in which the resource is represented','element'); insert into label_stand values('series_2018','elmnt_mtd','fra','Informations sur la collection','Informations sur la collection','element'); insert into label_stand values('series_2018','elmnt_mtd','eng','Series information','Information about the series, or aggregate dataset, to which a dataset belongs','element'); insert into label_stand values('CI_Series_2019','elmnt_mtd','fra','CI_Series','Classe CI_Series','element'); insert into label_stand values('CI_Series_2019','elmnt_mtd','eng','CI_Series','Class CI_Series','element'); insert into label_stand values('name_2020','elmnt_mtd','fra','Nom de la collection','Nom de la collection','element'); insert into label_stand values('name_2020','elmnt_mtd','eng','Series name','Name of the series, or aggregate dataset, of which the dataset is a part','element'); insert into label_stand values('issueIdentification_2021','elmnt_mtd','fra','Identification du numéro de la série','Information permettant d''identifier le numéro de la série','element'); insert into label_stand values('issueIdentification_2021','elmnt_mtd','eng','Issue identification','Information identifying the issue of the series','element'); insert into label_stand values('page_2022','elmnt_mtd','fra','Numéro des pages','Numéros des pages dans la collection citée','element'); insert into label_stand values('page_2022','elmnt_mtd','eng','Number of page','Details on which pages of the publication the article was published','element'); insert into label_stand values('otherCitationDetails_2023','elmnt_mtd','fra','Autres détails sur la citation','Autre informations nécessaire sur la citation qui n''a pas été mises par ailleurs','element'); insert into label_stand values('otherCitationDetails_2023','elmnt_mtd','eng','Other citation details','Other information required to complete the citation that is not recorded elsewhere','element'); insert into label_stand values('collectiveTitle_2024','elmnt_mtd','fra','Titre dans la collection','Titre de la ressource dans la collection auquelle elle appartient','element'); insert into label_stand values('collectiveTitle_2024','elmnt_mtd','eng','Collective title of the cited resource','Common title with holdings note. Note : title identifies elements of a series collectively, combined with information about what volumes are available at the source cited','element'); insert into label_stand values('ISBN_2025','elmnt_mtd','fra','ISBN','Identifiant international de la ressource (ISBN : International Standard Book Number)','element'); insert into label_stand values('ISBN_2025','elmnt_mtd','eng','ISBN','International Standard Book Number','element'); insert into label_stand values('ISSN_2026','elmnt_mtd','fra','ISSN','Identifiant international de la collection (ISSN : International Standard Series Number)','element'); insert into label_stand values('ISSN_2026','elmnt_mtd','eng','ISSN','International Standard Series Number','element'); insert into label_stand values('serviceType_925','elmnt_mtd','fra','Nom du type de service','Nom du type de service d''un annuaire de service. Par exemple, les valeurs de l''espace de nom et nom des attributs GeneralName peut être OGC et catalogue','element'); insert into label_stand values('serviceType_925','elmnt_mtd','eng','Name of service type','A service type name from a registry of services. For example, the values of the nameSpace and name attributes of GeneralName may be OGC and catalogue','element'); insert into label_stand values('serviceTypeVersion_926','elmnt_mtd','fra','Version du type de service','Fournit pour la version du type de service. Par exemple, nous pouvons être seulement interessés par le service OGC Catalogue v1.1. si la version est maintenu comme un attribut séparé, les utilisateurs pourront aisement recherche une version en particulier','element'); insert into label_stand values('serviceTypeVersion_926','elmnt_mtd','eng','Version of service type','Provides for searching based on the version of serviceType. For exampl, we may only be interested in OGC catalogue v1.1. If version is maintained as a separate attribute, users can easily search for all services of a type regardless of the version','element'); insert into label_stand values('accessProperties_930','elmnt_mtd','fra','Informations sur la disponibilité du service','Informations sur la disponibilité du service incluant le cout, la planification, les délais, etc.','element'); insert into label_stand values('accessProperties_930','elmnt_mtd','eng','Informations about availability of the service','Informations about availability of the service including, fees, planned available date and time, ordering instructions and turnaround','element'); insert into label_stand values('MD_StandardOrderProcess_931','elmnt_mtd','fra','MD_StandardOrderProcess','Classe MD_StandardOrderProcess','element'); insert into label_stand values('MD_StandardOrderProcess_931','elmnt_mtd','eng','MD_StandardOrderProcess','MD_StandardOrderProcess class','element'); insert into label_stand values('fees_964','elmnt_mtd','fra','Prix et unité monétaire du jeu de données','Prix et unité monétaire du jeu de données','element'); insert into label_stand values('fees_964','elmnt_mtd','eng','Fees for the order process','Fees and terms for retreiving the resource. Include monetary units (as specified in ISO 4217)','element'); insert into label_stand values('plannedAvailableDateTime_965','elmnt_mtd','fra','Date et heure d''obtention du service','Date et heure d''obtention du service','element'); insert into label_stand values('plannedAvailableDateTime_965','elmnt_mtd','eng','Availability of the resource (date and time)','Date and time when the resource will be available','element'); insert into label_stand values('orderingInstructions_966','elmnt_mtd','fra','Formalités d''acquisition du jeu de données','Formalités d''acquisition du jeu de données','element'); insert into label_stand values('orderingInstructions_966','elmnt_mtd','eng','Generals instructions to provide the resource','General instructions, terms and services provided by the distributor','element'); insert into label_stand values('turnaround_967','elmnt_mtd','fra','Délai de fourniture du service','Délai de fourniture du service','element'); insert into label_stand values('turnaround_967','elmnt_mtd','eng','Turnaround time to fill an order','Typical turnaround time for the filling of an order','element'); insert into label_stand values('restrictions_932','elmnt_mtd','fra','Informations sur les contraintes d''accès au service','Informations sur les contraintes d''accès au service et les données issues de ce service','element'); insert into label_stand values('restrictions_932','elmnt_mtd','eng','Informations about constraints on the service','Legal and security constraints on accessing the service and distributing data generated by the service','element'); insert into label_stand values('MD_Constraints_933','elmnt_mtd','fra','MD_Constraints','Classe MD_Constraints','element'); insert into label_stand values('MD_Constraints_933','elmnt_mtd','eng','MD_Constraints','Class MD_Constraints','element'); insert into label_stand values('useLimitation_968','elmnt_mtd','fra','Limites d''utilisation du service (scientifique)','Limitation concernant les aptitudes de la ressource pour une utilisation, par exemple : « ne pas utiliser pour la navigation »','element'); insert into label_stand values('useLimitation_968','elmnt_mtd','eng','Limitation use of service','Limitation affecting the fitness for use of the resource or metadata. Example : not be used for navigation','element'); insert into label_stand values('MD_LegalConstraints_955','elmnt_mtd','fra','MD_LegalConstraints','Classe MD_LegalConstraints','element'); insert into label_stand values('MD_LegalConstraints_955','elmnt_mtd','eng','MD_LegalConstraints','MD_LegalConstraints class','element'); insert into label_stand values('useLimitation_969','elmnt_mtd','fra','Limites d''utilisation du service (scientifique)','Limitation concernant les aptitudes de la ressource pour une utilisation, par exemple : « ne pas utiliser pour la navigation »','element'); insert into label_stand values('useLimitation_969','elmnt_mtd','eng','Limitation use of service','Limitation affecting the fitness for use of the resource or metadata. Example : not be used for navigation','element'); insert into label_stand values('accessConstraints_970','elmnt_mtd','fra','Contraintes d''accès aux services','Contraintes d''accès appliquées pour assurer la protection de la propriété privée ou intellectuelle, et toute restriction ou limitation spéciales sur l''obtention de la ressource','element'); insert into label_stand values('accessConstraints_970','elmnt_mtd','eng','Access constraints of the service','Access constraints applied to assure the protection of privacy or intellectual property, and any special restrictions or limitations on obtaining the resource or metadata','element'); insert into label_stand values('useConstraints_971','elmnt_mtd','fra','Contraintes d''utilisation du service (juridique)','Contraintes appliquées pour assurer la protection de la propriété privée ou intellectuelle, et toute restriction ou limitation spéciales ou avertissement/mise en garde sur l''utilisation de la ressource ex : copyright, licence, aucune…','element'); insert into label_stand values('useConstraints_971','elmnt_mtd','eng','Use constraints of the service','Constraints applied to assure the protection of privacy or intellectual property, and any special restrictions or limitations or warning on using resource or metadata','element'); insert into label_stand values('otherConstraints_972','elmnt_mtd','fra','Autres Contraintes sur les services','Autres restrictions et conditions légales requises pour accéder aux métadonnées et l''utiliser','element'); insert into label_stand values('otherConstraints_972','elmnt_mtd','eng','Others constraints of the service','Other restrictions or legal prerequisites for accessing and using the resource or metadata','element'); insert into label_stand values('MD_SecurityConstraints_956','elmnt_mtd','fra','MD_SecurityConstraints','Classe MD_SecurityConstraints','element'); insert into label_stand values('MD_SecurityConstraints_956','elmnt_mtd','eng','MD_SecurityConstraints','MD_SecurityConstraints class','element'); insert into label_stand values('useLimitation_973','elmnt_mtd','fra','Limites d''utilisation du service (scientifique)','Limitation concernant les aptitudes de la ressource pour une utilisation, par exemple : « ne pas utiliser pour la navigation »','element'); insert into label_stand values('useLimitation_973','elmnt_mtd','eng','Limitation use of service','Limitation affecting the fitness for use of the resource or metadata. Example : not be used for navigation','element'); insert into label_stand values('classification_974','elmnt_mtd','fra','Type de contraintes de sécurité','Type de contraintes de sécurité','element'); insert into label_stand values('classification_974','elmnt_mtd','eng','Handling restrictions of the metadata','Name of handling restrictions on the resource or metadata','element'); insert into label_stand values('userNote_975','elmnt_mtd','fra','Explications portant sur les contraintes','Explications portant sur les contraintes','element'); insert into label_stand values('userNote_975','elmnt_mtd','eng','Explanation of the application of the constraints','Explanation of the application of the legal restrictions or other restrictions and legal prerequisites for obtaining and using the resource or metadata','element'); insert into label_stand values('classificationSystem_976','elmnt_mtd','fra','Nom du système de classification','Nom du système de classification','element'); insert into label_stand values('classificationSystem_976','elmnt_mtd','eng','Name of the classification of restrictions','Name of the classification system','element'); insert into label_stand values('handlingDescription_977','elmnt_mtd','fra','Information complémentaire','Information complémentaire','element'); insert into label_stand values('handlingDescription_977','elmnt_mtd','eng','Handling description','Additional information about the restrictions on handling the resource or metadata','element'); insert into label_stand values('containsOperations_934','elmnt_mtd','fra','Informations sur les opérations réalisées par le service',NULL,'element'); insert into label_stand values('containsOperations_934','elmnt_mtd','eng','Informations abput the operations that comprise the service','Informations abput the operations that comprise the service','element'); insert into label_stand values('SV_OperationMetadata_935','elmnt_mtd','fra','SV_OperationMetadata','Classe SV_OperationMetadata','element'); insert into label_stand values('SV_OperationMetadata_935','elmnt_mtd','eng','SV_OperationMetadata','SV_OperationMetadata class','element'); insert into label_stand values('operationName_943','elmnt_mtd','fra','Identifiant de l''opération','Identifiant unique pour cette opération','element'); insert into label_stand values('operationName_943','elmnt_mtd','eng','Operation identifier','A unique identifier for this interface','element'); insert into label_stand values('DCP_944','elmnt_mtd','fra','Type de plateforme d''éxécution','Type de plateforme d''éxécution sur laquelle les opérations seront implémentées','element'); insert into label_stand values('DCP_944','elmnt_mtd','eng','Distributed computing plateforms','Distributed computing plateforms on which the operation has been implemented','element'); insert into label_stand values('operationDescription_945','elmnt_mtd','fra','Description de l''opération','Texte libre pour décrire le but de l''opération et ses résultats','element'); insert into label_stand values('operationDescription_945','elmnt_mtd','eng','Description of the intent of the operation','Description of the intent of the operation and the results of the operation','element'); insert into label_stand values('invocationName_946','elmnt_mtd','fra','Nom utilisé pour appeler le service','Nom utilisé pour appeler le service dans le contexte des DCP. Le nom est identique pour tous les DCP','element'); insert into label_stand values('invocationName_946','elmnt_mtd','eng','Name used to invoke the service','Name used to invoke the service within the context of the DCP. The name is identical for all DCP','element'); insert into label_stand values('connectPoint_947','elmnt_mtd','fra','Point de connexion au service','Point de connexion au service','element'); insert into label_stand values('connectPoint_947','elmnt_mtd','eng','Handle for accessing the service interface','Handle for accessing the service interface','element'); insert into label_stand values('CI_OnlineResource_948','elmnt_mtd','fra','CI_OnlineResource','Classe CI_OnlineResource','element'); insert into label_stand values('CI_OnlineResource_948','elmnt_mtd','eng','CI_OnlineResource','Class CI_OnlineResource','element'); insert into label_stand values('linkage_958','elmnt_mtd','fra','Adresse web (URL)','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_958','elmnt_mtd','eng','Access for on-line address','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('protocol_959','elmnt_mtd','fra','Protocole de connection','Protocole de connexion à utiliser','element'); insert into label_stand values('protocol_959','elmnt_mtd','eng','Connection protocol','Connection protocol to be used','element'); insert into label_stand values('applicationProfile_960','elmnt_mtd','fr