X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=ex%2Fbeerdb.sql;fp=ex%2Fbeerdb.sql;h=b5d7d7c5d6160c4411f6977744c222dca3152564;hb=a02686080acb66fce170e9657e110761b09e62a2;hp=0000000000000000000000000000000000000000;hpb=9248ebe461d183756053e56e7b1941f5c682e344;p=maypole.git diff --git a/ex/beerdb.sql b/ex/beerdb.sql new file mode 100644 index 0000000..b5d7d7c --- /dev/null +++ b/ex/beerdb.sql @@ -0,0 +1,37 @@ +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), + url varchar(120), + score integer(2), + price varchar(12), + abv varchar(10), + notes text +); + +CREATE TABLE brewery ( + id integer primary key auto_increment, + name varchar(30), + url varchar(50), + notes text +);