dolibarr-dev
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Dolibarr-dev] Fix of 3-letter ISO code in table llx_c_pays

From: Destailleur Laurent
Subject: Re: [Dolibarr-dev] Fix of 3-letter ISO code in table llx_c_pays
Date: Sat, 28 Jun 2014 21:42:26 +0200
I update file llx_c_00_pays.sql to include the update.
A better fix would be to modified directly the insert instead of doing insert then update into this file.


2014-06-28 15:51 GMT+02:00 Oli Sennhauser <address@hidden>:
How do we want to fix the 3-letter ISO codes in the table llx_c_pays?

For me the following job worked but I do not believe it is the right place...

Source: http://en.wikipedia.org/wiki/ISO_3166-1

UPDATE llx_c_pays SET code_iso = 'AFG' WHERE code = 'AF';
UPDATE llx_c_pays SET code_iso = 'ALA' WHERE code = 'AX';
UPDATE llx_c_pays SET code_iso = 'ALB' WHERE code = 'AL';
UPDATE llx_c_pays SET code_iso = 'DZA' WHERE code = 'DZ';
UPDATE llx_c_pays SET code_iso = 'ASM' WHERE code = 'AS';
UPDATE llx_c_pays SET code_iso = 'AND' WHERE code = 'AD';
UPDATE llx_c_pays SET code_iso = 'AGO' WHERE code = 'AO';
UPDATE llx_c_pays SET code_iso = 'AIA' WHERE code = 'AI';
UPDATE llx_c_pays SET code_iso = 'ATA' WHERE code = 'AQ';
UPDATE llx_c_pays SET code_iso = 'ATG' WHERE code = 'AG';
UPDATE llx_c_pays SET code_iso = 'ARG' WHERE code = 'AR';
UPDATE llx_c_pays SET code_iso = 'ARM' WHERE code = 'AM';
UPDATE llx_c_pays SET code_iso = 'ABW' WHERE code = 'AW';
UPDATE llx_c_pays SET code_iso = 'AUS' WHERE code = 'AU';
UPDATE llx_c_pays SET code_iso = 'AUT' WHERE code = 'AT';
UPDATE llx_c_pays SET code_iso = 'AZE' WHERE code = 'AZ';
UPDATE llx_c_pays SET code_iso = 'BHS' WHERE code = 'BS';
UPDATE llx_c_pays SET code_iso = 'BHR' WHERE code = 'BH';
UPDATE llx_c_pays SET code_iso = 'BGD' WHERE code = 'BD';
UPDATE llx_c_pays SET code_iso = 'BRB' WHERE code = 'BB';
UPDATE llx_c_pays SET code_iso = 'BLR' WHERE code = 'BY';
UPDATE llx_c_pays SET code_iso = 'BEL' WHERE code = 'BE';
UPDATE llx_c_pays SET code_iso = 'BLZ' WHERE code = 'BZ';
UPDATE llx_c_pays SET code_iso = 'BEN' WHERE code = 'BJ';
UPDATE llx_c_pays SET code_iso = 'BMU' WHERE code = 'BM';
UPDATE llx_c_pays SET code_iso = 'BTN' WHERE code = 'BT';
UPDATE llx_c_pays SET code_iso = 'BOL' WHERE code = 'BO';
UPDATE llx_c_pays SET code_iso = 'BES' WHERE code = 'BQ';
UPDATE llx_c_pays SET code_iso = 'BIH' WHERE code = 'BA';
UPDATE llx_c_pays SET code_iso = 'BWA' WHERE code = 'BW';
UPDATE llx_c_pays SET code_iso = 'BVT' WHERE code = 'BV';
UPDATE llx_c_pays SET code_iso = 'BRA' WHERE code = 'BR';
UPDATE llx_c_pays SET code_iso = 'IOT' WHERE code = 'IO';
UPDATE llx_c_pays SET code_iso = 'BRN' WHERE code = 'BN';
UPDATE llx_c_pays SET code_iso = 'BGR' WHERE code = 'BG';
UPDATE llx_c_pays SET code_iso = 'BFA' WHERE code = 'BF';
UPDATE llx_c_pays SET code_iso = 'BDI' WHERE code = 'BI';
UPDATE llx_c_pays SET code_iso = 'KHM' WHERE code = 'KH';
UPDATE llx_c_pays SET code_iso = 'CMR' WHERE code = 'CM';
UPDATE llx_c_pays SET code_iso = 'CAN' WHERE code = 'CA';
UPDATE llx_c_pays SET code_iso = 'CPV' WHERE code = 'CV';
UPDATE llx_c_pays SET code_iso = 'CYM' WHERE code = 'KY';
UPDATE llx_c_pays SET code_iso = 'CAF' WHERE code = 'CF';
UPDATE llx_c_pays SET code_iso = 'TCD' WHERE code = 'TD';
UPDATE llx_c_pays SET code_iso = 'CHL' WHERE code = 'CL';
UPDATE llx_c_pays SET code_iso = 'CHN' WHERE code = 'CN';
UPDATE llx_c_pays SET code_iso = 'CXR' WHERE code = 'CX';
UPDATE llx_c_pays SET code_iso = 'CCK' WHERE code = 'CC';
UPDATE llx_c_pays SET code_iso = 'COL' WHERE code = 'CO';
UPDATE llx_c_pays SET code_iso = 'COM' WHERE code = 'KM';
UPDATE llx_c_pays SET code_iso = 'COG' WHERE code = 'CG';
UPDATE llx_c_pays SET code_iso = 'COD' WHERE code = 'CD';
UPDATE llx_c_pays SET code_iso = 'COK' WHERE code = 'CK';
UPDATE llx_c_pays SET code_iso = 'CRI' WHERE code = 'CR';
UPDATE llx_c_pays SET code_iso = 'CIV' WHERE code = 'CI';
UPDATE llx_c_pays SET code_iso = 'HRV' WHERE code = 'HR';
UPDATE llx_c_pays SET code_iso = 'CUB' WHERE code = 'CU';
UPDATE llx_c_pays SET code_iso = 'CUW' WHERE code = 'CW';
UPDATE llx_c_pays SET code_iso = 'CYP' WHERE code = 'CY';
UPDATE llx_c_pays SET code_iso = 'CZE' WHERE code = 'CZ';
UPDATE llx_c_pays SET code_iso = 'DNK' WHERE code = 'DK';
UPDATE llx_c_pays SET code_iso = 'DJI' WHERE code = 'DJ';
UPDATE llx_c_pays SET code_iso = 'DMA' WHERE code = 'DM';
UPDATE llx_c_pays SET code_iso = 'DOM' WHERE code = 'DO';
UPDATE llx_c_pays SET code_iso = 'ECU' WHERE code = 'EC';
UPDATE llx_c_pays SET code_iso = 'EGY' WHERE code = 'EG';
UPDATE llx_c_pays SET code_iso = 'SLV' WHERE code = 'SV';
UPDATE llx_c_pays SET code_iso = 'GNQ' WHERE code = 'GQ';
UPDATE llx_c_pays SET code_iso = 'ERI' WHERE code = 'ER';
UPDATE llx_c_pays SET code_iso = 'EST' WHERE code = 'EE';
UPDATE llx_c_pays SET code_iso = 'ETH' WHERE code = 'ET';
UPDATE llx_c_pays SET code_iso = 'FLK' WHERE code = 'FK';
UPDATE llx_c_pays SET code_iso = 'FRO' WHERE code = 'FO';
UPDATE llx_c_pays SET code_iso = 'FJI' WHERE code = 'FJ';
UPDATE llx_c_pays SET code_iso = 'FIN' WHERE code = 'FI';
UPDATE llx_c_pays SET code_iso = 'FRA' WHERE code = 'FR';
UPDATE llx_c_pays SET code_iso = 'GUF' WHERE code = 'GF';
UPDATE llx_c_pays SET code_iso = 'PYF' WHERE code = 'PF';
UPDATE llx_c_pays SET code_iso = 'ATF' WHERE code = 'TF';
UPDATE llx_c_pays SET code_iso = 'GAB' WHERE code = 'GA';
UPDATE llx_c_pays SET code_iso = 'GMB' WHERE code = 'GM';
UPDATE llx_c_pays SET code_iso = 'GEO' WHERE code = 'GE';
UPDATE llx_c_pays SET code_iso = 'DEU' WHERE code = 'DE';
UPDATE llx_c_pays SET code_iso = 'GHA' WHERE code = 'GH';
UPDATE llx_c_pays SET code_iso = 'GIB' WHERE code = 'GI';
UPDATE llx_c_pays SET code_iso = 'GRC' WHERE code = 'GR';
UPDATE llx_c_pays SET code_iso = 'GRL' WHERE code = 'GL';
UPDATE llx_c_pays SET code_iso = 'GRD' WHERE code = 'GD';
UPDATE llx_c_pays SET code_iso = 'GLP' WHERE code = 'GP';
UPDATE llx_c_pays SET code_iso = 'GUM' WHERE code = 'GU';
UPDATE llx_c_pays SET code_iso = 'GTM' WHERE code = 'GT';
UPDATE llx_c_pays SET code_iso = 'GGY' WHERE code = 'GG';
UPDATE llx_c_pays SET code_iso = 'GIN' WHERE code = 'GN';
UPDATE llx_c_pays SET code_iso = 'GNB' WHERE code = 'GW';
UPDATE llx_c_pays SET code_iso = 'GUY' WHERE code = 'GY';
UPDATE llx_c_pays SET code_iso = 'HTI' WHERE code = 'HT';
UPDATE llx_c_pays SET code_iso = 'HMD' WHERE code = 'HM';
UPDATE llx_c_pays SET code_iso = 'VAT' WHERE code = 'VA';
UPDATE llx_c_pays SET code_iso = 'HND' WHERE code = 'HN';
UPDATE llx_c_pays SET code_iso = 'HKG' WHERE code = 'HK';
UPDATE llx_c_pays SET code_iso = 'HUN' WHERE code = 'HU';
UPDATE llx_c_pays SET code_iso = 'ISL' WHERE code = 'IS';
UPDATE llx_c_pays SET code_iso = 'IND' WHERE code = 'IN';
UPDATE llx_c_pays SET code_iso = 'IDN' WHERE code = 'ID';
UPDATE llx_c_pays SET code_iso = 'IRN' WHERE code = 'IR';
UPDATE llx_c_pays SET code_iso = 'IRQ' WHERE code = 'IQ';
UPDATE llx_c_pays SET code_iso = 'IRL' WHERE code = 'IE';
UPDATE llx_c_pays SET code_iso = 'IMN' WHERE code = 'IM';
UPDATE llx_c_pays SET code_iso = 'ISR' WHERE code = 'IL';
UPDATE llx_c_pays SET code_iso = 'ITA' WHERE code = 'IT';
UPDATE llx_c_pays SET code_iso = 'JAM' WHERE code = 'JM';
UPDATE llx_c_pays SET code_iso = 'JPN' WHERE code = 'JP';
UPDATE llx_c_pays SET code_iso = 'JEY' WHERE code = 'JE';
UPDATE llx_c_pays SET code_iso = 'JOR' WHERE code = 'JO';
UPDATE llx_c_pays SET code_iso = 'KAZ' WHERE code = 'KZ';
UPDATE llx_c_pays SET code_iso = 'KEN' WHERE code = 'KE';
UPDATE llx_c_pays SET code_iso = 'KIR' WHERE code = 'KI';
UPDATE llx_c_pays SET code_iso = 'PRK' WHERE code = 'KP';
UPDATE llx_c_pays SET code_iso = 'KOR' WHERE code = 'KR';
UPDATE llx_c_pays SET code_iso = 'KWT' WHERE code = 'KW';
UPDATE llx_c_pays SET code_iso = 'KGZ' WHERE code = 'KG';
UPDATE llx_c_pays SET code_iso = 'LAO' WHERE code = 'LA';
UPDATE llx_c_pays SET code_iso = 'LVA' WHERE code = 'LV';
UPDATE llx_c_pays SET code_iso = 'LBN' WHERE code = 'LB';
UPDATE llx_c_pays SET code_iso = 'LSO' WHERE code = 'LS';
UPDATE llx_c_pays SET code_iso = 'LBR' WHERE code = 'LR';
UPDATE llx_c_pays SET code_iso = 'LBY' WHERE code = 'LY';
UPDATE llx_c_pays SET code_iso = 'LIE' WHERE code = 'LI';
UPDATE llx_c_pays SET code_iso = 'LTU' WHERE code = 'LT';
UPDATE llx_c_pays SET code_iso = 'LUX' WHERE code = 'LU';
UPDATE llx_c_pays SET code_iso = 'MAC' WHERE code = 'MO';
UPDATE llx_c_pays SET code_iso = 'MKD' WHERE code = 'MK';
UPDATE llx_c_pays SET code_iso = 'MDG' WHERE code = 'MG';
UPDATE llx_c_pays SET code_iso = 'MWI' WHERE code = 'MW';
UPDATE llx_c_pays SET code_iso = 'MYS' WHERE code = 'MY';
UPDATE llx_c_pays SET code_iso = 'MDV' WHERE code = 'MV';
UPDATE llx_c_pays SET code_iso = 'MLI' WHERE code = 'ML';
UPDATE llx_c_pays SET code_iso = 'MLT' WHERE code = 'MT';
UPDATE llx_c_pays SET code_iso = 'MHL' WHERE code = 'MH';
UPDATE llx_c_pays SET code_iso = 'MTQ' WHERE code = 'MQ';
UPDATE llx_c_pays SET code_iso = 'MRT' WHERE code = 'MR';
UPDATE llx_c_pays SET code_iso = 'MUS' WHERE code = 'MU';
UPDATE llx_c_pays SET code_iso = 'MYT' WHERE code = 'YT';
UPDATE llx_c_pays SET code_iso = 'MEX' WHERE code = 'MX';
UPDATE llx_c_pays SET code_iso = 'FSM' WHERE code = 'FM';
UPDATE llx_c_pays SET code_iso = 'MDA' WHERE code = 'MD';
UPDATE llx_c_pays SET code_iso = 'MCO' WHERE code = 'MC';
UPDATE llx_c_pays SET code_iso = 'MNG' WHERE code = 'MN';
UPDATE llx_c_pays SET code_iso = 'MNE' WHERE code = 'ME';
UPDATE llx_c_pays SET code_iso = 'MSR' WHERE code = 'MS';
UPDATE llx_c_pays SET code_iso = 'MAR' WHERE code = 'MA';
UPDATE llx_c_pays SET code_iso = 'MOZ' WHERE code = 'MZ';
UPDATE llx_c_pays SET code_iso = 'MMR' WHERE code = 'MM';
UPDATE llx_c_pays SET code_iso = 'NAM' WHERE code = 'NA';
UPDATE llx_c_pays SET code_iso = 'NRU' WHERE code = 'NR';
UPDATE llx_c_pays SET code_iso = 'NPL' WHERE code = 'NP';
UPDATE llx_c_pays SET code_iso = 'NLD' WHERE code = 'NL';
UPDATE llx_c_pays SET code_iso = 'NCL' WHERE code = 'NC';
UPDATE llx_c_pays SET code_iso = 'NZL' WHERE code = 'NZ';
UPDATE llx_c_pays SET code_iso = 'NIC' WHERE code = 'NI';
UPDATE llx_c_pays SET code_iso = 'NER' WHERE code = 'NE';
UPDATE llx_c_pays SET code_iso = 'NGA' WHERE code = 'NG';
UPDATE llx_c_pays SET code_iso = 'NIU' WHERE code = 'NU';
UPDATE llx_c_pays SET code_iso = 'NFK' WHERE code = 'NF';
UPDATE llx_c_pays SET code_iso = 'MNP' WHERE code = 'MP';
UPDATE llx_c_pays SET code_iso = 'NOR' WHERE code = 'NO';
UPDATE llx_c_pays SET code_iso = 'OMN' WHERE code = 'OM';
UPDATE llx_c_pays SET code_iso = 'PAK' WHERE code = 'PK';
UPDATE llx_c_pays SET code_iso = 'PLW' WHERE code = 'PW';
UPDATE llx_c_pays SET code_iso = 'PSE' WHERE code = 'PS';
UPDATE llx_c_pays SET code_iso = 'PAN' WHERE code = 'PA';
UPDATE llx_c_pays SET code_iso = 'PNG' WHERE code = 'PG';
UPDATE llx_c_pays SET code_iso = 'PRY' WHERE code = 'PY';
UPDATE llx_c_pays SET code_iso = 'PER' WHERE code = 'PE';
UPDATE llx_c_pays SET code_iso = 'PHL' WHERE code = 'PH';
UPDATE llx_c_pays SET code_iso = 'PCN' WHERE code = 'PN';
UPDATE llx_c_pays SET code_iso = 'POL' WHERE code = 'PL';
UPDATE llx_c_pays SET code_iso = 'PRT' WHERE code = 'PT';
UPDATE llx_c_pays SET code_iso = 'PRI' WHERE code = 'PR';
UPDATE llx_c_pays SET code_iso = 'QAT' WHERE code = 'QA';
UPDATE llx_c_pays SET code_iso = 'REU' WHERE code = 'RE';
UPDATE llx_c_pays SET code_iso = 'ROU' WHERE code = 'RO';
UPDATE llx_c_pays SET code_iso = 'RUS' WHERE code = 'RU';
UPDATE llx_c_pays SET code_iso = 'RWA' WHERE code = 'RW';
UPDATE llx_c_pays SET code_iso = 'BLM' WHERE code = 'BL';
UPDATE llx_c_pays SET code_iso = 'SHN' WHERE code = 'SH';
UPDATE llx_c_pays SET code_iso = 'KNA' WHERE code = 'KN';
UPDATE llx_c_pays SET code_iso = 'LCA' WHERE code = 'LC';
UPDATE llx_c_pays SET code_iso = 'MAF' WHERE code = 'MF';
UPDATE llx_c_pays SET code_iso = 'SPM' WHERE code = 'PM';
UPDATE llx_c_pays SET code_iso = 'VCT' WHERE code = 'VC';
UPDATE llx_c_pays SET code_iso = 'WSM' WHERE code = 'WS';
UPDATE llx_c_pays SET code_iso = 'SMR' WHERE code = 'SM';
UPDATE llx_c_pays SET code_iso = 'STP' WHERE code = 'ST';
UPDATE llx_c_pays SET code_iso = 'SAU' WHERE code = 'SA';
UPDATE llx_c_pays SET code_iso = 'SEN' WHERE code = 'SN';
UPDATE llx_c_pays SET code_iso = 'SRB' WHERE code = 'RS';
UPDATE llx_c_pays SET code_iso = 'SYC' WHERE code = 'SC';
UPDATE llx_c_pays SET code_iso = 'SLE' WHERE code = 'SL';
UPDATE llx_c_pays SET code_iso = 'SGP' WHERE code = 'SG';
UPDATE llx_c_pays SET code_iso = 'SXM' WHERE code = 'SX';
UPDATE llx_c_pays SET code_iso = 'SVK' WHERE code = 'SK';
UPDATE llx_c_pays SET code_iso = 'SVN' WHERE code = 'SI';
UPDATE llx_c_pays SET code_iso = 'SLB' WHERE code = 'SB';
UPDATE llx_c_pays SET code_iso = 'SOM' WHERE code = 'SO';
UPDATE llx_c_pays SET code_iso = 'ZAF' WHERE code = 'ZA';
UPDATE llx_c_pays SET code_iso = 'SGS' WHERE code = 'GS';
UPDATE llx_c_pays SET code_iso = 'SSD' WHERE code = 'SS';
UPDATE llx_c_pays SET code_iso = 'ESP' WHERE code = 'ES';
UPDATE llx_c_pays SET code_iso = 'LKA' WHERE code = 'LK';
UPDATE llx_c_pays SET code_iso = 'SDN' WHERE code = 'SD';
UPDATE llx_c_pays SET code_iso = 'SUR' WHERE code = 'SR';
UPDATE llx_c_pays SET code_iso = 'SJM' WHERE code = 'SJ';
UPDATE llx_c_pays SET code_iso = 'SWZ' WHERE code = 'SZ';
UPDATE llx_c_pays SET code_iso = 'SWE' WHERE code = 'SE';
UPDATE llx_c_pays SET code_iso = 'CHE' WHERE code = 'CH';
UPDATE llx_c_pays SET code_iso = 'SYR' WHERE code = 'SY';
UPDATE llx_c_pays SET code_iso = 'TWN' WHERE code = 'TW';
UPDATE llx_c_pays SET code_iso = 'TJK' WHERE code = 'TJ';
UPDATE llx_c_pays SET code_iso = 'TZA' WHERE code = 'TZ';
UPDATE llx_c_pays SET code_iso = 'THA' WHERE code = 'TH';
UPDATE llx_c_pays SET code_iso = 'TLS' WHERE code = 'TL';
UPDATE llx_c_pays SET code_iso = 'TGO' WHERE code = 'TG';
UPDATE llx_c_pays SET code_iso = 'TKL' WHERE code = 'TK';
UPDATE llx_c_pays SET code_iso = 'TON' WHERE code = 'TO';
UPDATE llx_c_pays SET code_iso = 'TTO' WHERE code = 'TT';
UPDATE llx_c_pays SET code_iso = 'TUN' WHERE code = 'TN';
UPDATE llx_c_pays SET code_iso = 'TUR' WHERE code = 'TR';
UPDATE llx_c_pays SET code_iso = 'TKM' WHERE code = 'TM';
UPDATE llx_c_pays SET code_iso = 'TCA' WHERE code = 'TC';
UPDATE llx_c_pays SET code_iso = 'TUV' WHERE code = 'TV';
UPDATE llx_c_pays SET code_iso = 'UGA' WHERE code = 'UG';
UPDATE llx_c_pays SET code_iso = 'UKR' WHERE code = 'UA';
UPDATE llx_c_pays SET code_iso = 'ARE' WHERE code = 'AE';
UPDATE llx_c_pays SET code_iso = 'GBR' WHERE code = 'GB';
UPDATE llx_c_pays SET code_iso = 'USA' WHERE code = 'US';
UPDATE llx_c_pays SET code_iso = 'UMI' WHERE code = 'UM';
UPDATE llx_c_pays SET code_iso = 'URY' WHERE code = 'UY';
UPDATE llx_c_pays SET code_iso = 'UZB' WHERE code = 'UZ';
UPDATE llx_c_pays SET code_iso = 'VUT' WHERE code = 'VU';
UPDATE llx_c_pays SET code_iso = 'VEN' WHERE code = 'VE';
UPDATE llx_c_pays SET code_iso = 'VNM' WHERE code = 'VN';
UPDATE llx_c_pays SET code_iso = 'VGB' WHERE code = 'VG';
UPDATE llx_c_pays SET code_iso = 'VIR' WHERE code = 'VI';
UPDATE llx_c_pays SET code_iso = 'WLF' WHERE code = 'WF';
UPDATE llx_c_pays SET code_iso = 'ESH' WHERE code = 'EH';
UPDATE llx_c_pays SET code_iso = 'YEM' WHERE code = 'YE';
UPDATE llx_c_pays SET code_iso = 'ZMB' WHERE code = 'ZM';
UPDATE llx_c_pays SET code_iso = 'ZWE' WHERE code = 'ZW';


_______________________________________________
Dolibarr-dev mailing list
address@hidden
https://lists.nongnu.org/mailman/listinfo/dolibarr-dev




--
Laurent Destailleur (alias Eldy)
------------------------------------------------------------------------------------
Social networks of my OpenSource projects:
Dolibarr Google+: https://plus.google.com/+DolibarrOrg/
Dolibarr Facebook: https://www.facebook.com/dolibarr
Dolibarr Twitter: http://www.twitter.com/dolibarr
AWStats Google+: https://plus.google.com/+AWStatsOrgPoject/
AWStats Facebook: https://www.facebook.com/awstats.org
AWStats Twitter: http://www.twitter.com/awstats_project

reply via email to
[Prev in Thread] Current Thread [Next in Thread]