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
|
--
-- Table structure for table `country`
--
DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country` (
`iso` char(2) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
`printable_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
`iso3` char(3) COLLATE utf8_unicode_ci NOT NULL,
`3char_4217` char(3) COLLATE utf8_unicode_ci NOT NULL,
`numcode` smallint(6) DEFAULT NULL,
PRIMARY KEY (`iso3`),
KEY `fk_devise_of` (`3char_4217`),
CONSTRAINT `fk_devise_of` FOREIGN KEY (`3char_4217`) REFERENCES `currency_4217` (`3char_4217`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `country`
--
LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` VALUES ('AW','ARUBA','Aruba','ABW','AWG',533),('AF','AFGHANISTAN','Afghanistan','AFG','AFN',4),('ZW','ZIMBABWE','Zimbabwe','ZWE','ZWL',716);
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `currency_4217`
--
DROP TABLE IF EXISTS `currency_4217`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `currency_4217` (
`3char_4217` char(3) COLLATE utf8_unicode_ci NOT NULL,
`num_4217` int(11) NOT NULL,
`currency_4217` varchar(70) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`3char_4217`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `currency_4217`
--
LOCK TABLES `currency_4217` WRITE;
/*!40000 ALTER TABLE `currency_4217` DISABLE KEYS */;
INSERT INTO `currency_4217` VALUES
('AFN',971,'Afghani '),('ALL',8,'Lek '),
('ZWL',932,'Zimbabwe Dollar ');
/*!40000 ALTER TABLE `currency_4217` ENABLE KEYS */;
UNLOCK TABLES; |
Partager