X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=Makefile.PL;h=f085b6a024b4ebf607bac296d1a71568bceb16c1;hb=bec4a6ff4a3503a297ce1226f9bbd46341193616;hp=a1e613194db7ed4f816d24b296f2493fe26a90c5;hpb=b60178968c046206aa97123141d4dca524fb67c7;p=maypole.git diff --git a/Makefile.PL b/Makefile.PL index a1e6131..f085b6a 100644 --- a/Makefile.PL +++ b/Makefile.PL @@ -45,16 +45,16 @@ 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, + id integer auto_increment primary key, brewery integer, - style integer, + style integer, name varchar(30), url varchar(120), # tasted date, @@ -65,20 +65,20 @@ create table beer ( ); create table handpump ( - id int auto_increment primary key, + id integer auto_increment primary key, beer integer, pub integer ); 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 );