X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=Makefile.PL;h=f6b9c7e9eeeec967d66c7655a784d4bf63fcbc83;hb=3ad2dcf33ac9ae8edb90ac3d074d31a6cc95afee;hp=a1e613194db7ed4f816d24b296f2493fe26a90c5;hpb=d0870933fcb803bac8e31a30b785d1dff15c5278;p=maypole.git diff --git a/Makefile.PL b/Makefile.PL index a1e6131..f6b9c7e 100644 --- a/Makefile.PL +++ b/Makefile.PL @@ -45,40 +45,40 @@ if (!-e "t/beerdb.db") { __DATA__ create table brewery ( - id int auto_increment primary key, + id integer auto_increment primary key, name varchar(30), url varchar(50), notes text ); create table beer ( - id int auto_increment primary key, - brewery integer, - style integer, + id integer auto_increment primary key, + brewery integereger, + style integereger, name varchar(30), url varchar(120), # tasted date, - score integer(2), + score integereger(2), price varchar(12), abv varchar(10), notes text ); create table handpump ( - id int auto_increment primary key, - beer integer, - pub integer + id integer auto_increment primary key, + beer integereger, + pub integereger ); create table pub ( - id int auto_increment primary key, + id integer auto_increment primary key, name varchar(60), url varchar(120), notes text ); create table style ( - id int auto_increment primary key, + id integer auto_increment primary key, name varchar(60), notes text );