-
Notifications
You must be signed in to change notification settings - Fork 0
/
isocurrency.sql
171 lines (168 loc) · 4.78 KB
/
isocurrency.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
/*
ISO 4217 Currency Codes
www.iso.org/iso/home/standards/currency_codes.htm
*/
CREATE TABLE currency (ccycode CHAR(3) NOT NULL PRIMARY KEY, ccyname VARCHAR(80) NOT NULL);
INSERT INTO currency (ccycode,ccyname)
VALUES
('AED', 'United Arab Emirates Dirham'),
('AFN', 'Afghanistan Afghani'),
('ALL', 'Albania Lek'),
('AMD', 'Armenia Dram'),
('ANG', 'Netherlands Antilles Guilder'),
('AOA', 'Angola Kwanza'),
('ARS', 'Argentina Peso'),
('AUD', 'Australia Dollar'),
('AWG', 'Aruba Guilder'),
('AZN', 'Azerbaijan New Manat'),
('BAM', 'Bosnia and Herzegovina Convertible Marka'),
('BBD', 'Barbados Dollar'),
('BDT', 'Bangladesh Taka'),
('BGN', 'Bulgaria Lev'),
('BHD', 'Bahrain Dinar'),
('BIF', 'Burundi Franc'),
('BMD', 'Bermuda Dollar'),
('BND', 'Brunei Darussalam Dollar'),
('BOB', 'Bolivia Bolíviano'),
('BRL', 'Brazil Real'),
('BSD', 'Bahamas Dollar'),
('BTN', 'Bhutan Ngultrum'),
('BWP', 'Botswana Pula'),
('BYR', 'Belarus Ruble'),
('BZD', 'Belize Dollar'),
('CAD', 'Canada Dollar'),
('CDF', 'Congo/Kinshasa Franc'),
('CHF', 'Switzerland Franc'),
('CLP', 'Chile Peso'),
('CNY', 'China Yuan Renminbi'),
('COP', 'Colombia Peso'),
('CRC', 'Costa Rica Colon'),
('CUC', 'Cuba Convertible Peso'),
('CUP', 'Cuba Peso'),
('CVE', 'Cape Verde Escudo'),
('CZK', 'Czech Republic Koruna'),
('DJF', 'Djibouti Franc'),
('DKK', 'Denmark Krone'),
('DOP', 'Dominican Republic Peso'),
('DZD', 'Algeria Dinar'),
('EGP', 'Egypt Pound'),
('ERN', 'Eritrea Nakfa'),
('ETB', 'Ethiopia Birr'),
('EUR', 'Euro Member Countries'),
('FJD', 'Fiji Dollar'),
('FKP', 'Falkland Islands (Malvinas) Pound'),
('GBP', 'United Kingdom Pound'),
('GEL', 'Georgia Lari'),
('GGP', 'Guernsey Pound'),
('GHS', 'Ghana Cedi'),
('GIP', 'Gibraltar Pound'),
('GMD', 'Gambia Dalasi'),
('GNF', 'Guinea Franc'),
('GTQ', 'Guatemala Quetzal'),
('GYD', 'Guyana Dollar'),
('HKD', 'Hong Kong Dollar'),
('HNL', 'Honduras Lempira'),
('HRK', 'Croatia Kuna'),
('HTG', 'Haiti Gourde'),
('HUF', 'Hungary Forint'),
('IDR', 'Indonesia Rupiah'),
('ILS', 'Israel Shekel'),
('IMP', 'Isle of Man Pound'),
('INR', 'India Rupee'),
('IQD', 'Iraq Dinar'),
('IRR', 'Iran Rial'),
('ISK', 'Iceland Krona'),
('JEP', 'Jersey Pound'),
('JMD', 'Jamaica Dollar'),
('JOD', 'Jordan Dinar'),
('JPY', 'Japan Yen'),
('KES', 'Kenya Shilling'),
('KGS', 'Kyrgyzstan Som'),
('KHR', 'Cambodia Riel'),
('KMF', 'Comoros Franc'),
('KPW', 'Korea (North) Won'),
('KRW', 'Korea (South) Won'),
('KWD', 'Kuwait Dinar'),
('KYD', 'Cayman Islands Dollar'),
('KZT', 'Kazakhstan Tenge'),
('LAK', 'Laos Kip'),
('LBP', 'Lebanon Pound'),
('LKR', 'Sri Lanka Rupee'),
('LRD', 'Liberia Dollar'),
('LSL', 'Lesotho Loti'),
('LYD', 'Libya Dinar'),
('MAD', 'Morocco Dirham'),
('MDL', 'Moldova Leu'),
('MGA', 'Madagascar Ariary'),
('MKD', 'Macedonia Denar'),
('MMK', 'Myanmar (Burma) Kyat'),
('MNT', 'Mongolia Tughrik'),
('MOP', 'Macau Pataca'),
('MRO', 'Mauritania Ouguiya'),
('MUR', 'Mauritius Rupee'),
('MVR', 'Maldives (Maldive Islands) Rufiyaa'),
('MWK', 'Malawi Kwacha'),
('MXN', 'Mexico Peso'),
('MYR', 'Malaysia Ringgit'),
('MZN', 'Mozambique Metical'),
('NAD', 'Namibia Dollar'),
('NGN', 'Nigeria Naira'),
('NIO', 'Nicaragua Cordoba'),
('NOK', 'Norway Krone'),
('NPR', 'Nepal Rupee'),
('NZD', 'New Zealand Dollar'),
('OMR', 'Oman Rial'),
('PAB', 'Panama Balboa'),
('PEN', 'Peru Sol'),
('PGK', 'Papua New Guinea Kina'),
('PHP', 'Philippines Peso'),
('PKR', 'Pakistan Rupee'),
('PLN', 'Poland Zloty'),
('PYG', 'Paraguay Guarani'),
('QAR', 'Qatar Riyal'),
('RON', 'Romania New Leu'),
('RSD', 'Serbia Dinar'),
('RUB', 'Russia Ruble'),
('RWF', 'Rwanda Franc'),
('SAR', 'Saudi Arabia Riyal'),
('SBD', 'Solomon Islands Dollar'),
('SCR', 'Seychelles Rupee'),
('SDG', 'Sudan Pound'),
('SEK', 'Sweden Krona'),
('SGD', 'Singapore Dollar'),
('SHP', 'Saint Helena Pound'),
('SLL', 'Sierra Leone Leone'),
('SOS', 'Somalia Shilling'),
('SRD', 'Suriname Dollar'),
('STD', 'São Tomé and Príncipe Dobra'),
('SVC', 'El Salvador Colon'),
('SYP', 'Syria Pound'),
('SZL', 'Swaziland Lilangeni'),
('THB', 'Thailand Baht'),
('TJS', 'Tajikistan Somoni'),
('TMT', 'Turkmenistan Manat'),
('TND', 'Tunisia Dinar'),
('TOP', 'Tonga Pa''anga'),
('TRY', 'Turkey Lira'),
('TTD', 'Trinidad and Tobago Dollar'),
('TVD', 'Tuvalu Dollar'),
('TWD', 'Taiwan New Dollar'),
('TZS', 'Tanzania Shilling'),
('UAH', 'Ukraine Hryvnia'),
('UGX', 'Uganda Shilling'),
('USD', 'United States Dollar'),
('UYU', 'Uruguay Peso'),
('UZS', 'Uzbekistan Som'),
('VEF', 'Venezuela Bolivar'),
('VND', 'Viet Nam Dong'),
('VUV', 'Vanuatu Vatu'),
('WST', 'Samoa Tala'),
('XAF', 'Communauté Financière Africaine (BEAC) CFA Franc BEAC'),
('XCD', 'East Caribbean Dollar'),
('XDR', 'International Monetary Fund (IMF) Special Drawing Rights'),
('XOF', 'Communauté Financière Africaine (BCEAO) Franc'),
('XPF', 'Comptoirs Français du Pacifique (CFP) Franc'),
('YER', 'Yemen Rial'),
('ZAR', 'South Africa Rand'),
('ZMW', 'Zambia Kwacha'),
('ZWD', 'Zimbabwe Dollar');