| 1 | -- +--------------------------------------------------------------------+ |
| 2 | -- | CiviCRM version 5 | |
| 3 | -- +--------------------------------------------------------------------+ |
| 4 | -- | Copyright CiviCRM LLC (c) 2004-2019 | |
| 5 | -- +--------------------------------------------------------------------+ |
| 6 | -- | This file is a part of CiviCRM. | |
| 7 | -- | | |
| 8 | -- | CiviCRM is free software; you can copy, modify, and distribute it | |
| 9 | -- | under the terms of the GNU Affero General Public License | |
| 10 | -- | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. | |
| 11 | -- | | |
| 12 | -- | CiviCRM is distributed in the hope that it will be useful, but | |
| 13 | -- | WITHOUT ANY WARRANTY; without even the implied warranty of | |
| 14 | -- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. | |
| 15 | -- | See the GNU Affero General Public License for more details. | |
| 16 | -- | | |
| 17 | -- | You should have received a copy of the GNU Affero General Public | |
| 18 | -- | License and the CiviCRM Licensing Exception along | |
| 19 | -- | with this program; if not, contact CiviCRM LLC | |
| 20 | -- | at info[AT]civicrm[DOT]org. If you have questions about the | |
| 21 | -- | GNU Affero General Public License or the licensing of CiviCRM, | |
| 22 | -- | see the CiviCRM license FAQ at http://civicrm.org/licensing | |
| 23 | -- +--------------------------------------------------------------------+ |
| 24 | -- |
| 25 | -- Generated from {$smarty.template} |
| 26 | -- {$generated} |
| 27 | -- |
| 28 | -- currencies |
| 29 | INSERT INTO civicrm_currency (id, name, symbol, numeric_code, full_name) VALUES |
| 30 | ( 1, "AUD", "$", "036", "Australian Dollar"), |
| 31 | ( 2, "CAD", "$", "124", "Canadian Dollar"), |
| 32 | ( 3, "EUR", "€", "978", "Euro"), |
| 33 | ( 4, "GBP", "£", "826", "Pound Sterling"), |
| 34 | ( 5, "ILS", "₪", "826", "New Israeli Shekel"), |
| 35 | ( 6, "INR", "₨", "356", "Indian Rupee"), |
| 36 | ( 7, "JPY", "¥", "392", "Japanese Yen"), |
| 37 | ( 8, "KRW", "₩", "410", "South Korean Won"), |
| 38 | ( 9, "LAK", "₭", "418", "Lao Kip"), |
| 39 | ( 10, "MNT", "₮", "496", "Mongolian Tugrik"), |
| 40 | ( 11, "NGN", "₦", "566", "Nigerian Naira"), |
| 41 | ( 12, "PLN", "zł", "985", "Polish Złoty"), |
| 42 | ( 13, "THB", "฿", "764", "Thai Baht"), |
| 43 | ( 14, "USD", "$", "840", "US Dollar"), |
| 44 | ( 15, "VND", "₫", "704", "Viet Nam Dong"), |
| 45 | ( 16, "ZAR", "R", "710", "South African Rand"), |
| 46 | ( 17, "AED", NULL, "784", "UAE Dirham"), |
| 47 | ( 18, "AFN", "؋", "971", "Afghani"), |
| 48 | ( 19, "ALL","Lek", "008", "Albanian Lek"), |
| 49 | ( 20, "AMD", NULL, "051", "Armenian Dram"), |
| 50 | ( 21, "ANG", "ƒ", "532", "Netherlands Antillian Guilder"), |
| 51 | ( 22, "AOA", NULL, "973", "Angola Kwanza"), |
| 52 | ( 23, "ARS", "$", "032", "Argentine Peso"), |
| 53 | ( 24, "AWG", "ƒ", "533", "Aruban Guilder"), |
| 54 | ( 25, "AZN","ман", "944", "Azerbaijanian Manat"), |
| 55 | ( 26, "BAM", "KM", "977", "Convertible Marks"), |
| 56 | ( 27, "BBD", "$", "052", "Barbados Dollar"), |
| 57 | ( 28, "BDT", NULL, "050", "Bangladeshi Taka"), |
| 58 | ( 29, "BGN", "лв", "975", "Bulgarian Lev"), |
| 59 | ( 30, "BHD", NULL, "048", "Bahraini Dinar"), |
| 60 | ( 31, "BIF", NULL, "108", "Burundi Franc"), |
| 61 | ( 32, "BMD", "$", "060", "Bermudian Dollar"), |
| 62 | ( 33, "BND", "$", "096", "Brunei Dollar"), |
| 63 | ( 34, "BOB", "$b", "068", "Boliviano"), |
| 64 | ( 35, "BOV", NULL, "984", "Bolivian Mvdol"), |
| 65 | ( 36, "BRL", "R$", "986", "Brazilian Real"), |
| 66 | ( 37, "BSD", "$", "044", "Bahamian Dollar"), |
| 67 | ( 38, "BTN", NULL, "064", "Bhutan Ngultrum"), |
| 68 | ( 39, "BWP", "P", "072", "Botswana Pula"), |
| 69 | ( 40, "BYR", "p.", "974", "Belarussian Rouble"), |
| 70 | ( 41, "BZD","BZ$", "084", "Belize Dollar"), |
| 71 | ( 42, "CDF", NULL, "976", "Franc Congolais"), |
| 72 | ( 43, "CHE", NULL, "947", "WIR Euro"), |
| 73 | ( 44, "CHF","CHF", "756", "Swiss Franc"), |
| 74 | ( 45, "CHW", NULL, "948", "WIR Franc"), |
| 75 | ( 46, "CLF", NULL, "990", "Unidades de fomento"), |
| 76 | ( 47, "CLP", "$", "152", "Chilean Peso"), |
| 77 | ( 48, "CNY", "元", "156", "Chinese Yuan Renminbi"), |
| 78 | ( 49, "COP", "$", "170", "Colombian Peso"), |
| 79 | ( 50, "COU", NULL, "970", "Unidad de Valor Real"), |
| 80 | ( 51, "CRC", "₡", "188", "Costa Rican Colon"), |
| 81 | ( 52, "RSD", "Дин.","941", "Serbian Dinar"), |
| 82 | ( 53, "CUP", "₱", "192", "Cuban Peso"), |
| 83 | ( 54, "CVE", NULL, "132", "Cape Verde Escudo"), |
| 84 | ( 55, "CYP", "£", "196", "Cyprus Pound"), |
| 85 | ( 56, "CZK", "Kč", "203", "Czech Koruna"), |
| 86 | ( 57, "DJF", NULL, "262", "Djibouti Franc"), |
| 87 | ( 58, "DKK", "kr", "208", "Danish Krone"), |
| 88 | ( 59, "DOP","RD$", "214", "Dominican Peso"), |
| 89 | ( 60, "DZD", NULL, "012", "Algerian Dinar"), |
| 90 | ( 62, "EGP", "£", "818", "Egyptian Pound"), |
| 91 | ( 63, "ERN", NULL, "232", "Eritrean Nakfa"), |
| 92 | ( 64, "ETB", NULL, "230", "Ethiopian Birr"), |
| 93 | ( 65, "FJD", "$", "242", "Fiji Dollar"), |
| 94 | ( 66, "FKP", "£", "238", "Falkland Islands Pound"), |
| 95 | ( 67, "GEL", NULL, "981", "Georgian Lari"), |
| 96 | ( 68, "GHC", "¢", "288", "Ghanaian Cedi"), |
| 97 | ( 69, "GIP", "£", "292", "Gibraltar Pound"), |
| 98 | ( 70, "GMD", NULL, "270", "Gambian Dalasi"), |
| 99 | ( 71, "GNF", NULL, "324", "Guinea Franc"), |
| 100 | ( 72, "GTQ", "Q", "320", "Guatemalan Quetzal"), |
| 101 | ( 73, "GWP", NULL, "624", "Guinea-Bissau Peso"), |
| 102 | ( 74, "GYD", "$", "328", "Guyana Dollar"), |
| 103 | ( 75, "HKD","HK$", "344", "Hong Kong Dollar"), |
| 104 | ( 76, "HNL", "L", "340", "Honduran Lempira"), |
| 105 | ( 77, "HRK", "kn", "191", "Croatian Kuna"), |
| 106 | ( 78, "HTG", NULL, "332", "Haitian Gourde"), |
| 107 | ( 79, "HUF", "Ft", "348", "Hungarian Forint"), |
| 108 | ( 80, "IDR", "Rp", "360", "Indonesian Rupiah"), |
| 109 | ( 81, "IQD", NULL, "368", "Iraqi Dinar"), |
| 110 | ( 82, "IRR", "﷼", "364", "Iranian Rial"), |
| 111 | ( 83, "ISK", "kr", "352", "Iceland Krona"), |
| 112 | ( 84, "JMD", "J$", "388", "Jamaican Dollar"), |
| 113 | ( 85, "JOD", NULL, "400", "Jordanian Dinar"), |
| 114 | ( 86, "KES", NULL, "404", "Kenyan Shilling"), |
| 115 | ( 87, "KGS", "лв", "417", "Kyrgyzstan Som"), |
| 116 | ( 88, "KHR", "៛", "116", "Cambodian Riel"), |
| 117 | ( 89, "KMF", NULL, "174", "Comoro Franc"), |
| 118 | ( 90, "KPW", "₩", "408", "North Korean Won"), |
| 119 | ( 91, "KWD", NULL, "414", "Kuwaiti Dinar"), |
| 120 | ( 92, "KYD", "$", "136", "Cayman Islands Dollar"), |
| 121 | ( 93, "KZT", "лв", "398", "Kazakhstan Tenge"), |
| 122 | ( 94, "LBP", "£", "422", "Lebanese Pound"), |
| 123 | ( 95, "LKR", "₨", "144", "Sri Lanka Rupee"), |
| 124 | ( 96, "LRD", "$", "430", "Liberian Dollar"), |
| 125 | ( 97, "LSL", NULL, "426", "Lesotho Loti"), |
| 126 | ( 98, "LTL", "Lt", "440", "Lithuanian Litas"), |
| 127 | ( 99, "LVL", "Ls", "428", "Latvian Lats"), |
| 128 | (100, "LYD", NULL, "434", "Libyan Dinar"), |
| 129 | (101, "MAD", NULL, "504", "Moroccan Dirham"), |
| 130 | (102, "MDL", NULL, "498", "Moldovan Leu"), |
| 131 | (103, "MGA", NULL, "969", "Malagascy Ariary"), |
| 132 | (104, "MKD","ден", "807", "Macedonian Denar"), |
| 133 | (105, "MMK", NULL, "104", "Myanmar Kyat"), |
| 134 | (106, "MOP", NULL, "446", "Macao Pataca"), |
| 135 | (107, "MRO", NULL, "478", "Mauritanian Ouguiya"), |
| 136 | (108, "MTL", "Lm", "470", "Maltese Lira"), |
| 137 | (109, "MUR", "₨", "480", "Mauritius Rupee"), |
| 138 | (110, "MVR", NULL, "462", "Maldive Rufiyaa"), |
| 139 | (111, "MWK", NULL, "454", "Malawi Kwacha"), |
| 140 | (112, "MXN", "$", "484", "Mexican Peso"), |
| 141 | (113, "MXV", NULL, "979", "Mexican Unidad de Inversion (UID)"), |
| 142 | (114, "MYR", "RM", "458", "Malaysian Ringgit"), |
| 143 | (115, "MZN", "MT", "943", "Mozambique Metical"), |
| 144 | (116, "NAD", "N$", "516", "Namibian Dollar"), |
| 145 | (117, "NIO", "C$", "558", "Nicaraguan Cordoba Oro"), |
| 146 | (118, "NOK", "kr", "578", "Norwegian Krone"), |
| 147 | (119, "NPR", "₨", "524", "Nepalese Rupee"), |
| 148 | (120, "NZD", "$", "554", "New Zealand Dollar"), |
| 149 | (121, "OMR", "﷼", "512", "Rial Omani"), |
| 150 | (122, "PAB","B/.", "590", "Panamanian Balboa"), |
| 151 | (123, "PEN","S/.", "604", "Peruvian Nuevo Sol"), |
| 152 | (124, "PGK", NULL, "598", "Papua New Guinea Kina"), |
| 153 | (125, "PHP","Php", "608", "Philippine Peso"), |
| 154 | (126, "PKR", "₨", "586", "Pakistan Rupee"), |
| 155 | (127, "PYG", "Gs", "600", "Paraguay Guarani"), |
| 156 | (128, "QAR", "﷼", "634", "Qatari Rial"), |
| 157 | (129, "ROL", NULL, "642", "Romanian Old Leu"), |
| 158 | (130, "RON","lei", "946", "Romanian New Leu"), |
| 159 | (131, "RUB","руб", "643", "Russian Rouble"), |
| 160 | (132, "RWF", NULL, "646", "Rwanda Franc"), |
| 161 | (133, "SAR", "﷼", "682", "Saudi Riyal"), |
| 162 | (134, "SBD", "$", "090", "Solomon Islands Dollar"), |
| 163 | (135, "SCR", "₨", "690", "Seychelles Rupee"), |
| 164 | (136, "SDD", NULL, "736", "Sudanese Dinar"), |
| 165 | (137, "SEK", "kr", "752", "Swedish Krona"), |
| 166 | (138, "SGD", "$", "702", "Singapore Dollar"), |
| 167 | (139, "SHP", "£", "654", "Saint Helena Pound"), |
| 168 | (140, "SIT", NULL, "705", "Slovenian Tolar"), |
| 169 | (141, "SKK","SIT", "703", "Slovak Koruna"), |
| 170 | (142, "SLL", NULL, "694", "Leone"), |
| 171 | (143, "SOS", "S", "706", "Somali Shilling"), |
| 172 | (144, "SRD", "$", "968", "Surinam Dollar"), |
| 173 | (145, "STD", NULL, "678", "São Tome and Principe Dobra"), |
| 174 | (146, "SVC", "$", "222", "El Salvador Colon"), |
| 175 | (147, "SYP", "£", "760", "Syrian Pound"), |
| 176 | (148, "SZL", NULL, "748", "Swaziland Lilangeni"), |
| 177 | (149, "TJS", NULL, "972", "Tajik Somoni"), |
| 178 | (150, "TMM", NULL, "795", "Turkmenistan Manat"), |
| 179 | (151, "TND", NULL, "788", "Tunisian Dinar"), |
| 180 | (152, "TOP", NULL, "776", "Tongan Pa'anga"), |
| 181 | (153, "TRY","YTL", "949", "New Turkish Lira"), |
| 182 | (154, "TTD","TT$", "780", "Trinidad and Tobago Dollar"), |
| 183 | (155, "TWD","NT$", "901", "New Taiwan Dollar"), |
| 184 | (156, "TZS", NULL, "834", "Tanzanian Shilling"), |
| 185 | (157, "UAH", "₴", "980", "Ukrainian Hryvnia"), |
| 186 | (158, "UGX", NULL, "800", "Ugandan Shilling"), |
| 187 | (159, "USN", NULL, "997", "US Dollar (Next day)"), |
| 188 | (160, "USS", NULL, "998", "US Dollar (Same day)"), |
| 189 | (161, "UYU", "$U", "858", "Peso Uruguayo"), |
| 190 | (162, "UZS", "лв", "860", "Uzbekistan Sum"), |
| 191 | (163, "VEF", "Bs", "937", "Venezuela Bolivar"), |
| 192 | (164, "VUV", NULL, "548", "Vanuatu Vatu"), |
| 193 | (165, "WST", NULL, "882", "Samoan Tala"), |
| 194 | (166, "XAF", NULL, "950", "CFA Franc BEAC"), |
| 195 | (167, "XAG", NULL, "961", "Silver"), |
| 196 | (168, "XAU", NULL, "959", "Gold"), |
| 197 | (169, "XBA", NULL, "955", "Bond Markets Units European Composite Unit (EURCO)"), |
| 198 | (170, "XBB", NULL, "956", "European Monetary Unit (E.M.U.-6)"), |
| 199 | (171, "XBC", NULL, "957", "European Unit of Account 9 (E.U.A.-9)"), |
| 200 | (172, "XBD", NULL, "958", "European Unit of Account 17 (E.U.A.-17)"), |
| 201 | (173, "XCD", "$", "951", "East Caribbean Dollar"), |
| 202 | (174, "XDR", NULL, "960", "Special Drawing Right"), |
| 203 | (175, "XFO", NULL, NULL, "Gold-Franc"), |
| 204 | (176, "XFU", NULL, NULL, "UIC-Franc"), |
| 205 | (177, "XOF", NULL, "952", "CFA Franc BCEAO"), |
| 206 | (178, "XPD", NULL, "964", "Palladium"), |
| 207 | (179, "XPF", NULL, "953", "CFP Franc"), |
| 208 | (180, "XPT", NULL, "962", "Platinum"), |
| 209 | (181, "XTS", NULL, "963", "Code for testing purposes"), |
| 210 | (182, "XXX", NULL, "999", "No currency involved"), |
| 211 | (183, "YER", "﷼", "886", "Yemeni Rial"), |
| 212 | (184, "ZMK", NULL, "894", "Zambian Kwacha"), |
| 213 | (185, "ZWD", "Z$", "716", "Zimbabwe Dollar"); |