create table beer (
id integer auto_increment primary key,
- brewery integereger,
- style integereger,
+ brewery integer,
+ style integer,
name varchar(30),
url varchar(120),
# tasted date,
- score integereger(2),
+ score integer(2),
price varchar(12),
abv varchar(10),
notes text
create table handpump (
id integer auto_increment primary key,
- beer integereger,
- pub integereger
+ beer integer,
+ pub integer
);
create table pub (