SQL table of World currencies and symbols (коды валют мира и их символы)

currency.sql

CREATE TABLE IF NOT EXISTS `currency` (
  `iso` char(3) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `symbol` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `currency` (`iso`, `name`, `symbol`) VALUES
('ADP', 'Andorran Peseta', 'ADP'),
('AED', 'United Arab Emirates Dirham', 'AED'),
('AFA', 'Afghanistan Afghani', 'AFA'),
('ALL', 'Albanian Lek', 'Lek'),
('AMD', 'Armenian Dram', 'AMD'),
('ANG', 'Netherlands Antillian Guilder', 'ƒ'),
('AOK', 'Angolan Kwanza', 'AOK'),
('ARS', 'Argentine Peso', '$'),
('AUD', 'Australian Dollar', '$'),
('AWG', 'Aruban Florin', 'ƒ'),
('BBD', 'Barbados Dollar', '$'),
('BDT', 'Bangladeshi Taka', 'BDT'),
('BGN', 'Bulgarian Lev', 'лв'),
('BHD', 'Bahraini Dinar', 'BHD'),
('BIF', 'Burundi Franc', 'BIF'),
('BMD', 'Bermudian Dollar', '$'),
('BND', 'Brunei Dollar', '$'),
('BOB', 'Bolivian Boliviano', '$b'),
('BRL', 'Brazilian Real', 'R$'),
('BSD', 'Bahamian Dollar', '$'),
('BTN', 'Bhutan Ngultrum', 'BTN'),
('BUK', 'Burma Kyat', 'BUK'),
('BWP', 'Botswanian Pula', 'P'),
('BZD', 'Belize Dollar', 'BZ$'),
('CAD', 'Canadian Dollar', '$'),
('CHF', 'Swiss Franc', 'CHF'),
('CLF', 'Chilean Unidades de Fomento', 'CLF'),
('CLP', 'Chilean Peso', '$'),
('CNY', 'Yuan (Chinese) Renminbi', '¥'),
('COP', 'Colombian Peso', '$'),
('CRC', 'Costa Rican Colon', '₡'),
('CUP', 'Cuban Peso', '₱'),
('CVE', 'Cape Verde Escudo', 'CVE'),
('CYP', 'Cyprus Pound', 'CYP'),
('CZK', 'Czech Republic Koruna', 'Kč'),
('DKK', 'Danish Krone', 'kr'),
('DOP', 'Dominican Peso', 'RD$'),
('DZD', 'Algerian Dinar', 'DZD'),
('ECS', 'Ecuador Sucre', 'ECS'),
('EEK', 'Estonian Kroon (EEK)', 'kr'),
('EGP', 'Egyptian Pound', '£'),
('ETB', 'Ethiopian Birr', 'ETB'),
('EUR', 'Euro', '€'),
('FJD', 'Fiji Dollar', '$'),
('FKP', 'Falkland Islands Pound', '£'),
('GBP', 'British Pound', '£'),
('GHC', 'Ghanaian Cedi', '¢'),
('GIP', 'Gibraltar Pound', '£'),
('GMD', 'Gambian Dalasi', 'GMD'),
('GNF', 'Guinea Franc', 'GNF'),
('GTQ', 'Guatemalan Quetzal', 'Q'),
('GWP', 'Guinea-Bissau Peso', 'GWP'),
('GYD', 'Guyanan Dollar', '$'),
('HKD', 'Hong Kong Dollar', '$'),
('HNL', 'Honduran Lempira', 'L'),
('HTG', 'Haitian Gourde', 'HTG'),
('HUF', 'Hungarian Forint', 'Ft'),
('IDR', 'Indonesian Rupiah', 'Rp'),
('IEP', 'Irish Punt', 'IEP'),
('ILS', 'Israeli Shekel', '₪'),
('INR', 'Indian Rupee', '₹'),
('IQD', 'Iraqi Dinar', 'IQD'),
('IRR', 'Iranian Rial', '﷼'),
('JMD', 'Jamaican Dollar', 'J$'),
('JOD', 'Jordanian Dinar', 'JOD'),
('JPY', 'Japanese Yen', '¥'),
('KES', 'Kenyan Schilling', 'KES'),
('KHR', 'Kampuchean (Cambodian) Riel', '៛'),
('KMF', 'Comoros Franc', 'KMF'),
('KPW', 'North Korean Won', '₩'),
('KRW', '(South) Korean Won', '₩'),
('KWD', 'Kuwaiti Dinar', 'KWD'),
('KYD', 'Cayman Islands Dollar', '$'),
('LAK', 'Lao Kip', '₭'),
('LBP', 'Lebanese Pound', '£'),
('LKR', 'Sri Lanka Rupee', '₨'),
('LRD', 'Liberian Dollar', '$'),
('LSL', 'Lesotho Loti', 'LSL'),
('LYD', 'Libyan Dinar', 'LYD'),
('MAD', 'Moroccan Dirham', 'MAD'),
('MGF', 'Malagasy Franc', 'MGF'),
('MNT', 'Mongolian Tugrik', '₮'),
('MOP', 'Macau Pataca', 'MOP'),
('MRO', 'Mauritanian Ouguiya', 'MRO'),
('MTL', 'Maltese Lira', 'MTL'),
('MUR', 'Mauritius Rupee', '₨'),
('MVR', 'Maldive Rufiyaa', 'MVR'),
('MWK', 'Malawi Kwacha', 'MWK'),
('MXP', 'Mexican Peso', 'MXP'),
('MYR', 'Malaysian Ringgit', 'RM'),
('MZM', 'Mozambique Metical', 'MZM'),
('NAD', 'Namibian Dollar', '$'),
('NGN', 'Nigerian Naira', '₦'),
('NIO', 'Nicaraguan Cordoba', 'C$'),
('NOK', 'Norwegian Kroner', 'kr'),
('NPR', 'Nepalese Rupee', '₨'),
('NZD', 'New Zealand Dollar', '$'),
('OMR', 'Omani Rial', '﷼'),
('PAB', 'Panamanian Balboa', 'B/.'),
('PEN', 'Peruvian Nuevo Sol', 'S/.'),
('PGK', 'Papua New Guinea Kina', 'PGK'),
('PHP', 'Philippine Peso', '₱'),
('PKR', 'Pakistan Rupee', '₨'),
('PLN', 'Polish Zloty', 'zł'),
('PYG', 'Paraguay Guarani', 'Gs'),
('QAR', 'Qatari Rial', '﷼'),
('RON', 'Romanian Leu', 'lei'),
('RUB', 'Russian Ruble', '₽'),
('RWF', 'Rwanda Franc', 'RWF'),
('SAR', 'Saudi Arabian Riyal', '﷼'),
('SBD', 'Solomon Islands Dollar', '$'),
('SCR', 'Seychelles Rupee', '₨'),
('SDP', 'Sudanese Pound', 'SDP'),
('SEK', 'Swedish Krona', 'kr'),
('SGD', 'Singapore Dollar', '$'),
('SHP', 'St. Helena Pound', '£'),
('SKK', 'Slovak Koruna', 'SKK'),
('SLL', 'Sierra Leone Leone', 'SLL'),
('SOS', 'Somali Schilling', 'S'),
('SRG', 'Suriname Guilder', 'SRG'),
('STD', 'Sao Tome and Principe Dobra', 'STD'),
('SVC', 'El Salvador Colon', '$'),
('SYP', 'Syrian Potmd', '£'),
('SZL', 'Swaziland Lilangeni', 'SZL'),
('THB', 'Thai Baht', '฿'),
('TND', 'Tunisian Dinar', 'TND'),
('TOP', 'Tongan Paanga', 'TOP'),
('TPE', 'East Timor Escudo', 'TPE'),
('TRY', 'Turkish Lira', 'TRY'),
('TTD', 'Trinidad and Tobago Dollar', 'TT$'),
('TWD', 'Taiwan Dollar', 'NT$'),
('TZS', 'Tanzanian Schilling', 'TZS'),
('UGX', 'Uganda Shilling', 'UGX'),
('USD', 'US Dollar', '$'),
('UYU', 'Uruguayan Peso', '$U'),
('VEF', 'Venezualan Bolivar', 'Bs'),
('VND', 'Vietnamese Dong', '₫'),
('VUV', 'Vanuatu Vatu', 'VUV'),
('WST', 'Samoan Tala', 'WST'),
('XAF', 'Communauté Financière Africaine BEAC, Francs', 'XAF'),
('XAG', 'Silver, Ounces', 'XAG'),
('XAU', 'Gold, Ounces', 'XAU'),
('XCD', 'East Caribbean Dollar', '$'),
('XDR', 'International Monetary Fund (IMF) Special Drawing Rights', 'XDR'),
('XOF', 'Communauté Financière Africaine BCEAO - Francs', 'XOF'),
('XPD', 'Palladium Ounces', 'XPD'),
('XPF', 'Comptoirs Français du Pacifique Francs', 'XPF'),
('XPT', 'Platinum, Ounces', 'XPT'),
('YDD', 'Democratic Yemeni Dinar', 'YDD'),
('YER', 'Yemeni Rial', '﷼'),
('YUD', 'New Yugoslavia Dinar', 'YUD'),
('ZAR', 'South African Rand', 'S'),
('ZMK', 'Zambian Kwacha', 'ZMK'),
('ZRZ', 'Zaire Zaire', 'ZRZ'),
('ZWD', 'Zimbabwe Dollar', 'Z$'),
('UAH', 'Украинская гривна', 'грн');


ALTER TABLE `gl_currency`
  ADD PRIMARY KEY (`iso`),
  ADD UNIQUE KEY `name` (`name`);