· 8 years ago · Jul 07, 2018, 12:16 PM
1DROP TABLE IF EXISTS `currency`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `currency` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `currency` varchar(3) NOT NULL DEFAULT '',
7 `currencyname` varchar(40) NOT NULL DEFAULT '',
8 `currencyrate` decimal(10,3) NOT NULL,
9 `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
10 PRIMARY KEY (`id`),
11 KEY `currency` (`currency`),
12 KEY `currencyrate` (`currencyrate`)
13) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8;
14/*!40101 SET character_set_client = @saved_cs_client */;
15
16--
17-- Dumping data for table `currency`
18--
19
20LOCK TABLES `currency` WRITE;
21/*!40000 ALTER TABLE `currency` DISABLE KEYS */;
22INSERT INTO `currency` VALUES (1,'ALL','Albanian Lek',1.840,'2016-07-26 15:29:52'),(2,'DZD','Algerian Dinar',1.643,'2016-07-26 15:29:52'),(3,'XAL','Aluminium Ounces',0.000,'2016-07-25 05:04:43'),(4,'ARS','Argentine Peso',0.222,'2016-07-26 15:29:52'),(5,'AWG','Aruba Florin',0.027,'2016-07-25 05:04:43'),(6,'AUD','Australian Dollar',0.020,'2016-07-25 05:04:43'),(7,'BSD','Bahamian Dollar',0.015,'2016-07-25 05:04:43'),(8,'BHD','Bahraini Dinar',0.006,'2016-07-25 05:04:43'),(9,'BDT','Bangladesh Taka',1.164,'2016-07-26 06:03:04'),(10,'BBD','Barbados Dollar',0.030,'2016-07-25 05:04:43'),(11,'BYR','Belarus Ruble',297.474,'2016-07-26 15:29:52'),(12,'BZD','Belize Dollar',0.029,'2016-07-26 06:03:04'),(13,'BMD','Bermuda Dollar',0.015,'2016-07-25 05:04:43'),(14,'BTN','Bhutan Ngultrum',0.999,'2016-07-26 06:03:04'),(15,'BOB','Bolivian Boliviano',0.102,'2016-07-25 05:04:43'),(16,'BRL','Brazilian Real',0.049,'2016-07-26 06:03:04'),(17,'GBP','British Pound',0.011,'2016-07-25 05:04:43'),(18,'BND','Brunei Dollar',0.020,'2016-07-25 05:04:43'),(19,'BGN','Bulgarian Lev',0.026,'2016-07-25 05:04:43'),(20,'BIF','Burundi Franc',24.443,'2016-07-26 15:29:52'),(21,'KHR','Cambodia Riel',60.505,'2016-07-26 15:29:52'),(22,'CAD','Canadian Dollar',0.020,'2016-07-25 05:04:44'),(23,'KYD','Cayman Islands Dollar',0.012,'2016-07-25 05:04:44'),(24,'XOF','CFA Franc (BCEAO)',8.868,'2016-07-26 15:29:52'),(25,'XAF','CFA Franc (BEAC)',8.867,'2016-07-26 15:29:52'),(26,'CLP','Chilean Peso',9.823,'2016-07-26 15:29:52'),(27,'CNY','Chinese Yuan',0.099,'2016-07-25 05:04:44'),(28,'COP','Colombian Peso',45.614,'2016-07-26 15:29:52'),(29,'KMF','Comoros Franc',6.639,'2016-07-26 15:29:52'),(30,'XCP','Copper Ounces',0.007,'2016-07-25 05:04:44'),(31,'CRC','Costa Rica Colon',8.044,'2016-07-26 15:29:52'),(32,'HRK','Croatian Kuna',0.101,'2016-07-25 05:04:44'),(33,'CUP','Cuban Peso',0.015,'2016-07-25 05:04:44'),(34,'CYP','Cyprus Pound',0.008,'2016-07-25 05:04:44'),(35,'CZK','Czech Koruna',0.366,'2016-07-26 15:29:52'),(36,'DKK','Danish Krone',0.101,'2016-07-26 15:29:52'),(37,'DJF','Dijibouti Franc',2.627,'2016-07-26 15:29:52'),(38,'DOP','Dominican Peso',0.680,'2016-07-26 06:03:04'),(39,'XCD','East Caribbean Dollar',0.040,'2016-07-25 05:04:44'),(40,'ECS','Ecuador Sucre',371.471,'2016-07-26 15:29:52'),(41,'EGP','Egyptian Pound',0.132,'2016-07-25 05:04:44'),(42,'SVC','El Salvador Colon',0.130,'2016-07-25 05:04:44'),(43,'ERN','Eritrea Nakfa',0.229,'2016-07-26 06:03:04'),(44,'EEK','Estonian Kroon',0.000,'2013-03-23 09:03:23'),(45,'ETB','Ethiopian Birr',0.324,'2016-07-25 05:04:44'),(46,'EUR','Euro',0.014,'2016-07-25 05:04:45'),(47,'FKP','Falkland Islands Pound',0.011,'2016-07-25 05:04:45'),(48,'GMD','Gambian Dalasi',0.621,'2016-07-26 15:29:52'),(49,'GHC','Ghanian Cedi',897.330,'2015-01-23 12:55:12'),(50,'GIP','Gibraltar Pound',0.011,'2016-07-25 05:04:45'),(51,'XAU','Gold Ounces',0.000,'2016-07-25 05:04:45'),(52,'GTQ','Guatemala Quetzal',0.113,'2016-07-26 06:03:04'),(53,'GNF','Guinea Franc',132.095,'2016-07-26 15:29:52'),(54,'HTG','Haiti Gourde',0.936,'2016-07-26 15:29:52'),(55,'HNL','Honduras Lempira',0.337,'2016-07-26 06:03:05'),(56,'HKD','Hong Kong Dollar',0.115,'2016-07-25 05:04:45'),(57,'HUF','Hungarian ForINT',4.232,'2016-07-26 15:29:52'),(58,'ISK','Iceland Krona',1.801,'2016-07-26 15:29:52'),(59,'INR','Indian Rupee',1.000,'2016-07-25 05:04:42'),(60,'IDR','Indonesian Rupiah',195.100,'2016-07-26 15:29:52'),(61,'IRR','Iran Rial',446.731,'2016-07-26 15:29:52'),(62,'ILS','Israeli Shekel',0.057,'2016-07-25 05:04:45'),(63,'JMD','Jamaican Dollar',1.876,'2016-07-26 15:29:52'),(64,'JPY','Japanese Yen',1.552,'2016-07-26 15:29:52'),(65,'JOD','Jordanian Dinar',0.011,'2016-07-25 05:04:45'),(66,'KZT','Kazakhstan Tenge',5.261,'2016-07-26 15:29:52'),(67,'KES','Kenyan Shilling',1.504,'2016-07-26 06:03:05'),(68,'KRW','Korean Won',16.876,'2016-07-26 15:29:52'),(69,'KWD','Kuwaiti Dinar',0.005,'2016-07-25 05:04:45'),(70,'LAK','Lao Kip',120.059,'2016-07-26 15:29:52'),(71,'LVL','Latvian Lat',0.009,'2016-07-25 05:04:45'),(72,'LBP','Lebanese Pound',22.354,'2016-07-26 15:29:52'),(73,'LSL','Lesotho Loti',0.213,'2016-07-25 05:04:45'),(74,'LYD','Libyan Dinar',0.020,'2016-07-26 15:29:52'),(75,'LTL','Lithuanian Lita',0.045,'2016-07-25 05:04:45'),(76,'MOP','Macau Pataca',0.119,'2016-07-25 05:04:45'),(77,'MKD','Macedonian Denar',0.828,'2016-07-26 15:29:52'),(78,'MGF','Malagasy Franc',5.830,'2015-01-23 12:55:12'),(79,'MWK','Malawi Kwacha',10.541,'2016-07-26 15:29:52'),(80,'MYR','Malaysian Ringgit',0.060,'2016-07-25 05:04:45'),(81,'MVR','Maldives Rufiyaa',0.222,'2016-07-26 06:03:05'),(82,'MTL','Maltese Lira',0.840,'2015-01-23 12:55:12'),(83,'MRO','Mauritania Ougulya',5.245,'2016-07-26 15:29:52'),(84,'MUR','Mauritius Rupee',0.524,'2016-07-26 15:29:52'),(85,'MXN','Mexican Peso',0.280,'2016-07-26 15:29:52'),(86,'MDL','Moldovan Leu',0.293,'2016-07-26 06:03:05'),(87,'MNT','Mongolian Tugrik',30.327,'2016-07-26 15:29:52'),(88,'MAD','Moroccan Dirham',0.146,'2016-07-26 06:03:06'),(89,'MZM','Mozambique Metical',0.000,'2013-03-23 09:03:23'),(90,'NAD','Namibian Dollar',0.214,'2016-07-26 15:29:52'),(91,'NPR','Nepalese Rupee',1.594,'2016-07-26 15:29:52'),(92,'ANG','Neth Antilles Guilder',0.026,'2016-07-25 05:04:46'),(93,'TRY','New Turkish Lira',0.045,'2016-07-26 06:03:06'),(94,'NZD','New Zealand Dollar',0.021,'2016-07-25 05:04:46'),(95,'NIO','Nicaragua Cordoba',0.421,'2016-07-26 15:29:52'),(96,'NGN','Nigerian Naira',4.636,'2016-07-26 15:29:52'),(97,'NOK','Norwegian Krone',0.128,'2016-07-26 15:29:52'),(98,'OMR','Omani Rial',0.006,'2016-07-25 05:04:46'),(99,'XPF','Pacific Franc',1.606,'2016-07-26 06:03:06'),(100,'PKR','Pakistani Rupee',1.553,'2016-07-26 15:29:52'),(101,'XPD','Palladium Ounces',0.000,'2016-07-25 05:04:46'),(102,'PAB','Panama Balboa',0.015,'2016-07-25 05:04:46'),(103,'PGK','Papua New Guinea Kina',0.047,'2016-07-25 05:04:46'),(104,'PYG','Paraguayan Guarani',83.091,'2016-07-26 15:29:52'),(105,'PEN','Peruvian Nuevo Sol',0.050,'2016-07-26 15:29:52'),(106,'PHP','Philippine Peso',0.700,'2016-07-26 06:03:06'),(107,'XPT','Platinum Ounces',0.000,'2016-07-25 05:04:46'),(108,'PLN','Polish Zloty',0.059,'2016-07-25 05:04:46'),(109,'QAR','Qatar Rial',0.054,'2016-07-25 05:04:46'),(110,'ROL','Romanian Leu',33.340,'2015-01-09 12:36:25'),(111,'RON','Romanian New Leu',0.060,'2016-07-25 05:04:46'),(112,'RUB','Russian Rouble',0.983,'2016-07-26 15:29:52'),(113,'RWF','Rwanda Franc',11.040,'2016-07-26 15:29:52'),(114,'WST','Samoa Tala',0.038,'2016-07-25 05:04:46'),(115,'STD','Sao Tome Dobra',331.085,'2016-07-26 15:29:52'),(116,'SAR','Saudi Arabian Riyal',0.056,'2016-07-25 05:04:46'),(117,'SCR','Seychelles Rupee',0.190,'2016-07-26 15:29:52'),(118,'SLL','Sierra Leone Leone',81.724,'2016-07-26 15:29:52'),(119,'XAG','Silver Ounces',0.001,'2016-07-25 05:04:47'),(120,'SGD','Singapore Dollar',0.020,'2016-07-25 05:04:47'),(121,'SKK','Slovak Koruna',33.554,'2015-01-09 12:36:25'),(122,'SIT','Slovenian Tolar',3.217,'2016-07-26 15:29:52'),(123,'SOS','Somali Shilling',8.232,'2016-07-26 15:29:52'),(124,'ZAR','South African Rand',0.214,'2016-07-26 15:29:52'),(125,'LKR','Sri Lanka Rupee',2.169,'2016-07-26 15:29:52'),(126,'SHP','St Helena Pound',0.011,'2016-07-25 05:04:47'),(127,'SDD','Sudanese Dinar',40.366,'2015-01-23 12:55:12'),(128,'SRG','Surinam Guilder',0.000,'2013-03-23 09:03:23'),(129,'SZL','Swaziland Lilageni',0.214,'2016-07-26 15:29:52'),(130,'SEK','Swedish Krona',0.129,'2016-07-26 15:29:52'),(131,'CHF','Swiss Franc',0.015,'2016-07-25 05:04:47'),(132,'SYP','Syrian Pound',3.203,'2016-07-26 15:29:52'),(133,'TWD','Taiwan Dollar',0.477,'2016-07-26 15:29:52'),(134,'TZS','Tanzanian Shilling',32.422,'2016-07-26 15:29:52'),(135,'THB','Thai Baht',0.519,'2016-07-26 15:29:52'),(136,'TOP','Tonga Paanga',0.034,'2016-07-25 05:04:47'),(137,'TTD','Trinidad&Tobago Dollar',0.099,'2016-07-25 05:04:47'),(138,'TND','Tunisian Dinar',0.033,'2016-07-25 05:04:47'),(139,'USD','U.S. Dollar',0.015,'2016-07-25 05:04:47'),(140,'AED','UAE Dirham',0.055,'2016-07-26 15:29:52'),(141,'UGX','Ugandan Shilling',50.193,'2016-07-26 15:29:52'),(142,'UAH','Ukraine Hryvnia',0.368,'2016-07-25 05:04:47'),(143,'UYU','Uruguayan New Peso',0.444,'2016-07-26 06:03:06'),(144,'VUV','Vanuatu Vatu',1.583,'2016-07-26 06:03:06'),(145,'VEB','Venezuelan Bolivar',0.000,'2013-03-23 09:03:23'),(146,'VND','Vietnam Dong',331.352,'2016-07-26 15:29:52'),(147,'YER','Yemen Riyal',3.711,'2016-07-26 15:29:52'),(148,'ZMK','Zambian Kwacha',76.442,'2016-06-25 09:51:32'),(149,'ZWD','Zimbabwe Dollar',0.000,'2013-03-23 09:03:23'),(150,'GYD','Guyana Dollar',3.045,'2016-07-26 15:29:52'),(151,'458','uioui',0.000,'2015-01-23 12:55:12'),(152,'h45','g34y35hg 4h45h45',100000.000,'2016-06-15 06:15:57'),(153,'453','45435',3445.659,'2016-06-15 11:51:12'),(154,'526','test',100000.000,'2016-06-15 11:54:06'),(155,'34g','test2',0.000,'2016-06-15 11:58:08'),(156,'fhd','fdg',0.000,'2016-06-15 12:00:32'),(157,'dfh','fdsdg',0.000,'2016-06-15 12:00:47'),(159,'tes','test',9999999.000,'2016-06-24 03:57:09');
23/*!40000 ALTER TABLE `currency` ENABLE KEYS */;
24UNLOCK TABLES;