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 <oli.sennhau...@fromdual.com>: > 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 > Dolibarr-dev@nongnu.org > 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
_______________________________________________ Dolibarr-dev mailing list Dolibarr-dev@nongnu.org https://lists.nongnu.org/mailman/listinfo/dolibarr-dev
