Javier Belmonte vichango
vichango
/ countries.sql
Last active
September 1, 2021 16:08
— forked from allanlaal/countries.sql
Uses InnoDB and UTF-8. The ISO 3166-1 alpha-2 code is used as the primary key.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Table structure for table `country` | |
| -- | |
| CREATE TABLE IF NOT EXISTS `country` ( | |
| `iso` char(2) COLLATE utf8_unicode_ci NOT NULL, | |
| `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL, | |
| `nicename` varchar(80) COLLATE utf8_unicode_ci NOT NULL, | |
| `iso3` char(3) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| `numcode` smallint(6) DEFAULT NULL, |