[ic] Adding fields using mysql

[David Bordas]

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