Commit | Line | Data |
---|---|---|
6a488035 | 1 | -- +--------------------------------------------------------------------+ |
811982aa | 2 | -- | CiviCRM version 4.5 | |
6a488035 | 3 | -- +--------------------------------------------------------------------+ |
811982aa | 4 | -- | Copyright CiviCRM LLC (c) 2004-2014 | |
6a488035 TO |
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 | -- +--------------------------------------------------------------------+ | |
d5864876 ARW |
24 | -- |
25 | -- Generated from {$smarty.template} | |
26 | -- {$generated} | |
27 | -- | |
6a488035 TO |
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"), | |
f24ba3a6 | 81 | ( 52, "RSD", "Дин.","941", "Serbian Dinar"), |
6a488035 TO |
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"), | |
c09e8f20 | 144 | (116, "NAD", "N$", "516", "Namibian Dollar"), |
6a488035 TO |
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"), | |
f24ba3a6 | 191 | (163, "VEF", "Bs", "937", "Venezuela Bolivar"), |
6a488035 TO |
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"); | |
f24ba3a6 | 214 |