create table cities (
city varchar(80) primary key,
location point
);
create table weather (
city varchar(80) references cities(city),
temp_lo int,
temp_hi int,
prcp real,
date date
);
create table cities (
city varchar(80) primary key,
location point
);
create table weather (
city varchar(80) references cities(city),
temp_lo int,
temp_hi int,
prcp real,
date date
);