[ic] Adding fields using mysql

[Jon Jensen]

On 18 Sep 2001, Stefan Hornburg (Racke) wrote:

> "Zack Johnson" <zack@office.standardprinting.net> writes:
>
> > I added a field to dbconf/mysql/userdb.mysql:
> >
> > Database  userdb  COLUMN_DEF   "list TEXT NOT NULL"
> >
> > However, when I restart IC, the field is not added to the database.  Under
> > Admin > table information > userdb, 'list' comes up under COLUMN_DEF, but
> > not name.
> >
> > I'm lost on this one.  I checked through the IC Docs/mail archives, but most
> > of everything seems focused on products, not tables in general.
>
> Hm, maybe IC considers these line only when the table doesn't already
> exist ?

Those definitions are only used to create the database, so you need to
remove the userdb.sql file and restart Interchange. Of course make sure
you export your old data before you let IC drop the existing userdb!

Jon