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

/* Schema: Currencies(_code,name,value) */

CREATE TABLE Currencies(
  code CHAR(3) PRIMARY KEY,
  name TEXT,
  value FLOAT);