MySQL UNIQUE index needs NOT NULL

[Shane Roberts <shane@shaneroberts.com>]

I am trying to run MiniVend with MySQL.

I have created a test catalog based on the "simple" catalog
template.

I have created a user "minivend" in MySQL, and this user has full
permissions under MySQL.

I have placed the following lines in my catalog.cfg file to
create the "products" catalog:

Database            products products.asc
dbi:mysql:minivend:localhost:3333
Database   products  DELIMITER     TAB
Database   products  LongReadLen   128
Database   products  COLUMN_DEF    price=float, code=char(20),
discount=float
Database   products  COLUMN_DEF    author=char(40),
title=char(64)
Database   products  COLUMN_DEF    nontaxable=char(3)
Database   products  NUMERIC       price, discount

When I restart the MiniVend server it tries to configure the
above products table but it gets the following error from MySQL:

ERROR 1121: Column 'code' is used with UNIQUE or INDEX but is not
defined as NOT NULL

Has anyone run into this problem before. What do you have to tell
MiniVend for it to properly create the index for the products
table?

Thanks for your help.

Shane



--
Shane Roberts              E-mail: shane@shaneroberts.com
Software Strategies
Voice: (530) 265-4155