X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;ds=sidebyside;f=examples%2Fbeerdb.sql;fp=examples%2Fbeerdb.sql;h=0c6a0df4d50e77b891259c84977dee453824c3e6;hb=fadcae3ffddebaa38da172f9624cc60176d80b33;hp=0000000000000000000000000000000000000000;hpb=d813b3413bbd58789200c2ef02c7386e33cabe00;p=maypole.git

diff --git a/examples/beerdb.sql b/examples/beerdb.sql
new file mode 100644
index 0000000..0c6a0df
--- /dev/null
+++ b/examples/beerdb.sql
@@ -0,0 +1,38 @@
+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
+);