Merge commit '2.13' into HEAD

[maypole.git] / ex / fancy_example / beerdb.sql

diff --git a/ex/fancy_example/beerdb.sql b/ex/fancy_example/beerdb.sql
deleted file mode 100644 (file)
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)
-);
-
-