[ic] Adding fields using mysql

[Zack Johnson]

Jon,

I 'rm user*' in the products directory and restarted.  IC did not re-create
the table at all.  In detail, I:

1. dropped the table 'userdb'
2. edited 'dbconf/mysql/userdb.mysql'
3. cd'ed to products
4. rm user* -f
5. /etc/rc.d/init.d/interchange restart
6. mysql > show tables;

No 'userdb'.

Did I miss a step?

Thanks!

Zack
----- Original Message -----
From: "Jon Jensen" <jon@redhat.com>
To: <interchange-users@interchange.redhat.com>
Sent: Tuesday, September 18, 2001 11:44 AM
Subject: Re: [ic] Adding fields using mysql


> 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
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>