Re: [mv] MySQL UNIQUE index needs NOT NULL

[Tom Craig <paradoxe@altranet.fr>]

At 11:05 07/12/99 -0800, Shane Roberts wrote:
>I figured out to make "code" the primary key, but when I restart minivend
it wipes out my definition of the products table in Mysql, and creates the
bad one again.

One tool I have found very helpful is http://www.htmlwizard.net/phpMyAdmin/
(thanks to Scott Benson for that). It won't solve all your problems, but it
makes life a lot easier. Needless to say you need PHP installed.

>Also, I need minivend to make the table automatically because I am
building a lot of stores and I want to automate the process. I am having a
hard time figuring out just when and how minivend makes database tables,
although I
>realize that for Mysql MiniVend uses the Perl file "DBI.pm".

I started off making an empty database "mysqladmin create new_database"

Then I modified products.asc to have the fields I wanted.

Next I made modifications in catalog.cfg to make MV use MySQL and to modify
certain fields

Then I ./restart-ed the minivend server. During the catalog config, MV made
the table "products" with all the correct fields in the new MySQL database
I created. 

>Anything you turn up on this I would appreciate hearing about. Also, as I
make progress with this, I would be happy to share anything I learn.

You can find a lot of good MySQL tutorials at:

	http://www.devshed.com/Server_Side/MySQL/

All the best,

Tom..

---------------------------------------------------
N:	Tom Craig
E:	<tom@paradoxcafe.com>
W:	http://www.paradoxcafe.com/
T1:	(France) +33 (0) 616 215 777
T2:	(UK) +44 (0) 705 069 3887
?:	NEW MEDIA DESIGN - PARADOX CAFE