[imp] oracle_create script

[Henry Blackman]

MySQL doesn't have foreign keys which would maintain referential integrity;
pity, but I can't complain, it serves me well.

Although those things may not be necessary for Oracle, they are probably
worth having anyway.

Henry

----- Original Message -----
From: "Hanser, Kevin" <kevin@ShopsForMe.com>
To: <imp@lists.horde.org>
Sent: Thursday, October 12, 2000 4:26 PM
Subject: RE: [imp] oracle_create script


> Hmmm... interesting.  You're right, I left those out.  I was working
> primarily off the mysql_create.sql script, since I knew other people were
> using that script successfully w/IMP.  And the mysql_create.sql script
> didn't have these constraints... does anybody know why?  Why would these
be
> needed w/oracle but not w/other sql databases?  Or are these type of
> constraints not supported and/or not neccessary with MySQL?  (I know most
of
> nothing about MySQL, and only slightly more about oracle :)
>
> Thanx
>
> Kevin
>
> -----Original Message-----
> From: Hernan Morales [mailto:hernanm@la14.com]
> Sent: Thursday, October 12, 2000 11:15 AM
> To: Hanser, Kevin
> Cc: imp
> Subject: RE: [imp] oracle_create script
>
>
> Hi. Mr. Hanser..
>
> The original oracle_create script has any additional statements that you
> didn't
> use. These statements are:
>
> ALTER TABLE IMP_ADDR ADD (
>       CONSTRAINT PK_IMP_ADDR
>       PRIMARY KEY (USERNAME,
>                    ADDRESS)
> );
>
> ALTER TABLE IMP_PREF ADD (
>       CONSTRAINT PK_IMP_PREF
>       PRIMARY KEY (USERNAME)
> );
>
> ALTER TABLE IMP_ADDR ADD (
>       CONSTRAINT FK_PREF_ADDR
>       FOREIGN KEY (USERNAME)
>       REFERENCES  IMP_PREF (
>                    USERNAME)
> )
>
>
> I think it would be important include them in your script because these
> statements are granting the database referential intregrity.
>
> Do you think this might be in the final oracle_create.sql??
>
> Bye..
>
> Hernan Morales
> Servicios Internet
> Almacenes La 14
> Cali - Colombia
> hernanm@la14.com
>
> --
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>
> --
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>
>