X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Ffusionax%2FAdresses.sql;h=172e071813ad9f50e5a212f19c9f9f3ed791176a;hb=ed92ea696e042eb9b2d0efcc4731fdf89fb17924;hp=23af228de116b445cb6f470a4c5030cebef20096;hpb=950a769bb3f3154de64960ffc5cac111263bc8b0;p=platal.git diff --git a/modules/fusionax/Adresses.sql b/modules/fusionax/Adresses.sql index 23af228..172e071 100644 --- a/modules/fusionax/Adresses.sql +++ b/modules/fusionax/Adresses.sql @@ -39,7 +39,7 @@ SET `Date_maj` = CONCAT(SUBSTRING(@StringDate_maj,7),'-',SUBSTRING(@StringDate_maj,4,2),'-',SUBSTRING(@StringDate_maj,1,2)); LOAD DATA LOCAL INFILE 'Activites.txt' INTO TABLE `fusionax_adresses` FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r\n' -(provenance, id_ancien, @Code_etab, @Raison_sociale, @Libelle_fonctio, @Annuaire, +(provenance, id_ancien, @Code_etab, @Raison_sociale, @Libelle_fonctio, @Annuaire, Ligne1, Ligne2, Ligne3, code_postal, ville, zip_cedex, etat_distr, pays, tel, fax, @StringDate_maj) SET `Type_adr` = 'E',