[ic] Adding fields using mysql

[Zack Johnson]

I tried that one too.  Didn't work either.  I ended up dumping the userdb
from another cat and recreated it that way.

Just dropped and restarted.  Again, IC did not create userdb.

Wierd.

Zack
----- Original Message -----
From: "David Bordas" <bordas@jeuxvideo.com>
To: <interchange-users@interchange.redhat.com>
Sent: Tuesday, September 18, 2001 12:20 PM
Subject: Re: [ic] Adding fields using mysql


> put a userde.txt file in the <catroot>/products directory and remove the
> file userdb.sql.
> Then restart IC and it'll create the table as definied in the userdb.txt.
>
>
> I hope it can help.
> ----- Original Message -----
> From: "Zack Johnson" <zack@office.standardprinting.net>
> To: <interchange-users@interchange.redhat.com>
> Sent: Tuesday, September 18, 2001 6:10 PM
> Subject: Re: [ic] Adding fields using mysql
>
>
> > 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
> > >
> >
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@interchange.redhat.com
> > http://interchange.redhat.com/mailman/listinfo/interchange-users
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>