[ic] Database Table Definitions

[Chad Wittrock]

> -----Original Message-----
> From: interchange-users-admin@interchange.redhat.COM
> [mailto:interchange-users-admin@interchange.redhat.COM]On Behalf Of Ed
> LaFrance
> Sent: Wednesday, October 17, 2001 1:23 PM
> To: interchange-users@interchange.redhat.COM
> Subject: Re: [ic] Database Table Definitions
>
>
> At 12:54 PM 10/17/2001 -0500, you wrote:
> >I am trying to find the database definitions. I have found many
> of the files
> >associated with the database, but I want to find the actual file
> that states
> >the column names, data type, indexes, etc. Can someone tell me
> where to find
> >these for each table. I have come across some for certain tables, for
> >example products
> >(/var/lib/interchange/mycatalog/dbconf/oracle/products.ora). But
> I have not
> >found a file like this for every table, for example 2ndDayAir.
> Do I need to
> >look somewhere else or is this all the definitions? I am attempting to
> >recreate the tables that were made with the default db in oracle
> so that I
> >can use oracle as my backend db.
> >
> >Running IC 4.6 on RH 7.1.
> >
> >Thanks in advance.
> >Chad
>
> Did you read this section of the docs?
> http://interchange.redhat.com/cgi-bin/ic/dev-4.8/icfoundation_13.html
>

This states the tables and column names, which is very helpful. But, I need
the files that specify the data types of each column, any indexes that were
made, and primary keys. I am sure I could probably make up my own, but I
already have this working with the default tables that were setup during
makecat for the default db. I would like to move this over to Oracle tables
so I need to set up the tables the same way, as I have data in the existing
tables. Is there a place that lists the data types, indexes, etc? Like I
said I found a few like:
/var/lib/interchange/mycatalog/dbconf/oracle/products.ora. But, there is not
one of these files for every table listed at this link you gave me. Can
someone explain/help me with this?

Chad

> - Ed L.
>
> ===============================================================
> New Media E.M.S.               Software Solutions for Business
> 463 Main St., Suite D          eCommerce | Consulting | Hosting
> Placerville, CA  95667         edl@newmediaems.com
> (530) 622-9421                 http://www.newmediaems.com
> (866) 519-4680 Toll-Free       (530) 622-9426 Fax
> ===============================================================
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>