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)
 );