CREATE TABLE IF NOT EXISTS currency
(
  id INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
  symbol VARCHAR(10),
  name VARCHAR(255),
  symbol_native VARCHAR(20),
  decimal_digits INT,
  rounding INT,
  `code` VARCHAR(10),
  name_plural VARCHAR(200)
);

INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('$','US Dollar','$',2,0,'USD','US dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CA$','Canadian Dollar','$',2,0,'CAD','Canadian dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('€','Euro','€',2,0,'EUR','euros');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('AED','United Arab Emirates Dirham','د.إ.‏',2,0,'AED','UAE dirhams');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Af','Afghan Afghani','؋',0,0,'AFN','Afghan Afghanis');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('ALL','Albanian Lek','Lek',0,0,'ALL','Albanian lekë');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('AMD','Armenian Dram','դր.',0,0,'AMD','Armenian drams');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('AR$','Argentine Peso','$',2,0,'ARS','Argentine pesos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('AU$','Australian Dollar','$',2,0,'AUD','Australian dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('man.','Azerbaijani Manat','ман.',2,0,'AZN','Azerbaijani manats');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('KM','Bosnia-Herzegovina Convertible Mark','KM',2,0,'BAM','Bosnia-Herzegovina convertible marks');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Tk','Bangladeshi Taka','৳',2,0,'BDT','Bangladeshi takas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('BGN','Bulgarian Lev','лв.',2,0,'BGN','Bulgarian leva');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('BD','Bahraini Dinar','د.ب.‏',3,0,'BHD','Bahraini dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('FBu','Burundian Franc','FBu',0,0,'BIF','Burundian francs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('BN$','Brunei Dollar','$',2,0,'BND','Brunei dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Bs','Bolivian Boliviano','Bs',2,0,'BOB','Bolivian bolivianos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('R$','Brazilian Real','R$',2,0,'BRL','Brazilian reals');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('BWP','Botswanan Pula','P',2,0,'BWP','Botswanan pulas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('BYR','Belarusian Ruble','BYR',0,0,'BYR','Belarusian rubles');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('BZ$','Belize Dollar','$',2,0,'BZD','Belize dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CDF','Congolese Franc','FrCD',2,0,'CDF','Congolese francs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CHF','Swiss Franc','CHF',2,0.05,'CHF','Swiss francs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CL$','Chilean Peso','$',0,0,'CLP','Chilean pesos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CN¥','Chinese Yuan','CN¥',2,0,'CNY','Chinese yuan');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CO$','Colombian Peso','$',0,0,'COP','Colombian pesos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₡','Costa Rican Colón','₡',0,0,'CRC','Costa Rican colóns');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CV$','Cape Verdean Escudo','CV$',2,0,'CVE','Cape Verdean escudos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Kč','Czech Republic Koruna','Kč',2,0,'CZK','Czech Republic korunas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Fdj','Djiboutian Franc','Fdj',0,0,'DJF','Djiboutian francs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Dkr','Danish Krone','kr',2,0,'DKK','Danish kroner');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('RD$','Dominican Peso','RD$',2,0,'DOP','Dominican pesos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('DA','Algerian Dinar','د.ج.‏',2,0,'DZD','Algerian dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Ekr','Estonian Kroon','kr',2,0,'EEK','Estonian kroons');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('EGP','Egyptian Pound','ج.م.‏',2,0,'EGP','Egyptian pounds');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Nfk','Eritrean Nakfa','Nfk',2,0,'ERN','Eritrean nakfas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Br','Ethiopian Birr','Br',2,0,'ETB','Ethiopian birrs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('£','British Pound Sterling','£',2,0,'GBP','British pounds sterling');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('GEL','Georgian Lari','GEL',2,0,'GEL','Georgian laris');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('GH₵','Ghanaian Cedi','GH₵',2,0,'GHS','Ghanaian cedis');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('FG','Guinean Franc','FG',0,0,'GNF','Guinean francs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('GTQ','Guatemalan Quetzal','Q',2,0,'GTQ','Guatemalan quetzals');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('HK$','Hong Kong Dollar','$',2,0,'HKD','Hong Kong dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('HNL','Honduran Lempira','L',2,0,'HNL','Honduran lempiras');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('kn','Croatian Kuna','kn',2,0,'HRK','Croatian kunas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Ft','Hungarian Forint','Ft',0,0,'HUF','Hungarian forints');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Rp','Indonesian Rupiah','Rp',0,0,'IDR','Indonesian rupiahs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₪','Israeli New Sheqel','₪',2,0,'ILS','Israeli new sheqels');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Rs','Indian Rupee','টকা',2,0,'INR','Indian rupees');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('IQD','Iraqi Dinar','د.ع.‏',0,0,'IQD','Iraqi dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('IRR','Iranian Rial','﷼',0,0,'IRR','Iranian rials');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Ikr','Icelandic Króna','kr',0,0,'ISK','Icelandic krónur');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('J$','Jamaican Dollar','$',2,0,'JMD','Jamaican dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('JD','Jordanian Dinar','د.أ.‏',3,0,'JOD','Jordanian dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('¥','Japanese Yen','￥',0,0,'JPY','Japanese yen');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Ksh','Kenyan Shilling','Ksh',2,0,'KES','Kenyan shillings');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('KHR','Cambodian Riel','៛',2,0,'KHR','Cambodian riels');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CF','Comorian Franc','FC',0,0,'KMF','Comorian francs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₩','South Korean Won','₩',0,0,'KRW','South Korean won');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('KD','Kuwaiti Dinar','د.ك.‏',3,0,'KWD','Kuwaiti dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('KZT','Kazakhstani Tenge','тңг.',2,0,'KZT','Kazakhstani tenges');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('LB£','Lebanese Pound','ل.ل.‏',0,0,'LBP','Lebanese pounds');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('SLRs','Sri Lankan Rupee','SL Re',2,0,'LKR','Sri Lankan rupees');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Lt','Lithuanian Litas','Lt',2,0,'LTL','Lithuanian litai');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Ls','Latvian Lats','Ls',2,0,'LVL','Latvian lati');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('LD','Libyan Dinar','د.ل.‏',3,0,'LYD','Libyan dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MAD','Moroccan Dirham','د.م.‏',2,0,'MAD','Moroccan dirhams');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MDL','Moldovan Leu','MDL',2,0,'MDL','Moldovan lei');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MGA','Malagasy Ariary','MGA',0,0,'MGA','Malagasy Ariaries');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MKD','Macedonian Denar','MKD',2,0,'MKD','Macedonian denari');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MMK','Myanma Kyat','K',0,0,'MMK','Myanma kyats');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MOP$','Macanese Pataca','MOP$',2,0,'MOP','Macanese patacas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MURs','Mauritian Rupee','MURs',0,0,'MUR','Mauritian rupees');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MX$','Mexican Peso','$',2,0,'MXN','Mexican pesos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('RM','Malaysian Ringgit','RM',2,0,'MYR','Malaysian ringgits');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('MTn','Mozambican Metical','MTn',2,0,'MZN','Mozambican meticals');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('N$','Namibian Dollar','N$',2,0,'NAD','Namibian dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₦','Nigerian Naira','₦',2,0,'NGN','Nigerian nairas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('C$','Nicaraguan Córdoba','C$',2,0,'NIO','Nicaraguan córdobas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Nkr','Norwegian Krone','kr',2,0,'NOK','Norwegian kroner');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('NPRs','Nepalese Rupee','नेरू',2,0,'NPR','Nepalese rupees');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('NZ$','New Zealand Dollar','$',2,0,'NZD','New Zealand dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('OMR','Omani Rial','ر.ع.‏',3,0,'OMR','Omani rials');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('B/.','Panamanian Balboa','B/.',2,0,'PAB','Panamanian balboas');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('S/.','Peruvian Nuevo Sol','S/.',2,0,'PEN','Peruvian nuevos soles');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₱','Philippine Peso','₱',2,0,'PHP','Philippine pesos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('PKRs','Pakistani Rupee','₨',0,0,'PKR','Pakistani rupees');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('zł','Polish Zloty','zł',2,0,'PLN','Polish zlotys');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₲','Paraguayan Guarani','₲',0,0,'PYG','Paraguayan guaranis');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('QR','Qatari Rial','ر.ق.‏',2,0,'QAR','Qatari rials');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('RON','Romanian Leu','RON',2,0,'RON','Romanian lei');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('din.','Serbian Dinar','дин.',0,0,'RSD','Serbian dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('RUB','Russian Ruble','руб.',2,0,'RUB','Russian rubles');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('RWF','Rwandan Franc','FR',0,0,'RWF','Rwandan francs');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('SR','Saudi Riyal','ر.س.‏',2,0,'SAR','Saudi riyals');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('SDG','Sudanese Pound','SDG',2,0,'SDG','Sudanese pounds');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Skr','Swedish Krona','kr',2,0,'SEK','Swedish kronor');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('S$','Singapore Dollar','$',2,0,'SGD','Singapore dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Ssh','Somali Shilling','Ssh',0,0,'SOS','Somali shillings');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('SY£','Syrian Pound','ل.س.‏',0,0,'SYP','Syrian pounds');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('฿','Thai Baht','฿',2,0,'THB','Thai baht');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('DT','Tunisian Dinar','د.ت.‏',3,0,'TND','Tunisian dinars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('T$','Tongan Paʻanga','T$',2,0,'TOP','Tongan paʻanga');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('TL','Turkish Lira','TL',2,0,'TRY','Turkish Lira');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('TT$','Trinidad and Tobago Dollar','$',2,0,'TTD','Trinidad and Tobago dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('NT$','New Taiwan Dollar','NT$',2,0,'TWD','New Taiwan dollars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('TSh','Tanzanian Shilling','TSh',0,0,'TZS','Tanzanian shillings');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₴','Ukrainian Hryvnia','₴',2,0,'UAH','Ukrainian hryvnias');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('USh','Ugandan Shilling','USh',0,0,'UGX','Ugandan shillings');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('$U','Uruguayan Peso','$',2,0,'UYU','Uruguayan pesos');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('UZS','Uzbekistan Som','UZS',0,0,'UZS','Uzbekistan som');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('Bs.F.','Venezuelan Bolívar','Bs.F.',2,0,'VEF','Venezuelan bolívars');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('₫','Vietnamese Dong','₫',0,0,'VND','Vietnamese dong');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('FCFA','CFA Franc BEAC','FCFA',0,0,'XAF','CFA francs BEAC');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('CFA','CFA Franc BCEAO','CFA',0,0,'XOF','CFA francs BCEAO');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('YR','Yemeni Rial','ر.ي.‏',0,0,'YER','Yemeni rials');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('R','South African Rand','R',2,0,'ZAR','South African rand');
INSERT INTO CURRENCY(symbol, name, symbol_native, decimal_digits, rounding, `code`, name_plural) values ('ZK','Zambian Kwacha','ZK',0,0,'ZMK','Zambian kwachas');