Line 18... |
Line 18... |
18 |
# EFLORE_PROJET vers coel_projet
|
18 |
# EFLORE_PROJET vers coel_projet
|
19 |
# Insertion du projet Inventaire des Herbiers de France - Version 1
|
19 |
# Insertion du projet Inventaire des Herbiers de France - Version 1
|
20 |
INSERT INTO tb_coel.coel_projet (cpr_id_projet, cpr_nom, cpr_abreviation, cpr_description, cpr_url, cpr_ce_meta)
|
20 |
INSERT INTO tb_coel.coel_projet (cpr_id_projet, cpr_nom, cpr_abreviation, cpr_description, cpr_url, cpr_ce_meta)
|
21 |
SELECT 2, EPR_INTITULE_PROJET, EPR_ABREVIATION_PROJET, EPR_DESCRIPTION_PROJET, EPR_LIEN_WEB, @idm
|
21 |
SELECT 2, EPR_INTITULE_PROJET, EPR_ABREVIATION_PROJET, EPR_DESCRIPTION_PROJET, EPR_LIEN_WEB, @idm
|
22 |
FROM tb_herbiers.EFLORE_PROJET;
|
22 |
FROM tb_herbiers.EFLORE_PROJET;
|
23 |
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip) VALUES
|
23 |
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
24 |
(@idm := @idm+1, '113', '2', NULL , NOW( ) , 'Ajout du projet IHF', '1', '1', '162.38.234.1');
|
24 |
VALUES (@idm := @idm+1, '113', '2', NULL , NOW( ) , 'Ajout du projet IHF', '1', '1', '162.38.234.1');
|
- |
|
25 |
# Insertion du projet Utilisateur de l''application COEL - Version 1
|
- |
|
26 |
INSERT INTO tb_coel.coel_projet (cpr_id_projet, cpr_nom, cpr_abreviation, cpr_description, cpr_url, cpr_ce_meta)
|
- |
|
27 |
VALUES 3, 'Utilisateurs', 'U', 'Les utilisateurs de l''application COEL.', NULL, @idm;
|
- |
|
28 |
INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement, cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
- |
|
29 |
VALUES (@idm := @idm+1, '113', '2', NULL , NOW( ) , 'Ajout du projet U', '1', '1', '162.38.234.1');
|
Line -... |
Line 30... |
- |
|
30 |
|
25 |
|
31 |
|
26 |
#------------------------------------------------------------------------------------------------------------------------
|
32 |
#------------------------------------------------------------------------------------------------------------------------
|
27 |
# HERBIERS_ORGANISATION vers coel_structure
|
33 |
# HERBIERS_ORGANISATION vers coel_structure
|
28 |
ALTER TABLE tb_herbiers.HERBIERS_ORGANISATION ORDER BY ID_ORG;# Classement des organisations par ID croissant
|
34 |
ALTER TABLE tb_herbiers.HERBIERS_ORGANISATION ORDER BY ID_ORG;# Classement des organisations par ID croissant
|
29 |
#ALTER TABLE tb_herbiers.HERBIERS_ORGANISATION DROP NUM_COLLECTION, DROP ADRESS_TEXT, DROP TIME_ZONE ;# Suppression des champs inutiles
|
35 |
#ALTER TABLE tb_herbiers.HERBIERS_ORGANISATION DROP NUM_COLLECTION, DROP ADRESS_TEXT, DROP TIME_ZONE ;# Suppression des champs inutiles
|
Line 63... |
Line 69... |
63 |
|
69 |
|
64 |
#------------------------------------------------------------------------------------------------------------------------
|
70 |
#------------------------------------------------------------------------------------------------------------------------
|
65 |
#EFLORE_DROIT_POSSEDER vers coel_personne_a_relation
|
71 |
#EFLORE_DROIT_POSSEDER vers coel_personne_a_relation
|
66 |
INSERT INTO tb_coel.coel_personne_a_relation
|
72 |
INSERT INTO tb_coel.coel_personne_a_relation
|
67 |
(cpar_id_personne_01, cpar_id_personne_02, cpar_id_projet, cpar_id_role, cpar_ce_meta)
|
73 |
(cpar_id_personne_01, cpar_id_personne_02, cpar_id_projet, cpar_id_role, cpar_ce_meta)
|
68 |
SELECT EDP_ID_UTILISATEUR, EDP_ID_UTILISATEUR, 2, IF(EDP_ID_DROIT = '1', 2022, IF(EDP_ID_DROIT = '2', 2023, IF(EDP_ID_DROIT = '3', 2024, 0))), @idm := @idm+1
|
74 |
SELECT EDP_ID_UTILISATEUR, EDP_ID_UTILISATEUR, '2', IF(EDP_ID_DROIT = '1', 2022, IF(EDP_ID_DROIT = '2', 2023, IF(EDP_ID_DROIT = '3', 2024, 0))), @idm := @idm+1
|
69 |
FROM tb_herbiers.EFLORE_DROIT_POSSEDER
|
75 |
FROM tb_herbiers.EFLORE_DROIT_POSSEDER
|
70 |
ORDER BY EDP_ID_UTILISATEUR ASC;
|
76 |
ORDER BY EDP_ID_UTILISATEUR ASC;
|
71 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
77 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
72 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
78 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
73 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
79 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
74 |
SELECT @idm_tmp := @idm_tmp+1, 112, CONCAT(EDP_ID_UTILISATEUR, '-', EDP_ID_UTILISATEUR, '-2-', IF(EDP_ID_DROIT = '1', 2022, IF(EDP_ID_DROIT = '2', 2023, IF(EDP_ID_DROIT = '3', 2024, 0)))), NULL, NOW(), CONCAT('Importation des droits l''utilisateur #',EDP_ID_UTILISATEUR,' de la table EFLORE_DROIT_POSSEDER.'), '1', '1', '162.38.234.1'
|
80 |
SELECT @idm_tmp := @idm_tmp+1, '112', CONCAT(EDP_ID_UTILISATEUR, '-', EDP_ID_UTILISATEUR, '-2-', IF(EDP_ID_DROIT = '1', 2022, IF(EDP_ID_DROIT = '2', 2023, IF(EDP_ID_DROIT = '3', 2024, 0)))), NULL, NOW(), CONCAT('Importation des droits l''utilisateur #',EDP_ID_UTILISATEUR,' de la table EFLORE_DROIT_POSSEDER.'), '1', '1', '162.38.234.1'
|
75 |
FROM tb_herbiers.EFLORE_DROIT_POSSEDER
|
81 |
FROM tb_herbiers.EFLORE_DROIT_POSSEDER
|
Line 76... |
Line 82... |
76 |
ORDER BY EDP_ID_UTILISATEUR ASC;
|
82 |
ORDER BY EDP_ID_UTILISATEUR ASC;
|
77 |
|
83 |
|
Line 83... |
Line 89... |
83 |
FROM tb_herbiers.HERBIER_COORDONNE
|
89 |
FROM tb_herbiers.HERBIER_COORDONNE
|
84 |
ORDER BY HC_ID_COORDINATEUR, HC_ID_REDACTEUR ASC;
|
90 |
ORDER BY HC_ID_COORDINATEUR, HC_ID_REDACTEUR ASC;
|
85 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
91 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
86 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
92 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
87 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
93 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
88 |
SELECT @idm_tmp := @idm_tmp+1, 112, CONCAT(HC_ID_COORDINATEUR, '-', HC_ID_REDACTEUR, '-2-2025'), NULL,
|
94 |
SELECT @idm_tmp := @idm_tmp+1, '112', CONCAT(HC_ID_COORDINATEUR, '-', HC_ID_REDACTEUR, '-2-2025'), NULL,
|
89 |
NOW(), CONCAT('Importation des relations de coordination de l''utilisateur #',HC_ID_COORDINATEUR,' de la table HERBIER_COORDONNE.'), '1', '1', '162.38.234.1'
|
95 |
NOW(), CONCAT('Importation des relations de coordination de l''utilisateur #',HC_ID_COORDINATEUR,' de la table HERBIER_COORDONNE.'), '1', '1', '162.38.234.1'
|
90 |
FROM tb_herbiers.EFLORE_DROIT_POSSEDER
|
96 |
FROM tb_herbiers.EFLORE_DROIT_POSSEDER
|
91 |
ORDER BY EDP_ID_UTILISATEUR ASC;
|
97 |
ORDER BY EDP_ID_UTILISATEUR ASC;
|
Line 92... |
Line 98... |
92 |
|
98 |
|
93 |
#------------------------------------------------------------------------------------------------------------------------
|
99 |
#------------------------------------------------------------------------------------------------------------------------
|
- |
|
100 |
#annuaire_tela vers coel_personne
|
94 |
#annuaire_tela vers coel_personne
|
101 |
# Pour l''identifiant on garde celui de l''annuaire Tela. Les autres projets commenceront à partir de 100 000
|
95 |
INSERT INTO tb_coel.coel_personne
|
102 |
INSERT INTO tb_coel.coel_personne
|
96 |
(cp_id_personne, cp_ce_projet, cp_fmt_nom_complet, cp_prenom, cp_nom,
|
103 |
(cp_id_personne, cp_ce_projet, cp_fmt_nom_complet, cp_prenom, cp_nom,
|
97 |
cp_adresse_01, cp_adresse_02, cp_region, cp_code_postal, cp_ville, cp_pays,
|
104 |
cp_adresse_01, cp_adresse_02, cp_region, cp_code_postal, cp_ville, cp_pays,
|
98 |
cp_truk_courriel, cp_truk_url,
|
105 |
cp_truk_courriel, cp_truk_url,
|
99 |
cp_description,
|
106 |
cp_description,
|
100 |
cp_ce_truk_role,
|
107 |
cp_ce_truk_role,
|
101 |
cp_mot_de_passe, cp_login, cp_parametre,
|
108 |
cp_mot_de_passe, cp_login, cp_ce_annuaire_tela, cp_parametre,
|
102 |
cp_ce_meta)
|
109 |
cp_ce_meta)
|
103 |
SELECT U_ID, 2, CONCAT(U_SURNAME,'',U_NAME) AS NOM_COMPLET, U_SURNAME, U_NAME,
|
110 |
SELECT U_ID, '3', CONCAT(U_SURNAME,'',U_NAME) AS NOM_COMPLET, U_SURNAME, U_NAME,
|
104 |
U_ADDR1, U_ADDR2, U_STATE, U_ZIP_CODE, U_CITY, CP.CP_Intitule_pays,
|
111 |
U_ADDR1, U_ADDR2, U_STATE, U_ZIP_CODE, U_CITY, CP.CP_Intitule_pays,
|
105 |
U_MAIL, U_WEB,
|
112 |
LOWER(U_MAIL), U_WEB,
|
106 |
CONCAT('Spécialités systématiques : ', U_SPE, '\nSpécialités géographiques : ', U_GEO, '\nFonction : ', U_FONCTION, '\nStructure : ', U_TITLE),
|
113 |
CONCAT('Spécialités systématiques : ', U_SPE, '\nSpécialités géographiques : ', U_GEO, '\nFonction : ', U_FONCTION, '\nStructure : ', U_TITLE),
|
107 |
IF(EDP_ID_DROIT = '1', 2022, IF(EDP_ID_DROIT = '2', 2023, IF(EDP_ID_DROIT = '3', 2024, 0))),
|
114 |
IF(EDP_ID_DROIT = '1', 2022, IF(EDP_ID_DROIT = '2', 2023, IF(EDP_ID_DROIT = '3', 2024, 0))),
|
108 |
U_PASSWD, U_MAIL, CONCAT('<?xml version="1.0" encoding="UTF-8"><parametres><niveau_bota>', U_NIV,'</niveau_bota></parametres>'),
|
115 |
U_PASSWD, U_MAIL, U_ID, CONCAT('<?xml version="1.0" encoding="UTF-8"><parametres><niveau_bota>', U_NIV,'</niveau_bota></parametres>'),
|
109 |
@idm := @idm+1
|
116 |
@idm := @idm+1
|
110 |
FROM tela_prod_v4.annuaire_tela AS AT, tb_herbiers.EFLORE_DROIT_POSSEDER AS EDP, tela_prod_v4.carto_PAYS AS CP
|
117 |
FROM tela_prod_v4.annuaire_tela AS AT, tb_herbiers.EFLORE_DROIT_POSSEDER AS EDP, tela_prod_v4.carto_PAYS AS CP
|
111 |
WHERE AT.U_ID = EDP.EDP_ID_UTILISATEUR
|
118 |
WHERE AT.U_ID = EDP.EDP_ID_UTILISATEUR
|
112 |
AND CP.CP_ID_Pays = AT.U_COUNTRY
|
119 |
AND CP.CP_ID_Pays = AT.U_COUNTRY
|
Line 132... |
Line 139... |
132 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
139 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
133 |
SELECT @idm_tmp := @idm_tmp+1, '118', CONCAT(HA_ID_ORG, '-', HA_ID_ANNUAIRE, '-2026'), NULL,
|
140 |
SELECT @idm_tmp := @idm_tmp+1, '118', CONCAT(HA_ID_ORG, '-', HA_ID_ANNUAIRE, '-2026'), NULL,
|
134 |
NOW(), CONCAT('Importation des de l''administrateur #',HA_ID_ANNUAIRE,' de la structure #', HA_ID_ORG,'de la table HERBIER_ADMINISTRER.'), '1', '1', '162.38.234.1'
|
141 |
NOW(), CONCAT('Importation des de l''administrateur #',HA_ID_ANNUAIRE,' de la structure #', HA_ID_ORG,'de la table HERBIER_ADMINISTRER.'), '1', '1', '162.38.234.1'
|
135 |
FROM tb_herbiers.HERBIER_ADMINISTRER
|
142 |
FROM tb_herbiers.HERBIER_ADMINISTRER
|
136 |
ORDER BY HA_ID_ANNUAIRE, HA_ID_ORG ASC;
|
143 |
ORDER BY HA_ID_ANNUAIRE, HA_ID_ORG ASC;
|
- |
|
144 |
|
- |
|
145 |
|
- |
|
146 |
#------------------------------------------------------------------------------------------------------------------------
|
- |
|
147 |
#HERBIERS_STAFF vers coel_personne
|
- |
|
148 |
INSERT INTO tb_coel.coel_personne
|
- |
|
149 |
(cp_id_personne, cp_ce_projet, cp_fmt_nom_complet, cp_nom, cp_prenom, cp_adresse_01, cp_adresse_02, cp_code_postal, cp_ville, cp_truk_courriel,
|
- |
|
150 |
cp_truk_telephone, cp_truk_fax, cp_ce_meta)
|
- |
|
151 |
SELECT 100000+ID_STAFF, '2', CONCAT(PRENOM,'', NOM) AS NOM_COMPLET, NOM, PRENOM, ADRESSE1, ADRESSE2, CP, VILLE, LOWER(MAIL),
|
- |
|
152 |
IF(TEL != NULL, CONCAT('+33', TRIM(LEADING '0' FROM REPLACE(TEL,'[33]',''))), NULL), CONCAT('+33', TRIM(LEADING '0' FROM REPLACE(FAX,'[33]',''))), @idm := @idm+1
|
- |
|
153 |
FROM tb_herbiers.HERBIERS_STAFF
|
- |
|
154 |
ORDER BY ID_STAFF ASC;
|
- |
|
155 |
INSERT INTO tb_coel.coel_metal_historique_ligne
|
- |
|
156 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
- |
|
157 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
- |
|
158 |
SELECT @idm_tmp := @idm_tmp+1, '111', , NULL, DATE_DERNIERE_MODIF,
|
- |
|
159 |
CONCAT('Importation de l''utilisateur #', ID_STAFF,'de la table HERBIERS_STAFF'), '1', '1', '162.38.234.1'
|
- |
|
160 |
FROM tb_herbiers.HERBIERS_STAFF
|
- |
|
161 |
ORDER BY ID_STAFF ASC;
|
- |
|
162 |
UPDATE tb_coel.coel_personne SET cp_truk_telephone = IF(cp_truk_telephone LIKE (+336%), CONCAT('GSM#', cp_truk_telephone), CONCAT('FIX#', cp_truk_telephone)));
|
- |
|
163 |
UPDATE tb_coel.coel_personne SET cp_truk_telephone = REPLACE(cp_truk_telephone, '.', ' ') WHERE cp_truk_telephone LIKE '%.%';
|
- |
|
164 |
UPDATE tb_coel.coel_personne SET cp_truk_telephone = REPLACE(cp_truk_telephone, '+33 (0)', '') WHERE cp_truk_telephone LIKE '%+33 (0)%';
|
- |
|
165 |
# TODO : faire les fax
|
Line 137... |
Line 166... |
137 |
|
166 |
|
- |
|
167 |
#------------------------------------------------------------------------------------------------------------------------
|
- |
|
168 |
# HERBIERS_ont_un_staff vers coel_structure_a_personne
|
- |
|
169 |
INSERT INTO tb_coel.coel_structure_a_personne
|
- |
|
170 |
(csap_id_structure, csap_id_personne, csap_id_role, csap_mark_contact, csap_ce_truk_fonction, csap_ce_meta)
|
- |
|
171 |
SELECT ID_ORG, hous.ID_STAFF, '2027', IF(LOWER(CONTACT) = 'oui', 1, 0) AS CONTACT, IF(FONCTION != '', CONCAT('AUTRE#', FONCTION), NULL) AS FONCTION, @idm := @idm+1
|
- |
|
172 |
FROM tb_herbiers.HERBIERS_ont_un_staff AS hous LEFT JOIN tb_herbiers.HERBIERS_STAFF AS hs ON (hous.ID_STAFF = hs.ID_STAFF)
|
- |
|
173 |
WHERE hous.ID_ORG != 0
|
- |
|
174 |
ORDER BY hous.ID_ORG, hous.ID_STAFF ASC;
|
- |
|
175 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
- |
|
176 |
(cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
- |
|
177 |
cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
- |
|
178 |
SELECT @idm_tmp := @idm_tmp+1, '118', CONCAT(ID_ORG, '-', ID_STAFF, '-2027'), NULL,
|
- |
|
179 |
NOW(), CONCAT('Importation de la personne #',ID_STAFF,' de la structure #', ID_ORG,'de la table HERBIERS_ont_un_staff.'), '1', '1', '162.38.234.1'
|
- |
|
180 |
FROM tb_herbiers.HERBIERS_ont_un_staff
|
- |
|
181 |
WHERE hous.ID_ORG != 0
|
- |
|
182 |
ORDER BY ID_ORG, ID_STAFF ASC;
|
- |
|
183 |
# TODO : ajouter une requête d''update pour mettre à jour la fonction...
|
- |
|
184 |
|
- |
|
185 |
|
138 |
#------------------------------------------------------------------------------------------------------------------------
|
186 |
#------------------------------------------------------------------------------------------------------------------------
|
139 |
#HERBIER_COLLECTION vers coel_collection
|
187 |
#HERBIER_COLLECTION vers coel_collection
|
140 |
#INSERT INTO tb_coel.coel_collection
|
188 |
#INSERT INTO tb_coel.coel_collection
|
141 |
# (cc_id_collection, cc_ce_projet, cc_ce_mere, cc_truk_code, cc_nom, cc_description,
|
189 |
# (cc_id_collection, cc_ce_projet, cc_ce_mere, cc_truk_code, cc_nom, cc_description,
|
142 |
# cc_truk_url, cc_ce_type,
|
- |
|
143 |
# cc_truk_conservation_statut, cc_truk_preservation,
|
- |
|
144 |
# cc_ce_developpement, cc_truk_periode_constitution, cc_truk_couverture_lieu, cc_truk_coordonnee, cc_ce_specimen_type,
|
- |
|
145 |
# cc_specimen_type_nbre, cc_mark_speciment_type_nbre_precision, cc_ce_specimen_type_classement, cc_expedition_nom,
|
190 |
# cc_truk_url, cc_ce_type,
|
146 |
# cc_truk_digital_medium, cc_truk_digital_format,
|
- |
|
147 |
#
|
191 |
# cc_specimen_type_nbre,
|
148 |
# cc_ce_meta)
|
192 |
# cc_ce_meta)
|
149 |
# SELECT Id, 2, PARENT_ID, COLLECTION_CODE, NOM_COLLECTION, DESCRIPTION,
|
193 |
# SELECT Id, 2, PARENT_ID, COLLECTION_CODE, NOM_COLLECTION, DESCRIPTION,
|
- |
|
194 |
# URL, INCLUDED_TYPE,
|
- |
|
195 |
count (distinct NUM_SPECIMENS),
|
150 |
# URL, INCLUDED_TYPE, @idm
|
196 |
# @idm := @idm+1
|
151 |
# FROM tb_herbiers.HERBIERS_COLLECTION
|
197 |
# FROM tb_herbiers.HERBIERS_COLLECTION
|
- |
|
198 |
# ORDER BY Id ASC;
|
152 |
# ORDER BY Id ASC;
|
199 |
#INSERT INTO tb_coel.coel_meta_historique_ligne
|
153 |
# INSERT INTO tb_coel.coel_meta_historique_ligne (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
200 |
# (cmhl_id_historique_ligne, cmhl_ce_table, cmhl_cle_ligne, cmhl_enregistrement,
|
- |
|
201 |
# cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
154 |
# cmhl_date_modification, cmhl_notes, cmhl_ce_modifier_par, cmhl_ce_etat ,cmhl_ip)
|
202 |
# SELECT @idm_tmp := @idm_tmp+1, '101', '2', NULL,
|
155 |
# VALUES (@idm := @idm+1, '101', '2', NULL , NOW( ) , 'Ajout d''une collection', '1', '1', '162.38.234.1');
|
- |
|
- |
|
203 |
# NOW( ) , CONCAT('Ajout de la collection #',Id,'de la table HERBIER_COLLECTION.') '1', '1', '162.38.234.1';
|
- |
|
204 |
# FROM tb.herbiers.HERBIERS_COLLECTION
|