| Line 68... |
Line 68... |
| 68 |
cs_condition_acces,
|
68 |
cs_condition_acces,
|
| 69 |
cs_ce_meta)
|
69 |
cs_ce_meta)
|
| 70 |
SELECT ID_ORG, '2', '0', CONCAT("URN:tela-botanica.org:ihf:str",ID_ORG) AS GUID, IF(INDEX_HERB != '', CONCAT('IH#',INDEX_HERB), NULL) AS IDENTIFIANT_ALTERNATIF,
|
70 |
SELECT ID_ORG, '2', '0', CONCAT("URN:tela-botanica.org:ihf:str",ID_ORG) AS GUID, IF(INDEX_HERB != '', CONCAT('IH#',INDEX_HERB), NULL) AS IDENTIFIANT_ALTERNATIF,
|
| 71 |
REPLACE(CONVERT(INSTITUTION_NAME USING utf8), '\r\n', ''), CONVERT(ADRESS_LINE USING utf8), ZIP, CONVERT(TOWN USING utf8), CONVERT(REGION USING utf8), IF(COUNTRY_CODE = 'fr', 'France', COUNTRY_CODE) AS PAYS, TEL, FAX, EMAIL,
|
71 |
REPLACE(CONVERT(INSTITUTION_NAME USING utf8), '\r\n', ''), CONVERT(ADRESS_LINE USING utf8), ZIP, CONVERT(TOWN USING utf8), CONVERT(REGION USING utf8), IF(COUNTRY_CODE = 'fr', 'France', COUNTRY_CODE) AS PAYS, TEL, FAX, EMAIL,
|
| 72 |
IF(SOURCE_DES_DONNEES != '', CONVERT(CONCAT("Source des données : ",SOURCE_DES_DONNEES) USING utf8), NULL) AS DESCRIPTION ,
|
72 |
IF(SOURCE_DES_DONNEES != '', CONVERT(CONCAT("Source des données : ",SOURCE_DES_DONNEES) USING utf8), NULL) AS DESCRIPTION ,
|
| 73 |
CONCAT(IF(HO_URL != 'http://', CONCAT('WEB#',HO_URL), ''),IF(HO_URL != 'http://' AND LOGO != '', ';', ''), IF(LOGO != '', CONCAT('LOGO#',LOGO),'')) AS URLS,
|
73 |
CONCAT(IF(HO_URL != 'http://' AND HO_URL != '', CONCAT('WEB#',HO_URL), ''),IF(HO_URL != 'http://' AND HO_URL != '' AND LOGO != '', ';', ''), IF(LOGO != '', CONCAT('LOGO#',LOGO),'')) AS URLS,
|
| 74 |
CONVERT(ACCESS_RESTRICTION USING utf8),
|
74 |
CONVERT(ACCESS_RESTRICTION USING utf8),
|
| 75 |
@idm := @idm+1
|
75 |
@idm := @idm+1
|
| 76 |
FROM tb_herbiers.HERBIERS_ORGANISATION
|
76 |
FROM tb_herbiers.HERBIERS_ORGANISATION
|
| 77 |
ORDER BY ID_ORG ASC;
|
77 |
ORDER BY ID_ORG ASC;
|
| 78 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|
78 |
INSERT INTO tb_coel.coel_meta_historique_ligne
|