-- MySQL dump 10.16  Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: SPYquartup1
-- ------------------------------------------------------
-- Server version	10.1.48-MariaDB-0+deb9u2

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `quemmone`
--

DROP TABLE IF EXISTS `quemmone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quemmone` (
  `cod_moneda` char(3) NOT NULL DEFAULT '' COMMENT 'Moneda',
  `sw_auto` char(1) NOT NULL DEFAULT 'N' COMMENT 'Creado autom.',
  `cod_mone_nume` char(3) NOT NULL DEFAULT '' COMMENT 'Código Nº',
  `nombre` text NOT NULL COMMENT 'Nombre',
  `siglas` char(3) NOT NULL DEFAULT '' COMMENT 'Siglas Moneda',
  `paises` text NOT NULL COMMENT 'Países que la usan',
  `id_tenant` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Nº empresa',
  UNIQUE KEY `key0` (`id_tenant`,`cod_moneda`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quemmone`
--
-- WHERE:  id_tenant='1'

LOCK TABLES `quemmone` WRITE;
/*!40000 ALTER TABLE `quemmone` DISABLE KEYS */;
INSERT INTO `quemmone` (`cod_moneda`, `sw_auto`, `cod_mone_nume`, `nombre`, `siglas`, `paises`, `id_tenant`) VALUES ('AED','S','784','United Arab Emirates dirham','AED','United Arab Emirates',1),('AFN','S','971','Afghani','AFN','Afghanistan',1),('ALL','S','008','Lek','ALL','Albania',1),('AMD','S','051','Armenian dram','AMD','Armenia',1),('ANG','S','532','Netherlands Antillean guilder','ANG','Netherlands Antilles',1),('AOA','S','973','Kwanza','AOA','Angola',1),('ARS','S','032','Argentine peso','ARS','Argentina',1),('AUD','S','036','Australian dollar','AUD','Australia, Australian Antarctic Territory, Christmas Island, Cocos (Keeling) Islands, Heard and McDonald Islands, Kiribati, Nauru, Norfolk Island, Tuvalu',1),('AWG','S','533','Aruban guilder','AWG','Aruba',1),('AZN','S','944','Azerbaijanian manat','AZN','Azerbaijan',1),('BAM','S','977','Convertible marks','BAM','Bosnia and Herzegovina',1),('BBD','S','052','Barbados dollar','BBD','Barbados',1),('BDT','S','050','Bangladeshi taka','BDT','Bangladesh',1),('BGN','S','975','Bulgarian lev','BGN','Bulgaria',1),('BHD','S','048','Bahraini dinar','BHD','Bahrain',1),('BIF','S','108','Burundian franc','BIF','Burundi',1),('BMD','S','060','Bermudian dollar (customarily known as Bermuda dollar)','BMD','Bermuda',1),('BND','S','096','Brunei dollar','BND','Brunei, Singapore',1),('BOB','S','068','Boliviano','BOB','Bolivia',1),('BOV','S','984','Bolivian Mvdol (funds code)','BOV','Bolivia',1),('BRL','S','986','Brazilian real','BRL','Brazil',1),('BSD','S','044','Bahamian dollar','BSD','Bahamas',1),('BTN','S','064','Ngultrum','BTN','Bhutan',1),('BWP','S','072','Pula','BWP','Botswana',1),('BYR','S','974','Belarusian ruble','BYR','Belarus',1),('BZD','S','084','Belize dollar','BZD','Belize',1),('CAD','S','124','Canadian dollar','CAD','Canada',1),('CDF','S','976','Franc Congolais','CDF','Democratic Republic of Congo',1),('CHE','S','947','WIR euro (complementary currency)','CHE','Switzerland',1),('CHF','S','756','Swiss franc','CHF','Switzerland, Liechtenstein',1),('CHW','S','948','WIR franc (complementary currency)','CHW','Switzerland',1),('CLF','S','990','Unidad de Fomento (funds code)','CLF','Chile',1),('CLP','S','152','Chilean peso','CLP','Chile',1),('CNY','S','156','Chinese Yuan','CNY','China (Mainland)',1),('COP','S','170','Colombian peso','COP','Colombia',1),('COU','S','970','Unidad de Valor Real','COU','Colombia',1),('CRC','S','188','Costa Rican colon','CRC','Costa Rica',1),('CUC','S','931','Cuban convertible peso','CUC','Cuba',1),('CUP','S','192','Cuban peso','CUP','Cuba',1),('CVE','S','132','Cape Verde escudo','CVE','Cape Verde',1),('CZK','S','203','Czech Koruna','CZK','Czech Republic',1),('DJF','S','262','Djibouti franc','DJF','Djibouti',1),('DKK','S','208','Danish krone','DKK','Denmark, Faroe Islands, Greenland',1),('DOP','S','214','Dominican peso','DOP','Dominican Republic',1),('DZD','S','012','Algerian dinar','DZD','Algeria',1),('EEK','S','233','Kroon','EEK','Estonia',1),('EGP','S','818','Egyptian pound','EGP','Egypt',1),('ERN','S','232','Nakfa','ERN','Eritrea',1),('ETB','S','230','Ethiopian birr','ETB','Ethiopia',1),('EUR','S','978','Euro','EUR','16 European Union countries, Andorra, Kosovo, Monaco, Montenegro, San Marino, Vatican; see eurozone',1),('FJD','S','242','Fiji dollar','FJD','Fiji',1),('FKP','S','238','Falkland Islands pound','FKP','Falkland Islands',1),('GBP','S','826','Pound sterling','GBP','United Kingdom, Crown Dependencies (the Isle of Man and the Channel Islands), certain British Overseas Territories (South Georgia and the South Sandwich Islands, British Antarctic Territory and British Indian Ocean Territory)',1),('GEL','S','981','Lari','GEL','Georgia',1),('GHS','S','936','Cedi','GHS','Ghana',1),('GIP','S','292','Gibraltar pound','GIP','Gibraltar',1),('GMD','S','270','Dalasi','GMD','Gambia',1),('GNF','S','324','Guinea franc','GNF','Guinea',1),('GTQ','S','320','Quetzal','GTQ','Guatemala',1),('GYD','S','328','Guyana dollar','GYD','Guyana',1),('HKD','S','344','Hong Kong dollar','HKD','Hong Kong Special Administrative Region',1),('HNL','S','340','Lempira','HNL','Honduras',1),('HRK','S','191','Croatian kuna','HRK','Croatia',1),('HTG','S','332','Haiti gourde','HTG','Haiti',1),('HUF','S','348','Forint','HUF','Hungary',1),('IDR','S','360','Rupiah','IDR','Indonesia',1),('ILS','S','376','Israeli new sheqel','ILS','Israel',1),('INR','S','356','Indian rupee','INR','Bhutan, India, Nepal',1),('IQD','S','368','Iraqi dinar','IQD','Iraq',1),('IRR','S','364','Iranian rial','IRR','Iran',1),('ISK','S','352','Iceland krona','ISK','Iceland',1),('JMD','S','388','Jamaican dollar','JMD','Jamaica',1),('JOD','S','400','Jordanian dinar','JOD','Jordan',1),('JPY','S','392','Japanese yen','JPY','Japan',1),('KES','S','404','Kenyan shilling','KES','Kenya',1),('KGS','S','417','Som','KGS','Kyrgyzstan',1),('KHR','S','116','Riel','KHR','Cambodia',1),('KMF','S','174','Comoro franc','KMF','Comoros',1),('KPW','S','408','North Korean won','KPW','North Korea',1),('KRW','S','410','South Korean won','KRW','South Korea',1),('KWD','S','414','Kuwaiti dinar','KWD','Kuwait',1),('KYD','S','136','Cayman Islands dollar','KYD','Cayman Islands',1),('KZT','S','398','Tenge','KZT','Kazakhstan',1),('LAK','S','418','Kip','LAK','Laos',1),('LBP','S','422','Lebanese pound','LBP','Lebanon',1),('LKR','S','144','Sri Lanka rupee','LKR','Sri Lanka',1),('LRD','S','430','Liberian dollar','LRD','Liberia',1),('LSL','S','426','Lesotho loti','LSL','Lesotho',1),('LTL','S','440','Lithuanian litas','LTL','Lithuania',1),('LVL','S','428','Latvian lats','LVL','Latvia',1),('LYD','S','434','Libyan dinar','LYD','Libya',1),('MAD','S','504','Moroccan dirham','MAD','Morocco, Western Sahara',1),('MDL','S','498','Moldovan leu','MDL','Moldova',1),('MGA','S','969','Malagasy ariary','MGA','Madagascar',1),('MKD','S','807','Denar','MKD','Macedonia',1),('MMK','S','104','Kyat','MMK','Myanmar',1),('MNT','S','496','Tugrik','MNT','Mongolia',1),('MOP','S','446','Pataca','MOP','Macau Special Administrative Region',1),('MRO','S','478','Ouguiya','MRO','Mauritania',1),('MUR','S','480','Mauritius rupee','MUR','Mauritius',1),('MVR','S','462','Rufiyaa','MVR','Maldives',1),('MWK','S','454','Kwacha','MWK','Malawi',1),('MXN','S','484','Mexican peso','MXN','Mexico',1),('MXV','S','979','Mexican Unidad de Inversion (UDI) (funds code)','MXV','Mexico',1),('MYR','S','458','Malaysian ringgit','MYR','Malaysia',1),('MZN','S','943','Metical','MZN','Mozambique',1),('NAD','S','516','Namibian dollar','NAD','Namibia',1),('NGN','S','566','Naira','NGN','Nigeria',1),('NIO','S','558','Cordoba oro','NIO','Nicaragua',1),('NOK','S','578','Norwegian krone','NOK','Norway, Bouvet Island, Queen Maud Land, Peter I Island',1),('NPR','S','524','Nepalese rupee','NPR','Nepal',1),('NZD','S','554','New Zealand dollar','NZD','Cook Islands, New Zealand, Niue, Pitcairn, Tokelau',1),('OMR','S','512','Rial Omani','OMR','Oman',1),('PAB','S','590','Balboa','PAB','Panama',1),('PEN','S','604','Nuevo sol','PEN','Peru',1),('PGK','S','598','Kina','PGK','Papua New Guinea',1),('PHP','S','608','Philippine peso','PHP','Philippines',1),('PKR','S','586','Pakistan rupee','PKR','Pakistan',1),('PLN','S','985','Zloty','PLN','Poland',1),('PYG','S','600','Guarani','PYG','Paraguay',1),('QAR','S','634','Qatari rial','QAR','Qatar',1),('RON','S','946','Romanian new leu','RON','Romania',1),('RSD','S','941','Serbian dinar','RSD','Serbia',1),('RUB','S','643','Russian rouble','RUB','Russia, Abkhazia, South Ossetia',1),('RWF','S','646','Rwanda franc','RWF','Rwanda',1),('SAR','S','682','Saudi riyal','SAR','Saudi Arabia',1),('SBD','S','090','Solomon Islands dollar','SBD','Solomon Islands',1),('SCR','S','690','Seychelles rupee','SCR','Seychelles',1),('SDG','S','938','Sudanese pound','SDG','Sudan',1),('SEK','S','752','Swedish krona/kronor','SEK','Sweden',1),('SGD','S','702','Singapore dollar','SGD','Singapore, Brunei',1),('SHP','S','654','Saint Helena pound','SHP','Saint Helena',1),('SLL','S','694','Leone','SLL','Sierra Leone',1),('SOS','S','706','Somali shilling','SOS','Somalia',1),('SRD','S','968','Surinam dollar','SRD','Suriname',1),('STD','S','678','Dobra','STD','São Tomé and Príncipe',1),('SYP','S','760','Syrian pound','SYP','Syria',1),('SZL','S','748','Lilangeni','SZL','Swaziland',1),('THB','S','764','Baht','THB','Thailand',1),('TJS','S','972','Somoni','TJS','Tajikistan',1),('TMT','S','934','Manat','TMT','Turkmenistan',1),('TND','S','788','Tunisian dinar','TND','Tunisia',1),('TOP','S','776','Pa\'anga','TOP','Tonga',1),('TRY','S','949','Turkish lira','TRY','Turkey, Northern Cyprus',1),('TTD','S','780','Trinidad and Tobago dollar','TTD','Trinidad and Tobago',1),('TWD','S','901','New Taiwan dollar','TWD','Taiwan and other islands that are under the effective control of the Republic of China (ROC)',1),('TZS','S','834','Tanzanian shilling','TZS','Tanzania',1),('UAH','S','980','Hryvnia','UAH','Ukraine',1),('UGX','S','800','Uganda shilling','UGX','Uganda',1),('USD','S','840','US dollar','USD','American Samoa, British Indian Ocean Territory, Ecuador, El Salvador, Guam, Haiti, Marshall Islands, Micronesia, Northern Mariana Islands, Palau, Panama, Puerto Rico, Timor-Leste, Turks and Caicos Islands, United States, Virgin Islands, Bermuda (as well as Bermudian Dollar)',1),('USN','S','997','United States dollar (next day) (funds code)','USN','United States',1),('USS','S','998','United States dollar (same day) (funds code) (one source[who?] claims it is no longer used, but it is still on the ISO 4217-MA list)','USS','United States',1),('UYU','S','858','Peso Uruguayo','UYU','Uruguay',1),('UZS','S','860','Uzbekistan som','UZS','Uzbekistan',1),('VEF','S','937','Venezuelan bolívar fuerte','VEF','Venezuela',1),('VND','S','704','Vietnamese d?ng','VND','Vietnam',1),('VUV','S','548','Vatu','VUV','Vanuatu',1),('WST','S','882','Samoan tala','WST','Samoa',1),('XAF','S','950','CFA franc BEAC','XAF','Cameroon, Central African Republic, Congo, Chad, Equatorial Guinea, Gabon',1),('XAG','S','961','Silver (one troy ounce)','XAG','',1),('XAU','S','959','Gold (one troy ounce)','XAU','',1),('XBA','S','955','European Composite Unit (EURCO) (bond market unit)','XBA','',1),('XBB','S','956','European Monetary Unit (E.M.U.-6) (bond market unit)','XBB','',1),('XBC','S','957','European Unit of Account 9 (E.U.A.-9) (bond market unit)','XBC','',1),('XBD','S','958','European Unit of Account 17 (E.U.A.-17) (bond market unit)','XBD','',1),('XCD','S','951','East Caribbean dollar','XCD','Anguilla, Antigua and Barbuda, Dominica, Grenada, Montserrat, Saint Kitts and Nevis, Saint Lucia, Saint Vincent and the Grenadines',1),('XDR','S','960','Special Drawing Rights','XDR','International Monetary Fund',1),('XFU','S','Nil','UIC franc (special settlement currency)','XFU','International Union of Railways',1),('XOF','S','952','CFA Franc BCEAO','XOF','Benin, Burkina Faso, Côte d\'Ivoire, Guinea-Bissau, Mali, Niger, Senegal, Togo',1),('XPD','S','964','Palladium (one troy ounce)','XPD','',1),('XPF','S','953','CFP franc','XPF','French Polynesia, New Caledonia, Wallis and Futuna',1),('XPT','S','962','Platinum (one troy ounce)','XPT','',1),('XTS','S','963','Code reserved for testing purposes','XTS','',1),('XXX','S','999','No currency','XXX','',1),('YER','S','886','Yemeni rial','YER','Yemen',1),('ZAR','S','710','South African rand','ZAR','South Africa',1),('ZMK','S','894','Kwacha','ZMK','Zambia',1),('ZWL','S','932','Zimbabwe dollar','ZWL','Zimbabwe',1);
/*!40000 ALTER TABLE `quemmone` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-30  8:42:00
