/
country.mysql.sql
15 lines (14 loc) · 980 Bytes
/
country.mysql.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
CREATE TABLE country (id VARCHAR(2) NOT NULL, name VARCHAR(64) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB;
INSERT INTO `country` (`id`, `name`) VALUES ('BR', 'Brazil');
INSERT INTO `country` (`id`, `name`) VALUES ('CN', 'China');
INSERT INTO `country` (`id`, `name`) VALUES ('DE', 'Germany');
INSERT INTO `country` (`id`, `name`) VALUES ('DJ', 'Yabuuti');
INSERT INTO `country` (`id`, `name`) VALUES ('ER', 'Eretria');
INSERT INTO `country` (`id`, `name`) VALUES ('ET', 'Otobbia');
INSERT INTO `country` (`id`, `name`) VALUES ('FR', 'France');
INSERT INTO `country` (`id`, `name`) VALUES ('GB', 'United Kingdom');
INSERT INTO `country` (`id`, `name`) VALUES ('IN', 'India');
INSERT INTO `country` (`id`, `name`) VALUES ('IT', 'Italy');
INSERT INTO `country` (`id`, `name`) VALUES ('JP', 'Japan');
INSERT INTO `country` (`id`, `name`) VALUES ('RU', 'Russia');
INSERT INTO `country` (`id`, `name`) VALUES ('US', 'United States');