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

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