X-Git-Url: https://git.decadent.org.uk/gitweb/?p=maypole.git;a=blobdiff_plain;f=ex%2Fbeerdb.sql;fp=ex%2Fbeerdb.sql;h=0000000000000000000000000000000000000000;hp=0c6a0df4d50e77b891259c84977dee453824c3e6;hb=fadcae3ffddebaa38da172f9624cc60176d80b33;hpb=d813b3413bbd58789200c2ef02c7386e33cabe00 diff --git a/ex/beerdb.sql b/ex/beerdb.sql deleted file mode 100644 index 0c6a0df..0000000 --- a/ex/beerdb.sql +++ /dev/null @@ -1,38 +0,0 @@ -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, - tasted date -); - -CREATE TABLE brewery ( - id integer primary key auto_increment, - name varchar(30), - url varchar(50), - notes text -);