17 lines
537 B
SQL
Executable file
17 lines
537 B
SQL
Executable file
SET AUTOCOMMIT=1;
|
|
|
|
CREATE DATABASE IF NOT EXISTS country_stats charset utf8;
|
|
|
|
USE country_stats;
|
|
|
|
DROP TABLE IF EXISTS cs_countries;
|
|
|
|
CREATE TABLE IF NOT EXISTS country_stats.cs_countries (
|
|
cs_country_id INT AUTO_INCREMENT,
|
|
cs_country_name VARCHAR(32) NOT NULL UNIQUE,
|
|
cs_country_continent VARCHAR(16) NOT NULL,
|
|
cs_country_area INT NOT NULL,
|
|
cs_country_population INT NOT NULL,
|
|
cs_country_drivingSide ENUM('left', 'right') NOT NULL,
|
|
PRIMARY KEY (cs_country_id)
|
|
); |