CREATE TABLE zips (
	zip_code CHAR(5) NOT NULL,
	zip_type CHAR(1),
	city_name VARCHAR(64),
	city_type CHAR(1),
	state_name VARCHAR(64),
	state_abbr CHAR(2) NOT NULL,
	area_code CHAR(3),
	latitude NUMERIC(9,6) NOT NULL,
	longitude NUMERIC(9,6) NOT NULL
);

CREATE INDEX zip_codes ON zips (zip_code);
CREATE INDEX state_abbrs ON zips (state_abbr);
CREATE INDEX city_names ON zips USING btree (city_name); 

CREATE TABLE distance_cache (
	orig_zip CHAR(5) NOT NULL,
	dest_zip CHAR(5) NOT NULL,
	miles SMALLINT
);