/* Schema: Countries(name,capital,area,population,continent,currency) */

CREATE TABLE Countries(
  name       TEXT    PRIMARY KEY,
  capital    TEXT,
  area       FLOAT   NOT NULL,
  population INT     NOT NULL,
  continent  CHAR(2) NOT NULL,
  currency   CHAR(3)
);