|
From: | Oli Sennhauser |
Subject: | [Dolibarr-dev] Fix of 3-letter ISO code in table llx_c_pays |
Date: | Sat, 28 Jun 2014 15:51:04 +0200 |
User-agent: | Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 |
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'; |
[Prev in Thread] | Current Thread | [Next in Thread] |