X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=Makefile.PL;h=0f1ef0abf71ce3be0bdd2a3aea6cc1dc0a504821;hb=de8359e67f698ef3e44c5fcc0c77ba5385f3ce19;hp=4b8811038d7ee3d5d56d7f507ddcab11fd6b3076;hpb=d5094e896c266519f63cc0f18b090103463d74b7;p=maypole.git

diff --git a/Makefile.PL b/Makefile.PL
index 4b88110..0f1ef0a 100644
--- a/Makefile.PL
+++ b/Makefile.PL
@@ -45,16 +45,16 @@ if (!-e "t/beerdb.db") {
 __DATA__
 
 create table brewery (
-    id int not null auto_increment primary key,
+    id integer auto_increment primary key,
     name varchar(30),
     url varchar(50),
     notes text
 );
 
 create table beer (
-    id int not null 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 not null auto_increment primary key,
-    beer integer,
-    pub integer
+    id integer auto_increment primary key,
+    beer integereger,
+    pub integereger
 );
 
 create table pub (
-    id int not null auto_increment primary key,
+    id integer auto_increment primary key,
     name varchar(60),
     url varchar(120),
     notes text
 );
 
 create table style (
-    id int not null auto_increment primary key,
+    id integer auto_increment primary key,
     name varchar(60),
     notes text
 );