forked from ccmars/world-data
-
Notifications
You must be signed in to change notification settings - Fork 0
/
world_currencies.sql
177 lines (174 loc) · 9.48 KB
/
world_currencies.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
172
173
174
175
176
177
-- World Currencies (ISO 4217)
-- SQL Table | v2.0.1 (2022)
-- https://github.com/ccmars/world-data
DROP TABLE IF EXISTS `world_currencies`;
CREATE TABLE `world_currencies` (
`number` smallint(3) NOT NULL,
`alpha3` varchar(3) NOT NULL,
`decimals` tinyint(1) NOT NULL DEFAULT '2',
`langEN` varchar(39) NOT NULL,
`symbol_decimal` varchar(24) DEFAULT NULL,
`symbol_hex` varchar(24) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='World Currencies (ISO 4217)';
INSERT INTO `world_currencies` (`number`, `alpha3`, `decimals`, `langEN`, `symbol_decimal`, `symbol_hex`) VALUES
(784, 'AED', 2, 'United Arab Emirates dirham', '1583;46;1573', '062F;002E;0625'),
(971, 'AFN', 2, 'Afghan afghani', '1547', '060B'),
(8, 'ALL', 2, 'Albanian lek', '76;101;107', '004C;0065;006B'),
(51, 'AMD', 2, 'Armenian dram', NULL, NULL),
(532, 'ANG', 2, 'Netherlands Antillean guilder', '402', '0192'),
(973, 'AOA', 2, 'Angolan kwanza', '75;122', '004B;007A'),
(32, 'ARS', 2, 'Argentine peso', '36', '0024'),
(36, 'AUD', 2, 'Australian dollar', '36', '0024'),
(533, 'AWG', 2, 'Aruban florin', '402', '0192'),
(944, 'AZN', 2, 'Azerbaijani manat', '1084;1072;1085', '043C;0430;043D'),
(977, 'BAM', 2, 'Bosnia and Herzegovina convertible mark', '75;77', '004B;004D'),
(52, 'BBD', 2, 'Barbados dollar', '36', '0024'),
(50, 'BDT', 2, 'Bangladeshi taka', '2547', '09F3'),
(975, 'BGN', 2, 'Bulgarian lev', '1083;1074', '043B;0432'),
(48, 'BHD', 3, 'Bahraini dinar', '46;1583;46;1576', '002E;062F;002E;0628'),
(108, 'BIF', 0, 'Burundian franc', '70;66;117', '0046;0042;0075'),
(60, 'BMD', 2, 'Bermudian dollar', '36', '0024'),
(96, 'BND', 2, 'Brunei dollar', '36', '0024'),
(68, 'BOB', 2, 'Boliviano', '36;98', '0024;0062'),
(986, 'BRL', 2, 'Brazilian real', '82;36', '0052;0024'),
(44, 'BSD', 2, 'Bahamian dollar', '36', '0024'),
(64, 'BTN', 2, 'Bhutanese ngultrum', '78;117', '004E;0075'),
(72, 'BWP', 2, 'Botswana pula', '80', '0050'),
(933, 'BYN', 0, 'Belarusian ruble', '112;46', '0070;002E'),
(84, 'BZD', 2, 'Belize dollar', '66;90;36', '0042;005A;0024'),
(124, 'CAD', 2, 'Canadian dollar', '36', '0024'),
(976, 'CDF', 2, 'Congolese franc', '70;67', '0046;0043'),
(756, 'CHF', 2, 'Swiss franc', '67;72;70', '0043;0048;0046'),
(152, 'CLP', 0, 'Chilean peso', '36', '0024'),
(156, 'CNY', 2, 'Chinese yuan', '165', '00A5'),
(170, 'COP', 2, 'Colombian peso', '36', '0024'),
(188, 'CRC', 2, 'Costa Rican colon', '8353', '20A1'),
(931, 'CUC', 2, 'Cuban convertible peso', '36', '0024'),
(192, 'CUP', 2, 'Cuban peso', '8369', '20B1'),
(132, 'CVE', 0, 'Cape Verdean escudo', '36', '0024'),
(203, 'CZK', 2, 'Czech koruna', '75;269', '004B;010D'),
(262, 'DJF', 0, 'Djiboutian franc', '70;100;106', '0046;0064;006A'),
(208, 'DKK', 2, 'Danish krone', '107;114', '006B;0072'),
(214, 'DOP', 2, 'Dominican peso', '82;68;36', '0052;0044;0024'),
(12, 'DZD', 2, 'Algerian dinar', '1583;1580', '062F;062C'),
(818, 'EGP', 2, 'Egyptian pound', '163', '00A3'),
(232, 'ERN', 2, 'Eritrean nakfa', '1606;1575;1601;1603;1575', '0646;0627;0641;0643;0627'),
(230, 'ETB', 2, 'Ethiopian birr', '4709;4653', '1265;122D'),
(978, 'EUR', 2, 'Euro', '8364', '20AC'),
(242, 'FJD', 2, 'Fiji dollar', '36', '0024'),
(238, 'FKP', 2, 'Falkland Islands pound', '163', '00A3'),
(826, 'GBP', 2, 'Pound sterling', '163', '00A3'),
(981, 'GEL', 2, 'Georgian lari', '8382', '20BE'),
(936, 'GHS', 2, 'Ghanaian cedi', '162', '00A2'),
(292, 'GIP', 2, 'Gibraltar pound', '163', '00A3'),
(270, 'GMD', 2, 'Gambian dalasi', '68', '0044'),
(324, 'GNF', 0, 'Guinean franc', '70;71', '0046;0047'),
(320, 'GTQ', 2, 'Guatemalan quetzal', '81', '0051'),
(328, 'GYD', 2, 'Guyanese dollar', '36', '0024'),
(344, 'HKD', 2, 'Hong Kong dollar', '36', '0024'),
(340, 'HNL', 2, 'Honduran lempira', '76', '004C'),
(191, 'HRK', 2, 'Croatian kuna', '107;110', '006B;006E'),
(332, 'HTG', 2, 'Haitian gourde', '71', '0047'),
(348, 'HUF', 2, 'Hungarian forint', '70;116', '0046;0074'),
(360, 'IDR', 2, 'Indonesian rupiah', '82;112', '0052;0070'),
(376, 'ILS', 2, 'Israeli new shekel', '8362', '20AA'),
(356, 'INR', 2, 'Indian rupee', '8377', '20B9'),
(368, 'IQD', 3, 'Iraqi dinar', '1593;46;1583', '0639;002E;062F'),
(364, 'IRR', 2, 'Iranian rial', '65020', 'FDFC'),
(352, 'ISK', 0, 'Icelandic króna', '107;114', '006B;0072'),
(388, 'JMD', 2, 'Jamaican dollar', '74;36', '004A;0024'),
(400, 'JOD', 3, 'Jordanian dinar', '1583;1610;1606;1575;1585', '062F;064A;0646;0627;0631'),
(392, 'JPY', 0, 'Japanese yen', '165', '00A5'),
(404, 'KES', 2, 'Kenyan shilling', '75;83;104', '004B;0053;0068'),
(417, 'KGS', 2, 'Kyrgyzstani som', '1083;1074', '043B;0432'),
(116, 'KHR', 2, 'Cambodian riel', '6107', '17DB'),
(174, 'KMF', 0, 'Comoro franc', '67;70', '0043;0046'),
(408, 'KPW', 2, 'North Korean won', '8361', '20A9'),
(410, 'KRW', 0, 'South Korean won', '8361', '20A9'),
(414, 'KWD', 3, 'Kuwaiti dinar', '1583;46;1603', '062F;002E;0643'),
(136, 'KYD', 2, 'Cayman Islands dollar', '36', '0024'),
(398, 'KZT', 2, 'Kazakhstani tenge', '1083;1074', '043B;0432'),
(418, 'LAK', 2, 'Lao kip', '8365', '20AD'),
(422, 'LBP', 2, 'Lebanese pound', '163', '00A3'),
(144, 'LKR', 2, 'Sri Lankan rupee', '8360', '20A8'),
(430, 'LRD', 2, 'Liberian dollar', '36', '0024'),
(426, 'LSL', 2, 'Lesotho loti', '76', '004C'),
(434, 'LYD', 3, 'Libyan dinar', '1604;46;1583', '0644;002E;062F'),
(504, 'MAD', 2, 'Moroccan dirham', '77;65;68', '004D;0041;0044'),
(498, 'MDL', 2, 'Moldovan leu', NULL, NULL),
(969, 'MGA', 1, 'Malagasy ariary', '65;114', '0041;0072'),
(807, 'MKD', 2, 'Macedonian denar', '1076;1077;1085', '0434;0435;043D'),
(104, 'MMK', 2, 'Burmese kyat', '75', '004B'),
(496, 'MNT', 2, 'Mongolian tögrög', '8366', '20AE'),
(446, 'MOP', 2, 'Macanese pataca', '77;79;80;36', '004D;004F;0050;0024'),
(929, 'MRU', 1, 'Mauritanian ouguiya', '85;77', '0055;004D'),
(480, 'MUR', 2, 'Mauritian rupee', '8360', '20A8'),
(462, 'MVR', 2, 'Maldivian rufiyaa', '45;1923', '002D;0783'),
(454, 'MWK', 2, 'Malawian kwacha', '77;75', '004D;004B'),
(484, 'MXN', 2, 'Mexican peso', '36', '0024'),
(458, 'MYR', 2, 'Malaysian ringgit', '82;77', '0052;004D'),
(943, 'MZN', 2, 'Mozambican metical', '77;84', '004D;0054'),
(516, 'NAD', 2, 'Namibian dollar', '36', '0024'),
(566, 'NGN', 2, 'Nigerian naira', '8358', '20A6'),
(558, 'NIO', 2, 'Nicaraguan córdoba', '67;36', '0043;0024'),
(578, 'NOK', 2, 'Norwegian krone', '107;114', '006B;0072'),
(524, 'NPR', 2, 'Nepalese rupee', '8360', '20A8'),
(554, 'NZD', 2, 'New Zealand dollar', '36', '0024'),
(512, 'OMR', 3, 'Omani rial', '65020', 'FDFC'),
(590, 'PAB', 2, 'Panamanian balboa', '66;47;46', '0042;002F;002E'),
(604, 'PEN', 2, 'Peruvian sol', '83;47;46', '0053;002F;002E'),
(598, 'PGK', 2, 'Papua New Guinean kina', '75', '004B'),
(608, 'PHP', 2, 'Philippine peso', '8369', '20B1'),
(586, 'PKR', 2, 'Pakistani rupee', '8360', '20A8'),
(985, 'PLN', 2, 'Polish złoty', '122;322', '007A;0142'),
(600, 'PYG', 0, 'Paraguayan guaraní', '71;115', '0047;0073'),
(634, 'QAR', 2, 'Qatari riyal', '65020', 'FDFC'),
(946, 'RON', 2, 'Romanian leu', '108;101;105', '006C;0065;0069'),
(941, 'RSD', 2, 'Serbian dinar', '1044;1080;1085;46', '0414;0438;043D;002E'),
(643, 'RUB', 2, 'Russian ruble', '1088;1091;1073', '0440;0443;0431'),
(646, 'RWF', 0, 'Rwandan franc', '70;82;119', '0046;0052;0077'),
(682, 'SAR', 2, 'Saudi riyal', '65020', 'FDFC'),
(90, 'SBD', 2, 'Solomon Islands dollar', '36', '0024'),
(690, 'SCR', 2, 'Seychelles rupee', '8360', '20A8'),
(938, 'SDG', 2, 'Sudanese pound', '1580;46;1587', '062C;002E;0633'),
(752, 'SEK', 2, 'Swedish krona/kronor', '107;114', '006B;0072'),
(702, 'SGD', 2, 'Singapore dollar', '36', '0024'),
(654, 'SHP', 2, 'Saint Helena pound', '163', '00A3'),
(694, 'SLL', 2, 'Sierra Leonean leone', '76;101', '004C;0065'),
(706, 'SOS', 2, 'Somali shilling', '83', '0053'),
(968, 'SRD', 2, 'Surinamese dollar', '36', '0024'),
(728, 'SSP', 2, 'South Sudanese pound', '36', '0024'),
(930, 'STN', 2, 'São Tomé and Príncipe dobra', '68;98', '0044;0062'),
(760, 'SYP', 2, 'Syrian pound', '163', '00A3'),
(748, 'SZL', 2, 'Swazi lilangeni', '76', '004C'),
(764, 'THB', 2, 'Thai baht', '3647', '0E3F'),
(972, 'TJS', 2, 'Tajikistani somoni', NULL, NULL),
(934, 'TMT', 2, 'Turkmenistani manat', '84', '0054'),
(788, 'TND', 3, 'Tunisian dinar', '1583;46;1578', '062F;002E;062A'),
(776, 'TOP', 2, 'Tongan paʻanga', '84;36', '0054;0024'),
(949, 'TRY', 2, 'Turkish lira', '8378', '20BA'),
(780, 'TTD', 2, 'Trinidad and Tobago dollar', '84;84;36', '0054;0054;0024'),
(901, 'TWD', 2, 'New Taiwan dollar', '78;84;36', '004E;0054;0024'),
(834, 'TZS', 2, 'Tanzanian shilling', '84;83;104', '0054;0053;0068'),
(980, 'UAH', 2, 'Ukrainian hryvnia', '8372', '20B4'),
(800, 'UGX', 0, 'Ugandan shilling', '85;83;104', '0055;0053;0068'),
(840, 'USD', 2, 'United States dollar', '36', '0024'),
(858, 'UYU', 2, 'Uruguayan peso', '36;85', '0024;0055'),
(860, 'UZS', 2, 'Uzbekistan som', '1083;1074', '043B;0432'),
(928, 'VES', 2, 'Venezuelan bolívar soberano', '66;115', '0042;0073'),
(704, 'VND', 0, 'Vietnamese đồng', '8363', '20AB'),
(548, 'VUV', 0, 'Vanuatu vatu', '86;84', '0056;0054'),
(882, 'WST', 2, 'Samoan tala', '87;83;36', '0057;0053;0024'),
(950, 'XAF', 0, 'CFA franc BEAC', NULL, NULL),
(951, 'XCD', 2, 'East Caribbean dollar', '36', '0024'),
(952, 'XOF', 0, 'CFA franc BCEAO', NULL, NULL),
(953, 'XPF', 0, 'CFP franc (franc Pacifique)', '70', '0046'),
(999, 'XXX', 0, 'No currency', NULL, NULL),
(886, 'YER', 2, 'Yemeni rial', '65020', 'FDFC'),
(710, 'ZAR', 2, 'South African rand', '82', '0052'),
(967, 'ZMW', 2, 'Zambian kwacha', '90;36', '005A;0024'),
(222, 'SVC', 2, 'Salvadoran colón', '20A1', '8353'),
(932, 'ZWL', 2, 'Zimbabwean dollar', '36', '0024');
ALTER TABLE `world_currencies`
ADD PRIMARY KEY (`number`),
ADD UNIQUE (`alpha3`);