[ic] how to NOT use products.txt

[Corey Gilmore <cfg@dln.uvm.edu>]

I am going crazy here.  IMO, using products.txt seems like a horrible
idea, since I have a mysql database.  Say for instance, the first line
of my 'products.txt' file looked like

sku	desc	icon	image

And i wanted to add a field 'small_icon' between icon and image.

How would I do this (easily)?  What I want to do is ditch products.txt so
that I can just use mysql, and do
alter table products add small_icon varchar(64) after icon;
to add a new field.

What I can't do, is get interchange to recognize this.

in catalog.cfg i did
NoImport products

I added the appropriate
Database  products  COLUMN_DEF   "small_icon=VARCHAR(64)"
in products.mysql

And I changed
Database  products  products.txt __SQLDSN__
to
Database  products  products.mysql __SQLDSN__

in products.mysql

I restarted interchange, and all seemed well.  BUT, my new column was
still not showing up when I edit a product.

So I have two issues - why isn't my field showing up, and how do i STOP
using products.txt (all my searches are db searches anyways).

thanks,
.cfg