Re: mySQL create tables

[Dan Busarow <dan@dpcsys.com>]

On Thu, 22 Jul 1999, Russ wrote:
> On Solaris 2.5 w/ mySQL 3.22, and MV 3.14, and PERL
> 5.005_03...
> My catalog.cfg is this:
> 
> Database            products products.asc
> dbi:mysql:dbname:localhost:3306
> Database            products USER       username
> Database            products PASS       password
> 
> And the error I get is this:
> 
> simple config error: Undefined subroutine
> &Vend::Table::DBI::create called at
> /VENDROOT/mvend/lib/Vend/Table/Import.pm line 160, <IN>
> chunk 1.
> 
> simple: error in configuration. Skipping.
> simple: config error. Skipping.

Minivend can't create a mysql table because mysql key fields must
have the NOT NULL attribute.  I never figured out a way in my,
very limited, testing of this to convince MV to include that in the
column def.

I didn't pursue it very hard though since I feel that you should create 
your tables manually, you lose too much control letting MV guess at what
you want.

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82