DmKVQxRp

1
2
3    --
4    -- Table structure for table `countries`
5    --
6    
7    CREATE TABLE IF NOT EXISTS `countries` (
8      `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
9      `name_en` varchar(255) COLLATE utf8_bin NOT NULL,
10      `name_fr` varchar(255) COLLATE utf8_bin DEFAULT NULL,
11      `name_gr` varchar(255) COLLATE utf8_bin DEFAULT NULL,
12      `iso2_code` varchar(2) COLLATE utf8_bin NOT NULL,
13      `iso3_code` varchar(3) COLLATE utf8_bin NOT NULL,
14      `iso_num_code` smallint(6) NOT NULL,
15      `extension` text CHARACTER SET latin1 COLLATE latin1_bin,
16      `continent_code` char(2) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
17      `currency_code` char(4) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
18      `currency_name` varchar(45) COLLATE utf8_bin DEFAULT NULL,
19      `languages` text CHARACTER SET latin1 COLLATE latin1_bin,
20      `postal_code_regex` text CHARACTER SET latin1 COLLATE latin1_bin,
21      `tld` char(4) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
22      PRIMARY KEY (`id`),
23      UNIQUE KEY `id` (`id`),
24      UNIQUE KEY `iso_num_code` (`iso_num_code`),
25      UNIQUE KEY `iso2_code` (`iso2_code`),
26      UNIQUE KEY `iso3_code` (`iso3_code`),
27      KEY `continent_code` (`continent_code`),
28      KEY `currency_code` (`currency_code`),
29      KEY `tld` (`tld`)
30    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=256 ;