Sha256: 48789114e858d11a9c546c4a105ba8fc19b91d7ddcef3e3396f0d9dbeb1650c8
Contents?: true
Size: 467 Bytes
Versions: 53
Compression:
Stored size: 467 Bytes
Contents
-- SET client_encoding TO 'UNICODE';
CREATE TABLE country (
name TEXT NOT NULL,
two_letter TEXT PRIMARY KEY,
id integer NOT NULL
);
CREATE INDEX country_name ON country(name);
CREATE TABLE subcountry (
country TEXT NOT NULL REFERENCES country(two_letter),
name TEXT,
subdivision TEXT,
level TEXT,
UNIQUE(country, name)
);
CREATE INDEX subcountry_country ON subcountry(country);
CREATE INDEX subcountry_name ON subcountry(name);
Version data entries
53 entries across 53 versions & 3 rubygems