From 3ad2dcf33ac9ae8edb90ac3d074d31a6cc95afee Mon Sep 17 00:00:00 2001 From: Simon Cozens Date: Tue, 6 Apr 2004 11:45:10 +0000 Subject: [PATCH] This is also what draven says, and I still trust him, despite last time. git-svn-id: http://svn.maypole.perl.org/Maypole/trunk@120 48953598-375a-da11-a14b-00016c27c3ee --- Makefile.PL | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) 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 ); -- 2.39.5