g7k6m58F

1DROP SCHEMA IF EXISTS World CASCADE;
2CREATE SCHEMA World;
3SET search_path TO World;
4
5CREATE TABLE country (
6    code character(3) NOT NULL,
7    name text NOT NULL,
8    continent text NOT NULL,
9    population integer NOT NULL
10);
11
12CREATE TABLE countrylanguage (
13    countrycode character(3) NOT NULL,
14    countrylanguage text NOT NULL,
15    isofficial boolean,
16    percentage real
17);
18
19INSERT into country (code, name, continent, population) values
20('BOR', 'Borduria', 'Pangaea', 1000),
21('CAG', 'Cagliostro', 'Pangaea', 250),
22('MAR', 'Qumar', 'Pangaea', 250);
23
24INSERT into countrylanguages (countrycode, countrylanguage, isofficial,
25percentage) values
26('BOR', 'English', NULL, NULL),
27('BOR', 'Italian', NULL, NULL),
28('BOR', 'Klingon', NULL, NULL);