+CREATE TABLE style (
+ id integer primary key auto_increment,
+ name varchar(60),
+ notes text
+);
+
+CREATE TABLE pub (
+ id integer primary key auto_increment,
+ name varchar(60),
+ url varchar(120),
+ notes text
+);
+
+CREATE TABLE handpump (
+ id integer primary key auto_increment,
+ beer integer,
+ pub integer
+);
+
+CREATE TABLE beer (
+ id integer primary key auto_increment,
+ brewery integer,
+ style integer,
+ name varchar(30),
+ score integer(2),
+ price varchar(12),
+ abv varchar(10),
+ notes text,
+ tasted date
+);
+
+CREATE TABLE brewery (
+ id integer primary key auto_increment,
+ name varchar(30),
+ url varchar(50),
+ notes text
+);
+
+CREATE TABLE drinker (
+ id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
+ person INTEGER UNSIGNED NOT NULL,
+ handle VARCHAR(20) NOT NULL,
+ created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY(id),
+ INDEX drinker_FKIndex1(person)
+);
+
+CREATE TABLE person (
+ id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
+ first_name VARCHAR(50) NULL,
+ sur_name VARCHAR(50) NULL,
+ dob DATE NULL,
+ username VARCHAR(20) NULL,
+ password VARCHAR(20) NULL,
+ email VARCHAR(255) NULL,
+ PRIMARY KEY(id)
+);
+
+CREATE TABLE pint (
+ id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
+ drinker INTEGER UNSIGNED NOT NULL,
+ handpump INTEGER UNSIGNED NOT NULL,
+ date_and_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY(id)
+);
+
+