X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=ex%2Ffancy_example%2Fbeerdb.sql;fp=ex%2Ffancy_example%2Fbeerdb.sql;h=6089c942fa02888900bc8ea4d46936bd2034640f;hb=7bb021648c28d2f70ec2853f0d01dd49c6437460;hp=0000000000000000000000000000000000000000;hpb=c3973978e1373a262d13da63c9e9ecfde4b72cc7;p=maypole.git

diff --git a/ex/fancy_example/beerdb.sql b/ex/fancy_example/beerdb.sql
new file mode 100644
index 0000000..6089c94
--- /dev/null
+++ b/ex/fancy_example/beerdb.sql
@@ -0,0 +1,67 @@
+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)
+);
+
+