[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
RE: [ic] Database Table Definitions
> -----Original Message-----
> From: interchange-users-admin@interchange.redhat.COM
> [mailto:interchange-users-admin@interchange.redhat.COM]On Behalf Of
> Matthew T. Snyder
> Sent: Thursday, October 18, 2001 3:14 PM
> To: interchange-users@interchange.redhat.COM
> Subject: RE: [ic] Database Table Definitions
>
>
> <snip>
>
> > 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
>
> Most of those files can be found under the CATROOT/dbconf directory. I'm
> not familiar with oracle, so I'm not certain exactly how those
> files are set
> up - I've never looked. However, patrick was right in his
> earlier post, as
> far as I know... if it's a .dbm file extension, it doesn't show up in the
> database (at least not under MySQL or PostgreSQL), although it might be
> possible to change things so it does.
>
> The following is a snippet of what I see within my CATROOT/dbconf/oracle
> (and looks almost identical to products.mysql):
>
> <snip>
> Database products DEFAULT_TYPE VARCHAR2(128)
> Database products KEY sku
> Database products COLUMN_DEF "sku=VARCHAR2(64) PRIMARY KEY"
> Database products COLUMN_DEF "description=VARCHAR2(128)"
> Database products COLUMN_DEF "title=VARCHAR2(128) DEFAULT ''"
> Database products INDEX title
> Database products COLUMN_DEF "template_page=VARCHAR2(64)"
> Database products COLUMN_DEF "comment=VARCHAR2(2000)"
> Database products COLUMN_DEF "thumb=VARCHAR2(128)"
> Database products COLUMN_DEF "image=VARCHAR2(64)"
> Database products COLUMN_DEF "price=DECIMAL(12,2)"
> Database products INDEX price
> Database products COLUMN_DEF "category=VARCHAR2(64)"
> Database products INDEX category
> Database products INDEX prod_group
> Database products COLUMN_DEF "nontaxable=VARCHAR2(3)"
> Database products COLUMN_DEF "weight=VARCHAR2(12) DEFAULT '0'"
> Database products COLUMN_DEF "size=VARCHAR2(96)"
> Database products COLUMN_DEF "color=VARCHAR2(96)"
> Database products COLUMN_DEF "gift_cert=VARCHAR2(3)"
> Database products COLUMN_DEF "related=VARCHAR2(2000)"
> Database products COLUMN_DEF "featured=VARCHAR2(32)"
> Database products NUMERIC price
>
> I think that you'll find a quick more or less on those files with a .ora
> extension will answer most of those questions :)
>
Thanks for everyones input. I will try this and see where it gets me.
Chad
> _______________________________________________
> 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