[ic] TIPS: Adding a new mysql table to IC

[Zack Johnson]

Doug,

I don't know enough to address the auto *creation* of tables.  In my
instructions, the user is left to create the table manually, with whatever
tool they like (e.g., mysql client, phpmyadmin, etc.).  I simply find it
easiest to create the table from the textfile created in step 1.

IC will recognize the table with a <table>.txt, if created manually.
However, your comments may well address the case where you want IC to create
the table.  I will gladly defer to the experts on this matter.  Let me know
if I should add 2b.

Thanks for the compliments!

Zack

----- Original Message -----
From: "Doug Alcorn" <lathi@seapine.com>
To: <interchange-users@anthrax.interchange.redhat.com>
Sent: Wednesday, September 26, 2001 10:47 AM
Subject: Re: [ic] TIPS: Adding a new mysql table to IC


>
> "Zack Johnson" <zack@office.standardprinting.net> writes:
>
> > 6.  Restart IC.  Your table should now appear under Administration >
> > Tables.
>
> Haven't we forgotten a step here.  Maybe IC 4.8 has changed in this
> respect (I still haven't upgraded yet).  But I though you had to
> create <catroot>/products/foo.txt before IC would pick up the new
> table.  Most specifically, I thought you needed all the column headers
> in the foo.txt file:
>
> $ cat > <catroot>/products/foo.txt
> id<tab>name<tab>atomic_number
> <ctrl-d>
>
> I thought it was _this_ text file and not the one over in
> <catroot>/dbconf/mysql/foo.txt that IC used to create tables from.  I
> thought just the column definitions came from the dbconf file.
>
>
> Other than that, a very nice write-up.  Probably the best HOWTO on the
> subject yet.
> --
>  (__) Doug Alcorn (mailto:doug@lathi.net http://www.lathi.net)
>  oo / PGP 02B3 1E26 BCF2 9AAF 93F1  61D7 450C B264 3E63 D543
>  |_/  If you're a capitalist and you have the best goods and they're
>       free, you don't have to proselytize, you just have to wait.
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>